forked from celguar/classic-db
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path3967_av_lt_murp.sql
29 lines (25 loc) · 2.65 KB
/
3967_av_lt_murp.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
28
29
DELETE FROM `creature` WHERE (`guid` IN ('53110'));
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
('53110', '0', '30', '1', '0', '0', '-731.03643798828125', '-344.068267822265625', '66.6853179931640625', '0.0', '604800', '604800', '0', '0', '1', '0', '0', '4'); -- first wp, not his actual spawn position
INSERT INTO `creature_spawn_entry` (`guid`, `entry`) VALUES
('53110', '13146');
UPDATE `creature_template` SET `Scale` = '0', `SpeedWalk` = '1' WHERE (`Entry` = '13146');
INSERT INTO `creature_movement` (`Id`, `Point`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `WaitTime`, `ScriptId`) VALUES
('53110', '01', '-731.03643798828125', '-344.068267822265625', '66.6853179931640625', '100', '0', '0'),
('53110', '02', '-721.40216064453125', '-352.620513916015625', '66.9411773681640625', '100', '0', '0'),
('53110', '03', '-716.29925537109375', '-366.640686035156250', '67.5129547119140625', '100', '0', '0'),
('53110', '04', '-716.48675537109375', '-379.600250244140625', '67.4076232910156250', '100', '0', '0'),
('53110', '05', '-720.57061767578125', '-400.273223876953125', '67.7239532470703125', '100', '0', '0'),
('53110', '06', '-732.76043701171875', '-414.373474121093750', '67.7239532470703125', '100', '0', '0'),
('53110', '07', '-747.48992919921875', '-423.193145751953125', '67.0154266357421875', '100', '0', '0'),
('53110', '08', '-745.20184326171875', '-430.132812500000000', '66.9995574951171875', '100', '0', '0'),
('53110', '09', '-731.10461425781250', '-421.442047119140625', '67.7239532470703125', '100', '0', '0'),
('53110', '10', '-718.99121093750000', '-411.338867187500000', '67.7239532470703125', '100', '0', '0'),
('53110', '11', '-711.19464111328125', '-395.661346435546875', '67.7826232910156250', '100', '0', '0'),
('53110', '12', '-712.24414062500000', '-378.400939941406250', '67.1576232910156250', '100', '0', '0'),
('53110', '13', '-709.25225830078125', '-364.879547119140625', '66.7832183837890625', '100', '0', '0'),
('53110', '14', '-698.59649658203125', '-365.034240722656250', '66.1142425537109375', '100', '0', '0'),
('53110', '15', '-686.22741699218750', '-375.002990722656250', '65.7016906738281250', '100', '0', '0'),
('53110', '16', '-674.42199707031250', '-377.608398437500000', '65.6948547363281250', '100', '0', '0'),
('53110', '17', '-666.21887207031250', '-385.825531005859375', '64.2243652343750000', '100', '0', '0'),
('53110', '18', '-649.68359375000000', '-389.777343750000000', '61.2021484375000000', '100', '0', '0');