From 94fd1487d0f0c60a28a132385affbd16933f0bc2 Mon Sep 17 00:00:00 2001
From: click <none@none>
Date: Thu, 2 Dec 2010 17:30:48 +0100
Subject: Core/Chat: Fix issues introduced in 177d6f86ca + Wrong update-query
 for the channels-table (SQL from 10548 sorted properly) + Add a small
 correction on Channel.cpp say handling (thanks to Lazzalf/Leak)

--HG--
branch : trunk
---
 sql/updates/10548_characters_channel.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'sql')

diff --git a/sql/updates/10548_characters_channel.sql b/sql/updates/10548_characters_channel.sql
index 905d3583e4a..126a51ca5bb 100644
--- a/sql/updates/10548_characters_channel.sql
+++ b/sql/updates/10548_characters_channel.sql
@@ -5,4 +5,5 @@ CHANGE `m_announce` `m_announce` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL,
 CHANGE `m_public` `m_ownership` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL,
 CHANGE `m_password` `m_password` VARCHAR(32) NULL,
 ADD COLUMN `last_used` INT(10) UNSIGNED NOT NULL AFTER `BannedList`;
-SET last_used = UNIX_TIMESTAMP();
+-- Set already existing/current channels to use current timestamp (saves them from being unneccesarily cleaned up)
+UPDATE `channels` SET last_used = UNIX_TIMESTAMP();
-- 
cgit v1.2.3