aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--sql/FULL/world_tmp_full.sql56
-rw-r--r--sql/updates/4602_world_spell_bonus_data.txt2
-rw-r--r--sql/updates/4603_world_tmp.txt54
3 files changed, 111 insertions, 1 deletions
diff --git a/sql/FULL/world_tmp_full.sql b/sql/FULL/world_tmp_full.sql
index 19e1276d4ea..bfbb28a38b5 100644
--- a/sql/FULL/world_tmp_full.sql
+++ b/sql/FULL/world_tmp_full.sql
@@ -28,6 +28,62 @@ UPDATE creature_template SET speed = 1.0 WHERE entry = 23095; # molten_flame
-- --------
UPDATE `creature_template` SET `flags_extra` = 33 WHERE `entry` = 23576; /*no crush*/
+-- elevators
+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;
+
-- --------
-- PET
-- --------
diff --git a/sql/updates/4602_world_spell_bonus_data.txt b/sql/updates/4602_world_spell_bonus_data.txt
index ac604e4624f..6e39d948f30 100644
--- a/sql/updates/4602_world_spell_bonus_data.txt
+++ b/sql/updates/4602_world_spell_bonus_data.txt
@@ -4,4 +4,4 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`
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
+(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
new file mode 100644
index 00000000000..222a8efa783
--- /dev/null
+++ b/sql/updates/4603_world_tmp.txt
@@ -0,0 +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`=85556; \ No newline at end of file