aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
2024-10-03Core/Players: Prevent creation of characters with duplicate namesShauren
Closes #30299 (cherry picked from commit 49ab2bbe3883749594fe92a752e1d618c625d1b6)
2024-09-26DB: Remove unsigned floats and recreate views with utf8mb4 in auth databaseShauren
2024-08-30Core/Client Builds: Sync build_info structure with master branchShauren
2024-08-17TDB 335.24081 - 2024/08/17TDB335.24081TDB Release
2024-04-10TDB 335.24041 - 2024/04/10TDB335.24041TDB Release
2024-02-05DB/Channels: Allow name to be accent-sensitive (#29668)Gildor
2024-01-21TDB 335.24011 - 2024/01/21TDB335.24011TDB Release
2024-01-06DB/RBAC: Link RBAC_PERM_IGNORE_IDLE_CONNECTION to correct root permission.r4dish
2024-01-06Scripts/Commands: Implemented .bg start and .bg stop commands.r4dish
2024-01-06Core/Misc: Add permission that allows player to be AFK on the battleground.r4dish
2024-01-06Core/RBAC: Add permission that prevents getting a battleground deserter debuff.r4dish
2023-12-02Core/Calendar: Implement different timezone support for ingame calendarShauren
Closes #8390 Closes #29427 (cherry picked from commit b888b1b09f71a8b8b4a9d45c804a1f164fb65ac3)
2023-09-10DB: Allow reserved_name to be accent-sensitiveKitzunu
Closes #29310
2023-06-14TDB 335.23061 - 2023/06/14TDB335.23061TDB Release
2023-05-19DB: Fixed player name uniqueness checksShauren
(cherry picked from commit 40361a95dadb7bd6e760d684a23ba19e544ca40f)
2023-05-07CircleCI build fix (#28962)CraftedRO
2023-05-05DB/Command: Fix reload textAokromes
2023-02-05DB: Convert all databases to InnoDB engineShauren
2023-02-05DB: Convert databases to utf8mb4Shauren
2023-01-16TDB 335.23011 - 2023/01/16TDB335.23011TDB Release
2022-10-17TDB 335.22101 - 2022/10/17TDB335.22101TDB Release
2022-08-15TDB 335.22081 - 2022/08/15TDB335.22081TDB Release
2022-06-01TDB 335.22061 - 2022/06/01TDB335.22061TDB Release
2022-04-14TDB 335.22041 - 2022/04/14TDB335.22041TDB Release
2022-02-16TDB 335.22021 - 2022/02/16TDB335.22021TDB Release
2022-01-15TDB 335.22011 - 2022/01/15TDB335.22011TDB Release
2022-01-01DB: Sync structure of a shared auth table between branchesShauren
2021-12-16TDB 335.21121 - 2021/12/16TDB335.21121TDB Release
2021-11-15TDB 335.21111 - 2021/11/15TDB335.21111TDB Release
2021-10-15TDB 335.21101 - 2021/10/15TDB335.21101TDB Release
2021-09-28TDB 335.21091 - 2021/09/28TDB335.21091TDB Release
2021-08-15TDB 335.21081 - 2021/08/15TDB335.21081TDB Release
2021-08-14Scripts/Commands: Convert rbac commands to new systemCarbenium
Note: To enable rbac commands for administrators permissions 202-206 have to be linked to permission 196. Sample SQL for auth DB: INSERT INTO `rbac_linked_permissions` VALUES (196, 202), (196, 203), (196, 204), (196, 205), (196, 206);
2021-07-18[Exploit/Dupe] Container item (#26689)robinsch
* Core/Item: Fixed possible dupe with container items containing non unique non stackable items * Fixed build * Update sql script and related base structure Co-authored-by: jackpoz <giacomopoz@gmail.com>
2021-07-15TDB 335.21071 - 2021/07/15TDB335.21071TDB Release
2021-06-20SQL: Update auth_database.sql with latest updatesjackpoz
2021-06-15TDB 335.21061 - 2021/06/15TDB335.21061TDB Release
2021-05-14TDB 335.21051 - 2021/05/14TDB335.21051TDB Release
2021-04-16TDB 335.21041 - 2021/04/16TDB335.21041TDB Release
2021-03-15TDB 335.21031 - 2021/03/15TDB335.21031TDB Release
2021-02-15TDB 335.21021 - 2021/02/15TDB335.21021TDB Release
2021-01-15TDB 335.21011 - 2021/01/15TDB335.21011TDB Release
2021-01-03SQL: Fix auth db db structurejackpoz
2021-01-03Core/Commands: Add .reload vehicle_templateShauren
(cherry picked from commit 4ca15ec065289e12ce95962b3afd89445e141a97) # Conflicts: # sql/base/auth_database.sql # src/server/game/Accounts/RBAC.h
2020-12-15TDB 335.20121 - 2020/12/15TDB335.20121TDB Release
2020-11-16TDB 335.20111 - 2020/11/16TDB335.20111TDB Release
2020-10-15TDB 335.20101 - 2020/10/15TDB335.20101TDB Release
2020-09-27Core/Auction House: Eliminate blocking db queries for account permissions ↵Shauren
when expiring auctions that have offline bidders
2020-09-17Script/Commands: Add ".pdump copy" command (#25455)Giacomo Pozzoni
* Script/Commands: Add ".pdump copy" command Syntax: .pdump copy $playerNameOrGUID $account [$newname] [$newguid] Copy character with name/guid $playerNameOrGUID into character list of $account with $newname, with first free or $newguid guid. * Add missing return * Restore eof check * Fix sql * Use forward declaration header Co-authored-by: Shauren <shauren.trinity@gmail.com> * Remove buffer when reading a line * Rename sql files Co-authored-by: Shauren <shauren.trinity@gmail.com>
2020-09-15TDB 335.20091 - 2020/09/15TDB335.20091TDB Release