Jump to content

[Zero] Database updates


Swater96
 Share

Recommended Posts

This fixes Hegnar Rumbleshot's position

UPDATE creature SET position_x = '-6015.695801', position_y = '-201.567734', position_z = '407.405457', orientation = '0.111121' WHERE guid = '265';

This fixes Melris Malagan's position in Stormwind City, on the latest DB.

UPDATE creature SET position_x = '-8823.625000', position_y = '630.498901', position_z = '94.014442', orientation = '3.803255' WHERE guid = '79694';

This fixes High Sorcerer Andromath's position in Stormwind City, in the Mage Tower.

UPDATE creature SET position_x = '-9010.791992', position_y = '876.604919', position_z = '148.617188', orientation = '4.737573' WHERE guid = '90470';

This fixes a slanted position of a Stormwind Royal Guard near the entrance of the Stormwind Keep.

UPDATE creature SET position_x = '-8530.925781', position_y = '439.034271', position_z = '105.048889', orientation = '0.652942' WHERE guid = '10508';

This fixes Mithras Ironhill's slightly off positioning in Battleground room of Stormwind Keep.

UPDATE creature SET position_x = '-8401.429688', position_y = '275.915100', position_z = '120.885887', orientation = '0.641223' WHERE guid = '10499';

This fixes the VERYY slow walkspeed of Baron Geddon.. It is now blizzlike.

UPDATE `world`.`creature_template` SET `speed_walk`='5' WHERE `entry`='12056';

Link to comment
Share on other sites

  • 2 months later...
 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use