Guild rank

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

(Различия между версиями)
Перейти к: навигация, поиск
(Новая страница: «{| align="right" | __TOC__ |} Back to the characters database list of tables. <big>'''The `guild_rank` table'''</big> This table holds the…»)
 
(1 промежуточная версия не показана)
Строка 2: Строка 2:
| __TOC__
| __TOC__
|}
|}
-
Back to the [[charactersdb_struct|characters database]] list of tables.
+
[[Category: Mangos characters database tables]]
 +
К описанию таблиц [[Charactersdb_struct|базы данных characters]].
-
<big>'''The `guild_rank` table'''</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>'''Structure'''</big>
+
<big>'''Структура'''</big>
{| border="1"
{| border="1"
|'''Field'''
|'''Field'''
|'''Type'''
|'''Type'''
 +
|'''Attributes'''
|'''Null'''
|'''Null'''
|'''Key'''
|'''Key'''
|'''Default'''
|'''Default'''
-
|'''Extra'''
+
|'''Comments'''
|-
|-
|[[#guildid|guildid]]
|[[#guildid|guildid]]
-
|int(6) unsigned
+
|int(6)
 +
|unsigned
|NO
|NO
|PRI
|PRI
Строка 27: Строка 30:
|-
|-
|[[#rid|rid]]
|[[#rid|rid]]
-
|int(11) unsigned
+
|int(11)
 +
|unsigned
|NO
|NO
|PRI
|PRI
Строка 35: Строка 39:
|[[#rname|rname]]
|[[#rname|rname]]
|varchar(255)
|varchar(255)
-
|NO
 
|
|
 +
|NO
|
|
 +
|''
|
|
|-
|-
|[[#rights|rights]]
|[[#rights|rights]]
-
|int(3) unsigned
+
|int(3)
 +
|unsigned
|NO
|NO
|
|
Строка 48: Строка 54:
|-
|-
|[[#BankMoneyPerDay|BankMoneyPerDay]]
|[[#BankMoneyPerDay|BankMoneyPerDay]]
-
|int(11) unsigned
+
|int(11)
 +
|unsigned
|NO
|NO
|
|
Строка 56: Строка 63:
-
<big>'''Description of the fields'''</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: Строка 105:
====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.
-
 
-
(c)udbwiki
 

Текущая версия на 12:03, 13 февраля 2011

Содержание

К описанию таблиц базы данных 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.

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