====== guild_rank 表 ====== ---- [[数据库:characters数据库:首页|<-返回:Characters 数据库]] 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^Key^Null^Default^extra^Comment^ |[[#guildid|guildid]]|INT|UNSIGNED|PRI|NO|0| | | |[[#rid|rid]]|TINYINT|UNSIGNED|PRI|NO| | | | |[[#rname|rname]]|VARCHAR(20)|SIGNED| |NO|"| | | |[[#rights|rights]]|MEDIUMINT|UNSIGNED| |NO|0| | | |[[#BankMoneyPerDay|BankMoneyPerDay]]|INT|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.| |65600|GR_RIGHT_MODIFY_GUILD_INFO|Can edit guild info.| |131072|GR_RIGHT_WITHDRAW_GOLD_LOCK|Can remove money withdraw capacity.| |262144|GR_RIGHT_WITHDRAW_REPAIR|Can withdraw for repair.| |524288|GR_RIGHT_WITHDRAW_GOLD|Can withdraw gold.| |1048576|GR_RIGHT_CREATE_GUILD_EVENT|Can create a guild event.| |1962495|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.