diff options
| -rw-r--r-- | sql/updates/world/master/2020_07_17_20_world_2017_06_25_08_world.sql | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_07_17_20_world_2017_06_25_08_world.sql b/sql/updates/world/master/2020_07_17_20_world_2017_06_25_08_world.sql new file mode 100644 index 00000000000..24445f37601 --- /dev/null +++ b/sql/updates/world/master/2020_07_17_20_world_2017_06_25_08_world.sql @@ -0,0 +1,29 @@ +-- +SET @guid:=134935; +DELETE FROM `creature` WHERE `id` IN (30083); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `curhealth`, `curmana`, `MovementType`) VALUES +(@guid+0, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3410.94, -3084.66, 294.662, 2.42642, 7200, 0, 0, 0, 0), +(@guid+1, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3409.51, -3086.2, 294.662, 2.39107, 7200, 0, 0, 0, 0), +(@guid+2, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3410.88, -3087.48, 294.662, 2.39107, 7200, 0, 0, 0, 0), +(@guid+3, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3412.31, -3086.29, 294.662, 2.26934, 7200, 0, 0, 0, 0), +(@guid+4, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3414.18, -3084.71, 294.662, 2.27326, 7200, 0, 0, 0, 0), +(@guid+5, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3412.91, -3083.21, 294.662, 2.27326, 7200, 0, 0, 0, 0), +(@guid+6, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3411.25, -3081.24, 294.662, 2.27326, 7200, 0, 0, 0, 0), +(@guid+7, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3409.55, -3082.68, 294.662, 2.27326, 7200, 0, 0, 0, 0), +(@guid+8, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3407.67, -3084.26, 294.662, 2.26934, 7200, 0, 0, 0, 0), +(@guid+9, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3452.91, -3281.6, 267.594, 4.66245, 7200, 0, 0, 0, 0), +(@guid+10, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3453.04, -3278.97, 267.594, 4.66245, 7200, 0, 0, 0, 0), +(@guid+11, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3450.75, -3280.6, 267.594, 3.74353, 7200, 0, 0, 0, 0), +(@guid+12, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3451.24, -3284.51, 267.594, 5.49497, 7200, 0, 0, 0, 0), +(@guid+13, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3455.13, -3283.77, 267.594, 0.146405, 7200, 0,0, 0, 0), +(@guid+14, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3455.5, -3279.58, 267.594, 1.45409, 7200, 0, 0, 0, 0), +(@guid+15, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3450.28, -3277.25, 267.594, 2.73037, 7200, 0, 0, 0, 0), +(@guid+16, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3447.2, -3281.45, 267.594, 4.43075, 7200, 0, 0, 0, 0), +(@guid+17, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3163.76, -2984.34, 267.594, 3.11914, 7200, 0, 0, 0, 0), +(@guid+18, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3161.41, -2980.58, 267.594, 2.12953, 7200, 0, 0, 0, 0), +(@guid+19, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3159.66, -2984.66, 267.594, 4.30116, 7200, 0, 0, 0, 0), +(@guid+20, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3162.34, -2987.89, 267.594, 5.40464, 7200, 0, 0, 0, 0), +(@guid+21, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3166.4, -2986.91, 267.594, 0.181745, 7200, 0, 0, 0, 0), +(@guid+22, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3168.48, -2983.26, 267.594, 1.05354, 7200, 0, 0, 0, 0), +(@guid+23, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3164.23, -2990.77, 267.594, 4.14801, 7200, 0, 0, 0, 0), +(@guid+24, 30083, 533, '3,4', 0, 0, 0, 0, 0, 3155.26, -2985.87, 267.594, 2.75393, 7200, 0, 0, 0, 0); |