aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
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
2014-12-19Core/Spells: Implemented using dbc spellpower/ap coeffiecients for spellsShauren
2014-12-10Core/RBAC: Allow setting different default security level roles to different ↵Nyeriah
realms (cherry picked from commit c79af3f16f84d0d26bd69b5d06dd8754643ddc7f)
2014-12-05DB/BattleNet: Update wow build to 19243Vincent-Michael
2014-11-25DB/Schema/Auth: Also change `battlenet_accounts`.`os` to varchar(4)Nayd
Ref 59bb9c20f345544310369f3074fd0e716cc8092c
2014-11-23DB/Schema/Auth: Change `account`.`os` to varchar(4)Nayd
Windows and Mac 64 bit clients send "Wn64" and "Mc64", respectively, and that does not fit in a varchar(3)
2014-11-12Core/Talents:Intel
Fixed SMSG_TALENTS_INFO packet Fixed talents saving to DB Renamed 'talent spec' to 'talent group' since this name was shadowing character specializations (and new name is correct according to JAM) Enabled loading of MinorTalent.dbc (will be used later) Added additional specialization check in LearnTalent
2014-11-11Scripts/Commands: mod xp commandHeihachi
Closes #13476 (cherry picked from commit 3e03e546d3106bf8930e30ab9c2008b0e696e125) Conflicts: sql/base/auth_database.sql src/server/scripts/Commands/cs_modify.cpp
2014-11-10Core/Commands: implement .pvpstats commandDDuarte
Shows number of battleground victories in the last 7 days Closes #13460 Conflicts: sql/base/auth_database.sql sql/updates/auth/2014_11_10_00_auth.sql src/server/game/Accounts/RBAC.h (cherry picked from commit fd0b96178174e624510a10f5bc27b60af406d901)
2014-11-10SQL: Update auth_database.sqlDDuarte
It was missing an update to realmlist.gamebuild
2014-11-10Core/Commands: Battle.net account command changesShauren
* All commands renamed from "battlenetaccount" to "bnetaccount" * bnetaccount create now also creates and links initial game account * Added new commands bnetaccount link/unlink to manage relations between existing accounts
2014-11-09SQL: Updated the base build with changes in 2d74ee9141828721Kinzcool
2014-11-04SQL: Updated battlenet_components to current buildShauren
2014-11-03Core/NetworkIO: implemented undelete opcodes and moved char create/delete ↵joschiwald
packets to new packet classes
2014-10-27SQL: Revert changes to dev/world_database.sqlDDuarte
This file should only be updated in TDB releases. Fixes Travis 'build'
2014-10-26SQL: Changed creature_template.family to be unsignedShauren
2014-10-26Misc: Fixed sql import, added new changes to world_database.sql, removed ↵Shauren
duplicate definition of ObjectGuidGenerator<HIGHGUID_PET>
2014-10-26Core/Entities: Changed object lowguid to uint64Shauren
2014-10-25Fixed SQL typo in characters_database.sqlmarc0303
2014-10-25Core/Guilds: Fifth part of converting int to bigint guids in databaseShauren
2014-10-24Core/Entities: Fourth part of converting int to bigint guids in databaseShauren
2014-10-23Core/Entities: Third part of converting int to bigint guids in databaseShauren
2014-10-23Core/Entities: Second part of required database changes for migrating guids ↵Shauren
to 128 bit - all fields storing lowguid must be extended to uint64
2014-10-23Core/Entities: First step to 128 bit guidsShauren
* Database fields storing full guid have been converted to BINARY(16)
2014-10-20Core/Entities: First part of required database changes for migrating guids ↵Shauren
to 128 bit - all fields storing lowguid must be extended to uint64
2014-10-20Merge pull request #13361 from Sovak/602Shauren
Core/NetworkIO: *Fixed basic auth packets
2014-10-20DB: Move hotfixes_database.sql to the /dev folder (just like world)DDuarte
2014-10-19DB: Create hotfixes_database.sql file and update .travis.yml to import hotfixesDDuarte
Note: hotfixes_database.sql will be empty until the next TDB release And here's a friendly reminder that trinity now uses 4 DBs: characters, auth, world and hotfixes