aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
AgeCommit message (Collapse)Author
2020-03-16TDB 335.20031 - 2020/03/16TDB335.20031TDB Release
2020-02-15TDB 335.20021 - 2020/02/15TDB335.20021TDB Release
2020-01-15TDB 335.20011 - 2020/01/15TDB335.20011TDB Release
2019-12-15TDB 335.19121 - 2019/12/15TDB335.19121TDB Release
2019-11-16TDB 335.19111 - 2019/11/16TDB335.19111TDB Release
2019-10-18TDB 335.19101 - 2019/10/18TDB335.19101TDB Release
2019-09-15TDB 335.19091 - 2019/09/15TDB335.19091TDB Release
2019-08-16TDB 335.19081 - 2019/08/16TDB335.19081TDB Release
2019-07-16Core/DB: Add a world state for daily quest reset time to `characters`. Not ↵Treeston
used right now, but written to allow easier transition later.
2019-07-15Core/Addons: Improve WorldSession::ReadAddonsInfoShauren
* Only allow built-in addons to be marked as secure * Better protect against malformed packets
2019-07-15TDB 335.19071 - 2019/07/15TDB335.19071TDB Release
2019-07-14Core/DB: Unify `creature_respawn` and `gameobject_respawn` into a single ↵Treeston
`respawn` table
2019-06-15TDB 335.19061 - 2019/06/15TDB335.19061TDB Release
2019-05-15TDB 335.19051 - 2019/05/15TDB335.19051TDB Release
2019-04-15TDB 335.19041 - 2019/04/15TDB335.19041TDB Release
2019-03-19TDB 335.19031 - 2019/03/19TDB335.19031TDB Release
2018-11-09Core/Auras: Fixed saving auras with same spell id but different item sourceShauren
2018-07-09Core/Players: Fixed saving quest item progressShauren
2018-04-24Rename 9999_99_99_99_characters.sql to 2018_04_24_00_characters.sqlAokromes
2018-04-24Core/Battleground: Fix arena distribution timer where it is less than the ↵Gooyeth
current unix time. (#21859) * Core/Battleground: Fix arena distribution timer where it is less than the current unix time. * fix bracket * fix when the timer starts for the first time. * m_NextAutoDistributionTime instead of GetGameTime.
2018-04-03Delete 9999_99_99_99_characters.sqlGooyeth
2018-04-03improved fixGooyeth
2018-04-03Core/Spells: don't save Magma aura.Gooyeth
2018-02-18TDB 335.64 - 2018/02/18TDB335.64DDuarte
2018-01-13Core/Auras: removed caster dependency from coreariel-
- Decoupled Unit logic: split of spell critical chance into done (caster bonuses) and taken (target bonuses), this allows to precalculate caster bonuses on aura apply and then check victim's auras on damage/healing calc - Made static a bunch of methods (they no longer have this pointer because they are now called from periodic handlers which may or may not have an active caster in world) - Simplified all AuraEffect bonuses into AuraEffect::_amount, no more duplicated code - Critical chance and whether or not caster is player owned unit (for resilience calcs) is now saved one level upper, on Aura itself (it's impossible as of 3.3.5 to have different effects with different critical chances) - Minor cleanup of SPELL_DAMAGE_CLASS_NONE and Arcane Potency (#18813) crit handling Closes #19876
2017-11-27[3.3.5] Core/AuctionHouse: Auction bidders (#18328)iridinite
* Save more auction bidders than the highest bidder only
2017-10-29Rename sql/updates/characters/master/2017_10_29_00_characters.sql to ↵Aokromes
sql/updates/characters/3.3.5/2017_10_29_00_characters.sql
2017-10-29Core/Taxi: Apply reputation discount to all points in multi-segment pathsShauren
(cherry picked from commit 99f5d0614964041686083d497e7b8ccd572536b6)
2017-04-19TDB 335.63 - 2017/04/18TDB335.63DDuarte
2017-04-12Core/Instance: stop updating the instance resettimes based on creature respawnsariel-
- Rather update normal instance reset time to 2 hours after last creature kill - This fixes yet another integer overflow due to the possibility of having time_t max showing up - Also change respawntime and resettime fields to bigint on respawn/instance related tables - Start using prepared statements on the InstanceSaveMgr
2017-04-11Core/Loot: implement Loot Item Storage (#19018)xinef1
* Created Item Loot Storage, no more synchronous DB selects * Fixed buyback case, where stored loot was not removed from db * Added Primary key, and changed field types to be unsigned for table item_loot_money
2017-04-03DB/Schema: add unsigned to some guid fields in charactersariel-
2016-10-30Core/Auras: don't save auras casted by itemsariel-
- Drop useless field from DB (itemGuid was being saved, but never used, see Prepared Statements) - This type of auras (like Water Bucket, Precious Ribbon, etc) will be recasted on login anyways. This reverts commit 16cfd59f5b368fd1d05eeeab3afbacfccf0a6870
2016-10-16TDB 335.62 - 2016/10/17TDB335.62DDuarte
2016-09-13Core/Fishing: implement retail-like fishing skill-up functionality (#17528)SnapperRy
2016-04-16SQLs: Update to the /sql/updates organizationDDuarte
Update SQL files should now be in a sub-folder equal to the current branch name /sql/updates/auth/*.sql -> /sql/updates/auth/3.3.5/*.sql /sql/updates/characters/*.sql -> /sql/updates/characters/3.3.5/*.sql /sql/updates/world/*.sql -> /sql/updates/world/3.3.5/*.sql This facilitates merges between the version branches
2016-04-11TDB 335.61 - 2016/04/11TDB335.61DDuarte
2016-03-13Core/Players: Split playerBytes fields in characters tableShauren
(cherry picked from commit 2a6f65fddcdbe074ace6cd08ab27ec73a64ffe76)
2016-02-10Merge branch '3.3.5-instanceextend' into 3.3.5 (PR #16392)treeston
2016-02-10Maps/Instances: Implement handling of CMSG_SET_SAVED_INSTANCE_EXTENDtreeston
2015-11-07TDB 335.60 - 2015/11/07TDB335.60Carbenium
2015-11-03Core/Ticket improved ticket systemShinDarth
- Safely close ticket before character deletion - Allow to keep trace of delete characters tickets (configurable) - Closes #15655 Closes #15699
2015-10-29Core/Spells: Improved spell category cooldown handlingShauren
* Category cooldown is stored with the spell that started the cooldown (and only resetting cooldown on that spell will clear cooldowns on entire category - this fully mirrors client behavior) * This significantly reduces the amount of data saved to database for cooldowns * Spell casts from items that have a different category specified than on spell will now check for cooldown during the cast (cherry picked from commit 1efb3f08e278530f59d681f676b031a7fc6db3ac) Closes #15766 Closes #15137 Closes #14837
2015-10-28Core/Battleground: implement deserters tracker featureShinDarth
2015-10-12Core/BG fix .character changefaction pvpstats victories amountShinDarth
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.