Jump to content

  • Ghostlands Guardian waypoint path missing

    Necrovoice

    By Necrovoice

      • Status: Completed
      Main Category: Database
      Sub-Category: NPC
      Version: 21.11 Milestone: 21 Priority: New
      Implemented Version: 22.1
     Share

    Name: Ghostlands Guardian 
    Entry: 16541
    GUID: 81719
    Location: Tranquillien - Ghostlands
    Current: This npc is missing it's rather long patrol around the Tranquillien area. 
    Goal to fix:  I hope to have the waypoints mapped out and a suggested fix for this NPC. This will include over 40+ waypoints as the NPC's patrol is quite extensive.

     Share
    Go to bugs

    User Feedback

    Recommended Comments

    Necrovoice

    With a bit of a headache now, here is my proposed fix.
      

    --  New spawn and movement type --

UPDATE `creature` SET `position_x` = '7556.562012',
`position_y` = '-6782.428711',
`position_z` = '89.593323',
`orientation` = '4.907670', 
`currentwaypoint` = '1',
`MovementType` = '2' WHERE `creature`.`guid` =81719;

-- Start waypoints here --

insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','1','7556.56','-6782.43','89.5933','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','2','7561.1','-6802.9','86.956','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','3','7546.32','-6817.21','86.0504','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','4','7559.13','-6831.35','87.6316','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','5','7579.86','-6831.06','87.5385','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','6','7593.4','-6876.1','94.9574','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','7','7586.1','-6896.58','98.1275','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','8','7575.99','-6912.47','104.453','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','9','7563.8','-6915.16','108.927','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','10','7555.05','-6911.26','111.841','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','11','7549.05','-6908.11','111.912','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','12','7557.71','-6888.95','111.919','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','13','7565.6','-6878.49','111.915','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','14','7547.66','-6907.34','111.914','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','15','7567.84','-6916.18','107.449','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','16','7575.57','-6909.63','104.033','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','17','7583.21','-6903.69','101.306','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','18','7591.76','-6890.46','95.0252','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','19','7595.94','-6868.54','93.7355','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','20','7577.35','-6854.17','92.7386','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','21','7579.04','-6821.75','86.4944','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','22','7561.34','-6803.08','86.9523','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','23','7556.88','-6782.65','89.5638','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','24','7561.53','-6803.22','86.9506','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','25','7579.4','-6821.83','86.4656','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','26','7577.68','-6854.38','92.7697','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','27','7596.26','-6868.79','93.7651','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','28','7591.96','-6886.12','95.0436','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','29','7581.4','-6904.48','101.83','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','30','7566.95','-6915.39','107.652','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','31','7554.97','-6911.45','111.831','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','32','7547.43','-6907.29','111.913','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','33','7565.92','-6878.83','111.914','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','34','7549.46','-6908.17','111.912','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','35','7564','-6915.36','108.825','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','36','7576.27','-6912.33','104.371','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','37','7586.01','-6896.5','98.1144','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','38','7590.52','-6882.68','95.0473','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','39','7591.96','-6881.96','95.0586','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','40','7593.3','-6874.97','94.8868','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','41','7579.99','-6833.07','87.9464','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','42','7560.5','-6830.33','87.5708','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','43','7546.66','-6817.26','86.1086','0','0','0','0','0','0','0','0','0','0','100','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('81719','44','7561.57','-6803.37','86.9503','0','0','0','0','0','0','0','0','0','0','100','0','0');

     

    Ghostlands Guardian_wp_fix.rar

    Edited by necrovoice
    Link to comment
    Share on other sites

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • 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