aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
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
2014-10-19Core/NetworkIO: *Fixed basic auth packetsSovak
Fixed basic character packets Nulled all opcodes Thanks to @Shauren for pointing some derps out Signed-off-by: Sovak <sovak007@gmail.com>
2014-10-19Merge remote-tracking branch 'origin/4.3.4' into 6.xDDuarte
2014-10-19Merge remote-tracking branch 'origin/3.3.5' into 4.3.4DDuarte
Conflicts: sql/base/auth_database.sql src/server/game/Instances/InstanceScript.h src/server/scripts/Northrend/isle_of_conquest.cpp src/server/shared/Database/Implementation/LoginDatabase.cpp src/server/shared/Database/Implementation/LoginDatabase.h
2014-10-18Scripts/Commands: Implement mutehistory command for GM's with requested ↵Heihachi
improvements Closes #13350
2014-10-18Scripts/Commands: Implement commands to set and get boss states during run timeNyeriah
Closes #13186
2014-10-18Core/Quest: implement Quest TrackerShinDarth
2014-10-18Merge branch '4.3.4' of https://github.com/TrinityCore/TrinityCore into 6.xShauren
Conflicts: dep/PackageList.txt src/server/bnetserver/Packets/WoWRealmPackets.cpp src/server/bnetserver/Server/Session.cpp
2014-10-13Battle.net: Implemented cache stream itemsShauren
2014-10-04Core/Authserver: Updated battle.net structures to 6.0.2.18973Shauren