
π SQL
To ensure the quest and XP system works as intended you must run or import the SQL file provided in the folder [SQL]
to your database. Failure to do so will result in errors when mining
CREATE TABLE IF NOT EXISTS `mining_rep` (
`citizenid` VARCHAR(50) NOT NULL,
`rep` INT(11) DEFAULT 0,
`ores_mined` INT(11) DEFAULT 0,
`claimed_quests` TEXT DEFAULT NULL,
PRIMARY KEY (`citizenid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
Last updated