Necrovoice

Thanks for the guide..  So I used the github client to submit.. I think I did it right.    Should it appear on the site after showing that something was submitted , or will it appear once approved?

sorry to be such a pain.. I think I figured it out.. just not sure what branch to use and if its anything over than master, I am not sure I know how to switch it.

I use windows 10, in case you have tips for me to learn by.

I unfortunately never made a commit to the repo and sadly have no idea how to do so.

Played around with this for another  half hour just testing various scenarios. It seems to function fully... If interested I can pm info and make up an account to try it on my test world... just need to know a time/date when you would want to try it.. its only up when it needs to be. 

Well shit..... I got the port to work...

UPDATE `dbscripts_on_gossip` SET `data_flags` = '2' WHERE `dbscripts_on_gossip`.`id` = 9511;
 

Wish I had a better understanding of what many of the tables actually do

gossip_menu_option

menu_id  ||  action_script_id
9511       ||      9511
9513       ||      9511
9780       ||      9511
-----------------------------------
dbscripts_on_gossip

id: 9511
delay: 0
command: 15
datalong: 53360
datalong2: 0
buddy_entry: 0
search_radius: 0
data_flags: 8
dataint: 0
dataint2: 0
dataint3: 0
dataint4: 0
x: 0
y: 0
z: 0
o: 0
comments: cast Teleport to Dalaran

I tested this with a human and undead mage, both are able to get the quest.. The part where I see a breakdown is when the spell to teleport the play is cast. The npc will cast the spell, but then nothing.

http://img.photobucket.com/albums/v443/Nightfire101/WoWScrnShot_081916_102304.jpg

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

Unable to reproduce.  

Slegi , if this is still an issue for you, message me on the forums here and i will try to help you with it.

Confirmed, This NPC offers no text/quest until the above query is run, however this will cause an error during manos start up

Table gossip_menu 8441 are using non-existing text_is 10884

NPC:  Archmage Leryda
ID: 18253
GUID: 3957

Looking into this, yes. the spiders are still missing.

Name: Greater Spindleweb
ID: 16352

Location: The affected are seems to be the south east near Abndilien Estate, Sanctum of the sun.

http://www.wowhead.com/npc=16352/greater-spindleweb
 

Are you able to reproduce this? I gave it a try a few times. and have no issue with it.

I can confirm, this quest is  still broken

Thank you for the tip. I will keep that in mind for the future. Sorry this took so long to get back. Also I wanted to make sure that the correct fix was put in. Im not sure if its on my side or what, but I see a file. ghostland_fix(4).zip (2.7 KB) not the file ghostland_fix.rar (2.5 KB)

Feel free to PM me if you want.

Would love for someone to take another look at this and see if it can be implemented :)

I have also added a more recent fix as well as corrected some errors. Please see ghostland_fix.rar (2.5 KB)

I was slowly working on a revamp for the ghostlands sometime back as there is a lot wrong with both missing NPCs and many waypoint issues, but I have yet to really hear anything back from the devs on their they thoughts of what I submitted at the time so I gave up on the work I was doing, but yes I have noticed this as well with he spiders. on Two

has there been any news on this issue? I also seem to have this problem on Two as well.

Ok that has been corrected in my code, but I still cant seem to upload my fix

I was able to simply change the name of the item in the DB, but the actual "pop-up" information window still remains Battle-Bot Ignition Key. If I recall correctly, this has to do with the games DBC files. Something blizz should of fixed in 3.2.2 and simply missed and corrected later. But unless someone knows otherwise, we will need to live with it sadly :(.

This is 1 of 2 suggestions to update the bars issue showing food that players no longer start with. I will add the addition of the food icon for death knights shortly.
[code]DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '10' AND `class` = '4' AND `button` = '11' AND `action` = '20857' AND `type` = '128';
DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '10' AND `class` = '9' AND `button` = '11' AND `action` = '20857' AND `type` = '128';
DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '5' AND `class` = '4' AND `button` = '11' AND `action` = '4604' AND `type` = '128';
DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '1' AND `class` = '9' AND `button` = '11' AND `action` = '4604' AND `type` = '128';
DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '10' AND `class` = '8' AND `button` = '11' AND `action` = '20857' AND `type` = '128';
DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '10' AND `class` = '5' AND `button` = '11' AND `action` = '20857' AND `type` = '128';
DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '10' AND `class` = '2' AND `button` = '11' AND `action` = '20857' AND `type` = '128';
DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '8' AND `class` = '3' AND `button` = '11' AND `action` = '4604' AND `type` = '128';
DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '10' AND `class` = '3' AND `button` = '11' AND `action` = '20857' AND `type` = '128';
DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '6' AND `class` = '7' AND `button` = '11' AND `action` = '4604' AND `type` = '128';
DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '5' AND `class` = '1' AND `button` = '83' AND `action` = '4604' AND `type` = '128';
DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '7' AND `class` = '6' AND `button` = '83' AND `action` = '41751' AND `type` = '128';[/code]

Here is a reference that I am following to find the correct text.

[url]http://wowpedia.org/Sayge[/url]
[url]http://wowpedia.org/Sayge%27s_Fortunes[/url]

I just gave this quest a run and I have no issues. The quest does not complete and I get "Inventory is full" message. I also tested this but on a starter zone quest Dwarven Outfitters (ID 179) and have no issues.

I have attached the suggested additions and corrections for both the Fallen Ranger(s) ID: 16314 and the Deathhold Acolyte(s) ID: 16315.

Please use ghostland_fix(4).zip
The others can be removed. Sorry for the multi uploads.
This is my last revision. I was just looking around and I found an NPC in a wall that I missed. this NPC replaced a custom added NPC within one of the older zip files.

Anchorite Barada only gives the conversation text "I am ready. Anchorite. Let us begin the Exorcism." It will not allow you continue once clicked on.