aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/2949_world_creature_template.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/2949_world_creature_template.sql b/sql/updates/2949_world_creature_template.sql
new file mode 100644
index 00000000000..00bfea086ce
--- /dev/null
+++ b/sql/updates/2949_world_creature_template.sql
@@ -0,0 +1,10 @@
+INSERT INTO creature_template (entry, spell1, spell2, spell3, spell4) VALUES
+(15352, 36213, 0, 0, 0), # Greater Earth Elemental
+(15438, 57984, 12470, 13376, 0), # Greater Fire Elemental
+(29264, 58861, 58875, 58867, 58857), # Spirit Wolf
+(510, 31707, 33395, 0, 0) # Water Elemental
+ON DUPLICATE KEY UPDATE
+spell1 = VALUES(spell1),
+spell2 = VALUES(spell2),
+spell3 = VALUES(spell3),
+spell4 = VALUES(spell4); \ No newline at end of file