Back to 'calendar_events' Return to characters Go to 'channels'
This table holds player event attendance.
| 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 | '' |
The GUID of the invite.
The calendar event id the player belongs to.
character guid of the player invited to the event.
character guid of the player handing out the invite.
When creating a new event the owner invites itself (sender == invitee).
| 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 |
Unixtime of last status change.
| ID | Name |
|---|---|
| 0 | CALENDAR_RANK_PLAYER |
| 1 | CALENDAR_RANK_MODERATOR |
| 2 | CALENDAR_RANK_OWNER |
- unknown -
Back to 'calendar_events' Return to characters Go to 'channels'