diff options
| -rw-r--r-- | sql/updates/world/2016_04_09_24_world_2016_04_04_00_world.sql | 149 |
1 files changed, 149 insertions, 0 deletions
diff --git a/sql/updates/world/2016_04_09_24_world_2016_04_04_00_world.sql b/sql/updates/world/2016_04_09_24_world_2016_04_04_00_world.sql new file mode 100644 index 00000000000..69da8a7d699 --- /dev/null +++ b/sql/updates/world/2016_04_09_24_world_2016_04_04_00_world.sql @@ -0,0 +1,149 @@ +UPDATE `quest_template_addon` SET `RequiredMinRepValue`=9000 WHERE `ID`=9729; + +DELETE FROM `creature_text` WHERE `entry`=17877; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(17877, 0, 0, 'Fhwoor go now, $n. Get ark, come back.', 12, 0, 100, 0, 0, 0, 16439, 0, 'Fhwoor'), +(17877, 1, 0, 'Take moment... get ready.', 12, 0, 100, 0, 0, 0, 16440, 0, 'Fhwoor'), +(17877, 2, 0, 'We go!', 12, 0, 100, 0, 0, 0, 16441, 0, 'Fhwoor'), +(17877, 3, 0, '%s lifts the Ark of Ssslith with ease.', 16, 0, 100, 0, 0, 0, 16442, 0, 'Fhwoor'), +(17877, 4, 0, 'Uh oh...', 12, 0, 100, 0, 0, 0, 16443, 0, 'Fhwoor'), +(17877, 5, 0, 'Ha ha, squishy naga!', 12, 0, 100, 0, 0, 0, 16444, 0, 'Fhwoor'), +(17877, 6, 0, '%s places the Ark of Ssslith on the ground.', 16, 0, 100, 0, 0, 0, 16445, 0, 'Fhwoor'), +(17877, 7, 0, 'Fhwoor do good!', 16, 0, 100, 0, 0, 0, 16446, 0, 'Fhwoor'); + +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`IN(18154,17877); + +DELETE FROM `smart_scripts` WHERE `entryorguid`IN(17877,18154) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid`IN(1787700,1787701) AND `source_type`=9; +DELETE FROM `smart_scripts` WHERE `entryorguid`=18089 AND `source_type`=0 AND `id`>0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=18088 AND `source_type`=0 AND `id`>1; + +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 +(18154, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 53, 0, 18154, 0, 0, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, 'Ssslith - On Just Summoned - Start WP'), +(18088, 0, 2, 0, 54, 0, 100, 0, 0, 0, 0, 0, 53, 0, 18088, 0, 0, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, 'Bloodscale Enchantress - On Just Summoned - Start WP'), +(18089, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 53, 0, 18089, 0, 0, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, 'Bloodscale Slavedriver - On Just Summoned - Start WP'), +(18154, 0, 1, 0, 40, 0, 100, 0, 12, 18154, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 17877, 0, 0, 0, 0, 0, 0, 'Ssslith - On Reached WP12 - Face Fhwoor'), +(18088, 0, 3, 0, 40, 0, 100, 0, 6, 18088, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 17877, 0, 0, 0, 0, 0, 0, 'Bloodscale Enchantress - On Reached WP12 - Face Fhwoor'), +(18089, 0, 2, 0, 40, 0, 100, 0, 8, 18089, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 17877, 0, 0, 0, 0, 0, 0, 'Bloodscale Slavedriver - On Reached WP12 - Face Fhwoor'), +(17877, 0, 0, 1, 19, 0, 100, 0, 9729, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Quest Accept (Fhwoor Smash) - Store Targetlist'), +(17877, 0, 1, 18, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Quest Accept (Fhwoor Smash) - Say Line 0'), +(17877, 0, 2, 0, 6, 0, 100, 0, 0, 0, 0, 0, 6, 9729, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Death - Fail Quest Fhwoor Smash'), +(17877, 0, 3, 4, 40, 0, 100, 0, 11, 17877, 0, 0, 1, 1, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP11 - Say Line 1'), +(17877, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 54, 20000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP11 - Pause WP (20 seconds)'), +(17877, 0, 5, 0, 40, 0, 100, 0, 12, 17877, 0, 0, 1, 2, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP12 - Say Line 2'), +(17877, 0, 6, 7, 40, 0, 100, 0, 27, 17877, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP27 - Say Line 3'), +(17877, 0, 7, 8, 61, 0, 100, 0, 0, 0, 0, 0, 54, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP27 - Pause WP (5 seconds)'), +(17877, 0, 8, 0, 61, 0, 100, 0, 0, 0, 0, 0, 70, 120, 0, 0, 0, 0, 0, 20, 182082, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP27 - Despawn The Ark of Ssslith'), +(17877, 0, 9, 10, 40, 0, 100, 0, 43, 17877, 0, 0, 1, 4, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP43 - Say Line 4'), +(17877, 0, 10, 11, 61, 0, 100, 0, 0, 0, 0, 0, 54, 20000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP43 - Pause WP (20 seconds)'), +(17877, 0, 11, 12, 61, 0, 100, 0, 0, 0, 0, 0, 12, 18154, 1, 300000, 0, 0, 0, 8, 0, 0, 0, 168.5472, 8207.521, 22.9772, 4.467648, 'Fhwoor - On Reached WP43 - Summon Ssslith'), +(17877, 0, 12, 13, 61, 0, 100, 0, 0, 0, 0, 0, 12, 18088, 1, 300000, 0, 0, 0, 8, 0, 0, 0, 172.8663, 8214.886, 22.31137, 4.198237, 'Fhwoor - On Reached WP43 - Summon Bloodscale Enchantress'), +(17877, 0, 13, 0, 61, 0, 100, 0, 0, 0, 0, 0, 12, 18089, 1, 300000, 0, 0, 0, 8, 0, 0, 0, 166.7656, 8215.018, 22.63307, 4.604752, 'Fhwoor - On Reached WP43 - Summon Bloodscale Slavedriver'), +(17877, 0, 14, 0, 11, 0, 100, 0, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Spawn Set Active'), +(17877, 0, 15, 0, 40, 0, 100, 0, 44, 17877, 0, 0, 1, 5, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP44 - Say Line 5'), +(17877, 0, 16, 0, 40, 0, 100, 0, 45, 17877, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP45 - Set Run On'), +(17877, 0, 17, 0, 40, 0, 100, 0, 60, 17877, 0, 0, 80, 1787701, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP60 - Run Script 2'), +(17877, 0, 18, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, 1787700, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Quest Accept - Run Script 1'), +(17877, 0, 19, 20, 40, 0, 100, 0, 61, 17877, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 2.042035, 'Fhwoor - On Reached WP61 - Set Orientation'), +(17877, 0, 20, 21, 61, 0, 100, 0, 0, 0, 0, 0, 81, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP61 - Set Npc Flags'), +(17877, 0, 21, 22, 61, 0, 100, 0, 0, 0, 0, 0, 59, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP61 - Turn Run Off'), +(17877, 0, 22, 23, 61, 0, 100, 0, 0, 0, 0, 0, 1, 7, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP61 - Say Line 7'), +(17877, 0, 23, 24, 61, 0, 100, 0, 0, 0, 0, 0, 2, 1709, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP61 - Set Faction'), +(17877, 0, 24, 0, 61, 0, 100, 0, 0, 0, 0, 0, 15, 9729, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Reached WP61 - Complete Quest'), +(17877, 0, 25, 0, 9, 0, 100, 0, 0, 10, 20000, 30000, 11, 31277, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - On Range - Cast Stomp'), +(1787700, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - Script - Set NPC Flags'), +(1787700, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 2, 250, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - Script - Set Faction'), +(1787700, 9, 2, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 53, 0, 17877, 0, 0, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - Script - Start WP'), +(1787701, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 54, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - Script 2 - Pause WP (5 Seconds)'), +(1787701, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Fhwoor - Script 2 - Say Line 6'), +(1787701, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 50, 182082, 180, 0, 0, 0, 0, 8, 0, 0, 0, 249.717, 8482.185, 22.96521, 3.159062, 'Fhwoor - Script 2 - Summon The Ark of Ssslith'); + +DELETE FROM `waypoints` WHERE `entry`IN(17877,18154,18088,18089); +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(17877, 1, 213.6417, 8469.281, 23.52778, 'Fhwoor'), +(17877, 2, 194.8211, 8448.552, 24.48719, 'Fhwoor'), +(17877, 3, 181.9171, 8416.949, 23.39253, 'Fhwoor'), +(17877, 4, 162.9771, 8387.255, 22.28007, 'Fhwoor'), +(17877, 5, 169.1168, 8353.966, 21.07829, 'Fhwoor'), +(17877, 6, 179.16, 8325.873, 20.83087, 'Fhwoor'), +(17877, 7, 170.3557, 8302.857, 21.0235, 'Fhwoor'), +(17877, 8, 182.7192, 8270.847, 18.91084, 'Fhwoor'), +(17877, 9, 220.4595, 8241.914, 20.72861, 'Fhwoor'), +(17877, 10, 248.3627, 8210.217, 19.54621, 'Fhwoor'), +(17877, 11, 283.827, 8203.188, 22.15056, 'Fhwoor'), +(17877, 12, 299.8667, 8188.261, 21.42571, 'Fhwoor'), +(17877, 13, 318.4961, 8184.514, 18.0551, 'Fhwoor'), +(17877, 14, 333.9666, 8178.852, 17.66307, 'Fhwoor'), +(17877, 15, 349.5377, 8179.188, 18.45091, 'Fhwoor'), +(17877, 16, 366.4365, 8187.577, 21.90989, 'Fhwoor'), +(17877, 17, 378.7538, 8190.383, 23.30309, 'Fhwoor'), +(17877, 18, 396.7187, 8184.856, 19.38158, 'Fhwoor'), +(17877, 19, 416.5232, 8164.166, 18.35449, 'Fhwoor'), +(17877, 20, 436.7097, 8153.245, 21.59639, 'Fhwoor'), +(17877, 21, 451.9413, 8151.88, 23.76729, 'Fhwoor'), +(17877, 22, 467.4153, 8152.104, 22.10491, 'Fhwoor'), +(17877, 23, 485.0933, 8148.362, 20.20708, 'Fhwoor'), +(17877, 24, 500.4597, 8146.723, 20.18372, 'Fhwoor'), +(17877, 25, 517.5106, 8156.078, 22.14917, 'Fhwoor'), +(17877, 26, 536.4334, 8157.974, 23.6155, 'Fhwoor'), +(17877, 27, 558.9749, 8159.831, 23.83816, 'Fhwoor'), +(17877, 28, 522.1965, 8135.454, 21.15369, 'Fhwoor'), +(17877, 29, 498.0764, 8136.04, 20.90411, 'Fhwoor'), +(17877, 30, 477.8418, 8127.26, 22.5633, 'Fhwoor'), +(17877, 31, 450.433, 8131.167, 21.50137, 'Fhwoor'), +(17877, 32, 431.7549, 8121.7, 18.242, 'Fhwoor'), +(17877, 33, 416.2102, 8120.498, 17.59649, 'Fhwoor'), +(17877, 34, 394.6256, 8120.143, 17.94713, 'Fhwoor'), +(17877, 35, 379.7412, 8113.295, 17.7740, 'Fhwoor'), +(17877, 36, 364.4443, 8105.485, 18.17426, 'Fhwoor'), +(17877, 37, 350.215, 8106.762, 17.74799, 'Fhwoor'), +(17877, 38, 335.0946, 8119.199, 17.49909, 'Fhwoor'), +(17877, 39, 328.1111, 8135.518, 18.31635, 'Fhwoor'), +(17877, 40, 305.7509, 8149.812, 20.04914, 'Fhwoor'), +(17877, 41, 275.4078, 8161.027, 17.7491, 'Fhwoor'), +(17877, 42, 247.4046, 8177.393, 17.72273, 'Fhwoor'), +(17877, 43, 220.5886, 8180.784, 19.78761, 'Fhwoor'), +(17877, 44, 205.7915, 8183.323, 23.08216, 'Fhwoor'), +(17877, 45, 203.9108, 8206.521, 22.37668, 'Fhwoor'), +(17877, 46, 200.2505, 8229.313, 24.96921, 'Fhwoor'), +(17877, 47, 201.1895, 8251.09, 21.10947, 'Fhwoor'), +(17877, 48, 190.4957, 8267.601, 18.47761, 'Fhwoor'), +(17877, 49, 175.0741, 8288.405, 18.58564, 'Fhwoor'), +(17877, 50, 182.4148, 8311.77, 21.29364, 'Fhwoor'), +(17877, 51, 182.5205, 8333.074, 19.87689, 'Fhwoor'), +(17877, 52, 175.5308, 8357.185, 18.46842, 'Fhwoor'), +(17877, 53, 183.5543, 8381.03, 16.24468, 'Fhwoor'), +(17877, 54, 195.2988, 8399.357, 16.50945, 'Fhwoor'), +(17877, 55, 208.5941, 8413.654, 18.89419, 'Fhwoor'), +(17877, 56, 221.3398, 8432.104, 20.17568, 'Fhwoor'), +(17877, 57, 230.968, 8446.415, 21.99157, 'Fhwoor'), +(17877, 58, 227.1291, 8465.446, 19.64525, 'Fhwoor'), +(17877, 59, 231.5279, 8479.356, 17.87813, 'Fhwoor'), +(17877, 60, 246.9482, 8481.803, 22.1418, 'Fhwoor'), +(17877, 61, 231.4028, 8479.942, 18.03377, 'Fhwoor'), +(18154, 1, 169.4304, 8210.07, 22.51478, 'Ssslith'), +(18154, 2, 169.5868, 8209.083, 22.51478, 'Ssslith'), +(18154, 3, 168.75, 8208.333, 22.80278, 'Ssslith'), +(18154, 4, 168.0234, 8205.424, 23.42778, 'Ssslith'), +(18154, 5, 167.709, 8204.166, 23.80278, 'Ssslith'), +(18154, 6, 167.709, 8202.083, 23.80278, 'Ssslith'), +(18154, 7, 167.709, 8200, 23.60022, 'Ssslith'), +(18154, 8, 170.3105, 8196.961, 22.97522, 'Ssslith'), +(18154, 9, 170.834, 8196.354, 22.85022, 'Ssslith'), +(18154, 10, 171.2306, 8194.351, 22.48486, 'Ssslith'), +(18154, 11, 182.8383, 8183.431, 23.90405, 'Ssslith'), +(18154, 12, 188.6353, 8182.512, 23.86377, 'Ssslith'), +(18088, 1, 172.8497, 8215.886, 22.30278, 'Bloodscale Enchantress'), +(18088, 2, 172.8672, 8214.886, 22.30278, 'Bloodscale Enchantress'), +(18088, 3, 172.0461, 8213.434, 22.35161, 'Bloodscale Enchantress'), +(18088, 4, 176.9391, 8193.834, 23.09314, 'Bloodscale Enchantress'), +(18088, 5, 181.4677, 8187.228, 23.00415, 'Bloodscale Enchantress'), +(18088, 6, 185.6965, 8186.558, 23.32629, 'Bloodscale Enchantress'), +(18089, 1, 166.6959, 8216.016, 22.55278, 'Bloodscale Slavedriver'), +(18089, 2, 166.7656, 8215.018, 22.55278, 'Bloodscale Slavedriver'), +(18089, 3, 165.9063, 8207.064, 23.10177, 'Bloodscale Slavedriver'), +(18089, 4, 165.6914, 8205.076, 23.72677, 'Bloodscale Slavedriver'), +(18089, 5, 164.922, 8197.819, 23.50668, 'Bloodscale Slavedriver'), +(18089, 6, 172.0933, 8188.685, 22.47522, 'Bloodscale Slavedriver'), +(18089, 7, 180.3612, 8180.244, 24.05603, 'Bloodscale Slavedriver'), +(18089, 8, 184.59, 8179.574, 24.47522, 'Bloodscale Slavedriver'); |