guild_member
This table holds information on the members of all guilds, their ranks in the guild, and any notes made by them or by guild officers.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guildid | int | unsigned | MUL | NO | Guild Identificator | ||
| guid | int | unsigned | PRI | NO | |||
| rank | tinyint | unsigned | NO | ||||
| pnote | varchar(31) | NO | '' | ||||
| offnote | varchar(31) | NO | '' | ||||
Description of fields
guildid
references guild.guildid.
guid
The character guid of the guild member.
rank
The guild rank per member.
pnote
The note set by the player that can be read by everyone.
offnote
The note set by officers in the guild that can only be read by other officers of the guild.