DB/Quests: fix The Scarlet Oracle, Demetria (Closes #7773) and The Call to Command quest chain (Closes #7673)

DB/Creature: fixes sound for Twilight Lord Kelris (Closes #7309)

1 files changed, 320 insertions, 0 deletions

diff --git a/sql/updates/world/2012_09_17_02_world_misc.sql b/sql/updates/world/2012_09_17_02_world_misc.sql
new file mode 100644
index 00000000000..0b6a3b2237c
--- /dev/null
+++ b/sql/updates/world/2012_09_17_02_world_misc.sql
@@ -0,0 +1,320 @@
+-- The Call to Command (6144, 6145, 6146, 14349, 14350) quest chain fix by nelegalno
+-- The first 2 quests in the chain ware replaced with new ones after the removal of Varimathras (2425) but players that completed
+-- the old quests shouldn't get the new ones and the third quest Nathanos' Ruse (6146) should require 6145 or 14350 completed 
+
+-- The Call to Command ExclusiveGroup
+UPDATE `quest_template` SET `ExclusiveGroup` = 6144 WHERE `Id` = 6144; -- The Call to Command (6144) quest
+UPDATE `quest_template` SET `ExclusiveGroup` = 6144 WHERE `Id` = 14349; -- The Call to Command (14349) quest
+
+-- You should be able to take the quest from Varimathras (2425) or Lady Sylvanas Windrunner (10181) [proof http://old.wowhead.com/quest=6145]
+DELETE FROM `creature_questrelation` WHERE `quest` = 6145;
+INSERT INTO `creature_questrelation` (`id`,`quest`) VALUES (2425, 6145);
+INSERT INTO `creature_questrelation` (`id`,`quest`) VALUES (10181, 6145);
+
+-- The Crimson Courier ExclusiveGroup
+UPDATE `quest_template` SET `ExclusiveGroup` = 6145 WHERE `Id` = 6145; -- The Crimson Courier (6145) quest
+UPDATE `quest_template` SET `ExclusiveGroup` = 6145 WHERE `Id` = 14350; -- The Crimson Courier (14350) quest
+
+-- Nathanos' Ruse PrevQuestId conditions
+UPDATE `quest_template` SET `PrevQuestId` = 0 WHERE `Id` = 6146;
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry`=6146;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(19,0,6146,0,1,8,0, 6145,0,0,0,0,'',"Nathanos' Ruse requires quest The Crimson Courier (6145)"),
+(19,0,6146,0,2,8,0,14350,0,0,0,0,'',"Nathanos' Ruse requires quest The Crimson Courier (14350)");
+
+
+-- The Scarlet Oracle, Demetria (6148) quest fix by nelegalno
+-- TODO: NPC must spawn when the quest is acepted
+SET @ID := 12339;
+SET @GUID := 42575; -- set by TDB team
+
+DELETE FROM `creature` WHERE `id`=@ID;
+INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
+(@GUID,@ID,0,1,1,0,0,1567.16,-5611,114.19,1.084,900,0,1,26412,35250,2,0,0,0);
+
+DELETE FROM `creature_template_addon` WHERE `entry`=@ID;
+INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
+(@ID,@ID,0,0,0,0,'');
+
+DELETE FROM `waypoint_data` WHERE `id`=@ID;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@ID,1,1567.42,-5610.38,114.189,0,0,0,0,100,0),
+(@ID,2,1564.17,-5609.18,114.183,0,0,0,0,100,0),
+(@ID,3,1566.34,-5605.47,114.183,0,0,0,0,100,0),
+(@ID,4,1569.38,-5606.32,114.188,0,0,0,0,100,0),
+(@ID,5,1573.89,-5597.87,111.171,0,0,0,0,100,0),
+(@ID,6,1578.76,-5588.57,111.171,0,0,0,0,100,0),
+(@ID,7,1585.31,-5576.2,111.171,0,0,0,0,100,0),
+(@ID,8,1594.85,-5557.49,111.171,0,0,0,0,100,0),
+(@ID,9,1603.55,-5557.01,111.171,0,0,0,0,100,0),
+(@ID,10,1610.81,-5541.87,111.171,0,0,0,0,100,0),
+(@ID,11,1604.87,-5538.01,111.171,0,0,0,0,100,0),
+(@ID,12,1612.66,-5523.97,111.147,0,0,0,0,100,0),
+(@ID,13,1618.32,-5514.03,107.117,0,0,0,0,100,0),
+(@ID,14,1627.73,-5496.36,100.729,0,0,0,0,100,0),
+(@ID,15,1633,-5484.04,100.729,0,0,0,0,100,0),
+(@ID,16,1638.35,-5469.5,98.6581,0,0,0,0,100,0),
+(@ID,17,1645.41,-5450.02,92.1866,0,0,0,0,100,0),
+(@ID,18,1652.78,-5430.76,84.4578,0,0,0,0,100,0),
+(@ID,19,1657.93,-5416.62,79.8772,0,0,0,0,100,0),
+(@ID,20,1661.83,-5406.66,76.2934,0,0,0,0,100,0),
+(@ID,21,1669.8,-5383.78,73.6196,0,0,0,0,100,0),
+(@ID,22,1677.99,-5358.84,73.6117,0,0,0,0,100,0),
+(@ID,23,1695.25,-5350.09,73.6118,0,0,0,0,100,0),
+(@ID,24,1687.04,-5321.94,73.6112,0,0,0,0,100,0),
+(@ID,25,1688.58,-5304.51,73.6112,0,0,0,0,100,0),
+(@ID,26,1691,-5283.65,73.6122,0,0,0,0,100,0),
+(@ID,27,1691.91,-5262.08,73.6113,0,0,0,0,100,0),
+(@ID,28,1692.66,-5241.1,73.6185,0,0,0,0,100,0),
+(@ID,29,1692.85,-5206.13,74.6546,0,0,0,0,100,0),
+(@ID,30,1690.64,-5185.28,73.9301,0,0,0,0,100,0),
+(@ID,31,1688.08,-5167.96,73.9937,0,0,0,0,100,0),
+(@ID,32,1690.38,-5149.03,74.0396,0,0,0,0,100,0),
+(@ID,33,1697.51,-5118.86,73.6245,0,0,0,0,100,0),
+(@ID,34,1704.67,-5099.13,74.6873,0,0,0,0,100,0),
+(@ID,35,1711.01,-5080.54,77.301,0,0,0,0,100,0),
+(@ID,36,1718.55,-5057.22,80.1628,0,0,0,0,100,0),
+(@ID,37,1730.24,-5032.73,80.6236,0,0,0,0,100,0),
+(@ID,38,1742.91,-5011.79,79.9012,0,0,0,0,100,0),
+(@ID,39,1754.95,-4994.6,80.643,0,0,0,0,100,0),
+(@ID,40,1766.67,-4977.18,81.2274,0,0,0,0,100,0),
+(@ID,41,1773.03,-4950.42,81.449,0,0,0,0,100,0),
+(@ID,42,1777.47,-4922.77,81.5212,0,0,0,0,100,0),
+(@ID,43,1782.09,-4902.3,84.2517,0,0,0,0,100,0),
+(@ID,44,1788.34,-4877.56,87.4965,0,0,0,0,100,0),
+(@ID,45,1796.57,-4845.8,89.4469,0,0,0,0,100,0),
+(@ID,46,1809.45,-4798.58,91.0304,0,0,0,0,100,0),
+(@ID,47,1816.93,-4777.84,90.0115,0,0,0,0,100,0),
+(@ID,48,1831.75,-4734.83,90.0915,0,0,0,0,100,0),
+(@ID,49,1862.63,-4701.05,93.0158,0,0,0,0,100,0),
+(@ID,50,1889.08,-4684.05,92.355,0,0,0,0,100,0),
+(@ID,51,1910.74,-4672.59,91.1087,0,0,0,0,100,0),
+(@ID,52,1927.94,-4658.95,87.5957,0,0,0,0,100,0),
+(@ID,53,1935.76,-4647.33,84.3063,0,0,0,0,100,0),
+(@ID,54,1944.66,-4632.27,79.9795,0,0,0,0,100,0),
+(@ID,55,1954.98,-4609.24,74.7545,0,0,0,0,100,0),
+(@ID,56,1958.16,-4599.23,73.7161,0,0,0,0,100,0),
+(@ID,57,1968.46,-4572.57,73.6229,0,0,0,0,100,0),
+(@ID,58,1979.44,-4555.29,73.6229,0,0,0,0,100,0),
+(@ID,59,1984,-4549.99,73.6229,0,0,0,0,100,0),
+(@ID,60,1996.94,-4538.24,73.6229,0,0,0,0,100,0),
+(@ID,61,2005.36,-4531.97,73.6229,0,0,0,0,100,0),
+(@ID,62,2016.76,-4523.84,73.6213,0,0,0,0,100,0),
+(@ID,63,2027.83,-4517.97,73.6213,0,0,0,0,100,0),
+(@ID,64,2045.28,-4518.38,73.6213,0,0,0,0,100,0),
+(@ID,65,2061.31,-4534.8,73.6213,0,0,0,0,100,0),
+(@ID,66,2086.08,-4561.88,73.6213,0,0,0,0,100,0),
+(@ID,67,2105.32,-4580.45,73.6238,0,0,0,0,100,0),
+(@ID,68,2121.3,-4594.16,73.6238,0,0,0,0,100,0),
+(@ID,69,2146.73,-4612.71,73.6218,0,0,0,0,100,0),
+(@ID,70,2177.86,-4627.43,73.6067,0,0,0,0,100,0),
+(@ID,71,2197.77,-4633.93,73.6226,0,0,0,0,100,0),
+(@ID,72,2219.97,-4633.96,73.6226,0,0,0,0,100,0),
+(@ID,73,2250.74,-4627.66,73.6226,0,0,0,0,100,0),
+(@ID,74,2274.12,-4620.36,73.6226,0,0,0,0,100,0),
+(@ID,75,2304.25,-4611.22,73.6227,0,0,0,0,100,0),
+(@ID,76,2338.64,-4604.74,73.6227,0,0,0,0,100,0),
+(@ID,77,2389.36,-4603.99,73.6227,0,0,0,0,100,0),
+(@ID,78,2457.27,-4631.39,74.092,0,0,0,0,100,0),
+(@ID,79,2493.9,-4652.17,75.2848,0,0,0,0,100,0),
+(@ID,80,2535.82,-4654.52,77.3071,0,0,0,0,100,0),
+(@ID,81,2567.1,-4644.61,79.4072,0,0,0,0,100,0),
+(@ID,82,2594.36,-4628.84,81.876,0,0,0,0,100,0),
+(@ID,83,2617.07,-4615.06,84.1387,0,0,0,0,100,0),
+(@ID,84,2689.76,-4571.94,87.2045,0,0,0,0,100,0),
+(@ID,85,2745.8,-4539.07,88.764,0,0,0,0,100,0),
+(@ID,86,2839.33,-4436.83,89.7157,0,0,0,0,100,0),
+(@ID,87,2880.41,-4361.54,90.2576,0,0,0,0,100,0),
+(@ID,88,2923.76,-4110.16,96.3698,0,0,0,0,100,0),
+(@ID,89,2947.2,-4033.15,99.8002,0,0,0,0,100,0),
+(@ID,90,2968.64,-3982.02,104.423,0,0,0,0,100,0),
+(@ID,91,2976.9,-3964.26,107.058,0,0,0,0,100,0),
+(@ID,92,2983.54,-3937.96,111.717,0,0,0,0,100,0),
+(@ID,93,3000.21,-3877.74,118.93,0,0,0,0,100,0),
+(@ID,94,3011.92,-3842.22,119.306,0,0,0,0,100,0),
+(@ID,95,3021.88,-3813.28,118.955,0,0,0,0,100,0),
+(@ID,96,3028.71,-3797.17,120.17,0,0,0,0,100,0),
+(@ID,97,3042.19,-3764.47,119.971,0,0,0,0,100,0),
+(@ID,98,3057.23,-3724.98,119.568,0,0,0,0,100,0),
+(@ID,99,3062.31,-3690.16,121.125,0,0,0,0,100,0),
+(@ID,100,3048.16,-3659.65,122.811,0,0,0,0,100,0),
+(@ID,101,3041.49,-3641.07,125.02,0,0,0,0,100,0),
+(@ID,102,3039.91,-3617.72,123.977,0,0,0,0,100,0),
+(@ID,103,3040.67,-3597.35,124.377,0,0,0,0,100,0),
+(@ID,104,3042.45,-3556.22,126.571,0,0,0,0,100,0),
+(@ID,105,3046.02,-3530.23,129.898,0,0,0,0,100,0),
+(@ID,106,3057.06,-3493.26,131.601,0,0,0,0,100,0),
+(@ID,107,3076.38,-3462.24,134.709,0,0,0,0,100,0),
+(@ID,108,3086.02,-3451.18,136,0,0,0,0,100,0),
+(@ID,109,3097.45,-3438.57,136.842,0,0,0,0,100,0),
+(@ID,110,3133.22,-3404.77,139.345,0,0,0,0,100,0),
+(@ID,111,3150.28,-3401.16,140.105,0,0,0,0,100,0),
+(@ID,112,3172.46,-3393.09,142.015,0,0,0,0,100,0),
+(@ID,113,3191.09,-3389.1,143.607,0,0,0,0,100,0),
+(@ID,114,3210.72,-3387.02,144.24,0,0,0,0,100,0),
+(@ID,115,3250.95,-3382.95,143.581,0,0,0,0,100,0),
+(@ID,116,3269.06,-3382.33,143.195,0,0,0,0,100,0),
+(@ID,117,3286.95,-3382.42,142.377,0,0,0,0,100,0),
+(@ID,118,3307.89,-3382.95,144.951,0,0,0,0,100,0),
+(@ID,119,3329.2,-3382.28,144.845,0,0,0,0,100,0),
+(@ID,120,3347.55,-3381.64,144.779,0,0,0,0,100,0),
+(@ID,121,3361.09,-3380.75,144.781,0,0,0,0,100,0),
+(@ID,122,3339.81,-3380.58,144.774,0,0,0,0,100,0),
+(@ID,123,3311.44,-3380.27,145.017,0,0,0,0,100,0),
+(@ID,124,3296.01,-3380.1,143.741,0,0,0,0,100,0),
+(@ID,125,3274.59,-3380.86,142.727,0,0,0,0,100,0),
+(@ID,126,3274.59,-3380.86,142.727,0,0,0,0,100,0),
+(@ID,127,3251.44,-3382.31,143.585,0,0,0,0,100,0),
+(@ID,128,3217.38,-3385.87,144.301,0,0,0,0,100,0),
+(@ID,129,3189.08,-3389.3,143.545,0,0,0,0,100,0),
+(@ID,130,3168.36,-3392.69,141.758,0,0,0,0,100,0),
+(@ID,131,3128.73,-3405.3,139.154,0,0,0,0,100,0),
+(@ID,132,3104.29,-3429.73,137.697,0,0,0,0,100,0),
+(@ID,133,3079.44,-3458.29,135.39,0,0,0,0,100,0),
+(@ID,134,3062.03,-3484.05,132.59,0,0,0,0,100,0),
+(@ID,135,3051.15,-3508.73,131.122,0,0,0,0,100,0),
+(@ID,136,3044.5,-3543.07,128.53,0,0,0,0,100,0),
+(@ID,137,3040.58,-3585.59,124.369,0,0,0,0,100,0),
+(@ID,138,3040.05,-3618.85,124.055,0,0,0,0,100,0),
+(@ID,139,3041.87,-3636.23,125.378,0,0,0,0,100,0),
+(@ID,140,3048.01,-3656.25,122.83,0,0,0,0,100,0),
+(@ID,141,3059.89,-3685.41,121.254,0,0,0,0,100,0),
+(@ID,142,3063.62,-3704.59,120.885,0,0,0,0,100,0),
+(@ID,143,3049.97,-3743.53,120.437,0,0,0,0,100,0),
+(@ID,144,3038.77,-3773.26,119.728,0,0,0,0,100,0),
+(@ID,145,3029.37,-3797.56,120.123,0,0,0,0,100,0),
+(@ID,146,3017.78,-3822.93,118.882,0,0,0,0,100,0),
+(@ID,147,3011.9,-3841.29,119.307,0,0,0,0,100,0),
+(@ID,148,2999.1,-3881.4,118.595,0,0,0,0,100,0),
+(@ID,149,2992.82,-3899.77,116.742,0,0,0,0,100,0),
+(@ID,150,2987.35,-3919.01,114.686,0,0,0,0,100,0),
+(@ID,151,2979.54,-3951.23,108.575,0,0,0,0,100,0),
+(@ID,152,2974.35,-3965.01,106.582,0,0,0,0,100,0),
+(@ID,153,2965.39,-3989.01,103.564,0,0,0,0,100,0),
+(@ID,154,2947.58,-4032.49,99.8551,0,0,0,0,100,0),
+(@ID,155,2940.68,-4050.84,98.8149,0,0,0,0,100,0),
+(@ID,156,2927.47,-4095.16,96.9418,0,0,0,0,100,0),
+(@ID,157,2922.28,-4117.41,96.1034,0,0,0,0,100,0),
+(@ID,158,2916.91,-4141.33,95.1063,0,0,0,0,100,0),
+(@ID,159,2912.33,-4161.43,94.1942,0,0,0,0,100,0),
+(@ID,160,2906.67,-4194.05,92.8009,0,0,0,0,100,0),
+(@ID,161,2902.22,-4224.72,91.8676,0,0,0,0,100,0),
+(@ID,162,2898.62,-4254.12,91.3725,0,0,0,0,100,0),
+(@ID,163,2896.84,-4270.08,91.1643,0,0,0,0,100,0),
+(@ID,164,2892.88,-4300.96,90.6728,0,0,0,0,100,0),
+(@ID,165,2882.86,-4347.85,90.3236,0,0,0,0,100,0),
+(@ID,166,2875.88,-4369.2,90.0259,0,0,0,0,100,0),
+(@ID,167,2866.06,-4388.72,89.6369,0,0,0,0,100,0),
+(@ID,168,2855.15,-4407.04,89.3003,0,0,0,0,100,0),
+(@ID,169,2844.51,-4424.87,89.4741,0,0,0,0,100,0),
+(@ID,170,2835.01,-4439.19,89.6752,0,0,0,0,100,0),
+(@ID,171,2825.9,-4452.37,89.8312,0,0,0,0,100,0),
+(@ID,172,2781.37,-4503.54,89.6992,0,0,0,0,100,0),
+(@ID,173,2768.3,-4516.57,89.4068,0,0,0,0,100,0),
+(@ID,174,2751.64,-4531.98,88.9045,0,0,0,0,100,0),
+(@ID,175,2738.52,-4542.49,88.4996,0,0,0,0,100,0),
+(@ID,176,2714.09,-4557.62,87.6424,0,0,0,0,100,0),
+(@ID,177,2699.67,-4566.29,87.4294,0,0,0,0,100,0),
+(@ID,178,2684.52,-4575.58,87.001,0,0,0,0,100,0),
+(@ID,179,2667.22,-4586.17,85.7211,0,0,0,0,100,0),
+(@ID,180,2630.76,-4606.45,84.5909,0,0,0,0,100,0),
+(@ID,181,2618.07,-4614.37,84.1965,0,0,0,0,100,0),
+(@ID,182,2592.51,-4629.78,81.6831,0,0,0,0,100,0),
+(@ID,183,2570.53,-4643.56,79.6884,0,0,0,0,100,0),
+(@ID,184,2558.75,-4648.16,78.7332,0,0,0,0,100,0),
+(@ID,185,2544.22,-4651.95,77.8191,0,0,0,0,100,0),
+(@ID,186,2528.11,-4654.63,76.8986,0,0,0,0,100,0),
+(@ID,187,2511.76,-4655.66,76.0362,0,0,0,0,100,0),
+(@ID,188,2487.63,-4647.41,75.1608,0,0,0,0,100,0),
+(@ID,189,2467.38,-4636.04,74.6576,0,0,0,0,100,0),
+(@ID,190,2453.17,-4627.91,73.6226,0,0,0,0,100,0),
+(@ID,191,2437.83,-4620.44,73.6179,0,0,0,0,100,0),
+(@ID,192,2425.09,-4614.63,73.613,0,0,0,0,100,0),
+(@ID,193,2401.34,-4604.92,73.6229,0,0,0,0,100,0),
+(@ID,194,2367.28,-4602.14,73.6229,0,0,0,0,100,0),
+(@ID,195,2348.43,-4603.85,73.6229,0,0,0,0,100,0),
+(@ID,196,2312.07,-4610.25,73.6226,0,0,0,0,100,0),
+(@ID,197,2289.67,-4616.1,73.6237,0,0,0,0,100,0),
+(@ID,198,2270.18,-4621.81,73.6232,0,0,0,0,100,0),
+(@ID,199,2237.91,-4633.07,73.623,0,0,0,0,100,0),
+(@ID,200,2211.17,-4636.19,73.623,0,0,0,0,100,0),
+(@ID,201,2185.27,-4631.85,73.6238,0,0,0,0,100,0),
+(@ID,202,2161.67,-4621.89,73.6227,0,0,0,0,100,0),
+(@ID,203,2149.52,-4615.7,73.6227,0,0,0,0,100,0),
+(@ID,204,2128.18,-4600.53,73.6227,0,0,0,0,100,0),
+(@ID,205,2110.23,-4586.01,73.6227,0,0,0,0,100,0),
+(@ID,206,2094.4,-4570.16,73.6232,0,0,0,0,100,0),
+(@ID,207,2059.78,-4531.27,73.6232,0,0,0,0,100,0),
+(@ID,208,2025.92,-4515.28,73.6218,0,0,0,0,100,0),
+(@ID,209,1981.81,-4549.69,73.6228,0,0,0,0,100,0),
+(@ID,210,1968.69,-4574.04,73.6228,0,0,0,0,100,0),
+(@ID,211,1957.36,-4608.7,74.4979,0,0,0,0,100,0),
+(@ID,212,1948.95,-4627.72,78.4405,0,0,0,0,100,0),
+(@ID,213,1940.18,-4642.16,82.8813,0,0,0,0,100,0),
+(@ID,214,1932.32,-4651.64,85.6817,0,0,0,0,100,0),
+(@ID,215,1923.41,-4662.78,88.4994,0,0,0,0,100,0),
+(@ID,216,1912.89,-4671.55,90.7472,0,0,0,0,100,0),
+(@ID,217,1904.98,-4676.2,91.9429,0,0,0,0,100,0),
+(@ID,218,1880.51,-4687.26,92.3027,0,0,0,0,100,0),
+(@ID,219,1854.01,-4707.87,93.1035,0,0,0,0,100,0),
+(@ID,220,1840.53,-4719.99,92.1716,0,0,0,0,100,0),
+(@ID,221,1833.29,-4732.42,90.4734,0,0,0,0,100,0),
+(@ID,222,1825.75,-4748.92,88.8841,0,0,0,0,100,0),
+(@ID,223,1822.27,-4758.66,89.1826,0,0,0,0,100,0),
+(@ID,224,1817.98,-4771.4,89.7992,0,0,0,0,100,0),
+(@ID,225,1813.98,-4783.45,90.3784,0,0,0,0,100,0),
+(@ID,226,1810.56,-4794.25,91.0151,0,0,0,0,100,0),
+(@ID,227,1805.81,-4811.34,90.581,0,0,0,0,100,0),
+(@ID,228,1801.15,-4827.95,90.0279,0,0,0,0,100,0),
+(@ID,229,1791.34,-4861.33,88.9552,0,0,0,0,100,0),
+(@ID,230,1787.86,-4875.91,87.5166,0,0,0,0,100,0),
+(@ID,231,1780.76,-4905.48,84.0821,0,0,0,0,100,0),
+(@ID,232,1776.19,-4928.71,81.4626,0,0,0,0,100,0),
+(@ID,233,1774.3,-4938.49,81.4626,0,0,0,0,100,0),
+(@ID,234,1771.16,-4965.22,81.2126,0,0,0,0,100,0),
+(@ID,235,1757.6,-4990.9,80.8461,0,0,0,0,100,0),
+(@ID,236,1748.01,-5004.46,79.9039,0,0,0,0,100,0),
+(@ID,237,1738.94,-5016.73,79.9039,0,0,0,0,100,0),
+(@ID,238,1730.81,-5028.28,80.3151,0,0,0,0,100,0),
+(@ID,239,1720.51,-5053.17,80.4197,0,0,0,0,100,0),
+(@ID,240,1713.61,-5072.05,78.6081,0,0,0,0,100,0),
+(@ID,241,1704.71,-5094.96,75.245,0,0,0,0,100,0),
+(@ID,242,1692.75,-5131.78,73.8809,0,0,0,0,100,0),
+(@ID,243,1689.73,-5148.36,74.0206,0,0,0,0,100,0),
+(@ID,244,1688.35,-5178.24,73.7731,0,0,0,0,100,0),
+(@ID,245,1692.81,-5201.48,74.6409,0,0,0,0,100,0),
+(@ID,246,1690.74,-5274.98,73.6232,0,0,0,0,100,0),
+(@ID,247,1687.05,-5306.95,73.6112,0,0,0,0,100,0),
+(@ID,248,1686.21,-5322.85,73.6114,0,0,0,0,100,0),
+(@ID,249,1688.3,-5343.87,74.2449,0,0,0,0,100,0),
+(@ID,250,1672.16,-5377.38,73.6118,0,0,0,0,100,0),
+(@ID,251,1667.54,-5388.89,73.6137,0,0,0,0,100,0),
+(@ID,252,1664.18,-5398.35,74.3809,0,0,0,0,100,0),
+(@ID,253,1659.56,-5411.51,78.0987,0,0,0,0,100,0),
+(@ID,254,1657.63,-5416.96,80.0233,0,0,0,0,100,0),
+(@ID,255,1654.7,-5425.03,82.2941,0,0,0,0,100,0),
+(@ID,256,1652.04,-5432.05,84.9364,0,0,0,0,100,0),
+(@ID,257,1649.05,-5439.55,87.5085,0,0,0,0,100,0),
+(@ID,258,1646.61,-5446.01,90.2014,0,0,0,0,100,0),
+(@ID,259,1644.44,-5452.14,93.1195,0,0,0,0,100,0),
+(@ID,260,1641.84,-5459.95,95.4057,0,0,0,0,100,0),
+(@ID,261,1639.43,-5466.45,97.7334,0,0,0,0,100,0),
+(@ID,262,1635.2,-5476.15,100.195,0,0,0,0,100,0),
+(@ID,263,1631.56,-5485.27,100.73,0,0,0,0,100,0),
+(@ID,264,1627.96,-5493.81,100.73,0,0,0,0,100,0),
+(@ID,265,1623.74,-5501.82,102.308,0,0,0,0,100,0),
+(@ID,266,1621.54,-5506.67,104.154,0,0,0,0,100,0),
+(@ID,267,1619.31,-5510.5,105.706,0,0,0,0,100,0),
+(@ID,268,1617.2,-5514.39,107.478,0,0,0,0,100,0),
+(@ID,269,1615.11,-5518.38,108.951,0,0,0,0,100,0),
+(@ID,270,1613.27,-5521.97,110.422,0,0,0,0,100,0),
+(@ID,271,1610.31,-5527.82,111.163,0,0,0,0,100,0),
+(@ID,272,1606.59,-5535.3,111.171,0,0,0,0,100,0),
+(@ID,273,1596.95,-5537.16,111.171,0,0,0,0,100,0),
+(@ID,274,1591.5,-5546.99,111.171,0,0,0,0,100,0),
+(@ID,275,1594.64,-5559.12,111.171,0,0,0,0,100,0),
+(@ID,276,1587.05,-5573.4,111.171,0,0,0,0,100,0),
+(@ID,277,1576.47,-5592.38,111.171,0,0,0,0,100,0),
+(@ID,278,1569.09,-5606.81,114.19,0,0,0,0,100,0);
+
+UPDATE `script_texts` SET `sound`=5802 WHERE `npc_entry`=4832 AND `entry`='-1048002';