46749 Stonard Wardrummer duped auras added mount SAI

[eyerobot]

I know theres a million of these posted, But i'm fixing them as they appear on my console.

-- 46749 Stonard Wardrummer

update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 46749);

UPDATE `creature_template_addon` SET `auras`=NULL WHERE  `entry`=46749;

UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 46749;
DELETE FROM `smart_scripts` WHERE (`entryorguid`=46749 AND `source_type`=0);
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 
(46749, 0, 0, 0, 0, 0, 100, 0, 5000, 8000, 27000, 32000, 11, 81219, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Cast Battle Shout"),
(46749, 0, 1, 0, 25, 0, 100, 0, 0, 0, 0, 0, 11, 46598, 2, 0, 0, 0, 0, 19, 46748, 50, 0, 0, 0, 0, 0, "Cast Ride On Kodo");

-- 46748 Stonard Kodo Beast

UPDATE `creature_template` SET `VehicleId` = 1218 WHERE `entry` = 46748;

 

[ExO]

Applied to the VIP version that is available by donating here:
https://www.emucoach.com/payments.php