aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
AgeCommit message (Collapse)Author
2012-06-07Core/Maps: Moved object respawn time storage from global to map level. This ↵Shauren
removes unneccessary locking since all objects run within its map's thread.
2012-05-19TDB 335.11.47 - 2012/05/19TDB335.11.47Nay
2012-04-07Core/Tickets: Add report time and current latency to lag_reports tableNay
It's a tiny bit more useful now.
2012-03-28Partially revert a36a0a77ef75e66933ac5b8802a9ec7906acfd0b.click
Cleaning databases for old/deprecated and expired quests should never be a developers choice specifically. This should be done by admins, not developers, through the use of the already existing paramters found in the worldserver config : CleanCharacterDB / PersistentCharacterCleanFlags An adjustment to the respective questloader prepared statement has been done to accomodate for the earlier change (by not loading such quests into memory at all). Documentation for how this cleanup-procedures work already exists in the core : doc/CharacterDBCleanup.txt.
2012-03-01Core/Player: Quests with status QUEST_STATUS_NONE(0) shouldn't be loaded ↵Machiavelli
into player's queststatus storage. These should be removed since they are remnants from the old queststatus storage system.
2012-02-26Add a missing semicolon (;) to a SQL.Anubisss
Signed-off-by: Anubisss <anubisss210@gmail.com>
2012-02-19Core/Warden: Base implementation for Warden functionalityleak
Note: The default config file action for clients failing the checks can be changed for each check via the characters.warden_action table Credits to TOM_RUS
2012-02-12TDB 335.11.46 - 2012/02/13TDB335.11.46Nay
2012-01-26fix seasonal quest checkKandera
2012-01-14Core/LFG:Subv2112
Fix priority of the player when its added to the lfg group Better implementation of the Dungeon Deserter debuff Rewrite the NeedBeforeGreed loot Fixed players being shown as Unknown Entity when entering the lfg group Some incremental optimizations after original patch Thanks to Retriman and Paecman for base implementation Signed-off-by: Machiavelli <machiavelli.trinity@gmail.com>
2012-01-07DB: 335.11.45TDB335.11.45Nay
2012-01-04SQL: Correct SQL naming/locations for recent pullShocker
2011-10-29TDB 335.11.43TDB335.11.43Nay
Move SQL updates to the directory old.
2011-10-09Scripts/ICC: Fix Shadow PrisonHavenard
Fix Shadow Prison implementation, the control aura should not be cast on players. Fix Shadow Prison aura remaining on players if they leave the instance during the encounter, causing them to kill all nearby moving enemies including inside battlegrounds.
2011-09-28Core/Achievements: Fix gender-specific Matron/Patron title reward.Machiavelli
Closes #1406
2011-09-05Core/Quests: Implement quests that require PlayerSlain. Closes #169Nay
2011-08-27DB: Move SQL updates to old directory. Uploaded full DB 42.Nay
2011-08-03Core/Refer-a-Friend: Finish base work for Refer-a-Friend.Silinoron
Any testing would be very much appreciated.
2011-06-17DB: TrinityDB revision 41: move SQL updates to the old directoryNay
2011-05-31Core/Players: Pet talents can be reset at a pet trainer for free, original ↵tobmaps
idea by rsa
2011-05-29DB/Schema: Add index to characters.character_pet.slot. Prevents deadlocks ↵Machiavelli
when operating on this table.
2011-05-29Fix optional cleanup query from f8bd56armano2
Signed-off-by: Machiavelli <machiavelli.trinity@gmail.com>
2011-05-29DB/Schema: Correct use of indexes on mail_items table. Prevents deadlocks in ↵Machiavelli
operations on this table.