From ccdc100d10143285bc058d968f0472ea4d073120 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Tue, 27 Jan 2015 21:50:28 +0000 Subject: DB/Misc: Trayanise Script http://www.wowhead.com/npc=18230/trayanise from sniff Only the Tiny Arcane Construct appears to have fixed WP ie same waypoints repeat in sniff over and over while trayanise waypoints are different each time, Also adds the texts to this npc --- sql/updates/world/2015_01_27_00_world.sql | 56 +++++++++++++++++++++++++++++++ 1 file changed, 56 insertions(+) create mode 100644 sql/updates/world/2015_01_27_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2015_01_27_00_world.sql b/sql/updates/world/2015_01_27_00_world.sql new file mode 100644 index 00000000000..5b964110846 --- /dev/null +++ b/sql/updates/world/2015_01_27_00_world.sql @@ -0,0 +1,56 @@ +UPDATE `creature_template` SET `ainame`='SmartAI', `scriptname`='' WHERE `entry` IN(18230,18237); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(18230,18237) 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 +(18230, 0, 0, 0, 1, 0, 100, 0, 0, 0, 500, 500, 29, 0, 0, 0, 0, 0, 0, 19, 18237, 0, 0, 0, 0, 0, 0, 'Trayanise - OOC - Follow Tiny Arcane Construct'), +(18230, 0, 1, 0, 1, 0, 100, 0, 0, 60000, 180000, 300000, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Trayanise - OOC - Say Line 0'), +(18237, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 53, 1, 18237, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Tiny Arcane Construct - On Spawn - Start WP'); + +UPDATE `creature_template` SET `speed_run`=1.142857 WHERE `entry`=18230; +UPDATE `creature_template` SET `speed_run`=2.142857 WHERE `entry`=18237; + +DELETE FROM `creature_addon` WHERE `guid` IN(65501,65505); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(65501, 0, 0, 0x0, 0x1, 0, NULL), +(65505, 0, 0, 0x0, 0x1, 0, NULL); + +DELETE FROM `creature_template_addon` WHERE `entry` IN(18230,18237); + +DELETE FROM `creature` WHERE `guid` IN(65501,65505); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(65501, 18230, 530, 1, 1, 9891.047, -7180.686, 31.02935, 2.363085, 120, 0, 0), -- 18230 (Area: 3487) +(65505, 18237, 530, 1, 1, 9886.445, -7179.344, 31.03508, 2.353462, 120, 0, 0); -- 18237 (Area: 3487) + + +DELETE FROM `waypoint_data` WHERE `id` IN(655010,655050); + +DELETE FROM `waypoints` WHERE `entry` IN(18230,18237); +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(18237, 1, 9854.372, -7131.53, 30.8774, 'Tiny Arcane Construct'), +(18237, 2, 9848.939, -7149.687, 30.88104, 'Tiny Arcane Construct'), +(18237, 3, 9853.528, -7164.35, 30.94116, 'Tiny Arcane Construct'), +(18237, 4, 9873.93, -7174.143, 31.04511, 'Tiny Arcane Construct'), +(18237, 5, 9890.317, -7171.364, 32.04652, 'Tiny Arcane Construct'), +(18237, 6, 9893.691, -7182.642, 31.02659, 'Tiny Arcane Construct'), +(18237, 7, 9906.294, -7211.048, 30.9103, 'Tiny Arcane Construct'), +(18237, 8, 9914.21, -7215.013, 30.81886, 'Tiny Arcane Construct'), +(18237, 9, 9930.763, -7214.394, 30.86104, 'Tiny Arcane Construct'), +(18237, 10, 9954.362, -7211.773, 30.87779, 'Tiny Arcane Construct'), +(18237, 11, 9953.68, -7204.061, 30.87768, 'Tiny Arcane Construct'), +(18237, 12, 9941.922, -7198.434, 30.87755, 'Tiny Arcane Construct'), +(18237, 13, 9915.126, -7188.168, 30.9569, 'Tiny Arcane Construct'), +(18237, 14, 9897.4, -7190.357, 31.03786, 'Tiny Arcane Construct'), +(18237, 15, 9885.156, -7178.048, 31.03413, 'Tiny Arcane Construct'), +(18237, 16, 9874.851, -7163.025, 30.99726, 'Tiny Arcane Construct'), +(18237, 17, 9867.523, -7139.578, 30.87733, 'Tiny Arcane Construct'); + +DELETE FROM `creature_text` WHERE `entry`=18230; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES +(18230, 0, 0, 'The magister''s going to kill me...', 12, 1, 100, 0, 0, 0, 15011, 'Trayanise'), +(18230, 0, 1, 'No, no, no! Come back here!', 12, 1, 100, 0, 0, 0, 15010, 'Trayanise'), +(18230, 0, 2, 'Argh. They told me those crystals would work properly!', 12, 1, 100, 0, 0, 0, 15013, 'Trayanise'), +(18230, 0, 3, 'When I catch you, I''m going to disenchant your components, so help me...', 12, 1, 100, 0, 0, 0, 15015, 'Trayanise'), +(18230, 0, 4, 'Get back here, you little...', 12, 1, 100, 0, 0, 0, 15012, 'Trayanise'), +(18230, 0, 5, 'You stay out of the regent lord''s way! I mean it!', 12, 1, 100, 0, 0, 0, 15014, 'Trayanise'); + -- cgit v1.2.3