AzerothCore
Pages :
Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.
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 | |||
| 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.
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 |