forked from celguar/classic-db
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path3913_wpl_mountain_silversage.pkt.sql
79 lines (65 loc) · 5.15 KB
/
3913_wpl_mountain_silversage.pkt.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
DELETE FROM `gameobject` WHERE (`guid` IN (19686, 45537, 45557, 63658, 63665, 86441));
DELETE FROM `pool_gameobject` WHERE (`guid` IN (19686, 45537, 45557, 63658, 63665, 86441));
DELETE FROM `pool_template` WHERE (`entry` IN (8247, 8252, 8257, 8262));
-- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SET @OBJECT_1 = 140080;
SET @OBJECT_2 = 140081;
SET @OBJECT_3 = 140082;
SET @OBJECT_4 = 140083;
SET @OBJECT_5 = 140084;
SET @OBJECT_6 = 140085;
SET @GROUP_ID = 42;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`) VALUES
(@OBJECT_1, '0', '0', '1', '2575.6420898437500', '-1595.9572753906250', '94.52051544189453125', '2.338739633560180664', '0', '0', '0.920504570007324218', '0.390731811523437500', '300', '600', '100', '1'),
(@OBJECT_2, '0', '0', '1', '2201.2377929687500', '-1801.1833496093750', '72.03926849365234375', '1.256635904312133789', '0', '0', '0.587784767150878906', '0.809017360210418701', '300', '600', '100', '1'),
(@OBJECT_3, '0', '0', '1', '3000.3623046875000', '-1661.5183105468750', '165.8311309814453125', '5.532694816589355468', '0', '0', '-0.36650085449218750', '0.930417716503143310', '300', '600', '100', '1'),
(@OBJECT_4, '0', '0', '1', '2693.4936523437500', '-1661.4169921875000', '147.1721343994140625', '5.759587764739990234', '0', '0', '-0.25881862640380859', '0.965925931930541992', '300', '600', '100', '1'),
(@OBJECT_5, '0', '0', '1', '2907.6535644531250', '-1319.4996337890625', '167.1591796875000000', '5.427974700927734375', '0', '0', '-0.41469287872314453', '0.909961462020874023', '300', '600', '100', '1'),
(@OBJECT_6, '0', '0', '1', '2320.0017089843750', '-2046.6796875000000', '175.2209930419921875', '1.117009282112121582', '0', '0', '0.529918670654296875', '0.848048448562622070', '300', '600', '100', '1');
INSERT INTO `gameobject_spawn_entry` (`guid`, `entry`) VALUES
(@OBJECT_1, '176586'),
(@OBJECT_2, '176586'),
(@OBJECT_3, '176586'),
(@OBJECT_4, '176586'),
(@OBJECT_5, '176586'),
(@OBJECT_6, '176586');
INSERT INTO `spawn_group_spawn` (`Id`, `Guid`, `SlotId`) VALUES
(@GROUP_ID, @OBJECT_1, '-1'),
(@GROUP_ID, @OBJECT_2, '-1'),
(@GROUP_ID, @OBJECT_3, '-1'),
(@GROUP_ID, @OBJECT_4, '-1'),
(@GROUP_ID, @OBJECT_5, '-1'),
(@GROUP_ID, @OBJECT_6, '-1');
INSERT INTO `spawn_group` (`Id`, `Name`, `Type`, `MaxCount`, `WorldState`, `Flags`) VALUES
(@GROUP_ID, 'Western Plaguelands - Mountain Silversage (1) Herb 000', '1', '1', '0', '0');
-- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SET @OBJECT_1 = 140090;
SET @OBJECT_2 = 140091;
SET @OBJECT_3 = 140092;
SET @OBJECT_4 = 140093;
SET @OBJECT_5 = 140094;
SET @OBJECT_6 = 140095;
SET @GROUP_ID = 43;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`) VALUES
(@OBJECT_1, '0', '0', '1', '1690.2348632812500', '-2477.8039550781250', '99.81735992431640625', '3.211419343948364257', '0', '0', '-0.99939060211181640', '0.034906134009361267', '300', '600', '100', '1'),
(@OBJECT_2, '0', '0', '1', '2225.3286132812500', '-2463.5480957031250', '90.51047515869140625', '3.263772249221801757', '0', '0', '-0.99813461303710937', '0.061051756143569946', '300', '600', '100', '1'),
(@OBJECT_3, '0', '0', '1', '1861.6679687500000', '-1889.4282226562500', '99.05277252197265625', '3.368495941162109375', '0', '0', '-0.99357128143310546', '0.113208353519439697', '300', '600', '100', '1'),
(@OBJECT_4, '0', '0', '1', '1613.9862060546875', '-2440.5991210937500', '89.55572509765625000', '5.113816738128662109', '0', '0', '-0.55193614959716796', '0.833886384963989257', '300', '600', '100', '1'),
(@OBJECT_5, '0', '0', '1', '1862.2828369140625', '-1242.7801513671875', '73.62285614013671875', '1.012289404869079589', '0', '0', '0.484808921813964843', '0.874620079994201660', '300', '600', '100', '1'),
(@OBJECT_6, '0', '0', '1', '1963.5679931640625', '-2147.6696777343750', '83.23751831054687500', '3.595378875732421875', '0', '0', '-0.97437000274658203', '0.224951311945915222', '300', '600', '100', '1');
INSERT INTO `gameobject_spawn_entry` (`guid`, `entry`) VALUES
(@OBJECT_1, '176586'),
(@OBJECT_2, '176586'),
(@OBJECT_3, '176586'),
(@OBJECT_4, '176586'),
(@OBJECT_5, '176586'),
(@OBJECT_6, '176586');
INSERT INTO `spawn_group_spawn` (`Id`, `Guid`, `SlotId`) VALUES
(@GROUP_ID, @OBJECT_1, '-1'),
(@GROUP_ID, @OBJECT_2, '-1'),
(@GROUP_ID, @OBJECT_3, '-1'),
(@GROUP_ID, @OBJECT_4, '-1'),
(@GROUP_ID, @OBJECT_5, '-1'),
(@GROUP_ID, @OBJECT_6, '-1');
INSERT INTO `spawn_group` (`Id`, `Name`, `Type`, `MaxCount`, `WorldState`, `Flags`) VALUES
(@GROUP_ID, 'Western Plaguelands - Mountain Silversage (1) Herb 001', '1', '1', '0', '0');