aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
AgeCommit message (Collapse)Author
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
2012-07-12TDB 335.11.48 - 2012/07/12TDB335.11.48Nay
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.