diff options
| -rw-r--r-- | sql/updates/world/2011_04_03_01_world_game_events.sql | 17 |
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); |