Heyo-
So I’m working on a full fix for the Zul’Drak Region, I’m doing a full cleanup and re-script of some quests, converting existing EAI to SAI, doing the new SAI, etc.
EDIT: Well, everything’s works now, but those damn guards that don’t do anything but move to the position.
I tried triggering with SMART_EVENT_MOVEMENTINFORM but didn’t work it out very well. I’ll move on for now, lots to do. After I complete other stuff I’ll look back and finish this.
UPDATE creature_template
SET AIName
=‘SmartAI’ WHERE entry
=28043;
DELETE FROM smart_scripts
WHERE (entryorguid
=28043 AND source_type
=0);
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
(28043, 0, 0, 1, 20, 0, 100, 0, 12599, 0, 0, 0, 1, 0, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Captain Grondel - Quest Completion - Talk’),
(28043, 0, 1, 0, 52, 0, 100, 0, 0, 28043, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 111301, 28324, 0, 0, 0, 0, 0, ‘Captain Grondel - Text Over - Set Data’);
DELETE FROM creature_text
WHERE entry
=28043;
INSERT INTO creature_text
(entry
, groupid
, id
, text
, type
, language
, probability
, emote
, duration
, sound
, comment
) VALUES
(28043,0,0, “Crusader! Take this wood and light a fire for the troops.”, 12,0,100,0,0,0, “Captain Grondel”);
– Crusader Whazzaaaaah SAI
UPDATE creature_template
SET AIName
=‘SmartAI’ WHERE entry
=28324;
DELETE FROM smart_scripts
WHERE source_type
=0 AND entryorguid
=28324;
DELETE FROM smart_scripts
WHERE source_type
=9 AND entryorguid
=2832400;
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
(28324, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 1, 0, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Crusader Whathah - Data Set - Talk’),
(28324, 0, 1, 0, 52, 0, 100, 0, 0, 28324, 0, 0, 53, 0, 28324, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Crusader Whathah - Text Over - Start WP’),
(28324, 0, 2, 0, 40, 0, 100, 0, 3, 28324, 0, 0, 80, 2832400, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Crusader Whathah - Reached WP 3 - Load Script’),
(28324, 0, 3, 0, 40, 0, 100, 0, 3, 28324, 0, 0, 50, 196417, 40, 0, 0, 0, 0, 8, 0, 0, 0, 5574.01, -2972.21, 276.583, 0, ‘Crusader Whathah - Reached WP 3 - Summon Bonfire’),
(28324, 0, 4, 0, 40, 0, 100, 0, 3, 28324, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 115930, 28117, 0, 0, 0, 0, 0, ‘Crusader Whathah - Reached WP 3 - Set Data’),
(28324, 0, 5, 0, 40, 0, 100, 0, 3, 28324, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 115928, 28117, 0, 0, 0, 0, 0, ‘Crusader Whathah - Reached WP 3 - Set Data’),
(28324, 0, 6, 0, 40, 0, 100, 0, 3, 28324, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 115929, 28117, 0, 0, 0, 0, 0, ‘Crusader Whathah - Reached WP 3 - Set Data’),
(28324, 0, 7, 8, 40, 0, 100, 0, 3, 28324, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 115931, 28117, 0, 0, 0, 0, 0, ‘Crusader Whathah - Reached WP 3 - Set Data’),
(28324, 0, 9, 0, 40, 0, 100, 0, 5, 28324, 0, 0, 78, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Crusader Whathah - Reached WP 5 - Reset Script’),
(28324, 0, 10, 0, 40, 0, 100, 0, 5, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 2.391100, ‘Crusader Whathah - Reached WP 5 - Turn to’),
– Script 1
(2832400,9,0,0,0,0,100,0,0,0,0,0,54,5000,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,“Crusader Whathah - Pause at WP 3”),
(2832400,9,1,0,0,0,100,0,0,0,0,0,17,69,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,‘Crusader Whathah - Emote STATE_USESTANDING’),
(2832400,9,2,0,0,0,100,0,3000,3000,0,0,17,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,‘Crusader Whathah - Emote STATE_NONE’);
– Waypoints for Crusader Whathah
DELETE FROM waypoints
WHERE entry
=28324;
INSERT INTO waypoints
(entry
,pointid
,position_x
,position_y
,position_z
,point_comment
) VALUES
(28324,1,5542.890,-3012.409,278.391,‘Crusader Whathah WP 1’),
(28324,2,5538.055,-3008.528,278.391,‘Crusader Whathah WP 2’),
(28324,3,5571.576,-2973.857,276.583,‘Crusader Whathah WP 3’),
(28324,4,5538.055,-3008.528,278.391,‘Crusader Whathah WP 4’),
(28324,5,5542.890,-3012.409,278.391,‘Crusader Whathah WP 5’);
– Text for Crusader Whathah
DELETE FROM creature_text
WHERE entry
=28324;
INSERT INTO creature_text
(entry
, groupid
, id
, text
, type
, language
, probability
, emote
, duration
, sound
, comment
) VALUES
(28324,0,0, “Sir, yes sir!”, 12,0,100,0,0,0, “Crusader Whathah”);
– Argent Footman SAI
UPDATE creature_template
SET AIName
=‘SmartAI’ WHERE entry
=28117;
– Spawn by spawn
/*
DELETE FROM smart_scripts
WHERE entryorguid
=-115928;
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
(-115928, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, 5571.085, -2975.938, 276.583, 0, ‘Argent Footman - On Data Set - Move to Position’),
(-115928, 0, 1, 0, 34, 0, 100, 0, 1, 0, 0, 0, 80, 2811700, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Argent Footman - Reached Position - Load Script’),
(-115928, 0, 2, 0, 34, 0, 100, 0, 1, 0, 0, 0, 17, 13, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Argent Footman - Reached Position - Emote STATE_SIT’);
DELETE FROM smart_scripts
WHERE entryorguid
=-115929;
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
(-115929, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, 5568.842, -2972.543, 276.583, 0, ‘Argent Footman - On Data Set - Move to Position’),
(-115929, 0, 1, 0, 34, 0, 100, 0, 1, 0, 0, 0, 80, 2811700, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Argent Footman - Reached Position - Load Script’),
(-115929, 0, 2, 0, 34, 0, 100, 0, 1, 0, 0, 0, 17, 13, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Argent Footman - Reached Position - Emote STATE_SIT’);
DELETE FROM smart_scripts
WHERE entryorguid
=-115930;
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
(-115930, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, 5574.604, -2977.184, 276.583, 0, ‘Argent Footman - On Data Set - Move to Position’),
(-115930, 0, 1, 0, 34, 0, 100, 0, 1, 0, 0, 0, 80, 2811700, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Argent Footman - Reached Position - Load Script’),
(-115930, 0, 2, 0, 34, 0, 100, 0, 1, 0, 0, 0, 17, 13, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Argent Footman - Reached Position - Emote STATE_SIT’);
DELETE FROM smart_scripts
WHERE entryorguid
=-115931;
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
(-115931, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, 5571.928, -2968.551, 276.583, 0, ‘Argent Footman - On Data Set - Move to Position’),
(-115931, 0, 1, 0, 34, 0, 100, 0, 1, 0, 0, 0, 80, 2811700, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Argent Footman - Reached Position - Load Script’),
(-115931, 0, 2, 0, 34, 0, 100, 0, 1, 0, 0, 0, 17, 13, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Argent Footman - Reached Position - Emote STATE_SIT’);
– Script 1
DELETE FROM smart_scripts
WHERE (entryorguid
=2811700 AND source_type
=9);
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
(2811700, 9, 0, 0, 0, 0, 100, 0, 40000, 40000, 0, 0, 78, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ‘Argent Footman - Script - Reset Script’);
*/[/SQL]
-- Captain Grondel SAI
Also, if anyone could help me out with some data (Waypoints, mostly would be great) from sniffs or w/e, I’d love him/her /emoticons/default_smile.png