I’m short on time. So if someone would like to finish this it would be great.
Note: respawn time in creature table should be 3 hrs.
-- SAI for Lil Timmy
SET @ENTRY := 8666;
SET @GUID := 45501;
UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=-8555.496,`position_y`=614.9783,`position_z`=102.3081,`orientation`=6.230762 WHERE `guid`=@GUID;
DELETE FROM `creature_addon` WHERE `guid`=@GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@GUID,0,1,0, '');
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,53,0,@ENTRY,0,0,0,0,1,0,0,0,0,0,0,0, 'Lil Timmy - On spawn - Start WP movement'),
-- need to spawn entry 7386 as pet at -8557.493 Y: 615.0831 Z: 102.3996 O: 6.230867
(@ENTRY,0,1,0,1,0,100,0,25000,35000,25000,35000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Lil Timmy - OOC - Say Text 0'),
(@ENTRY,0,2,0,64,0,100,0,0,0,0,0,54,12000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Lil Timmy - On Gossip Hello - pause waypoint'), -- Not working
(@ENTRY,0,3,0,40,0,100,0,30,@ENTRY,0,0,41,1000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Lil Timmy - Reach wp 30 - despawn');
-- Waypoints for Lil Timmy from sniff
DELETE FROM `waypoints` WHERE `entry`=@ENTRY;
INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES
(@ENTRY,1,-8543.412,625.4933,100.8733, 'Lil Timmy'),
(@ENTRY,2,-8528.514,636.2614,100.0886, 'Lil Timmy'),
(@ENTRY,3,-8512.747,648.0453,100.2959, 'Lil Timmy'),
(@ENTRY,4,-8512.297,656.0422,100.8963, 'Lil Timmy'),
(@ENTRY,5,-8522.728,670.3621,102.7968, 'Lil Timmy'),
(@ENTRY,6,-8532.767,684.5682,97.84038, 'Lil Timmy'),
(@ENTRY,7,-8540.768,687.0398,97.67824, 'Lil Timmy'),
(@ENTRY,8,-8551.445,680.8598,97.17807, 'Lil Timmy'),
(@ENTRY,9,-8558.964,675.4208,97.01649, 'Lil Timmy'),
(@ENTRY,10,-8563.482,676.4645,97.01649, 'Lil Timmy'),
(@ENTRY,11,-8581.504,698.1172,97.01649, 'Lil Timmy'),
(@ENTRY,12,-8592.527,711.3143,96.62417, 'Lil Timmy'),
(@ENTRY,13,-8602.414,713.5643,96.61008, 'Lil Timmy'),
(@ENTRY,14,-8614.688,710.1391,96.77583, 'Lil Timmy'),
(@ENTRY,15,-8629.039,727.0874,96.69756, 'Lil Timmy'),
(@ENTRY,16,-8653.279,753.1558,96.71466, 'Lil Timmy'),
(@ENTRY,17,-8660.023,762.5481,96.7223, 'Lil Timmy'),
(@ENTRY,18,-8658.965,767.959,96.72258, 'Lil Timmy'),
(@ENTRY,19,-8641.038,781.887,96.6423, 'Lil Timmy'),
(@ENTRY,20,-8636.863,785.3159,96.65224, 'Lil Timmy'),
(@ENTRY,21,-8635.395,798.3671,96.67358, 'Lil Timmy'),
(@ENTRY,22,-8637.041,814.8489,96.64377, 'Lil Timmy'),
(@ENTRY,23,-8646.509,832.7954,96.62849, 'Lil Timmy'),
(@ENTRY,24,-8656.26,844.2271,97.01368, 'Lil Timmy'),
(@ENTRY,25,-8680.317,875.5948,97.01649, 'Lil Timmy'),
(@ENTRY,26,-8680.58,880.0547,97.01649, 'Lil Timmy'),
(@ENTRY,27,-8671.217,887.5997,97.14404, 'Lil Timmy'),
(@ENTRY,28,-8664.06,894.1663,97.53514, 'Lil Timmy'),
(@ENTRY,29,-8649.566,904.5507,98.5368, 'Lil Timmy'),
(@ENTRY,30,-8642.125,908.5306,99.18146, 'Lil Timmy');
-- NPC talk text insert from sniff
DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
(@ENTRY,0,0, 'I can''t believe dad won''t let me keep your sister.',12,7,100,0,0,0, 'Lil Timmy'),
(@ENTRY,0,1, 'Will someone please give my little kitten a good home?',12,7,100,0,0,0, 'Lil Timmy'),
(@ENTRY,0,2, 'Can anyone give my adorable, extra little kitty a home?',12,7,100,0,0,0, 'Lil Timmy'),
(@ENTRY,0,3, 'What does allergic mean anyway? And what does it have to do with either of my kitties?',12,7,100,0,0,0, 'Lil Timmy'),
(@ENTRY,0,4, 'Kitten for sale, looking for a good home.',12,7,100,0,0,0, 'Lil Timmy'),
(@ENTRY,0,5, 'Don''t worry, I''ll find a good home for ya.',12,7,100,0,0,0, 'Lil Timmy');[/sql]