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/Misc: Update two Levers position in Shadowfang Keep #30004

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

DB/Misc: Update two Levers position in Shadowfang Keep #30004

CraftedRO opened this issue May 24, 2024 · 1 comment

Comments

@CraftedRO
Copy link
Contributor

CraftedRO commented May 24, 2024

Description

https://youtu.be/PQOifDDT6z8?t=610

SQL fix

-- Update two Levers position in Shadowfang Keep
UPDATE `gameobject` SET `orientation`=5.312439441680908203, `rotation0`=-0.58448696136474609, `rotation1`=-0.39796257019042968, `rotation2`=-0.58448696136474609, `rotation3`=0.397964507341384887, `spawntimesecs`=7200, `animprogress`=255, `VerifiedBuild`=54737 WHERE `guid`=32443 AND `id`=101812;
UPDATE `gameobject` SET `position_x`=-113.761627197265625, `position_z`=157.854644775390625, `rotation0`=0.694697380065917968, `rotation1`=-0.13189220428466796, `rotation2`=0.694696426391601562, `rotation3`=0.131897181272506713, `VerifiedBuild`=54737 WHERE `guid`=32480 AND `id`=18899;

Branch

3.3.5

TC rev. hash/commit

d8240fb

@CraftedRO CraftedRO changed the title DB/Misc: Update one lever in Shadowfang Keep DB/Misc: Update two Levers position in Shadowfang Keep May 25, 2024
Aokromes added a commit that referenced this issue May 26, 2024
Copy link

04e0801

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