From 62e44d0e4b61c72489961535a00a0386cfb0ca9f Mon Sep 17 00:00:00 2001 From: Killyana Date: Wed, 19 Jun 2019 16:45:16 +0200 Subject: DB/Quest: Building a Perimeter --- sql/updates/world/3.3.5/2019_06_19_00_world.sql | 12 ------------ sql/updates/world/3.3.5/2019_06_19_01_world.sql | 12 ++++++++++++ sql/updates/world/3.3.5/2019_06_19_02_world.sql | 23 +++++++++++++++++++++++ 3 files changed, 35 insertions(+), 12 deletions(-) delete mode 100644 sql/updates/world/3.3.5/2019_06_19_00_world.sql create mode 100644 sql/updates/world/3.3.5/2019_06_19_01_world.sql create mode 100644 sql/updates/world/3.3.5/2019_06_19_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2019_06_19_00_world.sql b/sql/updates/world/3.3.5/2019_06_19_00_world.sql deleted file mode 100644 index fb257cd0595..00000000000 --- a/sql/updates/world/3.3.5/2019_06_19_00_world.sql +++ /dev/null @@ -1,12 +0,0 @@ --- -DELETE FROM `creature` WHERE `id` IN (21292) AND `guid` IN (111105); -INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `unit_flags`) VALUES -(111105, 21292, 530, 0, 0, 1, 1, 0, 0, -3795.850098, 2595.90991, 90.12059, 4.782200, 600, 0, 0, 0, 0, 0, 33554432); -DELETE FROM `creature_addon` WHERE `guid`=111105; -INSERT INTO `creature_addon` (`guid`, `bytes2`, `auras`) VALUES (111105,0,"29266 37497"); -UPDATE `smart_scripts` SET `target_type`=10, `target_param1`=84607 AND `target_param2`=21292 WHERE `action_type`=11 AND`action_param1` = 36558; --- DB errors and spawns fix -DELETE FROM `gameobject_addon` WHERE `guid` IN (99874,99873,99872); -UPDATE `gameobject` SET `rotation2`=0.588741, `rotation3`=0.808322 WHERE `id` = 142698; -UPDATE `creature` SET `MovementType`=1, `spawndist`=5 WHERE `id` IN (18867,18866); -UPDATE `creature` SET `position_x`=2172.269531, `position_y`=2317.429688, `position_z`=81.406921 WHERE `guid` IN (67476); diff --git a/sql/updates/world/3.3.5/2019_06_19_01_world.sql b/sql/updates/world/3.3.5/2019_06_19_01_world.sql new file mode 100644 index 00000000000..fb257cd0595 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_06_19_01_world.sql @@ -0,0 +1,12 @@ +-- +DELETE FROM `creature` WHERE `id` IN (21292) AND `guid` IN (111105); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `unit_flags`) VALUES +(111105, 21292, 530, 0, 0, 1, 1, 0, 0, -3795.850098, 2595.90991, 90.12059, 4.782200, 600, 0, 0, 0, 0, 0, 33554432); +DELETE FROM `creature_addon` WHERE `guid`=111105; +INSERT INTO `creature_addon` (`guid`, `bytes2`, `auras`) VALUES (111105,0,"29266 37497"); +UPDATE `smart_scripts` SET `target_type`=10, `target_param1`=84607 AND `target_param2`=21292 WHERE `action_type`=11 AND`action_param1` = 36558; +-- DB errors and spawns fix +DELETE FROM `gameobject_addon` WHERE `guid` IN (99874,99873,99872); +UPDATE `gameobject` SET `rotation2`=0.588741, `rotation3`=0.808322 WHERE `id` = 142698; +UPDATE `creature` SET `MovementType`=1, `spawndist`=5 WHERE `id` IN (18867,18866); +UPDATE `creature` SET `position_x`=2172.269531, `position_y`=2317.429688, `position_z`=81.406921 WHERE `guid` IN (67476); diff --git a/sql/updates/world/3.3.5/2019_06_19_02_world.sql b/sql/updates/world/3.3.5/2019_06_19_02_world.sql new file mode 100644 index 00000000000..ef368d9e384 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_06_19_02_world.sql @@ -0,0 +1,23 @@ +-- Building a Perimeter (10240) +DELETE FROM smart_scripts WHERE entryorguid IN(19866, 19867, 19868) AND source_type=0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(19866, 0, 0, 0, 8, 0, 100, 0, 34646, 0, 1000, 1000, 33, 19866, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Invis East KV Rune - On Spell Hit - Kill Monster Credit'), +(19866, 0, 1, 0, 8, 0, 100, 0, 34646, 0, 120000, 120000, 50, 183948, 120, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Invis East KV Rune - On Spell Hit - Summon Gameobject'), +(19867, 0, 0, 0, 8, 0, 100, 0, 34646, 0, 1000, 1000, 33, 19867, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Invis NE KV Rune - On Spell Hit - Kill Monster Credit'), +(19867, 0, 1, 0, 8, 0, 100, 0, 34646, 0, 120000, 120000, 50, 183948, 120, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Invis NE KV Rune - On Spell Hit - Summon Gameobject'), +(19868, 0, 0, 0, 8, 0, 100, 0, 34646, 0, 1000, 1000, 33, 19868, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Invis West KV Rune - On Spell Hit - Kill Monster Credit'), +(19868, 0, 1, 0, 8, 0, 100, 0, 34646, 0, 120000, 120000, 50, 183948, 120, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Invis West KV Rune - On Spell Hit - Summon Gameobject'); + +DELETE FROM `gameobject` WHERE `id` = 183955; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(9009, 183955, 530, 1, 1, 2194.7275, 2314.035, 145, 2.179214, 0, 0, 0.133363, -0.991067, 180, 0, 1); + +DELETE FROM `gameobject_addon` WHERE `guid` = 9009; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation2`, `parent_rotation3`, `invisibilityType`, `invisibilityValue`) VALUES +(9009,0.133363,-0.991067, 7, 1000); + +DELETE FROM `spell_area` WHERE `spell` IN (60194) AND `area` IN (3879,3934,3935); +INSERT INTO `spell_area` (`spell`,`area`,`quest_start`,`quest_end`,`aura_spell`,`racemask`,`gender`,`autocast`,`quest_start_status`,`quest_end_status`) VALUES +(60194,3879,10240,0,0,0,2,1,64,0), +(60194,3934,10240,0,0,0,2,1,64,0), +(60194,3935,10240,0,0,0,2,1,64,0); -- cgit v1.2.3