aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2023_11_06_05_world_ghostlands_tranquillien.sql141
1 files changed, 141 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_06_05_world_ghostlands_tranquillien.sql b/sql/updates/world/master/2023_11_06_05_world_ghostlands_tranquillien.sql
new file mode 100644
index 00000000000..c7841352dd9
--- /dev/null
+++ b/sql/updates/world/master/2023_11_06_05_world_ghostlands_tranquillien.sql
@@ -0,0 +1,141 @@
+SET @OGUID := 3002535;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=190075; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=190075; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=51886 WHERE `ID`=12373;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=190075;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(190075, 12373, 51886);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=190075 AND `quest`=12373);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=190075;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid`=37686;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 78351 AND 78403;
+DELETE FROM `game_event_gameobject` WHERE `guid`=37686;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 78351 AND 78403;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+54;
+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, 530, 3433, 3488, '0', 0, 0, 7566.19873046875, -6800.0595703125, 87.48343658447265625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+1, 180405, 530, 3433, 3488, '0', 0, 0, 7552.51220703125, -6816.896484375, 86.94879913330078125, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+2, 180405, 530, 3433, 3488, '0', 0, 0, 7577.56787109375, -6858.06787109375, 93.35547637939453125, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+3, 180406, 530, 3433, 3488, '0', 0, 0, 7552.9765625, -6801.01416015625, 87.0927886962890625, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+4, 180406, 530, 3433, 3488, '0', 0, 0, 7512.57373046875, -6856.6826171875, 84.6278228759765625, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+5, 180407, 530, 3433, 3488, '0', 0, 0, 7571.5947265625, -6855.142578125, 93.347503662109375, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+6, 180407, 530, 3433, 3488, '0', 0, 0, 7572.27783203125, -6819.2998046875, 86.6661376953125, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+7, 180407, 530, 3433, 3488, '0', 0, 0, 7576.37939453125, -6780.384765625, 87.40020751953125, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+8, 180411, 530, 3433, 3488, '0', 0, 0, 7552.2109375, -6766.90283203125, 96.955322265625, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+9, 180411, 530, 3433, 3488, '0', 0, 0, 7557.6005859375, -6889.19091796875, 103.97802734375, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+10, 180415, 530, 3433, 3488, '0', 0, 0, 7565.1171875, -6815.14794921875, 88.056915283203125, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+11, 180415, 530, 3433, 3488, '0', 0, 0, 7602.1162109375, -6828.63916015625, 86.01513671875, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+12, 180415, 530, 3433, 3488, '0', 0, 0, 7612.1103515625, -6804.234375, 81.90377044677734375, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+13, 180415, 530, 3433, 3488, '0', 0, 0, 7555.83056640625, -6833.35400390625, 89.27994537353515625, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+14, 180415, 530, 3433, 3488, '0', 0, 0, 7612.02099609375, -6828.265625, 83.91069793701171875, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+15, 180415, 530, 3433, 3488, '0', 0, 0, 7566.6728515625, -6821.13037109375, 88.058013916015625, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+16, 180415, 530, 3433, 3488, '0', 0, 0, 7567.126953125, -6817.865234375, 88.05730438232421875, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+17, 180415, 530, 3433, 3488, '0', 0, 0, 7564.033203125, -6823.21337890625, 88.05828857421875, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+18, 180415, 530, 3433, 3488, '0', 0, 0, 7558.4287109375, -6818.41259765625, 88.05863189697265625, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+19, 180415, 530, 3433, 3488, '0', 0, 0, 7563.42822265625, -6814.640625, 88.05914306640625, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+20, 180415, 530, 3433, 3488, '0', 0, 0, 7506.4765625, -6809.16650390625, 81.56932830810546875, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+21, 180415, 530, 3433, 3488, '0', 0, 0, 7516.30908203125, -6806.7744140625, 83.16226959228515625, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+22, 180415, 530, 3433, 3488, '0', 0, 0, 7561.72412109375, -6814.66357421875, 88.05759429931640625, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+23, 180415, 530, 3433, 3488, '0', 0, 0, 7558.94384765625, -6816.72802734375, 88.05735015869140625, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+24, 180415, 530, 3433, 3488, '0', 0, 0, 7566.345703125, -6816.29833984375, 88.05789947509765625, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+25, 180415, 530, 3433, 3488, '0', 0, 0, 7565.5078125, -6822.4482421875, 88.05878448486328125, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+26, 180415, 530, 3433, 3488, '0', 0, 0, 7567.19970703125, -6819.6005859375, 88.0578460693359375, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+27, 180415, 530, 3433, 3488, '0', 0, 0, 7560.62060546875, -6822.765625, 88.0595245361328125, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+28, 180415, 530, 3433, 3488, '0', 0, 0, 7558.51220703125, -6820.00927734375, 88.058135986328125, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+29, 180415, 530, 3433, 3488, '0', 0, 0, 7559.306640625, -6821.54443359375, 88.05991363525390625, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+30, 180415, 530, 3433, 3488, '0', 0, 0, 7605.087890625, -6811.048828125, 84.11589813232421875, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+31, 180415, 530, 3433, 3488, '0', 0, 0, 7560.125, -6815.39990234375, 88.05716705322265625, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+32, 180415, 530, 3433, 3488, '0', 0, 0, 7562.18505859375, -6823.2880859375, 88.0597076416015625, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+33, 180415, 530, 3433, 3488, '0', 0, 0, 7546.27783203125, -6830.88525390625, 88.811309814453125, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+34, 180426, 530, 3433, 3488, '0', 0, 0, 7567.49853515625, -6812.46533203125, 101.9165725708007812, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 51886), -- Bat01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+35, 180426, 530, 3433, 3488, '0', 0, 0, 7571.84619140625, -6841.22216796875, 98.84716033935546875, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 51886), -- Bat01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+36, 180426, 530, 3433, 3488, '0', 0, 0, 7547.64306640625, -6825.2880859375, 94.4019317626953125, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 51886), -- Bat01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+37, 180426, 530, 3433, 3488, '0', 0, 0, 7572.0068359375, -6815.111328125, 93.45476531982421875, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 51886), -- Bat01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+38, 180426, 530, 3433, 3488, '0', 0, 0, 7564.71875, -6828.1181640625, 96.1754608154296875, 0.994837164878845214, 0, 0, 0.477158546447753906, 0.878817260265350341, 120, 255, 1, 51886), -- Bat01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+39, 180426, 530, 3433, 3488, '0', 0, 0, 7572.7431640625, -6822.45849609375, 90.08892059326171875, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 51886), -- Bat01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+40, 180426, 530, 3433, 3488, '0', 0, 0, 7557.046875, -6828.94970703125, 95.44632720947265625, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 51886), -- Bat01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+41, 180426, 530, 3433, 3488, '0', 0, 0, 7569.08154296875, -6825.9912109375, 89.69709014892578125, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 51886), -- Bat01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+42, 180426, 530, 3433, 3488, '0', 0, 0, 7560.46728515625, -6812.44091796875, 96.04750823974609375, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 51886), -- Bat01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+43, 180426, 530, 3433, 3488, '0', 0, 0, 7560.97216796875, -6804.74658203125, 97.29666900634765625, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 51886), -- Bat01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+44, 180426, 530, 3433, 3488, '0', 0, 0, 7547.69189453125, -6814.10400390625, 93.27422332763671875, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 51886), -- Bat01 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+45, 180427, 530, 3433, 3488, '0', 0, 0, 7569.0244140625, -6809.578125, 94.5003814697265625, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 51886), -- Bat02 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+46, 180427, 530, 3433, 3488, '0', 0, 0, 7567.3759765625, -6835.13525390625, 98.69683074951171875, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 51886), -- Bat02 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+47, 180427, 530, 3433, 3488, '0', 0, 0, 7574.76806640625, -6814.0380859375, 95.28166961669921875, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 51886), -- Bat02 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+48, 180427, 530, 3433, 3488, '0', 0, 0, 7589.01123046875, -6833.8505859375, 98.975738525390625, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 51886), -- Bat02 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+49, 180427, 530, 3433, 3488, '0', 0, 0, 7542.7353515625, -6808.8212890625, 93.34178924560546875, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 51886), -- Bat02 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+50, 180427, 530, 3433, 3488, '0', 0, 0, 7573.91845703125, -6803.22900390625, 94.867401123046875, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 51886), -- Bat02 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+51, 180427, 530, 3433, 3488, '0', 0, 0, 7558.27978515625, -6809.564453125, 94.68666839599609375, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 51886), -- Bat02 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+52, 180427, 530, 3433, 3488, '0', 0, 0, 7538.96875, -6832.84375, 96.30994415283203125, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 51886), -- Bat02 (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+53, 180523, 530, 3433, 3488, '0', 0, 0, 7556.11572265625, -6883.65478515625, 96.47802734375, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 51886), -- Apple Bob (Area: Tranquillien - Difficulty: 0) CreateObject1
+(@OGUID+54, 190075, 530, 3433, 3488, '0', 0, 0, 7564.82470703125, -6889.671875, 96.026641845703125, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 51886); -- Candy Bucket (Area: Tranquillien - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+54;
+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);