$_SESSION['user_id'], 'action' => $action, 'description' => $description, 'ip_address' => $_SERVER['REMOTE_ADDR'] ?? '', 'user_agent' => $_SERVER['HTTP_USER_AGENT'] ?? '', 'created_at' => date('Y-m-d H:i:s') ]; // Create activity log table if it doesn't exist $sql = "CREATE TABLE IF NOT EXISTS activity_logs ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT, action VARCHAR(100), description TEXT, ip_address VARCHAR(45), user_agent TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES users(id) )"; try { executeQuery($sql); insertData('activity_logs', $data); } catch (Exception $e) { error_log("Failed to log activity: " . $e->getMessage()); } } ?>