Open ghost opened 12 years ago
After doing this, we'll probably also want to include a query to remove creature_ai_scripts entries pointing to these no-longer-existing gossips.
DELETE FROM creature_ai_scripts WHERE event_type=1 AND action1_type=1 AND action1_param1 NOT IN (SELECT entry FROM creature_ai_texts)
This is to mostly remove all the console errors about the ai_texts not existing when the scripts try to run. However, this also brings up other console errors about NPCs not having script entries. I'd suggest we then run:
ALTER TABLE `creature_ai_scripts` ADD INDEX ( `creature_id` )
UPDATE `creature_template` SET AIName='' WHERE AIName = 'EventAI' AND entry NOT IN (SELECT creature_id FROM creature_ai_scripts)
ALTER TABLE `creature_ai_scripts` DROP INDEX `creature_id`
agreed.
Paste bin for prettiernesseress.
Will add this to the next DB update coming soon.
: D
Redundancies are in place to prevent potential undesired loss of data.
Signed-off-by: sycantha bryan.mayer26@yahoo.com