diff options
| author | Malcrom <malcromdev@gmail.com> | 2013-11-10 18:00:15 -0330 |
|---|---|---|
| committer | Malcrom <malcromdev@gmail.com> | 2013-11-10 18:00:15 -0330 |
| commit | 113735690a06217a9648ddd6c8de2aa932c89db8 (patch) | |
| tree | 9d56af25450a9578f3227836ea7d4077f85a8dc5 /sql | |
| parent | e0138abaac886eac24022ff86eccf1671604c6e3 (diff) | |
Scripts/The Slave Pens: Fix up Mennu the Betrayer and add Rokmar the Cracker & Quagmirran.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2013_11_10_02_world_misc.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/2013_11_10_02_world_misc.sql b/sql/updates/world/2013_11_10_02_world_misc.sql new file mode 100644 index 00000000000..6049724f6d3 --- /dev/null +++ b/sql/updates/world/2013_11_10_02_world_misc.sql @@ -0,0 +1,13 @@ +UPDATE `creature_template` SET `AIName` = '', `ScriptName`= 'boss_rokmar_the_crackler' WHERE entry=17991; +DELETE FROM creature_ai_scripts WHERE creature_id=17991; +UPDATE `creature_template` SET `AIName` = '', `ScriptName`= 'boss_mennu_the_betrayer' WHERE entry=17941; +DELETE FROM creature_ai_scripts WHERE creature_id=17941; +DELETE FROM creature_ai_texts WHERE entry BETWEEN -98 AND -93; +UPDATE `creature_template` SET `AIName` = '', `ScriptName`= 'boss_quagmirran' WHERE entry=17942; +DELETE FROM creature_ai_scripts WHERE creature_id=17942; + +-- Add missing spelldifficulty_dbc values +DELETE FROM `spelldifficulty_dbc` WHERE `id` IN (31956,34780); +INSERT INTO `spelldifficulty_dbc` (`id`,`spellid0`,`spellid1`) VALUES +(31956,31956,39005), -- Rokmar the Crackler +(34780,34780,39340); -- Quagmirran |