query("SELECT u.mac_amount, (SELECT SUM(mac_amount) FROM USERS WHERE user_id=u.id) as amountSum FROM USERS u WHERE u.id = '$id' ");
$fetch = $res->fetchArray();
$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'];
$availableMacs = $macCount - ($count + ($_POST['mac_amount'] ?? 0));
}else{
$availableMacs = 9999999999;
}
if (isset($_POST["submit"])) {
if($availableMacs < 0){
?>
querySingle("SELECT * FROM USERS WHERE USERNAME = '$username'");
if ($existingUser) {
?>
querySingle("SELECT * FROM USERS WHERE NAME = '$username'");
if ($existingUser) {
?>
exec("INSERT INTO USERS(NAME, USERNAME, PASSWORD, mac_amount, user_id, dns_fixo) VALUES('$name', '$username', '$password', '$mac_amount', '". $_SESSION['id'] ."', '$dns_fixo')");
$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
";
}else{
echo "MAC disponíveis: Ilimitado
";
}
?>
\r\n//select activecode form\r\n//var response = {};\r\n//response.val = \"op2\";\r\n//\$(\"#codemode option[data-value='\" + response.val +\"']\").attr(\"selected\",\"selected\");\r\n\r\n//hide activecode form\r\n\$('.active1').show(); \r\n\$('.active2').hide(); \r\n\r\n//Show/hide activecode select\r\n\$(document).ready(function(){\r\n \$('.type').change(function(){\r\n if(\$('.type').val() < 1) {\r\n \$('.active1').show(); \r\n \$('.active2').hide(); \r\n } else {\r\n \$('.active2').show(); \r\n \$('.active1').hide(); \r\n } \r\n });\r\n});\r\n\r\n\r\n\n \r\n \n \n\n