diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2025_07_28_02_world.sql | 93 |
1 files changed, 93 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2025_07_28_02_world.sql b/sql/updates/world/3.3.5/2025_07_28_02_world.sql new file mode 100644 index 00000000000..67762d9b8fa --- /dev/null +++ b/sql/updates/world/3.3.5/2025_07_28_02_world.sql @@ -0,0 +1,93 @@ +-- +SET @NPC=14424; +SET @GUID=91113; +SET @PATH=@GUID * 10; +UPDATE `creature` SET `orientation`=3.34791 WHERE `id`=@NPC AND `guid`=@GUID; +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,-2752.9434,-1311.9869,6.144358,NULL,0,0,0,100,0), +(@PATH,2,-2779.3325,-1318.1886,6.212498,NULL,0,0,0,100,0), +(@PATH,3,-2802.5144,-1327.2316,6.2124987,NULL,0,0,0,100,0), +(@PATH,4,-2841.5269,-1356.3691,6.2124963,NULL,0,0,0,100,0), +(@PATH,5,-2868.5942,-1383.6816,6.2125034,NULL,0,0,0,100,0), +(@PATH,6,-2888.584,-1418.0055,6.2125034,NULL,0,0,0,100,0), +(@PATH,7,-2915.9563,-1455.4119,6.2125106,NULL,0,0,0,100,0), +(@PATH,8,-2948.1558,-1477.9122,6.2125034,NULL,0,0,0,100,0), +(@PATH,9,-2979.6265,-1493.0153,6.2125106,NULL,0,0,0,100,0), +(@PATH,10,-3007.2742,-1519.1643,6.1943064,NULL,0,0,0,100,0), +(@PATH,11,-3030.377,-1531.1482,1.8713083,NULL,0,0,0,100,0), +(@PATH,12,-3050.034,-1538.9908,2.2948234,NULL,0,0,0,100,0), +(@PATH,13,-3068.111,-1529.2074,4.6410594,NULL,0,0,0,100,0), +(@PATH,14,-3048.722,-1507.4395,2.3030105,NULL,0,0,0,100,0), +(@PATH,15,-3045.1477,-1488.9481,6.1078167,NULL,0,0,0,100,0), +(@PATH,16,-3037.5547,-1465.8003,6.2125444,NULL,0,0,0,100,0), +(@PATH,17,-3013.2668,-1444.2893,6.2125444,NULL,0,0,0,100,0), +(@PATH,18,-2992.2075,-1423.2106,6.2125444,NULL,0,0,0,100,0), +(@PATH,19,-2982.6704,-1384.7448,6.2125444,NULL,0,0,0,100,0), +(@PATH,20,-2976.297,-1355.0217,6.1414337,NULL,0,0,0,100,0), +(@PATH,21,-2972.429,-1315.0929,6.212561,NULL,0,0,0,100,0), +(@PATH,22,-2959.098,-1289.4697,6.212534,NULL,0,0,0,100,0), +(@PATH,23,-2946.3533,-1262.2607,6.212534,NULL,0,0,0,100,0), +(@PATH,24,-2940.9849,-1235.0204,6.212534,NULL,0,0,0,100,0), +(@PATH,25,-2927.3582,-1214.3258,6.276264,NULL,0,0,0,100,0), +(@PATH,26,-2913.8328,-1184.8007,6.2125435,NULL,0,0,0,100,0), +(@PATH,27,-2913.718,-1156.6484,6.380024,NULL,0,0,0,100,0), +(@PATH,28,-2906.6707,-1130.346,6.3375435,NULL,0,0,0,100,0), +(@PATH,29,-2924.4268,-1129.007,6.262104,NULL,0,0,0,100,0), +(@PATH,30,-2948.263,-1141.3658,6.581269,NULL,0,0,0,100,0), +(@PATH,31,-2981.483,-1160.7555,6.2125306,NULL,0,0,0,100,0), +(@PATH,32,-3008.991,-1189.4165,6.3375306,NULL,0,0,0,100,0), +(@PATH,33,-3033.5713,-1223.1588,3.6263075,NULL,0,0,0,100,0), +(@PATH,34,-3058.1658,-1243.8303,6.385656,NULL,0,0,0,100,0), +(@PATH,35,-3084.6208,-1262.775,6.2125497,NULL,0,0,0,100,0), +(@PATH,36,-3110.9539,-1251.6007,5.657193,NULL,0,0,0,100,0), +(@PATH,37,-3127.4268,-1279.7166,6.2125597,NULL,0,0,0,100,0), +(@PATH,38,-3140.0647,-1310.3094,6.2125597,NULL,0,0,0,100,0), +(@PATH,39,-3129.7153,-1336.1788,6.2125444,NULL,0,0,0,100,0), +(@PATH,40,-3135.3235,-1368.5166,6.2125444,NULL,0,0,0,100,0), +(@PATH,41,-3156.5852,-1393.152,6.2125444,NULL,0,0,0,100,0), +(@PATH,42,-3176.052,-1410.8157,6.2125344,NULL,0,0,0,100,0), +(@PATH,43,-3184.6921,-1435.9547,6.2125344,NULL,0,0,0,100,0), +(@PATH,44,-3201.1177,-1461.5942,6.2125344,NULL,0,0,0,100,0), +(@PATH,45,-3184.6921,-1435.9547,6.2125344,NULL,0,0,0,100,0), +(@PATH,46,-3176.052,-1410.8157,6.2125344,NULL,0,0,0,100,0), +(@PATH,47,-3156.5852,-1393.152,6.2125444,NULL,0,0,0,100,0), +(@PATH,48,-3135.3235,-1368.5166,6.2125444,NULL,0,0,0,100,0), +(@PATH,49,-3129.7153,-1336.1788,6.2125444,NULL,0,0,0,100,0), +(@PATH,50,-3140.0647,-1310.3094,6.2125597,NULL,0,0,0,100,0), +(@PATH,51,-3127.4268,-1279.7166,6.2125597,NULL,0,0,0,100,0), +(@PATH,52,-3110.9539,-1251.6007,5.657193,NULL,0,0,0,100,0), +(@PATH,53,-3084.6208,-1262.775,6.2125497,NULL,0,0,0,100,0), +(@PATH,54,-3058.1658,-1243.8303,6.385656,NULL,0,0,0,100,0), +(@PATH,55,-3033.5713,-1223.1588,3.6263075,NULL,0,0,0,100,0), +(@PATH,56,-3008.991,-1189.4165,6.3375306,NULL,0,0,0,100,0), +(@PATH,57,-2981.483,-1160.7555,6.2125306,NULL,0,0,0,100,0), +(@PATH,58,-2948.263,-1141.3658,6.581269,NULL,0,0,0,100,0), +(@PATH,59,-2924.4268,-1129.007,6.262104,NULL,0,0,0,100,0), +(@PATH,60,-2906.6707,-1130.346,6.3375435,NULL,0,0,0,100,0), +(@PATH,61,-2913.718,-1156.6484,6.380024,NULL,0,0,0,100,0), +(@PATH,62,-2913.8281,-1184.6484,6.2125435,NULL,0,0,0,100,0), +(@PATH,63,-2927.3582,-1214.3258,6.276264,NULL,0,0,0,100,0), +(@PATH,64,-2940.9849,-1235.0204,6.212534,NULL,0,0,0,100,0), +(@PATH,65,-2946.3533,-1262.2607,6.212534,NULL,0,0,0,100,0), +(@PATH,66,-2959.098,-1289.4697,6.212534,NULL,0,0,0,100,0), +(@PATH,67,-2972.429,-1315.0929,6.212561,NULL,0,0,0,100,0), +(@PATH,68,-2976.297,-1355.0217,6.1414337,NULL,0,0,0,100,0), +(@PATH,69,-2982.6704,-1384.7448,6.2125444,NULL,0,0,0,100,0), +(@PATH,70,-2992.2075,-1423.2106,6.2125444,NULL,0,0,0,100,0), +(@PATH,71,-3013.2668,-1444.2893,6.2125444,NULL,0,0,0,100,0), +(@PATH,72,-3037.5547,-1465.8003,6.2125444,NULL,0,0,0,100,0), +(@PATH,73,-3045.1477,-1488.9481,6.1078167,NULL,0,0,0,100,0), +(@PATH,74,-3048.722,-1507.4395,2.3030105,NULL,0,0,0,100,0), +(@PATH,75,-3068.037,-1529.0762,4.6693797,NULL,0,0,0,100,0), +(@PATH,76,-3050.034,-1538.9908,2.2948234,NULL,0,0,0,100,0), +(@PATH,77,-3030.377,-1531.1482,1.8713083,NULL,0,0,0,100,0), +(@PATH,78,-3007.2742,-1519.1643,6.1943064,NULL,0,0,0,100,0), +(@PATH,79,-2979.6265,-1493.0153,6.2125106,NULL,0,0,0,100,0), +(@PATH,80,-2948.1558,-1477.9122,6.2125034,NULL,0,0,0,100,0), +(@PATH,81,-2915.9563,-1455.4119,6.2125106,NULL,0,0,0,100,0), +(@PATH,82,-2888.584,-1418.0055,6.2125034,NULL,0,0,0,100,0), +(@PATH,83,-2868.5942,-1383.6816,6.2125034,NULL,0,0,0,100,0), +(@PATH,84,-2841.5269,-1356.3691,6.2124963,NULL,0,0,0,100,0), +(@PATH,85,-2802.5144,-1327.2316,6.2124987,NULL,0,0,0,100,0), +(@PATH,86,-2779.3325,-1318.1886,6.212498,NULL,0,0,0,100,0); |