The `petition_sign` table
This table holds information on all the signatures of a petition for either a guild or an arena team.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ownerguid | INT | UNSIGNED | NO | ||||
| petitionguid | INT | UNSIGNED | PRI | NO | 0 | ||
| playerguid | INT | UNSIGNED | PRI | NO | 0 | ||
| player_account | INT | UNSIGNED | NO | 0 | |||
| type | TINYINT | UNSIGNED | NO | 0 |
Description of the fields
The GUID of the owner that is trying to make the guild/arena team. See characters.guid.
The GUID of the charter item. See item_template.guid.
The GUID of the player that has signed the charter. See characters.guid.
The account ID of the player that has signed the charter. No two players can sign the same charter from the same account.
The type of the petition.
| ID | Type |
|---|---|
| 2 | 2vs2 Arena charter |
| 3 | 3vs3 Arena charter |
| 5 | 5vs5 Arena charter |
| 9 | Guild charter |