diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2024_10_10_01_world.sql | 95 |
1 files changed, 95 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_10_10_01_world.sql b/sql/updates/world/3.3.5/2024_10_10_01_world.sql new file mode 100644 index 00000000000..44380e5b69b --- /dev/null +++ b/sql/updates/world/3.3.5/2024_10_10_01_world.sql @@ -0,0 +1,95 @@ +-- Pathing for Greater Firebird Entry: 8207 +SET @NPC=8207; +SET @GUID=51827; +SET @PATH=@GUID * 10; +UPDATE `creature` SET `position_x`=-7710.758,`position_y`=-3956.6245,`position_z`=9.728199,`wander_distance`=0,`MovementType`=2 WHERE `guid`=@GUID; +UPDATE `creature_template` SET `MovementType`=2 WHERE `entry`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `visibilityDistanceType`, `auras`) VALUES +(@GUID, @PATH, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL); +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,-7710.758,-3956.6245,9.728199,NULL,0,0,0,100,0), +(@PATH,2,-7715.532,-3928.461,8.749683,NULL,0,0,0,100,0), +(@PATH,3,-7700.7812,-3906.8174,9.525318,NULL,0,0,0,100,0), +(@PATH,4,-7663.8013,-3875.1206,8.839839,NULL,0,0,0,100,0), +(@PATH,5,-7657.634,-3840.8525,10.83584,NULL,0,0,0,100,0), +(@PATH,6,-7671.237,-3821.5408,15.216432,NULL,0,0,0,100,0), +(@PATH,7,-7678.901,-3795.2083,21.681417,NULL,0,0,0,100,0), +(@PATH,8,-7681.229,-3756.9055,24.819561,NULL,0,0,0,100,0), +(@PATH,9,-7673.8613,-3716.5469,29.9973,NULL,0,0,0,100,0), +(@PATH,10,-7673.6987,-3687.2478,28.922815,NULL,0,0,0,100,0), +(@PATH,11,-7656.421,-3656.8772,26.623302,NULL,0,0,0,100,0), +(@PATH,12,-7662.468,-3629.3574,28.541769,NULL,0,0,0,100,0), +(@PATH,13,-7677.4897,-3582.9736,32.306168,NULL,0,0,0,100,0), +(@PATH,14,-7677.9395,-3540.1658,24.65451,NULL,0,0,0,100,0), +(@PATH,15,-7675.5747,-3503.2544,26.522423,NULL,0,0,0,100,0), +(@PATH,16,-7661.9976,-3472.317,26.822615,NULL,0,0,0,100,0), +(@PATH,17,-7631.3594,-3455.7761,29.158308,NULL,0,0,0,100,0), +(@PATH,18,-7600.8604,-3474.5388,23.820978,NULL,0,0,0,100,0), +(@PATH,19,-7556.848,-3491.1558,16.88118,NULL,0,0,0,100,0), +(@PATH,20,-7516.682,-3490.9087,15.407843,NULL,0,0,0,100,0), +(@PATH,21,-7482.791,-3478.7441,14.191426,NULL,0,0,0,100,0), +(@PATH,22,-7448.849,-3445.8245,11.7975445,NULL,0,0,0,100,0), +(@PATH,23,-7413.9087,-3422.8777,11.448396,NULL,0,0,0,100,0), +(@PATH,24,-7384.762,-3389.0525,12.521492,NULL,0,0,0,100,0), +(@PATH,25,-7390.377,-3364.397,9.953996,NULL,0,0,0,100,0), +(@PATH,26,-7417.989,-3343.9648,10.760514,NULL,0,0,0,100,0), +(@PATH,27,-7455.8647,-3346.955,13.619991,NULL,0,0,0,100,0), +(@PATH,28,-7488.782,-3342.5862,15.875005,NULL,0,0,0,100,0), +(@PATH,29,-7525.165,-3314.5938,23.809805,NULL,0,0,0,100,0), +(@PATH,30,-7545.5747,-3282.4626,28.957174,NULL,0,0,0,100,0), +(@PATH,31,-7538.598,-3249.0413,27.585447,NULL,0,0,0,100,0), +(@PATH,32,-7510.407,-3218.524,23.716492,NULL,0,0,0,100,0), +(@PATH,33,-7479.388,-3191.0247,14.460273,NULL,0,0,0,100,0), +(@PATH,34,-7465.8647,-3183.5723,13.781521,NULL,0,0,0,100,0), +(@PATH,35,-7455.6353,-3158.7048,12.994573,NULL,0,0,0,100,0), +(@PATH,36,-7456.4126,-3114.431,13.864947,NULL,0,0,0,100,0), +(@PATH,37,-7490.0244,-3081.6028,13.82893,NULL,0,0,0,100,0), +(@PATH,38,-7517.932,-3068.775,13.160608,NULL,0,0,0,100,0), +(@PATH,39,-7552.173,-3088.9275,16.074425,NULL,0,0,0,100,0), +(@PATH,40,-7580.729,-3117.3545,27.553055,NULL,0,0,0,100,0), +(@PATH,41,-7618.8794,-3141.1875,35.611378,NULL,0,0,0,100,0), +(@PATH,42,-7646.901,-3118.3042,37.350555,NULL,0,0,0,100,0), +(@PATH,43,-7678.538,-3115.4187,44.10227,NULL,0,0,0,100,0), +(@PATH,44,-7646.901,-3118.3042,37.350555,NULL,0,0,0,100,0), +(@PATH,45,-7618.8794,-3141.1875,35.611378,NULL,0,0,0,100,0), +(@PATH,46,-7580.729,-3117.3545,27.553055,NULL,0,0,0,100,0), +(@PATH,47,-7552.173,-3088.9275,16.074425,NULL,0,0,0,100,0), +(@PATH,48,-7517.932,-3068.775,13.160608,NULL,0,0,0,100,0), +(@PATH,49,-7490.0244,-3081.6028,13.82893,NULL,0,0,0,100,0), +(@PATH,50,-7456.4126,-3114.431,13.864947,NULL,0,0,0,100,0), +(@PATH,51,-7455.6353,-3158.7048,12.994573,NULL,0,0,0,100,0), +(@PATH,52,-7465.8647,-3183.5723,13.781521,NULL,0,0,0,100,0), +(@PATH,53,-7479.388,-3191.0247,14.460273,NULL,0,0,0,100,0), +(@PATH,54,-7510.407,-3218.524,23.716492,NULL,0,0,0,100,0), +(@PATH,55,-7538.598,-3249.0413,27.585447,NULL,0,0,0,100,0), +(@PATH,56,-7545.5747,-3282.4626,28.957174,NULL,0,0,0,100,0), +(@PATH,57,-7525.165,-3314.5938,23.809805,NULL,0,0,0,100,0), +(@PATH,58,-7488.782,-3342.5862,15.875005,NULL,0,0,0,100,0), +(@PATH,59,-7455.8647,-3346.955,13.619991,NULL,0,0,0,100,0), +(@PATH,60,-7417.989,-3343.9648,10.760514,NULL,0,0,0,100,0), +(@PATH,61,-7390.377,-3364.397,9.953996,NULL,0,0,0,100,0), +(@PATH,62,-7384.762,-3389.0525,12.521492,NULL,0,0,0,100,0), +(@PATH,63,-7413.9087,-3422.8777,11.448396,NULL,0,0,0,100,0), +(@PATH,64,-7448.849,-3445.8245,11.7975445,NULL,0,0,0,100,0), +(@PATH,65,-7482.721,-3478.6821,14.169454,NULL,0,0,0,100,0), +(@PATH,66,-7516.6113,-3490.8457,15.322148,NULL,0,0,0,100,0), +(@PATH,67,-7556.848,-3491.1558,16.88118,NULL,0,0,0,100,0), +(@PATH,68,-7600.8604,-3474.5388,23.820978,NULL,0,0,0,100,0), +(@PATH,69,-7631.3594,-3455.7761,29.158308,NULL,0,0,0,100,0), +(@PATH,70,-7661.9976,-3472.317,26.822615,NULL,0,0,0,100,0), +(@PATH,71,-7675.5747,-3503.2544,26.522423,NULL,0,0,0,100,0), +(@PATH,72,-7677.9395,-3540.1658,24.65451,NULL,0,0,0,100,0), +(@PATH,73,-7677.4897,-3582.9736,32.306168,NULL,0,0,0,100,0), +(@PATH,74,-7662.468,-3629.3574,28.541769,NULL,0,0,0,100,0), +(@PATH,75,-7656.421,-3656.8772,26.623302,NULL,0,0,0,100,0), +(@PATH,76,-7673.6987,-3687.2478,28.922815,NULL,0,0,0,100,0), +(@PATH,77,-7673.8438,-3716.3994,30.064438,NULL,0,0,0,100,0), +(@PATH,78,-7681.229,-3756.9055,24.819561,NULL,0,0,0,100,0), +(@PATH,79,-7678.901,-3795.2083,21.681417,NULL,0,0,0,100,0), +(@PATH,80,-7671.237,-3821.5408,15.216432,NULL,0,0,0,100,0), +(@PATH,81,-7657.634,-3840.8525,10.83584,NULL,0,0,0,100,0), +(@PATH,82,-7663.8013,-3875.1206,8.839839,NULL,0,0,0,100,0), +(@PATH,83,-7700.7812,-3906.8174,9.525318,NULL,0,0,0,100,0), +(@PATH,84,-7715.532,-3928.461,8.749683,NULL,0,0,0,100,0); |