summaryrefslogtreecommitdiff
path: root/docs/guild_member.md
diff options
context:
space:
mode:
Diffstat (limited to 'docs/guild_member.md')
-rw-r--r--docs/guild_member.md271
1 files changed, 262 insertions, 9 deletions
diff --git a/docs/guild_member.md b/docs/guild_member.md
index 2455393..d1716f5 100644
--- a/docs/guild_member.md
+++ b/docs/guild_member.md
@@ -1,9 +1,262 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [guild_member](guild_member)
-
-Column | Type | Description
---- | --- | ---
-Guildid | int(10) unsigned |
-Guid | int(10) unsigned |
-Rank | tinyint(3) unsigned |
-Pnote | varchar(31) |
-Offnote | varchar(31) |
+# guild\_member
+
+`Back-to:Characters`
+
+**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**
+
+<table>
+<colgroup>
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+</colgroup>
+<tbody>
+<tr class="odd">
+<td><p><strong>Field</strong></p></td>
+<td><p><strong>Type</strong></p></td>
+<td><p><strong>Attributes</strong></p></td>
+<td><p><strong>Key</strong></p></td>
+<td><p><strong>Null</strong></p></td>
+<td><p><strong>Default</strong></p></td>
+<td><p><strong>Extra</strong></p></td>
+<td><p><strong>Comment</strong></p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild_member-guildid">guildid</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+<td><p>Guild Identificator</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#guild_member-guid">guid</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p>Unique</p></td>
+<td><p>NO</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild_member-rank">rank</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#guild_member-pnote">pnote</a></p></td>
+<td><p>varchar(31)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>&quot;</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild_member-offnote">offnote</a></p></td>
+<td><p>varchar(31)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>&quot;</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#guild_member-BankResetTimeMoney">BankResetTimeMoney</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild_member-BankRemMoney">BankRemMoney</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#guild_member-BankResetTimeTab0-5">BankResetTimeTab0</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild_member-BankRemSlotsTab0-5">BankRemSlotsTab0</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#guild_member-BankResetTimeTab0-5">BankResetTimeTab1</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild_member-BankRemSlotsTab0-5">BankRemSlotsTab1</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#guild_member-BankResetTimeTab0-5">BankResetTimeTab2</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild_member-BankRemSlotsTab0-5">BankRemSlotsTab2</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#guild_member-BankResetTimeTab0-5">BankResetTimeTab3</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild_member-BankRemSlotsTab0-5">BankRemSlotsTab3</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#guild_member-BankResetTimeTab0-5">BankResetTimeTab4</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild_member-BankRemSlotsTab0-5">BankRemSlotsTab4</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#guild_member-BankResetTimeTab0-5">BankResetTimeTab5</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild_member-BankRemSlotsTab0-5">BankRemSlotsTab5</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+</tbody>
+</table>
+
+**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 characters.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
+
+`field-no-description|6`
+
+### BankRemMoney
+
+`field-no-description|7`
+
+### BankResetTimeTab0-5
+
+`field-no-description|8`
+
+### BankRemSlotsTab0-5
+
+`field-no-description|9`