} } 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>'; $html .= '</table></div>'; }
function pakketten_do_action_create_dns() { global $mysqli; if (!isset($mysqli) || empty($mysqli)) { create_db_connection('mysqli', 'central'); } global $mysqli; $temp = 1; if (get_value_session('from_db', 'is_admin') == 1) { $sql = 'INSERT INTO `pakketten_dns` (`max_domain`,`max_templates`) VALUES ("' . $mysqli->real_escape_string(get_value_post('domain')) . '","' . $mysqli->real_escape_string(get_value_post('templates')) . '")'; $mysqli->query($sql); $id = $mysqli->insert_id; if ($id != 0) { $sql = 'INSERT INTO `pakketten` (`type`,`user_id`,`pakket_id`) VALUES ("dns","' . $mysqli->real_escape_string(get_value_post('klant')) . '","' . $mysqli->real_escape_string($id) . '")'; $mysqli->query($sql); $id2 = $mysqli->insert_id; if ($id2 != 0) { return TRUE; } else { return FALSE; } } else { return FALSE; } } else { if (check_user_subuser(get_value_session('from_db', 'id'), get_value_post('klant'))) { $availabledomains = pakketten_get_value_size_dns(get_value_session('from_db', 'id'), 'domain') - pakketten_get_value_used_dns(get_value_session('from_db', 'id'), 'domain'); $availabletemplates = pakketten_get_value_size_dns(get_value_session('from_db', 'id'), 'template') - pakketten_get_value_used_dns(get_value_session('from_db', 'id'), 'template'); if (get_value_post('domain') < $availabledomains && get_value_post('template') < $availabletemplates) { $sql = 'INSERT INTO `pakketten_dns` (`max_domain`,`max_templates`) VALUES ("' . $mysqli->real_escape_string(get_value_post('domain')) . '","' . $mysqli->real_escape_string(get_value_post('templates')) . '")'; $mysqli->query($sql); $id = $mysqli->insert_id; if ($id != 0) { $sql = 'INSERT INTO `pakketten` (`type`,`user_id`,`pakket_id`) VALUES ("dns","' . $mysqli->real_escape_string(get_value_post('klant')) . '","' . $mysqli->real_escape_string($id) . '")'; $mysqli->query($sql); $id2 = $mysqli->insert_id; if ($id2 != 0) { return TRUE; } else { return FALSE; } } else { return FALSE; } } else { return FALSE; } } else { return FALSE; } } }