Skip to content
Schmoozerd edited this page Apr 14, 2013 · 1 revision

Back to the characters database list of tables.

The `guild_member` table

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 Null Key Default Extra
guildid int(6) unsigned NO MUL 0
guid int(11) unsigned NO MUL 0
rank tinyint(2) unsigned NO 0
pnote varchar(255) NO
offnote varchar(255) NO
BankResetTimeMoney int(11) unsigned NO 0
BankRemMoney int(11) unsigned NO 0
BankResetTimeTab0 int(11) unsigned NO 0
BankRemSlotsTab0 int(11) unsigned NO 0
BankResetTimeTab1 int(11) unsigned NO 0
BankRemSlotsTab1 int(11) unsigned NO 0
BankResetTimeTab2 int(11) unsigned NO 0
BankRemSlotsTab2 int(11) unsigned NO 0
BankResetTimeTab3 int(11) unsigned NO 0
BankRemSlotsTab3 int(11) unsigned NO 0
BankResetTimeTab4 int(11) unsigned NO 0
BankRemSlotsTab4 int(11) unsigned NO 0
BankResetTimeTab5 int(11) unsigned NO 0
BankRemSlotsTab5 int(11) unsigned NO 0

Description of the fields

guildid

The ID of the guild that the member is a part of. See guild.guildid

guid

The GUID of the player. See character.guid

rank

The rank that the player has in the guild. See guild_rank.rid

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.

BankResetTimeMoney

BankRemMoney

BankResetTimeTab

BankRemSlotsTab

Clone this wiki locally