diff options
-rw-r--r-- | sql/updates/4602_world_spell_bonus_data.txt | 12 | ||||
-rw-r--r-- | sql/updates/4603_world_tmp.txt | 106 |
2 files changed, 59 insertions, 59 deletions
diff --git a/sql/updates/4602_world_spell_bonus_data.txt b/sql/updates/4602_world_spell_bonus_data.txt index 6e39d948f30..85975accd34 100644 --- a/sql/updates/4602_world_spell_bonus_data.txt +++ b/sql/updates/4602_world_spell_bonus_data.txt @@ -1,7 +1,7 @@ -DELETE FROM `spell_bonus_data` WHERE `entry`=779;
-INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES
-('779', '-1', '-1', '0.063', '-1', 'Druid - Swipe (Bear)');
-
-DELETE FROM `spell_bonus_data` WHERE `entry`=50256;
-INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES
+DELETE FROM `spell_bonus_data` WHERE `entry`=779; +INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES +('779', '-1', '-1', '0.063', '-1', 'Druid - Swipe (Bear)'); + +DELETE FROM `spell_bonus_data` WHERE `entry`=50256; +INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES (50256, -1, -1, 0.08, -1, 'Pet Skills - Bear (Swipe)');
\ No newline at end of file diff --git a/sql/updates/4603_world_tmp.txt b/sql/updates/4603_world_tmp.txt index 222a8efa783..4ce1593c9c7 100644 --- a/sql/updates/4603_world_tmp.txt +++ b/sql/updates/4603_world_tmp.txt @@ -1,54 +1,54 @@ -UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=11898;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=11899;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=149045;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=149046;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=164871;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=175080;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176080;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176081;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176082;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176083;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176084;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176085;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176086;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176231;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176244;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176310;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176495;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=177233;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=181056;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=181646;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=183169;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=183177;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=183202;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=183203;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=183407;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=183490;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=183788;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=184330;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20649;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20650;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20651;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20652;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20653;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20654;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20655;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20656;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20657;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20808;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=210335;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=210336;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=210349;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=211023;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=211024;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=211050;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=211051;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=211052;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=211053;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=4170;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=4171;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=47296;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=47297;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=80022;
-UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=80023;
+UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=11898; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=11899; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=149045; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=149046; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=164871; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=175080; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176080; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176081; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176082; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176083; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176084; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176085; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176086; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176231; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176244; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176310; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=176495; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=177233; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=181056; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=181646; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=183169; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=183177; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=183202; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=183203; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=183407; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=183490; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=183788; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=184330; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20649; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20650; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20651; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20652; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20653; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20654; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20655; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20656; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20657; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=20808; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=210335; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=210336; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=210349; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=211023; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=211024; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=211050; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=211051; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=211052; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=211053; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=4170; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=4171; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=47296; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=47297; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=80022; +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=80023; UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=85556;
\ No newline at end of file |