DB/GameEvents: Fix Fishing Extravaganza timers and add a missing spawn

1 files changed, 17 insertions, 0 deletions

diff --git a/sql/updates/world/2011_04_03_01_world_game_events.sql b/sql/updates/world/2011_04_03_01_world_game_events.sql
new file mode 100644
index 00000000000..f5615ec0b15
--- /dev/null
+++ b/sql/updates/world/2011_04_03_01_world_game_events.sql
@@ -0,0 +1,17 @@
+SET @Event = 62;
+SET @GUID = 209028;
+
+UPDATE `game_event` SET `start_time`='2011-01-04 14:00:00',`description`='Fishing Extravaganza Fishing Pools' WHERE `eventEntry`=15; -- Fishing Extravaganza
+UPDATE `game_event` SET `start_time`='2011-01-03 14:00:00',`length`=60*(24+3) WHERE `eventEntry`=14; -- Fishing Extravaganza Announce
+DELETE FROM `game_event` WHERE `eventEntry`=@Event;
+INSERT INTO `game_event` (`eventEntry`,`start_time`,`end_time`,`occurence`,`length`,`holiday`,`description`,`world_event`) VALUES
+(@Event, '2011-01-04 14:00:00', '2020-12-31 05:00:00',10080,3*60,0, 'Fishing Extravaganza Turn-ins',0);
+
+UPDATE `game_event_creature` SET `eventEntry`=@Event WHERE `guid` IN (54688,54687,203521);
+DELETE FROM `game_event_creature` WHERE `guid`=@GUID;
+INSERT INTO `game_event_creature` (`eventEntry`,`guid`) VALUES
+(14,@GUID);
+
+DELETE FROM `creature` WHERE `id`=15119;
+INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
+(@GUID,15119,0,1,1,0,0,-4964.69,-936.287,501.743,5.44543,300,0,0,1,0,0,0,0,0,0);