diff options
| author | untaught <untaught@trinity.contrib> | 2013-07-06 15:24:55 +0200 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2013-07-06 15:24:55 +0200 |
| commit | b49beae2f4fc90ef7865f7418e0b9d1337a2fa1d (patch) | |
| tree | acb34046ce26b6cc2756cac593f4deca5b93524b | |
| parent | 3afd29e3e4bd3bcf8e0f4100474b88321339510a (diff) | |
DB/SAI: fix some issues with Quest: Song of Reflection
Closes #7662
| -rw-r--r-- | sql/updates/world/2013_07_05_04_world_sai.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/2013_07_05_04_world_sai.sql b/sql/updates/world/2013_07_05_04_world_sai.sql new file mode 100644 index 00000000000..dc493837814 --- /dev/null +++ b/sql/updates/world/2013_07_05_04_world_sai.sql @@ -0,0 +1,12 @@ +DELETE FROM `disables` WHERE `sourcetype`=0 AND `entry`=53038 AND `flags`=64; +INSERT INTO `disables` (`sourceType`, `entry`, `flags`, `params_0`, `params_1`, `comment`) VALUES +(0,53038,64, '', '', 'Disable Vmaps for Didgeridoo of Contemplation'); + +DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (29056,29057,29069,29058); +UPDATE `creature_template` SET `ainame`='SmartAI',`scriptname`='' WHERE `entry` IN (29056,29057,29069,29058); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (29056,29057,29069,29058) AND `source_type`=0; +INSERT INTO `smart_scripts` VALUES +(29056,0,0,0,8,0,100,0,53038,0,0,0,33,29056,0,0,0,0,0,7,0,0,0,0,0,0,0,'Glimmering Pillar Credit - On Spell Hit - Give Quest Credit'), +(29057,0,0,0,8,0,100,0,53038,0,0,0,33,29057,0,0,0,0,0,7,0,0,0,0,0,0,0,'Mosslight Pillar Credit - On Spell Hit - Give Quest Credit'), +(29069,0,0,0,8,0,100,0,53038,0,0,0,33,29069,0,0,0,0,0,7,0,0,0,0,0,0,0,'Skyreach Pillar Credit - On Spell Hit - Give Quest Credit'), +(29058,0,0,0,8,0,100,0,53038,0,0,0,33,29058,0,0,0,0,0,7,0,0,0,0,0,0,0,'Suntouched Pillar Credit - On Spell Hit - Give Quest Credit'); |