aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
2015-09-05Core: Updated to 6.2.2.20444.Shauren
* This includes all known packet structures, nothing has been disabled. * worldserver still expects 6.2.0 DBC/DB2 files - do not reextract
2015-08-26Core/Player: implemented ToyboxMitchesD
* now you can use all the things in toybox - add new toys, set them as favorite and use them
2015-08-22DB/Updater: fix characters updates listShinDarth
2015-08-12Core/Void Storage: Implemented saving item upgrade and bonuses for items ↵Shauren
deposited in void storage
2015-08-08SQL: Added missing sql in d8b36dfc173fb66248cf86d1723ee7343c3cfc9fVincent-Michael
2015-07-31DB/Base: Fix update table of character base after 83c2d36179a6Naios
* Never forget to update the `updates` table of the base dump after changes too. * closes #15198
2015-07-29DB/BattleNet: Update wow build to 20338Vincent-Michael
2015-07-28Core/PacketIO: CalendarPackets:Golrag
CMSG_CALENDAR_GET CMSG_CALENDAR_GET_EVENT CMSG_CALENDAR_GUILD_FILTER CMSG_CALENDAR_ADD_EVENT CMSG_CALENDAR_UPDATE_EVENT CMSG_CALENDAR_REMOVE_EVENT CMSG_CALENDAR_COPY_EVENT CMSG_CALENDAR_GET_NUM_PENDING CMSG_CALENDAR_EVENT_SIGN_UP CMSG_CALENDAR_REMOVE_INVITE CMSG_CALENDAR_EVENT_STATUS CMSG_SET_SAVED_INSTANCE_EXTEND CMSG_CALENDAR_EVENT_MODERATOR_STATUS SMSG_CALENDAR_EVENT_INVITE SMSG_CALENDAR_SEND_CALENDAR SMSG_CALENDAR_SEND_EVENT SMSG_CALENDAR_EVENT_INVITE_ALERT SMSG_CALENDAR_EVENT_INVITE_STATUS SMSG_CALENDAR_EVENT_INVITE_REMOVED SMSG_CALENDAR_EVENT_INVITE_MODERATOR_STATUS SMSG_CALENDAR_EVENT_INVITE_REMOVED_ALERT SMSG_CALENDAR_CLEAR_PENDING_ACTION SMSG_CALENDAR_EVENT_UPDATED_ALERT SMSG_CALENDAR_EVENT_REMOVED_ALERT SMSG_CALENDAR_SEND_NUM_PENDING SMSG_CALENDAR_COMMAND_RESULT SMSG_CALENDAR_RAID_LOCKOUT_UPDATED SMSG_CALENDAR_EVENT_INITIAL_INVITES SMSG_CALENDAR_EVENT_INVITE_STATUS_ALERT // NYI SMSG_CALENDAR_EVENT_INVITE_NOTES_ALERT // NYI SMSG_CALENDAR_EVENT_INVITE_NOTES // NYI
2015-07-16DB/BattleNet: Update wow build to 20253Vincent-Michael
2015-07-14TDB 6.0.2 - 2015/07/14TDB6.02DDuarte
2015-07-12Core/Players: Fixed power slot orderingShauren
2015-07-11Core/Players: Fixed glyph slotsShauren
2015-07-10DB/Base: Smth went wrong during the last dump...Carbenium
2015-07-10DB/Base: Update auth and char database dump after recent changes to the ↵Carbenium
ticket system (c7d49ab91074472d821d681266ad0e90b7d8887e)
2015-07-08DB/BattleNet: Update wow build to 20216Vincent-Michael
2015-07-06DB/BattleNet: Update wow build to 20201Vincent-Michael
2015-07-02DB: Updated build data to 20182Shauren
2015-05-22Core/Garrisons: Implemented follower class/spec abilities and saving them to ↵Shauren
database
2015-05-08Core/Garrisons: Basics for garrisonsShauren
2015-05-04Core/Creatures: Extended npcflags to uint64Shauren
2015-05-02SQL: Update characters_databaseVincent-Michael
2015-05-02SQL: Update auth_databaseVincent-Michael
2015-04-28Core/Entities: Reworked guid scopesShauren
* Added ObjectGuid traits to easily access whether guid type can be generated globally (ObjectMgr) or not * This adds separate (per map) guid sequences depending on object type * Ported map object container from cmangos/mangos-wotlk@a2d396eb0bb195efc460944dd4e0fab2a858b300 * Added type container visitor for TypeUnorderedMapContainer * Implemented helper function to erase unique pairs from multimap containers * Moved object storage of all objects except players and transports to map level * Added containers linking database spawn id with creature/gameobject in world * Renamed DBTableGuid to spawnId * Added a separate spawn id sequence generator for creatures and gameobjects - this will be used in db tables * Moved building SMSG_UPDATE_OBJECT - updatefields changes broadcast to map update
2015-04-21Core/Misc: Update base sql files after bba6eb8d3dfe73a02063a7cefe6f465dae69334bCarbenium
* Move some std::list to std::vector
2015-04-11Core/Battle.net: Query optimizations part2 - made all queries asynchronousShauren
2015-04-11Core/Misc:Vincent-Michael
- Drop locales_npc_text - Update npc_text for WoD - Implemented Quest Greeting - Sync auth database
2015-04-06SQL: Update auth_databaseVincent-Michael
2015-04-04Update to 6.1.2 19831Carbenium
2015-03-26Core/Misc: Update base stuff for V6.1.2 build 19802Carbenium
2015-03-21TDB 6.0.1 - 2015/03/21TDB6.01Nayd
Closes #13816 Closes #13792 Ref #14139
2015-03-21Core/Updates: Add an automatic database update system. Automatically detects ↵Naios
new and edited sql updates through file lists and hashing. Detects renames, deletes and is able to create and auto import full databases. * cleanups in main.cpp of world & bnetserver * refactoring in DatabaseWorkerPool.h & MySQLConnection.cpp Make sure you re-run cmake, because boost::iostreams was added as dependency. Maybe you need to install libboost-iostreams1.55-dev on unix as well. Import every update manual until (included) those INSERT IGNORE updates for each database. Thanks DDuarte and Shauren for your amazing ideas, help and advises. In hope that nobody gets a "Your database structure is not up to date..." anymore ,-) Signed-off-by: Naios <naios-dev@live.de> Signed-off-by: Nayd <dnpd.dd@gmail.com>
2015-03-10Core/Support: Update the support/ticket system to 6.xCarbenium
Core/Mail: fix a logic error introduced in 829e11b6623f967672143d79cd8d31772f54866d
2015-03-01Core/Misc: Update base stuff for V6.1.0 build 19702Vincent-Michael
2015-02-22Core/Database: Removed locales_item from world database (use ↵Shauren
item_sparse_locale in hotfixes database)
2015-02-17Core/Spells: Cooldown updatesShauren
* Refactored cooldown handling to separate class shared by creatures and players * Updated and enabled cooldown packets * Implemented creature school lockouts * Implemented spell charges * Fixed AuraUpdate structure * Fixed aura flag AFLAG_NOCASTER handling * Implemented spell charge related auras
2015-02-13Core/Guild: Updated and enabled most previously implemented guild and ↵Mogadischu
petition related packets Merged from https://github.com/Mogadischu/TrinityCore/commits/guild Signed-off-by: Duarte Duarte <dnpd.dd@gmail.com>
2015-02-11DB/Auth: Remove auto_increment value from auth_database.sqlDuarte Duarte
2015-02-05SQL: Make sure the correct world db is select when executing SQL update scriptsjackpoz
Make sure script 2014_12_25_00_hotfixes_locale_broadcast_text.sql affects the correct world database version "TDB 6.00". This fixes an issue where the script would drop table "locales_broadcast_text" from a world database of another version (335, 434). Issue added in df444890daf74e95d51a229f99996561a88ac71a
2015-01-27DB/Schema: Update characters databaseNayd
- Change multiple table's chartset from latin1 to utf8 - Add primary keys to tables that didn't have one - Replaced one unique constraint by primary key
2015-01-16Core/Auras: Fixed saving all aura effect values to databaseShauren
2015-01-10Core/Maps: Updated map difficultiesShauren
2015-01-02Merge pull request #13809 from AriDEV/6.xjoschiwald
Server/PacketIO: Currency Updates
2015-01-02Server/PacketIO: Currency UpdatesAriDEV
* Update SMSG_SET_CURRENCY & SMSG_SETUP_CURRENCY Packets. * Update of Database Structure and SQLStatements for Currencies. Signed-off-by: AriDEV <aridev666@gmail.com>
2014-12-31Core/Achievements: Enabled saving progress and converted old saved dataShauren
2014-12-28SQL: Sync auth baseVincent-Michael
2014-12-28Core/Quests: Updated Quest System to new FormatIntel
All quest requirements are now in quest_objectives table quest_template table contains _ONLY_ WDB data and must not be modified Currently supported objectives are MONSTER, GAMEOBJECT, ITEM, TALKTO, CURRENCY, REPUTATION, MONEY, PLAYERKILLS, AREATRIGGER
2014-12-27Core/RBAC: Add two side trade to RBACmthsena
(cherry-picked from commit 3ee2f0d2bf9d5f859c8022ca49f1889c35584ffe)
2014-12-25Core/DataStores: Moved broadcast_text handling to DB2StorageShauren
2014-12-23Core/Items: Updated item stat calculationsShauren
* Implemented item modifiers * Implemented item bonuses
2014-12-20DB/BattleNet: Update wow build to 19342Vincent-Michael