-- Spawn the main 'Master Angler' questgiverDELETE FROM `creature` WHERE id=15077;INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES('15077','0','1','1','0','13','-14428.5','518.461','9.29274','5.60027','25','0','0','3700','0','0','0');-- Get GUID as variableSET @mob = (SELECT `guid` FROM world.creature WHERE id=15077);-- Bind three NPCs to the eventDELETE FROM `game_event_creature` WHERE `event`=15;INSERT INTO `game_event_creature` (`guid`, `event`) VALUES(54688, 15),(54687, 15),(@mob, 15); -- Add end_quest_scrpt to 'Master Angler' quest so only 1 person can win each weekUPDATE `quest_template` SET `CompleteScript`=8193 WHERE `entry`=8193;DELETE FROM `quest_end_scripts` WHERE `id`=8193;-- The questgiver casts powerfull Invisibility upon himself. this spell can't be dispelled or neglected by players anyway. When the event ends the invisibility no longer has effect (proven by restarting the event)INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES(8193, 0, 15, 60190, 1, 0, 0, 0, 0, 0);-- update game_event data to match blizzlike timer!UPDATE `game_event` SET `start_time`='2009-01-04 14:00:00' WHERE entry=15;UPDATE `game_event` SET `start_time`='2009-01-04 9:00:00' WHERE entry=14;