calendar_invites
This table holds player event attendance.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| id | bigint | unsigned | PRI | NO | 0 | ||
| event | bigint | unsigned | NO | 0 | |||
| invitee | int | unsigned | NO | 0 | |||
| sender | int | unsigned | NO | 0 | |||
| status | tinyint | unsigned | NO | 0 | |||
| statustime | int | unsigned | NO | 0 | |||
| rank | tinyint | unsigned | NO | 0 | |||
| text | varchar(255) | NO | '' | ||||
Description of fields
id
The GUID of the invite.
event
The calendar event id the player belongs to.
invitee
character guid of the player invited to the event.
sender
character guid of the player handing out the invite.
When creating a new event the owner invites itself (sender == invitee).
status
| ID | Name | Comment |
|---|---|---|
| 0 | CALENDAR_STATUS_INVITED | |
| 1 | CALENDAR_STATUS_ACCEPTED | |
| 2 | CALENDAR_STATUS_DECLINED | |
| 3 | CALENDAR_STATUS_CONFIRMED | |
| 4 | CALENDAR_STATUS_OUT | |
| 5 | CALENDAR_STATUS_STANDBY | |
| 6 | CALENDAR_STATUS_SIGNED_UP | |
| 7 | CALENDAR_STATUS_NOT_SIGNED_UP | not saved in db |
| 8 | CALENDAR_STATUS_TENTATIVE | |
| 9 | CALENDAR_STATUS_REMOVED | not saved in db |
statustime
Unixtime of last status change.
rank
| ID | Name |
|---|---|
| 0 | CALENDAR_RANK_PLAYER |
| 1 | CALENDAR_RANK_MODERATOR |
| 2 | CALENDAR_RANK_OWNER |
text
- unknown -
