Guilds

From ArcEmu-Wiki
Revision as of 13:49, 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.

It automatically increases.

guildName

The name of the guild.

leaderGuid

The Guid of the leader.

emblemStyle

The emblemStyle

emblemColor

The emblemColor

backgroundColor

The backgroundColor

guildInfo

The info about the guild.

motd

The motd when you login.

createdate

The date of creation.

bankBalance

SQL Structure

CREATE TABLE `guilds` (
  `guildId` bigint(20) NOT NULL AUTO_INCREMENT,
  `guildName` varchar(32) NOT NULL DEFAULT '',
  `leaderGuid` bigint(20) NOT NULL DEFAULT '0',
  `emblemStyle` int(10) NOT NULL DEFAULT '0',
  `emblemColor` int(10) NOT NULL DEFAULT '0',
  `borderStyle` int(10) NOT NULL DEFAULT '0',
  `borderColor` int(10) NOT NULL DEFAULT '0',
  `backgroundColor` int(10) NOT NULL DEFAULT '0',
  `guildInfo` varchar(300) NOT NULL DEFAULT '',
  `motd` varchar(300) NOT NULL DEFAULT '',
  `createdate` int(30) NOT NULL,
  `bankBalance` bigint(30) unsigned NOT NULL,
  PRIMARY KEY (`guildId`),
  UNIQUE KEY `guildId` (`guildId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Personal tools