query("SELECT u.mac_amount, (SELECT SUM(mac_amount) FROM USERS WHERE user_id=u.id AND id != '". $_GET["update"] ."') as amountSum FROM USERS u WHERE u.id = '$id' ");
$fetch = $res->fetchArray();
$res = $db->query("SELECT * FROM USERS WHERE id='" . $_GET["update"] . "' AND user_id='". $_SESSION['id'] ."'");
$row = $res->fetchArray();
if(!$row['id']){
header("Location:/stores.php");
}
$id = $row["id"];
$name = $row["NAME"];
$mac_amount = $row["mac_amount"];
$username = $row["USERNAME"];
$password = $row["PASSWORD"];
$dns_fixo = $row['dns_fixo'] ?? '';
$macCount = $fetch['mac_amount'];
if($macCount != "9999999999"){
$res = $dbStores->query("SELECT COUNT(*) as count FROM ibo WHERE id_user = '$id' AND active = 1 AND expire_date > date('now')");
$count = $res->fetchArray()['count']+$fetch['amountSum']+1;
$availableMacs = $macCount - ($count + ($_POST['mac_amount'] ?? 0));
}else{
$availableMacs = 9999999999;
}
if (isset($_POST["submit"])) {
if($availableMacs < 0){
?>
exec("UPDATE USERS SET NAME='" . $_POST['name'] . "', USERNAME='" . $_POST['username'] . "', PASSWORD='$password', mac_amount = '" . $_POST['mac_amount'] . "', dns_fixo='". $dnsfixo ."' WHERE id=$id");
$db->close();
header("Location: stores.php");
}
include "includes/header.php";
if($isAdmin == 1){
if (strtotime(date("Y-m-d", strtotime($expire_date))) <= strtotime(date("Y-m-d"))) {
echo "Função bloqueada! Regularize a sua assinatura para voltar a cadastrar novas revendas
";
die;
}
}
if($macCount != "9999999999"){
echo "MAC disponíveis: ".($availableMacs - $mac_amount)."
";
}else{
echo "MAC disponíveis: Ilimitado
";
}
?>
\n\$('#confirm-delete').on('show.bs.modal', function(e) {\n \$(this).find('.btn-ok').attr('href', \$(e.relatedTarget).data('href'));\n});\n \n\r\n\r\n\r\n\n\r\n\r\n \n \n\n