From 3a9db7babbd2d98c0376e1cc79b54b803eee9215 Mon Sep 17 00:00:00 2001 From: Drahy Date: Mon, 27 Jul 2009 08:29:46 +0200 Subject: * Fixed elevators in game * Fixed ugly typo in previous commit --HG-- branch : trunk --- sql/FULL/world_tmp_full.sql | 56 +++++++++++++++++++++++++++++ sql/updates/4602_world_spell_bonus_data.txt | 2 +- sql/updates/4603_world_tmp.txt | 54 ++++++++++++++++++++++++++++ 3 files changed, 111 insertions(+), 1 deletion(-) create mode 100644 sql/updates/4603_world_tmp.txt (limited to 'sql') 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 -- cgit v1.2.3