|
NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'guild_rank' table for MaNGOSOne
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.
Table Notes
This table uses the 'MyISAM' DB Engine
The Field definitions follow:
| Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
|---|---|---|---|---|---|---|
| guildid | int(6) unsigned | NO | PRI | '0' | The guild ID that the rank is part of. [See guild.guildid] | |
| rid | int(11) unsigned | NO | PRI | NULL | The particular rank ID. This number must be unique to each rank in a guild. | |
| rname | varchar(255) | NO | {Blank String} | The name of the rank that is displayed in-game. | ||
| rights | int(3) unsigned | NO | '0' | The rights a player with this rank has in the guild. | ||
| BankMoneyPerDay | int(11) unsigned | NO | '0' |
Description of the fields
guildid int(6) unsigned
The guild ID that the rank is part of. [See guild.guildid]
rid int(11) unsigned
The particular rank ID. This number must be unique to each rank in a guild.
rname varchar(255)
The name of the rank that is displayed in-game.
rights int(3) unsigned
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 | Flag Name | Meaning |
|---|---|---|
| 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 int(11) unsigned
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now