petition_sign
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 | MUL | 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 fields
ownerguid
The character guid of the owner that is trying to found the guild/arena team.
petitionguid
The guid of the charter item.
playerguid
The character guid of the player that has signed the charter
player_account
The account id of the player that has signed the charter. No two players can sign the same charter from the same account.
type
The type of the petition.
| ID | Name |
|---|---|
| 2 | ARENA_TEAM_CHARTER_2v2_TYPE |
| 3 | ARENA_TEAM_CHARTER_3v3_TYPE |
| 5 | ARENA_TEAM_CHARTER_5v5_TYPE |
| 9 | GUILD_CHARTER_TYPE |
