diff options
| author | azazel <none@none> | 2010-10-17 19:54:13 +0600 |
|---|---|---|
| committer | azazel <none@none> | 2010-10-17 19:54:13 +0600 |
| commit | c0faed2251dff3814fe60e1a8ba86a046e48f707 (patch) | |
| tree | 068f2ab41c2d32bbdeddd2e5c722dc6239cdd073 /sql | |
| parent | f5911917b4ea1e97b0f22876dc8f35bbfa9833c9 (diff) | |
Core/Guilds: guild code was completely refactored and rewritten.
* OOP desing and implementation;
* all the queries are moved to prepared statements;
* guild loading is optimized;
* all the possible interaction with guild's data is done inside the guild class;
* added more hooks to GuildScript class;
WARNING: Make sure you backup your characters database before applying this change (just in case).
Known problems with guilds:
* when new member is added to the guild, MOTD is not displayed for him in guild tab of social window;
* if you add item with random property to guild bank visual representation of item below it becomes wrong (it displays wrong stack number);
* packets order differs from official: currently guild bank packet traffic is twice as more than on offy.
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/10241_characters_guilds.sql | 2 |
2 files changed, 4 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index cd460411e9e..74ad13fe060 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1533,7 +1533,7 @@ DROP TABLE IF EXISTS `guild_bank_right`; CREATE TABLE `guild_bank_right` ( `guildid` int(11) unsigned NOT NULL default '0', `TabId` tinyint(1) unsigned NOT NULL default '0', - `rid` int(11) unsigned NOT NULL default '0', + `rid` tinyint(1) unsigned NOT NULL default '0', `gbright` tinyint(3) unsigned NOT NULL default '0', `SlotPerDay` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`guildid`,`TabId`,`rid`), @@ -1659,7 +1659,7 @@ DROP TABLE IF EXISTS `guild_rank`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `guild_rank` ( `guildid` int(6) unsigned NOT NULL default '0', - `rid` int(11) unsigned NOT NULL, + `rid` tinyint(1) unsigned NOT NULL, `rname` varchar(255) NOT NULL default '', `rights` int(3) unsigned NOT NULL default '0', `BankMoneyPerDay` int(11) unsigned NOT NULL default '0', diff --git a/sql/updates/10241_characters_guilds.sql b/sql/updates/10241_characters_guilds.sql new file mode 100644 index 00000000000..ba2d2cf7277 --- /dev/null +++ b/sql/updates/10241_characters_guilds.sql @@ -0,0 +1,2 @@ +ALTER TABLE guild_rank CHANGE COLUMN rid rid TINYINT(1) UNSIGNED NOT NULL; +ALTER TABLE guild_bank_right CHANGE COLUMN rid rid TINYINT(1) UNSIGNED NOT NULL DEFAULT 0; |