Esempio n. 1
0
         $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>';
             }
         } elseif (get_value_get('p') == "stream") {
             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') {
Esempio n. 2
0
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;
        }
    }
}