diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_06_02_world.sql | 219 |
1 files changed, 219 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_06_02_world.sql b/sql/updates/world/master/2022_12_06_02_world.sql new file mode 100644 index 00000000000..599d5ccaf64 --- /dev/null +++ b/sql/updates/world/master/2022_12_06_02_world.sql @@ -0,0 +1,219 @@ +SET @CGUID := 396483; +SET @OGUID := 248739; +SET @EVENT := 26; + +-- Creature templates +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=34678; -- Dokin Farplain +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=34684; -- Laha Farplain +UPDATE `creature_template` SET `gossip_menu_id`=10569, `minlevel`=60, `maxlevel`=60, `npcflag`=83 WHERE `entry`=34714; -- Mahara Goldwheat +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `unit_flags`=2147746560 WHERE `entry`=35343; -- Bountiful Barrel + +DELETE FROM `creature_template_addon` WHERE `entry`=34714; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(34714, 0, 0, 0, 2, 0, 0, 0, 0, 0, ''); -- 34714 (Mahara Goldwheat) + +-- Equipments +UPDATE `creature_equip_template` SET `VerifiedBuild`=46741 WHERE (`ID`=1 AND `CreatureID` IN (52651,51372,34723,34721,34719,34718,34717,34715,34714,34678,10881,8364,8362,8361,5189,5054,3084,3002,3001)); + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE `DifficultyID`=0 AND `Entry` IN (34678, 34684, 34714, 35343); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(34678, 0, 0, 0, 389, 46741), +(34684, 0, 0, 0, 389, 46741), +(34714, 0, 0, 0, 389, 46741), +(35343, 0, 0, 0, 389, 46741); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=46741 WHERE (`DifficultyID`=0 AND `Entry` IN (121541,61143,61141,52658,52657,52655,52651,51503,51372,34824,34823,34822,34819,34812,34730,34723,34721,34719,34718,34717,34715,34654,32840,32839,32831,32830,32829,32827,32825,32824,32823,25075,24935,24934,10881,8364,8362,8361,5189,5054,4166,3084,3035,3002,3001,2959,2957,2956,2620)); + +-- Trainer +DELETE FROM `creature_trainer` WHERE `CreatureID`=34714; +INSERT INTO `creature_trainer` (`CreatureID`, `TrainerID`, `MenuID`, `OptionID`) VALUES +(34714, 136, 10569, 0); + +-- Quests +UPDATE `quest_poi_points` SET `VerifiedBuild`=46741 WHERE (`QuestID`=14060 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14060 AND `Idx1`=0 AND `Idx2`=0); + +DELETE FROM `quest_details` WHERE `ID`=14060; +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(14060, 1, 1, 0, 0, 0, 0, 0, 0, 46741); -- Easy As Pie + +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1 WHERE `ID`=14060; + +UPDATE `creature_queststarter` SET `VerifiedBuild`=46741 WHERE (`id`=34714 AND `quest`=14060); + +UPDATE `creature_questender` SET `VerifiedBuild`=46741 WHERE (`id`=34714 AND `quest`=14060); + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+10; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 32823, 1, 1638, 5345, '0', 0, 0, 0, 0, -1319.9461669921875, 201.3663177490234375, 59.04747772216796875, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Thunder Bluff - Difficulty: 0) (Auras: ) +(@CGUID+1, 32823, 1, 1638, 5345, '0', 0, 0, 0, 0, -1282.4375, 204.439239501953125, 58.96425247192382812, 2.042035102844238281, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Thunder Bluff - Difficulty: 0) (Auras: ) +(@CGUID+2, 32823, 1, 1638, 5345, '0', 0, 0, 0, 0, -1283.7882080078125, 215.9131927490234375, 58.96979904174804687, 2.042035102844238281, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Thunder Bluff - Difficulty: 0) +(@CGUID+3, 32823, 1, 1638, 5345, '0', 0, 0, 0, 0, -1316.0625, 189.8663177490234375, 59.27079010009765625, 1.710422635078430175, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Thunder Bluff - Difficulty: 0) (Auras: ) +(@CGUID+4, 34654, 1, 1638, 5345, '0', 0, 0, 0, 0, -1303.18408203125, 204.251739501953125, 58.94807815551757812, 3.40339207649230957, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Feast Hostess (Area: Thunder Bluff - Difficulty: 0) +(@CGUID+5, 34678, 1, 1638, 5345, '0', 0, 0, 0, 1, -1293.595458984375, 194.4618072509765625, 59.82789993286132812, 0.907571196556091308, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Dokin Farplain (Area: Thunder Bluff - Difficulty: 0) +(@CGUID+6, 34684, 1, 1638, 5345, '0', 0, 0, 0, 0, -1290.921875, 192.7881927490234375, 59.7661590576171875, 1.099557399749755859, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Laha Farplain (Area: Thunder Bluff - Difficulty: 0) +(@CGUID+7, 34714, 1, 1638, 5345, '0', 0, 0, 0, 1, -1335.94970703125, 193.4618072509765625, 61.42329025268554687, 6.143558979034423828, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Mahara Goldwheat (Area: Thunder Bluff - Difficulty: 0) (Auras: ) +(@CGUID+8, 35343, 1, 1638, 5345, '0', 0, 0, 0, 0, -1287.4149169921875, 191.420135498046875, 59.39658355712890625, 5.201081275939941406, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Barrel (Area: Thunder Bluff - Difficulty: 0) (Auras: ) +(@CGUID+9, 35343, 1, 1638, 5345, '0', 0, 0, 0, 0, -1289.8941650390625, 188.8038177490234375, 59.20885467529296875, 4.310963153839111328, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Barrel (Area: Thunder Bluff - Difficulty: 0) +(@CGUID+10, 35343, 1, 1638, 5345, '0', 0, 0, 0, 0, -1289.65283203125, 190.98785400390625, 59.25662612915039062, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Barrel (Area: Thunder Bluff - Difficulty: 0) (Auras: ) + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+68; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 179968, 1, 1638, 5345, '0', 0, 0, -1293.25, 194.859375, 59.06423568725585937, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+1, 179968, 1, 1638, 5345, '0', 0, 0, -1272.9879150390625, 219.6336822509765625, 59.29188919067382812, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+2, 179968, 1, 1638, 5345, '0', 0, 0, -1330.4097900390625, 202.50347900390625, 59.38118362426757812, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+3, 179968, 1, 1638, 5345, '0', 0, 0, -1290.6927490234375, 193.0572967529296875, 59.09027862548828125, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+4, 179968, 1, 1638, 5345, '0', 0, 0, -1331.298583984375, 183.22222900390625, 60.75667953491210937, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+5, 179968, 1, 1638, 5345, '0', 0, 0, -1305.265625, 188.361114501953125, 59.32638931274414062, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+6, 179968, 1, 1638, 5345, '0', 0, 0, -1270.7135009765625, 219.6875, 59.4375, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+7, 179968, 1, 1638, 5345, '0', 0, 0, -1313.173583984375, 217.076385498046875, 58.15972137451171875, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+8, 179968, 1, 1638, 5345, '0', 0, 0, -1332.8125, 202.6684112548828125, 59.39925765991210937, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+9, 179968, 1, 1638, 5345, '0', 0, 0, -1301.4600830078125, 193.359375, 59.16145706176757812, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+10, 179968, 1, 1638, 5345, '0', 0, 0, -1336.3472900390625, 193.51910400390625, 60.78462600708007812, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+11, 179968, 1, 1638, 5345, '0', 0, 0, -1294.5191650390625, 196.94097900390625, 59.01711654663085937, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+12, 179968, 1, 1638, 5345, '0', 0, 0, -1335.5504150390625, 193.4947967529296875, 60.76797103881835937, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+13, 179968, 1, 1638, 5345, '0', 0, 0, -1303.048583984375, 192.092010498046875, 59.20486068725585937, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+14, 179968, 1, 1638, 5345, '0', 0, 0, -1299.1597900390625, 219.81597900390625, 58.68712615966796875, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+15, 179968, 1, 1638, 5345, '0', 0, 0, -1328.65625, 183.7881927490234375, 60.86743927001953125, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+16, 179968, 1, 1638, 5345, '0', 0, 0, -1296.09033203125, 220.4270782470703125, 58.75826644897460937, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+17, 179968, 1, 1638, 5345, '0', 0, 0, -1293.7222900390625, 194.25347900390625, 59.0800323486328125, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+18, 179968, 1, 1638, 5345, '0', 0, 0, -1315.82470703125, 214.642364501953125, 58.56658172607421875, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+19, 179968, 1, 1638, 5345, '0', 0, 0, -1288.4617919921875, 192.67535400390625, 59.23349380493164062, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+20, 179968, 1, 1638, 5345, '0', 0, 0, -1291.092041015625, 192.3993072509765625, 59.11111068725585937, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+21, 179968, 1, 1638, 5345, '0', 0, 0, -1305.7760009765625, 186.1180572509765625, 59.39863967895507812, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 46741), -- Haystack 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+22, 180353, 1, 1638, 5345, '0', 0, 0, -1297.53125, 220.09722900390625, 58.73811721801757812, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+23, 180353, 1, 1638, 5345, '0', 0, 0, -1341.8992919921875, 191.5434112548828125, 60.91740798950195312, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+24, 180353, 1, 1638, 5345, '0', 0, 0, -1271.685791015625, 219.720489501953125, 59.36458206176757812, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+25, 180353, 1, 1638, 5345, '0', 0, 0, -1292.107666015625, 193.8090362548828125, 59.04325485229492187, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+26, 180353, 1, 1638, 5345, '0', 0, 0, -1329.94970703125, 183.5, 60.86111831665039062, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+27, 180353, 1, 1638, 5345, '0', 0, 0, -1342.0191650390625, 196.0121612548828125, 60.74286651611328125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+28, 180353, 1, 1638, 5345, '0', 0, 0, -1331.673583984375, 202.6961822509765625, 59.3792877197265625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+29, 180353, 1, 1638, 5345, '0', 0, 0, -1302.4739990234375, 192.8975677490234375, 59.17671585083007812, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+30, 180353, 1, 1638, 5345, '0', 0, 0, -1314.767333984375, 216.21875, 58.3557891845703125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+31, 180353, 1, 1638, 5345, '0', 0, 0, -1305.7864990234375, 187.267364501953125, 59.35844802856445312, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+32, 195164, 1, 1638, 5345, '0', 0, 0, -1302.951416015625, 192.046875, 59.91107940673828125, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+33, 195164, 1, 1638, 5345, '0', 0, 0, -1305.126708984375, 188.4809112548828125, 60.02998733520507812, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+34, 195164, 1, 1638, 5345, '0', 0, 0, -1299.0625, 219.7708282470703125, 59.40331268310546875, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+35, 195164, 1, 1638, 5345, '0', 0, 0, -1288.3524169921875, 192.65625, 59.88541030883789062, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+36, 195164, 1, 1638, 5345, '0', 0, 0, -1332.87158203125, 202.7395782470703125, 60.0962677001953125, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+37, 195164, 1, 1638, 5345, '0', 0, 0, -1305.8663330078125, 186.0902862548828125, 60.10401153564453125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+38, 195164, 1, 1638, 5345, '0', 0, 0, -1270.8489990234375, 219.5416717529296875, 60.14274215698242187, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+39, 195164, 1, 1638, 5345, '0', 0, 0, -1296.111083984375, 220.3819427490234375, 59.46550750732421875, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+40, 195164, 1, 1638, 5345, '0', 0, 0, -1294.4566650390625, 196.939239501953125, 59.7273712158203125, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+41, 195164, 1, 1638, 5345, '0', 0, 0, -1339.248291015625, 194.6458282470703125, 61.59141159057617187, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+42, 195164, 1, 1638, 5345, '0', 0, 0, -1273.04345703125, 219.703125, 59.98953628540039062, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+43, 195164, 1, 1638, 5345, '0', 0, 0, -1315.9600830078125, 214.6302032470703125, 59.24356460571289062, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+44, 195164, 1, 1638, 5345, '0', 0, 0, -1331.24658203125, 183.267364501953125, 61.46392059326171875, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+45, 195164, 1, 1638, 5345, '0', 0, 0, -1328.71875, 183.7465362548828125, 61.57897186279296875, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+46, 195164, 1, 1638, 5345, '0', 0, 0, -1301.3629150390625, 193.314239501953125, 59.86749267578125, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+47, 195164, 1, 1638, 5345, '0', 0, 0, -1313.21533203125, 216.9809112548828125, 58.84811782836914062, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+48, 195164, 1, 1638, 5345, '0', 0, 0, -1330.545166015625, 202.359375, 60.10107421875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 46741), -- Pumpkin (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+49, 195191, 1, 1638, 5345, '0', 0, 0, -1338.8072509765625, 193.314239501953125, 60.67528533935546875, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 46741), -- Dwarven Table Simple 05 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+50, 195192, 1, 1638, 5345, '0', 0, 0, -1338.4427490234375, 194.86285400390625, 61.56208038330078125, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 46741), -- Basket of Corn (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+51, 195194, 1, 1638, 5345, '0', 0, 0, -1338.248291015625, 193.9479217529296875, 61.58173370361328125, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46741), -- Small Basket 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+52, 195195, 1, 1638, 5345, '0', 0, 0, -1338.8836669921875, 191.7604217529296875, 61.49615478515625, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 46741), -- Cranberry Masher (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+53, 195196, 1, 1638, 5345, '0', 0, 0, -1342.921875, 194.5694427490234375, 60.86281967163085937, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46741), -- Large Basket 03 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+54, 195197, 1, 1638, 5345, '0', 0, 0, -1340.7535400390625, 190.33160400390625, 60.70974349975585937, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 46741), -- Grain Sack 02 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+55, 195198, 1, 1638, 5345, '0', 0, 0, -1340.8853759765625, 195.6666717529296875, 60.87417984008789062, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 46741), -- Crate 01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+56, 195200, 1, 1638, 5345, '0', 0, 0, -1339.1910400390625, 198.078125, 60.1246337890625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pilgrim's Bounty Cooking Fire (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+57, 195215, 1, 1638, 5345, '0', 0, 0, -1343.5416259765625, 191.98785400390625, 61.30249786376953125, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 46741), -- Sweet Potato (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+58, 195215, 1, 1638, 5345, '0', 0, 0, -1343.232666015625, 192.3385467529296875, 61.25694656372070312, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 46741), -- Sweet Potato (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+59, 195215, 1, 1638, 5345, '0', 0, 0, -1342.60595703125, 192.1493072509765625, 61.17882156372070312, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 46741), -- Sweet Potato (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+60, 195215, 1, 1638, 5345, '0', 0, 0, -1343.6614990234375, 192.4427032470703125, 61.31076431274414062, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 46741), -- Sweet Potato (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+61, 195215, 1, 1638, 5345, '0', 0, 0, -1343.28125, 191.8871612548828125, 61.2704010009765625, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 46741), -- Sweet Potato (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+62, 195215, 1, 1638, 5345, '0', 0, 0, -1342.9010009765625, 192.5434112548828125, 61.21090316772460937, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46741), -- Sweet Potato (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+63, 195215, 1, 1638, 5345, '0', 0, 0, -1343.296875, 192.7725677490234375, 61.25880813598632812, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 46741), -- Sweet Potato (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+64, 195215, 1, 1638, 5345, '0', 0, 0, -1342.7691650390625, 192.3020782470703125, 61.19965362548828125, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46741), -- Sweet Potato (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+65, 195664, 1, 1638, 5345, '0', 0, 0, -1319.949951171875, 201.365997314453125, 58.96409988403320312, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+66, 195664, 1, 1638, 5345, '0', 0, 0, -1282.43994140625, 204.438995361328125, 58.88090133666992187, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+67, 195664, 1, 1638, 5345, '0', 0, 0, -1283.7900390625, 215.912994384765625, 58.88650131225585937, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+68, 195664, 1, 1638, 5345, '0', 0, 0, -1316.06005859375, 189.865997314453125, 59.1875, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Thunder Bluff - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+10; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(@EVENT, @CGUID+0), +(@EVENT, @CGUID+1), +(@EVENT, @CGUID+2), +(@EVENT, @CGUID+3), +(@EVENT, @CGUID+4), +(@EVENT, @CGUID+5), +(@EVENT, @CGUID+6), +(@EVENT, @CGUID+7), +(@EVENT, @CGUID+8), +(@EVENT, @CGUID+9), +(@EVENT, @CGUID+10); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+68; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(@EVENT, @OGUID+0), +(@EVENT, @OGUID+1), +(@EVENT, @OGUID+2), +(@EVENT, @OGUID+3), +(@EVENT, @OGUID+4), +(@EVENT, @OGUID+5), +(@EVENT, @OGUID+6), +(@EVENT, @OGUID+7), +(@EVENT, @OGUID+8), +(@EVENT, @OGUID+9), +(@EVENT, @OGUID+10), +(@EVENT, @OGUID+11), +(@EVENT, @OGUID+12), +(@EVENT, @OGUID+13), +(@EVENT, @OGUID+14), +(@EVENT, @OGUID+15), +(@EVENT, @OGUID+16), +(@EVENT, @OGUID+17), +(@EVENT, @OGUID+18), +(@EVENT, @OGUID+19), +(@EVENT, @OGUID+20), +(@EVENT, @OGUID+21), +(@EVENT, @OGUID+22), +(@EVENT, @OGUID+23), +(@EVENT, @OGUID+24), +(@EVENT, @OGUID+25), +(@EVENT, @OGUID+26), +(@EVENT, @OGUID+27), +(@EVENT, @OGUID+28), +(@EVENT, @OGUID+29), +(@EVENT, @OGUID+30), +(@EVENT, @OGUID+31), +(@EVENT, @OGUID+32), +(@EVENT, @OGUID+33), +(@EVENT, @OGUID+34), +(@EVENT, @OGUID+35), +(@EVENT, @OGUID+36), +(@EVENT, @OGUID+37), +(@EVENT, @OGUID+38), +(@EVENT, @OGUID+39), +(@EVENT, @OGUID+40), +(@EVENT, @OGUID+41), +(@EVENT, @OGUID+42), +(@EVENT, @OGUID+43), +(@EVENT, @OGUID+44), +(@EVENT, @OGUID+45), +(@EVENT, @OGUID+46), +(@EVENT, @OGUID+47), +(@EVENT, @OGUID+48), +(@EVENT, @OGUID+49), +(@EVENT, @OGUID+50), +(@EVENT, @OGUID+51), +(@EVENT, @OGUID+52), +(@EVENT, @OGUID+53), +(@EVENT, @OGUID+54), +(@EVENT, @OGUID+55), +(@EVENT, @OGUID+56), +(@EVENT, @OGUID+57), +(@EVENT, @OGUID+58), +(@EVENT, @OGUID+59), +(@EVENT, @OGUID+60), +(@EVENT, @OGUID+61), +(@EVENT, @OGUID+62), +(@EVENT, @OGUID+63), +(@EVENT, @OGUID+64), +(@EVENT, @OGUID+65), +(@EVENT, @OGUID+66), +(@EVENT, @OGUID+67), +(@EVENT, @OGUID+68); |