Chucksta

Judging by the entries in the tables (creature_template, creature_loot_template, conditions, quest_template), this should work, but I am unable to test it right now.

[B]EDIT:[/B] Tested in-game and found to be working as intended :)

It looks like this issue has been fixed. I went in-game and took on a number of these creatures, with no issues at all.

This issue still exists

Checked Zero and the minion is red there too.

I checked the Warlock trainers in SW, and the imp (Zardeth's Minion: entry 1733) there is green!

The difference between the 2 imps, is that the one in SW has a creature_template entry, whereas the one in Goldshire is handled as a pet.

This is working perfectly on MaNGOS Two. I will figure out what needs to be copied over :)

Quest: 9483, "Life's Finer Pleasures", is missing the CompleteScript entry, plus the script itself from the [B]dbscripts_on_quest_end[/B] table

[B][SIZE=3]**** [COLOR="#008000"]THE FIX (NOT!)[/COLOR] ****[/SIZE][/B]


[B][SIZE=3]MaNGOS One[/SIZE][/B]

--
[B][COLOR="#0000FF"]DELETE FROM db_script_string WHERE entry IN (2000000388, 2000000389, 2000000390, 2000000391, 2000000404, 2000000405, 2000000406);[/COLOR][/B]
[B][COLOR="#0000FF"]INSERT INTO db_script_string (entry, content_default, sound, type, language, emote) VALUES
('2000000388', 'Ok, let\'s go. I know just the perfect spot!', '0', '0', '0', '0'),
('2000000389', 'What... is happening... to me? Get this cat away from me!', '0', '0', '0', '0'),
('2000000390', 'Twinkle looks at Viera Sunwhisper with very hungry eyes.', '0', '2', '0', '0'),
('2000000391', '%s scurries away, attempting to flee from Twinkle.', '0', '2', '0', '0'),
('2000000404', 'Did you find something fun to chase around, Twinkle? I bet you did!', '0', '0', '0', '1');
('2000000405', 'It\'s just you and me, Twinkle. Daddy\'s not going to be coming home.', '0', '0', '0', '1');
('2000000406', 'I wonder how far this would launch that white cat...', '0', '0', '0', '0');[/COLOR][/B]

-- On Quest Complete script
[B][COLOR="#0000FF"]DELETE FROM dbscripts_on_quest_end WHERE id = 9483;[/COLOR][/B]
[B][COLOR="#0000FF"]INSERT INTO dbscripts_on_quest_end (id, delay, command, datalong, datalong2, buddy_entry, search_radius, data_flags, dataint, dataint2, dataint3, dataint4, x, y, z, o, comments) VALUES
(9483,0,29,3,2,0,0,0,0,0,0,0,0,0,0,0,'npc_flag removed'),
(9483,1,21,1,0,0,0,0,0,0,0,0,0,0,0,0,'Viera Sunwhisper - active'),
(9483,3,28,0,0,0,0,0,0,0,0,0,0,0,0,0,'STATE_STAND'),
(9483,6,0,0,0,0,0,0,2000000388,0,0,0,0,0,0,0,''),
(9483,6,32,1,0,17230,61963,23,0,0,0,0,0,0,0,0,'wp pause'),
(9483,7,25,1,0,17230,61963,23,0,0,0,0,0,0,0,0,'RUN ON'),
(9483,8,3,0,0,0,0,0,0,0,0,0,-656.13,4146.6,64.128,2.16845,''),
(9483,8,3,0,0,17230,61963,23,0,0,0,0,-656.13,4146.6,64.128,2.16845,''),
(9483,11,3,0,0,0,0,0,0,0,0,0,-682.265,4148.52,63.9026,1.87414,''),
(9483,18,3,0,0,17230,61963,23,0,0,0,0,-682.265,4148.52,63.9026,1.87414,''),
(9483,19,3,0,0,0,0,0,0,0,0,0,-699.983,4184.54,57.9007,2.85353,''),
(9483,20,25,0,0,17230,61963,23,0,0,0,0,0,0,0,0,'RUN OFF'),
(9483,21,3,0,0,17230,61963,23,0,0,0,0,-699.983,4184.54,57.9007,2.85353,''),
(9483,30,3,0,0,0,0,0,0,0,0,0,-718.249,4174.95,51.9827,4.24132,''),
(9483,31,3,0,0,17230,61963,23,0,0,0,0,-718.249,4174.95,51.9827,4.24132,''),
(9483,37,3,0,0,0,0,0,0,0,0,0,-719.781,4168.6,51.2242,4.51228,''),
(9483,38,3,0,0,17230,61963,23,0,0,0,0,-718.649,4170.65,51.8661,4.50951,''),
(9483,36,32,1,0,0,0,0,0,0,0,0,0,0,0,0,'wp pause'),
(9483,93,31,17230,220,0,0,0,0,0,0,0,0,0,0,0,''),
(9483,94,18,0,0,17230,61963,23,0,0,0,0,0,0,0,0,''),
(9483,94,18,0,0,17226,61961,23,0,0,0,0,0,0,0,0,'');[/COLOR][/B]

-- link to the On Quest Complete script
[B][COLOR="#0000FF"]UPDATE quest_template SET CompleteScript=9483 WHERE entry=9483;[/COLOR][/B]

-- make the same as in MaNGOS Two
[B][COLOR="#0000FF"]UPDATE creature_ai_scripts SET action2_type = 47 WHERE id = 1722601;[/COLOR][/B]

-- missing from MaNGOS One
[B][COLOR="#0000FF"]DELETE FROM creature_movement_template WHERE entry = 17226;[/COLOR][/B]
[B][COLOR="#0000FF"]INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUES
(17226,1,-719.781,4168.6,51.2242,7000,1722601,0,0,0,0,0,0,0,4.51228,0,0),
(17226,2,-723.602,4123.29,49.3491,1000,1722602,0,0,0,0,0,0,0,4.60652,0,0);[/COLOR][/B]

Cripes, more missing stuff... [B]creature_movement_template [/B]and [B]dbscripts_on_creature_movement [/B](1722601, 1722602), -- 2000000389 -- 2000000390 -- 2000000391

-- missing from MaNGOS One
[B][COLOR="#0000FF"]DELETE FROM dbscripts_on_creature_movement WHERE id IN (1722601,1722602);[/COLOR][/B]
[B][COLOR="#0000FF"]INSERT INTO dbscripts_on_creature_movement (id, delay, command, datalong, datalong2, buddy_entry, search_radius, data_flags, dataint, dataint2, dataint3, dataint4, x, y, z, o, comments) VALUES
(1722601,0,25,1,0,0,0,0,0,0,0,0,0,0,0,0,'RUN ON'),
(1722601,1,25,1,0,17230,61963,23,0,0,0,0,0,0,0,0,'RUN ON'),
(1722601,1,0,0,0,0,0,0,2000000389,0,0,0,0,0,0,0,''),
(1722601,5,0,0,0,0,0,0,2000000390,0,0,0,0,0,0,0,''),
(1722601,7,0,0,0,0,0,0,2000000391,0,0,0,0,0,0,0,''),
(1722601,11,3,0,0,17230,61963,23,0,0,0,0,-723.602,4123.29,49.3491,4.60652,''),
(1722601,9,21,0,0,0,0,0,0,0,0,0,0,0,0,0,'Viera Sunwhisper - inactive'),
(1722601,17,18,0,0,17230,61963,23,0,0,0,0,0,0,0,0,''),
(1722602,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,'');[/COLOR][/B]

-- TWINKLE (cat)
-- missing records
[B]creature_ai_scripts[/B], [B]creature_movement_template[/B], [B]dbscripts_on_creature_movement[/B]

-- cat's movement
[B][COLOR="#0000FF"]DELETE FROM creature_movement_template WHERE entry = 17230;[/COLOR][/B]
[B][COLOR="#0000FF"]INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUES
(17230,1,-603.059,4166.03,64.3336,0,0,0,0,0,0,0,0,0,4.63706,0,0),
(17230,2,-600.881,4161.52,64.9931,0,0,0,0,0,0,0,0,0,5.42795,0,0),
(17230,3,-595.116,4157.8,65.2767,0,0,0,0,0,0,0,0,0,5.75546,0,0),
(17230,4,-590.633,4155.53,67.8345,0,0,0,0,0,0,0,0,0,5.82222,0,0),
(17230,5,-576.829,4149.44,68.1243,5000,1723001,0,0,0,0,0,0,0,5.86542,0,0),
(17230,6,-591.253,4155.71,67.667,0,0,0,0,0,0,0,0,0,2.71597,0,0),
(17230,7,-594.879,4158.15,65.2685,0,0,0,0,0,0,0,0,0,2.23766,0,0),
(17230,8,-599.785,4161.72,65.0972,0,0,0,0,0,0,0,0,0,1.9667,0,0),
(17230,9,-601.114,4164.75,64.754,0,0,0,0,0,0,0,0,0,1.20172,0,0),
(17230,10,-597.099,4176,64.9199,240000,0,0,0,0,0,0,0,0,0.944113,0,0),
(17230,11,-597.099,4176,64.9199,1000,1723002,0,0,0,0,0,0,0,0.944113,0,0),
(17230,12,-602.987,4163.88,64.5397,0,0,0,0,0,0,0,0,0,3.80201,0,0),
(17230,13,-605.388,4162.12,64.4036,0,0,0,0,0,0,0,0,0,3.27186,0,0),
(17230,14,-618.198,4162.71,63.1639,0,0,0,0,0,0,0,0,0,2.73779,0,0),
(17230,15,-620.134,4163.85,63.0323,0,0,0,0,0,0,0,0,0,2.11968,0,0),
(17230,16,-621.806,4167.84,62.6762,0,0,0,0,0,0,0,0,0,1.72384,0,0),
(17230,17,-623.2,4175.55,61.4847,0,0,0,0,0,0,0,0,0,1.74602,0,0),
(17230,18,-628.983,4190.44,58.1583,0,0,0,0,0,0,0,0,0,1.95808,0,0),
(17230,19,-623.776,4177.94,60.921,0,0,0,0,0,0,0,0,0,5.28581,0,0),
(17230,20,-613.522,4175.35,62.6926,1000,1723003,0,0,0,0,0,0,0,0.0464096,0,0),
(17230,21,-597.789,4176.94,64.7764,240000,0,0,0,0,0,0,0,0,0.186996,0,0);[/COLOR][/B]

--
[B][COLOR="#0000FF"]DELETE FROM dbscripts_on_creature_movement WHERE id IN (1723001, 1723002, 1723003);[/COLOR][/B]
[B][COLOR="#0000FF"]INSERT INTO dbscripts_on_creature_movement (id, delay, command, datalong, datalong2, buddy_entry, search_radius, data_flags, dataint, dataint2, dataint3, dataint4, x, y, z, o, comments) VALUES
(1723001,0,25,1,0,0,0,0,0,0,0,0,0,0,0,0,'RUN ON'),
(1723002,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,'RUN OFF'),
(1723002,0,31,16793,20,0,0,0,0,0,0,0,0,0,0,0,''),
(1723002,1,0,0,0,16793,20,7,2000000404,2000000405,0,0,0,0,0,0,'force buddy to: say random text'),
(1723003,0,31,17282,20,0,0,0,0,0,0,0,0,0,0,0,''),
(1723003,1,0,0,0,17282,62075,23,2000000406,0,0,0,0,0,0,0,'force buddy to: say random text');[/COLOR][/B]

Hmm, required entries in db_script_string table are already in use! :(
2000000011 2000000012 2000000013

Gonna change the entry numbers to 2000000404, 2000000405, and 2000000406 (next available numbers on Two). This will need to be changed on Two as well.

-- make the cat follow the scripted movement
[B][COLOR="#0000FF"]UPDATE creature_template SET MovementType=2 WHERE Entry=17230;[/COLOR][/B]
[B][COLOR="#0000FF"]UPDATE creature SET MovementType=2 WHERE guid=61963;[/COLOR][/B]

[B][SIZE=3]MaNGOS Two changes[/SIZE][/B]

-- remove original entries 2000000011, 2000000012, and 2000000013(these are in use already on One)
[B][COLOR="#0000FF"]DELETE FROM db_script_string WHERE entry IN (2000000011, 2000000012, 2000000013, 2000000404, 2000000405, 2000000406);[/COLOR][/B]
[B][COLOR="#0000FF"]INSERT INTO db_script_string (entry, content_default, sound, type, language, emote) VALUES
('2000000404', 'Did you find something fun to chase around, Twinkle? I bet you did!', '0', '0', '0', '1');
('2000000405', 'It\'s just you and me, Twinkle. Daddy\'s not going to be coming home.', '0', '0', '0', '1');
('2000000406', 'I wonder how far this would launch that white cat...', '0', '0', '0', '0');[/COLOR][/B]


[B][SIZE=3]ISSUE STILL![/SIZE][/B]

[COLOR="#FF0000"]Hmm, looks like it needs something else. It is complaining about "Requires Discreet Location" when attempting to use the scroll !
There must be something that needs to be done re the use of the scroll: Carinda's Scroll of Retribution[/COLOR]

This has been fixed already.

Setting to Completed.

It looks like this has been fixed, I was able to do the whole thing with no issues :)

Setting to Completed.

Confirmed, all fine re the Fargodeep mine issue.

Imp issue still exists. Passive does not stop the Imp from fighting, plus the Imp does not use the fireball by default. The imp should use the fireball first until it runs out of mana, then go in melee.

[B][COLOR="#B22222"][SIZE=3]I'm going to create a new thread for the Imp and set this one to Completed, especially as it is a server side issue, not database.[/SIZE][/COLOR][/B]

Imp issue now handled in: [url]https://www.getmangos.eu/issue.php?issueid=931[/url]

[B][SIZE=3]**** [COLOR="#008000"]FIXES APPLIED[/COLOR] ****[/SIZE][/B]

[B]MaNGOS Zero[/B]

[url]https://github.com/mangoszero/database/pull/9[/url]

[B]MaNGOS One[/B]

[url]https://github.com/mangosone/database/pull/14[/url]

[B]MaNGOS Two[/B]

[url]https://github.com/mangostwo/database/pull/28[/url]

===========================================================================


[B][COLOR="#800080"]For the WIKI – entry in the npc_text table's page, for randon gossip text.[/COLOR][/B]


[B]Version 1[/B]

Random gossip text
This table allows an NPC to have a choice of what to say when interacted with by a character player, such as for Terl Arakor in the Wetlands. This is done by entering each choice of text into the following fields:

text0_0, text1_0, text2_0, text3_0, text4_0, text5_0, text6_0, text7_0 for a male NPC
or
text0_1, text1_1, text2_1, text3_1, text4_1, text5_1, text6_1, text7_1 for a female NPC

As can be seen, an NPC can have a choice of up to 8 different things to say.

[B]Version 2[/B]

Random gossip text
The fields text0_0 to text7_0 (male NPC) and text0_1 to text7_1 (female NPC), can be used to give the NPC a choice of what to say when interacted with by a player character. An example of use can be found with the NPC, Terl Arakor, in the Wetlands.

[B][SIZE=3][COLOR="#008000"]FIXES:[/COLOR][/SIZE][/B]

[B]MaNGOS Zero[/B]

[B][COLOR="#0000FF"]UPDATE npc_text SET `prob0`='1', `text1_1`='On my way down here from Dun Algaz I saw a gnoll hunting Threshadons in the middle of a lake. If you\'ve never seen a dog try to use a spear, you\'re in for a treat!', `prob1`='1', `text2_1`='I was up at Whelgar\'s a few days ago attempting to...er...liberate...some titan relics from the bones of the dead raptors, and I saw him! Sarltooth lives! Well, he\'s undead, so I guess he doesn\'t live, but he exists. Sarltooth exists!', `prob2`='1', `text3_0`='They say that the raptor matriarch lives deep within Raptor Ridge, protecting her clutch of eggs.', `prob3`='1', `text4_0`='The Dragonmaw are attempting to push out of the Angerfang Encampment and are already raiding the caravan to the east. They\'ve called in two powerful warriors who are leading the charge. If you\'re up for a challenge, you might find them at the Encampment, planning and strategizing and doing other evil Orcish things.', `prob4`='1' WHERE `ID`='16528';[/COLOR][/B]


[B]MaNGOS One and ManGOS Two[/B]

-- Link gossip text to NPC
[B][COLOR="#0000FF"]UPDATE creature_template SET `GossipMenuId`='11788' WHERE `Entry`='2153';[/COLOR][/B]

-- gossip_menu
[B][COLOR="#0000FF"]DELETE FROM gossip_menu WHERE entry = 11788;[/COLOR][/B]
[B][COLOR="#0000FF"]INSERT INTO gossip_menu (`entry`, `text_id`, `script_id`, `condition_id`) VALUES ('11788', '16528', '0', '0');[/COLOR][/B]

-- npc_text
[B][COLOR="#0000FF"]DELETE FROM npc_text WHERE ID = 16528;[/COLOR][/B]
[B][COLOR="#0000FF"]INSERT INTO npc_text (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) VALUES ('16528', 'This is MY WAGON!$B$BMINE!', '', '0', '1', '0', '0', '0', '0', '0', '0', '', 'On my way down here from Dun Algaz I saw a gnoll hunting Threshadons in the middle of a lake. If you\'ve never seen a dog try to use a spear, you\'re in for a treat!', '0', '1', '0', '0', '0', '0', '0', '0', '', 'I was up at Whelgar\'s a few days ago attempting to...er...liberate...some titan relics from the bones of the dead raptors, and I saw him! Sarltooth lives! Well, he\'s undead, so I guess he doesn\'t live, but he exists. Sarltooth exists!', '0', '1', '0', '0', '0', '0', '0', '0', 'They say that the raptor matriarch lives deep within Raptor Ridge, protecting her clutch of eggs.', '', '0', '1', '0', '0', '0', '0', '0', '0', 'The Dragonmaw are attempting to push out of the Angerfang Encampment and are already raiding the caravan to the east. They\'ve called in two powerful warriors who are leading the charge. If you\'re up for a challenge, you might find them at the Encampment, planning and strategizing and doing other evil Orcish things.', '', '0', '1', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');[/COLOR][/B]

Solved it, at least for myself, and MEGA [B][SIZE=5]D'OH[/SIZE][/B]

For a choice of text to be displayed, you use the fields in the npc_text table: text0_0, text1_0, text,2_0, etc

So, I now need to add the 2nd text to the text1_0 of that NPC's npc_text record.

[COLOR="#0000FF"]UPDATE npc_text SET `prob0`='0.5', `text1_1`='On my way down here from Dun Algaz I saw a gnoll hunting Threshadons in the middle of a lake. If you\'ve never seen a dog try to use a spear, you\'re in for a treat!', `prob1`='0.5' WHERE `ID`='16528';[/COLOR]

Now to find out what else the NPC says.

[B]NOTE:[/B] chat text is missing completely from One and Two for this NPC

[B]NOTE 2[/B]: NPC should do the following:

After the "Wetlands is under attack!" message is broadcast, the NPC says
[QUOTE]WHERE IN WETLANDS? Maybe next time you could just warn me "Azeroth is under attack, somewhere!"[/QUOTE]

[url]http://www.wowhead.com/npc=2153/terl-arakor#comments[/url]


Blimey, this guy says tons of things!!!

[QUOTE]I was up at Whelgar's a few days ago attempting to...er...liberate...some titan relics from the bones of the dead raptors, and I saw him! Sarltooth lives! Well, he's undead, so I guess he doesn't live, but he exists. Sarltooth exists![/QUOTE]

[QUOTE]They say that the raptor matriarch lives deep within Raptor Ridge, protecting her clutch of eggs.[/QUOTE]

Okay, not tons of things, just one more... :p

[QUOTE]The Dragonmaw are attempting to push out of the Angerfang Encampment and are already raiding the caravan to the east. They've called in two powerful warriors who are leading the charge. If you're up for a challenge, you might find them at the Encampment, planning and strategizing and doing other evil Orcish things.[/QUOTE]

It looks like someone has added the combat AI for this NPC now as per:

[url]http://www.wowhead.com/npc=7607/weegli-blastfuse[/url]

For Zero, One, and Two

Tried it again, and it does not work.

I added the 2nd text to my system.

Actually, I can't see how it would work. I thought the probability field may have something to do with it, but it seems not.

Probably fixed already then, if you have seen it working on other NPCs. This was posted in November, so quite old.

Thanks for the input :)

"beware of cmangos doku its wrong for our DB sometimes"

noted :)

[B][SIZE=3][COLOR="#008000"]Final fix applied: [/COLOR][/SIZE][/B]

database scripted visiting of the graves
[url]https://github.com/mangosone/database/pull/13[/url]

[B][COLOR="#008000"][SIZE=3]Fix as per MaNGOS Two:[/SIZE][/COLOR][/B]

-- Move NPC to same location as in Two
[COLOR="#0000FF"]UPDATE creature SET `position_x`='-807.327', `position_y`='2739.82', `position_z`='115.447', `orientation`='4.18481' WHERE `guid`='58021';[/COLOR]

-- Change MovementType so that it will take the path set out in the creature_movement_template table
[COLOR="#0000FF"]UPDATE creature_template SET `MovementType`='2' WHERE `Entry`='16856';[/COLOR]
[COLOR="#0000FF"]UPDATE creature SET `MovementType`='2' WHERE `guid`='58021';[/COLOR]

-- Define the path the NPC is to take
[COLOR="#0000FF"]DELETE FROM creature_movement_template WHERE entry = 16856;[/COLOR]
[COLOR="#0000FF"]INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUES
(16856,1,-807.327,2739.82,115.447,60000,0,0,0,0,0,0,0,0,4.18481,0,0),
(16856,2,-798.86,2719.21,111.628,0,0,0,0,0,0,0,0,0,5.48986,0,0),
(16856,3,-785.502,2706.21,107.293,0,0,0,0,0,0,0,0,0,5.46463,0,0),
(16856,4,-785.546,2702.16,106.208,0,0,0,0,0,0,0,0,0,4.17889,0,0),
(16856,5,-787.652,2700.58,105.792,12000,1685601,0,0,0,0,0,0,0,3.3349,0,0),
(16856,6,-791.771,2694.26,104.589,0,0,0,0,0,0,0,0,0,3.84755,0,0),
(16856,7,-793.482,2693.76,104.592,10000,1685602,0,0,0,0,0,0,0,3.13126,0,0),
(16856,8,-794.696,2691.44,104.35,0,0,0,0,0,0,0,0,0,3.7887,0,0),
(16856,9,-797.951,2691.02,104.535,0,0,0,0,0,0,0,0,0,2.95382,0,0),
(16856,10,-798.984,2693.63,104.891,0,0,0,0,0,0,0,0,0,1.64928,0,0),
(16856,11,-797.778,2697.53,105.43,12000,1685603,0,0,0,0,0,0,0,3.13126,0,0),
(16856,12,-792.678,2705.64,106.948,0,0,0,0,0,0,0,0,0,1.6532,0,0),
(16856,13,-792.409,2708.46,107.754,0,0,0,0,0,0,0,0,0,2.0399,0,0),
(16856,14,-794.25,2710.38,108.384,0,0,0,0,0,0,0,0,0,3.14966,0,0),
(16856,15,-799.924,2706.66,107.387,10000,1685602,0,0,0,0,0,0,0,4.01203,0,0),
(16856,16,-807.92,2692.9,104.856,12000,1685604,0,0,0,0,0,0,0,3.58948,0,0),
(16856,17,-811.612,2690.9,104.36,0,0,0,0,0,0,0,0,0,3.33756,0,0),
(16856,18,-814.837,2692.26,104.736,0,0,0,0,0,0,0,0,0,2.3079,0,0),
(16856,19,-814.33,2696.03,105.773,0,0,0,0,0,0,0,0,0,1.17929,0,0),
(16856,20,-809.779,2704.45,107.63,10000,1685602,0,0,0,0,0,0,0,1.13373,0,0),
(16856,21,-801.425,2715.06,109.679,12000,1685605,0,0,0,0,0,0,0,0.966449,0,0),
(16856,22,-801.359,2718.11,110.676,0,0,0,0,0,0,0,0,0,1.97582,0,0),
(16856,23,-804.433,2720.69,111.13,0,0,0,0,0,0,0,0,0,3.4021,0,0),
(16856,24,-810.324,2717.67,110.329,10000,1685602,0,0,0,0,0,0,0,4.00607,0,0),
(16856,25,-814.433,2712.14,109.487,0,0,0,0,0,0,0,0,0,4.15529,0,0),
(16856,26,-820.17,2701.35,107.506,12000,1685606,0,0,0,0,0,0,0,4.41448,0,0),
(16856,27,-823.067,2699.77,107.458,0,0,0,0,0,0,0,0,0,3.02746,0,0),
(16856,28,-824.921,2701.38,107.939,0,0,0,0,0,0,0,0,0,2.213,0,0),
(16856,29,-824.739,2706.05,108.591,0,0,0,0,0,0,0,0,0,1.32158,0,0),
(16856,30,-820.185,2714.8,110.056,12000,1685607,0,0,0,0,0,0,0,1.05768,0,0),
(16856,31,-814.476,2725.61,111.567,0,0,0,0,0,0,0,0,0,1.07653,0,0),
(16856,32,-807.327,2739.82,115.447,0,0,0,0,0,0,0,0,0,1.07653,0,0),
(16856,33,-807.327,2739.82,115.447,300000,0,0,0,0,0,0,0,0,4.18481,0,0);[/COLOR]

-- AI scripts for use during the visit to the grave - saluting, kneeling, etc
[COLOR="#0000FF"]INSERT INTO `dbscripts_on_creature_movement` (`id`, `delay`, `command`, `datalong`, `datalong2`, `buddy_entry`, `search_radius`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES
(1685601,1,3,0,0,0,0,0,0,0,0,0,0,0,0,2.75976,''),
(1685601,3,1,66,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685601,6,1,16,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685601,7,9,21211,180,0,0,0,0,0,0,0,0,0,0,0,'respawn gobject'),
(1685602,1,3,0,0,0,0,0,0,0,0,0,0,0,0,2.76949,''),
(1685602,3,1,69,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685602,7,1,0,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685602,8,1,66,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685603,1,3,0,0,0,0,0,0,0,0,0,0,0,0,2.75976,''),
(1685603,3,1,66,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685603,6,1,16,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685603,7,9,21212,180,0,0,0,0,0,0,0,0,0,0,0,'respawn gobject'),
(1685604,1,3,0,0,0,0,0,0,0,0,0,0,0,0,2.75976,''),
(1685604,3,1,66,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685604,6,1,16,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685604,7,9,21213,180,0,0,0,0,0,0,0,0,0,0,0,'respawn gobject'),
(1685605,1,3,0,0,0,0,0,0,0,0,0,0,0,0,2.75976,''),
(1685605,3,1,66,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685605,6,1,16,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685605,7,9,21214,180,0,0,0,0,0,0,0,0,0,0,0,'respawn gobject'),
(1685606,1,3,0,0,0,0,0,0,0,0,0,0,0,0,2.75976,''),
(1685606,3,1,18,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685606,6,1,16,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685606,7,9,21215,180,0,0,0,0,0,0,0,0,0,0,0,'respawn gobject'),
(1685607,1,3,0,0,0,0,0,0,0,0,0,0,0,0,2.75976,''),
(1685607,3,1,66,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685607,6,1,16,0,0,0,0,0,0,0,0,0,0,0,0,''),
(1685607,7,9,21210,180,0,0,0,0,0,0,0,0,0,0,0,'respawn gobject');[/COLOR]

Tested and working on One. Had to remove 1 column from Two's [B]creature_movement_template[/B] script - [B]wpguid[/B] - this field does not appear in One

SD2 script added:

[B]MaNGOS One[/B]

SD2 script
[url]https://github.com/mangosone/server/pull/8[/url]

[B][COLOR="#FF0000"]Does not include the laying of a wreath. [/COLOR][/B]

Database
[url]https://github.com/mangosone/database/pull/11[/url]

[B]MaNGOS Two[/B]

[B][COLOR="#FF0000"][SIZE=3]FORGET THE ABOVE[/SIZE][/COLOR][/B]

It has already been set up in MaNGOS Two, and working really well! I should've checked, do'h

Will transfer that to MaNGOS One!

[B][SIZE=3][COLOR="#008000"]THE FIX[/COLOR][/SIZE][/B]

-- Quest rewarded 9152
[COLOR="#0000FF"]DELETE FROM conditions WHERE condition_entry = 1734;
INSERT INTO conditions (condition_entry, type, value1) VALUES (1734, 8, 9152);[/COLOR]
-- Stop the option for listing vendor goods
[COLOR="#0000FF"]UPDATE gossip_menu_option SET condition_id=1734 WHERE menu_id=7162 and id=0;[/COLOR]

PR and merged on MaNGOSOne
[url]https://github.com/mangosone/database/pull/10[/url]

Will check MaNGOSTwo tomorrow!

MaNGOSTwo is fine.

[SIZE=3][B]***** [COLOR="#008000"]Job done - Setting to Completed[/COLOR] *****[/B][/SIZE]

Checked in-game and this has not been fixed.

I think it can be sorted out by the use of:
[B]npc_vendor [/B]table
[B]conditions [/B]table + CONDITION_QUESTREWARDED type + the quest entry 9152

----------------------------------------------
-- Quest rewarded 9152
[B][COLOR="#0000FF"]INSERT INTO conditions (condition_entry, type, value1) VALUES (1734, 8, 9152);[/COLOR][/B]

-- Only allow access to trade if quest rewarded
[B][COLOR="#0000FF"]UPDATE npc_vendor SET condition_id = 1734 WHERE entry = 16224;[/COLOR][/B]

That does not appear to be the way to do it :(

[B]gossip_menu_option [/B]perhaps ?

[B][COLOR="#0000FF"]UPDATE gossip_menu_option SET condition_id=1734 WHERE menu_id=7162 and id=0;[/COLOR][/B]

YEY, that did it :)

Will PR this in a mo!

[IMG]http://s29.postimg.org/5p0x12q53/Caretaker_Dilandrus.jpg[/IMG]

[SIZE=3][B]***** [COLOR="#008000"]FIX[/COLOR] *****[/B][/SIZE]
[B][COLOR="#0000FF"]UPDATE npc_text SET text0_0 = 'I was born here, $r. This is my world - all that I know... As a boy, my mother and father would regale me with tales of your world and the splendor it held. How I longed to leave this place.$B$BAlas, fate is a cruel mistress. My mother and father have long since passed, buried in this graveyard. I remain to uphold their honor and the honor of my family - The Sons of Lothar.' WHERE ID = 8676;[/COLOR][/B]

[B][COLOR="#FF0000"]Seems odd that a human addresses and another human as "human" !?!?[/COLOR][/B]

Before submitting the above, I'll check to see if anything needs to be added to the database for the scripted part (going to graves, placing flowers, saluting, etc)

[B]Scripted part:[/B]

MaNGOSOne

[COLOR="#0000FF"]DELETE FROM script_binding WHERE bind = 16856;
INSERT INTO script_binding (type, ScriptName, bind, data) VALUES (0, 'npc_caretaker_dilandrus', 16856, 0);[/COLOR]

Bloodfury Ambushers found in-game :) This no doubt was fixed since the issue was raised.

Check the following coords as per the [B]creature [/B]table:

877.562, 1798.55, -6.31066
901.677, 1781.91, -7.34716
1010.01, 1726.79, -9.77721
1010.01, 1726.79, -9.77721
948.891, 1679.82, -12.1807

oo, better check Two!!!

All good on Two too :D
Although there is one more spawn location there:
[B]creature [/B]table - '31802', '4025', '1', '1', '1', '0', '0', '919.809', '1741.91', '-11.9346', '0.839383', '300', '15', '0', '426', '581', '0', '1'

Gonna add this record to One, as it was obviously deleted. It exists on both Zero and Two.

Missing record added back to One:
[url]https://github.com/mangosone/database/pull/9[/url]

It looks like he should have the following text:

[QUOTE]'I was born here, . This is my world - all that I know... As a boy, my mother and father would regale me with tales of your world and the splendor it held. How I longed to leave this place.

Alas, fate is a cruel mistress. My mother and father have long since passed, buried in this graveyard. I remain to uphold their honor and the honor of my family - The Sons of Lothar.'[/QUOTE]

[url]http://wowwiki.wikia.com/Caretaker_Dilandrus[/url]

And he should also do the following, if not already:

[QUOTE]Every 15 minutes Caretaker Dilandrus walks down to the front of the graveyard, stops at a gravestone and salutes, kneels down and lays a wreath on the ground in front of the gravestone. He visits ten of the twenty-six gravestones. He salutes a few, kneels down at a few and lays flowers down in front of six gravestones. He cries at one gravestone and it’s so sad. But a funny jewel is found at the Decorated Gravestone which reads: “Here lies the remains of a Peon stouthearted. He tried to fight, but only farted.”[/QUOTE]
[url]http://www.wowhead.com/npc=16856/caretaker-dilandrus#comments[/url]

EDIT: The guy is definitely not doing the above, and I can find no script for him.

Fix has already been applied to One by SylvainNeau:
20000_32_Fel_Stalker_issue_fix.sql

Fix has now been applied to Two:
[url]https://github.com/mangostwo/database/pull/27[/url]

I think this has been fixed, although maybe broken on Two... checking now...

Yep, by our man SylvainNeau :)

20000_32_Fel_Stalker_issue_fix.sql

Checking Two now...

Yep, issue is on Two... will create/copy fix and credit SylvainNeau

Fix has already been applied to One:
20000_33_Tortured_skeleton_issue_fix.sql by SylvainNeau

Fix now applied to Two:
[url]https://github.com/mangostwo/database/pull/26[/url]

Ah ha, someone has posted a fix for this.

I'll get the details then post it here.

EDIT: Hmm, I cannot locate who submitted the fix for One:
20000_33_Tortured_skeleton_issue_fix.sql

oo, idea

Fixer was SylvainNeau :)

I'll credit him when I submit the fix for Two.