Skip to content

DB/AlteracValley: Hallow's End spawns #30436

@Foldor1

Description

@Foldor1

Description

Add Hallow's End spawns for Alterac Valley - Sniffed from Cata classic (57294)

SQL fix

SET @OGUID := SET_VALUE_MANUALLY_HERE; -- Need 80
SET @EVENT := 12;

DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+79;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES 
(@OGUID+0, 180405, 30, 2597, 2959, 8, 1, 646.654541015625, -265.53472900390625, 39.214599609375, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+1, 180406, 30, 2597, 2959, 8, 1, 626.03302001953125, -268.701385498046875, 39.21208572387695312, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+2, 180406, 30, 2597, 2959, 8, 1, 640.85418701171875, -230.305557250976562, 40.65717315673828125, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+3, 180407, 30, 2597, 2959, 8, 1, 621.2413330078125, -233.352432250976562, 40.60834121704101562, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 7200, 255, 1, 0), -- G_Pumpkin_03 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+4, 180407, 30, 2597, 2959, 8, 1, 634.47222900390625, -189.105911254882812, 41.8665313720703125, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 7200, 255, 1, 0), -- G_Pumpkin_03 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+5, 180405, 30, 2597, 2959, 8, 1, 615.029541015625, -192.126739501953125, 41.89269638061523437, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+6, 180405, 30, 2597, 2959, 8, 1, 629.8819580078125, -153.539932250976562, 42.62963104248046875, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+7, 180406, 30, 2597, 2959, 8, 1, 609.092041015625, -156.633682250976562, 42.63003158569335937, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+8, 180406, 30, 2597, 2959, 8, 1, 659.373291015625, -113.126739501953125, 59.99969482421875, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+9, 180407, 30, 2597, 2959, 8, 1, 650.69964599609375, -126.258682250976562, 59.99827957153320312, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 7200, 255, 1, 0), -- G_Pumpkin_03 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+10, 180405, 30, 2597, 2959, 8, 1, 644.6805419921875, -121.621528625488281, 53.0552825927734375, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+11, 180426, 30, 2597, 2959, 8, 1, 617.54339599609375, -72.4375, 61.5846710205078125, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 7200, 255, 1, 0), -- Bat01 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+12, 180405, 30, 2597, 2959, 8, 1, 587.36981201171875, -82.282989501953125, 48.296722412109375, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+13, 180426, 30, 2597, 2959, 8, 1, 632.50177001953125, -67.3333358764648437, 65.44399261474609375, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 0), -- Bat01 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+14, 180426, 30, 2597, 2959, 8, 1, 622.451416015625, -62.4270820617675781, 70.39658355712890625, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 7200, 255, 1, 0), -- Bat01 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+15, 180427, 30, 2597, 2959, 8, 1, 636.7100830078125, -62.2118072509765625, 69.47876739501953125, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 7200, 255, 1, 0), -- Bat02 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+16, 180426, 30, 2597, 2959, 8, 1, 630.5225830078125, -44.9826393127441406, 69.8639984130859375, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 7200, 255, 1, 0), -- Bat01 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+17, 180427, 30, 2597, 2959, 8, 1, 627.1788330078125, -43.5381965637207031, 72.63372802734375, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 7200, 255, 1, 0), -- Bat02 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+18, 180427, 30, 2597, 2959, 8, 1, 618.34027099609375, -55.8923606872558593, 73.432586669921875, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 7200, 255, 1, 0), -- Bat02 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+19, 180427, 30, 2597, 2959, 8, 1, 625.44964599609375, -53.5190963745117187, 60.47428512573242187, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 7200, 255, 1, 0), -- Bat02 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+20, 180407, 30, 2597, 2959, 8, 1, 587.263916015625, -64.75, 41.32236480712890625, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 7200, 255, 1, 0), -- G_Pumpkin_03 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+21, 180406, 30, 2597, 2959, 8, 1, 580.42535400390625, -67.861114501953125, 48.267059326171875, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+22, 180407, 30, 2597, 2959, 8, 1, 663.2569580078125, -38.8993072509765625, 53.6306610107421875, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 7200, 255, 1, 0), -- G_Pumpkin_03 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+23, 180426, 30, 2597, 2959, 8, 1, 627.41839599609375, -47.6284713745117187, 58.8141632080078125, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 7200, 255, 1, 0), -- Bat01 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+24, 180426, 30, 2597, 2959, 8, 1, 635.185791015625, -45.3333320617675781, 55.84263992309570312, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 7200, 255, 1, 0), -- Bat01 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+25, 180406, 30, 2597, 2959, 8, 1, 672.71527099609375, -36.015625, 53.9852752685546875, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+26, 180405, 30, 2597, 2959, 8, 1, 607.685791015625, -18.3559036254882812, 49.12700271606445312, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+27, 180406, 30, 2597, 2959, 8, 1, 657.40625, -19.0451393127441406, 53.6367340087890625, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+28, 180405, 30, 2597, 2959, 8, 1, 666.65625, -16.0868053436279296, 53.9852752685546875, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+29, 180406, 30, 2597, 2959, 8, 1, 602.41143798828125, -20.1336803436279296, 49.12700271606445312, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Dun Baldar - Difficulty: 0) CreateObject1
(@OGUID+30, 180407, 30, 2597, 3304, 8, 1, 236.859375, -356.430572509765625, 52.74988937377929687, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 7200, 255, 1, 0), -- G_Pumpkin_03 (Area: Icewing Bunker - Difficulty: 0) CreateObject1
(@OGUID+31, 180405, 30, 2597, 3304, 8, 1, 233.09722900390625, -339.27777099609375, 45.786163330078125, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: Icewing Bunker - Difficulty: 0) CreateObject1
(@OGUID+32, 180406, 30, 2597, 3304, 8, 1, 226.4149322509765625, -343.572906494140625, 52.72425460815429687, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Icewing Bunker - Difficulty: 0) CreateObject1
(@OGUID+33, 180406, 30, 2597, 2958, 8, 1, 11.27430534362792968, -309.234375, 18.56873893737792968, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) CreateObject1
(@OGUID+34, 180405, 30, 2597, 2958, 8, 1, 15.17708301544189453, -417.265625, 45.45663833618164062, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: 0 - Difficulty: 0) CreateObject1
(@OGUID+35, 180406, 30, 2597, 2958, 8, 1, 4.625, -287.088531494140625, 18.92850685119628906, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) CreateObject1
(@OGUID+36, 180407, 30, 2597, 2958, 8, 1, 1.512153029441833496, -307.454864501953125, 18.92850685119628906, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 7200, 255, 1, 0), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) CreateObject1
(@OGUID+37, 180405, 30, 2597, 2958, 8, 1, 14.54340267181396484, -288.689239501953125, 18.60309410095214843, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: 0 - Difficulty: 0) CreateObject1
(@OGUID+38, 180407, 30, 2597, 3305, 8, 1, -119.586807250976562, -457.270843505859375, 29.78376197814941406, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 7200, 255, 1, 0), -- G_Pumpkin_03 (Area: Stonehearth Bunker - Difficulty: 0) CreateObject1
(@OGUID+39, 180405, 30, 2597, 3305, 8, 1, -126.302093505859375, -453.8350830078125, 36.7489776611328125, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: Stonehearth Bunker - Difficulty: 0) CreateObject1
(@OGUID+40, 180406, 30, 2597, 3305, 8, 1, -132.559036254882812, -469.015625, 36.75251007080078125, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Stonehearth Bunker - Difficulty: 0) CreateObject1
(@OGUID+41, 180406, 30, 2597, 3305, 8, 1, -115.708343505859375, -559.18231201171875, 46.41589736938476562, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Stonehearth Bunker - Difficulty: 0) CreateObject1
(@OGUID+42, 180426, 30, 2597, 3057, 8, 1, -255.208328247070312, -305.076385498046875, 47.92544174194335937, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 7200, 255, 1, 0), -- Bat01 (Area: Field of Strife - Difficulty: 0) CreateObject1
(@OGUID+43, 180426, 30, 2597, 3057, 8, 1, -247.923614501953125, -289.095489501953125, 43.70219802856445312, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 7200, 255, 1, 0), -- Bat01 (Area: Field of Strife - Difficulty: 0) CreateObject1
(@OGUID+44, 180426, 30, 2597, 3057, 8, 1, -250.307296752929687, -294.670135498046875, 51.5083465576171875, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 7200, 255, 1, 0), -- Bat01 (Area: Field of Strife - Difficulty: 0) CreateObject1
(@OGUID+45, 180427, 30, 2597, 3057, 8, 1, -258.149322509765625, -300.31597900390625, 52.52907562255859375, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 7200, 255, 1, 0), -- Bat02 (Area: Field of Strife - Difficulty: 0) CreateObject1
(@OGUID+46, 180427, 30, 2597, 3057, 8, 1, -263.734375, -304.36285400390625, 41.69293212890625, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 7200, 255, 1, 0), -- Bat02 (Area: Field of Strife - Difficulty: 0) CreateObject1
(@OGUID+47, 180426, 30, 2597, 3057, 8, 1, -263.671875, -294.01214599609375, 66.921905517578125, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 7200, 255, 1, 0), -- Bat01 (Area: Field of Strife - Difficulty: 0) CreateObject1
(@OGUID+48, 180427, 30, 2597, 3057, 8, 1, -267.001739501953125, -291.99652099609375, 68.89626312255859375, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 7200, 255, 1, 0), -- Bat02 (Area: Field of Strife - Difficulty: 0) CreateObject1
(@OGUID+49, 180426, 30, 2597, 3057, 8, 1, -268.958343505859375, -286.12847900390625, 65.72660064697265625, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 7200, 255, 1, 0), -- Bat01 (Area: Field of Strife - Difficulty: 0) CreateObject1
(@OGUID+50, 180426, 30, 2597, 3057, 8, 1, -270.383697509765625, -292.399322509765625, 57.81918716430664062, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 7200, 255, 1, 0), -- Bat01 (Area: Field of Strife - Difficulty: 0) CreateObject1
(@OGUID+51, 180427, 30, 2597, 3057, 8, 1, -265.97222900390625, -290.92535400390625, 73.38953399658203125, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 7200, 255, 1, 0), -- Bat02 (Area: Field of Strife - Difficulty: 0) CreateObject1
(@OGUID+52, 180427, 30, 2597, 3057, 8, 1, -273.810760498046875, -288.57464599609375, 50.90760040283203125, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 7200, 255, 1, 0), -- Bat02 (Area: Field of Strife - Difficulty: 0) CreateObject1
(@OGUID+53, 180426, 30, 2597, 3057, 8, 1, -269.526031494140625, -278.1632080078125, 65.567047119140625, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 7200, 255, 1, 0), -- Bat01 (Area: Field of Strife - Difficulty: 0) CreateObject1
(@OGUID+54, 180405, 30, 2597, 2977, 8, 1, -500.524322509765625, -192.560760498046875, 57.47841262817382812, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: Iceblood Garrison - Difficulty: 0) CreateObject1
(@OGUID+55, 180406, 30, 2597, 2977, 8, 1, -494.53472900390625, -177.293411254882812, 57.46548843383789062, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Iceblood Garrison - Difficulty: 0) CreateObject1
(@OGUID+56, 180407, 30, 2597, 2977, 8, 1, -556.34893798828125, -269.619781494140625, 52.33962631225585937, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 7200, 255, 1, 0), -- G_Pumpkin_03 (Area: Iceblood Garrison - Difficulty: 0) CreateObject1
(@OGUID+57, 180406, 30, 2597, 2977, 8, 1, -563.5538330078125, -277.614593505859375, 51.84586334228515625, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Iceblood Garrison - Difficulty: 0) CreateObject1
(@OGUID+58, 180407, 30, 2597, 2962, 8, 1, -756.53125, -349.4288330078125, 67.5057830810546875, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 7200, 255, 1, 0), -- G_Pumpkin_03 (Area: Tower Point - Difficulty: 0) CreateObject1
(@OGUID+59, 180405, 30, 2597, 2962, 8, 1, -766.61456298828125, -343.541656494140625, 67.859375, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: Tower Point - Difficulty: 0) CreateObject1
(@OGUID+60, 180405, 30, 2597, 2961, 8, 1, -1158.9722900390625, -357.826385498046875, 52.01720809936523437, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+61, 180407, 30, 2597, 2961, 8, 1, -1160.1285400390625, -348.217010498046875, 52.0004425048828125, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 7200, 255, 1, 0), -- G_Pumpkin_03 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+62, 180406, 30, 2597, 2961, 8, 1, -1227.8836669921875, -372.7413330078125, 57.95041275024414062, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+63, 180405, 30, 2597, 2961, 8, 1, -1305.9097900390625, -299.920135498046875, 92.6384429931640625, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 7200, 255, 1, 0), -- G_Pumpkin_01 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+64, 180407, 30, 2597, 2961, 8, 1, -1209.85595703125, -258.70660400390625, 72.77683258056640625, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 7200, 255, 1, 0), -- G_Pumpkin_03 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+65, 180426, 30, 2597, 2961, 8, 1, -1329.8333740234375, -300.213531494140625, 107.9651336669921875, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 7200, 255, 1, 0), -- Bat01 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+66, 180407, 30, 2597, 2961, 8, 1, -1362.3680419921875, -309.545135498046875, 91.70438385009765625, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 7200, 255, 1, 0), -- G_Pumpkin_03 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+67, 180426, 30, 2597, 2961, 8, 1, -1338.4132080078125, -299.876739501953125, 111.29962158203125, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 7200, 255, 1, 0), -- Bat01 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+68, 180426, 30, 2597, 2961, 8, 1, -1332.5399169921875, -294.961822509765625, 117.9036636352539062, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 7200, 255, 1, 0), -- Bat01 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+69, 180427, 30, 2597, 2961, 8, 1, -1338.5833740234375, -296.3507080078125, 117.1262893676757812, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 7200, 255, 1, 0), -- Bat02 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+70, 180427, 30, 2597, 2961, 8, 1, -1336.3021240234375, -295.64410400390625, 116.5309906005859375, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 7200, 255, 1, 0), -- Bat02 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+71, 180427, 30, 2597, 2961, 8, 1, -1341.8819580078125, -298.439239501953125, 119.022552490234375, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 7200, 255, 1, 0), -- Bat02 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+72, 180426, 30, 2597, 2961, 8, 1, -1336.1180419921875, -293.7100830078125, 109.1396865844726562, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 7200, 255, 1, 0), -- Bat01 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+73, 180406, 30, 2597, 2961, 8, 1, -1315.8385009765625, -266.8194580078125, 91.59452056884765625, 6.14356088638305664, 0, 0, -0.06975555419921875, 0.997564136981964111, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+74, 180406, 30, 2597, 2961, 8, 1, -1208.5035400390625, -248.340286254882812, 73.06655120849609375, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+75, 180427, 30, 2597, 2961, 8, 1, -1347.111083984375, -291.33160400390625, 110.968292236328125, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 7200, 255, 1, 0), -- Bat02 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+76, 180406, 30, 2597, 2961, 8, 1, -1343.9010009765625, -278.90625, 95.8878173828125, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+77, 180406, 30, 2597, 2961, 8, 1, -1359.548583984375, -275.984375, 97.480438232421875, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 7200, 255, 1, 0), -- G_Pumpkin_02 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+78, 180407, 30, 2597, 2961, 8, 1, -1346.5833740234375, -271.59375, 97.4921722412109375, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 7200, 255, 1, 0), -- G_Pumpkin_03 (Area: Frostwolf Village - Difficulty: 0) CreateObject1
(@OGUID+79, 180405, 30, 2597, 2961, 8, 1, -1357.7396240234375, -283.203125, 95.7138671875, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 7200, 255, 1, 0); -- G_Pumpkin_01 (Area: Frostwolf Village - Difficulty: 0) CreateObject1

DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+79 AND `eventEntry`=@EVENT;
INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+79;

Branch

3.3.5

TC rev. hash/commit

dd7ee3c

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions