数据库:characters数据库:guild_rank
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 后一修订版 | 前一修订版 | ||
| 数据库:characters数据库:guild_rank [2023/09/24 12:23] – 创建 admin | 数据库:characters数据库:guild_rank [2023/09/24 12:24] (当前版本) – [rights] admin | ||
|---|---|---|---|
| 行 7: | 行 7: | ||
| **表结构** | **表结构** | ||
| ^Field^Type^Attributes^Key^Null^Default^extra^Comment^ | ^Field^Type^Attributes^Key^Null^Default^extra^Comment^ | ||
| - | |[[#id|id]]|INT|UNSIGNED|PRI|NO| | | | | + | |[[#guildid|guildid]]|INT|UNSIGNED|PRI|NO|0| | | |
| - | |[[#gmlevel|gmlevel]]|TINYINT|UNSIGNED| |NO| | | | | + | |[[#rid|rid]]|TINYINT|UNSIGNED|PRI|NO| | | | |
| - | |[[#RealmID|RealmID]]|INT|SIGNED|PRI|NO|-1| | | | + | |[[#rname|rname]]|VARCHAR(20)|SIGNED| |NO|"| | | |
| - | |[[#comment|comment]]|VARCHAR(255)|SIGNED| |YES|' '| | | | + | |[[#rights|rights]]|MEDIUMINT|UNSIGNED| |NO|0| | | |
| + | |[[# | ||
| 行 31: | 行 33: | ||
| 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. | 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 | + | ^Flag^Name^Comments^ |
| - | 64 GR_RIGHT_EMPTY Having just this flag by itself is equivalent to having no rights at all. | + | |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. | + | |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. | + | |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. | + | |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. | + | |72|GR_RIGHT_OFFCHATSPEAK|Player can type messages in the guild officers channel.| |
| - | 80 GR_RIGHT_INVITE Can invite other players to guild. | + | |80|GR_RIGHT_INVITE|Can invite other players to guild.| |
| - | 96 GR_RIGHT_REMOVE Can kick other players out of guild. | + | |96|GR_RIGHT_REMOVE|Can kick other players out of guild.| |
| - | 192 GR_RIGHT_PROMOTE Can promote other players. | + | |192|GR_RIGHT_PROMOTE|Can promote other players.| |
| - | 320 GR_RIGHT_DEMOTE Can demote other players. | + | |320|GR_RIGHT_DEMOTE|Can demote other players.| |
| - | 4160 GR_RIGHT_SETMOTD Can change the guild message of the day. | + | |4160|GR_RIGHT_SETMOTD|Can change the guild message of the day.| |
| - | 8256 GR_RIGHT_EPNOTE Can edit other players' | + | |8256|GR_RIGHT_EPNOTE|Can edit other players' |
| - | 16448 GR_RIGHT_VIEWOFFNOTE Can view the officer notes of other players. | + | |16448|GR_RIGHT_VIEWOFFNOTE|Can view the officer notes of other players.| |
| - | 32832 GR_RIGHT_EOFFNOTE Can edit officer notes of other players. | + | |32832|GR_RIGHT_EOFFNOTE|Can edit officer notes of other players.| |
| - | 65600 GR_RIGHT_MODIFY_GUILD_INFO Can edit guild info. | + | |65600|GR_RIGHT_MODIFY_GUILD_INFO|Can edit guild info.| |
| - | 131072 GR_RIGHT_WITHDRAW_GOLD_LOCK Can remove money withdraw capacity. | + | |131072|GR_RIGHT_WITHDRAW_GOLD_LOCK|Can remove money withdraw capacity.| |
| - | 262144 GR_RIGHT_WITHDRAW_REPAIR Can withdraw for repair. | + | |262144|GR_RIGHT_WITHDRAW_REPAIR|Can withdraw for repair.| |
| - | 524288 GR_RIGHT_WITHDRAW_GOLD Can withdraw gold. | + | |524288|GR_RIGHT_WITHDRAW_GOLD|Can withdraw gold.| |
| - | 1048576 GR_RIGHT_CREATE_GUILD_EVENT Can create a guild event. | + | |1048576|GR_RIGHT_CREATE_GUILD_EVENT|Can create a guild event.| |
| - | 1962495 GR_RIGHT_ALL Has all of the rights. | + | |1962495|GR_RIGHT_ALL|Has all of the rights.| |
| ==== 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. | ||
数据库/characters数据库/guild_rank.1695529406.txt.gz · 最后更改: 2023/09/24 12:23 由 admin