CoreProtect SQL queries

Chat.sql

USE logging;

SELECT 
	DATE(FROM_UNIXTIME(co_chat.time)),
	co_user.user,
	message
FROM 
	co_chat
LEFT JOIN co_user
    ON co_user.rowid = co_chat.user
ORDER BY 
	co_chat.rowid DESC;

Sessions.sql

USE logging;

SELECT 
	FROM_UNIXTIME(co_session.time),
	co_user.user,
	action
FROM 
	co_session
LEFT JOIN co_user
    ON co_user.rowid = co_session.user
ORDER BY 
	co_session.rowid DESC;

Users.sql

USE logging;

SELECT
	rowid,
	DATE(FROM_UNIXTIME(time)),
	user
FROM
	co_user
WHERE user NOT LIKE "#%";