Quest Fish Fer Squirky fix 7.02

[eyerobot]

On spell hit condition

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=99431 AND `SourceId`=0 AND `ElseGroup`=1 AND `ConditionTypeOrReference`=31 AND `ConditionTarget`=0 AND `ConditionValue1`=3 AND `ConditionValue2`=53543 AND `ConditionValue3`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (13, 1, 99431, 0, 1, 31, 0, 3, 53543, 0, 0, 0, 0, '', NULL);

Smart Scripts

DELETE FROM `smart_scripts` WHERE `entryorguid`=53543 AND `source_type`=0 AND `id`=0 AND `link`=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 (53543, 0, 0, 0, 8, 0, 100, 0, 99431, 0, 0, 0, 33, 53543, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'OnSpellHit, Credit');

Creature Templates
Squirky

DELETE FROM `creature_template` WHERE `entry`=53544;
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`, `exp_unk`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_fly`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `type_flags2`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `currencyId`, `currencyCount`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Mana_mod_extra`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (53544, 0, 0, 0, 0, 0, 0, 15395, 0, 0, 'Squirky', '', '', 0, 1, 1, 0, 0, 7, 7, 0, 1, 1.42857, 1, 1.42857, 1, 0, 0, 0, 0, 0, 1, 2000, 2000, 1, 256, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 'SmartAI', 0, 3, 0, 0, 1, 1, 1, 0, 4161536, 0, 0, 0, 0, 0, 0, 1, 53544, 0, 0, '', 13623);

Squirky Quest Credit

DELETE FROM `creature_template` WHERE `entry`=53543;
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`, `exp_unk`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_fly`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `type_flags2`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `currencyId`, `currencyCount`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Mana_mod_extra`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (53543, 0, 0, 0, 0, 0, 17188, 0, 0, 0, 'Feed Squrky Credit', '', '', 0, 1, 1, 0, 0, 35, 35, 0, 1, 1.14286, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 2000, 2000, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 'SmartAI', 0, 3, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '', 15595);

Squirky Quest Credit placement

DELETE FROM `creature` WHERE `guid`=719664;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (719664, 53543, 0, 1537, 4679, 1, 1, 0, 0, -4609.28, -1095.66, 504.98, 6.11255, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0);

Fishing Loot Forlorn Cavern

DELETE FROM `fishing_loot_template` WHERE (`entry`=4679);
INSERT INTO `fishing_loot_template` VALUES 
(4679, 2079, 0.120851, 1, 1, 1, 1),
(4679, 2555, 0.120851, 1, 1, 1, 1),
(4679, 2601, 0.120851, 1, 1, 1, 1),
(4679, 2961, 0.120851, 1, 1, 1, 1),
(4679, 2982, 0.120851, 1, 1, 1, 1),
(4679, 3040, 0.120851, 1, 1, 1, 1),
(4679, 3195, 0.108765, 1, 1, 1, 1),
(4679, 3211, 0.120851, 1, 1, 1, 1),
(4679, 3393, 0.120851, 1, 1, 1, 1),
(4679, 3610, 0.120851, 1, 1, 1, 1),
(4679, 3645, 0.108765, 1, 1, 1, 1),
(4679, 4345, 0.120201, 1, 1, 1, 1),
(4679, 4346, 0.120851, 1, 1, 1, 1),
(4679, 4564, 0.120851, 1, 1, 1, 1),
(4679, 4684, 0.120201, 1, 1, 1, 1),
(4679, 5071, 0.120851, 1, 1, 1, 1),
(4679, 5207, 0.120851, 1, 1, 1, 1),
(4679, 5578, 0.120851, 1, 1, 1, 1),
(4679, 5972, 0.120851, 1, 1, 1, 1),
(4679, 6344, 0.120851, 1, 1, 1, 1),
(4679, 6380, 0.120851, 1, 1, 1, 1),
(4679, 6391, 0.108765, 1, 1, 1, 1),
(4679, 6510, 0.120851, 1, 1, 1, 1),
(4679, 6512, 0.120851, 1, 1, 1, 1),
(4679, 6518, 0.120851, 1, 1, 1, 1),
(4679, 6541, 0.108765, 1, 1, 1, 1),
(4679, 6548, 0.120851, 1, 1, 1, 1),
(4679, 6555, 0.108765, 1, 1, 1, 1),
(4679, 9755, 0.108765, 1, 1, 1, 1),
(4679, 45194, 0.102051, 1, 1, 1, 1),
(4679, 69932, -100, 1, 0, 1, 1),
(4679, 69933, -100, 1, 0, 1, 1);