Commit Graph

69 Commits

Author SHA1 Message Date
trickerer
c6ab8cefae Merge branch '3.3.5' into npcbots_3.3.5
# Conflicts:
#	src/common/Common.h
#	src/server/database/Database/Implementation/CharacterDatabase.cpp
#	src/server/database/Database/Implementation/CharacterDatabase.h
#	src/server/game/Entities/Creature/Creature.cpp
#	src/server/game/Entities/Creature/Creature.h
#	src/server/game/Entities/Unit/Unit.cpp
#	src/server/game/Spells/SpellInfo.cpp
#	src/server/scripts/Pet/pet_dk.cpp
2025-08-03 15:38:01 +07:00
Kitzunu
129434bb42 feat(DB): Release ACDB 13.0.0 (#22508) 2025-07-19 13:16:46 +02:00
Kitzunu
f4e049f227 refactor(db-scripts): replace PowerShell database tools with Bash scripts and update documentation (#22372)
* closes https://github.com/azerothcore/azerothcore-wotlk/issues/4343

This pull request replaces the PowerShell implementation of the AzerothCore database export and squash tools with Bash scripts, streamlining the process and improving compatibility. It also updates the documentation to reflect these changes. The most important changes include the creation of new Bash scripts for exporting databases, squashing databases, and updating versions, as well as the removal of the previous PowerShell script and its associated documentation.

### Script Replacement and Enhancements:
* [`apps/DatabaseSquash/DatabaseExporter/DatabaseExporter.sh`](diffhunk://#diff-af0bd252ac095aaad91b842c75b60a689792e6dc9ce88f5e2e4b6f68acf84dcaR1-R69): Introduced a Bash script to replace the PowerShell implementation for exporting database tables, with added features such as formatted SQL output and dynamic directory creation.
* [`apps/DatabaseSquash/DatabaseSquash.sh`](diffhunk://#diff-79ff4f749c045a7d91e9b43aefb5d6fbebdc5fdfb430fbcba329e4d96d71a4fbR1-R52): Added a Bash script to automate the database squash process, integrating the version updater and database exporter tools.
* [`apps/DatabaseSquash/VersionUpdater/VersionUpdater.sh`](diffhunk://#diff-3abc69c645cb80aff30824739e317c9e847e743eeab15ab4825951d10179b265R1-R84): Created a Bash script for automatically updating the version in `acore.json` and generating SQL update files with proper versioning.

### Documentation Updates:
* [`apps/DatabaseSquash/DatabaseExporter/databaseexporter.md`](diffhunk://#diff-b2b291286f2b900a022474f00754ebfe78410780c010d46752335a372d688aefR1-R16): Rewritten documentation to reflect the usage of the new Bash script for database exporting.
* [`apps/DatabaseSquash/VersionUpdater/versionupdater.md`](diffhunk://#diff-f12e21f8a404957c90d9120cf9df0724ff27a7efdb5de0798d974079cfe8adadR1-R10): Added documentation for the new version updater tool, explaining its functionality and usage.
* [`apps/DatabaseSquash/databasesquash.md`](diffhunk://#diff-4a559f6e7404b529714bac65ad22744feb7b9f88343864a20e0a46974233767eR1-R11): Documented the overall database squash tool, detailing its integration of the version updater and database exporter scripts.

### Removal of Legacy Code:
* [`apps/DatabaseExporter/DatabaseExporter.ps1`](diffhunk://#diff-2b4e49f704d88a372b5160c7278839668c81dbecaf52a4edd327873e30b9ae70L1-L234): Removed the PowerShell script for database exporting, along with its associated functionality and settings.
* [`apps/DatabaseExporter/databaseexporter.md`](diffhunk://#diff-0618d62def0d611be6e0d4fc524df6f702f493cb87870d9382402aaf52f484e8L1-L85): Deleted outdated documentation for the PowerShell-based database exporter tool.
2025-06-28 16:17:48 +02:00
trickerer
15e9afd159 Merge branch '3.3.5' into npcbots_3.3.5
# Conflicts:
#	.github/README.md
#	src/server/apps/worldserver/worldserver.conf.dist
#	src/server/game/Battlegrounds/Arena.cpp
#	src/server/game/Battlegrounds/Arena.h
#	src/server/game/Battlegrounds/Zones/BattlegroundAV.cpp
#	src/server/game/Battlegrounds/Zones/BattlegroundEY.cpp
#	src/server/game/Battlegrounds/Zones/BattlegroundWS.cpp
#	src/server/game/Entities/Creature/Creature.cpp
#	src/server/game/Entities/Player/Player.cpp
#	src/server/game/Globals/ObjectMgr.h
#	src/server/game/Maps/Map.cpp
#	src/server/game/Server/WorldSession.cpp
2025-04-06 12:26:48 +07:00
sudlud
34bed0651a fix(DB/world): delete base/db_world/player_classlevelstats.sql (#21329) 2025-02-05 15:47:18 +01:00
trickerer
7e91ab78e6 Merge branch '3.3.5' into npcbots_3.3.5
# Conflicts:
#	src/server/game/Server/WorldSession.cpp
2024-12-21 07:43:37 +07:00
sudlud
abbd552ce5 feat(DB): Release ACDB 12.0.1 (#20954) 2024-12-18 06:07:03 +01:00
Kitzunu
3a20433827 feat(DB): New DB exporter and versioning tools for DB squashes (#20920) 2024-12-16 16:13:05 +01:00
Kitzunu
7732e1a5b2 feat(DB): Release ACDB 12.0.0 (#20921) 2024-12-15 14:35:42 +01:00
trickerer
d719c662fc Merge branch '3.3.5' into npcbots_3.3.5 2024-11-16 06:49:57 +07:00
Francesco Borzì
c5ae1ae88f chore(DB): move 2023 update files (#20470)
* chore(DB): move 2023 update files

* chore: flag files as archied
2024-11-15 11:27:45 +01:00
Github Actions
286ad3c8f8 Merge 3.3.5 to npcbots_3.3.5 2024-07-19 21:27:19 +00:00
Kitzunu
3831557dfe docs(DB): Database Squash (#19415) 2024-07-18 19:34:32 +02:00
Kitzunu
d26a2cac52 fix(DB): Correct collation for c_t_model (#19428) 2024-07-18 12:47:48 -03:00
Kitzunu
3e88bd8668 feat(DB): Release ACDB 11.0.0 (#19414) 2024-07-17 01:07:46 +02:00
trickerer
4ef3ff79c2 Merge branch '3.3.5' into npcbots_3.3.5 2024-02-10 14:58:59 +07:00
Kitzunu
fa8a9d65c8 fix(DB): Collation error (#18204)
* fix(DB): Collation error

* closes https://github.com/azerothcore/azerothcore-wotlk/issues/18202

* Update 2024_01_20_06.sql
2024-01-20 21:23:45 -03:00
Kitzunu
7f7f18e489 feat(DB): Release ACDB 10.0.0 (#18197)
* move archived files into old dir

* auth

* characters

* world

* mistake

* revert some stuff

* Squash time!

* newline
2024-01-20 17:17:44 +01:00
trickerer
e892898632 Merge branch '3.3.5' into npcbots_3.3.5 2023-06-03 07:50:55 +07:00
Kitzunu
5e326789ac fix(DB/Character): Allow names to be accent senstive (#16344)
* fix(DB/Character): Allow names to be accent senstive

* closes https://github.com/azerothcore/azerothcore-wotlk/issues/16314

* Cherry-pick commit (fb388298a0)

Co-authored-by: Shauren <shauren.trinity@gmail.com>
2023-05-23 16:16:00 +02:00
trickerer
1ca207daf1 NPCBots: Fix trailing spaces in base sqls, Fix build 2023-05-09 09:35:41 +07:00
trickerer
896e1044ee Merge branch '3.3.5' into npcbots_3.3.5 2023-04-29 07:15:45 +07:00
Gultask
5ca6fe6fda feat(DB): Release ACDB 9.0.0 (#16069)
* squishy
2023-04-25 01:48:38 -03:00
trickerer
eb36cbb42c Merge branch '3.3.5' into npcbots_3.3.5 2023-02-18 08:51:19 +07:00
Gultask
21c2e7d3e5 fix(DB): Separate INSERTs from base sql into smaller sections part 2 (#14938) 2023-02-11 00:00:56 -03:00
trickerer
68e1efe8d4 Merge branch '3.3.5' into npcbots_3.3.5 2023-02-11 08:50:50 +07:00
Gultask
542a1e206f fix(DB): Separate INSERTs from base sql into smaller sections (#14881) 2023-02-08 14:03:22 -03:00
trickerer
f5317aa902 Merge branch '3.3.5' into npcbots_3.3.5 2023-02-04 07:59:43 +07:00
Revision
c3dd1b7a5c fix(DB): MariaDB Imports (#14841) 2023-02-01 10:11:28 -03:00
Gultask
785bb5ed6b feat(DB): release ACDB 8.0.0 (#14833) 2023-02-01 01:56:25 +01:00
trickerer
a0ad70697c NPCBots: recompile sql files to fit into AC DB autopopulate scheme 2022-12-03 14:58:14 +07:00
M'Dic
e0b7c7d0d3 fix(sql): Squash fix for mariadb (#12830)
Update log_money.sql
2022-08-23 17:48:14 +02:00
Kitzunu
3daa8e2146 feat(DB): release ACDB 7.0.0 (#12811)
* feat(DB): release ACDB 7.0.0

* cleanup

* we try sourcery
2022-08-21 12:31:37 +02:00
Kitzunu
62f6513c9a fix(DB): Weird leftover (#11518) 2022-04-24 16:08:33 +02:00
Kitzunu
b4bcdd94d1 feat(DB): release ACDB 6.0.0 (#11515) 2022-04-24 15:56:31 +02:00
Walter Pagani
35d58463bf feat(DB/Account): Delete auto increment in account table (#10879) 2022-03-03 05:09:08 +07:00
Kitzunu
3501ceb710 refactor(Core/DB/playercreateinfo_spell_custom): Load empty (#10595) 2022-02-14 20:21:56 +01:00
Kargatum
a689775891 feat(DB): release ACDB 5.0.0 (#10292)
* auth

* char

* world

* archive

* new files

* v

* correct auth db

* add support get last file from archive

* correct world updates

* fix auth

* pendinig to normal

* add pending auth

* add pendings

* smallint

* MEDIUMINT
2022-01-29 10:35:10 -03:00
Kargatum
43ebc5f24a feat(DB): release ACDB 4.0.0 (#8494)
***ATTENTION***
- To avoid mistakes need to update the core to 9e3949232c to add support correct archive dir and after can merge to actual commit
2021-10-20 04:31:19 +07:00
Kargatum
2d2857ce81 feat(Core/DBUpdater): implement db auto update (#6576)
* feat(Core/DBUpdater): implement db auto update

* 1

* 2

* 3

* Some minor improvements

* add find bin for mysql 8.0

* lic

Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com>
2021-06-27 18:59:44 +02:00
Kargatum
3da83cc0e6 feat(Common/IPLocation): replace ip2nation by ip2location (#5653) 2021-06-17 22:02:08 +02:00
Kitzunu
0a12aed4bb fix(DB/Account): Remove default accounts (#5292) 2021-04-15 11:17:14 +02:00
Kitzunu
e0d36be56e refactor(DB/SQL): Update integer & utf to MySQL's new standards (#4929) 2021-03-24 15:50:06 +01:00
Francesco Borzì
49712bd12f release: DB squash & begin AC 4.0.0 development (#4341) 2021-01-25 19:51:22 +01:00
Viste
fa57954ff9 fix(DB): error on default MySQL install (#2776) 2020-03-24 23:06:53 +01:00
Francesco Borzì
caf955dd78 fix(DB): update chain after release 2019-02-17 14:56:23 +01:00
Francesco Borzì
0858526c9a DB squash & begin AC 3.0.0 development 2019-02-17 14:25:53 +01:00
Francesco Borzì
f960d8e848 fix(setup): MySQL 5.7 (#1445) 2019-02-16 20:04:26 +01:00
Barbz
fa65a8070a DB/Characters: Remove unused tables "uptime" and "cheaters" (#1000)
* DB/Characters: Remove unused tables "uptime" and "cheaters"
2018-09-03 22:40:38 +02:00
barncastle
2c9b2542d6 Implement banned_addons (#647) 2017-09-17 17:13:43 +02:00