Running utils.py will produce a sqlite3 database with information on a Minecraft server, primarily based on log files.
python utils.py --help
usage: MinecraftLogParser [-h] [-i INPUT] [-o OUTPUT]
options:
-h, --help show this help message and exit
-i INPUT, --input INPUT
-o OUTPUT, --output OUTPUTSELECT DISTINCT
MINECRAFT_SERVER_LOGS_LOGGED_IN.IP,
MINECRAFT_SERVER_LOGS_LOGGED_IN.player
FROM MINECRAFT_SERVER_LOGS_LOGGED_IN
;SELECT
MINECRAFT_SERVER_LOGS_LOGGED_IN.player,
MINECRAFT_SERVER_LOGS_LOGGED_IN.log_datetime,
MINECRAFT_SERVER_REGIONS.region_x,
MINECRAFT_SERVER_REGIONS.region_z,
MINECRAFT_SERVER_LOGS_LOGGED_IN.x,
MINECRAFT_SERVER_LOGS_LOGGED_IN.y,
MINECRAFT_SERVER_LOGS_LOGGED_IN.z
FROM MINECRAFT_SERVER_LOGS_LOGGED_IN
LEFT JOIN MINECRAFT_SERVER_REGIONS ON
MINECRAFT_SERVER_REGIONS.run_date = MINECRAFT_SERVER_LOGS_LOGGED_IN.run_date AND
MINECRAFT_SERVER_REGIONS.min_x < MINECRAFT_SERVER_LOGS_LOGGED_IN.x AND
MINECRAFT_SERVER_REGIONS.max_x > MINECRAFT_SERVER_LOGS_LOGGED_IN.x AND
MINECRAFT_SERVER_REGIONS.min_y < MINECRAFT_SERVER_LOGS_LOGGED_IN.y AND
MINECRAFT_SERVER_REGIONS.max_y > MINECRAFT_SERVER_LOGS_LOGGED_IN.y AND
MINECRAFT_SERVER_REGIONS.min_z < MINECRAFT_SERVER_LOGS_LOGGED_IN.z AND
MINECRAFT_SERVER_REGIONS.max_z > MINECRAFT_SERVER_LOGS_LOGGED_IN.z
;SELECT
MINECRAFT_SERVER_SESSIONS.player,
SUM(MINECRAFT_SERVER_SESSIONS.duration) as duration
FROM
MINECRAFT_SERVER_SESSIONS
GROUP BY
MINECRAFT_SERVER_SESSIONS.source_id,
MINECRAFT_SERVER_SESSIONS.player
ORDER BY duration DESC- LOGS_MOVED_TOO_QUICKLY has coordinates, but what do they mean??? They don't look like regular coords. Maybe chunk?