$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') { $pakket_name = $pakket['pakket_name']; $listeners_pakket_limit = stream_get_value_pakket($pakket['pakket_id'], 'listeners'); $listeners_pakket_used = stream_get_value_current_usage($pakket['pakket_id'], 'listeners'); $listeners_total_limit = pakketten_get_value_size_stream($pakket['user_id'], 'listeners'); $listeners_total_used = pakketten_get_value_used_stream($pakket['user_id'], 'listeners'); $html .= '<br /><br />'; $userdata = get_userdata($pakket['user_id']); $html .= '' . $lang->translate(670) . $userdata['username'] . '<br />'; $html .= '' . $lang->translate(682) . '<br /><br />'; $html .= '<table border="1">'; $html .= '<tr><td></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(680) . '</td><td>' . $listeners_pakket_used . '</td><td>' . $listeners_pakket_limit . '</td></tr>'; $html .= '<tr><td>' . $lang->translate(681) . '</td><td>' . $listeners_total_used . '</td><td>' . $listeners_total_limit . '</td></tr>'; $html .= '</table>'; } } else { $html .= '<br /><br />' . $lang->translate(663) . '<br /><br />'; } } else {
function stream_do_action_toevoegen($account, $admin = 2) { global $lang; global $stream_bitrates; global $stream_host_poorten; global $mysqli; if (!isset($mysqli) || empty($mysqli)) { create_db_connection('mysqli', 'central'); } global $mysqli; $bitrate = FALSE; $host = FALSE; $poort = FALSE; $admin_user = FALSE; $admin_pass = FALSE; $name = FALSE; $max_listeners = FALSE; foreach ($stream_bitrates as $type) { if (get_value_post('bitrate') == $type) { $bitrate = $type; } } $post_port = get_value_post('poort'); if ($post_port !== FALSE) { $post_port2 = explode(':', $post_port); foreach ($stream_host_poorten as $hostname => $ports) { if ($post_port2[0] == $hostname) { foreach ($ports as $port) { if ($post_port2[1] == $port) { $sql = 'SELECT * FROM `stream_streams` WHERE `host` LIKE "' . $mysqli->real_escape_string($hostname) . '" AND `poort` LIKE "' . $mysqli->real_escape_string($port) . '" LIMIT 1'; $query = $mysqli->query($sql); if (!isset($query) || empty($query) || $query->num_rows == "0") { $poort = $port; $host = $hostname; } } } } } } $admin_user = get_value_post('admin_user'); $admin_pass = get_value_post('admin_pass'); $name = get_value_post('name'); $max_listeners = get_value_post('max_listeners'); $genre = get_value_post('genre'); $description = get_value_post('description'); $url = get_value_post('url'); $source_pass = get_value_post('source_pass'); $relay_pass = get_value_post('relay_pass'); $mountpoint = get_value_post('mountpoint'); $master_server = get_value_post('master_server'); $master_port = get_value_post('master_port'); $master_user = get_value_post('master_user'); $master_pass = get_value_post('master_pass'); $ftp_pass = get_value_post('ftp_pass'); $streamtype = get_value_post('streamtype'); $shoutcastkey = get_value_post('shoutcastkey'); if ($bitrate === FALSE || $host === FALSE || $poort === FALSE || $admin_user === FALSE || $admin_pass === FALSE || $name === FALSE || $max_listeners === FALSE) { $html = '<br /><br />' . $lang->translate(929) . '<br /><br />'; } else { $availablelisteners = pakketten_get_value_size_stream(get_value_session('from_db', 'id'), 'listeners') - pakketten_get_value_used_stream(get_value_session('from_db', 'id'), 'listeners'); if ($max_listeners < $availablelisteners) { $sql2 = 'INSERT INTO `stream_streams` (`poort`,`admin_user`,`admin_pass`,`max_listeners`,`bitrate`,`account`,`name`,`host`,`genre`,`description`,`url`,`source_pass`,`relay_pass`,`mountpoint`,`master_server`,`master_port`,`master_user`,`master_pass`,`changed2`,`changed`,`type`,`shoutcastkey`) VALUES ("' . $mysqli->real_escape_string($poort) . '","' . $mysqli->real_escape_string($admin_user) . '","' . $mysqli->real_escape_string($admin_pass) . '","' . $mysqli->real_escape_string($max_listeners) . '","' . $mysqli->real_escape_string($bitrate) . '","' . $mysqli->real_escape_string($account) . '","' . $mysqli->real_escape_string($name) . '","' . $mysqli->real_escape_string($host) . '","' . $mysqli->real_escape_string($genre) . '","' . $mysqli->real_escape_string($description) . '","' . $mysqli->real_escape_string($url) . '","' . $mysqli->real_escape_string($source_pass) . '","' . $mysqli->real_escape_string($relay_pass) . '","' . $mysqli->real_escape_string($mountpoint) . '","' . $mysqli->real_escape_string($master_server) . '","' . $mysqli->real_escape_string($master_port) . '","' . $mysqli->real_escape_string($master_user) . '","' . $mysqli->real_escape_string($master_pass) . '","1","1","' . $mysqli->real_escape_string($streamtype) . '","' . $mysqli->real_escape_string($shoutcastkey) . '")'; $mysqli->query($sql2); $id = $mysqli->insert_id; if (get_value_post('ftp_pass') != FALSE && get_value_post('ftp_pass') != '') { $sql = 'INSERT INTO `stream_ftpuser` (`userid`,`passwd`,`homedir`) VALUES ("stream' . $id . '","' . $mysqli->real_escape_string(get_value_post('ftp_pass')) . '","/home/icecast/stream' . $id . '")'; $mysqli->query($sql); $sql = 'INSERT INTO `stream_ftpquotalimits` (`name`,`limit_type`) VALUES ("stream' . $id . '","hard")'; $mysqli->query($sql); } $html = '<br /><br />' . $lang->translate(930) . '<br /><br />'; } else { $html = '<br /><br />' . $lang->translate(931) . '<br /><br />'; } } return $html; }
function pakketten_do_action_create_stream() { 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_stream` (`max_listeners`) VALUES ("' . $mysqli->real_escape_string(get_value_post('listeners')) . '")'; $mysqli->query($sql); $id = $mysqli->insert_id; if ($id != 0) { $sql = 'INSERT INTO `pakketten` (`type`,`user_id`,`pakket_id`) VALUES ("stream","' . $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'))) { $availablelisteners = pakketten_get_value_size_stream(get_value_session('from_db', 'id'), 'listeners') - pakketten_get_value_used_stream(get_value_session('from_db', 'id'), 'listeners'); if (get_value_post('listeners') < $availablelisteners) { $sql = 'INSERT INTO `pakketten_stream` (`max_listeners`) VALUES ("' . $mysqli->real_escape_string(get_value_post('listeners')) . '")'; $mysqli->query($sql); $id = $mysqli->insert_id; if ($id != 0) { $sql = 'INSERT INTO `pakketten` (`type`,`user_id`,`pakket_id`) VALUES ("stream","' . $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; } } }