diff options
Diffstat (limited to 'docs/petition.md')
| -rw-r--r-- | docs/petition.md | 133 |
1 files changed, 125 insertions, 8 deletions
diff --git a/docs/petition.md b/docs/petition.md index 24cf369..444e1f2 100644 --- a/docs/petition.md +++ b/docs/petition.md @@ -1,8 +1,125 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [petition](petition) - -Column | Type | Description ---- | --- | --- -Ownerguid | int(10) unsigned | -Petitionguid | int(10) unsigned | -Name | varchar(24) | -Type | tinyint(3) unsigned | +# petition + +`Back-to:Characters` + +**The \`petition\` table** + +This table holds information on all ongoing petitions for a guild or for an arena team. + +**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="#petition-ownerguid">ownerguid</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p> </p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#petition-petitionguid">petitionguid</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#petition-name">name</a></p></td> +<td><p>varchar(24)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p> </p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#petition-type">type</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p>PRI</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** + +### ownerguid + +The petition's owner's GUID. See characters.guid + +### petitionguid + +The GUID of the petition item. See item\_instance.guid + +### name + +The name of the guild or arena team that the player is trying to ask for petitions for. + +### type + +The type of the petition. + +<table> +<colgroup> +<col width="50%" /> +<col width="50%" /> +</colgroup> +<thead> +<tr class="header"> +<th><p>ID</p></th> +<th><p>Type</p></th> +</tr> +</thead> +<tbody> +<tr class="odd"> +<td><p>2</p></td> +<td><p>2vs2 Arena charter</p></td> +</tr> +<tr class="even"> +<td><p>3</p></td> +<td><p>3vs3 Arena charter</p></td> +</tr> +<tr class="odd"> +<td><p>5</p></td> +<td><p>5vs5 Arena charter</p></td> +</tr> +<tr class="even"> +<td><p>9</p></td> +<td><p>Guild charter</p></td> +</tr> +</tbody> +</table> + + |
