aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
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-04SQL: Update characters_database.sqlVincent-Michael
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-10-17DB: Add gm_tickets changes to base character dbkaelima
2012-10-09allow glyph1 be null like other glyph slotstibbi
2012-09-08SQL: Update characters_database.sqlNay
2012-08-12Update sql/base/auth_database.sqlNay
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-06-07And missing full sql changesShauren
2012-04-08Core/Conditions: Add missing code for CONDITION_TITLENay
DB/Char: Add changes to character base Thanks to manuel and QAston for noticing
2012-04-05DB/GOs: Correct some templates and add a missing one (WDB)Nay
DB/Auth: Add missed change to auth_base.sql Also fix file endings in some of hte sqls
2012-04-01DB/Auth: Increase realmlist.address size to 64 (varchar)Nay
You might want to verify if the previous size did not truncate your address (it was 15)
2012-03-28SQL: Auth db data type cleanup `logs`, `realmcharacters`, `realmlist`, ↵leak
`uptime` / Storage engine switched to InnoDB Note: As for the redundant `uptime`.`startstring` being removed, this page might be of interest how to generate time strings from unix timestamps http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_from-unixtime
2012-03-28SQL: Auth db data type cleanup `account_access`, `account_banned`, ↵leak
`ip_banned` / Storage engine switched to InnoDB
2012-03-28SQL: Auth db data type cleanup `account` / Storage engine switched to InnoDBleak
2012-03-26DB/Auth: Update auth_database.sql with recent changesNay
2012-03-25DB/Auth: Update auth_database.sql with recent changesNay
DB/GameEvent: Resync Darkmoon, again - by Aokromes
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-19DB/Schema: Update auth db base SQL to recent mysqldump formatleak
2012-01-19DB/Characters: Add missing table create to characters_database.sql from ↵Nay
f4075f0f945c842fe2b1a08ea4a7fa253e8e2e53
2012-01-07DB: Add missing changes to characters base sqlNay
2011-09-05Core/Quests: Implement quests that require PlayerSlain. Closes #169Nay
2011-08-13DB/FULL: Remove redundant full content files for world database from the ↵Machiavelli
repo. They serve no particular purpose to the project other than consume precious time of the developers having to maintain it. If you're using TDB, this shouldn't affect you in any way since the full world database is periodically dumped and uploaded.
2011-08-07Core/Spells: Fix Shaman talent Nature's Guardian and rewrite fix for ↵Machiavelli
fc52f08. Fixes some spells not triggering.
2011-08-06Core/Commands: Add .cast dest #spellid #x #y #z which orders selected unit ↵QAston
to cast a spell at selected destination.
2011-08-03Core/Refer-a-Friend: Finish base work for Refer-a-Friend.Silinoron
Any testing would be very much appreciated.
2011-08-01Core/Spells: Fix Soul Preserver trinketMachiavelli
2011-07-27Core/Commands: Allow muting offline players - the mute will become effective ↵Machiavelli
on next player login.
2011-07-23Core/Spells: Fix talent Deep Wounds. Original idea by DrTenmatobmaps
Closes #395 Closes #954 Closes #1188
2011-07-21Core/Spells: talent Judgements of the Pure should proc also on absorbstobmaps
2011-07-21Core/Spells: Fix Glyph of Scourge Striketobmaps
Closes #391
2011-07-16Core/Spells: Fix Unstable Afflictiontobmaps
Closes #94 Closes #1244 Closes #1528
2011-07-15Core/Spells: Fix Divine Hymn spell power coefficientsRamusik
Closes #438
2011-07-04Core/Commands: Update the trinity_string and cleanup the code related to ↵Nay
.list auras command
2011-07-04Core/Spells: Fix talent Damage Shieldtobmaps
2011-07-04Core/Spells: Fix Warlock T7 4P BonusSarjuuk
2011-06-29Core/Commands: Move .gps to command scripts and add .wpgps command, used for ↵Shocker
generating partial SQL queries for pathing
2011-06-27DB/Creature:kaelima
- Nuke the hacky column DeathState. - Removed some hacks from Kologarn script, including some cleanup. - Removed set deathstate command. BIG thanks to Malcrom for replacing all creatures that had deathstate with proper dynamicflags/auras.
2011-06-27Core/Vehicles: Final stage of vehicle stat scaling table removalMachiavelli
2011-06-26Database/Spells: Add spell_proc table which is a replacement for ↵QAston
spell_proc_event table. This is the initial patch from series of patches changing the way we currently handle procs in the core, and doesn't interfere with existing code in any way.
2011-06-26Core/Spells: Fix Glyph of Raptor StrikeRamusik
2011-06-25Core/Spells: Fix Shaman T10 Elemental 4P Bonustobmaps
Closes #1501
2011-06-25Core/Misc: Typo fix in trinity_stringShocker
Thanks to sebid, closes #2100
2011-06-24Core/Spells: Fix Paladin T8 Holy 2P Bonustobmaps
2011-06-22Scripts/Ulduar: Fixed achievement Getting Back to Nature in Freya's encounterLopin
2011-06-21Core/Spells: Fix proc of item Eye of the Broodmothertobmaps
Closes #530
2011-06-19Core/Gossip: Ditch gossip_scripts as it is no longer used. SAI is a better ↵Nay
option
2011-06-18Core/Spells: Fix Victory Rushtobmaps
Closes #2020