diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2023_11_06_14_world_hillsbrad_foothills_tarren_mill.sql | 193 | ||||
| -rw-r--r-- | sql/updates/world/master/2023_11_06_15_world_hillsbrad_foothills_eastpoint_tower.sql | 95 |
2 files changed, 288 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_06_14_world_hillsbrad_foothills_tarren_mill.sql b/sql/updates/world/master/2023_11_06_14_world_hillsbrad_foothills_tarren_mill.sql new file mode 100644 index 00000000000..57a4697477e --- /dev/null +++ b/sql/updates/world/master/2023_11_06_14_world_hillsbrad_foothills_tarren_mill.sql @@ -0,0 +1,193 @@ +SET @OGUID := 3003540; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=190078; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=190078; -- Candy Bucket + +-- Quests +UPDATE `quest_offer_reward` SET `VerifiedBuild`=51886 WHERE `ID`=12376; + +DELETE FROM `gameobject_queststarter` WHERE `id`=190078; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(190078, 12376, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=190078 AND `quest`=12376); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=190078; + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 230281 AND 230357; +DELETE FROM `gameobject` WHERE `guid` IN (230381, 230382); +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 230281 AND 230357; +DELETE FROM `game_event_gameobject` WHERE `guid` IN (230381, 230382); + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+80; +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, 180405, 0, 267, 272, '0', 0, 0, -44.5780982971191406, -839.2239990234375, 63.99309921264648437, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 267, 272, '0', 0, 0, 21.2985992431640625, -870.69598388671875, 64.76850128173828125, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 267, 272, '0', 0, 0, -2.91318988800048828, -846.21197509765625, 66.5386962890625, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+3, 180405, 0, 267, 272, '0', 0, 0, -36.3628005981445312, -875.21002197265625, 56.4225006103515625, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+4, 180405, 0, 267, 272, '0', 0, 0, 20.2360992431640625, -847.010009765625, 64.94300079345703125, 5.218535900115966796, 0, 0, -0.507537841796875, 0.861629426479339599, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+5, 180405, 0, 267, 272, '0', 0, 0, 39.96699905395507812, -898.52801513671875, 66.8489990234375, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+6, 180405, 0, 267, 272, '0', 0, 0, -47.6701011657714843, -951.75201416015625, 60.211700439453125, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+7, 180405, 0, 267, 272, '0', 0, 0, 61.69440078735351562, -923.3389892578125, 70.21160125732421875, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+8, 180405, 0, 267, 272, '0', 0, 0, 61.94789886474609375, -900.14898681640625, 70.54180145263671875, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+9, 180405, 0, 267, 272, '0', 0, 0, 61.68059921264648437, -946.06298828125, 70.28659820556640625, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+10, 180405, 0, 267, 272, '0', 0, 0, -62.8785018920898437, -978.20697021484375, 55.32960128784179687, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+11, 180406, 0, 267, 272, '0', 0, 0, -59.3801994323730468, -838.78997802734375, 63.1519012451171875, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+12, 180406, 0, 267, 272, '0', 0, 0, -111.016998291015625, -838.010009765625, 63.68109893798828125, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+13, 180406, 0, 267, 272, '0', 0, 0, -50.2551994323730468, -877.4580078125, 56.01200103759765625, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+14, 180406, 0, 267, 272, '0', 0, 0, -39.6232986450195312, -958.16302490234375, 60.07229995727539062, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+15, 180406, 0, 267, 272, '0', 0, 0, 62.32469940185546875, -969.24298095703125, 70.4613037109375, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+16, 180406, 0, 267, 272, '0', 0, 0, -56.5728988647460937, -982.343994140625, 55.41650009155273437, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+17, 180406, 0, 267, 272, '0', 0, 0, 18.22739982604980468, -1019.510009765625, 64.82869720458984375, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+18, 180406, 0, 267, 272, '0', 0, 0, -6.125, -1019.52001953125, 64.47480010986328125, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+19, 180406, 0, 267, 272, '0', 0, 0, -31.3020992279052734, -1019.08001708984375, 64.11090087890625, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+20, 180406, 0, 267, 272, '0', 0, 0, -54.7742996215820312, -1018.46002197265625, 63.679901123046875, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+21, 180406, 0, 267, 272, '0', 0, 0, -78.8767013549804687, -1016.80999755859375, 63.93289947509765625, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+22, 180407, 0, 267, 267, '0', 0, 0, -46.1753005981445312, -744.28997802734375, 67.33209991455078125, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+23, 180407, 0, 267, 267, '0', 0, 0, -8.05729007720947265, -775.03997802734375, 67.2953033447265625, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+24, 180407, 0, 267, 267, '0', 0, 0, -45.2985992431640625, -790.72198486328125, 66.0771026611328125, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+25, 180407, 0, 267, 267, '0', 0, 0, -45.8541984558105468, -768.4439697265625, 65.9145965576171875, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+26, 180407, 0, 267, 267, '0', 0, 0, -4, -797.3699951171875, 66.257598876953125, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+27, 180407, 0, 267, 267, '0', 0, 0, -3.41318988800048828, -822.280029296875, 65.36930084228515625, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+28, 180407, 0, 267, 272, '0', 0, 0, -1.19270837306976318, -883.68927001953125, 65.35227203369140625, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+29, 180407, 0, 267, 272, '0', 0, 0, -10.3558998107910156, -868.93798828125, 69.24089813232421875, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+30, 180407, 0, 267, 272, '0', 0, 0, -63.6649017333984375, -839.76397705078125, 63.927398681640625, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+31, 180407, 0, 267, 272, '0', 0, 0, -86.8610992431640625, -839.20001220703125, 63.01430130004882812, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+32, 180407, 0, 267, 272, '0', 0, 0, -39.9357986450195312, -958.36102294921875, 68.5345001220703125, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+33, 180407, 0, 267, 272, '0', 0, 0, -48.0399017333984375, -953.28997802734375, 68.525299072265625, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+34, 180411, 0, 267, 272, '0', 0, 0, -45.4166984558105468, -958.0889892578125, 59.54759979248046875, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+35, 180411, 0, 267, 272, '0', 0, 0, -55.652801513671875, -986.4639892578125, 56.78839874267578125, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+36, 180411, 0, 267, 272, '0', 0, 0, -66.034698486328125, -978.8389892578125, 56.7855987548828125, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+37, 180411, 0, 267, 272, '0', 0, 0, -61.375, -982.25897216796875, 57.10419845581054687, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+38, 180415, 0, 267, 272, '0', 0, 0, -48.625, -959.7139892578125, 54.25859832763671875, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+39, 180415, 0, 267, 272, '0', 0, 0, -45.9253005981445312, -961.77801513671875, 54.24309921264648437, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+40, 180415, 0, 267, 272, '0', 0, 0, -48.4253005981445312, -960.22698974609375, 54.24140167236328125, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+41, 180425, 0, 267, 272, '0', 0, 0, -27.2395992279052734, -939.7860107421875, 56.77500152587890625, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- SkullCandle01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+42, 180425, 0, 267, 272, '0', 0, 0, -20.7812995910644531, -925.9580078125, 56.80289840698242187, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 51886), -- SkullCandle01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+43, 180425, 0, 267, 272, '0', 0, 0, -15.0521001815795898, -928.61102294921875, 56.90169906616210937, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 51886), -- SkullCandle01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+44, 180425, 0, 267, 272, '0', 0, 0, -29.3957996368408203, -933.83697509765625, 56.85950088500976562, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 51886), -- SkullCandle01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+45, 180425, 0, 267, 272, '0', 0, 0, -12.8906002044677734, -934.5689697265625, 56.76910018920898437, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 51886), -- SkullCandle01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+46, 180425, 0, 267, 272, '0', 0, 0, -26.7205009460449218, -928.10797119140625, 56.8441009521484375, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 51886), -- SkullCandle01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+47, 180425, 0, 267, 272, '0', 0, 0, -15.5486001968383789, -940.29498291015625, 56.68519973754882812, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 51886), -- SkullCandle01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+48, 180425, 0, 267, 272, '0', 0, 0, -21.5034999847412109, -942.47601318359375, 56.71590042114257812, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 51886), -- SkullCandle01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+49, 180426, 0, 267, 272, '0', 0, 0, -32.0798988342285156, -943.08197021484375, 81.20870208740234375, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 51886), -- Bat01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+50, 180426, 0, 267, 272, '0', 0, 0, -35.1753005981445312, -947.22601318359375, 82.763702392578125, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 120, 255, 1, 51886), -- Bat01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+51, 180426, 0, 267, 272, '0', 0, 0, -30.6580009460449218, -945.87701416015625, 67.86440277099609375, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 51886), -- Bat01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+52, 180426, 0, 267, 272, '0', 0, 0, -37.4426994323730468, -948.31298828125, 68.06060028076171875, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 51886), -- Bat01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+53, 180426, 0, 267, 272, '0', 0, 0, -33.7169990539550781, -947.71697998046875, 70.10669708251953125, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 51886), -- Bat01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+54, 180426, 0, 267, 272, '0', 0, 0, -33.2899017333984375, -947.3489990234375, 95.15579986572265625, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 51886), -- Bat01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+55, 180426, 0, 267, 272, '0', 0, 0, -33.9010009765625, -947.23101806640625, 73.29540252685546875, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 51886), -- Bat01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+56, 180426, 0, 267, 272, '0', 0, 0, -30.9617996215820312, -951.77099609375, 62.8927001953125, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 51886), -- Bat01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+57, 180426, 0, 267, 272, '0', 0, 0, -33.0087013244628906, -953.280029296875, 66.16539764404296875, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 120, 255, 1, 51886), -- Bat01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+58, 180426, 0, 267, 272, '0', 0, 0, -37.3905982971191406, -950.52301025390625, 72.34220123291015625, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 51886), -- Bat01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+59, 180427, 0, 267, 272, '0', 0, 0, -34.6683998107910156, -947.67401123046875, 70.5977020263671875, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 51886), -- Bat02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+60, 180427, 0, 267, 272, '0', 0, 0, -33.7135009765625, -947.197998046875, 57.89440155029296875, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 51886), -- Bat02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+61, 180427, 0, 267, 272, '0', 0, 0, -34.465301513671875, -946.73101806640625, 68.72949981689453125, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 51886), -- Bat02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+62, 180427, 0, 267, 272, '0', 0, 0, -34.659698486328125, -947.97900390625, 69.3087005615234375, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- Bat02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+63, 180427, 0, 267, 272, '0', 0, 0, -36.5, -945.98797607421875, 73.933197021484375, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 51886), -- Bat02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+64, 180427, 0, 267, 272, '0', 0, 0, -33.0433998107910156, -947.25701904296875, 71.98509979248046875, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 51886), -- Bat02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+65, 180427, 0, 267, 272, '0', 0, 0, -31.9705009460449218, -948.2550048828125, 73.98169708251953125, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 51886), -- Bat02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+66, 180427, 0, 267, 272, '0', 0, 0, -31.1961994171142578, -948.76702880859375, 59.52370071411132812, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- Bat02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+67, 180427, 0, 267, 272, '0', 0, 0, -33.6926994323730468, -949.52099609375, 66.0785980224609375, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 51886), -- Bat02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+68, 180427, 0, 267, 272, '0', 0, 0, -32.5816001892089843, -949.197998046875, 69.71900177001953125, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 51886), -- Bat02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+69, 180428, 0, 267, 272, '0', 0, 0, -45.4687995910644531, -968.09698486328125, 53.46630096435546875, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 51886), -- G_WitchBroom_01 scale 0.5 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+70, 180471, 0, 267, 272, '0', 0, 0, -64.9271011352539062, -986.08001708984375, 57.8404998779296875, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+71, 180471, 0, 267, 272, '0', 0, 0, -60.4479179382324218, -989.201416015625, 57.79619598388671875, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+72, 180471, 0, 267, 272, '0', 0, 0, -62.8350715637207031, -987.55902099609375, 57.84000015258789062, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+73, 180471, 0, 267, 272, '0', 0, 0, -61.6597213745117187, -988.48956298828125, 57.79619598388671875, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+74, 180471, 0, 267, 272, '0', 0, 0, -67.6336822509765625, -984.576416015625, 57.77629852294921875, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+75, 180471, 0, 267, 272, '0', 0, 0, -66.1493072509765625, -985.20489501953125, 57.79770278930664062, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+76, 180472, 0, 267, 272, '0', 0, 0, -48.6423988342285156, -950.64898681640625, 59.28390121459960937, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+77, 180472, 0, 267, 272, '0', 0, 0, -38.0521011352539062, -958.11602783203125, 59.10430145263671875, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+78, 180472, 0, 267, 272, '0', 0, 0, -62.8889007568359375, -985.572998046875, 57.37689971923828125, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+79, 180523, 0, 267, 272, '0', 0, 0, -54.4635009765625, -963.34002685546875, 53.45389938354492187, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 51886), -- Apple Bob (Area: Tarren Mill - Difficulty: 0) CreateObject1 +(@OGUID+80, 190078, 0, 267, 272, '0', 0, 0, -51.1632003784179687, -963.04302978515625, 53.454498291015625, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 51886); -- Candy Bucket (Area: Tarren Mill - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+80; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(12, @OGUID+0), +(12, @OGUID+1), +(12, @OGUID+2), +(12, @OGUID+3), +(12, @OGUID+4), +(12, @OGUID+5), +(12, @OGUID+6), +(12, @OGUID+7), +(12, @OGUID+8), +(12, @OGUID+9), +(12, @OGUID+10), +(12, @OGUID+11), +(12, @OGUID+12), +(12, @OGUID+13), +(12, @OGUID+14), +(12, @OGUID+15), +(12, @OGUID+16), +(12, @OGUID+17), +(12, @OGUID+18), +(12, @OGUID+19), +(12, @OGUID+20), +(12, @OGUID+21), +(12, @OGUID+22), +(12, @OGUID+23), +(12, @OGUID+24), +(12, @OGUID+25), +(12, @OGUID+26), +(12, @OGUID+27), +(12, @OGUID+28), +(12, @OGUID+29), +(12, @OGUID+30), +(12, @OGUID+31), +(12, @OGUID+32), +(12, @OGUID+33), +(12, @OGUID+34), +(12, @OGUID+35), +(12, @OGUID+36), +(12, @OGUID+37), +(12, @OGUID+38), +(12, @OGUID+39), +(12, @OGUID+40), +(12, @OGUID+41), +(12, @OGUID+42), +(12, @OGUID+43), +(12, @OGUID+44), +(12, @OGUID+45), +(12, @OGUID+46), +(12, @OGUID+47), +(12, @OGUID+48), +(12, @OGUID+49), +(12, @OGUID+50), +(12, @OGUID+51), +(12, @OGUID+52), +(12, @OGUID+53), +(12, @OGUID+54), +(12, @OGUID+55), +(12, @OGUID+56), +(12, @OGUID+57), +(12, @OGUID+58), +(12, @OGUID+59), +(12, @OGUID+60), +(12, @OGUID+61), +(12, @OGUID+62), +(12, @OGUID+63), +(12, @OGUID+64), +(12, @OGUID+65), +(12, @OGUID+66), +(12, @OGUID+67), +(12, @OGUID+68), +(12, @OGUID+69), +(12, @OGUID+70), +(12, @OGUID+71), +(12, @OGUID+72), +(12, @OGUID+73), +(12, @OGUID+74), +(12, @OGUID+75), +(12, @OGUID+76), +(12, @OGUID+77), +(12, @OGUID+78), +(12, @OGUID+79), +(12, @OGUID+80); diff --git a/sql/updates/world/master/2023_11_06_15_world_hillsbrad_foothills_eastpoint_tower.sql b/sql/updates/world/master/2023_11_06_15_world_hillsbrad_foothills_eastpoint_tower.sql new file mode 100644 index 00000000000..be34d671247 --- /dev/null +++ b/sql/updates/world/master/2023_11_06_15_world_hillsbrad_foothills_eastpoint_tower.sql @@ -0,0 +1,95 @@ +SET @CGUID := 3000244; +SET @OGUID := 3003621; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208145; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=208145; -- Candy Bucket + +-- Quests +DELETE FROM `quest_offer_reward` WHERE `ID`=28962; +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(28962, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket + +DELETE FROM `gameobject_queststarter` WHERE `id`=208145; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208145, 28962, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208145 AND `quest`=28962); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208145; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid`=@CGUID+0; +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`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 22816, 0, 267, 267, '0', 0, 0, 0, 0, -572.05365673828125, -1084.0196533203125, 61.66269692993164062, 1.999523639678955078, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 51886); -- Black Cat (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 230358 AND 230380; +DELETE FROM `gameobject` WHERE `guid`=231994; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 230358 AND 230380; +DELETE FROM `game_event_gameobject` WHERE `guid`=231994; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+25; +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, 180405, 0, 267, 267, '0', 0, 0, -573.0225830078125, -1055.782958984375, 61.02981948852539062, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+1, 180406, 0, 267, 267, '0', 0, 0, -622.02606201171875, -1058.673583984375, 65.68636322021484375, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+2, 180407, 0, 267, 267, '0', 0, 0, -573.625, -1095.704833984375, 61.52630615234375, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+3, 180408, 0, 267, 267, '0', 0, 0, -573.01739501953125, -1055.75, 62.6433258056640625, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+4, 180411, 0, 267, 267, '0', 0, 0, -616.98614501953125, -1058.6492919921875, 70.426666259765625, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+5, 180414, 0, 267, 267, '0', 0, 0, -576.5850830078125, -1067.4774169921875, 61.83576202392578125, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 51886), -- Cauldron (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+6, 180415, 0, 267, 267, '0', 0, 0, -576.98614501953125, -1071.4583740234375, 63.10279083251953125, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 51886), -- CandleBlack01 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+7, 180415, 0, 267, 267, '0', 0, 0, -576.74481201171875, -1071.7100830078125, 62.99906539916992187, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 51886), -- CandleBlack01 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+8, 180425, 0, 267, 267, '0', 0, 0, -576.5850830078125, -1071.2725830078125, 63.07996368408203125, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 51886), -- SkullCandle01 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+9, 180426, 0, 267, 267, '0', 0, 0, -607.5225830078125, -1062.607666015625, 99.010162353515625, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 51886), -- Bat01 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+10, 180426, 0, 267, 267, '0', 0, 0, -605.38018798828125, -1064.9271240234375, 98.2997589111328125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+11, 180426, 0, 267, 267, '0', 0, 0, -607.78643798828125, -1064.21533203125, 101.6134033203125, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 51886), -- Bat01 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+12, 180427, 0, 267, 267, '0', 0, 0, -604.4757080078125, -1064.017333984375, 87.59879302978515625, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 120, 255, 1, 51886), -- Bat02 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+13, 180427, 0, 267, 267, '0', 0, 0, -606.1805419921875, -1060.642333984375, 93.02291107177734375, 1.099556446075439453, 0, 0, 0.522498130798339843, 0.852640450000762939, 120, 255, 1, 51886), -- Bat02 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+14, 180427, 0, 267, 267, '0', 0, 0, -605.59027099609375, -1066.34033203125, 85.75673675537109375, 5.724681377410888671, 0, 0, -0.27563667297363281, 0.961261868476867675, 120, 255, 1, 51886), -- Bat02 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+15, 180427, 0, 267, 267, '0', 0, 0, -609.42535400390625, -1066.9166259765625, 85.75673675537109375, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 51886), -- Bat02 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+16, 180427, 0, 267, 267, '0', 0, 0, -606.41143798828125, -1068.6041259765625, 93.07080841064453125, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 51886), -- Bat02 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+17, 180471, 0, 267, 267, '0', 0, 0, -583.28472900390625, -1091.0711669921875, 65.45624542236328125, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+18, 180471, 0, 267, 267, '0', 0, 0, -576.54339599609375, -1096.99658203125, 65.57852935791015625, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+19, 180471, 0, 267, 267, '0', 0, 0, -582.76214599609375, -1097.454833984375, 65.53986358642578125, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+20, 180472, 0, 267, 267, '0', 0, 0, -576.9444580078125, -1090.74658203125, 67.08074951171875, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+21, 180523, 0, 267, 267, '0', 0, 0, -576.64581298828125, -1076.890625, 61.94430923461914062, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Apple Bob (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+22, 185438, 0, 267, 267, '0', 0, 0, -576.48785400390625, -1067.4254150390625, 62.5225982666015625, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 51886), -- Sitting Skeleton 04 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+23, 185454, 0, 267, 267, '0', 0, 0, -573.3125, -1094.91845703125, 61.53342819213867187, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 51886), -- Laying Skeleton 02 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+24, 208070, 0, 267, 267, '0', 0, 0, -617.015625, -1058.6944580078125, 67.40525054931640625, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 51886), -- Web Hanging Scale 2.0 (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 +(@OGUID+25, 208145, 0, 267, 267, '0', 0, 0, -584.96875, -1080.1771240234375, 65.88028717041015625, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 51886); -- Candy Bucket (Area: Hillsbrad Foothills - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid`=@CGUID+0; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(12, @CGUID+0); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+25; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(12, @OGUID+0), +(12, @OGUID+1), +(12, @OGUID+2), +(12, @OGUID+3), +(12, @OGUID+4), +(12, @OGUID+5), +(12, @OGUID+6), +(12, @OGUID+7), +(12, @OGUID+8), +(12, @OGUID+9), +(12, @OGUID+10), +(12, @OGUID+11), +(12, @OGUID+12), +(12, @OGUID+13), +(12, @OGUID+14), +(12, @OGUID+15), +(12, @OGUID+16), +(12, @OGUID+17), +(12, @OGUID+18), +(12, @OGUID+19), +(12, @OGUID+20), +(12, @OGUID+21), +(12, @OGUID+22), +(12, @OGUID+23), +(12, @OGUID+24), +(12, @OGUID+25); |