Guild member

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

Версия от 12:03, 13 февраля 2011; NeatElves (Обсуждение | вклад)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к: навигация, поиск

Содержание

К описанию таблиц базы данных characters.


Таблица `guild_member`

This table holds information on the members of all guilds, their ranks in the guild, and any notes made by them or by guild officers.


Структура

Field Type Attributes Null Key Default Comments
guildid int(6) unsigned NO MUL 0
guid int(11) unsigned NO MUL 0
rank tinyint(2) unsigned NO 0
pnote varchar(255) NO
offnote varchar(255) NO
BankResetTimeMoney int(11) unsigned NO 0
BankRemMoney int(11) unsigned NO 0
BankResetTimeTab0 int(11) unsigned NO 0
BankRemSlotsTab0 int(11) unsigned NO 0
BankResetTimeTab1 int(11) unsigned NO 0
BankRemSlotsTab1 int(11) unsigned NO 0
BankResetTimeTab2 int(11) unsigned NO 0
BankRemSlotsTab2 int(11) unsigned NO 0
BankResetTimeTab3 int(11) unsigned NO 0
BankRemSlotsTab3 int(11) unsigned NO 0
BankResetTimeTab4 int(11) unsigned NO 0
BankRemSlotsTab4 int(11) unsigned NO 0
BankResetTimeTab5 int(11) unsigned NO 0
BankRemSlotsTab5 int(11) unsigned NO 0


Описание полей

guildid

The ID of the guild that the member is a part of. See guild.guildid

guid

The GUID of the player. See characters.guid

rank

The rank that the player has in the guild. See guild_rank.rid

pnote

The note set by the player that can be read by everyone.

offnote

The note set by officers in the guild that can only be read by other officers of the guild.

BankResetTimeMoney

BankRemMoney

BankResetTimeTab

BankRemSlotsTab

Личные инструменты