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;
}
}
}
if (get_value_session('from_db', 'is_admin') == '1') {
if (get_value_get('userid') !== FALSE) {
if (get_value_get('p') !== FALSE) {
$overview = pakketten_get_value_overview(get_value_get('userid'), get_value_get('p'), get_value_session('from_db', 'is_admin'));
} else {
$overview = pakketten_get_value_overview(get_value_get('userid'), '%', get_value_session('from_db', 'is_admin'));
}
} else {
if (get_value_get('p') !== FALSE) {
$overview = pakketten_get_value_overview('%', get_value_get('p'), get_value_session('from_db', 'is_admin'));
} else {
$overview = pakketten_get_value_overview('%', '%', get_value_session('from_db', 'is_admin'));
}
}
} else {
if (get_value_get('userid') !== FALSE && check_user_subuser(get_value_session('from_db', 'id'), get_value_get('userid'))) {
if (get_value_get('p') !== FALSE) {
$overview = pakketten_get_value_overview(get_value_get('userid'), get_value_get('p'), get_value_session('from_db', 'is_admin'));
} else {
$overview = pakketten_get_value_overview(get_value_get('userid'), '%', get_value_session('from_db', 'is_admin'));
}
} else {
if (get_value_get('p') !== FALSE) {
$overview = pakketten_get_value_overview(get_value_session('from_db', 'id'), get_value_get('p'), get_value_session('from_db', 'is_admin'));
} else {
$overview = pakketten_get_value_overview(get_value_session('from_db', 'id'), '%', get_value_session('from_db', 'is_admin'));
}
}
}
if ($overview == FALSE) {
$html .= '<br /><br />' . $lang->translate(627) . '<br /><br />';
$namefrom = $userdata['handelsnaam'];
$email = $userdata['email'];
send_email($email, $subject, $body, $mailfrom, $namefrom);
$html .= '<br /><br />' . $lang->translate(232) . '<br /><br />' . $lang->translate(237) . $new . '<br /><br />';
}
} else {
$html .= '<br /><br />' . $lang->translate(233) . '<br /><br />';
}
} else {
$html .= '<br /><br />' . $lang->translate(233) . '<br /><br />';
}
} elseif (get_value_get('type') == 'overzicht') {
$html .= '<div class="paginatitel">' . $lang->translate(32) . '</div>';
if (check_user_right(get_value_session('from_db', 'id'), 'klantoverzicht', get_value_session('from_db', 'is_admin')) != FALSE) {
if (get_value_get('id') != FALSE) {
if (check_user_subuser(get_value_session('from_db', 'id'), get_value_get('id')) != FALSE || get_value_session('from_db', 'is_admin') == '1') {
$temp = get_subusers(get_value_get('id'));
} else {
$temp = FALSE;
}
} else {
if (get_value_session('from_db', 'is_admin') == '1') {
$temp = get_subusers('0');
} else {
$temp = get_subusers(get_value_session('from_db', 'id'));
}
}
if ($temp == FALSE) {
$html .= '<br /><br /><div class="content"><p>' . $lang->translate(212) . '</p></div><br /><br />';
} else {
$html .= '<DIV class="tablestop2"><table><tr><td align="right" colspan="10"><div style="width:665px;">';
