From a54713ec4bbfbfc619ef2ed5675722c2b61a7f47 Mon Sep 17 00:00:00 2001 From: Nay Date: Sat, 2 Apr 2011 01:24:57 +0100 Subject: DB/GameEvents: Change Nights to start at 9 PM (21:00) instead 2 AM. Thanks Aokromes. --- sql/updates/world/2011_03_01_00_world_creature.sql | 1 - sql/updates/world/2011_04_01_00_world_creature.sql | 1 + sql/updates/world/2011_04_02_00_world_game_event.sql | 2 ++ 3 files changed, 3 insertions(+), 1 deletion(-) delete mode 100644 sql/updates/world/2011_03_01_00_world_creature.sql create mode 100644 sql/updates/world/2011_04_01_00_world_creature.sql create mode 100644 sql/updates/world/2011_04_02_00_world_game_event.sql (limited to 'sql') diff --git a/sql/updates/world/2011_03_01_00_world_creature.sql b/sql/updates/world/2011_03_01_00_world_creature.sql deleted file mode 100644 index 982f41974b2..00000000000 --- a/sql/updates/world/2011_03_01_00_world_creature.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature` SET `spawnMask`=`spawnMask`|2|1 WHERE `guid` BETWEEN 48304 AND 48304+6 AND `id`=33233; diff --git a/sql/updates/world/2011_04_01_00_world_creature.sql b/sql/updates/world/2011_04_01_00_world_creature.sql new file mode 100644 index 00000000000..982f41974b2 --- /dev/null +++ b/sql/updates/world/2011_04_01_00_world_creature.sql @@ -0,0 +1 @@ +UPDATE `creature` SET `spawnMask`=`spawnMask`|2|1 WHERE `guid` BETWEEN 48304 AND 48304+6 AND `id`=33233; diff --git a/sql/updates/world/2011_04_02_00_world_game_event.sql b/sql/updates/world/2011_04_02_00_world_game_event.sql new file mode 100644 index 00000000000..b64127f6af5 --- /dev/null +++ b/sql/updates/world/2011_04_02_00_world_game_event.sql @@ -0,0 +1,2 @@ +-- Change Nights game event start time to 9 PM +UPDATE `game_event` SET `start_time`= '2008-01-02 21:00:00' WHERE `eventEntry`=25; -- cgit v1.2.3