Installation
3
Database (oxmysql)
CREATE TABLE IF NOT EXISTS xmas_tree_progress (
id TINYINT NOT NULL PRIMARY KEY,
xp INT NOT NULL DEFAULT 0,
stage TINYINT NOT NULL DEFAULT 1
);
CREATE TABLE IF NOT EXISTS xmas_players (
identifier VARCHAR(64) NOT NULL PRIMARY KEY,
total_xp INT NOT NULL DEFAULT 0,
donations_today INT NOT NULL DEFAULT 0,
last_donation_date DATE DEFAULT NULL,
last_spot_date DATE DEFAULT NULL,
spot_count_today INT NOT NULL DEFAULT 0,
last_daily_date DATE DEFAULT NULL,
calendar_claims LONGTEXT DEFAULT NULL,
last_quest_day DATE DEFAULT NULL,
quest_completed TINYINT(1) NOT NULL DEFAULT 0,
key_day TINYINT UNSIGNED DEFAULT NULL,
key_used TINYINT(1) NOT NULL DEFAULT 0
);4
5