Necrovoice

Fix/Non bug? After several attempts to recreate this issue, I have been unable to do so.

Fixed Link: Removed imp from spell list.

Completed Link: Ghostlands Guardian waypoints.

Fixed Link: Quest gossip fix

Fixed Link: Hellfire portal fix

This seems to have been fixed.

Corrected the sql command and removed a few things from Aresella that had been removed back in 2009. Fix pending

after a few hiccups I have submitted the fix as well as some others

Here is the correction in its entirety. I would submit, but it looks like some of it was already done by the Implemented Version tag. Let me know what you would like me to do with this final product. /* remove unnecessary action food bar icon */ DELETE FROM `playercreateinfo_action` WHERE `race` = '10' AND `class` = '9' AND `button` = '11' AND `action` = '20857' AND `type` = '128'; DELETE FROM `playercreateinfo_action` WHERE `race` = '10' AND `class` = '8' AND `button` = '11' AND `action` = '20857' AND `type` = '128'; DELETE FROM `playercreateinfo_action` WHERE `race` = '10' AND `class` = '5' AND `button` = '11' AND `action` = '20857' AND `type` = '128'; DELETE FROM `playercreateinfo_action` WHERE `race` = '10' AND `class` = '4' AND `button` = '11' AND `action` = '20857' AND `type` = '128'; DELETE FROM `playercreateinfo_action` WHERE `race` = '10' AND `class` = '2' AND `button` = '11' AND `action` = '20857' AND `type` = '128'; DELETE FROM `playercreateinfo_action` WHERE `race` = '10' AND `class` = '3' AND `button` = '11' AND `action` = '20857' AND `type` = '128'; DELETE FROM `playercreateinfo_action` WHERE `race` = '8' AND `class` = '3' AND `button` = '11' AND `action` = '4604' AND `type` = '128'; DELETE FROM `playercreateinfo_action` WHERE `race` = '7' AND `class` = '6' AND `button` = '83' AND `action` = '41751' AND `type` = '128'; DELETE FROM `playercreateinfo_action` WHERE `race` = '6' AND `class` = '7' AND `button` = '11' AND `action` = '4604' AND `type` = '128'; DELETE FROM `playercreateinfo_action` WHERE `race` = '5' AND `class` = '4' AND `button` = '11' AND `action` = '4604' AND `type` = '128'; DELETE FROM `playercreateinfo_action` WHERE `race` = '5' AND `class` = '1' AND `button` = '83' AND `action` = '4604' AND `type` = '128'; DELETE FROM `playercreateinfo_action` WHERE `race` = '1' AND `class` = '9' AND `button` = '11' AND `action` = '4604' AND `type` = '128'; /* Add food icon to deathknight action bar */ Update `playercreateinfo_action` set `button` = '10' where `race` = '1' and `class` = '6' and `button` = '11' INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('1','6','11','41751','128'); INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('2','6','11','41751','128'); INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('3','6','11','41751','128'); INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('4','6','11','41751','128'); INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('5','6','11','41751','128'); INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('6','6','11','41751','128'); INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('8','6','11','41751','128'); INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('10','6','11','41751','128');

thanks to chucksta and after a few muckups on my own, I know how to commit to the repo..... Was this already added or can I try my new learned skills and add this?

message sent with my e-mail.

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