Guild member
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) |
||
| Строка 178: | Строка 178: | ||
The ID of the guild that the member is a part of. See [[guild#guildid|guild.guildid]] | The ID of the guild that the member is a part of. See [[guild#guildid|guild.guildid]] | ||
====guid==== | ====guid==== | ||
| - | The GUID of the player. See [[ | + | The GUID of the player. See [[characters#guid|characters.guid]] |
====rank==== | ====rank==== | ||
The rank that the player has in the guild. See [[guild_rank#rid|guild_rank.rid]] | The rank that the player has in the guild. See [[guild_rank#rid|guild_rank.rid]] | ||
Версия 13:27, 8 декабря 2010
|
К описанию таблиц базы данных 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.
