} else { $html .= '<br /><br />' . $lang->translate(663) . '<br /><br />'; } } else { $html .= '<br /><br />' . $lang->translate(663) . '<br /><br />'; } } elseif (get_value_get('type') == 'bekijken' && check_user_right(get_value_session('from_db', 'id'), 'pakketbekijken', get_value_session('from_db', 'is_admin')) !== FALSE) { $pakket = pakketten_get_value_details(get_value_session('from_db', 'id'), get_value_get('id'), get_value_session('from_db', 'is_admin')); if ($pakket !== FALSE) { if (get_value_get('p') == "dns") { if (check_user_subuser(get_value_session('from_db', 'id'), $pakket['user_id'], $type = 3) !== FALSE || $pakket['user_id'] == get_value_session('from_db', 'id') || get_value_session('from_db', 'is_admin') == '1') { $pakket_name = $pakket['pakket_name']; $domain_pakket_limit = dns_get_value_pakket($pakket['pakket_id'], 'domain'); $template_pakket_limit = dns_get_value_pakket($pakket['pakket_id'], 'template'); $domain_pakket_used = dns_get_value_current_usage($pakket['pakket_id'], 'domain'); $template_pakket_used = dns_get_value_current_usage($pakket['pakket_id'], 'template'); $domain_total_limit = pakketten_get_value_size_dns($pakket['user_id'], 'domain'); $template_total_limit = pakketten_get_value_size_dns($pakket['user_id'], 'template'); $domain_total_used = pakketten_get_value_used_dns($pakket['user_id'], 'domain'); $template_total_used = pakketten_get_value_used_dns($pakket['user_id'], 'template'); $html .= '<br />'; $userdata = get_userdata($pakket['user_id']); $html .= '<p>' . $lang->translate(670) . '<b>' . $userdata['username'] . '</b><br />'; $html .= '' . $lang->translate(671) . '<br /><br /></p>'; $html .= '<div class="tablestop1"><table>'; $html .= '<tr><td>' . $lang->translate(1200) . '</td><td>' . $lang->translate(664) . '</td><td>' . $lang->translate(665) . '</td></tr>'; $html .= '<tr><td>' . $lang->translate(690) . '</td><td> - </td><td>' . $pakket_name . '</td></tr>'; $html .= '<tr><td>' . $lang->translate(666) . '</td><td>' . $domain_pakket_used . '</td><td>' . $domain_pakket_limit . '</td></tr>'; $html .= '<tr><td>' . $lang->translate(667) . '</td><td>' . $template_pakket_used . '</td><td>' . $template_pakket_limit . '</td></tr>'; $html .= '<tr><td>' . $lang->translate(668) . '</td><td>' . $domain_total_used . '</td><td>' . $domain_total_limit . '</td></tr>'; $html .= '<tr><td>' . $lang->translate(669) . '</td><td>' . $template_total_used . '</td><td>' . $template_total_limit . '</td></tr>';
function dns_do_action_recglobbew($account, $oud, $nieuw) { global $lang; global $mysqli_dns; if (!isset($mysqli_dns) || empty($mysqli_dns)) { create_db_connection('mysqli_dns', 'dns'); } global $mysqli_dns; global $mysqli; if (!isset($mysqli) || empty($mysqli)) { create_db_connection('mysqli', 'central'); } global $mysqli; $numdom = dns_get_value_current_usage($account, 'domain'); $numtem = dns_get_value_current_usage($account, 'template'); $num = 0; if ($numdom != FALSE && $numdom != 0) { $sql2 = 'SELECT records.id,records.domain_id FROM records INNER JOIN domains ON (records.domain_id = domains.id) WHERE records.name LIKE "' . $mysqli_dns->real_escape_string($oud) . '" AND records.type NOT LIKE "SOA" AND domains.account LIKE "' . $mysqli_dns->real_escape_string($account) . '"'; $query = $mysqli_dns->query($sql2); if (!isset($query) || empty($query) || $query->num_rows == "0") { } else { while ($row = $query->fetch_array(MYSQLI_ASSOC)) { $num++; $update = 'UPDATE `records` SET `name` = "' . $mysqli_dns->real_escape_string($nieuw) . '" WHERE `id` = ' . $row['id'] . ' LIMIT 1'; $mysqli_dns->query($update); $mysqli_dns->query("UPDATE `domains` SET `changed` = +1 WHERE `id` = " . $row['domain_id'] . " LIMIT 1"); } } $sql2 = 'SELECT records.id FROM records INNER JOIN domain ON (records.domain_id = domains.id) WHERE records.type LIKE "' . $mysqli_dns->real_escape_string($oud) . '" AND records.type NOT LIKE "SOA" AND domains.account LIKE "' . $mysqli_dns->real_escape_string($account) . '"'; $query = $mysqli_dns->query($sql2); if (!isset($query) || empty($query) || $query->num_rows == "0") { } else { while ($row = $query->fetch_array(MYSQLI_ASSOC)) { $num++; $update = 'UPDATE `records` SET `type` = "' . $mysqli_dns->real_escape_string($nieuw) . '" WHERE `id` = ' . $row['id'] . ' LIMIT 1'; $mysqli_dns->query($update); $mysqli_dns->query("UPDATE `domains` SET `changed` = +1 WHERE `id` = " . $row['domain_id'] . " LIMIT 1"); } } $sql2 = 'SELECT records.id FROM records INNER JOIN domains ON (records.domain_id = domains.id) WHERE records.content LIKE "' . $mysqli_dns->real_escape_string($oud) . '" AND records.type NOT LIKE "SOA" AND domains.account LIKE "' . $mysqli_dns->real_escape_string($account) . '"'; $query = $mysqli_dns->query($sql2); if (!isset($query) || empty($query) || $query->num_rows == "0") { } else { while ($row = $query->fetch_array(MYSQLI_ASSOC)) { $num++; $update = 'UPDATE `records` SET `content` = "' . $mysqli_dns->real_escape_string($nieuw) . '" WHERE `id` = ' . $row['id'] . ' LIMIT 1'; $mysqli_dns->query($update); $mysqli_dns->query("UPDATE `domains` SET `changed` = +1 WHERE `id` = " . $row['domain_id'] . " LIMIT 1"); } } $sql2 = 'SELECT records.id FROM records INNER JOIN domains ON (records.domain_id = domains.id) WHERE records.ttl LIKE "' . $mysqli_dns->real_escape_string($oud) . '" AND records.type NOT LIKE "SOA" AND domains.account LIKE "' . $mysqli_dns->real_escape_string($account) . '"'; $query = $mysqli_dns->query($sql2); if (!isset($query) || empty($query) || $query->num_rows == "0") { } else { while ($row = $query->fetch_array(MYSQLI_ASSOC)) { $num++; $update = 'UPDATE `records` SET `ttl` = "' . $mysqli_dns->real_escape_string($nieuw) . '" WHERE `id` = ' . $row['id'] . ' LIMIT 1'; $mysqli_dns->query($update); $mysqli_dns->query("UPDATE `domains` SET `changed` = +1 WHERE `id` = " . $row['domain_id'] . " LIMIT 1"); } } } if ($numtem != FALSE && $numtem != 0) { $sql2 = 'SELECT dns_templates_records.id FROM dns_templates_records INNER JOIN dns_templates ON (dns_templates_records.template_id = dns_templates.id) WHERE dns_templates_records.name LIKE "' . $mysqli->real_escape_string($oud) . '" AND dns_templates_records.type NOT LIKE "SOA" AND dns_templates.account LIKE "' . $mysqli->real_escape_string($account) . '"'; $query = $mysqli->query($sql2); if (!isset($query) || empty($query) || $query->num_rows == "0") { } else { while ($row = $query->fetch_array(MYSQLI_ASSOC)) { $num++; $update = 'UPDATE `dns_templates_records` SET `name` = "' . $mysqli->real_escape_string($nieuw) . '" WHERE `id` = ' . $row['id'] . ' LIMIT 1'; $mysqli->query($update); } } $sql2 = 'SELECT dns_templates_records.id FROM dns_templates_records INNER JOIN dns_templates ON (dns_templates_records.template_id = dns_templates.id) WHERE dns_templates_records.type LIKE "' . $mysqli->real_escape_string($oud) . '" AND dns_templates_records.type NOT LIKE "SOA" AND dns_templates.account LIKE "' . $mysqli->real_escape_string($account) . '"'; $query = $mysqli->query($sql2); if (!isset($query) || empty($query) || $query->num_rows == "0") { } else { while ($row = $query->fetch_array(MYSQLI_ASSOC)) { $num++; $update = 'UPDATE `dns_templates_records` SET `type` = "' . $mysqli->real_escape_string($nieuw) . '" WHERE `id` = ' . $row['id'] . ' LIMIT 1'; $mysqli->query($update); } } $sql2 = 'SELECT dns_templates_records.id FROM dns_templates_records INNER JOIN dns_templates ON (dns_templates_records.template_id = dns_templates.id) WHERE dns_templates_records.content LIKE "' . $mysqli->real_escape_string($oud) . '" AND dns_templates_records.type NOT LIKE "SOA" AND dns_templates.account LIKE "' . $mysqli->real_escape_string($account) . '"'; $query = $mysqli->query($sql2); if (!isset($query) || empty($query) || $query->num_rows == "0") { } else { while ($row = $query->fetch_array(MYSQLI_ASSOC)) { $num++; $update = 'UPDATE `dns_templates_records` SET `content` = "' . $mysqli->real_escape_string($nieuw) . '" WHERE `id` = ' . $row['id'] . ' LIMIT 1'; $mysqli->query($update); } } $sql2 = 'SELECT dns_templates_records.id FROM dns_templates_records INNER JOIN dns_templates ON (dns_templates_records.template_id = dns_templates.id) WHERE dns_templates_records.ttl LIKE "' . $mysqli->real_escape_string($oud) . '" AND dns_templates_records.type NOT LIKE "SOA" AND dns_templates.account LIKE "' . $mysqli->real_escape_string($account) . '"'; $query = $mysqli->query($sql2); if (!isset($query) || empty($query) || $query->num_rows == "0") { } else { while ($row = $query->fetch_array(MYSQLI_ASSOC)) { $num++; $update = 'UPDATE `dns_templates_records` SET `ttl` = "' . $mysqli->real_escape_string($nieuw) . '" WHERE `id` = ' . $row['id'] . ' LIMIT 1'; $mysqli->query($update); } } } return '<br /><br /><p>' . $num . $lang->translate(756) . '</p><br /><br />'; }
function pakketten_get_value_used_dns($userid, $typ = 'domain') { $pakketten = pakketten_get_value_overview($userid, 'dns'); $useddomains = 0; $usedtemplates = 0; if (is_array($pakketten) !== FALSE) { foreach ($pakketten as $product) { if ($product['user_id'] == $userid) { $useddomains = $useddomains + dns_get_value_current_usage($product['pakket_id'], 'domain'); $usedtemplates = $usedtemplates + dns_get_value_current_usage($product['pakket_id'], 'template'); } else { $useddomains = $useddomains + dns_get_value_pakket($product['pakket_id'], 'domain'); $usedtemplates = $usedtemplates + dns_get_value_pakket($product['pakket_id'], 'template'); } } } if ($typ == 'domain') { return $useddomains; } else { return $usedtemplates; } }