-- Spawn the main 'Master Angler' questgiver
DELETE 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 variable
SET @mob = (SELECT `guid` FROM world.creature WHERE id=15077);
-- Bind three NPCs to the event
DELETE 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 week
UPDATE `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;