aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/4222_world.sql
diff options
context:
space:
mode:
authorQAston <none@none>2009-06-24 02:03:06 +0200
committerQAston <none@none>2009-06-24 02:03:06 +0200
commit329b020af442240131f9d08d577f694e50bc9064 (patch)
tree5ec54f49cbc6509841772cfc3c550ff23952ef0c /sql/updates/4222_world.sql
parente58230d5061191756248e2e020910a23afb63b33 (diff)
*Add delete query for data in 4212_world.sql.(if you had problems with 4212 use 4222).
--HG-- branch : trunk
Diffstat (limited to 'sql/updates/4222_world.sql')
-rw-r--r--sql/updates/4222_world.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/4222_world.sql b/sql/updates/4222_world.sql
new file mode 100644
index 00000000000..88cba6a134b
--- /dev/null
+++ b/sql/updates/4222_world.sql
@@ -0,0 +1,13 @@
+DELETE FROM spell_pet_auras where `spell` in (56314,56315,56316, 56317, 56318);
+INSERT INTO spell_pet_auras VALUES
+(56314, 0, 0, 57447),
+(56314, 1, 0, 57485),
+(56315, 0, 0, 57452),
+(56315, 1, 0, 57484),
+(56316, 0, 0, 57453),
+(56316, 1, 0, 57483),
+(56317, 0, 0, 57457),
+(56317, 1, 0, 57482),
+(56318, 0, 0, 57458),
+(56318, 1, 0, 57475);
+DELETE FROM spell_linked_spell where `spell_trigger` in (57447,57482,57453, 57457, 57458);