calendar_events
This table holds player created events.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| id | bigint | unsigned | PRI | NO | 0 | ||
| creator | int | unsigned | NO | 0 | |||
| title | varchar(255) | NO | '' | ||||
| description | varchar(255) | NO | '' | ||||
| type | tinyint | unsigned | NO | 4 | |||
| dungeon | int | signed | NO | -1 | |||
| eventtime | int | unsigned | NO | 0 | |||
| flags | int | unsigned | NO | 0 | |||
| time2 | int | unsigned | NO | 0 | |||
Description of fields
id
The GUID of the event.
creator
character guid of the creator.
title
short event title
description
fulltext event description
type
| ID | Name |
|---|---|
| 0 | CALENDAR_TYPE_RAID |
| 1 | CALENDAR_TYPE_DUNGEON |
| 2 | CALENDAR_TYPE_PVP |
| 3 | CALENDAR_TYPE_MEETING |
| 4 | CALENDAR_TYPE_OTHER |
dungeon
LFGDungeon ID or -1 if not set.
eventtime
Unixtime when the event is due.
flags
| Value | Flag | Name | Comment |
|---|---|---|---|
| 1 | 0x0001 | CALENDAR_FLAG_ALL_ALLOWED | Event is open to all |
| 16 | 0x0010 | CALENDAR_FLAG_INVITES_LOCKED | 'Lock Event' checkbox ticked |
| 64 | 0x0040 | CALENDAR_FLAG_WITHOUT_INVITES | Guild Announcement |
| 1024 | 0x0400 | CALENDAR_FLAG_GUILD_EVENT | Event is restricted to guild |
time2
Unixtime of: 946681200 (Sat Jan 01 00:00:00 UTC 2000)
Not sure, seems constant from the little sniffs we have