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