aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
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-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-28Rename SQL after mergeDDuarte
Also removed tabs
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-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-08Core/Support: Drop parts of the support system since Blizz switched to a ↵Carbenium
browser based ticket system
2015-05-22Core/Garrisons: Implemented follower class/spec abilities and saving them to ↵Shauren
database
2015-05-08Core/Garrisons: Basics for garrisonsShauren
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/Player: Added character templatesCarbenium
* Characters with predefined levels can be created * Avaiable factions and classes can be configured * Valid values for `factionGroup` in table `character_template_class` are 3 (Alliance) or 5 (Horde) * Added new permission RBAC_PERM_USE_CHARACTER_TEMPLATES - has to be set, to allow the usage of the templates Closes #13952
2015-03-29Core/Phases: updated packet handling to new formatRat
2015-03-24Merge branch '6.x' of https://github.com/TrinityCore/TrinityCore into 6.xRat
Conflicts: src/server/collision/Management/MMapManager.cpp src/server/game/Conditions/ConditionMgr.cpp src/server/game/Conditions/ConditionMgr.h
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-16Core/Phases: Ported new phasing system from 4.3.4 branch and fixed some map ↵Rat
swap logic
2015-03-10Core/Support: Update the support/ticket system to 6.xCarbenium
Core/Mail: fix a logic error introduced in 829e11b6623f967672143d79cd8d31772f54866d
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-13Rename SQLs added in commit bc0c0aeDuarte Duarte
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-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-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-23Core/Items: Updated item stat calculationsShauren
* Implemented item modifiers * Implemented item bonuses
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-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-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-19TDB 335.57 - 2014/10/20TDB335.57DDuarte
2014-10-18Core/Quest: implement Quest TrackerShinDarth
2014-09-21TDB 335.56 - 2014/09/21TDB335.56Vincent-Michael
2014-09-16Merge branch 'ObjectGuid' of https://github.com/TrinityCore/TrinityCoreShauren
Conflicts: src/server/game/Entities/Player/Player.cpp src/server/game/Entities/Player/Player.h src/server/game/Scripting/MapScripts.cpp src/server/scripts/Northrend/Naxxramas/instance_naxxramas.cpp src/server/scripts/Northrend/Nexus/EyeOfEternity/instance_eye_of_eternity.cpp src/server/scripts/Northrend/Nexus/Nexus/boss_anomalus.cpp src/server/scripts/Northrend/Nexus/Nexus/boss_magus_telestra.cpp src/server/scripts/Northrend/Nexus/Oculus/boss_varos.cpp src/server/scripts/Northrend/Ulduar/HallsOfStone/halls_of_stone.cpp src/server/scripts/Northrend/Ulduar/Ulduar/boss_auriaya.cpp src/server/scripts/Northrend/Ulduar/Ulduar/boss_freya.cpp src/server/scripts/Northrend/Ulduar/Ulduar/boss_hodir.cpp src/server/scripts/Northrend/Ulduar/Ulduar/boss_ignis.cpp src/server/scripts/Northrend/Ulduar/Ulduar/boss_razorscale.cpp src/server/scripts/Northrend/UtgardeKeep/UtgardePinnacle/boss_skadi.cpp src/server/scripts/Northrend/UtgardeKeep/UtgardePinnacle/boss_svala.cpp src/server/scripts/Northrend/UtgardeKeep/UtgardePinnacle/boss_ymiron.cpp
2014-09-14Core/Entities: Use ObjectGuid class in game projectShauren
2014-08-28Core/BattleGrounds: store data about BGs victoriesShinDarth
Enable in worldserver.conf Closes #12944 Signed-off-by: DDuarte <dnpd.dd@gmail.com>
2014-07-05TDB 335.54 - 2014/07/05TDB335.54Vincent-Michael
2014-07-01Core/Skills: Use SkillLineAbility.dbc to determine player initial spells - ↵Shauren
skill assignment done in a new table `playercreateinfo_skills` * Removed DK start skill hacks * Resolved missing skills in character skill tab Closes #12311
2014-06-14SQL: Renamed files to match the naming rulesShauren
2014-04-30DB/Seasonal:Vincent-Michael
* Added missing seasonal quest in game_event_seasonal_questrelation table * Remove all event = 0 in character_queststatus_seasonal table
2014-03-29Core/LootShauren
* Master Looter cannot freely loot items under threshold * Update round robin looter only if loot is not empty * Fixed loot bag icon appearing in raid frames when loot method was not Master Looter * Fixed changing loot method reseting current round robin looter