world-eventai.log start up errors (again)

5 more of the bleepers!

It looks like some records may have been deleted from the tables to do with AI; mainly creature_ai_texts.

I'll put together the fixes here.


–- missing/deleted
[COLOR="#0000FF"]DELETE FROM creature_ai_texts WHERE entry in (-1133, -1134, -1136);

INSERT INTO creature_ai_texts (entry, content_default, sound, type, language, emote, comment) VALUES (-1136, 'Anu\dora!', 0, 0, 0, 0, 7999);

INSERT INTO creature_ai_texts (entry, content_default, sound, type, language, emote, comment) VALUES (-1133, 'For Kalimdor!', 0, 0, 0, 0, 7999);

INSERT INTO creature_ai_texts (entry, content_default, sound, type, language, emote, comment) VALUES (-1134, 'Endu\di Rifa!', 0, 0, 0, 0, 7999);[/COLOR]

[COLOR="#0000FF"]UPDATE creature_ai_scripts SET action1_param2 = -1133, action1_param3 = -1134 WHERE id = 799905;[/COLOR]

–- EventAI not required - Guardian of Blizzard - (implemented by ScriptDev)
[COLOR="#0000FF"]UPDATE creature_template SET AIName = '' WHERE Entry = 5764;[/COLOR]

-- water elemental
[COLOR="#0000FF"]DELETE FROM creature_ai_texts WHERE entry = -148;
INSERT INTO creature_ai_texts (entry, content_default, sound, type, language, emote, comment) VALUES (-148, '[Kalimag] Ma reth bromo zoln kilagrin dra ma zoern tu ko fraht ko kadrom Ma krin drinor zoln drinor Ma krin kan aasrugel korsul', 0, 0, 0, 0, 8666);[/COLOR]

-- dwarf dude
-- [url]http://www.wowhead.com/npc=10817/duggan-wildhammer#comments[/url]
[COLOR="#0000FF"]UPDATE creature_ai_texts SET comment = 10817 WHERE entry= -1160;
DELETE FROM creature_ai_scripts WHERE id = 1081710;
INSERT INTO creature_ai_scripts (id, creature_id, event_type, event_inverse_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action1_type, action1_param1, action1_param2, action1_param3, action2_type, action2_param1, action2_param2, action2_param3, action3_type, action3_param1, action3_param2, action3_param3, comment) VALUES (1081710, 10817, 4, 0, 100, 0, 0, 0, 0, 0, 1, -1160, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Duggan Wildhammer - Say on Aggro');[/COLOR]

[COLOR="#0000FF"]DELETE FROM creature_ai_scripts WHERE id = 1081711;
INSERT INTO creature_ai_scripts (id, creature_id, event_type, event_inverse_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action1_type, action1_param1, action1_param2, action1_param3, action2_type, action2_param1, action2_param2, action2_param3, action3_type, action3_param1, action3_param2, action3_param3, comment) VALUES ('1081711', '10817', '1', '0', '100', '1', '120000', '120000', '120000', '120000', '1', '-1161', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Duggan Wildhammer - Random Say OOC');[/COLOR]

[COLOR="#0000FF"]DELETE FROM creature_ai_texts WHERE entry = -1161 AND comment = 10817;
INSERT INTO creature_ai_texts (entry, content_default, sound, type, language, emote, comment) VALUES ('-1161', 'Ooooooooh... $B To the plaguelands went old Duggan, ta\' send them Scourge back inta\' th\' groun\'. $B Where th\' scent of death is on th\' wind and everythin\' is mostly brown. $B An\' when he did arrive there, what\'d his dwarf eyes see? $B A hundred crates of barley there ta\' be makin\' inta\' mead! $B But tha\' mead was cursed with th\' plague o\' death, and now old Duggan, too. $B An\' surrounded by the Lich King\'s beasts, what could old Duggan do? $B But though I feel the plague within, my hopes \'ave not yet sunk. $B If\'n I\'m gonna be Scourge anyway, I might as well be drunk!', '0', '0', '0', '0', '10817');[/COLOR]

-- Tortured Druid
-- [url]http://www.wowwiki.com/Tortured_Druid[/url]
[COLOR="#0000FF"]DELETE FROM creature_ai_scripts WHERE id = 1217804;
INSERT INTO creature_ai_scripts (id, creature_id, event_type, event_inverse_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action1_type, action1_param1, action1_param2, action1_param3, action2_type, action2_param1, action2_param2, action2_param3, action3_type, action3_param1, action3_param2, action3_param3, comment) VALUES ('1217804', '12178', '6', '0', '75', '2', '0', '0', '0', '0', '1', '-1147', '0', '0', '12', '13136', '1', '300000', '0', '0', '0', '0', 'Tortured Druid - Shout and summon drone');[/COLOR]

-------------------------------------------------- 2nd lot of errors (Live World mode)

-- Misha - movement type 14 - follow - MoveMaster.h, line 56
[COLOR="#0000FF"]UPDATE creature SET MovementType= 14 WHERE guid = 590005;

UPDATE creature SET MovementType = 14 WHERE guid = 14516;

UPDATE creature SET MovementType = 14 WHERE guid = 14515;

UPDATE creature SET MovementType = 14 WHERE guid = 14517;

UPDATE creature SET MovementType = 0 WHERE guid = 11453;

UPDATE creature SET MovementType = 0 WHERE guid = 79750;[/COLOR]

-- Donna chasing William (SW)
[COLOR="#0000FF"]UPDATE creature SET position_x = -8741.086, position_y = 551.811, position_z = 99.461, MovementType = 14 WHERE guid = 79721;[/COLOR]