FALL1N1

DELETE FROM `spell_bonus_data` WHERE `entry` IN(13907, 64442, 44578, 44525, 28005, 46579, 20004, 20007, 20006, 13897, 64569, 6297, 7712, 7714, 10577, 16614, 17484, 18798, 21992, 27655, 28788, 38395, 55756, 40972, 60526, 67760, 67714, 28715, 43731, 43733, 38616);
INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES 
(7714, 0, 0, -1, -1, 'Fiery Plate Gauntlets'),
(21992, 0, 0, -1, -1, 'Thunderfury legendary weapon lightning'),
(28715, 0, 0, -1, -1, 'Flamecap (Flamecap op damage)'),
(43731, 0, 0, -1, -1, 'Stormchops (Lightning fix)'),
(43733, 0, 0, -1, -1, 'Stormchops 2 (Lightning fix)'),
(38616, 0, 0, -1, -1, 'Bloodboil Poison'),
(7712, 0, 0, -1, -1, 'Blazefury Medallion & Fiery Retributor'),
(10577, 0, 0, -1, -1, 'Gauntlets of the Sea'),

FALL1N1

/*
QUERY


INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeade

FALL1N1

/*
QUERY


INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeade

FALL1N1

INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(700021, 0, 729, 0, 0, 0),
(700021, 0, 769, 0, 0, 0),
(700021, 0, 1015, 0, 0, 0),
(700021, 0, 2672, 0, 0, 0),
(700021, 0, 2673, 0, 0, 0),
(700021, 0, 2674, 0, 0, 0),
(700021, 0, 2677, 0, 0, 0),
(700021, 0, 2886, 0, 0, 0),
(700021, 0, 2924, 0, 0, 0),

FALL1N1

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=25814;

DELETE FROM `creature_text` WHERE `entry`=25814;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
(25814,1,1, 'We are Mechagnome...resistance is futile.',12,0,0,0,0,0, ''),
(25814,1,2, 'The flesh is weak. We will make you better, stronger...faster.',12,0,0,0,0,0, ''),
(25814,1,3, 'We can decurse you, we have the technology.',12,0,0,0,0,0, '');

DELETE FROM `smart_scripts` WHERE `entryorguid`=25814 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`, 

FALL1N1

-- Fix [Q]{A/H} Conjurer Luminrath ID: 10306
SET @Luminrath := 19580; -- The required npc to be summoned to thank the player, give credit and despawn /without cape/
SET @Capeless := 19544; -- The combat version
-- SET @Mantle := 34142; -- The required spell that triggers the event below to summon the npc to give credit, just for info
SET @Credit := 19548;
SET @Event := 12609;
-- Remove the required spell since it is supposed to send a event and cannot be casted on target, this is the reason it bugged all everything /core issue/, I remove it and in order to obtain the credit this spell needs to be cast anyway, so it is a proper* hack fix, if you think about it.
UPDATE `quest_template` SET `RequiredSpellCast1`=0 WHERE `Id`=10306;
-- Makes the specific spell that already have the call event defined summon Luminrath
DELETE FROM `event_scripts` WHERE `id`=@Event;

FALL1N1

SET @Luminrath := 19580;
SET @Capeless := 19544;
SET @Credit := 19548;
SET @Event := 12609;
UPDATE `quest_template` SET `RequiredSpellCast1`=0 WHERE `Id`=10306;
DELETE FROM `event_scripts` WHERE `id`=@Event;
INSERT INTO `event_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`x`,`y`,`z`,`o`) VALUES
(@Event,0,10,@Luminrath,25000,2192.744873,2340.836182,90.353905,4.682819);
UPDATE `creature_template` SET `maxlevel`=68,`minlevel`=68,`unit_class`=2,`AIName`= 'SmartAI' WHERE `entry`= @Luminrath;
DELETE FROM `creature_ai_scripts` WHERE creature_id = @Luminrath;

FALL1N1

SET @ENTRY := 29327;
SET @QUEST := 13549;
SET @GOSSIP := 54000;
SET @SPELL_RAKE := 54668;
SET @SPELL_BLOWGUN := 62105;
SET @SPELL_SLEEP := 42386; 
UPDATE `creature_template` SET `AIName`='SmartAI',`npcflag`=0,`gossip_menu_id`=@GOSSIP,`faction_A`=1990,`faction_H`=1990,`unit_flags`=0 WHERE `entry`=@ENTRY;
DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRY,@ENTRY*100,@ENTRY*100+1,@ENTRY*100+2);
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

FALL1N1

-- east central sai (broken one, fixed)
SET @ENTRY := 21237;
SET @SPELL_IGNITE_SIEGE := 32979;
SET @SPELL_HELLFIRE_FIRE := 34386;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
DELETE FROM `creature` WHERE `id`=@ENTRY;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES 
(210919, @ENTRY, 530, 1, 1, 11686, 0, -156.464, 2663.68, 63.7235, 3.28655, 300, 0, 0, 42, 0, 0, 0, 0, 0),
(74455, @ENTRY, 530, 1, 1, 0, 0, -160.337, 2663.65, 62.2968, 3.57792, 300, 0, 0, 42, 0, 0, 0, 0, 0);
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY;

FALL1N1

-- east central sai (broken one, fixed)
SET @ENTRY := 21237;
SET @SPELL_IGNITE_SIEGE := 32979;
SET @SPELL_HELLFIRE_FIRE := 34386;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
DELETE FROM `creature` WHERE `id`=@ENTRY;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES 
(210919, @ENTRY, 530, 1, 1, 11686, 0, -156.464, 2663.68, 63.7235, 3.28655, 300, 0, 0, 42, 0, 0, 0, 0, 0),
(74455, @ENTRY, 530, 1, 1, 0, 0, -160.337, 2663.65, 62.2968, 3.57792, 300, 0, 0, 42, 0, 0, 0, 0, 0);
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY;