Wandering Isle fixes | MoP 5.4.8

eltnen

Gold Supporter
Verified Member
12
2023
7
Location
Netherlands
Fixed some issues and visual bugs.
I will update this thread as I add more.

--- 2023-07-09 ---
- Lowered "Jaomin Ro" damage since some classes have no proper abilities here yet -
SQL:
UPDATE `mop_world`.`creature_template` SET `mindmg` = '6', `maxdmg` = '10' WHERE (`entry` = '54611');

- Lowered "Huojin Trainee" damage since some classes have no proper abilities here yet -
SQL:
UPDATE `mop_world`.`creature_template` SET `mindmg` = '4', `maxdmg` = '8' WHERE (`entry` = '65470');

- Lowered "Amberleaf Scamp" damage since somce classes have no proper abilities here yet -
SQL:
UPDATE `mop_world`.`creature_template` SET `mindmg` = '6', `maxdmg` = '12' WHERE (`entry` = '54130');

- Fixed game object orientation of several objects -
SQL:
UPDATE `mop_world`.`gameobject` SET `orientation` = '6.11458', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540331');
UPDATE `mop_world`.`gameobject` SET `orientation` = '3.12082', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540333');
UPDATE `mop_world`.`gameobject` SET `orientation` = '2.6817', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540334');
UPDATE `mop_world`.`gameobject` SET `orientation` = '1.39967', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540335');
UPDATE `mop_world`.`gameobject` SET `orientation` = '1.43788', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540336');
UPDATE `mop_world`.`gameobject` SET `orientation` = '4.52197', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540337');
UPDATE `mop_world`.`gameobject` SET `orientation` = '4.49827', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540338');
UPDATE `mop_world`.`gameobject` SET `orientation` = '6.1145', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540339');
UPDATE `mop_world`.`gameobject` SET `orientation` = '4.49362', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540340');
UPDATE `mop_world`.`gameobject` SET `orientation` = '1.08123', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540342');
UPDATE `mop_world`.`gameobject` SET `orientation` = '4.58061', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540345');
UPDATE `mop_world`.`gameobject` SET `orientation` = '6.05677', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540348');
UPDATE `mop_world`.`gameobject` SET `orientation` = '1.42288', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540349');
UPDATE `mop_world`.`gameobject` SET `orientation` = '3.20748', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540350');
UPDATE `mop_world`.`gameobject` SET `orientation` = '6.00586', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540352');
UPDATE `mop_world`.`gameobject` SET `orientation` = '2.86251', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540353');
UPDATE `mop_world`.`gameobject` SET `orientation` = '6.14024', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540355');
UPDATE `mop_world`.`gameobject` SET `orientation` = '2.89916', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540356');
UPDATE `mop_world`.`gameobject` SET `orientation` = '4.26916', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540358');
UPDATE `mop_world`.`gameobject` SET `orientation` = '2.66642', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540361');
UPDATE `mop_world`.`gameobject` SET `orientation` = '2.06167', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540362');
UPDATE `mop_world`.`gameobject` SET `orientation` = '1.94255', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540363');
UPDATE `mop_world`.`gameobject` SET `orientation` = '3.80918', `rotation0` = '-0', `rotation1` = '-0', `rotation2` = '-0.956177', `rotation3` = '0.29279' WHERE (`guid` = '540365');
UPDATE `mop_world`.`gameobject` SET `orientation` = '1.37099', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540366');
UPDATE `mop_world`.`gameobject` SET `orientation` = '3.20442', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540369');
UPDATE `mop_world`.`gameobject` SET `orientation` = '4.48481', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540371');
UPDATE `mop_world`.`gameobject` SET `orientation` = '1.35676', `rotation0` = '-0', `rotation1` = '-0', `rotation2` = '-0.992348', `rotation3` = '-0.12347' WHERE (`guid` = '540372');
UPDATE `mop_world`.`gameobject` SET `orientation` = '2.34267', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540373');
UPDATE `mop_world`.`gameobject` SET `orientation` = '2.3274', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540374');
UPDATE `mop_world`.`gameobject` SET `orientation` = '1.35037', `rotation0` = '0', `rotation1` = '0', `rotation2` = '0', `rotation3` = '1' WHERE (`guid` = '540375');
UPDATE `mop_world`.`gameobject` SET `orientation` = '5.89872', `rotation0` = '-0', `rotation1` = '-0', `rotation2` = '-0.82504', `rotation3` = '0.565075' WHERE (`guid` = '540376');

- Made some npc's sit down on a seat instead of standing on it -
SQL:
UPDATE `mop_world`.`creature_template_addon` SET `bytes1` = '1' WHERE (`entry` = '65059');
UPDATE `mop_world`.`creature_template_addon` SET `bytes1` = '1' WHERE (`entry` = '65070');
UPDATE `mop_world`.`creature_template_addon` SET `bytes1` = '1' WHERE (`entry` = '65248');
 
Top