[Complete] Sai & Pathing For Curator Thorius

I know no one cares but this guy is now blizzlike /emoticons/default_smile.png

-- SAI & Pathing for Curator Thorius Entry: 8256 SET @NPC := 8256; SET @GUID := 1887; -- Update creature data UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=-4654.313,`position_y`=-1281.536,`position_z`=503.3816 WHERE `guid`=@GUID; UPDATE `creature_addon` SET `path_id`=0 WHERE `guid`=@GUID; -- SAI for Curator Thorius UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`='' WHERE `entry`=@NPC; DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@NPC; DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid` IN (@NPC*100,@NPC*100+1,@NPC*100+2); 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 -- AI (@NPC,0,0,0,25,0,100,0,0,0,0,0,53,0,@NPC,1,0,0,0,1,0,0,0,0,0,0,0, 'Curator Thorius - on reset - load path'), (@NPC,0,1,2,40,0,100,0,10,@NPC,0,0,54,6000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Curator Thorius - Reach wp 10 - pause wp'), (@NPC,0,2,0,61,0,100,0,0,0,0,0,80,@NPC*100,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Curator Thorius - Reach wp 10 - run script'), (@NPC,0,3,4,40,0,100,0,15,@NPC,0,0,54,6000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Curator Thorius - Reach wp 15 - pause wp'), (@NPC,0,4,0,61,0,100,0,0,0,0,0,80,@NPC*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Curator Thorius - Reach wp 15 - run script'), (@NPC,0,5,6,40,0,100,0,20,@NPC,0,0,54,6000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Curator Thorius - Reach wp 20 - pause wp'), (@NPC,0,6,0,61,0,100,0,0,0,0,0,80,@NPC*100+2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Curator Thorius - Reach wp 20 - run script'), (@NPC,0,7,8,40,0,100,0,36,@NPC,0,0,54,3000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Curator Thorius - Reach wp 36 - pause wp'), (@NPC,0,8,0,61,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,3.577925, 'Curator Thorius - Reach wp 36 - turn to'), -- Scripts (@NPC*100,9,0,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.066617, 'Curator Thorius - script - turn to'), (@NPC*100,9,1,0,0,0,100,0,2000,2000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Curator Thorius - script - say text 0'), (@NPC*100+1,9,0,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0.3316126, 'Curator Thorius - script - turn to'), (@NPC*100+1,9,1,0,0,0,100,0,2000,2000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Curator Thorius - script - say text 1'), (@NPC*100+2,9,0,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,5.742133, 'Curator Thorius - script - turn to'), (@NPC*100+2,9,1,0,0,0,100,0,2000,2000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Curator Thorius - script - say text 2'); -- Remove old waypoints DELETE FROM `waypoint_data` WHERE `id`=18870; -- Remove old waypoint scripts DELETE FROM `waypoint_scripts` WHERE `id`=2; UPDATE `waypoint_data` SET `action`=0 WHERE `action`=2; -- Remove old text DELETE FROM `db_script_string` WHERE `entry`=2000005000; -- NPC talk text insert from sniff DELETE FROM `creature_text` WHERE `entry`=8256; INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES (8256,0,0, '%s dusts the base of the artifact.',16,0,100,16,0,0, 'Curator Thorius'), (8256,1,0, '%s meticulously examines the large vase.',16,0,100,69,2000,0, 'Curator Thorius'), (8256,2,0, 'Poor Dorius. If I ever get my hands on those Dark Irons, so help me...',12,0,100,0,0,0, 'Curator Thorius'); -- SAI waypoints from sniff DELETE FROM `waypoints` WHERE `entry`=@NPC; INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES (@NPC,1,-4649.496,-1276.173,503.3816,'Curator Thorius Path'), (@NPC,2,-4646.738,-1273.377,503.3816,'Curator Thorius Path'), (@NPC,3,-4643.056,-1269.847,503.3816,'Curator Thorius Path'), (@NPC,4,-4638.852,-1265.486,503.3816,'Curator Thorius Path'), (@NPC,5,-4633.741,-1261.104,503.3816,'Curator Thorius Path'), (@NPC,6,-4629.312,-1256.385,503.3816,'Curator Thorius Path'), (@NPC,7,-4626.09,-1255.278,503.3816,'Curator Thorius Path'), (@NPC,8,-4623.375,-1256.474,503.3816,'Curator Thorius Path'), (@NPC,9,-4622.471,-1258.746,503.3816,'Curator Thorius Path'), (@NPC,10,-4622.471,-1258.746,503.3816,'Curator Thorius Path'), (@NPC,11,-4618.021,-1258.523,503.3789,'Curator Thorius Path'), (@NPC,12,-4615.686,-1255.442,503.3816,'Curator Thorius Path'), (@NPC,13,-4608.177,-1249.271,503.3816,'Curator Thorius Path'), (@NPC,14,-4603.862,-1251.563,503.3816,'Curator Thorius Path'), (@NPC,15,-4603.862,-1251.563,503.3816,'Curator Thorius Path'), (@NPC,16,-4602.771,-1247.457,503.3816,'Curator Thorius Path'), (@NPC,17,-4598.436,-1240.892,503.3816,'Curator Thorius Path'), (@NPC,18,-4592.519,-1232.318,503.3816,'Curator Thorius Path'), (@NPC,19,-4588.735,-1222.179,503.3816,'Curator Thorius Path'), (@NPC,20,-4588.735,-1222.179,503.3816,'Curator Thorius Path'), (@NPC,21,-4589.21,-1215.229,503.3816,'Curator Thorius Path'), (@NPC,22,-4593.643,-1214.159,503.3816,'Curator Thorius Path'), (@NPC,23,-4598.711,-1219.354,503.3816,'Curator Thorius Path'), (@NPC,24,-4604.79,-1227.24,503.3816,'Curator Thorius Path'), (@NPC,25,-4610.729,-1236.657,503.3816,'Curator Thorius Path'), (@NPC,26,-4613.151,-1251.97,503.3816,'Curator Thorius Path'), (@NPC,27,-4618.215,-1264.094,503.3798,'Curator Thorius Path'), (@NPC,28,-4633.393,-1276.797,503.3816,'Curator Thorius Path'), (@NPC,29,-4652.419,-1285.877,503.3816,'Curator Thorius Path'), (@NPC,30,-4667.36,-1293.998,503.3816,'Curator Thorius Path'), (@NPC,31,-4678.205,-1296.404,503.3816,'Curator Thorius Path'), (@NPC,32,-4689.225,-1301.691,503.3816,'Curator Thorius Path'), (@NPC,33,-4699.487,-1307.61,503.3816,'Curator Thorius Path'), (@NPC,34,-4709.615,-1317.365,503.3816,'Curator Thorius Path'), (@NPC,35,-4711.283,-1322.386,503.3816,'Curator Thorius Path'), (@NPC,36,-4711.283,-1322.386,503.3816,'Curator Thorius Path'), (@NPC,37,-4708.532,-1326.242,503.3816,'Curator Thorius Path'), (@NPC,38,-4702.81,-1325.271,503.3816,'Curator Thorius Path'), (@NPC,39,-4696.292,-1325.814,503.3816,'Curator Thorius Path'), (@NPC,40,-4689.635,-1325.204,503.3816,'Curator Thorius Path'), (@NPC,41,-4686.068,-1319.191,503.3816,'Curator Thorius Path'), (@NPC,42,-4683.053,-1314.015,503.3816,'Curator Thorius Path'), (@NPC,43,-4675,-1312.604,503.3826,'Curator Thorius Path'), (@NPC,44,-4664.885,-1306.134,503.3816,'Curator Thorius Path'), (@NPC,45,-4662.037,-1298.117,503.3816,'Curator Thorius Path'), (@NPC,46,-4659.361,-1288.6,503.3816,'Curator Thorius Path'), (@NPC,47,-4654.313,-1281.536,503.3816,'Curator Thorius Path');[/sql]

Mistake on

UPDATE `creature_addon` SET `path_id`=0;

It’s really funny to see how every single fix you write gets at least 2-3 ‘likes’. /emoticons/default_happy.png

An old quote :

« Malcrom, Malcrom … He’s the man ! If he can’t, nobody can ! »

No mistake there.

UPDATE `creature_addon` SET `path_id`=0 WHERE `guid`=@GUID;[/CODE]

small bug

And in “UPDATE waypoint_data SET action=0 WHERE action=2;” too, there are two records with that use that action.

The one you deleted and npc guid 97931 (waypoint id 979310, creature entry 28691?)

That’s because I can’t dislike!

Seems to be incorrect scripts added to that npc. I had to remove them.

Yeah, doesn’t make much sense.