Server History

File: server/history.lua

Activity log and player statistics.

Functions

lua

DB.LogActivity(groupId, taskType, title, status, members, data, xpEarned)
DB.GetRecentActivities(groupId, count) → rows
DB.GetActivityStats(groupId) → { total, completed, failed, successRate }
DB.GetPlayerActivityStats(groupId, citizenid) → { tasksDone, xpEarned }

Activity Log Schema

sql

wtf_group_activity_log (
    id, group_id, task_type, title, status,
    members, data, xp_earned, completed_at
)

members: JSON array of {citizenid, name} objects
status: 'completed' or 'failed'
xp_earned: XP awarded for this activity