prepare("UPDATE users SET email = ? WHERE id = ?"); $stmt->execute([$new_email, $_SESSION['user_id']]); $msg_email = "
Email mis à jour avec succès.
"; } else { $msg_email = "
Format d'email invalide.
"; } } // --- Gestion Suppression Appareil --- $msg_device = ''; if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['remove_device'])) { $device_name = trim($_POST['device_name']); if (!empty($device_name)) { // On insère une demande de type 'support' $stmt = $pdo->prepare("INSERT INTO requests (user_id, type, category, title, details, status, created_at) VALUES (?, 'support', 'suppression_appareil', ?, '{}', 'en_attente', NOW())"); $title = "Retrait appareil : " . $device_name; $stmt->execute([$_SESSION['user_id'], $title]); $msg_device = "
Demande de suppression envoyée.
"; } else { $msg_device = "
Veuillez entrer un nom d'appareil.
"; } } // Récupérer l'email actuel $stmt_u = $pdo->prepare("SELECT email FROM users WHERE id = ?"); $stmt_u->execute([$_SESSION['user_id']]); $current_user = $stmt_u->fetch(); // Calculer les jours restants $exp_date = new DateTime($_SESSION['exp_date']); $today = new DateTime(); $interval = $today->diff($exp_date); $daysLeft = $interval->format('%r%a'); // --- Pagination --- $page = isset($_GET['page']) && is_numeric($_GET['page']) ? (int)$_GET['page'] : 1; $limit = 100; $offset = ($page - 1) * $limit; // --- Filtres et Tri --- $filter = $_GET['filter'] ?? ''; $sort = $_GET['sort'] ?? 'date_desc'; $where_clauses = ["user_id = :user_id"]; $params = [':user_id' => $_SESSION['user_id']]; if ($filter === 'bug') { $where_clauses[] = "type = 'bug'"; } elseif ($filter === 'film') { $where_clauses[] = "type = 'ajout' AND category = 'film'"; } elseif ($filter === 'serie') { $where_clauses[] = "type = 'ajout' AND category = 'serie'"; } $where_sql = "WHERE " . implode(' AND ', $where_clauses); $order_sql = "ORDER BY created_at DESC"; if ($sort === 'date_asc') $order_sql = "ORDER BY created_at ASC"; if ($sort === 'alpha_asc') $order_sql = "ORDER BY title ASC"; if ($sort === 'alpha_desc') $order_sql = "ORDER BY title DESC"; // Total requests count for pagination $total_stmt = $pdo->prepare("SELECT COUNT(*) FROM requests $where_sql"); $total_stmt->execute($params); $total_requests = $total_stmt->fetchColumn(); $total_pages = ceil($total_requests / $limit); // Récupérer les demandes de l'utilisateur avec pagination $stmt = $pdo->prepare("SELECT * FROM requests $where_sql $order_sql LIMIT :limit OFFSET :offset"); $stmt->bindValue(':limit', $limit, PDO::PARAM_INT); $stmt->bindValue(':offset', $offset, PDO::PARAM_INT); foreach ($params as $key => $val) { $stmt->bindValue($key, $val); } $stmt->execute(); $requests = $stmt->fetchAll(); // // --- Logic to sort requests --- // $ongoing_requests = []; $archived_requests = []; $not_available_requests = []; $seven_days_ago = new DateTime('-7 days'); foreach ($requests as $request) { if ($request['status'] === 'pas_encore_dispo') { $not_available_requests[] = $request; } elseif (in_array($request['status'], ['traite', 'bug_regle', 'ajoute'])) { $archived_requests[] = $request; } else { $ongoing_requests[] = $request; } } // // --- Function to display a table of requests --- // function display_requests_table($requests_array, $title) { echo "

$title

"; echo '
'; if (count($requests_array) > 0) { echo ''; echo ''; echo ''; foreach($requests_array as $req) { $row_style = ''; if ($req['status'] === 'en_cours_de_traitement') { $row_style = 'style="background:rgba(91, 140, 255, 0.25)"'; } elseif (in_array($req['status'], ['ajoute', 'bug_regle', 'traite'])) { $row_style = 'style="background:rgba(54, 211, 153, 0.15)"'; } elseif ($req['status'] === 'pas_encore_dispo') { $row_style = 'style="background:rgba(255, 209, 102, 0.15)"'; } echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo '
DateTypeTitre / ChaîneStatut
' . date('d/m/Y', strtotime($req['created_at'])) . '' . ucfirst($req['type']) . ' (' . ucfirst($req['category']) . ')' . htmlspecialchars($req['title'] ?: 'N/A') . ''; echo '' . str_replace('_', ' ', ucfirst($req['status'])) . ''; if ($req['status'] === 'pas_encore_dispo') { echo '
ⓘLe film est trop récent ou n\'est pas encore disponible en bonne qualité et ou en Francais. Nous l\'ajouterons dès que possible.
'; } echo '
'; } else { echo '

Aucune demande dans cette catégorie.

'; } echo '
'; } ?> Espace Client – Streambox

Bonjour,

Déconnexion
Abonnement
0) ? $daysLeft . ' Jours restants' : 'Expiré' ?>
Expire le :
Mon mail de contact
ⓘCe mail sert à rester informé lors des mises à jour des demandes et des potentielles maintenances.
Mes appareils MaxPlayer
Besoin d'aide ?
Signaler un bug ou demander un ajout
Nouvelle demande
Global Films Séries Bugs