guild
This table holds the main guild information. All created guilds or all guilds in the process of being created have a record in this table.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guildid | int | unsigned | PRI | NO | 0 | ||
| name | varchar(24) | NO | '' | ||||
| leaderguid | int | unsigned | NO | 0 | |||
| EmblemStyle | tinyint | unsigned | NO | 0 | |||
| EmblemColor | tinyint | unsigned | NO | 0 | |||
| BorderStyle | tinyint | unsigned | NO | 0 | |||
| BorderColor | tinyint | unsigned | NO | 0 | |||
| BackgroundColor | tinyint | unsigned | NO | 0 | |||
| info | varchar(500) | NO | '' | ||||
| motd | varchar(128) | NO | '' | ||||
| createdate | int | unsigned | NO | 0 | |||
| BankMoney | bigint | unsigned | NO | 0 | |||
Description of fields
guildid
The ID of the guild. This number is unique to each guild and is the main method to identify a guild.
name
The guild's name.
leaderguid
The character guid of the guild leader.
EmblemStyle
EmblemColor
Defines the emblem on the guild tabard. file index to: textures/GuildEmblems/Emblem_<Style>_<Color>_TU_U.blp / *_TL_U.blp
BorderStyle
BorderColor
Defines the border on the guild tabard. file index to: textures/GuildEmblems/Border_<Style>_<Color>_TU_U.blp / *_TL_U.blp
BackgroundColor
Defines the background color of the guild tabard. file index to: textures/GuildEmblems/Background_<Color>_TU_U.blp / *_TL_U.blp
info
The text message that appears in the Guild Information box.
motd
The text that appears in the 'Message Of The Day' box.
createdate
Unix timestamp when the guild was created.
BankMoney
The total money, in copper, that is currently in the guild's guild bank.