diff options
| author | Machiavelli <none@none> | 2009-08-17 22:06:37 +0200 |
|---|---|---|
| committer | Machiavelli <none@none> | 2009-08-17 22:06:37 +0200 |
| commit | 977e655e2adb227ca1cd72ab317fd465ddd94b5c (patch) | |
| tree | 1386d5dc15d6374c83a5a6a6fdce8f06f5d061ee /sql | |
| parent | 9855c9e8715d1993ba5265a8c66951a0e548c510 (diff) | |
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
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/characters.sql | 1 | ||||
| -rw-r--r-- | sql/updates/5159_characters_channels.sql | 1 |
2 files changed, 1 insertions, 1 deletions
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`; |