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;">';