Guild

Материал из YTDB DataBase

(Различия между версиями)

Версия 05:54, 30 мая 2010

Содержание

1 guildid
2 name
3 leaderguid
4 EmblemStyle
5 EmblemColor
6 BorderStyle
7 BorderColor
8 BackgroundColor
9 info
10 motd
11 createdate
12 BankMoney

Back to characters database list of tables.

The `guild` table

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	Null	Key	Default	Extra
guildid	int(6) unsigned	NO	PRI	0
name	varchar(255)	NO
leaderguid	int(6) unsigned	NO		0
EmblemStyle	int(5)	NO		0
EmblemColor	int(5)	NO		0
BorderStyle	int(5)	NO		0
BorderColor	int(5)	NO		0
BackgroundColor	int(5)	NO		0
info	text	NO
motd	varchar(255)	NO
createdate	datetime	YES
BankMoney	bigint(20)	NO		0

Description of the 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 name.

leaderguid

The GUID of the character who created the guild. See characters.guid

EmblemStyle

The emblem style of the guild tabard.

EmblemColor

The emblem color of the guild tabard.

BorderStyle

The border style of the guild tabard.

BorderColor

The border color of the guild tabard.

BackgroundColor

The background color of the guild tabard.

info

The text message that appears in the Guild Information box.

motd

The text that appears in the Message Of The Day box.

createdate

The date when the guild was created.

BankMoney

The total money, in copper, that is currently in the guild's guild bank.

(c)udbwiki

@@ Строка 110: / Строка 110: @@
 The guild name.
 ====leaderguid====
-The GUID of the character who created the guild. See [[character#guid|character.guid]]
+The GUID of the character who created the guild. See [[characters#guid|characters.guid]]
 ====EmblemStyle====
 The emblem style of the guild tabard.