AzerothCore
Pages :
petition
The `petition` table
This table holds information on all ongoing petitions for a guild or for an arena team.
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ownerguid | INT | UNSIGNED | PRI | NO | |||
| petitionguid | INT | UNSIGNED | YES | 0 | |||
| petition_id | INT | UNSIGNED | NO | 0 | |||
| name | VARCHAR(24) | SIGNED | NO | ||||
| type | TINYINT | UNSIGNED | PRI | NO | 0 |
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.
petition_id
Sequential identifier of the petition, unique per petition. Used to reference the petition independently of the charter item 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.
| ID | Type |
|---|---|
| 2 | 2vs2 Arena charter |
| 3 | 3vs3 Arena charter |
| 5 | 5vs5 Arena charter |
| 9 | Guild charter |