From 977e655e2adb227ca1cd72ab317fd465ddd94b5c Mon Sep 17 00:00:00 2001
From: Machiavelli <none@none>
Date: Mon, 17 Aug 2009 22:06:37 +0200
Subject: Channel system update: * Fix bug that player does not have moderator
 priveliges when ownership was passed on to him after previous owner left the
 channel. * Comment out code + alter DB field that are responsible for storing
 ownerGUID in the database, making it no longer possible for an ex-owner to
 instantly regain ownership by rejoining the channel as this is not blizzlike.
 The code is commented out in case someone wants to make a configurable option
 out of it. * Cleanup some other code in affected files.

--HG--
branch : trunk
---
 sql/characters.sql                       | 1 -
 sql/updates/5159_characters_channels.sql | 1 +
 2 files changed, 1 insertion(+), 1 deletion(-)
 create mode 100644 sql/updates/5159_characters_channels.sql

(limited to 'sql')

diff --git a/sql/characters.sql b/sql/characters.sql
index 9bee55654ee..17a5e7b2abd 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -274,7 +274,6 @@ DROP TABLE IF EXISTS `channels`;
 CREATE TABLE `channels` (
   `m_name` text NOT NULL,
   `m_team` int(10) unsigned NOT NULL,
-  `m_ownerGUID` int(11) unsigned NOT NULL default '0',
   `m_announce` tinyint(1) unsigned NOT NULL default '0',
   `m_moderate` tinyint(1) unsigned NOT NULL default '0',
   `m_password` text,
diff --git a/sql/updates/5159_characters_channels.sql b/sql/updates/5159_characters_channels.sql
new file mode 100644
index 00000000000..4b107a8547c
--- /dev/null
+++ b/sql/updates/5159_characters_channels.sql
@@ -0,0 +1 @@
+ALTER TABLE `channels` DROP `m_ownerGUID`;
-- 
cgit v1.2.3