aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormegamage <none@none>2009-08-06 13:57:41 -0500
committermegamage <none@none>2009-08-06 13:57:41 -0500
commit624bd6a1f08dbf312c045fd46be3d989ddf71f05 (patch)
treebce885c7edfb1e615c1021e422623d55bf6699cb
parent6eb19cbe0fa8efca343de2fb6e15aa612f08ac2b (diff)
*Fix some Gothik mob spells. Thanks to Stryker
--HG-- branch : trunk
-rw-r--r--sql/updates/4795_world_scripts_converter.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/4795_world_scripts_converter.sql b/sql/updates/4795_world_scripts_converter.sql
new file mode 100644
index 00000000000..185075f05ed
--- /dev/null
+++ b/sql/updates/4795_world_scripts_converter.sql
@@ -0,0 +1,13 @@
+INSERT INTO creature_template (entry, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8) VALUES
+(29987, 55645, 0, 0, 0, 0, 0, 0, 27892), # Unrelenting Trainee (H)
+(29985, 27825, 0, 0, 0, 0, 0, 0, 27928), # Unrelenting Death Knight (H)
+(29986, 55638, 55608, 0, 0, 0, 0, 0, 27935) # Unrelenting Rider (H)
+ON DUPLICATE KEY UPDATE
+spell1 = VALUES(spell1),
+spell2 = VALUES(spell2),
+spell3 = VALUES(spell3),
+spell4 = VALUES(spell4),
+spell5 = VALUES(spell5),
+spell6 = VALUES(spell6),
+spell7 = VALUES(spell7),
+spell8 = VALUES(spell8); \ No newline at end of file