Skip to content

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 ​

FieldTypeAttributesKeyNullDefaultExtraComment
guildidintunsignedPRINO0
namevarchar(24)NO''
leaderguidintunsignedNO0
EmblemStyletinyintunsignedNO0
EmblemColortinyintunsignedNO0
BorderStyletinyintunsignedNO0
BorderColortinyintunsignedNO0
BackgroundColortinyintunsignedNO0
infovarchar(500)NO''
motdvarchar(128)NO''
createdateintunsignedNO0
BankMoneybigintunsignedNO0

 

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.