prepare("SELECT COUNT(*) FROM logs_telegram WHERE $whereClause");
$stmt->execute($params);
$totalLogs = $stmt->fetchColumn();
$totalPages = ceil($totalLogs / $perPage);
// Obtener logs
$stmt = $db->prepare("
SELECT l.*, u.username
FROM logs_telegram l
LEFT JOIN usuarios u ON l.usuario_id = u.id
WHERE $whereClause
ORDER BY l.fecha DESC
LIMIT $perPage OFFSET $offset
");
$stmt->execute($params);
$logs = $stmt->fetchAll();
?>
Logs Telegram - Sistema de Bots