diff options
| -rw-r--r-- | sql/updates/world/master/2025_04_04_02_world.sql | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_04_04_02_world.sql b/sql/updates/world/master/2025_04_04_02_world.sql new file mode 100644 index 00000000000..9eb071252c4 --- /dev/null +++ b/sql/updates/world/master/2025_04_04_02_world.sql @@ -0,0 +1,42 @@ +SET @CGUID := 7001805; +SET @OGUID := 7000430; + +-- Creature +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`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 124953, 1643, 8721, 9033, '0', 0, 0, 0, 0, 187.4895782470703125, 1987.69970703125, 101.0208892822265625, 3.432718276977539062, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888); -- Helena Gentle (Area: Shrouded Foothills - Difficulty: 0) CreateObject2 + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+24; +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, 295778, 1643, 8721, 9032, '0', 0, 0, -101.710678100585937, 1950.5103759765625, 34.23123931884765625, 5.388891220092773437, 0, 0, -0.43239498138427734, 0.901684284210205078, 120, 255, 1, 59888), -- Fire (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+1, 295802, 1643, 8721, 9032, '0', 0, 0, 54.34577178955078125, 1828.55419921875, 47.43634796142578125, 4.965455532073974609, 0, 0, -0.61221981048583984, 0.790687620639801025, 120, 255, 1, 59888), -- Chair (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+2, 295801, 1643, 8721, 9032, '0', 0, 0, 55.91382980346679687, 1826.363525390625, 47.43634414672851562, 2.55689859390258789, 0, 0, 0.957570075988769531, 0.288200527429580688, 120, 255, 1, 59888), -- Chair (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+3, 303028, 1643, 8721, 9032, '0', 0, 0, 49.05208206176757812, 1661.21533203125, 1.157267093658447265, 4.790929317474365234, 0, 0, -0.67880058288574218, 0.734322667121887207, 120, 255, 1, 59888), -- Chair (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+4, 295778, 1643, 8721, 9032, '0', 0, 0, 51.80818557739257812, 1829.400390625, 47.31052780151367187, 3.826812028884887695, 0, 0, -0.94188117980957031, 0.335946202278137207, 120, 255, 1, 59888), -- Fire (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+5, 303035, 1643, 8721, 9032, '0', 0, 0, 79.13541412353515625, 1689.9739990234375, 0.114583350718021392, 2.871063947677612304, 0, 0, 0.990865707397460937, 0.134852290153503417, 120, 255, 1, 59888), -- Chair (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+6, 303034, 1643, 8721, 9032, '0', 0, 0, 82.82465362548828125, 1691.201416015625, 0.081597223877906799, 5.611230850219726562, 0, 0, -0.32969188690185546, 0.944088578224182128, 120, 255, 1, 59888), -- Chair (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+7, 296901, 1643, 8721, 9032, '0', 0, 0, 65.90277862548828125, 1834.9461669921875, 47.23859405517578125, 5.436700820922851562, 0, 0, -0.41071891784667968, 0.911761999130249023, 120, 255, 1, 59888), -- Chair (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+8, 303033, 1643, 8721, 9032, '0', 0, 0, 86.58333587646484375, 1689.2135009765625, -0.00694444449618458, 3.115387916564941406, 0, 0, 0.999914169311523437, 0.013101960532367229, 120, 255, 1, 59888), -- Chair (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+9, 296900, 1643, 8721, 9032, '0', 0, 0, 64.34027862548828125, 1829.7708740234375, 47.20653152465820312, 0.052360795438289642, 0, 0, 0.026177406311035156, 0.999657332897186279, 120, 255, 1, 59888), -- Chair (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+10, 303032, 1643, 8721, 9032, '0', 0, 0, 86.5069427490234375, 1691.064208984375, 0.02604166604578495, 3.115387916564941406, 0, 0, 0.999914169311523437, 0.013101960532367229, 120, 255, 1, 59888), -- Chair (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+11, 303037, 1643, 8721, 9032, '0', 0, 0, 76.111114501953125, 1689.453125, 0.149305552244186401, 0.235617712140083312, 0, 0, 0.117536544799804687, 0.993068516254425048, 120, 255, 1, 59888), -- Chair (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+12, 303027, 1643, 8721, 9032, '0', 0, 0, 49.31423568725585937, 1658.267333984375, 1.167453169822692871, 2.251477956771850585, 0, 0, 0.902585983276367187, 0.43050965666770935, 120, 255, 1, 59888), -- Chair (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+13, 303036, 1643, 8721, 9032, '0', 0, 0, 77.6319427490234375, 1687.9947509765625, 0.102430559694766998, 1.60569620132446289, 0, 0, 0.71933746337890625, 0.694660782814025878, 120, 255, 1, 59888), -- Chair (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+14, 272198, 1643, 8721, 9032, '0', 0, 0, -50.2795143127441406, 1948.3680419921875, 37.52858352661132812, 1.615791201591491699, 0, 0, 0.722834587097167968, 0.691021084785461425, 120, 255, 1, 59888), -- Cursed Charm (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+15, 277420, 1643, 8721, 9032, '0', 0, 0, 56.34375, 1834.3021240234375, 47.41795730590820312, 2.877968549728393554, 0, 0, 0.99132537841796875, 0.131430670619010925, 120, 255, 1, 59888), -- Stool (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+16, 272199, 1643, 8721, 9032, '0', 0, 0, 61.43229293823242187, 1828.420166015625, 47.44915008544921875, 6.090238571166992187, 0, 0, -0.09632396697998046, 0.995350062847137451, 120, 255, 1, 59888), -- Stool (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+17, 272174, 1643, 8721, 9032, '0', 0, 0, 54.92361068725585937, 1834.80908203125, 47.40673446655273437, 1.28933107852935791, 0, 0, 0.600931167602539062, 0.799300789833068847, 120, 255, 1, 59888), -- Table (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+18, 272198, 1643, 8721, 9032, '0', 0, 0, -52.3211822509765625, 1950.107666015625, 35.99113845825195312, 0.09384927898645401, 0, 0, 0.046907424926757812, 0.998899221420288085, 120, 255, 1, 59888), -- Cursed Charm (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+19, 277380, 1643, 8721, 9032, '0', 0, 0, -44.6545143127441406, 1924.93408203125, 33.0326995849609375, 0.012832976877689361, 0.037631988525390625, -0.18040752410888671, 0.013010025024414062, 0.982785701751708984, 120, 255, 1, 59888), -- Tainted Pig Feed (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+20, 290442, 1643, 8721, 9032, '0', 0, 0, 55.53645706176757812, 1834.4132080078125, 48.20467758178710937, 0, 0, 0, 0, 1, 120, 255, 1, 59888), -- Food (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+21, 278670, 1643, 8721, 9032, '0', 0, 0, -91.3211822509765625, 1950.251708984375, 35.01362228393554687, 1.832701325416564941, 0, 0, 0.793385505676269531, 0.608719468116760253, 120, 255, 1, 59888), -- Cursed Charm (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+22, 290441, 1643, 8721, 9032, '0', 0, 0, 54.98090362548828125, 1834.6163330078125, 48.20263671875, 1.135462641716003417, 0, 0, 0.537720680236816406, 0.843123018741607666, 120, 255, 1, 59888), -- Tea Pot (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+23, 278671, 1643, 8721, 9032, '0', 0, 0, 1.795138955116271972, 1951.65625, 37.55127716064453125, 3.013794183731079101, 0, 0, 0.997959136962890625, 0.063855722546577453, 120, 255, 1, 59888), -- Cursed Charm (Area: Fallhaven - Difficulty: 0) CreateObject1 +(@OGUID+24, 278670, 1643, 8721, 9032, '0', 0, 0, -76.8993072509765625, 1973.6927490234375, 38.3642730712890625, 2.210199356079101562, 0, 0, 0.8935089111328125, 0.449045419692993164, 120, 255, 1, 59888); -- Cursed Charm (Area: Fallhaven - Difficulty: 0) CreateObject1 +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+24; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+0, 0, 0, 0.99086618423461914, 0.134848982095718383, 0, 0), -- Fire +(@OGUID+1, 0, 0, 0.608758747577667236, 0.793355405330657958, 0, 0), -- Chair +(@OGUID+2, 0, 0, 0.608758747577667236, 0.793355405330657958, 0, 0), -- Chair +(@OGUID+4, 0, 0, 0.608758747577667236, 0.793355405330657958, 0, 0); -- Fire |