-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathr3002_scriptdev2.sql
More file actions
90 lines (88 loc) · 5.44 KB
/
r3002_scriptdev2.sql
File metadata and controls
90 lines (88 loc) · 5.44 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
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
DELETE FROM script_texts WHERE entry BETWEEN -1001043 AND -1001018;
INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
(-1001018,'On the move, men!',0,0,0,0,'kor\'kron squad leader SAY_HORDER_RUN'),
(-1001019,'Alright boys, let\'s do this!',0,0,0,0,'skybreaker squad leader SAY_ALLIANCE_RUN'),
(-1001020,'Incoming!',0,1,0,0,'squad leader SAY_AGGRO_1'),
(-1001021,'Ambush!',0,1,0,0,'squad leader SAY_AGGRO_2'),
(-1001022,'For the Horde!',0,1,0,0,'kor\'kron squad leader SAY_HORDE_AGGRO_1'),
(-1001023,'Time for some blood, men!',0,1,0,0,'kor\'kron squad leader SAY_HORDE_AGGRO_2'),
(-1001024,'Vrykul!',0,1,0,0,'kor\'kron squad leader SAY_HORDE_AGGRO_3'),
(-1001025,'Weapons out!',0,1,0,0,'kor\'kron squad leader SAY_HORDE_AGGRO_4'),
(-1001026,'Find some cover!',0,1,0,0,'skybreaker squad leader SAY_ALLIANCE_AGGRO_1'),
(-1001027,'Group up!',0,1,0,0,'skybreaker squad leader SAY_ALLIANCE_AGGRO_2'),
(-1001028,'On your feet, boys!',0,1,0,0,'skybreaker squad leader SAY_ALLIANCE_AGGRO_3'),
(-1001029,'Vrykul attack!',0,1,0,0,'skybreaker squad leader SAY_ALLIANCE_AGGRO_4'),
(-1001030,'Quickly, catch your breaths before we press for the gate!',0,0,0,0,'kor\'kron squad leader SAY_HORDE_BREAK'),
(-1001031,'On your feet, men! Move, move move!',0,0,0,0,'kor\'kron squad leader SAY_HORDE_BREAK_DONE'),
(-1001032,'Nice work! We can only rest a moment.',0,0,0,0,'skybreaker squad leader SAY_ALLIANCE_BREAK'),
(-1001033,'On your feet, boys! Move, move move!',0,0,0,0,'skybreaker squad leader SAY_ALLIANCE_BREAK_DONE'),
(-1001034,'Thanks for keeping us covered back there! We\'ll hold the gate while we wait for reinforcements.',0,0,0,1,'squad leader SAY_EVENT_COMPLETE'),
(-1001035,'Die, maggot!',0,0,0,0,'ymirheim defender SAY_DEFENDER_AGGRO_1'),
(-1001036,'Haraak foln!',0,0,0,0,'ymirheim defender SAY_DEFENDER_AGGRO_2'),
(-1001037,'I spit on you!',0,0,0,0,'ymirheim defender SAY_DEFENDER_AGGRO_3'),
(-1001038,'I will feed you to the dogs!',0,0,0,0,'ymirheim defender SAY_DEFENDER_AGGRO_4'),
(-1001039,'I will take pleasure in gutting you!',0,0,0,0,'ymirheim defender SAY_DEFENDER_AGGRO_5'),
(-1001040,'I\'ll eat your heart!',0,0,0,0,'ymirheim defender SAY_DEFENDER_AGGRO_6'),
(-1001041,'Sniveling pig!',0,0,0,0,'ymirheim defender SAY_DEFENDER_AGGRO_7'),
(-1001042,'Ugglin oo bjorr!',0,0,0,0,'ymirheim defender SAY_DEFENDER_AGGRO_8'),
(-1001043,'You come to die!',0,0,0,0,'ymirheim defender SAY_DEFENDER_AGGRO_9');
DELETE FROM script_waypoint WHERE entry=31737;
INSERT INTO script_waypoint VALUES
(31737, 0, 7269.769, 1509.434, 320.903, 0, ''),
(31737, 1, 7258.117, 1526.602, 324.304, 0, ''),
(31737, 2, 7260.972, 1549.837, 335.689, 1000, 'SAY_ALLIANCE_RUN'),
(31737, 3, 7264.854, 1564.689, 341.974, 0, ''),
(31737, 4, 7255.504, 1579.524, 351.389, 0, ''),
(31737, 5, 7246.569, 1583.333, 358.133, 0, ''),
(31737, 6, 7232.839, 1581.032, 367.501, 0, 'first attack'),
(31737, 7, 7223.732, 1580.088, 373.346, 0, ''),
(31737, 8, 7218.684, 1586.349, 377.490, 0, ''),
(31737, 9, 7217.367, 1593.943, 379.455, 0, ''),
(31737, 10, 7225.456, 1598.870, 379.647, 0, ''),
(31737, 11, 7237.810, 1601.123, 381.088, 0, ''),
(31737, 12, 7251.413, 1609.023, 383.766, 0, ''),
(31737, 13, 7265.517, 1611.843, 382.620, 0, ''),
(31737, 14, 7277.738, 1609.804, 383.899, 0, ''),
(31737, 15, 7290.876, 1608.956, 390.451, 0, 'second attack'),
(31737, 16, 7310.857, 1615.485, 400.580, 0, ''),
(31737, 17, 7327.588, 1622.280, 411.449, 0, ''),
(31737, 18, 7343.151, 1629.884, 423.033, 0, ''),
(31737, 19, 7347.384, 1636.286, 428.066, 0, ''),
(31737, 20, 7343.727, 1644.666, 430.427, 8000, 'SAY_ALLIANCE_BREAK'),
(31737, 21, 7343.727, 1644.666, 430.427, 1000, 'SAY_ALLIANCE_BREAK_DONE'),
(31737, 22, 7301.614, 1649.022, 434.578, 0, ''),
(31737, 23, 7291.128, 1653.633, 435.176, 0, ''),
(31737, 24, 7278.780, 1657.080, 434.619, 0, ''),
(31737, 25, 7259.066, 1651.533, 433.942, 0, 'gate attack'),
(31737, 26, 7243.214, 1662.610, 438.890, 0, ''),
(31737, 27, 7211.633, 1684.327, 462.316, 0, 'SAY_EVENT_COMPLETE');
DELETE FROM script_waypoint WHERE entry=31833;
INSERT INTO script_waypoint VALUES
(31833, 0, 7504.983, 1806.833, 355.928, 0, ''),
(31833, 1, 7500.186, 1817.217, 355.494, 0, ''),
(31833, 2, 7492.701, 1828.367, 361.420, 1000, 'SAY_HORDER_RUN'),
(31833, 3, 7481.528, 1836.774, 370.704, 0, ''),
(31833, 4, 7463.597, 1840.573, 383.662, 0, 'first attack'),
(31833, 5, 7449.448, 1839.822, 394.694, 0, ''),
(31833, 6, 7432.161, 1847.350, 406.290, 0, ''),
(31833, 7, 7415.067, 1845.623, 419.790, 0, ''),
(31833, 8, 7409.832, 1839.991, 423.997, 0, ''),
(31833, 9, 7403.585, 1822.599, 428.435, 0, 'second attack'),
(31833, 10, 7398.860, 1810.257, 430.373, 0, ''),
(31833, 11, 7396.572, 1789.399, 432.286, 0, ''),
(31833, 12, 7397.816, 1769.238, 432.947, 0, ''),
(31833, 13, 7399.105, 1745.266, 433.108, 8000, 'SAY_HORDE_BREAK'),
(31833, 14, 7399.105, 1745.266, 433.108, 1000, 'SAY_HORDE_BREAK_DONE'),
(31833, 15, 7393.293, 1729.907, 435.058, 0, ''),
(31833, 16, 7385.299, 1720.183, 437.602, 0, ''),
(31833, 17, 7370.189, 1715.580, 442.425, 0, ''),
(31833, 18, 7358.270, 1719.352, 446.378, 0, ''),
(31833, 19, 7348.808, 1723.011, 449.727, 0, ''),
(31833, 20, 7333.273, 1724.842, 453.621, 0, ''),
(31833, 21, 7325.701, 1725.662, 456.896, 0, ''),
(31833, 22, 7319.808, 1725.676, 459.731, 0, 'gate attack'),
(31833, 23, 7308.107, 1726.708, 465.138, 0, ''),
(31833, 24, 7297.754, 1727.792, 467.980, 0, ''),
(31833, 25, 7288.278, 1726.889, 469.816, 0, ''),
(31833, 26, 7278.187, 1722.632, 472.149, 0, ''),
(31833, 27, 7253.084, 1729.579, 474.225, 0, 'SAY_EVENT_COMPLETE');