-- Clean up Opus and move him to SAI scripting "Seems he had EAI text scripting & Waypoint text scripting"
-- Remove old text
DELETE FROM `db_script_string` WHERE `entry` BETWEEN 2000005001 AND 2000005008;
-- Remove old waypoint scripts
DELETE FROM `waypoint_scripts` WHERE `id` BETWEEN 5 AND 12;
UPDATE `waypoint_data` SET `action`=0 WHERE `action` BETWEEN 5 AND 12;
-- Remove old waypoints
UPDATE `creature` SET `modelid`=0,`spawndist`=0,`MovementType`=0 WHERE `guid`=4567;
UPDATE `creature_addon` SET `path_id`=0 WHERE `guid`=4567;
DELETE FROM `waypoint_data` WHERE `id`=45670;
-- Remove EAI
DELETE FROM `creature_ai_scripts` WHERE `creature_id`=10262;
-- Remove EAI text
DELETE FROM `creature_ai_texts` WHERE `entry` IN (-582,-583,-584,-585,-586,-587);
-- SAI for Opus
UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`='' WHERE `entry`=10262;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=10262;
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
(10262,0,0,0,1,0,100,0,30000,60000,50000,60000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Opus - OOC - Say Text 0');
-- NPC talk text converted from db_script_string
DELETE FROM `creature_text` WHERE `entry`=10262;
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
(10262,0,0, 'Opus wants SOME Cuergo''s Gold... WITH worm.',12,0,100,0,0,0, 'Opus'),
(10262,0,1, 'Bijou lost! SQUAWK! *cough',12,0,100,0,0,0, 'Opus'),
(10262,0,2, 'Kibler IS being investigated BY G.E.T.A.',12,0,100,0,0,0, 'Opus'),
(10262,0,3, 'Bijou knows WHERE treasures are hidden.',12,0,100,0,0,0, 'Opus'),
(10262,0,4, 'Dragons controlling orcs!? SQUAWK!',12,0,100,0,0,0, 'Opus'),
(10262,0,5, 'They ALL go TO the Spire but NONE never come back... just LIKE Bijou.',12,0,100,0,0,0, 'Opus'),
(10262,0,6, 'Ask Kibler about the treasure! SQUAWK!',12,0,100,0,0,0, 'Opus'),
(10262,0,7, 'SQUAWK!! *cough* *cough* I need TO quit smoking!',12,0,100,0,0,0, 'Opus');
Another Thank you Malcrom.
Just curious… but will all the EAI be converted to SAI eventually?
That’s the idea.
Yes, and all db scripts will be converted to SAI also.