Guild ranks

From ArcEmu-Wiki
Revision as of 13:34, 11 March 2010 by Shadoxfix (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Contents

guildId

The id of the guild.

rankId

The id of the rank.

rankName

The name of the rank.

rankRights

The rights the player has if he has that rank.

goldLimitPerDay

The maximum gold limit a day.

bankTabFlags0

If he can access the first tab.

itemStacksPerDay0

How much items the player can get at that tab per day.

bankTabFlags1

If he can access the second tab.

itemStacksPerDay1

How much items the player can get at that tab per day.

bankTabFlags2

If he can access the thirth tab.

itemStacksPerDay2

How much items the player can get at that tab per day.

bankTabFlags3

If he can access the fourth tab.

itemStacksPerDay3

How much items the player can get at that tab per day.

bankTabFlags4

If he can access the fifth tab.

itemStacksPerDay4

How much items the player can get at that tab per day.

bankTabFlags5

If he can access the sixth tab.

itemStacksPerDay5

How much items the player can get at that tab per day.

SQL Structure

CREATE TABLE `guild_ranks` (
  `guildId` int(6) unsigned NOT NULL DEFAULT '0',
  `rankId` int(1) NOT NULL DEFAULT '0',
  `rankName` varchar(255) NOT NULL DEFAULT '',
  `rankRights` int(3) unsigned NOT NULL DEFAULT '0',
  `goldLimitPerDay` int(30) NOT NULL DEFAULT '0',
  `bankTabFlags0` int(30) NOT NULL DEFAULT '0',
  `itemStacksPerDay0` int(30) NOT NULL DEFAULT '0',
  `bankTabFlags1` int(30) NOT NULL DEFAULT '0',
  `itemStacksPerDay1` int(30) NOT NULL DEFAULT '0',
  `bankTabFlags2` int(30) NOT NULL DEFAULT '0',
  `itemStacksPerDay2` int(30) NOT NULL DEFAULT '0',
  `bankTabFlags3` int(30) NOT NULL DEFAULT '0',
  `itemStacksPerDay3` int(30) NOT NULL DEFAULT '0',
  `bankTabFlags4` int(30) NOT NULL DEFAULT '0',
  `itemStacksPerDay4` int(30) NOT NULL DEFAULT '0',
  `bankTabFlags5` int(30) NOT NULL DEFAULT '0',
  `itemStacksPerDay5` int(30) NOT NULL DEFAULT '0',
  PRIMARY KEY (`guildId`,`rankId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Personal tools