NPC: Caretaker Dilandrus - UDB Missing Text

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.

[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]

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][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

[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]