aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
AgeCommit message (Collapse)Author
2015-10-08Add caster guid to pet_aura table.pete318
This prevents duplicate key and transaction completion fail on pet save, if pet has same aura from two different casters present. This closes (already closed) issue https://github.com/TrinityCore/TrinityCore/issues/10529
2015-10-06Rename SQL after PR mergeDDuarte
2015-10-06Core/Ticket keep always trace of GM who resolves the ticketShinDarth
2015-09-28Auction house changes:pete318
- Stop storing guid for auctioneer. - Store instead house ID - No separate ID for various houses. Only Horde, Alliance and Neutral. - Removed non-needed faction checks. - Use enum for auction house IDs NOTE: This will expire all current auctions and return item to player (or award to high bidder) in order to prepare database for the changes.
2015-09-22Map local guids 6.x -> 3.3.35:pete318
Implemented: https://github.com/TrinityCore/TrinityCore/commit/ca83e14f8b141fab0a13e08f48fca6c1ace0c4c7 https://github.com/TrinityCore/TrinityCore/commit/ee1c1b97be4492ecabe8b15ea6323fc37e4eaa8c https://github.com/TrinityCore/TrinityCore/commit/18e4ab6911468b829b0fc768e532a770263c3717 https://github.com/TrinityCore/TrinityCore/commit/bf37446b3c2ed73b4d3aa9e227d3eff5c53b378b https://github.com/TrinityCore/TrinityCore/commit/cb854a2b7bb7bd96cf9c4d1daf3789f797bf4db8 * This adds separate (per map) guid sequences depending on object type * Ported map object container from cmangos/mangos-wotlk@a2d396e * 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 * Added new function to return but not increment guid * Adjusted .debug loadcells to show low guid in map before/after load * Added debug messages for creature spawn/destroy, for map guid debugging * Store all Gameobjects and Creatures added to OutdoorPvP, so the callback script can be removed when OutdoorPvP instance is destroyed.
2015-07-14TDB 335.59 - 2015/07/14TDB335.59DDuarte
2015-06-26DB/Characters: Backport schema changes from 6.x branch (renames)ShinDarth
Closes #14951
2015-03-21TDB 335.58 - 2015/03/21TDB335.58Nayd
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 ,-) (cherry picked from commit 352012e53173372ebc82898e1b6854c983b01b25) (cherry picked from commit 1f7f9feafc3f5017d617634ae993d2cdf4430920) For 3.3.5: * Synchronized ConfigureBoost.cmake with 6.x, libboost-filesystem1.55-dev also added as dependency! Signed-off-by: Naios <naios-dev@live.de> Signed-off-by: Nayd <dnpd.dd@gmail.com>
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
2014-03-29Merge pull request #11719 from Dehravor/master-lootShauren
Core/Loot: Fix master loot
2014-03-29TDB 335.53 - 2014/03/29TDB335.53Duarte Duarte
2014-03-16Core/Loot: Implement round robin for under threshold items in case of master ↵Dehravor
loot Thanks @Shauren for pointing out
2014-01-12Core/Movement: Add LOS check for fleeingmovement target point.zengwf
Prevents fleeing or feared units from going to upper floor ignoring walls/ceilings with mmaps on(and usually get stucked). Current implementation just randomly selects a distance and angle against the frighting unit, when in narrow circumstance such as underground caves, such targeting point would be at another floor. Closes #11300 Ref #9475 (needs fixed confirmation)
2014-01-12DB/Guild: Fix incorrect input length limitsDehravor
There is one incorrect field length related to guilds in the database, which can be used to cause an overflow client-side, by sending CMSG_GUILD_INFO_TEXT with long strings. The guild information has the same 500 characters client-side limit as the guild bank tab information, but on server-side it can be 65k characters long. A lengthy guild info makes the whole Guild panel unusable. Length of the other fields match the client's limits in the database: guild bank tab name (16), public note (31), officer note (31), motd (128), guild bank tab info (500). Closes #11395 Signed-off-by: DDuarte <dnpd.dd@gmail.com>
2013-07-19SQL: Rename in correct nameVincent-Michael
2013-07-19Core/Misc: Change creatures and gameobject phasemask from 16 to 32 bitsVlad
Signed-off-by: Nay <dnpd.dd@gmail.com>
2013-07-17TDB 335.52 - 2013/07/17TDB335.52Nay
2013-06-25DB/FactionChange: Add missing player_factionchange_spells for Black War Bear ↵Vincent-Michael
/ Black War Mammoth
2013-06-23DB/Misc: Cleaning db of unused/obsolete stuffAokromes
2013-04-05Core/PacketIO: Implemented possibility to ban client addons serversideShauren
2013-03-04Unbreak the build and renamed sql file to proper dateShauren
2013-03-04Core/Players: Implemented converting quests on faction change (keeping old ↵Shauren
faction quests in disabled state - not loaded during login) and restoring them if changing back to original faction Closes #890 Closes #9248
2013-01-13TDB 335.50 - 2013/01/14TDB335.50Nay
2012-12-20SQL: Rename SQL merged in PRVincent_Michael
2012-12-20Merge pull request #8662 from MrSmite/ItemContainer_1.1Subv
Item Loot Saving
2012-12-18Core/Character: Fix logic fail with world state in ↵Vincent_Michael
b2928e59fa8334e91dfa1a5951fade5b574b5842
2012-12-15Implements saving of loot (items / money) contained inside lootable ↵MrSmite
inventory items. * Unlooted items / money persist across player sessions * Loot inside items is tied to the item rather than the player so if trading partially looted items becomes possible, this implementation will still work * New tables added: characters_database.sql (first time users) characters_create_item_loot.sql (existing users) Implementation Can be tested with: Watertight Trunk [21113] Bulging Sack of Gems [25422] Fat Sack of Coins [11937] Closes #2048
2012-12-04Core/Quest: Add support for monthly questsVincent-Michael
Author: svetilo12 Converted and updated by: Subv
2012-11-18Scripts&DB: Nexus - OrmorokGacko
Following improvements: - Spellscript for crystal spikes - Spawn crystal tanglers with spell - Usage of event map - Correct usage of frenzy - Heroic spells - Target selection for crystal tanglers Details for the spell script: There are 4 spells. Each of them spawns the same trigger but in another direction. The trigger gets an aura which triggers the spell which summoned him after 250ms. This time is too long, so it triggers on apply. Don't worry - test ingame first, it's working blizzlike (I watched some videos on YT to find out which is the best amount of time difference between spawn and next summon). Some summon types don't store the spell id which summoned them. The trigger is one of them which are not doing so. So I had to move the line, which stores the spell id in the summon out of the if. This could be done more specific, but it works fine. This improvement is required to find out which spell the aura applied to the summoned trigger has to cast to keep the right direction. Closes #8193 Signed-off-by: Nay <dnpd.dd@gmail.com>
2012-11-18Core/Calendar: Completely rewrite and fix most of the calendar systemhorn
There are still some issues that need to be fixed, for more info see CalendarHandler.cpp TODO part. Some unblizzlike behaviour possible, we don't have a lot of sniffs. Big thanks to @Warpten, he joined my project and helped a lot. IMPORTANT NOTE: Read / append packed time functions in ByteBuffer.h are not correct, they need to be fixed in order to have event times accurate Signed-off-by: Nay <dnpd.dd@gmail.com>
2012-11-07Update characters_database.sql (Missing changes from 58ec4e5319)Spp
2012-11-02Core/Guild: Code RefactorSpp
- Send correct events when modifiying Ranks (Add, modify, delete) - Store money/slots withdraw, not remaining slots. This will update remaining slots/money properly. - Reset daily slots/money withdraw for all members at same time, configurable - Better debug messages
2012-10-17DB: Add gm_tickets changes to base character dbkaelima
2012-10-17Core/Ticket:kaelima
- Fully parse CMSG_GMTICKET_CREATE, use GmTicket::GetChatLog() to access the reporters chat log from this session (unused atm, possible useful to detect chat harassment) - Simplify SMSG_GMTICKET_GETTICKET and fix "category" field (renamed it same as in blizz LUA files) - Store response in DB
2012-10-09allow glyph1 be null like other glyph slotstibbi
2012-09-15TDB 335.49 - 2012/09/15TDB335.49Nay
2012-09-07DB/Schema: Change charset of `characters`Subv
Allows having different characters with names like "Subv" and "Súbv", it was not possible to have two characters with these names at the same time before closes #7679
2012-08-07Core/Players: Improved alcohol handling, weeeeeeeeeeeeeeeeeShauren
Closes #7293
2012-07-13Core/Player: Fix issues with 'ignore this slot' option on equipment manager ↵NNN666
usage