This is the ingester which grabs statiscs from your Project Zomboid server files and uploads them to the SQL database for the API to access. NOTE: if you havnt had a player connect to your server yet, you will get an error. If you are having issues with the database tables not being autocreated, connect to the database with adminer (or another program of your choice) and create the tables and structure with the following: USE `Zombo`; SET NAMES utf8mb4; CREATE TABLE `Game` ( `id` int NOT NULL AUTO_INCREMENT, `dayofmonth` int NOT NULL, `month` int NOT NULL, `daysSinceStart` int NOT NULL, `name` text NOT NULL, `maxPlayers` int NOT NULL, `startDay` int NOT NULL, `startMonth` int NOT NULL, `startYear` int NOT NULL, `year` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; CREATE TABLE `Players` ( `id` int NOT NULL AUTO_INCREMENT, `username` text NOT NULL, `charname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `x` float NOT NULL, `y` float NOT NULL, `data` blob NOT NULL, `lastOnline` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

Project Zomboid