forked from insider42/scriptdev2
-
Notifications
You must be signed in to change notification settings - Fork 4
Expand file tree
/
Copy path124_02_scriptdev2_script_waypoints.sql
More file actions
71 lines (65 loc) · 3.49 KB
/
124_02_scriptdev2_script_waypoints.sql
File metadata and controls
71 lines (65 loc) · 3.49 KB
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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
-- Waypoints for Massacre at Light's Point
DELETE FROM `script_waypoint` WHERE `entry`='28864';
INSERT INTO `script_waypoint`
(`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`)
VALUES
('28864', '0', '2199.4602', '-6125.4033', '35.6491', '1000'),
('28864', '1', '2237.8930', '-6007.2319', '73.6170', '0'),
('28864', '2', '2292.5766', '-5931.1767', '109.880', '0'),
('28864', '3', '2311.4689', '-5781.7138', '187.213', '0'),
('28864', '4', '2363.8535', '-5715.2338', '153.921', '0');
DELETE FROM `script_waypoint` WHERE `entry` = 28841;
INSERT INTO `script_waypoint`
(`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`)
VALUES
('28841', '0', '2389.030000', '-5902.740000', '109.014000', '5000'),
('28841', '1', '2341.812012', '-5900.484863', '102.619743', '0'),
('28841', '2', '2306.561279', '-5901.738210', '91.7924190', '0'),
('28841', '3', '2300.098389', '-5912.618652', '86.0148850', '0'),
('28841', '4', '2294.142090', '-5927.274414', '75.3168490', '0'),
('28841', '5', '2286.984375', '-5944.955566', '63.7149660', '0'),
('28841', '6', '2280.001709', '-5961.186035', '54.2282830', '0'),
('28841', '7', '2259.389648', '-5974.197754', '42.3593480', '0'),
('28841', '8', '2242.882812', '-5984.642578', '32.8278500', '0'),
('28841', '9', '2217.265625', '-6028.959473', '7.6757050', '0'),
('28841', '10', '2202.595947', '-6061.325684', '5.8820180', '0'),
('28841', '11', '2188.974609', '-6080.866699', '3.3700270', '0'),
('28841', '12', '2176.483887', '-6110.407227', '1.8551810', '0'),
('28841', '13', '2172.516602', '-6146.752441', '1.0742350', '0'),
('28841', '14', '2138.918457', '-6158.920898', '1.3429260', '0'),
('28841', '15', '2129.866699', '-6174.107910', '4.3807790', '0'),
('28841', '16', '2122.426270', '-6185.311035', '14.052804', '0'),
('28841', '17', '2117.739014', '-6193.830079', '13.354200', '10000');
-- Quest Cold Hearted
DELETE FROM `script_waypoint` WHERE `entry`='29709';
INSERT INTO `script_waypoint`
(`entry`, `pointid`, `location_x`, `location_y`, `location_z`)
VALUES
('29709', '0', '7250.15', '-2327.22', '869.03'),
('29709', '1', '7118.79', '-2122.05', '841.32'),
('29709', '2', '7052.86', '-1905.99', '888.59'),
('29709', '3', '7038.24', '-1822.77', '857.94'),
('29709', '4', '7044.09', '-1792.25', '841.69'),
('29709', '5', '7071.20', '-1780.73', '822.62');
-- Quest The Last of her kind
DELETE FROM `script_waypoint` WHERE `entry`='30468';
INSERT INTO `script_waypoint`
(`entry`, `pointid`, `location_x`, `location_y`, `location_z`)
VALUES
('30468', '0', '7332.80', '-2065.69', '765.29'),
('30468', '1', '7327.32', '-2101.70', '774.22'),
('30468', '2', '7254.51', '-2117.08', '778.98'),
('30468', '3', '7224.31', '-2117.58', '777.44'),
('30468', '4', '7194.28', '-2114.08', '765.97'),
('30468', '5', '7155.83', '-2134.19', '762.16'),
('30468', '6', '7117.62', '-2113.06', '760.57'),
('30468', '7', '7074.25', '-1956.43', '769.82'),
('30468', '8', '7065.34', '-1917.58', '781.57'),
('30468', '9', '7094.17', '-1884.47', '787.00'),
('30468', '10', '7033.13', '-1883.46', '799.88'),
('30468', '11', '7021.64', '-1844.55', '818.59'),
('30468', '12', '7015.42', '-1745.49', '819.72'),
('30468', '13', '7003.12', '-1721.36', '820.06'),
('30468', '14', '6947.09', '-1724.14', '820.61'),
('30468', '15', '6877.17', '-1684.31', '820.03'),
('30468', '16', '6825.53', '-1702.27', '820.55');