diff options
author | Filip <boev.filip@gmail.com> | 2013-09-22 18:40:47 +0200 |
---|---|---|
committer | Filip <boev.filip@gmail.com> | 2013-09-22 18:40:47 +0200 |
commit | 4498ac0062d56aa0a0f2b9a21358f12f83c4b1f7 (patch) | |
tree | a70912836f13e098fcf4b8a9da007ab0a6ba0e81 | |
parent | 3aa9446d548f187e6ce8111f8383d219dbf29723 (diff) |
DB/SAI: Zeth'Gor Must Burn!
Fixes #10904 by @untaught
-rw-r--r-- | sql/updates/world/2013_09_22_00_world_sai.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/2013_09_22_00_world_sai.sql b/sql/updates/world/2013_09_22_00_world_sai.sql new file mode 100644 index 00000000000..e7c5753bfc4 --- /dev/null +++ b/sql/updates/world/2013_09_22_00_world_sai.sql @@ -0,0 +1,7 @@ +UPDATE `smart_scripts` SET `link`=3 WHERE `entryorguid` IN (22401,21182,22402,22403) AND `source_type`=0 AND `id`=2 AND `link`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (22401,21182,22402,22403) AND `source_type`=0 AND `id`=3; +INSERT INTO `smart_scripts` (`entryorguid`, `id`, `event_type`, `action_type`, `action_param1`, `target_type`, `comment`) VALUES +(22401,3,61,33,22401,7,'Zeth''Gor Quest Credit Marker, They Must Burn, Tower North - On spell hit - Give Quest Credit'), +(21182,3,61,33,21182,7,'Zeth''Gor Quest Credit Marker, They Must Burn, Tower South - On spell hit - Give Quest Credit'), +(22402,3,61,33,22402,7,'Zeth''Gor Quest Credit Marker, They Must Burn, Tower Forge - On spell hit - Give Quest Credit'), +(22403,3,61,33,22403,7,'Zeth''Gor Quest Credit Marker, They Must Burn, Tower Foothill - On spell hit - Give Quest Credit'); |