petition_sign

Back-to:Characters

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(10)

unsigned

 

NO

 

 

 

petitionguid

int(10)

unsigned

PRI

NO

0

 

 

playerguid

int(10)

unsigned

PRI

NO

0

 

 

player_account

int(10)

unsigned

 

NO

0

 

 

type

tinyint(3)

unsigned

 

NO

0

 

 

Description of the fields

ownerguid

The GUID of the owner that is trying to make the guild/arena team. See characters.guid

petitionguid

The GUID of the charter item. See item_template.guid

playerguid

The GUID of the player that has signed the charter. See characters.guid

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

Type

2

2vs2 Arena charter

3

3vs3 Arena charter

5

5vs5 Arena charter

9

Guild charter