diff options
| -rw-r--r-- | sql/updates/world/master/2023_01_12_02_world_2022_10_30_06_world.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_01_12_02_world_2022_10_30_06_world.sql b/sql/updates/world/master/2023_01_12_02_world_2022_10_30_06_world.sql new file mode 100644 index 00000000000..a89d0754ff6 --- /dev/null +++ b/sql/updates/world/master/2023_01_12_02_world_2022_10_30_06_world.sql @@ -0,0 +1,23 @@ +-- Ziggurat Defenders of Death's Stand, Borean Tundra respawn from createobject2 "Replaced 21 with 20" +DELETE FROM `creature` WHERE `id` IN (26202); +INSERT INTO `creature` (`guid`,`id`,`map`,`zoneId`,`areaId`,`spawnDifficulties`,`phaseId`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`wander_distance`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`ScriptName`,`VerifiedBuild`) VALUES +(104107, 26202, 571, 0, 0, '0', 0, 0, 0, 3179.1128, 3876.5457, 26.972002, 5.550147056579589843, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104108, 26202, 571, 0, 0, '0', 0, 0, 0, 3208.3652, 3784.3962, 26.562134, 1.500983119010925292, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104109, 26202, 571, 0, 0, '0', 0, 0, 0, 3238.6262, 3825.5781, 27.355635, 3.263765573501586914, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104144, 26202, 571, 0, 0, '0', 0, 0, 0, 3276.2808, 3823.1567, 26.903698, 3.717551231384277343, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104148, 26202, 571, 0, 0, '0', 0, 0, 0, 3145.1267, 3855.4675, 25.529848, 4.345870018005371093, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104160, 26202, 571, 0, 0, '0', 0, 0, 0, 3189.6785, 3822.7556, 27.430134, 4.188790321350097656, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104161, 26202, 571, 0, 0, '0', 0, 0, 0, 3250.8606, 3788.2092, 27.558054, 0.558505356311798095, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104162, 26202, 571, 0, 0, '0', 0, 0, 0, 3245.572, 3876.8342, 30.06712, 3.630284786224365234, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104163, 26202, 571, 0, 0, '0', 0, 0, 0, 3319.423, 3814.4136, 28.766497, 0.174532920122146606, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104178, 26202, 571, 0, 0, '0', 0, 0, 0, 3286.8416, 3757.4067, 24.061386, 4.939281940460205078, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104179, 26202, 571, 0, 0, '0', 0, 0, 0, 3317.3142, 3782.119, 27.256924, 4.171336650848388671, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104183, 26202, 571, 0, 0, '0', 0, 0, 0, 3386.2854, 3726.193, 23.592287, 1.710422635078430175, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104195, 26202, 571, 0, 0, '0', 0, 0, 0, 3351.7532, 3754.534, 23.258732, 2.268928050994873046, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104196, 26202, 571, 0, 0, '0', 0, 0, 0, 3386.4788, 3775.5005, 27.368393, 6.248278617858886718, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104197, 26202, 571, 0, 0, '0', 0, 0, 0, 3237.26, 3612.8625, 30.551317, 5.969026088714599609, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104198, 26202, 571, 0, 0, '0', 0, 0, 0, 3279.4736, 3617.7239, 21.787313, 1.431169986724853515, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(104199, 26202, 571, 0, 0, '0', 0, 0, 0, 3345.7273, 3587.3877, 19.374687, 1.972222089767456054, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(80378, 26202, 571, 0, 0, '0', 0, 0, 0, 3355.7676, 3624.198, 22.045958, 0.296705961227416992, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(80364, 26202, 571, 0, 0, '0', 0, 0, 0, 3246.5815, 3686.7483, 21.914001, 5.113814830780029296, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0), +(80351, 26202, 571, 0, 0, '0', 0, 0, 0, 3206.451, 3679.6646, 37.50327, 0.139626339077949523, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0); |