diff options
| author | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-11-19 21:40:45 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-11-19 21:40:45 +0100 |
| commit | e5c047c90dfbc5a2172a4ae59a66c520f417539e (patch) | |
| tree | caa733b840a5883df3e2b92f4827f671300bef4d | |
| parent | 731d30664f5b9400f624d1dd5700ae06c1d51011 (diff) | |
DB/Misc: some cleanups
| -rw-r--r-- | sql/updates/world/2012_11_19_02_world_misc.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2012_11_19_02_world_misc.sql b/sql/updates/world/2012_11_19_02_world_misc.sql new file mode 100644 index 00000000000..1f792b8da41 --- /dev/null +++ b/sql/updates/world/2012_11_19_02_world_misc.sql @@ -0,0 +1,6 @@ +SET @Event = 26; -- game_event.entry - Set by TDB +DELETE FROM `game_event` WHERE `eventEntry`=@Event; +INSERT INTO `game_event` (`eventEntry`,`start_time`,`end_time`,`occurence`,`length`,`holiday`,`description`,`world_event`) VALUES +(@Event,'2012-11-18 01:00:00','2020-12-31 05:00:00',525600,10020,404, 'Pilgrim''s Bounty',0); +-- undo hack, reset to sniffed values +UPDATE `gameobject_template` SET `data10`=37639,`data5`=0 WHERE `entry`=184867; |