forked from celguar/classic-db
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path3891_2_ashenvale_legion_hounds.sql
354 lines (295 loc) · 22.7 KB
/
3891_2_ashenvale_legion_hounds.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
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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
SET @PATH_ID := 10010;
SET @PATH_TYPE := 4;
SET @GROUP_ID := 10034;
SET @CREATURE_0 := 108886;
SET @CREATURE_1 := 108887;
SET @CREATURE_2 := 108888;
SET @CREATURE_3 := 108889;
SET @CREATURE_4 := 108890;
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
(@CREATURE_0, '0', '1', '1', '0', '0', '1509.9937744141', '-2845.4375000000', '112.5672149658', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_1, '0', '1', '1', '0', '0', '1506.4437255859', '-2842.9934082031', '112.7861022949', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_2, '0', '1', '1', '0', '0', '1503.2708740234', '-2840.3620605469', '111.1945343018', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_3, '0', '1', '1', '0', '0', '1500.1083984375', '-2840.2927246094', '111.5321578979', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_4, '0', '1', '1', '0', '0', '1503.1079101563', '-2837.4458007813', '111.4089126587', '0.0', '300', '300', '0', '0', '0', '0', '0', '0');
INSERT INTO `waypoint_path` (`PathId`, `Point`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `WaitTime`, `ScriptId`) VALUES
(@PATH_ID, '01', '1507.6324462891', '-2843.7175292969', '112.4537048340', '100', '0', '0'),
(@PATH_ID, '02', '1516.7695312500', '-2852.3991699219', '113.3091506958', '100', '0', '0'),
(@PATH_ID, '03', '1535.7838134766', '-2852.3754882813', '112.3009338379', '100', '0', '0'),
(@PATH_ID, '04', '1545.6975097656', '-2867.9270019531', '112.6337280273', '100', '0', '0'),
(@PATH_ID, '05', '1542.9571533203', '-2881.2495117188', '112.7211608887', '100', '0', '0'),
(@PATH_ID, '06', '1528.0518798828', '-2886.9865722656', '111.6302642822', '100', '0', '0'),
(@PATH_ID, '07', '1514.9049072266', '-2880.8640136719', '111.7479324341', '100', '0', '0'),
(@PATH_ID, '08', '1501.7158203125', '-2878.7082519531', '113.2756195068', '100', '0', '0'),
(@PATH_ID, '09', '1479.0963134766', '-2883.8054199219', '112.5930862427', '100', '0', '0'),
(@PATH_ID, '10', '1460.5560302734', '-2866.7143554688', '112.0843200684', '100', '0', '0'),
(@PATH_ID, '11', '1462.1528320313', '-2849.8637695313', '114.5686569214', '100', '0', '0'),
(@PATH_ID, '12', '1465.7681884766', '-2833.1997070313', '116.7588653564', '100', '0', '0'),
(@PATH_ID, '13', '1454.6138916016', '-2820.9509277344', '119.5898284912', '100', '0', '0'),
(@PATH_ID, '14', '1433.8288574219', '-2823.3344726563', '120.4502410889', '100', '0', '0'),
(@PATH_ID, '15', '1409.3395996094', '-2820.8945312500', '115.6108856201', '100', '0', '0'),
(@PATH_ID, '16', '1396.1806640625', '-2820.4016113281', '110.9956741333', '100', '0', '0'),
(@PATH_ID, '17', '1383.5126953125', '-2827.5959472656', '109.1605300903', '100', '0', '0');
INSERT INTO `creature_spawn_entry` (`guid`, `entry`) VALUES
(@CREATURE_0, '6071'),
(@CREATURE_1, '6071'),
(@CREATURE_2, '6071'),
(@CREATURE_3, '6071'),
(@CREATURE_4, '6071');
INSERT INTO `spawn_group` (`Id`, `Name`, `Type`, `MaxCount`, `WorldState`, `Flags`) VALUES
(@GROUP_ID, 'Ashenvale - Legion Hound (5) Patrol 000', '0', '0', '0', '0');
INSERT INTO `spawn_group_spawn` (`Id`, `Guid`, `SlotId`) VALUES
(@GROUP_ID, @CREATURE_0, '0'),
(@GROUP_ID, @CREATURE_1, '1'),
(@GROUP_ID, @CREATURE_2, '2'),
(@GROUP_ID, @CREATURE_3, '3'),
(@GROUP_ID, @CREATURE_4, '4');
INSERT INTO `spawn_group_formation` (`Id`, `FormationType`, `FormationSpread`, `FormationOptions`, `PathId`, `MovementType`, `Comment`) VALUES
(@GROUP_ID, '1', '2', '0', @PATH_ID, @PATH_TYPE, 'Ashenvale - Legion Hound (5) Patrol 000');
-- -------------------------------------------------------------------------------------------------------------------------------------------
SET @PATH_ID := 10011;
SET @PATH_TYPE := 4;
SET @GROUP_ID := 10035;
SET @CREATURE_0 := 108891;
SET @CREATURE_1 := 108892;
SET @CREATURE_2 := 108893;
SET @CREATURE_3 := 108894;
SET @CREATURE_4 := 108895;
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
(@CREATURE_0, '0', '1', '1', '0', '0', '1419.1911621094', '-2841.3168945313', '134.0695343018', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_1, '0', '1', '1', '0', '0', '1418.7884521484', '-2844.6777343750', '133.8544006348', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_2, '0', '1', '1', '0', '0', '1419.9743652344', '-2848.3569335938', '132.9218444824', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_3, '0', '1', '1', '0', '0', '1416.8571777344', '-2848.8173828125', '133.0838928223', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_4, '0', '1', '1', '0', '0', '1420.4025878906', '-2851.2900390625', '133.2107849121', '0.0', '300', '300', '0', '0', '0', '0', '0', '0');
INSERT INTO `waypoint_path` (`PathId`, `Point`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `WaitTime`, `ScriptId`) VALUES
(@PATH_ID, '01', '1419.1470947266', '-2840.5385742188', '133.9643707275', '100', '0', '0'),
(@PATH_ID, '02', '1406.6416015625', '-2802.7175292969', '123.4502487183', '100', '0', '0'),
(@PATH_ID, '03', '1394.9146728516', '-2769.8654785156', '130.5137176514', '100', '0', '0'),
(@PATH_ID, '04', '1406.1224365234', '-2752.7880859375', '134.8696594238', '100', '0', '0'),
(@PATH_ID, '05', '1420.6713867188', '-2745.5451660156', '136.8955383301', '100', '0', '0'),
(@PATH_ID, '06', '1434.4151611328', '-2758.5874023438', '139.0515899658', '100', '0', '0'),
(@PATH_ID, '07', '1443.3970947266', '-2775.6137695313', '142.7558898926', '100', '0', '0'),
(@PATH_ID, '08', '1445.2176513672', '-2794.3537597656', '144.1688537598', '100', '0', '0'),
(@PATH_ID, '09', '1461.5325927734', '-2807.2036132813', '146.7122802734', '100', '0', '0'),
(@PATH_ID, '10', '1478.2132568359', '-2800.5209960938', '149.8771209717', '100', '0', '0'),
(@PATH_ID, '11', '1471.9844970703', '-2785.9663085938', '153.3509521484', '100', '0', '0'),
(@PATH_ID, '12', '1461.7359619141', '-2783.1645507813', '154.7435455322', '100', '0', '0'),
(@PATH_ID, '13', '1453.4445800781', '-2783.0046386719', '156.2232513428', '100', '0', '0'),
(@PATH_ID, '14', '1443.1058349609', '-2787.6145019531', '158.1158294678', '100', '0', '0'),
(@PATH_ID, '15', '1430.6467285156', '-2793.6838378906', '154.6290130615', '100', '0', '0');
INSERT INTO `creature_spawn_entry` (`guid`, `entry`) VALUES
(@CREATURE_0, '6071'),
(@CREATURE_1, '6071'),
(@CREATURE_2, '6071'),
(@CREATURE_3, '6071'),
(@CREATURE_4, '6071');
INSERT INTO `spawn_group` (`Id`, `Name`, `Type`, `MaxCount`, `WorldState`, `Flags`) VALUES
(@GROUP_ID, 'Ashenvale - Legion Hound (5) Patrol 001', '0', '0', '0', '0');
INSERT INTO `spawn_group_spawn` (`Id`, `Guid`, `SlotId`) VALUES
(@GROUP_ID, @CREATURE_0, '0'),
(@GROUP_ID, @CREATURE_1, '1'),
(@GROUP_ID, @CREATURE_2, '2'),
(@GROUP_ID, @CREATURE_3, '3'),
(@GROUP_ID, @CREATURE_4, '4');
INSERT INTO `spawn_group_formation` (`Id`, `FormationType`, `FormationSpread`, `FormationOptions`, `PathId`, `MovementType`, `Comment`) VALUES
(@GROUP_ID, '1', '2', '0', @PATH_ID, @PATH_TYPE, 'Ashenvale - Legion Hound (5) Patrol 001');
-- -------------------------------------------------------------------------------------------------------------------------------------------
SET @PATH_ID := 10012;
SET @PATH_TYPE := 4;
SET @GROUP_ID := 10036;
SET @CREATURE_0 := 108896;
SET @CREATURE_1 := 108897;
SET @CREATURE_2 := 108898;
SET @CREATURE_3 := 108899;
SET @CREATURE_4 := 108900;
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
(@CREATURE_0, '0', '1', '1', '0', '0', '1452.2094726563', '-2813.0793457031', '154.0061340332', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_1, '0', '1', '1', '0', '0', '1448.5938720703', '-2810.7546386719', '154.0048370361', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_2, '0', '1', '1', '0', '0', '1455.6990966797', '-2813.2658691406', '154.0058746338', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_3, '0', '1', '1', '0', '0', '1451.0445556641', '-2816.1103515625', '154.4288177490', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_4, '0', '1', '1', '0', '0', '1450.1032714844', '-2819.2355957031', '153.6099853516', '0.0', '300', '300', '0', '0', '0', '0', '0', '0');
INSERT INTO `waypoint_path` (`PathId`, `Point`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `WaitTime`, `ScriptId`) VALUES
(@PATH_ID, '01', '1452.0583496094', '-2812.5073242188', '154.0502624512', '100', '0', '0'),
(@PATH_ID, '02', '1460.8276367188', '-2784.9118652344', '154.9198455811', '100', '0', '0'),
(@PATH_ID, '03', '1468.0581054688', '-2763.0920410156', '155.4688415527', '100', '0', '0'),
(@PATH_ID, '04', '1486.5738525391', '-2748.7907714844', '157.6294250488', '100', '0', '0'),
(@PATH_ID, '05', '1496.1127929688', '-2755.3508300781', '158.8852386475', '100', '0', '0'),
(@PATH_ID, '06', '1507.8886718750', '-2773.8615722656', '162.5552215576', '100', '0', '0'),
(@PATH_ID, '07', '1513.1733398438', '-2792.2968750000', '165.7358093262', '100', '0', '0'),
(@PATH_ID, '08', '1524.6228027344', '-2801.7729492188', '168.0372009277', '100', '0', '0'),
(@PATH_ID, '09', '1523.7761230469', '-2810.8955078125', '170.7182006836', '100', '0', '0'),
(@PATH_ID, '10', '1518.9301757813', '-2814.5996093750', '172.5317993164', '100', '0', '0'),
(@PATH_ID, '11', '1512.7792968750', '-2814.5649414063', '174.0224456787', '100', '0', '0'),
(@PATH_ID, '12', '1507.7535400391', '-2809.9951171875', '175.9406433105', '100', '0', '0'),
(@PATH_ID, '13', '1507.3900146484', '-2804.0512695313', '177.3676147461', '100', '0', '0'),
(@PATH_ID, '14', '1510.5610351563', '-2798.6892089844', '179.3676910400', '100', '0', '0'),
(@PATH_ID, '15', '1516.3305664063', '-2796.8996582031', '180.7604827881', '100', '0', '0'),
(@PATH_ID, '16', '1522.2786865234', '-2799.0979003906', '182.6161041260', '100', '0', '0'),
(@PATH_ID, '17', '1524.3994140625', '-2807.8508300781', '183.4502716064', '100', '0', '0'),
(@PATH_ID, '18', '1524.6679687500', '-2811.3193359375', '183.4502716064', '100', '0', '0'),
(@PATH_ID, '19', '1534.2884521484', '-2820.1096191406', '183.6502227783', '100', '0', '0');
INSERT INTO `creature_spawn_entry` (`guid`, `entry`) VALUES
(@CREATURE_0, '6071'),
(@CREATURE_1, '6071'),
(@CREATURE_2, '6071'),
(@CREATURE_3, '6071'),
(@CREATURE_4, '6071');
INSERT INTO `spawn_group` (`Id`, `Name`, `Type`, `MaxCount`, `WorldState`, `Flags`) VALUES
(@GROUP_ID, 'Ashenvale - Legion Hound (5) Patrol 002', '0', '0', '0', '0');
INSERT INTO `spawn_group_spawn` (`Id`, `Guid`, `SlotId`) VALUES
(@GROUP_ID, @CREATURE_0, '0'),
(@GROUP_ID, @CREATURE_1, '1'),
(@GROUP_ID, @CREATURE_2, '2'),
(@GROUP_ID, @CREATURE_3, '3'),
(@GROUP_ID, @CREATURE_4, '4');
INSERT INTO `spawn_group_formation` (`Id`, `FormationType`, `FormationSpread`, `FormationOptions`, `PathId`, `MovementType`, `Comment`) VALUES
(@GROUP_ID, '1', '2', '0', @PATH_ID, @PATH_TYPE, 'Ashenvale - Legion Hound (5) Patrol 002');
-- -------------------------------------------------------------------------------------------------------------------------------------------
SET @PATH_ID := 10013;
SET @PATH_TYPE := 4;
SET @GROUP_ID := 10037;
SET @CREATURE_0 := 108901;
SET @CREATURE_1 := 108902;
SET @CREATURE_2 := 108903;
SET @CREATURE_3 := 108904;
SET @CREATURE_4 := 108905;
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
(@CREATURE_0, '0', '1', '1', '0', '0', '1559.3535156250', '-2899.8195800781', '132.7403869629', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_1, '0', '1', '1', '0', '0', '1560.3732910156', '-2895.6826171875', '132.3824615479', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_2, '0', '1', '1', '0', '0', '1563.0313720703', '-2898.0644531250', '132.5588836670', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_3, '0', '1', '1', '0', '0', '1564.8275146484', '-2893.8039550781', '132.6009521484', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_4, '0', '1', '1', '0', '0', '1563.4713134766', '-2895.4545898438', '132.4102630615', '0.0', '300', '300', '0', '0', '0', '0', '0', '0');
INSERT INTO `waypoint_path` (`PathId`, `Point`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `WaitTime`, `ScriptId`) VALUES
(@PATH_ID, '01', '1559.2366943359', '-2899.6057128906', '132.8502502441', '100', '0', '0'),
(@PATH_ID, '02', '1555.0596923828', '-2906.1862792969', '132.0301666260', '100', '0', '0'),
(@PATH_ID, '03', '1547.7662353516', '-2912.7097167969', '130.3299865723', '100', '0', '0'),
(@PATH_ID, '04', '1542.6158447266', '-2914.8486328125', '130.6167907715', '100', '0', '0'),
(@PATH_ID, '05', '1533.9981689453', '-2915.6418457031', '131.2113800049', '100', '0', '0'),
(@PATH_ID, '06', '1526.2742919922', '-2914.1955566406', '130.8502502441', '100', '0', '0'),
(@PATH_ID, '07', '1518.8679199219', '-2911.6906738281', '128.8542327881', '100', '0', '0'),
(@PATH_ID, '08', '1521.0257568359', '-2903.0139160156', '130.6499938965', '100', '0', '0'),
(@PATH_ID, '09', '1524.6125488281', '-2891.4016113281', '129.9381713867', '100', '0', '0'),
(@PATH_ID, '10', '1529.5504150391', '-2871.8962402344', '124.7983398438', '100', '0', '0'),
(@PATH_ID, '11', '1542.3168945313', '-2856.8269042969', '129.6177215576', '100', '0', '0'),
(@PATH_ID, '12', '1555.6269531250', '-2839.2734375000', '128.6081085205', '100', '0', '0'),
(@PATH_ID, '13', '1563.0196533203', '-2827.3574218750', '131.2225036621', '100', '0', '0'),
(@PATH_ID, '14', '1563.2279052734', '-2805.7604980469', '137.7077636719', '100', '0', '0'),
(@PATH_ID, '15', '1552.1490478516', '-2792.3532714844', '139.6502380371', '100', '0', '0'),
(@PATH_ID, '16', '1533.4208984375', '-2791.8293457031', '141.8470611572', '100', '0', '0'),
(@PATH_ID, '17', '1522.4678955078', '-2807.4189453125', '143.7973022461', '100', '0', '0'),
(@PATH_ID, '18', '1513.8826904297', '-2819.1728515625', '145.4502410889', '100', '0', '0'),
(@PATH_ID, '19', '1498.1441650391', '-2815.6848144531', '147.0724792480', '100', '0', '0'),
(@PATH_ID, '20', '1482.6168212891', '-2808.4628906250', '149.4043273926', '100', '0', '0');
INSERT INTO `creature_spawn_entry` (`guid`, `entry`) VALUES
(@CREATURE_0, '6071'),
(@CREATURE_1, '6071'),
(@CREATURE_2, '6071'),
(@CREATURE_3, '6071'),
(@CREATURE_4, '6071');
INSERT INTO `spawn_group` (`Id`, `Name`, `Type`, `MaxCount`, `WorldState`, `Flags`) VALUES
(@GROUP_ID, 'Ashenvale - Legion Hound (5) Patrol 003', '0', '0', '0', '0');
INSERT INTO `spawn_group_spawn` (`Id`, `Guid`, `SlotId`) VALUES
(@GROUP_ID, @CREATURE_0, '0'),
(@GROUP_ID, @CREATURE_1, '1'),
(@GROUP_ID, @CREATURE_2, '2'),
(@GROUP_ID, @CREATURE_3, '3'),
(@GROUP_ID, @CREATURE_4, '4');
INSERT INTO `spawn_group_formation` (`Id`, `FormationType`, `FormationSpread`, `FormationOptions`, `PathId`, `MovementType`, `Comment`) VALUES
(@GROUP_ID, '1', '2', '0', @PATH_ID, @PATH_TYPE, 'Ashenvale - Legion Hound (5) Patrol 003');
-- -------------------------------------------------------------------------------------------------------------------------------------------
SET @PATH_ID := 10014;
SET @PATH_TYPE := 2;
SET @GROUP_ID := 10038;
SET @CREATURE_0 := 108906;
SET @CREATURE_1 := 108907;
SET @CREATURE_2 := 108908;
SET @CREATURE_3 := 108909;
SET @CREATURE_4 := 108910;
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
(@CREATURE_0, '0', '1', '1', '0', '0', '1599.7243652344', '-2850.7302246094', '181.1339263916', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_1, '0', '1', '1', '0', '0', '1599.2915039063', '-2848.8210449219', '181.0938110352', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_2, '0', '1', '1', '0', '0', '1603.9509277344', '-2849.8891601563', '180.5202941895', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_3, '0', '1', '1', '0', '0', '1599.1334228516', '-2845.9375000000', '180.8693847656', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_4, '0', '1', '1', '0', '0', '1603.0677490234', '-2845.5156250000', '180.4708557129', '0.0', '300', '300', '0', '0', '0', '0', '0', '0');
INSERT INTO `waypoint_path` (`PathId`, `Point`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `WaitTime`, `ScriptId`) VALUES
(@PATH_ID, '01', '1579.3240966797', '-2832.3063964844', '181.7618713379', '100', '0', '0'),
(@PATH_ID, '02', '1556.0823974609', '-2826.8750000000', '182.0734405518', '100', '0', '0'),
(@PATH_ID, '03', '1543.2236328125', '-2829.2143554688', '182.1035919189', '100', '0', '0'),
(@PATH_ID, '04', '1527.4703369141', '-2841.3916015625', '182.3975219727', '100', '0', '0'),
(@PATH_ID, '05', '1526.5399169922', '-2853.9843750000', '182.3948364258', '100', '0', '0'),
(@PATH_ID, '06', '1532.6683349609', '-2868.6145019531', '182.9491882324', '100', '0', '0'),
(@PATH_ID, '07', '1526.3363037109', '-2889.3371582031', '182.2448425293', '100', '0', '0'),
(@PATH_ID, '08', '1538.7496337891', '-2900.2502441406', '181.9121246338', '100', '0', '0'),
(@PATH_ID, '09', '1554.4565429688', '-2914.5166015625', '183.0323638916', '100', '0', '0'),
(@PATH_ID, '10', '1572.5640869141', '-2942.9167480469', '181.9698638916', '100', '0', '0'),
(@PATH_ID, '11', '1594.0043945313', '-2972.1828613281', '181.8462524414', '100', '0', '0'),
(@PATH_ID, '12', '1576.4291992188', '-2937.9094238281', '181.8448638916', '100', '0', '0'),
(@PATH_ID, '13', '1567.0260009766', '-2920.4011230469', '181.8051300049', '100', '0', '0'),
(@PATH_ID, '14', '1561.9654541016', '-2897.5268554688', '182.2711181641', '100', '0', '0'),
(@PATH_ID, '15', '1559.7420654297', '-2876.5541992188', '183.6461181641', '100', '0', '0'),
(@PATH_ID, '16', '1570.9301757813', '-2870.9050292969', '182.7313232422', '100', '0', '0'),
(@PATH_ID, '17', '1587.4206542969', '-2864.3513183594', '182.4906921387', '100', '0', '0'),
(@PATH_ID, '18', '1599.5563964844', '-2859.0075683594', '181.0693054199', '100', '0', '0'),
(@PATH_ID, '19', '1598.8391113281', '-2850.3588867188', '181.2981872559', '100', '0', '0');
INSERT INTO `creature_spawn_entry` (`guid`, `entry`) VALUES
(@CREATURE_0, '6071'),
(@CREATURE_1, '6071'),
(@CREATURE_2, '6071'),
(@CREATURE_3, '6071'),
(@CREATURE_4, '6071');
INSERT INTO `spawn_group` (`Id`, `Name`, `Type`, `MaxCount`, `WorldState`, `Flags`) VALUES
(@GROUP_ID, 'Ashenvale - Legion Hound (5) Patrol 004', '0', '0', '0', '0');
INSERT INTO `spawn_group_spawn` (`Id`, `Guid`, `SlotId`) VALUES
(@GROUP_ID, @CREATURE_0, '0'),
(@GROUP_ID, @CREATURE_1, '1'),
(@GROUP_ID, @CREATURE_2, '2'),
(@GROUP_ID, @CREATURE_3, '3'),
(@GROUP_ID, @CREATURE_4, '4');
INSERT INTO `spawn_group_formation` (`Id`, `FormationType`, `FormationSpread`, `FormationOptions`, `PathId`, `MovementType`, `Comment`) VALUES
(@GROUP_ID, '0', '2', '0', @PATH_ID, @PATH_TYPE, 'Ashenvale - Legion Hound (5) Patrol 004');
-- -------------------------------------------------------------------------------------------------------------------------------------------
SET @PATH_ID := 10015;
SET @PATH_TYPE := 4;
SET @GROUP_ID := 10039;
SET @CREATURE_0 := 108911;
SET @CREATURE_1 := 108912;
SET @CREATURE_2 := 108913;
SET @CREATURE_3 := 108914;
SET @CREATURE_4 := 108915;
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
(@CREATURE_0, '0', '1', '1', '0', '0', '1735.4996337891', '-3496.2370605469', '142.7059783936', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_1, '0', '1', '1', '0', '0', '1731.3863525391', '-3494.5925292969', '142.9052886963', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_2, '0', '1', '1', '0', '0', '1733.6562500000', '-3492.9553222656', '142.9471130371', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_3, '0', '1', '1', '0', '0', '1731.7257080078', '-3490.3107910156', '143.0869750977', '0.0', '300', '300', '0', '0', '0', '0', '0', '0'),
(@CREATURE_4, '0', '1', '1', '0', '0', '1728.5694580078', '-3492.3872070313', '142.9865722656', '0.0', '300', '300', '0', '0', '0', '0', '0', '0');
INSERT INTO `waypoint_path` (`PathId`, `Point`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `WaitTime`, `ScriptId`) VALUES
(@PATH_ID, '01', '1735.2545166016', '-3496.0998535156', '142.6332855225', '100', '0', '0'),
(@PATH_ID, '02', '1724.1323242188', '-3484.9157714844', '143.7532501221', '100', '0', '0'),
(@PATH_ID, '03', '1720.9526367188', '-3470.0847167969', '144.3831329346', '100', '0', '0'),
(@PATH_ID, '04', '1718.1024169922', '-3455.6633300781', '144.4345397949', '100', '0', '0'),
(@PATH_ID, '05', '1706.9387207031', '-3449.8723144531', '144.5595397949', '100', '0', '0'),
(@PATH_ID, '06', '1696.4487304688', '-3432.8994140625', '145.0921173096', '100', '0', '0'),
(@PATH_ID, '07', '1675.6900634766', '-3437.5383300781', '143.1683044434', '100', '0', '0'),
(@PATH_ID, '08', '1657.0562744141', '-3420.7373046875', '143.1819305420', '100', '0', '0'),
(@PATH_ID, '09', '1645.8989257813', '-3408.0559082031', '143.3323211670', '100', '0', '0'),
(@PATH_ID, '10', '1614.4556884766', '-3391.8537597656', '143.0776824951', '100', '0', '0'),
(@PATH_ID, '11', '1590.9205322266', '-3383.4045410156', '142.7824249268', '100', '0', '0'),
(@PATH_ID, '12', '1579.9191894531', '-3367.0759277344', '142.2824249268', '100', '0', '0'),
(@PATH_ID, '13', '1583.4056396484', '-3346.7856445313', '143.0324249268', '100', '0', '0'),
(@PATH_ID, '14', '1609.4511718750', '-3328.5710449219', '144.2978973389', '100', '0', '0');
INSERT INTO `creature_spawn_entry` (`guid`, `entry`) VALUES
(@CREATURE_0, '6071'),
(@CREATURE_1, '6071'),
(@CREATURE_2, '6071'),
(@CREATURE_3, '6071'),
(@CREATURE_4, '6071');
INSERT INTO `spawn_group` (`Id`, `Name`, `Type`, `MaxCount`, `WorldState`, `Flags`) VALUES
(@GROUP_ID, 'Ashenvale - Legion Hound (5) Patrol 005', '0', '0', '0', '0');
INSERT INTO `spawn_group_spawn` (`Id`, `Guid`, `SlotId`) VALUES
(@GROUP_ID, @CREATURE_0, '0'),
(@GROUP_ID, @CREATURE_1, '1'),
(@GROUP_ID, @CREATURE_2, '2'),
(@GROUP_ID, @CREATURE_3, '3'),
(@GROUP_ID, @CREATURE_4, '4');
INSERT INTO `spawn_group_formation` (`Id`, `FormationType`, `FormationSpread`, `FormationOptions`, `PathId`, `MovementType`, `Comment`) VALUES
(@GROUP_ID, '0', '2', '0', @PATH_ID, @PATH_TYPE, 'Ashenvale - Legion Hound (5) Patrol 005');