query("SELECT * FROM ibo WHERE id='" . $_GET["update"] . "'"); $row = $res->fetchArray(); if (!$row) { header("Location: users.php"); exit; } // Verifica se o usuário tem permissão para editar este registro if ($row['id_user'] != $id && $_SESSION['nivel'] == 2) { header("Location: users.php"); exit; } $id_mac = $row["id"]; $mac_address = $row["mac_address"]; $username = $row["username"]; $password = $row["password"]; $dns = $row["dns"]; $epg_url = $row["epg_url"]; $title = $row["title"]; $url = $row["url"]; $type = $row["type"]; if (isset($_POST["submit"])) { $address1 = strtoupper($_POST["mac_address"]); // Mantém o id_user original em vez de usar o ID da sessão $user_id = $row['id_user']; if ($_POST["type"] == "1") { $line = $_POST["dns"] . "/get.php?username=" . $_POST["username"] . "&password=" . $_POST["password"] . "&type=m3u_plus&output=ts"; } else { $line = $_POST["url"]; } $stmt = $db->prepare("UPDATE ibo SET mac_address = :mac_address, username = :username, password = :password, dns = :dns, epg_url = :epg_url, title = :title, url = :url, type = :type, active = '0' WHERE id = :id"); $stmt->bindValue(':mac_address', $address1, SQLITE3_TEXT); $stmt->bindValue(':username', $_POST["username"], SQLITE3_TEXT); $stmt->bindValue(':password', $_POST["password"], SQLITE3_TEXT); $stmt->bindValue(':dns', $_POST["dns"], SQLITE3_TEXT); $stmt->bindValue(':epg_url', $_POST["epg_url"], SQLITE3_TEXT); $stmt->bindValue(':title', $_POST["title"], SQLITE3_TEXT); $stmt->bindValue(':url', $line, SQLITE3_TEXT); $stmt->bindValue(':type', $_POST["type"], SQLITE3_INTEGER); $stmt->bindValue(':id', $_POST["id"], SQLITE3_INTEGER); if ($stmt->execute()) { // Atualiza a sessão se necessário if (isset($_SESSION['macs'])) { $res = $db->query("SELECT * FROM ibo WHERE id = " . $_POST["id"]); $updated_row = $res->fetchArray(); foreach ($_SESSION['macs'] as &$session_row) { if ($session_row['id'] == $_POST["id"]) { $session_row = $updated_row; break; } } } header("Location: users.php?r=atualizado"); } else { echo "Erro ao atualizar: " . $db->lastErrorMsg(); } exit; } ?>

Atualizar Usuário