diff options
| -rw-r--r-- | sql/updates/world/2015_08_12_00_world.sql | 116 |
1 files changed, 116 insertions, 0 deletions
diff --git a/sql/updates/world/2015_08_12_00_world.sql b/sql/updates/world/2015_08_12_00_world.sql new file mode 100644 index 00000000000..5afe2f91697 --- /dev/null +++ b/sql/updates/world/2015_08_12_00_world.sql @@ -0,0 +1,116 @@ +-- +UPDATE `creature_template_addon` SET `auras`="" WHERE `entry` IN (32638, 32639); +UPDATE `creature_template_addon` SET `auras`="49414" WHERE `entry` IN (39640); +DELETE FROM `creature` WHERE `id` IN (32638, 32639); + +UPDATE `creature` SET `position_x`= 5652.729980, `position_y`= 2106.209961, `position_z`= 798.138000, `Orientation`= 4.572760 WHERE `guid`= 266; +UPDATE `creature` SET `position_x`= 5916.85, `position_y`= 579.396, `position_z`= 639.656, `Orientation`= 0.122173 WHERE `guid`= 269; +DELETE FROM `creature` WHERE `guid`= 272; + +UPDATE `creature` SET `Orientation`= 4.764750 WHERE `guid`=265; +DELETE FROM `gameobject_addon` WHERE `guid` IN (156, 157, 6135, 6134); +INSERT INTO `gameobject_addon` (`guid`, `invisibilityType`, `invisibilityValue`) VALUES +(156,9,1000), (157,9,1000); + +DELETE FROM `creature_queststarter` WHERE `id`=2031; +UPDATE `creature_template` SET `npcflag`=0 WHERE `entry` IN (49337); +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (42960,41570,48092,48266,41776,42958,42608,52585,50636,41445,14864,41327,42951,42949,51157,38424,57287,42956,57378,53088,48343,47820,48341,50409,57377,38377,56097,50635,52887,31749,50638,34567,34568,36283,37807,39619,39867,40250,41620,41789,41848,42175,42571,42603,42801,42947,42954,44579,44776,45455,46085,46165,46411,47066,47403,47404,47814,47821,47822,48342,49208,49337,50643,51340,51551,52682,52884,52885,52886,52888,52889,52890,53089,53131,53275,53493,53887,54247,54348,54367,55549,55715,56129,56130,56131,57288,57289,57328,57379,57443,57882); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(41570, 41020, 1, 0 ), +(41620, 41020, 1, 0 ), +(41789, 41020, 1, 0 ), +(42175, 43767, 1, 0 ), +(41848, 43767, 1, 0 ), +(57328, 49213, 1, 0 ), +(41327, 59099, 1, 0 ), +(46411, 59907, 1, 0 ), +(31749, 61421, 1, 0 ), +(34567, 65684, 1, 0 ), +(34568, 65686, 1, 0 ), +(37807, 69434, 1, 0 ), +(36283, 69434, 1, 0 ), +(38424, 72009, 1, 0 ), +(56131, 75648, 1, 0 ), +(56130, 75648, 1, 0 ), +(56129, 75648, 1, 0 ), +(56097, 75648, 1, 0 ), +(53131, 76387, 1, 0 ), +(42958, 77611, 1, 0 ), +(41445, 77611, 1, 0 ), +(42960, 77611, 1, 0 ), +(42956, 77611, 1, 0 ), +(42954, 77611, 1, 0 ), +(42951, 77611, 1, 0 ), +(42947, 77611, 1, 0 ), +(42949, 77611, 1, 0 ), +(42801, 80633, 1, 0 ), +(44776, 83486, 1, 0 ), +(46085, 85875, 1, 0 ), +(51551, 86296, 1, 0 ), +(51340, 86296, 1, 0 ), +(41776, 86358, 1, 0 ), +(47066, 87713, 1, 0 ), +(45455, 87742, 1, 0 ), +(48342, 89908, 1, 0 ), +(48341, 89908, 1, 0 ), +(48343, 89908, 1, 0 ), +(46165, 90102, 1, 0 ), +(57378, 90102, 1, 0 ), +(48092, 90102, 1, 0 ), +(48266, 90102, 1, 0 ), +(57882, 90102, 1, 0 ), +(47403, 90102, 1, 0 ), +(38377, 90102, 1, 0 ), +(44579, 90102, 1, 0 ), +(49208, 90102, 1, 0 ), +(54348, 90102, 1, 0 ), +(54367, 90102, 1, 0 ), +(39619, 90102, 1, 0 ), +(55549, 90102, 1, 0 ), +(57289, 90102, 1, 0 ), +(42603, 90102, 1, 0 ), +(57443, 90102, 1, 0 ), +(52585, 90102, 1, 0 ), +(57288, 90102, 1, 0 ), +(57287, 90102, 1, 0 ), +(47814, 90102, 1, 0 ), +(47820, 90102, 1, 0 ), +(47821, 90102, 1, 0 ), +(47404, 90102, 1, 0 ), +(47822, 90102, 1, 0 ), +(50643, 94269, 1, 0 ), +(50635, 94271, 1, 0 ), +(50636, 94272, 1, 0 ), +(50638, 94275, 1, 0 ), +(51157, 94316, 1, 0 ), +(42608, 94350, 1, 0 ), +(42571, 94350, 1, 0 ), +(39867, 94656, 1, 0 ), +(40250, 97400, 1, 0 ), +(52682, 97400, 1, 0 ), +(52889, 97773, 1, 0 ), +(52886, 97773, 1, 0 ), +(52887, 97773, 1, 0 ), +(52888, 97773, 1, 0 ), +(52890, 97773, 1, 0 ), +(52885, 97773, 1, 0 ), +(53887, 97773, 1, 0 ), +(52884, 97773, 1, 0 ), +(52886, 97885, 1, 0 ), +(52888, 97885, 1, 0 ), +(52884, 97885, 1, 0 ), +(53887, 97885, 1, 0 ), +(52885, 97885, 1, 0 ), +(52889, 97885, 1, 0 ), +(52887, 97885, 1, 0 ), +(52890, 97885, 1, 0 ), +(53088, 98208, 1, 0 ), +(53275, 98725, 1, 0 ), +(53089, 99933, 1, 0 ), +(53493, 101376, 1, 0), +(55715, 104515, 1, 0), +(14864, 104517, 1, 0), +(57377, 106094, 1, 0), +(57379, 109835, 1, 0), +(54247, 90102, 1, 0), +(50409, 93473, 1, 0); |