DB/Quest: Get Me Out of Here! (Desolace)

1 files changed, 199 insertions, 0 deletions

diff --git a/sql/updates/world/2015_03_28_01_world.sql b/sql/updates/world/2015_03_28_01_world.sql
new file mode 100644
index 00000000000..55c841cd3e6
--- /dev/null
+++ b/sql/updates/world/2015_03_28_01_world.sql
@@ -0,0 +1,199 @@
+-- 
+-- Melizza Brimbuzzle SAI
+SET @ENTRY := 12277;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,1,19,0,100,0,6132,0,0,0,53,0,@ENTRY*100+00,0,0,0,1,1,0,0,0,0,0,0,0,"Melizza Brimbuzzle - On Quest 'Get Me Out of Here!' Taken - Start Waypoint"),
+(@ENTRY,0,1,0,61,0,100,0,6132,0,0,0,81,0,0,0,0,0,0,10,0,0,0,0,0,0,0,"Melizza Brimbuzzle - On Quest 'Get Me Out of Here!' Taken - Set Npc Flag "),
+(@ENTRY,0,2,0,40,0,100,0,3,@ENTRY*100+00,0,0,1,0,0,0,0,0,0,21,20,0,0,0,0,0,0,"Melizza Brimbuzzle - On Waypoint 3 Reached - Say Line 0"),
+(@ENTRY,0,3,4,40,0,100,0,58,@ENTRY*100+00,0,0,15,6132,0,0,0,0,0,17,0,30,0,0,0,0,0,"Melizza Brimbuzzle - On Waypoint 58 Reached - Quest Credit 'Get Me Out of Here!'"),
+(@ENTRY,0,4,5,61,0,100,0,58,@ENTRY*100+00,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Melizza Brimbuzzle - On Waypoint 58 Reached - Say Line 1"),
+(@ENTRY,0,5,6,61,0,100,0,58,@ENTRY*100+00,0,0,53,1,@ENTRY*100+01,0,0,0,0,1,0,0,0,0,0,0,0,"Melizza Brimbuzzle - On Waypoint 58 Reached - Start Waypoint"),
+(@ENTRY,0,6,0,61,0,100,0,58,@ENTRY*100+00,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Melizza Brimbuzzle - On Waypoint 58 Reached - Set Active On"),
+(@ENTRY,0,7,8,40,0,100,0,69,@ENTRY*100+01,0,0,54,10000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Melizza Brimbuzzle - On Waypoint 69 Reached - Pause Waypoint"),
+(@ENTRY,0,8,0,61,0,100,0,69,@ENTRY*100+01,0,0,80,@ENTRY*100+00,0,0,0,0,0,1,0,0,0,0,0,0,0,"Melizza Brimbuzzle - On Waypoint 69 Reached - Run Script"),
+(@ENTRY,0,9,0,40,0,100,0,93,@ENTRY*100+01,0,0,41,3000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Melizza Brimbuzzle - On Waypoint 93 Reached - Despawn In 3000 ms"),
+(@ENTRY,0,10,0,11,0,100,0,0,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Melizza Brimbuzzle - On Respawn - Set Npc Flag Questgiver"),
+(@ENTRY,0,11,0,40,0,100,1,57,@ENTRY*100+00,0,0,80,@ENTRY*100+01,0,0,0,0,0,1,0,0,0,0,0,0,0,"Melizza Brimbuzzle - On Waypoint 57 Reached - Run Script (No Repeat)");
+DELETE FROM `gameobject` WHERE `guid` IN (218966, 232397);
+
+-- Actionlist SAI
+SET @ENTRY := 1227700;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9;
+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
+(@ENTRY,9,0,0,0,0,100,0,3000,3000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Say Line 2"),
+(@ENTRY,9,1,0,0,0,100,0,3000,3000,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Say Line 3"),
+(@ENTRY,9,2,0,0,0,100,0,3000,3000,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Say Line 4");
+
+-- Actionlist SAI
+SET @ENTRY := 1227701;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9;
+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
+(@ENTRY,9,0,0,0,0,100,0,0,0,0,0,12,4655,7,0,0,0,0,8,0,0,0,-1382.56,2417.06,88.9714,2.46091,"Melizza Brimbuzzle - On Script - Summon Creature 'Maraudine Wrangler'"),
+(@ENTRY,9,1,0,0,0,100,0,0,0,0,0,12,4655,7,0,0,0,0,8,0,0,0,-1406.39,2423.48,88.5732,0.20944,"Melizza Brimbuzzle - On Script - Summon Creature 'Maraudine Wrangler'"),
+(@ENTRY,9,2,0,0,0,100,0,0,0,0,0,12,4655,7,0,0,0,0,8,0,0,0,-1394.38,2417.12,88.7675,0.959931,"Melizza Brimbuzzle - On Script - Summon Creature 'Maraudine Wrangler'");
+
+DELETE FROM `creature_text` WHERE `entry`=12277;
+INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
+(12277, 0, 0, 'Thanks $n.  Now let''s get out of here!', 12, 0, 100, 0, 0, 0, 7540, 'Melizza Brimbuzzle'),
+(12277, 1, 0, 'We made it!  Thanks again!  I''m going to run ahead!', 12, 0, 100, 0, 0, 0, 7544, 'Melizza Brimbuzzle'),
+(12277, 2, 0, 'Hey Hornizz!  I''m back!  And there are some people behind me who helped me out of a jam.', 12, 0, 100, 0, 0, 0, 7550, 'Melizza Brimbuzzle'),
+(12277, 3, 0, 'We''re going to have to scratch the Maraudines off our list.  Too hard to work with...', 12, 0, 100, 0, 0, 0, 7551, 'Melizza Brimbuzzle'),
+(12277, 4, 0, 'Well, I''m off to the Gelkis.  They''re not as dumb as the Maraudines, but they''re more reasonable.', 12, 0, 100, 0, 0, 0, 7552, 'Melizza Brimbuzzle');
+
+SET @PATH := 1227700;
+SET @PATH_TWO := 1227701;
+DELETE FROM `waypoints` WHERE `entry` IN (@PATH, @PATH_TWO);
+INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES 
+(@PATH,1,-1155.146,2709.409,111.2361,'Melizza Brimbuzzle'),
+(@PATH,2,-1155.146,2709.409,111.2361,'Melizza Brimbuzzle'),
+(@PATH,3,-1162.785,2712.464,111.5828,'Melizza Brimbuzzle'),
+(@PATH,4,-1162.752,2712.397,111.6417,'Melizza Brimbuzzle'),
+(@PATH,5,-1169.502,2711.397,112.3917,'Melizza Brimbuzzle'),
+(@PATH,6,-1177.48,2710.258,112.1255,'Melizza Brimbuzzle'),
+(@PATH,7,-1199.98,2702.508,111.6255,'Melizza Brimbuzzle'),
+(@PATH,8,-1206.389,2700.128,111.496,'Melizza Brimbuzzle'),
+(@PATH,9,-1248.919,2680.271,111.8919,'Melizza Brimbuzzle'),
+(@PATH,10,-1272.489,2666.548,111.8956,'Melizza Brimbuzzle'),
+(@PATH,11,-1288.82,2646.104,111.7111,'Melizza Brimbuzzle'),
+(@PATH,12,-1290.413,2644.388,111.6542,'Melizza Brimbuzzle'),
+(@PATH,13,-1290.413,2644.388,111.6542,'Melizza Brimbuzzle'),
+(@PATH,14,-1290.413,2644.388,111.6542,'Melizza Brimbuzzle'),
+(@PATH,15,-1309.874,2622.18,111.7776,'Melizza Brimbuzzle'),
+(@PATH,16,-1309.908,2622.186,111.9743,'Melizza Brimbuzzle'),
+(@PATH,17,-1323.898,2605.008,111.8986,'Melizza Brimbuzzle'),
+(@PATH,18,-1336.769,2591.199,111.8607,'Melizza Brimbuzzle'),
+(@PATH,19,-1349.322,2578.486,111.7647,'Melizza Brimbuzzle'),
+(@PATH,20,-1359.602,2564.017,111.4906,'Melizza Brimbuzzle'),
+(@PATH,21,-1361.852,2559.517,110.7406,'Melizza Brimbuzzle'),
+(@PATH,22,-1362.352,2557.767,109.9906,'Melizza Brimbuzzle'),
+(@PATH,23,-1363.102,2556.267,109.4906,'Melizza Brimbuzzle'),
+(@PATH,24,-1364.602,2553.517,108.9906,'Melizza Brimbuzzle'),
+(@PATH,25,-1365.352,2551.767,108.2406,'Melizza Brimbuzzle'),
+(@PATH,26,-1366.102,2550.017,107.7406,'Melizza Brimbuzzle'),
+(@PATH,27,-1366.477,2549.685,107.5719,'Melizza Brimbuzzle'),
+(@PATH,28,-1366.727,2549.185,107.0719,'Melizza Brimbuzzle'),
+(@PATH,29,-1367.227,2547.185,106.8219,'Melizza Brimbuzzle'),
+(@PATH,30,-1367.727,2545.185,106.0719,'Melizza Brimbuzzle'),
+(@PATH,31,-1368.477,2543.435,105.3219,'Melizza Brimbuzzle'),
+(@PATH,32,-1368.977,2541.435,104.5719,'Melizza Brimbuzzle'),
+(@PATH,33,-1369.477,2539.435,103.8219,'Melizza Brimbuzzle'),
+(@PATH,34,-1370.227,2536.685,103.3219,'Melizza Brimbuzzle'),
+(@PATH,35,-1370.977,2534.685,102.5719,'Melizza Brimbuzzle'),
+(@PATH,36,-1371.227,2532.935,102.0719,'Melizza Brimbuzzle'),
+(@PATH,37,-1371.727,2531.185,101.3219,'Melizza Brimbuzzle'),
+(@PATH,38,-1372.227,2529.185,100.8219,'Melizza Brimbuzzle'),
+(@PATH,39,-1372.977,2527.185,100.0719,'Melizza Brimbuzzle'),
+(@PATH,40,-1373.727,2524.435,99.32188,'Melizza Brimbuzzle'),
+(@PATH,41,-1374.227,2522.435,98.57188,'Melizza Brimbuzzle'),
+(@PATH,42,-1374.727,2520.685,97.82188,'Melizza Brimbuzzle'),
+(@PATH,43,-1375.477,2518.685,97.32188,'Melizza Brimbuzzle'),
+(@PATH,44,-1375.639,2518.402,97.00177,'Melizza Brimbuzzle'),
+(@PATH,45,-1375.889,2517.152,96.75177,'Melizza Brimbuzzle'),
+(@PATH,46,-1376.389,2515.152,96.00177,'Melizza Brimbuzzle'),
+(@PATH,47,-1376.889,2513.402,95.25177,'Melizza Brimbuzzle'),
+(@PATH,48,-1378.139,2509.402,93.75177,'Melizza Brimbuzzle'),
+(@PATH,49,-1378.389,2507.652,93.00177,'Melizza Brimbuzzle'),
+(@PATH,50,-1379.139,2504.902,92.50177,'Melizza Brimbuzzle'),
+(@PATH,51,-1379.889,2501.902,91.75177,'Melizza Brimbuzzle'),
+(@PATH,52,-1380.389,2500.152,91.25177,'Melizza Brimbuzzle'),
+(@PATH,53,-1381.389,2496.152,90.50177,'Melizza Brimbuzzle'),
+(@PATH,54,-1381.559,2495.931,90.14986,'Melizza Brimbuzzle'),
+(@PATH,55,-1381.809,2495.431,90.14986,'Melizza Brimbuzzle'),
+(@PATH,56,-1382.309,2491.431,89.64986,'Melizza Brimbuzzle'),
+(@PATH,57,-1385.493,2471.513,89.11208,'Melizza Brimbuzzle'),
+(@PATH,58,-1386.618,2405.71,89.767,'Melizza Brimbuzzle'),
+(@PATH_TWO,1,-1385.368,2401.21,90.267,'Melizza Brimbuzzle'),
+(@PATH_TWO,2,-1383.618,2395.46,90.767,'Melizza Brimbuzzle'),
+(@PATH_TWO,3,-1382.118,2390.71,91.517,'Melizza Brimbuzzle'),
+(@PATH_TWO,4,-1377.252,2375.137,91.91622,'Melizza Brimbuzzle'),
+(@PATH_TWO,5,-1373.759,2355.208,92.06256,'Melizza Brimbuzzle'),
+(@PATH_TWO,6,-1366.36,2323.406,91.9967,'Melizza Brimbuzzle'),
+(@PATH_TWO,7,-1362.618,2277.267,91.79288,'Melizza Brimbuzzle'),
+(@PATH_TWO,8,-1358.118,2257.017,91.54288,'Melizza Brimbuzzle'),
+(@PATH_TWO,9,-1354.14,2239.229,91.62033,'Melizza Brimbuzzle'),
+(@PATH_TWO,10,-1352.89,2229.729,92.12033,'Melizza Brimbuzzle'),
+(@PATH_TWO,11,-1350.869,2214.848,91.63843,'Melizza Brimbuzzle'),
+(@PATH_TWO,12,-1351.869,2210.848,90.88843,'Melizza Brimbuzzle'),
+(@PATH_TWO,13,-1352.119,2209.848,90.13843,'Melizza Brimbuzzle'),
+(@PATH_TWO,14,-1352.619,2208.098,89.13843,'Melizza Brimbuzzle'),
+(@PATH_TWO,15,-1352.869,2207.098,87.88843,'Melizza Brimbuzzle'),
+(@PATH_TWO,16,-1353.119,2206.098,86.38843,'Melizza Brimbuzzle'),
+(@PATH_TWO,17,-1353.369,2205.348,85.38843,'Melizza Brimbuzzle'),
+(@PATH_TWO,18,-1353.619,2204.348,84.38843,'Melizza Brimbuzzle'),
+(@PATH_TWO,19,-1354.119,2202.348,83.63843,'Melizza Brimbuzzle'),
+(@PATH_TWO,20,-1354.369,2201.348,82.88843,'Melizza Brimbuzzle'),
+(@PATH_TWO,21,-1354.619,2200.598,82.13843,'Melizza Brimbuzzle'),
+(@PATH_TWO,22,-1354.869,2199.598,81.38843,'Melizza Brimbuzzle'),
+(@PATH_TWO,23,-1355.119,2198.598,80.63843,'Melizza Brimbuzzle'),
+(@PATH_TWO,24,-1355.119,2197.598,79.88843,'Melizza Brimbuzzle'),
+(@PATH_TWO,25,-1355.619,2195.598,78.88843,'Melizza Brimbuzzle'),
+(@PATH_TWO,26,-1356.119,2193.848,77.88843,'Melizza Brimbuzzle'),
+(@PATH_TWO,27,-1356.619,2191.848,77.13843,'Melizza Brimbuzzle'),
+(@PATH_TWO,28,-1357.619,2188.848,76.38843,'Melizza Brimbuzzle'),
+(@PATH_TWO,29,-1355.239,2198.246,80.43513,'Melizza Brimbuzzle'),
+(@PATH_TWO,30,-1355.489,2197.246,79.68513,'Melizza Brimbuzzle'),
+(@PATH_TWO,31,-1355.989,2195.496,78.68513,'Melizza Brimbuzzle'),
+(@PATH_TWO,32,-1356.489,2193.496,77.68513,'Melizza Brimbuzzle'),
+(@PATH_TWO,33,-1356.989,2191.496,76.93513,'Melizza Brimbuzzle'),
+(@PATH_TWO,34,-1357.739,2188.746,76.18513,'Melizza Brimbuzzle'),
+(@PATH_TWO,35,-1357.989,2187.496,75.68513,'Melizza Brimbuzzle'),
+(@PATH_TWO,36,-1358.739,2185.746,75.18513,'Melizza Brimbuzzle'),
+(@PATH_TWO,37,-1359.239,2183.746,74.43513,'Melizza Brimbuzzle'),
+(@PATH_TWO,38,-1359.989,2181.996,73.68513,'Melizza Brimbuzzle'),
+(@PATH_TWO,39,-1360.489,2179.996,72.93513,'Melizza Brimbuzzle'),
+(@PATH_TWO,40,-1361.489,2177.246,72.18513,'Melizza Brimbuzzle'),
+(@PATH_TWO,41,-1362.239,2175.246,71.68513,'Melizza Brimbuzzle'),
+(@PATH_TWO,42,-1362.739,2173.496,70.93513,'Melizza Brimbuzzle'),
+(@PATH_TWO,43,-1363.239,2171.746,70.43513,'Melizza Brimbuzzle'),
+(@PATH_TWO,44,-1363.739,2169.746,69.68513,'Melizza Brimbuzzle'),
+(@PATH_TWO,45,-1364.739,2166.996,68.68513,'Melizza Brimbuzzle'),
+(@PATH_TWO,46,-1365.489,2164.996,67.68513,'Melizza Brimbuzzle'),
+(@PATH_TWO,47,-1365.989,2163.246,66.68513,'Melizza Brimbuzzle'),
+(@PATH_TWO,48,-1366.739,2161.246,65.93513,'Melizza Brimbuzzle'),
+(@PATH_TWO,49,-1367.489,2159.496,64.68513,'Melizza Brimbuzzle'),
+(@PATH_TWO,50,-1367.989,2157.496,63.93513,'Melizza Brimbuzzle'),
+(@PATH_TWO,51,-1368.989,2154.746,63.18513,'Melizza Brimbuzzle'),
+(@PATH_TWO,52,-1369.739,2152.746,62.43513,'Melizza Brimbuzzle'),
+(@PATH_TWO,53,-1370.239,2150.996,61.68513,'Melizza Brimbuzzle'),
+(@PATH_TWO,54,-1370.989,2148.996,60.93513,'Melizza Brimbuzzle'),
+(@PATH_TWO,55,-1369.163,2154.362,62.88633,'Melizza Brimbuzzle'),
+(@PATH_TWO,56,-1369.913,2152.612,62.63633,'Melizza Brimbuzzle'),
+(@PATH_TWO,57,-1370.413,2150.612,61.63633,'Melizza Brimbuzzle'),
+(@PATH_TWO,58,-1371.163,2148.862,61.13633,'Melizza Brimbuzzle'),
+(@PATH_TWO,59,-1371.663,2147.612,60.63633,'Melizza Brimbuzzle'),
+(@PATH_TWO,60,-1374.663,2142.362,60.13633,'Melizza Brimbuzzle'),
+(@PATH_TWO,61,-1381.413,2131.612,60.88633,'Melizza Brimbuzzle'),
+(@PATH_TWO,62,-1387.413,2121.362,61.38633,'Melizza Brimbuzzle'),
+(@PATH_TWO,63,-1391.413,2114.362,62.13633,'Melizza Brimbuzzle'),
+(@PATH_TWO,64,-1395.163,2108.362,62.63633,'Melizza Brimbuzzle'),
+(@PATH_TWO,65,-1391.807,2114.246,61.76419,'Melizza Brimbuzzle'),
+(@PATH_TWO,66,-1395.307,2108.246,62.26419,'Melizza Brimbuzzle'),
+(@PATH_TWO,67,-1396.307,2106.496,62.51419,'Melizza Brimbuzzle'),
+(@PATH_TWO,68,-1404.391,2088.967,62.0089,'Melizza Brimbuzzle'),
+(@PATH_TWO,69,-1405.748,2087.39,62.09642,'Melizza Brimbuzzle'),
+(@PATH_TWO,70,-1407.248,2086.89,62.09642,'Melizza Brimbuzzle'),
+(@PATH_TWO,71,-1408.248,2086.89,62.34642,'Melizza Brimbuzzle'),
+(@PATH_TWO,72,-1410.498,2086.39,62.34642,'Melizza Brimbuzzle'),
+(@PATH_TWO,73,-1412.498,2086.39,62.59642,'Melizza Brimbuzzle'),
+(@PATH_TWO,74,-1413.998,2085.39,62.59642,'Melizza Brimbuzzle'),
+(@PATH_TWO,75,-1415.498,2083.39,62.59642,'Melizza Brimbuzzle'),
+(@PATH_TWO,76,-1416.498,2082.39,62.59642,'Melizza Brimbuzzle'),
+(@PATH_TWO,77,-1417.498,2079.39,62.59642,'Melizza Brimbuzzle'),
+(@PATH_TWO,78,-1417.998,2077.39,62.59642,'Melizza Brimbuzzle'),
+(@PATH_TWO,79,-1419.998,2075.14,62.59642,'Melizza Brimbuzzle'),
+(@PATH_TWO,80,-1424.748,2073.14,62.34642,'Melizza Brimbuzzle'),
+(@PATH_TWO,81,-1418.114,2077.1,62.59175,'Melizza Brimbuzzle'),
+(@PATH_TWO,82,-1420.364,2075.35,62.59175,'Melizza Brimbuzzle'),
+(@PATH_TWO,83,-1425.114,2073.1,62.34175,'Melizza Brimbuzzle'),
+(@PATH_TWO,84,-1425.114,2075.1,62.34175,'Melizza Brimbuzzle'),
+(@PATH_TWO,85,-1436.864,2074.35,62.84175,'Melizza Brimbuzzle'),
+(@PATH_TWO,86,-1451.277,2073.542,62.70998,'Melizza Brimbuzzle'),
+(@PATH_TWO,87,-1464.777,2075.542,62.95998,'Melizza Brimbuzzle'),
+(@PATH_TWO,88,-1465.031,2075.661,62.89689,'Melizza Brimbuzzle'),
+(@PATH_TWO,89,-1473.031,2077.161,63.14689,'Melizza Brimbuzzle'),
+(@PATH_TWO,90,-1480.031,2086.411,62.39689,'Melizza Brimbuzzle'),
+(@PATH_TWO,91,-1485.531,2093.411,61.89689,'Melizza Brimbuzzle'),
+(@PATH_TWO,92,-1485.639,2093.875,61.82396,'Melizza Brimbuzzle'),
+(@PATH_TWO,93,-1487.889,2096.375,61.82396,'Melizza Brimbuzzle');