aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
2011-03-19Core/Spells: Arcane Concentration should proc only from mage spell castsRamus
2011-03-19SQL: Lost changes in character base sqlleak
2011-03-17Core/DB: increase size of phaseMask field in corpse table to allow values ↵Azazel
larger than 255
2011-03-17Core/SQL: fix error in world_database.sqlAzazel
2011-03-11Core/Commands: Allow npc info to show both DB GUID and current GUIDShocker
2011-03-11CharDB Schema/Cleanup: cleanup channels table:Azazel
* rename columns (remove m_ prefix and convert to lowerCamel case); * rename prepared statements to conform to standards (there is no CLEAN statement).
2011-03-07DB/NPC: Spawn Shango with pathing.Nay
SQL: Fix typo and add missing changes to world_database.sql Closes #883
2011-03-07Core/Commands: Make vehicle_accessory and vehicle_template_accessory ↵Machiavelli
reloadable with commands
2011-03-07Core/Spells: Fixed Glyph of Shadow Word: PainGWRde
2011-03-05Core/Spells: Fixed Heartpierce procShauren
2011-03-04Fix: SQL syntax error in world base SQL scriptEdwinDW
2011-02-26DB/Spells: Added flower summoning visual of LifebloodShauren
2011-02-25Core/Spells: Focus Magic should proc only from critical hitsShocker
2011-02-25CharDB Schema/Cleanup: cleanup character_tutorial table:Azazel
* rename table to account_tutorial, because it holds account specific data; * rename column account to accountId; * introduce prepared statements for table.
2011-02-25CharDB Schema/Cleanup: cleanup account_data and character_account_data tables:Azazel
* rename column account to accountId; * introduce prepared statements for both tables.
2011-02-24Usual commit about forgotten full SQL changes in previous commit.Nay
2011-02-20DB/Schema: Properly use field types in smart_script tableNay
Thanks Shauren
2011-02-18Core/Spells: Fixed Combustion stacking exploitShauren
2011-02-18Scripts/Icecrown Citadel: Added support for weekly quest "Deprogramming"Shauren
2011-02-15Scripts/Icecrown Citadel: Fixed Sindragosa's Icy GripShauren
Closes #629
2011-02-11Core/Gossip: Remove support for `npc_gossip` table (DEPRECATED).runningnak3d
2011-02-07Scripts/Icecrown Citadel: Added Sindragosa scriptShauren
2011-02-03Core/Instances: Implemented DungeonEncounter.dbc for creating completed ↵Shauren
encounters mask to use in packets Core/Dungeon Finder: Implemented new way of giving random dungeon rewards, linked to DungeonEncounter.dbc
2011-01-31Core/Spells: Implemented Druid T10 4P restoration bonusShauren
2011-01-31Core/Spells: Added cooldown for Purified Lunar Dust trinket (item 50358)Shauren
2011-01-30Core/Spells: Fixed Judgements of the JustDrTenma
Signed-off-by: Shauren <shauren.trinity@gmail.com>
2011-01-29SQL/Quest: Added linked credit spells for quest 8867 (Lunar Fireworks)Shauren
2011-01-28Scripts/Icecrown Citadel: Implemented Pact of the Darkfallen damage scaling ↵Shauren
(Blood-Queen Lana'thel) SQL: Renamed and split 2011_01_26_world_scriptname to meet the standards
2011-01-24Core/Instances: Implemented hourly instance limit: players are limited to ↵Shauren
entering 5 instances per hour (account wide limit)
2011-01-22Core/SQL: Add unique table key for (guid, bag, slot) in character_inventory ↵Machiavelli
to prevent storing different item entities in the same slot. NOTE: If you get import errors it's YOUR OWN RESPONSIBILITY to fix current data inconsistencies your database might have.
2011-01-20SQL: Characters db storage type cleanup No. 7 (final) - Note:leak
- It is _strongly_ recommended to extensively test the recent changes before applying them to live data - To fully resync the character db layout with TC releases it is recommended to dump the characters table with mysqldump --no-data characters > characters_database_livedata.sql and use a diff tool to compare it against sql/base/characters_database.sql
2011-01-20SQL: Characters db storage type cleanup No. 6leak
2011-01-20SQL: Characters db storage type cleanup No. 5leak
2011-01-19SQL: Characters db storage type cleanup No. 4leak
2011-01-19SQL: Characters db storage type cleanup No. 3 - Note:leak
There is a chance that you will be getting importing errors / data truncation warnings because of ancient invalid pet names. SELECT * FROM character_pet WHERE CHAR_LENGTH(`name`) > 21;
2011-01-19SQL: Characters db storage type cleanup No. 2leak
2011-01-19SQL: Characters db storage type cleanup #1 - Note:leak
- MySQL numeric types can NOT be altered in value range or or storage size at all, so things like INT(32) are entirely pointless. As TC currently doesn't use the display width of numeric types, use the default width to avoid confusion. (see MySQL numeric types docs) - Timestamps can be stored as INT(10) UNSIGNED. As the max value of this type is 4294967295 which translates into year 2106 using it as timestamp we are NOT affected by the year 2038 bug. If the timestamp needs to be negative in some cases, i.e. for displaying infinity using -1, use BIGINT(20) instead. - Do NOT set ROW_FORMAT for InnoDB tables unless you specifically want COMPRESSED tables (which we don't for performance reasons). MySQL will chose the appropriate ROW_FORMAT by itself depending on the innodb_file_format setting of the server. (FIXED is only available for MyISAM) - Even though VARCHAR does require less storage space than CHAR for values with variable length, the length still needs to be chosen wisely as this doesn't apply to memory consumption.
2011-01-19SQL: Resync characters db base SQL with rollups and redump with recent ↵leak
mysqldump version in preparation for char db storage type cleanup
2011-01-11Core/SQL: Fix up a few missing tables from base world_database import schema ↵click
and a few typos Thanks to Aokromes for the heads up ref the typos, and Oinquer on the missing tables.
2011-01-10Core/Spells: Fixed Spirit Walk ability of shaman's Feral Spirit summonsShauren
Closes #115 Signed-off-by: Shauren <shauren.dev@gmail.com>
2011-01-09Core/Battleground: Implemented blizzlike script for Isle of Conquest, ↵Manuel
written by gyullo and me, based on Socolin's and Josh's patch -BIG THANKS TO THEM- Anyway the map is not yet playable, there are issues not related with the script. I also want to thanks to QAston, linencloth, Shauren and Machiavelli to be so patient with my questions.
2011-01-08Core/SQL: Move spell_script_names from world_database.sql to ↵Machiavelli
world_scripts_full.sql (they're called scripts for a reason)
2011-01-08Scripts/Ulduar: Spell script for spells 62524,62525,62521 (Freya encounter)Lopin
Signed-off-by: Machiavelli <machiavelli.trinity@gmail.com>
2011-01-02Core/Spells: Cleaned up Shaman 4P Enhancement and Paladin 2P Retribution set ↵Shauren
bonus code SQL: Added missing sql for that revision, thx cyberbrest Closes #12
2011-01-01Scripts/Pit of Saron: Rewrite Pit of Saron instanceDark0r
Signed-off-by: Shauren <krzysiek.7.5.4@gmail.com>
2010-12-31Scripts/Trial of the Crusader:John Holiver
1) Fix Leeching Swarm damage and create spell difficulty links to code. Closes issue #4909 . 2) Fix Valkyr's Touch. Closes issue #4553 . 3) Fix Permafrost aura difficulty check. 4) Reduce Slime Pool damage range. 5) Avoid Shaman Champion Heroism spam using 5 minutes (CD) as timer. 6) Fix many spell target selection to only select players (no more totens or pets). 7) Fix Anub'arak Spike being able to receibe the permafrost aura in order to cast spike fail, hopefully.
2010-12-30Core/ScriptSystem: Add OnEffectManaShield and AfterEffectManaShield hooks to ↵QAston
AuraScript class. Usage of these is the same as similar Absorb hooks. Scripts: Move Incanter's Absorbtion script from Unit::CalcAbsorbResist to AuraScript.
2010-12-30Core/Unit: Move spell specific code from Unit::CalcAbsorbResist to AuraScripts.QAston
2010-12-29Scripts: Correct function registration of ↵Machiavelli
spell_dru_moonkin_form_passive_AuraScript, fix intendation in world_database.sql Author: QAston
2010-12-27Core/Unit: Big cleanup in Unit::CalcAbsorbResistQAston
Core/AuraScript: Fix compile time check for AuraScript functions Remove AuraApplication from hook functions parameter list, use GetTarget() and GetTargetApplication() instead Add OnEffectAbsorb hook Scripts: move handlers of Spell Deflection, Savage Defense, Primal Tenacity, Nerves of Steel, Astral shift from core to scripts. --HG-- branch : trunk