/
2020_08_21_05_world_335.sql
27 lines (27 loc) · 1.36 KB
/
2020_08_21_05_world_335.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
--
UPDATE `creature_model_info` SET `DisplayID_Other_Gender` = 0 WHERE `DisplayID` = 2582;
UPDATE `creature_equip_template` SET `ItemID1` = 4560, `VerifiedBuild` = 0 WHERE `CreatureID` = 14221 AND `ID` = 1;
UPDATE `creature` SET `position_x` = 717.6572, `position_y` = -846.4034, `position_z` = 160.7536, `orientation` = 3.351032 WHERE `id` = 14221;
DELETE FROM `waypoint_data` WHERE `id` = 867560;
INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES
(867560,1,710.176,-847.23,158.978,0,0),
(867560,2,700.134,-853.063,158.516,0,0),
(867560,3,684.42,-847.68,158.498,0,0),
(867560,4,666.937,-858.739,158.498,0,0),
(867560,5,663.885,-866.644,158.499,0,0),
(867560,6,662.637,-879.389,158.291,0,0),
(867560,7,659.842,-884.845,158.617,0,0),
(867560,8,666.729,-899.79,164.624,0,0),
(867560,9,669.022,-904.201,164.414,0,0),
(867560,10,667.229,-921.961,164.414,0,0),
(867560,11,666.778,-939.546,164.85,0,0),
(867560,12,673.587,-950.274,164.35,0,0),
(867560,13,684.347,-959.261,164.35,0,0),
(867560,14,698.708,-966.321,164.653,0,0),
(867560,15,708.321,-976.576,165.562,0,30000),
(867560,16,700.121,-957.096,164.68,0,0),
(867560,17,715.224,-933.369,164.344,0,0),
(867560,18,716.543,-899.917,166.366,0,0),
(867560,19,715.204,-866.595,161.66,0,0),
(867560,20,717.657,-846.403,160.754,0,0),
(867560,21,717.657,-846.403,160.754,3.35103,30000);