diff options
| -rw-r--r-- | sql/updates/world/2015_07_31_02_world.sql | 193 |
1 files changed, 193 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_31_02_world.sql b/sql/updates/world/2015_07_31_02_world.sql new file mode 100644 index 00000000000..d584737d4f1 --- /dev/null +++ b/sql/updates/world/2015_07_31_02_world.sql @@ -0,0 +1,193 @@ +-- Trok 4.x + 6.x +DELETE FROM `creature_formations` WHERE `leaderGUID`=303759; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(303759, 303759, 0, 0, 0, 0, 0), +(303759, 303762, 3, 30, 0, 0, 0), +(303759, 303764, 3, 60, 0, 0, 0), +(303759, 303763, 3, 330, 0, 0, 0), +(303759, 303761, 3, 300, 0, 0, 0); + +-- Trok SAI +SET @ENTRY := 14872; +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,0,1,0,100,0,10000,10000,10000,10000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Trok - Out of Combat - Say Line 0"); + +DELETE FROM `creature_text` WHERE `entry`=14872; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES +(14872, 0, 0, 'Help! I''m being chased by a swarm of bees!', 12, 1, 100, 0, 0, 0, 10259, 'Trok'), +(14872, 0, 1, 'I''m so tired of running, but these bees won''t leave me alone!', 12, 1, 100, 0, 0, 0, 10260, 'Trok'), +(14872, 0, 2, 'I didn''t know bees didn''t like fire!', 12, 1, 100, 0, 0, 0, 10261, 'Trok'), +(14872, 1, 3, 'Karu will you please help get these bees off of me? They sting!', 12, 1, 100, 0, 0, 0, 10262, 'Trok'); + +SET @NPC := 303759; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=208.3277,`position_y`=-2984.533,`position_z`=93.41618 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,208.3277,-2984.533,93.41618,0,0,1,0,100,0), +(@PATH,2,214.3277,-2975.783,92.41618,0,0,1,0,100,0), +(@PATH,3,214.4524,-2975.595,92.45035,0,0,1,0,100,0), +(@PATH,4,218.2024,-2970.345,92.20035,0,0,1,0,100,0), +(@PATH,5,214.7024,-2963.345,92.45035,0,0,1,0,100,0), +(@PATH,6,214.8174,-2963.406,92.42918,0,0,1,0,100,0), +(@PATH,7,213.5674,-2961.156,92.67918,0,0,1,0,100,0), +(@PATH,8,195.6956,-2969.93,92.3918,0,0,1,0,100,0), +(@PATH,9,190.3945,-2990.763,92.83701,0,0,1,0,100,0), +(@PATH,10,194.1445,-2998.763,92.08701,0,0,1,0,100,0), +(@PATH,11,194.0587,-2998.934,92.41968,0,0,1,0,100,0), +(@PATH,12,197.0587,-3005.184,92.16968,0,0,1,0,100,0), +(@PATH,13,204.8087,-3008.934,92.91968,0,0,1,0,100,0), +(@PATH,14,206.5587,-3009.934,93.66968,0,0,1,0,100,0), +(@PATH,15,209.0587,-3011.184,94.66968,0,0,1,0,100,0), +(@PATH,16,211.0587,-3012.184,95.41968,0,0,1,0,100,0), +(@PATH,17,206.8103,-3010.117,93.97746,0,0,1,0,100,0), +(@PATH,18,209.3103,-3011.367,94.47746,0,0,1,0,100,0), +(@PATH,19,211.3103,-3012.367,95.22746,0,0,1,0,100,0), +(@PATH,20,211.3103,-3012.617,95.47746,0,0,1,0,100,0), +(@PATH,21,213.8103,-3013.617,95.72746,0,0,1,0,100,0), +(@PATH,22,214.1222,-3014.03,95.90149,0,0,1,0,100,0), +(@PATH,23,217.8722,-3016.03,96.15149,0,0,1,0,100,0), +(@PATH,24,217.8722,-3023.03,95.40149,0,0,1,0,100,0), +(@PATH,25,217.6222,-3026.78,94.65149,0,0,1,0,100,0), +(@PATH,26,217.6222,-3029.78,94.40149,0,0,1,0,100,0), +(@PATH,27,217.9783,-3027.129,95.01676,0,0,1,0,100,0), +(@PATH,28,217.9783,-3030.129,94.26676,0,0,1,0,100,0), +(@PATH,29,217.7283,-3033.379,94.51676,0,0,1,0,100,0), +(@PATH,30,217.9783,-3034.379,95.01676,0,0,1,0,100,0), +(@PATH,31,218.7283,-3038.379,95.26676,0,0,1,0,100,0), +(@PATH,32,218.1058,-3034.597,95.06687,0,0,1,0,100,0), +(@PATH,33,218.8558,-3038.597,95.31687,0,0,1,0,100,0), +(@PATH,34,219.6058,-3040.847,95.81687,0,0,1,0,100,0), +(@PATH,35,223.8558,-3043.097,96.56687,0,0,1,0,100,0), +(@PATH,36,218.3195,-3046.51,95.85423,0,0,1,0,100,0), +(@PATH,37,215.5695,-3046.26,94.85423,0,0,1,0,100,0), +(@PATH,38,213.5695,-3045.76,94.10423,0,0,1,0,100,0), +(@PATH,39,211.5695,-3045.51,93.60423,0,0,1,0,100,0), +(@PATH,40,208.8195,-3045.01,92.85423,0,0,1,0,100,0), +(@PATH,41,205.8195,-3044.51,92.10423,0,0,1,0,100,0), +(@PATH,42,208.5269,-3044.983,92.51109,0,0,1,0,100,0), +(@PATH,43,205.5269,-3044.483,92.26109,0,0,1,0,100,0), +(@PATH,44,200.2769,-3043.483,92.26109,0,0,1,0,100,0), +(@PATH,45,199.3011,-3058.522,91.95006,0,0,1,0,100,0), +(@PATH,46,213.6869,-3057.947,92.64718,0,0,1,0,100,0), +(@PATH,47,214.9369,-3055.447,93.39718,0,0,1,0,100,0), +(@PATH,48,215.9369,-3053.697,94.14718,0,0,1,0,100,0), +(@PATH,49,216.9369,-3051.947,94.64718,0,0,1,0,100,0), +(@PATH,50,217.9369,-3050.447,95.39718,0,0,1,0,100,0), +(@PATH,51,218.9369,-3048.697,95.89718,0,0,1,0,100,0), +(@PATH,52,218.9457,-3048.589,96.01563,0,0,1,0,100,0), +(@PATH,53,222.6957,-3042.089,96.51563,0,0,1,0,100,0), +(@PATH,54,220.1957,-3037.839,95.76563,0,0,1,0,100,0), +(@PATH,55,219.4457,-3036.089,95.01563,0,0,1,0,100,0), +(@PATH,56,217.9457,-3033.589,94.51563,0,0,1,0,100,0), +(@PATH,57,216.4457,-3030.839,94.01563,0,0,1,0,100,0), +(@PATH,58,213.4457,-3024.839,93.26563,0,0,1,0,100,0), +(@PATH,59,210.9457,-3020.339,94.01563,0,0,1,0,100,0), +(@PATH,60,213.1537,-3024.447,92.99397,0,0,1,0,100,0), +(@PATH,61,210.9037,-3020.197,93.74397,0,0,1,0,100,0), +(@PATH,62,210.4037,-3019.447,93.74397,0,0,1,0,100,0), +(@PATH,63,207.9037,-3017.697,92.99397,0,0,1,0,100,0), +(@PATH,64,205.1537,-3015.197,92.49397,0,0,1,0,100,0), +(@PATH,65,195.8551,-3007.947,91.97503,0,0,1,0,100,0), +(@PATH,66,196.3405,-2990.304,92.28298,0,0,1,0,100,0), +(@PATH,67,205.5905,-2984.804,92.78298,0,0,1,0,100,0), +(@PATH,68,209.5936,-2985.285,93.96368,0,0,1,0,100,0), +(@PATH,69,208.5936,-2992.285,94.71368,0,0,1,0,100,0), +(@PATH,70,208.0936,-2997.285,93.96368,0,0,1,0,100,0), +(@PATH,71,207.5936,-3001.035,93.21368,0,0,1,0,100,0), +(@PATH,72,205.8935,-3013.946,93.09561,0,0,1,0,100,0), +(@PATH,73,207.8935,-3013.446,94.09561,0,0,1,0,100,0), +(@PATH,74,208.8935,-3013.196,94.34561,0,0,1,0,100,0), +(@PATH,75,210.6435,-3012.696,95.09561,0,0,1,0,100,0), +(@PATH,76,210.8413,-3013.034,95.25333,0,0,1,0,100,0), +(@PATH,77,213.5913,-3012.034,95.75333,0,0,1,0,100,0), +(@PATH,78,221.1634,-3016.889,96.20912,0,0,1,0,100,0), +(@PATH,79,222.8369,-3027.971,96.03332,0,0,1,0,100,0), +(@PATH,80,225.8369,-3027.971,96.53332,0,0,1,0,100,0), +(@PATH,81,228.5869,-3027.971,97.03332,0,0,1,0,100,0), +(@PATH,82,232.5869,-3027.721,97.53332,0,0,1,0,100,0), +(@PATH,83,225.8138,-3028.087,96.2298,0,0,1,0,100,0), +(@PATH,84,228.8138,-3028.087,96.9798,0,0,1,0,100,0), +(@PATH,85,232.8138,-3028.087,97.4798,0,0,1,0,100,0), +(@PATH,86,234.0638,-3028.087,97.7298,0,0,1,0,100,0), +(@PATH,87,243.0638,-3041.087,97.2298,0,0,1,0,100,0), +(@PATH,88,243.1479,-3041.456,97.15866,0,0,1,0,100,0), +(@PATH,89,243.8979,-3042.456,96.90866,0,0,1,0,100,0), +(@PATH,90,245.6479,-3048.206,96.40866,0,0,1,0,100,0), +(@PATH,91,252.3979,-3072.956,95.90866,0,0,1,0,100,0), +(@PATH,92,253.6479,-3076.956,95.40866,0,0,1,0,100,0), +(@PATH,93,252.8096,-3073.445,95.80983,0,0,1,0,100,0), +(@PATH,94,253.8096,-3076.945,95.30983,0,0,1,0,100,0), +(@PATH,95,254.5596,-3079.195,95.30983,0,0,1,0,100,0), +(@PATH,96,259.5596,-3079.445,95.80983,0,0,1,0,100,0), +(@PATH,97,267.9379,-3079.989,96.17749,0,0,1,0,100,0), +(@PATH,98,270.9379,-3076.489,96.67749,0,0,1,0,100,0), +(@PATH,99,270.6745,-3068.651,97.42564,0,0,1,0,100,0), +(@PATH,100,266.6745,-3062.901,97.92564,0,0,1,0,100,0), +(@PATH,101,260.9245,-3054.901,97.42564,0,0,1,0,100,0), +(@PATH,102,257.6745,-3050.151,96.92564,0,0,1,0,100,0), +(@PATH,103,248.6745,-3038.151,97.42564,0,0,1,0,100,0), +(@PATH,104,246.4245,-3034.901,97.92564,0,0,1,0,100,0), +(@PATH,105,243.6962,-3031.323,98.18463,0,0,1,0,100,0), +(@PATH,106,236.1172,-3037.736,97.73177,0,0,1,0,100,0), +(@PATH,107,230.1172,-3042.736,97.23177,0,0,1,0,100,0), +(@PATH,108,230.1608,-3043.067,96.96597,0,0,1,0,100,0), +(@PATH,109,228.9108,-3044.067,96.96597,0,0,1,0,100,0), +(@PATH,110,239.9108,-3050.317,96.46597,0,0,1,0,100,0), +(@PATH,111,240.185,-3050.621,96.58394,0,0,1,0,100,0), +(@PATH,112,241.185,-3051.121,96.58394,0,0,1,0,100,0), +(@PATH,113,255.685,-3057.121,97.08394,0,0,1,0,100,0), +(@PATH,114,255.9355,-3057.419,97.01665,0,0,1,0,100,0), +(@PATH,115,259.6855,-3058.919,97.76665,0,0,1,0,100,0), +(@PATH,116,271.9355,-3070.419,97.26665,0,0,1,0,100,0), +(@PATH,117,272.1206,-3070.531,97.25916,0,0,1,0,100,0), +(@PATH,118,273.6206,-3072.031,97.00916,0,0,1,0,100,0), +(@PATH,119,276.6206,-3076.031,96.25916,0,0,1,0,100,0), +(@PATH,120,279.6206,-3080.781,95.50916,0,0,1,0,100,0), +(@PATH,121,281.3706,-3083.281,94.50916,0,0,1,0,100,0), +(@PATH,122,282.6206,-3084.781,93.75916,0,0,1,0,100,0), +(@PATH,123,283.6206,-3086.531,92.50916,0,0,1,0,100,0), +(@PATH,124,284.1089,-3086.748,92.52485,0,0,1,0,100,0), +(@PATH,125,289.1089,-3093.998,92.27485,0,0,1,0,100,0), +(@PATH,126,309.8589,-3093.748,92.77485,0,0,1,0,100,0), +(@PATH,127,310.1771,-3093.723,92.50008,0,0,1,0,100,0), +(@PATH,128,312.4271,-3093.723,92.75008,0,0,1,0,100,0), +(@PATH,129,321.9271,-3083.723,92.25008,0,0,1,0,100,0), +(@PATH,130,328.3951,-3076.796,91.88872,0,0,1,0,100,0), +(@PATH,131,307.6125,-3065.445,92.25626,0,0,1,0,100,0), +(@PATH,132,294.8625,-3065.445,93.00626,0,0,1,0,100,0), +(@PATH,133,292.8625,-3065.445,93.75626,0,0,1,0,100,0), +(@PATH,134,290.8625,-3065.445,94.25626,0,0,1,0,100,0), +(@PATH,135,288.8625,-3065.445,95.00626,0,0,1,0,100,0), +(@PATH,136,284.8625,-3065.445,95.75626,0,0,1,0,100,0), +(@PATH,137,284.5811,-3065.265,95.96494,0,0,1,0,100,0), +(@PATH,138,280.0811,-3065.265,96.46494,0,0,1,0,100,0), +(@PATH,139,277.0811,-3065.265,96.71494,0,0,1,0,100,0), +(@PATH,140,275.3311,-3065.265,97.21494,0,0,1,0,100,0), +(@PATH,141,271.0811,-3064.265,97.46494,0,0,1,0,100,0), +(@PATH,142,266.8311,-3064.265,97.96494,0,0,1,0,100,0), +(@PATH,143,265.1016,-3052.868,97.46735,0,0,1,0,100,0), +(@PATH,144,261.6016,-3047.118,96.96735,0,0,1,0,100,0), +(@PATH,145,248.974,-3039.003,97.26952,0,0,1,0,100,0), +(@PATH,146,242.474,-3037.003,97.76952,0,0,1,0,100,0), +(@PATH,147,230.224,-3033.003,97.26952,0,0,1,0,100,0), +(@PATH,148,226.474,-3031.753,96.51952,0,0,1,0,100,0), +(@PATH,149,230.0052,-3032.802,97.08563,0,0,1,0,100,0), +(@PATH,150,226.2552,-3031.552,96.58563,0,0,1,0,100,0), +(@PATH,151,225.5052,-3031.302,96.33563,0,0,1,0,100,0), +(@PATH,152,222.7552,-3030.052,95.58563,0,0,1,0,100,0), +(@PATH,153,219.2552,-3028.552,94.83563,0,0,1,0,100,0), +(@PATH,154,216.5052,-3027.302,94.33563,0,0,1,0,100,0), +(@PATH,155,214.7552,-3026.552,93.33563,0,0,1,0,100,0), +(@PATH,156,212.0052,-3025.302,92.58563,0,0,1,0,100,0), +(@PATH,157,214.4791,-3026.336,93.28333,0,0,1,0,100,0), +(@PATH,158,211.7291,-3025.086,92.78333,0,0,1,0,100,0), +(@PATH,159,208.2291,-3023.336,92.53333,0,0,1,0,100,0), +(@PATH,160,206.7291,-3015.836,93.03333,0,0,1,0,100,0), +(@PATH,161,206.7761,-3015.526,92.97921,0,0,1,0,100,0), +(@PATH,162,205.0261,-3006.026,92.72921,0,0,1,0,100,0), +(@PATH,163,206.5261,-2996.526,92.97921,0,0,0,0,100,0); |