aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
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
2011-06-17Core/Spells: Fix internal cooldown for item Jouster's Furytobmaps
2011-06-10Core/Spells: item Majestic Dragon Figurine should proc also from instant spellstobmaps
Closes #271
2011-06-09Core/Spells: Drop obsolete spell proc data for Surge of Lighttobmaps
2011-06-09Core/Spells: Drop obsolete spell proc data for Infusion of Lighttobmaps
Closes #1892 Closes #1899
2011-06-09Scripts/Ulduar/XT-002:Machiavelli
- Implement "Nerf Scrapbots" achievement - Proper target conditions for Boombot Boom - Pummeler add should walk towards raid on spawn
2011-06-07Scripts/Ulduar: Remove dirty spell and summon hacks from XT-002 script and ↵Machiavelli
rewrite with EventMap. Script is still WIP.
2011-06-02Core/Spells: Fix item Corpse Tongue Coin and some related cleanupRamusik
2011-05-31Core/Spells: Fix spell power and attack power coefficients for Seal of ↵tobmaps
Righteousness
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-29Scripts/Icecrown Citadel: Properly remove Uncontrollable Frenzy linked auras ↵Shauren
when entering evade more