Guild rank
Материал из YTDB DataBase
(Различия между версиями)
Neggod (Обсуждение | вклад) (Новая страница: «{| align="right" | __TOC__ |} Back to the characters database list of tables. <big>'''The `guild_rank` table'''</big> This table holds the…») |
NeatElves (Обсуждение | вклад) |
||
| Строка 2: | Строка 2: | ||
| __TOC__ | | __TOC__ | ||
|} | |} | ||
| - | + | К описанию таблиц [[Charactersdb_struct|базы данных characters]]. | |
| - | <big>''' | + | <big>'''Таблица `guild_rank`'''</big> |
This table holds the information on all of the ranks available in a guild along with their names and what rights a person with that rank has. | This table holds the information on all of the ranks available in a guild along with their names and what rights a person with that rank has. | ||
| - | <big>''' | + | <big>'''Структура'''</big> |
{| border="1" | {| border="1" | ||
|'''Field''' | |'''Field''' | ||
|'''Type''' | |'''Type''' | ||
| + | |'''Attributes''' | ||
|'''Null''' | |'''Null''' | ||
|'''Key''' | |'''Key''' | ||
|'''Default''' | |'''Default''' | ||
| - | |''' | + | |'''Comments''' |
|- | |- | ||
|[[#guildid|guildid]] | |[[#guildid|guildid]] | ||
| - | |int(6) unsigned | + | |int(6) |
| + | |unsigned | ||
|NO | |NO | ||
|PRI | |PRI | ||
| Строка 27: | Строка 29: | ||
|- | |- | ||
|[[#rid|rid]] | |[[#rid|rid]] | ||
| - | |int(11) unsigned | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
|PRI | |PRI | ||
| Строка 35: | Строка 38: | ||
|[[#rname|rname]] | |[[#rname|rname]] | ||
|varchar(255) | |varchar(255) | ||
| - | |||
| | | | ||
| + | |NO | ||
| | | | ||
| + | |'' | ||
| | | | ||
|- | |- | ||
|[[#rights|rights]] | |[[#rights|rights]] | ||
| - | |int(3) unsigned | + | |int(3) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 48: | Строка 53: | ||
|- | |- | ||
|[[#BankMoneyPerDay|BankMoneyPerDay]] | |[[#BankMoneyPerDay|BankMoneyPerDay]] | ||
| - | |int(11) unsigned | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 56: | Строка 62: | ||
| - | <big>''' | + | <big>'''Описание полей'''</big> |
====guildid==== | ====guildid==== | ||
The guild ID that the rank is part of. See [[guild#guildid|guild.guildid]] | The guild ID that the rank is part of. See [[guild#guildid|guild.guildid]] | ||
| Строка 98: | Строка 104: | ||
====BankMoneyPerDay==== | ====BankMoneyPerDay==== | ||
The total money per day, in copper, that a person with this rank can take out. Use the maximum value of an unsigned int (4294967295) to specify unlimited amount. | The total money per day, in copper, that a person with this rank can take out. Use the maximum value of an unsigned int (4294967295) to specify unlimited amount. | ||
| - | |||
| - | |||
Версия 13:20, 8 декабря 2010
|
К описанию таблиц базы данных characters.
Таблица `guild_rank`
This table holds the information on all of the ranks available in a guild along with their names and what rights a person with that rank has.
Структура
| Field | Type | Attributes | Null | Key | Default | Comments |
| guildid | int(6) | unsigned | NO | PRI | 0 | |
| rid | int(11) | unsigned | NO | PRI | ||
| rname | varchar(255) | NO | ||||
| rights | int(3) | unsigned | NO | 0 | ||
| BankMoneyPerDay | int(11) | unsigned | NO | 0 |
Описание полей
guildid
The guild ID that the rank is part of. See guild.guildid
rid
The particular rank ID. This number must be unique to each rank in a guild.
rname
The name of the rank that is displayed in-game.
rights
The rights a player with this rank has in the guild. The calculation of multiple rights is a bit different in this case as the rights do not all have 2^n values. To combine ranks, you must do the OR operation (|) on the two flags.
| Flag | Name | Comments |
|---|---|---|
| 64 | GR_RIGHT_EMPTY | Having just this flag by itself is equivalent to having no rights at all. |
| 65 | GR_RIGHT_GCHATLISTEN | Player can read messages in the guild general chat channel. |
| 66 | GR_RIGHT_GCHATSPEAK | Player can type messages in the guild general chat channel. |
| 68 | GR_RIGHT_OFFCHATLISTEN | Player can read messages in the guild officers channel. |
| 72 | GR_RIGHT_OFFCHATSPEAK | Player can type messages in the guild officers channel. |
| 80 | GR_RIGHT_INVITE | Can invite other players to guild. |
| 96 | GR_RIGHT_REMOVE | Can kick other players out of guild. |
| 192 | GR_RIGHT_PROMOTE | Can promote other players. |
| 320 | GR_RIGHT_DEMOTE | Can demote other players. |
| 4160 | GR_RIGHT_SETMOTD | Can change the guild message of the day. |
| 8256 | GR_RIGHT_EPNOTE | Can edit other players' personal notes. |
| 16448 | GR_RIGHT_VIEWOFFNOTE | Can view the officer notes of other players. |
| 32832 | GR_RIGHT_EOFFNOTE | Can edit officer notes of other players. |
| 61951 | GR_RIGHT_ALL | Has all of the rights. |
BankMoneyPerDay
The total money per day, in copper, that a person with this rank can take out. Use the maximum value of an unsigned int (4294967295) to specify unlimited amount.
