Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DB/Gameobject: Add 3 gameobjects in Shattrath - Aldor Rise #30008

Closed
CraftedRO opened this issue May 26, 2024 · 1 comment
Closed

DB/Gameobject: Add 3 gameobjects in Shattrath - Aldor Rise #30008

CraftedRO opened this issue May 26, 2024 · 1 comment

Comments

@CraftedRO
Copy link
Contributor

Description

Add Missing Alchemy Lab, Blacksmith's Anvil and Forge gameobjects in Shattrath - Aldor Rise, sniffed build: V10_2_7_54847.

SQL fix

-- Add 3 gameobjects in Shattrath - Aldor Rise
DELETE FROM `gameobject` WHERE `guid` IN (9898,9899,9900) AND `id` IN (194466,194467,194468);
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `ScriptName`, `VerifiedBuild`) VALUES
(9898, 194466, 530, 0, 0, 1, 1, -1737.48095703125, 5632.6103515625, 128.9701995849609375, 0, 0, 0, 0, 1, 120, 255, 1, '', 54847), -- Alchemy Lab
(9899, 194467, 530, 0, 0, 1, 1, -1745.2545166015625, 5646.84228515625, 128.023193359375, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, '', 54847), -- Blacksmith's Anvil
(9900, 194468, 530, 0, 0, 1, 1, -1747.6688232421875, 5648.66162109375, 128.023193359375, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, '', 54847); -- Forge

Branch

3.3.5

TC rev. hash/commit

ad3aeaa

Copy link

f96f847

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant