What's new

14423 Dozercism Database Fixes, Needs Spell Fix

eyerobot

Gold Supporter
Superior Member
916
2015
24
Location
Barryton Michigan USA
-- 68007 Airdrop a Priest is the spell the flaregun uses, It needs fixed.
-- The rest of this will most likely fix the remaining parts of the quest.

Code:
-- 14423 Dozercism

-- 49350 Blessed Flaregun
-- 68007 Airdrop a Priest
-- 36552 Airborne Goblin Priest
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 36552;

DELETE FROM `smart_scripts` WHERE (`entryorguid`=36552 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 
(36552, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 1, 0, 3000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Just Summoned - Say 0"),
(36552, 0, 1, 0, 52, 0, 100, 0, 0, 36552, 0, 0, 1, 1, 3000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Text Over - Say 1"),
(36552, 0, 2, 3, 52, 0, 100, 0, 1, 36552, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 35526, 100, 0, 0, 0, 0, 0, "On Text Over - Set Data 1 1 -  On Dozer"),
(36552, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 1, 2, 3000, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, "On Text Over - Say 2"),
(36552, 0, 4, 5, 52, 0, 100, 0, 2, 36552, 0, 0, 11, 46598, 2, 0, 0, 0, 0, 19, 35526, 100, 0, 0, 0, 0, 0, "On Text 2 Over Cast Ride"),
(36552, 0, 5, 0, 61, 0, 100, 0, 2, 36552, 0, 0, 1, 3, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Text 2 Over Say 3"),
(36552, 0, 6, 0, 52, 0, 100, 0, 3, 36552, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Text 3 Over - Say 4"),
(36552, 0, 7, 0, 5, 0, 100, 0, 0, 0, 0, 35526, 1, 5, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Dozer Death - Say 5");

DELETE FROM `creature_text` WHERE `entry`=36552 AND `groupid`=0 AND `id`=0;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (36552, 0, 0, 'Praise to the light brother $N, Let\'s take a look here.', 12, 0, 100, 0, 0, 0, 0, '');
DELETE FROM `creature_text` WHERE `entry`=36552 AND `groupid`=1 AND `id`=0;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (36552, 1, 0, 'Well theres your problem, You have what we call a ghost in the machine.', 12, 0, 100, 0, 0, 0, 0, '');
DELETE FROM `creature_text` WHERE `entry`=36552 AND `groupid`=2 AND `id`=0;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (36552, 2, 0, 'This calls for an old fashioned bulldozer exorcism, Give me a hand if she gets uppity will ya?', 12, 0, 100, 0, 0, 0, 0, '');
DELETE FROM `creature_text` WHERE `entry`=36552 AND `groupid`=3 AND `id`=0;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (36552, 3, 0, 'Whoa! We got a live one here.', 12, 0, 100, 0, 0, 0, 0, '');
DELETE FROM `creature_text` WHERE `entry`=36552 AND `groupid`=4 AND `id`=0;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (36552, 4, 0, 'I cast you out unclean spirit - Begone!', 12, 0, 100, 0, 0, 0, 0, '');
DELETE FROM `creature_text` WHERE `entry`=36552 AND `groupid`=5 AND `id`=0;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (36552, 5, 0, 'Terrific!  That went down nice and clean.', 12, 0, 100, 0, 0, 0, 0, '');


-- 35526 Clubnik's Dozer
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 35526;

DELETE FROM `smart_scripts` WHERE (`entryorguid`=35526 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 
(35526, 0, 0, 0, 27, 0, 100, 0, 0, 0, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Passenger Boarded - Set Run"),
(35526, 0, 1, 2, 38, 0, 100, 0, 1, 1, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Data Set 1 1 - Set Faction 14"),
(35526, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 20, 1, 0, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, "On Data Set 1 1 - Attack Closest Player"),
(35526, 0, 3, 4, 6, 0, 100, 0, 0, 0, 0, 0, 2, 1933, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "OnDeath - Set Faction 1933"),
(35526, 0, 4, 5, 61, 0, 100, 0, 0, 0, 0, 0, 59, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "OnDeath - Set Walk"),
(35526, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "OnDeath - Set Data 0 0");
 

ExO

Admin
5,119
2014
1,639
Thanks! It has now been executed, and will be taken effect on the newest Emucoach Cataclysm 4.3.4 Repack (VIP) version;
 
Top