Brother Sarno

-- TEMPLATE UPDATE
UPDATE creature_template SET `modelid3` = "0", `minhealth` = "3398", `maxhealth` = "3398", `armor` = "3221", `mindmg` = "66", `maxdmg` = "99", `attackpower` = "25", `baseattacktime` = "1500", `rangeattacktime` = "1500", `minrangedmg` = "53", `maxrangedmg` = "79", `rangedattackpower` = "20", `mingold` = "0", `maxgold` = "0", `AIName` = "EventAI", `flags_extra` = "2" WHERE entry=7917;


-- TEXT
DELETE FROM `creature_ai_texts` WHERE `entry`='-835';
INSERT INTO `creature_ai_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`)
VALUES
('-835', 'Greetings, $C! Welcome to the Cathedral of Light!', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '');


-- AI PART -> WILL TURN TO TARGET, SAY, WAVE
DELETE FROM `creature_ai_scripts` WHERE `creature_id` = '7917';
INSERT INTO `creature_ai_scripts` (`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
('7917', '10', '0', '100', '1', '1', '20', '60000', '60000', '44', '6', '5000', '0', '1', '-835', '0', '0', '5', '3', '0', '0', 'Brother Sarno - Greetings');