[Complete] Clean Up Opus And Move Him To Sai Scripting

-- 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.