} 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;
}
}
