function page_contact()
{
// Add departments
global $_CLASS;
$_CLASS['core_user']->user_setup();
$_CLASS['core_user']->add_lang();
$this->error = '';
$this->preview = !empty($_POST['preview']);
if ($this->preview || !empty($_POST['contact'])) {
$this->data['MESSAGE'] = trim(get_variable('message', 'POST', ''));
$this->data['NAME'] = get_variable('sender_name', 'POST', '');
$this->data['EMAIL'] = get_variable('sender_email', 'POST', '');
foreach ($this->data as $field => $value) {
if (!$value) {
$this->error .= $_CLASS['core_user']->lang['ERROR_' . $field] . '<br />';
unset($field, $value, $lang);
} elseif ($field == 'EMAIL' && !check_email($value)) {
$this->error .= $_CLASS['core_user']->lang['BAD_EMAIL'] . '<br />';
}
}
if (!$this->error) {
$this->send_feedback();
}
} else {
$this->data['NAME'] = $_CLASS['core_user']->is_user ? $_CLASS['core_user']->data['username'] : '';
$this->data['EMAIL'] = $_CLASS['core_user']->is_user ? $_CLASS['core_user']->data['user_email'] : '';
$this->data['MESSAGE'] = '';
}
$_CLASS['core_template']->assign_array(array('ERROR' => $this->error, 'MESSAGE' => $this->data['MESSAGE'], 'ACTION' => generate_link($_CLASS['core_display']->page['page_name']), 'SENDER_EMAIL' => $this->data['EMAIL'], 'SENDER_NAME' => $this->data['NAME']));
$_CLASS['core_template']->display('modules/contact/index.html');
}
function add_event()
{
global $_CLASS;
$data_array = array('calender_title' => mb_strtolower(htmlentities(get_variable('title', 'POST', ''), ENT_QUOTES, 'UTF-8')), 'calender_text' => strip_tags(get_variable('description', 'POST', false)), 'calender_notes' => strip_tags(get_variable('note', 'POST', false)), 'calender_starts' => get_variable('start', 'POST', false), 'calender_expires' => get_variable('end', 'POST', false));
$error = array();
if (empty($data_array['calender_title'])) {
$error[] = $_CLASS['core_user']->get_lang('NO_TITLE');
}
$start_time = strtotime($data_array['calender_starts']);
if (!$start_time || $start_time === -1) {
$error[] = $_CLASS['core_user']->get_lang('ERROR_START_TIME');
}
$end_time = strtotime($data_array['calender_expires']);
if (!$end_time || $end_time === -1) {
$error[] = $_CLASS['core_user']->get_lang('ERROR_END_TIME');
}
if (empty($error) && $start_time > $end_time) {
$error[] = $_CLASS['core_user']->get_lang('ERROR_');
}
if (!empty($error)) {
return false;
}
//$duration = $start_time - $end_time;
//$start_time = $date = implode(''. explode(':', date('H:i', $start_time)));;
$data_array['calender_starts'] = $_CLASS['core_user']->time_convert($start_time, 'gmt');
$data_array['calender_expires'] = $_CLASS['core_user']->time_convert($end_time, 'gmt');
$_CLASS['core_db']->query('INSERT INTO ' . CALENDER_TABLE . ' ' . $_CLASS['core_db']->sql_build_array('INSERT', $data_array));
$data_array['calender_id'] = $_CLASS['core_db']->insert_id(CALENDER_TABLE, 'calender_id');
return $data_array;
}
function merge($width, $height)
{
$array_variable = get_variable();
$bg = $array_variable[0];
$over = $array_variable[1];
$outputFile = $array_variable[2];
$result = $array_variable[3];
$path_to_save = $array_variable[4];
$n = $array_variable[5];
$tmp_img = $path_to_save . "/tmp_" . $n . ".png";
// $result_jpg_compressed = $path_to_save.'/'.$n.'.JPG';
// $base_image = imagecreatefrompng($bg);
jpg2png($bg, $outputFile);
$base_image = imagecreatefrompng($outputFile);
$top_image = imagecreatefrompng($over);
// $merged_image = $result;
imagesavealpha($top_image, true);
imagealphablending($top_image, true);
imagecopy($base_image, $top_image, 0, 0, 0, 0, $width, $height);
imagepng($base_image, $result);
// rename to temp for compression
rename($result, $path_to_save . "/tmp_" . $n . ".png");
// compress IMG
$img = imagecreatefrompng($tmp_img);
// imagejpeg($img,$result_jpg_compressed,75);
imagejpeg($img, $result, 75);
unlink($tmp_img);
unlink($tmp_img);
// if necessery !!!!!!!!!!!!!!!!!!!
unlink($outputFile);
unlink($over);
}
function get_userdata($data)
{
if (isset($_SESSION[get_variable("prfx") . "_" . $data])) {
return $_SESSION[get_variable("prfx") . "_" . $data];
}
return "No user";
}
function switchserver_main()
{
global $argc, $argv;
global $gbl, $sgbl, $login, $ghtml;
//sleep(60);
initProgram("admin");
if ($argc === 1) {
print "Usage: {$argv['0']} --class= --name= --v-syncserver= \n";
exit;
}
try {
$opt = parse_opt($argv);
$param = get_variable($opt);
dprintr($param);
$class = $opt['class'];
$name = $opt['name'];
if (lx_core_lock("{$class}-{$name}.switchserver")) {
exit;
}
$object = new $class(null, 'localhost', $name);
$object->get();
if ($object->dbaction === 'add') {
throw new lxException("no_object", '', '');
exit;
}
if (!$object->syncserver) {
print "No_synserver...\n";
throw new lxException("no_syncserver", '', '');
exit;
}
if ($param['syncserver'] === $object->syncserver) {
print "No Change...\n";
throw new lxException("no_change", '', '');
exit;
}
$driverapp_old = $gbl->getSyncClass('localhost', $object->syncserver, $object->get__table());
$driverapp_new = $gbl->getSyncClass('localhost', $param['syncserver'], $object->get__table());
if ($driverapp_new !== $driverapp_old) {
//throw new lxException ("the_drivers_are_different_in_two_servers", '', '');
}
$object->doupdateSwitchserver($param);
} catch (exception $e) {
print $e->getMessage();
/// hcak ahck... Chnage only the olddelete variable which is the mutex used for locking in the process of switch. The problem is we want to totally bail out if the switchserver fails. The corect way would be save after reverting the syncserve to the old value, but that's a bit risky. So we just use a hack to change only the olddeleteflag; Not a real hack.. This is the better way.
$message = "{$e->getMessage()}";
write_to_object($object, $message, $param['syncserver']);
$fullmesage = "Switch of {$object->get__table()}:{$object->nname} to {$object->syncserver} failed due to {$e->getMessage()}";
log_switch($fullmesage);
mail($login->contactemail, "Switch Failed:", "{$fullmesage}\n");
print "\n";
exit;
}
mail($login->contactemail, "Switch Succeeded", "Switch Succeeded {$object->get__table()}:{$object->nname} to {$param['syncserver']}\n");
}
function do_print($row_in)
{
global $today, $today_ref, $line_ctr, $units_str, $severities;
if (empty($today)) {
$today_ref = date("z", $row_in['problemstart']);
$today = substr(format_date($row_in['problemstart']), 0, 5);
} else {
if (!($today_ref == date("z", $row_in['problemstart']))) {
// date change?
$today_ref = date("z", $row_in['problemstart']);
$today = substr(format_date($row_in['problemstart']), 0, 5);
}
}
$def_city = get_variable('def_city');
$def_st = get_variable('def_st');
print "<TR CLASS= ''>\n";
print "<TD>{$today}</TD>\n";
// Date -
$problemstart = format_date($row_in['problemstart']);
$problemstart_sh = short_ts($problemstart);
print "<TD onMouseover=\"Tip('{$problemstart}');\" onmouseout='UnTip();'>{$problemstart_sh}</TD>\n";
// start
$problemend = format_date($row_in['problemend']);
$problemend_sh = short_ts($problemend);
print "<TD onMouseover=\"Tip('{$problemend}');\" onmouseout='UnTip();'>{$problemend_sh}</TD>\n";
// end
$elapsed = my_date_diff($row_in['problemstart'], $row_in['problemend']);
print "<TD>{$elapsed}</TD>\n";
// Ending time
print "<TD ALIGN='center'>{$severities[$row_in['severity']]}</TD>\n";
$scope = $row_in['tick_scope'];
$scope_sh = shorten($row_in['tick_scope'], 20);
print "<TD onMouseover=\"Tip('{$scope}');\" onmouseout='UnTip();'>{$scope_sh}</TD>\n";
// Call type
$comment = $row_in['comments'];
$short_comment = shorten($row_in['comments'], 50);
print "<TD onMouseover=\"Tip('{$comment}');\" onMouseout='UnTip();'>{$short_comment}</TD>\n";
// Comments/Disposition
$facility = $row_in['facy_name'];
$facility_sh = shorten($row_in['facy_name'], 16);
print "<TD onMouseover=\"Tip('{$facility}');\" onmouseout='UnTip();'>{$facility_sh}</TD>\n";
// Facility
$city = $row_in['tick_city'] == $def_city ? "" : ", {$row_in['tick_city']}";
$st = $row_in['tick_state'] == $def_st ? "" : ", {$row_in['tick_state']}";
$addr = "{$row_in['tick_street']}{$city}{$st}";
$addr_sh = shorten($row_in['tick_street'] . $city . $st, 20);
print "<TD onMouseover=\"Tip('{$addr}');\" onMouseout='UnTip();'>{$addr_sh}</TD>\n";
// Street addr
print "<TD>{$units_str}</TD>\n";
// Units responding
print "</TR>\n\n";
$line_ctr++;
}
function admin_save($data)
{
global $_CLASS, $_CORE_CONFIG;
foreach ($data as $section => $option) {
foreach ($option as $db_name => $data_op) {
$value = get_variable($data_op['post_name'], 'POST', false);
if ($value != $_CORE_CONFIG[$section][$db_name]) {
set_core_config($section, $db_name, $value, false);
}
}
}
$_CLASS['core_cache']->destroy('core_config');
}
function get_current_test()
{
// 3/16/09, 7/25/09
$delay = 1;
// minimum time in minutes between queries - 7/25/09
$when = get_variable('_aprs_time');
// misnomer acknowledged
if (time() < $when) {
return;
} else {
$next = time() + $delay * 60;
$query = "UPDATE `{$GLOBALS['mysql_prefix']}settings` SET `value`='{$next}' WHERE `name`='_aprs_time'";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
}
$aprs = $instam = $locatea = $gtrack = $glat = FALSE;
// 3/22/09
$query = "SELECT `id`, `aprs`, `instam`, `locatea`, `gtrack`, `glat` FROM `{$GLOBALS['mysql_prefix']}responder`WHERE ((`aprs` = 1) OR (`instam` = 1) OR (`locatea` = 1) OR (`gtrack` = 1) OR (`glat` = 1))";
$result = mysql_query($query) or do_error($query, ' mysql error=', mysql_error(), basename(__FILE__), __LINE__);
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
if ($row['aprs'] == 1) {
$aprs = TRUE;
}
if ($row['instam'] == 1) {
$instam = TRUE;
}
if ($row['locatea'] == 1) {
$locatea = TRUE;
}
//7/29/09
if ($row['gtrack'] == 1) {
$gtrack = TRUE;
}
//7/29/09
if ($row['glat'] == 1) {
$glat = TRUE;
}
//7/29/09
}
// end while ()
unset($result);
if ($glat) {
$glat_func = do_glat_test();
}
print $glat_func;
$result_code = "Get Current Successful";
return $result_code;
}
function get_butts($ticket_id, $unit_id)
{
global $patient;
$win_height = get_variable('map_height') + 120;
$win_width = get_variable('map_width') + 10;
if ($_SESSION['internet']) {
print "<INPUT TYPE='button' CLASS = 'btn_smaller' VALUE = 'Map' onClick = \"var popWindow = window.open('map_popup.php?id={$ticket_id}', 'PopWindow', 'resizable=1, scrollbars, height={$win_height}, width={$win_width}, left=250,top=50,screenX=250,screenY=50'); popWindow.focus();\" />\n";
// 7/3/10
}
if (can_edit()) {
// 5/23/11
print "<BR /><INPUT TYPE='button' CLASS = 'btn_smaller' VALUE = 'New' onClick = \"var newWindow = window.open('add.php?mode=1', 'addWindow', 'resizable=1, scrollbars, height=640, width=800, left=100,top=100,screenX=100,screenY=100'); newWindow.focus();\" />\n";
// 8/9/10
print "<BR /><INPUT TYPE='button' CLASS = 'btn_smaller' VALUE = 'Edit' onClick = \"var newWindow = window.open('edit_nm.php?mode=1&id={$ticket_id}', 'editWindow', 'resizable=1, scrollbars, height=600, width=600, left=100,top=100,screenX=100,screenY=100'); newWindow.focus();\" />\n";
// 2/1/10
if (!is_closed($ticket_id)) {
// 10/5/09
print "<BR /><INPUT TYPE='button' CLASS = 'btn_smaller' VALUE = 'Close' onClick = \"var mailWindow = window.open('close_in.php?ticket_id={$ticket_id}', 'mailWindow', 'resizable=1, scrollbars, height=480, width=700, left=100,top=100,screenX=100,screenY=100'); mailWindow.focus();\" />\n";
// 8/20/09
}
}
// end if ($can_edit())
if (is_administrator() || is_super() || is_unit()) {
if (!is_closed($ticket_id)) {
print "<BR /><INPUT TYPE='button' CLASS = 'btn_smaller' VALUE = 'Action' onClick = \"var actWindow = window.open('action_w.php?mode=1&ticket_id={$ticket_id}', 'ActWindow', 'resizable=1, scrollbars, height=480, width=900, left=250,top=50,screenX=250,screenY=50'); ActWindow.focus();\" />\n";
// 7/3/10
print "<BR /><INPUT TYPE='button' CLASS = 'btn_smaller' VALUE = '{$patient}' onClick = \"var patWindow = window.open('patient_w.php?mode=1&ticket_id={$ticket_id}', 'patWindow', 'resizable=1, scrollbars, height=480,width=720, left=250,top=50,screenX=250,screenY=50'); patWindow.focus();\" />\n";
// 7/3/10
}
print "<BR /><INPUT TYPE='button' CLASS = 'btn_smaller' VALUE = 'Notify' onClick = \"var notWindow = window.open('config.php?mode=1&func=notify&id={$ticket_id}', 'NotWindow', 'resizable=1, scrollbars, height=400, width=600, left=250,top=50,screenX=250,screenY=50'); notWindow.focus();\" />\n";
// 7/3/10
}
print "<BR /><INPUT TYPE='button' CLASS = 'btn_smaller' VALUE = 'Note' onClick = \"var noteWindow = window.open('add_note.php?ticket_id={$ticket_id}', 'mailWindow', 'resizable=1, scrollbars, height=240, width=600, left=100,top=100,screenX=100,screenY=100'); noteWindow.focus();\" />\n";
// 10/8/08
// print "<BR /><INPUT TYPE='button' CLASS = 'btn_smaller' VALUE = 'Print' onClick='main.php?print=true&id=$ticket_id;'>\n ";
print "<BR /><INPUT TYPE='button' CLASS = 'btn_smaller' VALUE = 'E-mail' onClick = \"var mailWindow = window.open('mail.php?ticket_id={$ticket_id}', 'mailWindow', 'resizable=1, scrollbars, height=600, width=600, left=100,top=100,screenX=100,screenY=100'); mailWindow.focus();\" />\n";
// 2/1/10
print "<BR /><INPUT TYPE='button' CLASS = 'btn_smaller' VALUE = 'Dispatch' onClick = \"var dispWindow = window.open('routes_nm.php?frm_mode=1&ticket_id={$ticket_id}', 'dispWindow', 'resizable=1, scrollbars, height=480, width=" . round(0.8 * $_SESSION['scr_width']) . ", left=100,top=100,screenX=100,screenY=100'); dispWindow.focus();\" />\n";
// 2/1/10
}
function add_event()
{
global $_CLASS;
$data_array = array('title' => get_variable('title', 'POST', false), 'description' => get_variable('description', 'POST', false), 'note' => get_variable('note', 'POST', false), 'start_time' => get_variable('start', 'POST', false), 'end_time' => get_variable('end', 'POST', false), 'recur' => false);
$error = '';
if (($start_time = strtotime($data_array['start_time'])) === -1) {
$error .= $_CLASS['core_user']->get_lang('ERROR_START_TIME') . '<br />';
}
if (($end_time = strtotime($data_array['end_time'])) === -1) {
$error .= $_CLASS['core_user']->get_lang('ERROR_END_TIME') . '<br />';
}
if (!$error && $start_time > $end_time) {
$error .= $_CLASS['core_user']->get_lang('ERROR_') . '<br />';
}
if (!$error) {
//$duration = $start_time - $end_time;
//$start_time = $date = implode(''. explode(':', date('H:i', $start_time)));;
$data_array['start_time'] = $data_array['start_date'] = $start_time;
$data_array['end_time'] = $data_array['end_date'] = $end_time;
$_CLASS['core_db']->sql_query('INSERT INTO cms_calender ' . $_CLASS['core_db']->sql_build_array('INSERT', $data_array));
}
}
function do_login($login_options, $template)
{
global $_CLASS, $_CORE_CONFIG;
$user_name = !empty($_SERVER['PHP_AUTH_USER']) ? $_SERVER['PHP_AUTH_USER'] : getenv('PHP_AUTH_USER');
$user_password = !empty($_SERVER['PHP_AUTH_PW']) ? $_SERVER['PHP_AUTH_PW'] : getenv('PHP_AUTH_PW');
//list($user_name, $user_password) = explode(':', base64_decode(substr($_SERVER['HTTP_AUTHORIZATION'], 6)));
$error = '';
$login_array = array('redirect' => false, 'explain' => false, 'success' => '', 'admin_login' => false, 'full_login' => true, 'full_screen' => false);
if (is_array($login_options)) {
$login_array = array_merge($login_array, $login_options);
}
if ($user_name || $user_password) {
if (!$user_name || !$user_password) {
$error = 'INCOMPLETE_LOGIN_INFO';
}
if (!$error) {
$result = $this->user_auth($user_name, $user_password);
if (is_numeric($result)) {
$_CLASS['core_user']->login($result, $login_array['admin_login'], false);
$login_array['redirect'] = generate_link(get_variable('redirect', 'POST', $login_array['redirect']), array('admin' => $data['admin_login']));
$_CLASS['core_display']->meta_refresh(5, $login_array['redirect']);
$message = ($login_array['success'] ? $_CLASS['core_user']->get_lang($login_array['success']) : $_CLASS['core_user']->lang['LOGIN_REDIRECT']) . '<br /><br />' . sprintf($_CLASS['core_user']->lang['RETURN_PAGE'], '<a href="' . $login_array['redirect'] . '">', '</a> ');
trigger_error($message);
}
$error = is_string($result) ? $result : 'LOGIN_ERROR';
}
}
if (!$login_array['redirect']) {
$login_array['redirect'] = htmlspecialchars($_CLASS['core_user']->url);
}
// better realm needed, logout support needed
// Random realm for spoofers ?
header('WWW-Authenticate: Basic realm="Site Login"');
header('HTTP/1.0 401 Unauthorized');
//echo $error
}
// -------------------------------------------------------------
if (!defined('VIPERAL') || VIPERAL != 'Admin') {
die;
}
// Some often used variables
$safe_mode = @ini_get('safe_mode') || @strtolower(ini_get('safe_mode')) == 'on' ? true : false;
$file_uploads = @ini_get('file_uploads') || strtolower(@ini_get('file_uploads')) == 'on' ? true : false;
$data = array('block_title' => 'Forum Administration', 'block_position' => BLOCK_LEFT, 'block_file' => 'block-Admin_Forums.php');
$_CLASS['core_blocks']->add_block($data);
load_class($site_file_root . 'includes/forums/auth.php', 'auth');
require_once $site_file_root . 'includes/forums/functions.php';
require_once $site_file_root . 'includes/forums/functions_admin.php';
$_CLASS['core_user']->add_lang('admin', 'Forums');
//$_CLASS['core_user']->add_img(false, 'Forums');
$_CLASS['auth']->acl($_CLASS['core_user']->data);
$file = get_variable('file', 'REQUEST', 'main');
if (file_exists($site_file_root . 'includes/forums/admin/' . $file . '.php')) {
require $site_file_root . 'includes/forums/admin/' . $file . '.php';
} else {
require $site_file_root . 'includes/forums/admin/main.php';
}
// -----------------------------
// Functions
function adm_page_header($sub_title, $meta = '', $table_html = true)
{
global $config, $db, $_CLASS;
$_CLASS['core_display']->display_header();
echo $_CLASS['core_display']->theme->table_open;
if ($table_html) {
?>
<a name="top"></a>
function start()
{
global $_CLASS, $_CORE_CONFIG, $SID, $mod;
$session_id = get_variable($_CORE_CONFIG['server']['cookie_name'] . '_sid', 'COOKIE');
$session_id_url = get_variable('sid', 'GET');
if ($session_id_url && (!$session_id || $session_id !== $session_id_url)) {
$session_id = $session_id_url;
} elseif (!defined('NEED_SID')) {
$this->need_sid = false;
}
if ($session_id) {
$sql = 'SELECT u.*, s.*
FROM ' . CORE_SESSIONS_TABLE . ' s, ' . CORE_USERS_TABLE . " u\n\t\t\t\tWHERE s.session_id = '" . $_CLASS['core_db']->escape($session_id) . "'\n\t\t\t\t\tAND u.user_id = s.session_user_id";
$result = $_CLASS['core_db']->query($sql);
$this->data = $_CLASS['core_db']->fetch_row_assoc($result);
$_CLASS['core_db']->free_result($result);
if (isset($this->data['user_id']) && ($this->data['user_id'] == ANONYMOUS || $this->data['user_status'] == STATUS_ACTIVE)) {
$valid = true;
if ($this->data['session_browser'] !== $this->browser) {
$valid = false;
}
if ($valid && $_CORE_CONFIG['server']['ip_check']) {
$check_ip = implode('.', explode('.', $this->data['session_ip'], $_CORE_CONFIG['server']['ip_check']));
if ($check_ip !== substr($this->ip, 0, strlen($check_ip))) {
$valid = false;
}
}
if ($valid) {
// Set session update a minute or so after last update or if page changes
if ($this->time - $this->data['session_time'] > 60 || $this->data['session_url'] !== $this->url) {
$this->save_session = true;
}
$this->data['session_data'] = $this->data['session_data'] ? unserialize($this->data['session_data']) : array();
$this->data['user_data'] = $this->data['user_data'] ? unserialize($this->data['user_data']) : array();
load_class(false, 'core_auth', 'auth_db');
$this->is_user = $this->data['user_type'] == USER_NORMAL;
$this->is_bot = $this->data['user_type'] == USER_BOT;
$this->is_admin = $this->data['session_admin'] == ADMIN_IS_ADMIN;
check_maintance_status();
if ($this->is_bot) {
$this->need_sid = false;
}
$this->autologin_code = $this->data['session_autologin'];
$this->load = check_load_status();
$this->sid_link = 'sid=' . $this->data['session_id'];
return true;
}
}
$this->data = array();
}
$user_id = ANONYMOUS;
$ali = get_variable($_CORE_CONFIG['server']['cookie_name'] . '_ali', 'COOKIE', false, 'int');
$alc = get_variable($_CORE_CONFIG['server']['cookie_name'] . '_alc', 'COOKIE');
if ($ali && $alc) {
if ($id = $this->autologin_retrieve($ali, $alc)) {
$user_id = $id;
}
}
check_maintance_status();
$this->load = check_load_status();
return $this->login($user_id);
}
if (substr($path, -1) != '/') {
$path .= '/';
}
$path = str_replace('install/', '', $path);
$domain = empty($_SERVER['SERVER_NAME']) ? $_SERVER['HTTP_HOST'] : $_SERVER['SERVER_NAME'];
$_CLASS['core_template']->assign_array(array('site_name' => 'New CMS Site', 'site_domain' => $domain, 'site_path' => $path, 'site_port' => $_SERVER['SERVER_PORT'] == 80 ? '' : $_SERVER['SERVER_PORT'], 'cookie_domain' => $domain, 'cookie_path' => $path, 'cookie_name' => 'cms', 'username' => '', 'password' => '', 'password_confirm' => '', 'email' => '', 'email_confirm' => '', 'error' => empty($error) ? false : implode('<br/>', $error), 'config_content' => $config_data));
$_CLASS['core_template']->display('installer/stage3.html');
script_close();
}
}
}
if ($stage === 2) {
if (isset($_POST['test']) && empty($error)) {
$error[] = 'Database Setting Perfect :-)';
}
$_CLASS['core_template']->assign_array(array('database_options' => $database_options, 'error' => empty($error) ? false : implode('<br/>', $error), 'server' => isset($site_db['server']) ? $site_db['server'] : 'localhost', 'port' => isset($site_db['port']) ? $site_db['port'] : '', 'database' => isset($site_db['database']) ? $site_db['database'] : '', 'username' => isset($site_db['username']) ? $site_db['username'] : '', 'password' => isset($site_db['password']) ? $site_db['password'] : '', 'file' => isset($site_db['file']) ? $site_db['file'] : '', 'table_prefix' => get_variable('table_prefix', 'POST', 'cms_'), 'user_prefix' => get_variable('user_prefix', 'POST', 'cms_')));
$_CLASS['core_template']->display('installer/stage2.html');
script_close();
}
if ($stage === 1) {
$gd_info = gd_info();
$continue = true;
if (!($compatible = version_compare(PHP_VERSION, '4.2.0', '>='))) {
$continue = false;
}
$_CLASS['core_template']->assign_array(array('error' => false, 'magic_quotes_gpc' => (bool) ini_get('magic_quotes_gpc') === false, 'output_buffering' => (int) ini_get('output_buffering') === 0, 'register_globals' => (bool) ini_get('register_globals') === false, 'safe_mode' => (bool) ini_get('safe_mode') === false, 'php_version' => PHP_VERSION, 'workable_Version' => $compatible, 'recommended_Version' => version_compare(PHP_VERSION, '4.3.0', '>='), 'mbstring' => extension_loaded('mbstring'), 'zlib' => extension_loaded('zlib'), 'gd' => extension_loaded('gd'), 'gd_version' => $gd_info['GD Version'], 'continue' => $continue));
$_CLASS['core_template']->display('installer/stage1.html');
script_close();
}
if (!$stage) {
$_CLASS['core_template']->display('installer/agreement.html');
and open the template in the editor.
-->
<?php
include_once 'function.php';
get_header();
if (isset($_GET["logout"])) {
logout();
}
?>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title><?php
out(get_variable("sitename"));
?>
</title>
<meta name="viewport" content="width=device-width" />
<link rel="stylesheet" href="style/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="style/ihover.css">
<link rel="stylesheet" href="style/bootstrap/css/bootstrap-theme.min.css">
<link rel="stylesheet" href="style/style.css">
<script src="js/jquery.min.js"></script>
<script src="js/jquery-ui/jquery-ui.js"></script>
<script src="style/bootstrap/js/bootstrap.min.js"></script>
<link rel="apple-touch-icon" sizes="57x57" href="image/apple-icon-57x57.png">
<link rel="apple-touch-icon" sizes="60x60" href="image/apple-icon-60x60.png">
<?php
/*
3/18/09 added direcs
3/22/09 remove terrain, add version settings update
7/28/10 Added inclusion of startup.inc.php for checking of network status and setting of file name variables to support no-maps versions of scripts.
3/15/11 changed stylesheet.php to stylesheet.php
*/
error_reporting(E_ALL);
// 10/1/08
@session_start();
require_once $_SESSION['fip'];
//7/28/10
$old_version = get_variable('_version');
$from_version = "2.10 D beta";
//$from_version = "2.10 D betaZ";
$this_version = "2.10 E beta";
if (!(trim($old_version) == trim($from_version))) {
die("This script upgrades *only* version '{$from_version}' - but has detected version '{$old_version}' in database '{$mysql_db}'.\n<br />\n<br />Please correct.");
}
// 3/18/09
$query = "ALTER TABLE `{$GLOBALS['mysql_prefix']}responder` ADD `direcs` TINYINT( 2 ) NOT NULL DEFAULT '1' COMMENT '0=>no directions, 1=> yes' AFTER `mobile` ;";
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), basename(__FILE__), __LINE__);
$query = "ALTER TABLE `{$GLOBALS['mysql_prefix']}responder` ADD `instam` TINYINT( 2 ) NOT NULL DEFAULT '0' COMMENT 'instamapper' AFTER `aprs` ;";
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), basename(__FILE__), __LINE__);
$query = "UPDATE `{$GLOBALS['mysql_prefix']}settings` SET `name` = 'auto_poll' WHERE `settings`.`name` ='aprs_poll' LIMIT 1 ;";
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), basename(__FILE__), __LINE__);
$query = "UPDATE `{$GLOBALS['mysql_prefix']}settings` SET `value` = '{$this_version}' WHERE `settings`.`name` ='_version' LIMIT 1 ;";
// 3/22/09
$result = mysql_query($query) or do_error($query, 'mysql_query() failed', mysql_error(), basename(__FILE__), __LINE__);
$query = "ALTER TABLE `{$GLOBALS['mysql_prefix']}tracks_hh` ADD `utc_stamp` BIGINT( 12 ) NOT NULL DEFAULT '0' COMMENT 'Position timestamp in UTC' AFTER `altitude` ;";
$cur_folder_id = get_variable('cur_folder_id', 'POST', PRIVMSGS_INBOX, 'int');
switch ($mark_option) {
case 'mark_read':
case 'mark_unread':
$read_status = $mark_option === 'mark_read';
set_read_status($read_status, $msg_ids, $_CLASS['core_user']->data['user_id'], $cur_folder_id);
break;
default:
handle_mark_actions($_CLASS['core_user']->data['user_id'], $mark_option, $msg_ids, $cur_folder_id);
break;
}
}
// If new messages arrived, place them into the appropiate folder
$num_not_moved = 0;
if ($_CLASS['core_user']->data['user_new_privmsg'] && $action == 'view_folder') {
place_pm_into_folder($global_privmsgs_rules, get_variable('release', 'POST', 0));
$num_not_moved = $_CLASS['core_user']->data['user_new_privmsg'];
// Make sure num_not_moved is valid.
if ($num_not_moved < 0) {
$sql = 'UPDATE ' . CORE_USERS_TABLE . '
SET user_new_privmsg = 0, user_unread_privmsg = 0
WHERE user_id = ' . $_CLASS['core_user']->data['user_id'];
$_CLASS['core_db']->query($sql);
$num_not_moved = $_CLASS['core_user']->data['user_new_privmsg'] = $_CLASS['core_user']->data['user_unread_privmsg'] = 0;
}
}
if (!$msg_id && $folder_id == PRIVMSGS_NO_BOX) {
$folder_id = PRIVMSGS_INBOX;
} else {
if ($msg_id && $folder_id == PRIVMSGS_NO_BOX) {
$sql = 'SELECT folder_id
$severities[$GLOBALS['SEVERITY_MEDIUM']] = "#00FF00";
$severities[$GLOBALS['SEVERITY_HIGH']] = "#F80000";
$colors[$GLOBALS['SEVERITY_NORMAL']] = "black";
$colors[$GLOBALS['SEVERITY_MEDIUM']] = "black";
$colors[$GLOBALS['SEVERITY_HIGH']] = "yellow";
echo "<BODY style='background-color:{$severities[$row['severity']]}; text-color: {$colors[$row['severity']]};' onload = 'ck_frames();' >";
/* Creates statistics header and details of responding and en-route units 7/29/09 */
$result_dispatched = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE ticket_id='{$id}'\n\tAND `dispatched` IS NOT NULL AND `responding` IS NULL AND `on_scene` IS NULL AND `clear` IS NULL");
$num_rows_dispatched = mysql_num_rows($result_dispatched);
$result_responding = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE ticket_id='{$id}'\n\tAND `responding` IS NOT NULL AND `on_scene` IS NULL AND `clear` IS NULL");
$num_rows_responding = mysql_num_rows($result_responding);
$result_on_scene = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE ticket_id='{$id}' \n\tAND `on_scene` IS NOT NULL AND `clear` IS NULL");
$num_rows_on_scene = mysql_num_rows($result_on_scene);
$result_cleared = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE ticket_id='{$id}' \n\tAND `clear` IS NOT NULL");
$num_rows_cleared = mysql_num_rows($result_cleared);
$end_date = is_date($row['problemend']) ? totime($row['problemend']) : time() - get_variable('delta_mins') * 60;
$elapsed = my_date_diff($end_date, totime($row['problemstart']));
// integer values req'd - 3/12/10
$stats = "<B>Severity: {$ticket_severity}, <SPAN STYLE='background-color:white; color:black;'> age: {$elapsed} </SPAN>";
echo $stats;
echo "<BR>Units dispatched: ({$num_rows_dispatched}) ";
while ($row_base = mysql_fetch_array($result_dispatched, MYSQL_ASSOC)) {
$result = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}responder` WHERE id='{$row_base['responder_id']}'");
$row = mysql_fetch_assoc($result);
echo "{$row['name']}: {$row['handle']} ";
}
echo "<BR>Units responding: ({$num_rows_responding}) ";
while ($row_base = mysql_fetch_array($result_responding, MYSQL_ASSOC)) {
$result = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}responder` WHERE id='{$row_base['responder_id']}'");
$row = mysql_fetch_assoc($result);
echo "{$row['name']}: {$row['handle']} ";
<?php
$hide_dispatched = 1;
// 0 is standard, disallows hiding of deployed units. 1 allows deployed units to be hidden.
$hide_status_groups = get_variable('group_or_dispatch');
/*
12/03/10 new file to support hide / show functions for facilities and units.
2/04/11 Revised SQL query in function get_category_butts() to IS NULL rather than <> NULL
2/12/11 Revised SQL in function get_category($unit) to correct error with show / hide when using setting group_or_dispatch = 0
*/
function get_category_butts()
{
global $hide_status_groups, $hide_dispatched;
$category_butts = array();
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `clear` IS NULL OR DATE_FORMAT(`clear`,'%y') = '00' ";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$num_disp = mysql_num_rows($result);
//
if ($num_disp > 0 && $hide_dispatched == 1) {
$category_butts[0] = "Dispatched";
$i = 1;
} else {
$i = 0;
}
if ($hide_status_groups == 1) {
$query = "SELECT DISTINCT `group` FROM `{$GLOBALS['mysql_prefix']}un_status` ORDER BY `group` ASC";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
if ($row['group'] == "" || $row['group'] == NULL || $row['group'] == "NULL") {
$category_name = "?";
} else {
function popup_ticket($id, $print = 'false', $search = FALSE)
{
/* 7/9/09 - show specified ticket */
global $istest, $iw_width;
if ($istest) {
print "GET<br />\n";
dump($_GET);
print "POST<br />\n";
dump($_POST);
}
if ($id == '' or $id <= 0 or !check_for_rows("SELECT * FROM `{$GLOBALS['mysql_prefix']}ticket` WHERE id='{$id}'")) {
/* sanity check */
print "Invalid Ticket ID: '{$id}'<BR />";
return;
}
$restrict_ticket = get_variable('restrict_user_tickets') == 1 && !is_administrator() ? " AND owner={$_SESSION['user_id']}" : "";
$query = "SELECT *,UNIX_TIMESTAMP(problemstart) AS problemstart,UNIX_TIMESTAMP(problemend) AS problemend,UNIX_TIMESTAMP(date) AS date,UNIX_TIMESTAMP(updated) AS updated, `{$GLOBALS['mysql_prefix']}ticket`.`description` AS `tick_descr` FROM `{$GLOBALS['mysql_prefix']}ticket` WHERE ID='{$id}' {$restrict_ticket}";
// 8/12/09
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
if (!mysql_num_rows($result)) {
//no tickets? print "error" or "restricted user rights"
print "<FONT CLASS=\"warn\">No such ticket or user access to ticket is denied</FONT>";
exit;
}
$row = stripslashes_deep(mysql_fetch_assoc($result));
?>
<TABLE BORDER="0" ID = "outer" ALIGN="left">
<?php
print "<TD ALIGN='left'>";
print "<TABLE ID='theMap' BORDER=0><TR CLASS='odd' ><TD ALIGN='center'>\n\t\t<DIV ID='map' STYLE='WIDTH:" . get_variable('map_width') . "px; HEIGHT: " . get_variable('map_height') . "PX'></DIV>\n\t\t</TD></TR>";
// 11/29/08
print "<FORM NAME='sv_form' METHOD='post' ACTION=''><INPUT TYPE='hidden' NAME='frm_lat' VALUE=" . $row['lat'] . ">";
// 2/11/09
print "<INPUT TYPE='hidden' NAME='frm_lng' VALUE=" . $row['lng'] . "></FORM>";
print "<TR ID='pointl1' CLASS='print_TD' STYLE = 'display:none;'>\n\t\t<TD ALIGN='center'><B>Range:</B> <SPAN ID='range'></SPAN> <B>Brng</B>: \n\t\t\t<SPAN ID='brng'></SPAN></TD></TR>\n\n\t\t<TR ID='pointl2' CLASS='print_TD' STYLE = 'display:none;'>\n\t\t\t<TD ALIGN='center'><B>Lat:</B> <SPAN ID='newlat'></SPAN>\n\t\t\t <B>Lng:</B> <SPAN ID='newlng'></SPAN> <B>NGS:</B> <SPAN ID = 'newusng'></SPAN></TD></TR>\n";
print "</TABLE>\n";
print "</TD></TR>";
print "<TR CLASS='odd' ><TD COLSPAN='2' CLASS='print_TD'>";
$lat = $row['lat'];
$lng = $row['lng'];
print "</TABLE>\n";
?>
<SCRIPT SRC='../js/usng.js' TYPE='text/javascript'></SCRIPT>
<SCRIPT SRC="../js/graticule.js" type="text/javascript"></SCRIPT>
<SCRIPT>
function isNull(val) { // checks var stuff = null;
return val === null;
}
var the_grid;
var grid = false;
function doGrid() {
if (grid) {
map.removeOverlay(the_grid);
grid = false;
}
else {
the_grid = new LatLonGraticule();
map.addOverlay(the_grid);
grid = true;
}
}
String.prototype.trim = function () { // 9/14/08
return this.replace(/^\s*(\S*(\s+\S+)*)\s*$/, "$1");
};
String.prototype.parseDeg = function() {
if (!isNaN(this)) return Number(this); // signed decimal degrees without NSEW
var degLL = this.replace(/^-/,'').replace(/[NSEW]/i,''); // strip off any sign or compass dir'n
var dms = degLL.split(/[^0-9.,]+/); // split out separate d/m/s
for (var i in dms) if (dms[i]=='') dms.splice(i,1); // remove empty elements (see note below)
switch (dms.length) { // convert to decimal degrees...
case 3: // interpret 3-part result as d/m/s
var deg = dms[0]/1 + dms[1]/60 + dms[2]/3600; break;
case 2: // interpret 2-part result as d/m
var deg = dms[0]/1 + dms[1]/60; break;
case 1: // decimal or non-separated dddmmss
if (/[NS]/i.test(this)) degLL = '0' + degLL; // - normalise N/S to 3-digit degrees
var deg = dms[0].slice(0,3)/1 + dms[0].slice(3,5)/60 + dms[0].slice(5)/3600; break;
default: return NaN;
}
if (/^-/.test(this) || /[WS]/i.test(this)) deg = -deg; // take '-', west and south as -ve
return deg;
}
Number.prototype.toRad = function() { // convert degrees to radians
return this * Math.PI / 180;
}
Number.prototype.toDeg = function() { // convert radians to degrees (signed)
return this * 180 / Math.PI;
}
Number.prototype.toBrng = function() { // convert radians to degrees (as bearing: 0...360)
return (this.toDeg()+360) % 360;
}
function brng(lat1, lon1, lat2, lon2) {
lat1 = lat1.toRad(); lat2 = lat2.toRad();
var dLon = (lon2-lon1).toRad();
var y = Math.sin(dLon) * Math.cos(lat2);
var x = Math.cos(lat1)*Math.sin(lat2) -
Math.sin(lat1)*Math.cos(lat2)*Math.cos(dLon);
return Math.atan2(y, x).toBrng();
}
distCosineLaw = function(lat1, lon1, lat2, lon2) {
var R = 6371; // earth's mean radius in km
var d = Math.acos(Math.sin(lat1.toRad())*Math.sin(lat2.toRad()) +
Math.cos(lat1.toRad())*Math.cos(lat2.toRad())*Math.cos((lon2-lon1).toRad())) * R;
return d;
}
var km2feet = 3280.83;
var thisMarker = false;
var map;
var icons=[]; // note globals - 1/29/09
icons[<?php
print $GLOBALS['SEVERITY_NORMAL'];
?>
] = "./our_icons/blue.png"; // normal
icons[<?php
print $GLOBALS['SEVERITY_MEDIUM'];
?>
] = "./our_icons/green.png"; // green
icons[<?php
print $GLOBALS['SEVERITY_HIGH'];
?>
] = "./our_icons/red.png"; // red
icons[<?php
print $GLOBALS['SEVERITY_HIGH'];
?>
+1] = "./our_icons/white.png"; // white - not in use
var baseIcon = new GIcon();
baseIcon.shadow = "./markers/sm_shadow.png";
baseIcon.iconSize = new GSize(20, 34);
baseIcon.iconAnchor = new GPoint(9, 34);
baseIcon.infoWindowAnchor = new GPoint(9, 2);
map = new GMap2($("map")); // create the map
<?php
$maptype = get_variable('maptype');
// 08/02/09
switch ($maptype) {
case "1":
break;
case "2":
?>
map.setMapType(G_SATELLITE_MAP);<?php
break;
case "3":
?>
map.setMapType(G_PHYSICAL_MAP);<?php
break;
case "4":
?>
map.setMapType(G_HYBRID_MAP);<?php
break;
default:
print "ERROR in " . basename(__FILE__) . " " . __LINE__ . "<BR />";
}
?>
map.addControl(new GLargeMapControl());
map.addControl(new GMapTypeControl());
map.addControl(new GOverviewMapControl()); // 12/24/08
<?php
if (get_variable('terrain') == 1) {
?>
map.addMapType(G_PHYSICAL_MAP);
<?php
}
?>
map.setCenter(new GLatLng(<?php
print $lat;
?>
, <?php
print $lng;
?>
),11);
var icon = new GIcon(baseIcon);
icon.image = icons[<?php
print $row['severity'];
?>
];
var point = new GLatLng(<?php
print $lat;
?>
, <?php
print $lng;
?>
); // 1147
map.addOverlay(new GMarker(point, icon));
map.enableScrollWheelZoom();
// ====================================Add Active Responding Units to Map =========================================================================
var icons=[]; // note globals - 1/29/09
icons[1] = "./our_icons/white.png"; // normal
icons[2] = "./our_icons/black.png"; // green
var baseIcon = new GIcon();
baseIcon.shadow = "./markers/sm_shadow.png";
baseIcon.iconSize = new GSize(20, 34);
baseIcon.iconAnchor = new GPoint(9, 34);
baseIcon.infoWindowAnchor = new GPoint(9, 2);
var unit_icon = new GIcon(baseIcon);
unit_icon.image = icons[1];
function createMarker(unit_point, number) {
var unit_marker = new GMarker(unit_point, unit_icon);
// Show this markers index in the info window when it is clicked
var html = number;
GEvent.addListener(unit_marker, "click", function() {unit_marker.openInfoWindowHtml(html);});
return unit_marker;
}
<?php
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE ticket_id='{$id}'";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
while ($row = mysql_fetch_array($result)) {
$responder_id = $row['responder_id'];
if ($row['clear'] == NULL) {
$query_unit = "SELECT * FROM `{$GLOBALS['mysql_prefix']}responder` WHERE id='{$responder_id}'";
$result_unit = mysql_query($query_unit) or do_error($query_unit, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
while ($row_unit = mysql_fetch_array($result_unit)) {
$unit_id = $row_unit['id'];
$mobile = $row_unit['mobile'];
if (my_is_float($row_unit['lat']) && my_is_float($row_unit['lng'])) {
if ($mobile == 1) {
echo "var unit_icon = new GIcon(baseIcon);\n";
echo "var unit_icon_url = \"./our_icons/gen_icon.php?blank=0&text=RU\";\n";
// 4/18/09
echo "unit_icon.image = unit_icon_url;\n";
echo "var unit_point = new GLatLng(" . $row_unit['lat'] . "," . $row_unit['lng'] . ");\n";
echo "var unit_marker = createMarker(unit_point, '" . addslashes($row_unit['name']) . "', unit_icon);\n";
echo "map.addOverlay(unit_marker);\n";
echo "\n";
} else {
echo "var unit_icon = new GIcon(baseIcon);\n";
echo "var unit_icon_url = \"./our_icons/gen_icon.php?blank=4&text=RU\";\n";
// 4/18/09
echo "unit_icon.image = unit_icon_url;\n";
echo "var unit_point = new GLatLng(" . $row_unit['lat'] . "," . $row_unit['lng'] . ");\n";
echo "var unit_marker = createMarker(unit_point, '" . addslashes($row_unit['name']) . "', unit_icon);\n";
echo "map.addOverlay(unit_marker);\n";
echo "\n";
}
// end if/else ($mobile)
}
// end ((my_is_float()) - responding units
}
// end outer if
}
// end inner while
}
// end outer while
// =====================================End of functions to show responding units========================================================================
// ====================================Add Facilities to Map 8/1/09================================================
?>
var icons=[];
var g=0;
var fmarkers = [];
var baseIcon = new GIcon();
baseIcon.shadow = "./markers/sm_shadow.png";
baseIcon.iconSize = new GSize(30, 30);
baseIcon.iconAnchor = new GPoint(15, 30);
baseIcon.infoWindowAnchor = new GPoint(9, 2);
var fac_icon = new GIcon(baseIcon);
fac_icon.image = icons[1];
function createfacMarker(fac_point, fac_name, id, fac_icon) {
var fac_marker = new GMarker(fac_point, fac_icon);
// Show this markers index in the info window when it is clicked
var fac_html = fac_name;
fmarkers[id] = fac_marker;
GEvent.addListener(fac_marker, "click", function() {fac_marker.openInfoWindowHtml(fac_html);});
return fac_marker;
}
<?php
$query_fac = "SELECT *,UNIX_TIMESTAMP(updated) AS updated, `{$GLOBALS['mysql_prefix']}facilities`.id AS fac_id, `{$GLOBALS['mysql_prefix']}facilities`.description AS facility_description, `{$GLOBALS['mysql_prefix']}fac_types`.name AS fac_type_name, `{$GLOBALS['mysql_prefix']}facilities`.name AS facility_name FROM `{$GLOBALS['mysql_prefix']}facilities` LEFT JOIN `{$GLOBALS['mysql_prefix']}fac_types` ON `{$GLOBALS['mysql_prefix']}facilities`.type = `{$GLOBALS['mysql_prefix']}fac_types`.id LEFT JOIN `{$GLOBALS['mysql_prefix']}fac_status` ON `{$GLOBALS['mysql_prefix']}facilities`.status_id = `{$GLOBALS['mysql_prefix']}fac_status`.id ORDER BY `{$GLOBALS['mysql_prefix']}facilities`.type ASC";
$result_fac = mysql_query($query_fac) or do_error($query_fac, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
while ($row_fac = mysql_fetch_array($result_fac)) {
$eols = array("\r\n", "\n", "\r");
// all flavors of eol
while ($row_fac = stripslashes_deep(mysql_fetch_array($result_fac))) {
//
$fac_name = $row_fac['facility_name'];
// 10/8/09
$fac_temp = explode("/", $fac_name);
$fac_index = substr($fac_temp[count($fac_temp) - 1], -6, strlen($fac_temp[count($fac_temp) - 1]));
// 3/19/11
print "\t\tvar fac_sym = '{$fac_index}';\n";
// for sidebar and icon 10/8/09
$fac_id = $row_fac['id'];
$fac_type = $row_fac['icon'];
$f_disp_name = $row_fac['facility_name'];
// 10/8/09
$f_disp_temp = explode("/", $f_disp_name);
$facility_display_name = $f_disp_temp[0];
if (my_is_float($row_fac['lat']) && my_is_float($row_fac['lng'])) {
$fac_tab_1 = "<TABLE CLASS='infowin' width='{$iw_width}' >";
$fac_tab_1 .= "<TR CLASS='even'><TD COLSPAN=2 ALIGN='center'><B>" . addslashes(shorten($facility_display_name, 48)) . "</B></TD></TR>";
$fac_tab_1 .= "<TR CLASS='odd'><TD COLSPAN=2 ALIGN='center'><B>" . addslashes(shorten($row_fac['fac_type_name'], 48)) . "</B></TD></TR>";
$fac_tab_1 .= "<TR CLASS='even'><TD ALIGN='right'>Description: </TD><TD ALIGN='left'>" . addslashes(str_replace($eols, " ", $row_fac['facility_description'])) . "</TD></TR>";
$fac_tab_1 .= "<TR CLASS='odd'><TD ALIGN='right'>Status: </TD><TD ALIGN='left'>" . addslashes($row_fac['status_val']) . " </TD></TR>";
$fac_tab_1 .= "<TR CLASS='even'><TD ALIGN='right'>Contact: </TD><TD ALIGN='left'>" . addslashes($row_fac['contact_name']) . " Email: " . addslashes($row_fac['contact_email']) . "</TD></TR>";
$fac_tab_1 .= "<TR CLASS='odd'><TD ALIGN='right'>Phone: </TD><TD ALIGN='left'>" . addslashes($row_fac['contact_phone']) . " </TD></TR>";
$fac_tab_1 .= "<TR CLASS='even'><TD ALIGN='right'>As of: </TD><TD ALIGN='left'>" . format_date($row_fac['updated']) . "</TD></TR>";
$fac_tab_1 .= "</TABLE>";
$fac_tab_2 = "<TABLE CLASS='infowin' width='{$iw_width}' >";
$fac_tab_2 .= "<TR CLASS='odd'><TD ALIGN='right'>Security contact: </TD><TD ALIGN='left'>" . addslashes($row_fac['security_contact']) . " </TD></TR>";
$fac_tab_2 .= "<TR CLASS='even'><TD ALIGN='right'>Security email: </TD><TD ALIGN='left'>" . addslashes($row_fac['security_email']) . " </TD></TR>";
$fac_tab_2 .= "<TR CLASS='odd'><TD ALIGN='right'>Security phone: </TD><TD ALIGN='left'>" . addslashes($row_fac['security_phone']) . " </TD></TR>";
$fac_tab_2 .= "<TR CLASS='even'><TD ALIGN='right'>Access rules: </TD><TD ALIGN='left'>" . addslashes(str_replace($eols, " ", $row_fac['access_rules'])) . "</TD></TR>";
$fac_tab_2 .= "<TR CLASS='odd'><TD ALIGN='right'>Security reqs: </TD><TD ALIGN='left'>" . addslashes(str_replace($eols, " ", $row_fac['security_reqs'])) . "</TD></TR>";
$fac_tab_2 .= "<TR CLASS='even'><TD ALIGN='right'>Opening hours: </TD><TD ALIGN='left'>" . addslashes(str_replace($eols, " ", $row_fac['opening_hours'])) . "</TD></TR>";
$fac_tab_2 .= "<TR CLASS='odd'><TD ALIGN='right'>Prim pager: </TD><TD ALIGN='left'>" . addslashes($row_fac['pager_p']) . " </TD></TR>";
$fac_tab_2 .= "<TR CLASS='even'><TD ALIGN='right'>Sec pager: </TD><TD ALIGN='left'>" . addslashes($row_fac['pager_s']) . " </TD></TR>";
$fac_tab_2 .= "</TABLE>";
?>
// var fac_sym = (g+1).toString();
var myfacinfoTabs = [
new GInfoWindowTab("<?php
print nl2brr(addslashes(shorten($row_fac['facility_name'], 10)));
?>
", "<?php
print $fac_tab_1;
?>
"),
new GInfoWindowTab("More ...", "<?php
print str_replace($eols, " ", $fac_tab_2);
?>
")
];
<?php
if ($row_fac['lat'] == 0.999999 && $row_fac['lng'] == 0.999999) {
// check for facilities entered in no maps mode 7/28/10
echo "var fac_icon = new GIcon(baseIcon);\n";
echo "var fac_type = {$fac_type};\n";
echo "var fac_icon_url = \"./our_icons/question1.png\";\n";
echo "fac_icon.image = fac_icon_url;\n";
echo "var fac_point = new GLatLng(" . get_variable('def_lat') . "," . get_variable('def_lng') . ");\n";
echo "var fac_marker = createfacMarker(fac_point, myfacinfoTabs, g, fac_icon);\n";
echo "map.addOverlay(fac_marker);\n";
echo "\n";
} else {
echo "var fac_icon = new GIcon(baseIcon);\n";
echo "var fac_type = {$fac_type};\n";
?>
var origin = ((fac_sym.length)>3)? (fac_sym.length)-3: 0; // pick low-order three chars 3/22/11
var iconStr = fac_sym.substring(origin);
<?php
echo "var fac_icon_url = \"./our_icons/gen_fac_icon.php?blank={$fac_type}&text=\" + (iconStr) + \"\";\n";
echo "fac_icon.image = fac_icon_url;\n";
echo "var fac_point = new GLatLng(" . $row_fac['lat'] . "," . $row_fac['lng'] . ");\n";
echo "var fac_marker = createfacMarker(fac_point, myfacinfoTabs, g, fac_icon);\n";
echo "map.addOverlay(fac_marker);\n";
echo "\n";
}
}
// end if my_is_float - facilities
?>
g++;
<?php
}
// end while
}
// =====================================End of functions to show facilities========================================================================
do_kml();
// kml functions
?>
function lat2ddm(inlat) { // 9/7/08
var x = new Number(inlat);
var y = (inlat>0)? Math.floor(x):Math.round(x);
var z = ((Math.abs(x-y)*60).toFixed(1));
var nors = (inlat>0.0)? " N":" S";
return Math.abs(y) + '\260 ' + z +"'" + nors;
}
function lng2ddm(inlng) {
var x = new Number(inlng);
var y = (inlng>0)? Math.floor(x):Math.round(x);
var z = ((Math.abs(x-y)*60).toFixed(1));
var eorw = (inlng>0.0)? " E":" W";
return Math.abs(y) + '\260 ' + z +"'" + eorw;
}
function do_coords(inlat, inlng) { //9/14/08
if(inlat.toString().length==0) return; // 10/15/08
var str = inlat + ", " + inlng + "\n";
str += ll2dms(inlat) + ", " +ll2dms(inlng) + "\n";
str += lat2ddm(inlat) + ", " +lng2ddm(inlng);
alert(str);
}
function ll2dms(inval) { // lat/lng to degr, mins, sec's - 9/9/08
var d = new Number(inval);
d = (inval>0)? Math.floor(d):Math.round(d);
var mi = (inval-d)*60;
var m = Math.floor(mi) // min's
var si = (mi-m)*60;
var s = si.toFixed(1);
return d + '\260 ' + Math.abs(m) +"' " + Math.abs(s) + '"';
}
</SCRIPT>
<?php
}
/**
* Display user notes
*/
function mcp_notes_user_view($action)
{
global $_CLASS, $_CORE_CONFIG, $config;
$user_id = request_var('u', 0);
$username = request_var('username', '');
$start = request_var('start', 0);
$st = request_var('st', 0);
$sk = request_var('sk', 'b');
$sd = request_var('sd', 'd');
$url = 'forums&file=mcp&i=notes&mode=user_notes';
$sql_where = $user_id ? "user_id = {$user_id}" : "username = '******'";
$sql = 'SELECT *
FROM ' . CORE_USERS_TABLE . "\n\t\tWHERE {$sql_where}";
$result = $_CLASS['core_db']->query($sql);
$userrow = $_CLASS['core_db']->fetch_row_assoc($result);
$_CLASS['core_db']->free_result($result);
if (!$userrow) {
trigger_error('NO_USER');
}
$user_id = $userrow['user_id'];
$deletemark = $action === 'del_marked';
$deleteall = $action === 'del_all';
$marked = get_variable('marknote', 'REQUEST', false, 'array:int');
$usernote = request_var('usernote', '', true);
// Handle any actions
if (($deletemark || $deleteall) && $_CLASS['forums_auth']->acl_get('a_clearlogs')) {
$where_sql = '';
if ($deletemark && !empty($marked)) {
$where_sql = ' AND log_id IN (' . implode(', ', $marked) . ')';
}
if ($where_sql || $deleteall) {
$sql = 'DELETE FROM ' . FORUMS_LOG_TABLE . '
WHERE log_type = ' . LOG_USERS . " \n\t\t\t\t\tAND reportee_id = {$user_id}\n\t\t\t\t\t{$where_sql}";
$_CLASS['core_db']->query($sql);
add_log('admin', 'LOG_CLEAR_USER', $userrow['username']);
$msg = $deletemark ? 'MARKED_NOTES_DELETED' : 'ALL_NOTES_DELETED';
$redirect = generate_link($url . '&u=' . $user_id);
$_CLASS['core_display']->meta_refresh(3, $redirect);
trigger_error($_CLASS['core_user']->lang[$msg] . '<br /><br />' . sprintf($_CLASS['core_user']->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>'));
}
}
if ($usernote && $action === 'add_feedback') {
add_log('admin', 'LOG_USER_FEEDBACK', $userrow['username']);
add_log('user', $user_id, 'LOG_USER_GENERAL', $usernote);
$redirect = generate_link($url . '&u=' . $user_id);
$_CLASS['core_display']->meta_refresh(3, $redirect);
trigger_error($_CLASS['core_user']->lang['USER_FEEDBACK_ADDED'] . '<br /><br />' . sprintf($_CLASS['core_user']->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>'));
}
// Generate the appropriate user information for the user we are looking at
$rank_title = $rank_img = '';
//get_user_rank($userrow['user_rank'], $userrow['user_posts'], $rank_title, $rank_img);
$avatar_img = '';
if (!empty($userrow['user_avatar'])) {
switch ($userrow['user_avatar_type']) {
case AVATAR_UPLOAD:
$avatar_img = $_CORE_CONFIG['global']['path_avatar_upload'] . '/';
break;
case AVATAR_GALLERY:
$avatar_img = $_CORE_CONFIG['global']['path_avatar_gallery'] . '/';
break;
}
$avatar_img .= $userrow['user_avatar'];
$avatar_img = '<img src="' . $avatar_img . '" width="' . $userrow['user_avatar_width'] . '" height="' . $userrow['user_avatar_height'] . '" alt="" />';
}
$limit_days = array(0 => $_CLASS['core_user']->lang['ALL_ENTRIES'], 1 => $_CLASS['core_user']->lang['1_DAY'], 7 => $_CLASS['core_user']->lang['7_DAYS'], 14 => $_CLASS['core_user']->lang['2_WEEKS'], 30 => $_CLASS['core_user']->lang['1_MONTH'], 90 => $_CLASS['core_user']->lang['3_MONTHS'], 180 => $_CLASS['core_user']->lang['6_MONTHS'], 365 => $_CLASS['core_user']->lang['1_YEAR']);
$sort_by_text = array('a' => $_CLASS['core_user']->lang['SORT_USERNAME'], 'b' => $_CLASS['core_user']->lang['SORT_DATE'], 'c' => $_CLASS['core_user']->lang['SORT_IP'], 'd' => $_CLASS['core_user']->lang['SORT_ACTION']);
$sort_by_sql = array('a' => 'l.username', 'b' => 'l.log_time', 'c' => 'l.log_ip', 'd' => 'l.log_operation');
$s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';
gen_sort_selects($limit_days, $sort_by_text, $st, $sk, $sd, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);
// Define where and sort sql for use in displaying logs
$sql_where = $st ? $_CLASS['core_user']->time - $st * 86400 : 0;
$sql_sort = $sort_by_sql[$sk] . ' ' . ($sd == 'd' ? 'DESC' : 'ASC');
$log_data = array();
$log_count = 0;
view_log('user', $log_data, $log_count, $config['posts_per_page'], $start, 0, 0, $user_id, $sql_where, $sql_sort);
$_CLASS['core_template']->assign('S_USER_NOTES', false);
if ($log_count) {
$_CLASS['core_template']->assign('S_USER_NOTES', true);
foreach ($log_data as $row) {
$_CLASS['core_template']->assign_vars_array('usernotes', array('REPORT_BY' => $row['username'], 'REPORT_AT' => $_CLASS['core_user']->format_date($row['time']), 'ACTION' => $row['action'], 'IP' => $row['ip'], 'ID' => $row['id']));
}
}
$pagination = generate_pagination($url . "&u={$user_id}&st={$st}&sk={$sk}&sd={$sd}", $log_count, $config['posts_per_page'], $start);
$_CLASS['core_template']->assign_array(array('U_POST_ACTION' => generate_link($url . '&u=' . $user_id), 'S_CLEAR_ALLOWED' => $_CLASS['forums_auth']->acl_get('a_clearlogs'), 'S_SELECT_SORT_DIR' => $s_sort_dir, 'S_SELECT_SORT_KEY' => $s_sort_key, 'S_SELECT_SORT_DAYS' => $s_limit_days, 'L_TITLE' => $_CLASS['core_user']->get_lang('MCP_NOTES_USER'), 'PAGE_NUMBER' => on_page($log_count, $config['posts_per_page'], $start), 'PAGINATION' => $pagination['formated'], 'PAGINATION_ARRAY' => $pagination['array'], 'TOTAL_REPORTS' => $log_count == 1 ? $_CLASS['core_user']->get_lang('LIST_REPORT') : sprintf($_CLASS['core_user']->get_lang('LIST_REPORTS'), $log_count), 'USERNAME' => $userrow['username'], 'USER_COLOR' => !empty($userrow['user_colour']) ? $userrow['user_colour'] : '', 'RANK_TITLE' => $rank_title, 'JOINED' => $_CLASS['core_user']->format_date($userrow['user_reg_date']), 'POSTS' => $userrow['user_posts'] ? $userrow['user_posts'] : 0, 'WARNINGS' => @$userrow['user_warnings'] ? $userrow['user_warnings'] : 0, 'AVATAR_IMG' => $avatar_img, 'RANK_IMG' => $rank_img));
}
padding-left: 0.5em; padding-right: 0.5em; }
#navhor{ margin-top: 1em; }
#navhor ul { BACKGROUND-COLOR: #EEEEEE; text-align: center; margin-left: 0; padding-left: 0;
border-top: 1px solid silver; border-bottom: 1px solid gray; }
#navhor li { list-style-type: none; padding: 0.25em 1em; border-left: 1px solid white; display: inline }
#navhor li:first-child { border: none; }
-->
</style>
</HEAD>' . "\n";
print '<!--BACKGROUND-COLOR: #fff5e3;#EEEEEE; -->' . " \n ";
print '<BODY>';
print '<TABLE width="90%" cellpadding=0 cellspacing=0 border=0><tr><td align ="left">';
print '<h4>' . $this_title . ' V. ' . get_variable('version') . ' at <a href="http://' . get_variable('host') . '" target="_blank">' . get_variable('host') . '</a> </h4>';
print '</TD><TD align="right">';
print '<A HREF="help.php" target="main">Help </A>' . " " . '</TD><TD>';
print ' <A HREF="logout.php" target="main"> Logout</A> ';
print '</TD></TR><TR><td COLSPAN="3">';
if ($GLOBALS['SEVERITY_SORT']) {
$button_link = array("main.php?ident=id¤t=0&order=DESC&sort_by=t_date&severity=0", "main.php?ident=id¤t=0&order=DESC&sort_by=t_date&severity=1", "main.php?ident=id¤t=0&order=DESC&sort_by=t_date&severity=2", "main.php?action=add&id=0", "main.php?ident=id¤t=0&order=DESC&sort_by=t_date&severity=0&showclosed=true", "main.php?ident=id¤t=0&order=DESC&sort_by=t_date&severity=1&showclosed=true", "main.php?ident=id¤t=0&order=DESC&sort_by=t_date&severity=2&showclosed=true");
$button_label = array("[All, ", "Medium+, ", "High] ", "Add New Ticket ", "[All, ", "Medium+, ", "High]");
print '<div id="this">Open Tickets ';
for ($i = 0; $i < 4; $i++) {
print '<A HREF="' . $button_link[$i] . '" target="main">' . $button_label[$i] . '</A>';
//$whattoprint = ($i = 2) ? (", ") : ("] | ") ;
//print $whattoprint;
}
/*******
print '<A HREF="main.php?ident=id¤t=0&order=DESC&sort_by=t_date&severity=0" target="main">All</A> , ';
||**************************************************************||
|| LICENSE: ( http://www.gnu.org/licenses/gpl.txt ) ||
||**************************************************************||
|| Viperal CMS is released under the terms and conditions ||
|| of the GNU General Public License version 2 ||
|| ||
||**************************************************************||
$Id$
*/
header('Content-Type: text/html');
$_CLASS['core_user']->user_setup();
require_once SITE_FILE_ROOT . 'includes/nusoap/nusoap.php';
$google_license_key = "dJ5XAtRQFHIlbfutrovVj3TizF1Q2TXP";
$query = get_variable('query', 'POST');
$search_type = get_variable('search_type', 'POST', 0, 'int');
$limit = 10;
if (!$query) {
script_close();
}
$query_command = $query;
if ($search_type === 1) {
$query_command .= ' site:viperals.berlios.de';
}
$params = array('key' => (string) $google_license_key, 'q' => (string) $query_command, 'start' => (int) 0, 'maxResults' => (int) $limit, 'filter' => (bool) true, 'restricts' => (string) '', 'safeSearch' => (bool) false, 'lr' => (string) '', 'ie' => 'UTF-8', 'oe' => 'UTF-8');
$client = new soapclient('http://api.google.com/search/beta2');
$result = $client->call('doGoogleSearch', $params, 'urn:GoogleSearch');
if ($client->fault || $client->getError()) {
script_close();
}
$pagination = generate_pagination('google_search&query=' . urlencode($query) . '&search_type=' . $search_type, $result['estimatedTotalResultsCount'], $limit, 0);
user_delete($id);
trigger_error($_CLASS['core_user']->lang['BOT_DELETED']);
}
break;
}
}
if ($_REQUEST['mode'] == 'unactivated') {
$status = STATUS_PENDING;
$template = 'admin/users/unactivated.html';
$link = 'users&mode=unactivated';
} else {
$status = STATUS_DISABLED;
$template = 'admin/users/disabled.html';
$link = 'users&mode=disabled';
}
$start = get_variable('start', 'GET', false, 'integer');
$sql = 'SELECT user_id, username, user_reg_date
FROM ' . USERS_TABLE . '
WHERE user_type = ' . USER_NORMAL . '
AND user_status = ' . $status;
$result = $_CLASS['core_db']->query_limit($sql, 20, $start);
while ($row = $_CLASS['core_db']->fetch_row_assoc($result)) {
$_CLASS['core_template']->assign_vars_array('users_admin', array('user_id' => $row['user_id'], 'user_name' => $row['username'], 'registered' => $_CLASS['core_user']->format_time($row['user_reg_date']), 'link_profile' => generate_link('Members_List&mode=viewprofile&u=' . $row['user_id']), 'link_activate' => generate_link($link . '&option=activate&id=' . $row['user_id'], array('admin' => true)), 'link_remove' => generate_link($link . '&option=delete&id=' . $row['user_id'], array('admin' => true)), 'link_remind' => generate_link($link . '&option=remind&id=' . $row['user_id'], array('admin' => true)), 'link_details' => ''));
}
$_CLASS['core_db']->free_result($result);
$sql = 'SELECT count(*) as count FROM ' . USERS_TABLE . '
WHERE user_type = ' . USER_NORMAL . '
AND user_status = ' . $status;
$result = $_CLASS['core_db']->query($sql);
list($count) = $_CLASS['core_db']->fetch_row_num($result);
$_CLASS['core_db']->free_result($result);
ajax_("profile", "&pass_="+pass+"&id_=<?php
echo $info_user[0];
?>
", false, "pruebaDB");
if(document.getElementById("txt_ver1").value==0){
message+="No se almacenó su contraseña. Intentelo más tarde.";
$("#grp_old_pass").addClass( "has-error" );
show_message(message,"login_message");
}else{
message+="Cambios realizados exitosamente";
show_message(message,"login_message2");
setTimeout(function (){ window.location.assign("<?php
echo get_variable("profile") . "&cP=ok";
?>
"); }, 3200);
}
}
}else{
show_message(message,"login_message");
}
});
$("#btn_back").click(function(){
window.location.assign("<?php
echo get_variable("profile");
?>
");
});
</script>
?>
</H3>
<input type='button' value="Again" onClick = 'location.href="<?php
print basename(__FILE__);
?>
"' />
</body><input type='button' value="Finished" onClick = "self.close()" /><br /><br />
<?php
if ($results) {
?>
<div id="map_canvas" style="width: <?php
print get_variable('map_width');
?>
px; height: <?php
print get_variable('map_height');
?>
px"></div>
<?php
}
?>
</body>
</html>
<?php
}
// end if/else
?>
</BODY>
</HTML>
function generate_auth_options($auth_options = array(), $options_extend = false, $return_link = false)
{
global $_CLASS, $site_file_root;
$auth_options['groups'][0] = empty($auth_options['groups'][0]) ? array() : $auth_options['groups'][0];
$auth_options['groups'][1] = empty($auth_options['groups'][1]) ? array() : $auth_options['groups'][1];
$auth_options['users'] = empty($auth_options['users']) ? array() : $auth_options['users'];
$mode = $return = false;
$checks = array('add', 'remove', 'set');
foreach ($checks as $check) {
if (isset($_POST[$check])) {
$mode = $check;
break;
}
}
if ($mode) {
require_once $site_file_root . 'includes/functions_user.php';
$ids = array('groups' => array(), 'users' => array());
switch ($mode) {
case 'add':
$setup['groups'] = get_variable('groups_add', 'POST', array(), 'array');
$setup['users'] = explode("\n", get_variable('users_add', 'POST'));
$submited_options = get_variable('auth_options', 'POST', array(), 'array');
if (count($setup['users'])) {
$setup['users'] = user_get_id($setup['users'], $null);
}
if (count($setup['groups'])) {
$sql = 'SELECT group_id
FROM ' . GROUPS_TABLE . '
WHERE group_id IN (' . implode(', ', array_map('intval', $setup['groups'])) . ')';
$result = $_CLASS['core_db']->query($sql);
$setup['groups'] = array();
while ($row = $_CLASS['core_db']->fetch_row_assoc($result)) {
$setup['groups'][] = $row['group_id'];
}
$_CLASS['core_db']->free_result($result);
}
foreach ($setup['groups'] as $id) {
$auth_options['groups'][$submited_options['core_auth_type']][$id] = array('core_status' => $submited_options['core_status']);
}
foreach ($setup['users'] as $id) {
$auth_options['users'][$id] = array('core_status' => $submited_options['core_status']);
}
unset($setup);
//print_r($auth_options); die;
break;
case 'remove':
$ids['groups'] = array_map('intval', get_variable('groups_current', 'POST', array(), 'array'));
$ids['users'] = array_map('intval', get_variable('users_current', 'POST', array(), 'array'));
$function = $mode == 'add' ? 'array_merge' : 'array_diff';
// We need to tell with is only group and with is in group.
foreach ($ids['groups'] as $groups_id) {
if (isset($auth_options['groups'][1][$groups_id])) {
unset($auth_options['groups'][1][$groups_id]);
}
if (isset($auth_options['groups'][0][$groups_id])) {
unset($auth_options['groups'][0][$groups_id]);
}
}
foreach ($auth_options['users'] as $key => $ignore) {
if (in_array($key, $ids['users'])) {
unset($auth_options['users'][$key]);
}
}
break;
case 'set':
break;
}
$return = null;
if (!empty($auth_options['users']) || !empty($auth_options['groups'][0]) || !empty($auth_options['groups'][1])) {
$return =& $auth_options;
}
}
$group_list = $allowed_group_list = $disallowed_group_list = $allowed_user_list = $disallowed_user_list = '';
if (!empty($auth_options['users'])) {
$sql = 'SELECT user_id, username, user_colour
FROM ' . USERS_TABLE . '
WHERE user_id IN (' . implode(', ', array_keys($auth_options['users'])) . ')
ORDER BY username';
$result = $_CLASS['core_db']->query($sql);
while ($row = $_CLASS['core_db']->fetch_row_assoc($result)) {
$user_list = $auth_options['users'][$row['user_id']]['core_status'] == 1 ? 'allowed_user_list' : 'disallowed_user_list';
${$user_list} .= '<option ' . ($row['user_colour'] ? ' style="color: #' . $row['user_colour'] . ';"' : '') . ' value="' . $row['user_id'] . '">' . $row['username'] . '</option>';
}
$_CLASS['core_db']->free_result($result);
}
// this can be removed, when everthing else is updated
$groups_ids = array_merge(array_keys($auth_options['groups'][0]), array_keys($auth_options['groups'][1]));
if (!empty($groups_ids)) {
$sql = 'SELECT group_id, group_name, group_type
FROM ' . GROUPS_TABLE . '
WHERE group_id IN (' . implode(', ', $groups_ids) . ')
ORDER BY group_type DESC, group_name';
$result = $_CLASS['core_db']->query($sql);
while ($row = $_CLASS['core_db']->fetch_row_assoc($result)) {
$group_auth_type = isset($auth_options['groups'][1][$row['group_id']]['core_status']) ? 1 : 0;
$group_list = $auth_options['groups'][$group_auth_type][$row['group_id']]['core_status'] ? 'allowed_group_list' : 'disallowed_group_list';
${$group_list} .= '<option' . ($group_auth_type == 1 ? ' style="color: #006699;"' : '') . ' value="' . $row['group_id'] . '">' . (isset($_CLASS['core_user']->lang['G_' . $row['group_name']]) ? $_CLASS['core_user']->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';
}
$_CLASS['core_db']->free_result($result);
}
$sql = 'SELECT group_id, group_name, group_type
FROM ' . GROUPS_TABLE . (empty($groups_ids) ? '' : ' WHERE group_id NOT IN (' . implode(', ', $groups_ids) . ')') . '
ORDER BY group_type DESC, group_name';
$result = $_CLASS['core_db']->query($sql);
while ($row = $_CLASS['core_db']->fetch_row_assoc($result)) {
$group_list .= '<option value="' . $row['group_id'] . '">' . (isset($_CLASS['core_user']->lang['G_' . $row['group_name']]) ? $_CLASS['core_user']->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';
}
$_CLASS['core_db']->free_result($result);
$_CLASS['core_template']->assign(array('P_ADD_GROUPS' => $group_list, 'P_CURRENT_USERS' => $allowed_user_list, 'P_DCURRENT_USERS' => $disallowed_user_list, 'P_CURRENT_GROUPS' => $allowed_group_list, 'P_DCURRENT_GROUPS' => $disallowed_group_list));
$_CLASS['core_template']->display('permission.html');
return $return;
}
function ucp_groups($id, $mode)
{
global $_CLASS, $site_file_root;
$_CLASS['core_user']->add_lang('groups');
$submit = isset($_POST['submit']) ? $_POST['submit'] : false;
if ($submit && !empty($_POST['group_id'])) {
if (is_array($_POST['group_id'])) {
$group_id = array_unique(get_variable('group_id', 'REQUEST', array(), 'array:int'));
} else {
if ($group_id = get_variable('group_id', 'REQUEST', false, 'interger')) {
$group_id = array($group_id);
} else {
die;
}
}
if (empty($group_id)) {
die;
//temp
}
require_once $site_file_root . 'includes/functions_user.php';
switch ($_POST['mode']) {
case 'resign':
$sql = 'SELECT m.member_status, g.group_id, g.group_type
FROM ' . USER_GROUP_TABLE . ' m, ' . GROUPS_TABLE . ' g
WHERE m.user_id = ' . $_CLASS['core_user']->data['user_id'] . '
AND m.group_id IN (' . implode(', ', $group_id) . ')';
$result = $_CLASS['core_db']->query($sql);
$unset = array();
while ($row = $_CLASS['core_db']->fetch_row_assoc($result)) {
if ($row['group_type'] == GROUP_SYSTEM && $row['group_type'] == GROUP_SPECIAL && $row['member_status'] != STATUS_PENDING) {
$unset[] = $row['user_id'];
}
}
$_CLASS['core_db']->free_result($result);
$group_id = array_diff($group_id, $unset);
unset($unset);
if (!empty($group_id)) {
groups_user_remove($group_id, $_CLASS['core_user']->data['user_id']);
}
break;
case 'apply':
$sql = 'SELECT group_id FROM ' . USER_GROUP_TABLE . '
WHERE user_id = ' . $_CLASS['core_user']->data['user_id'] . '
AND group_id IN (' . implode(', ', $group_id) . ')';
$result = $_CLASS['core_db']->query($sql);
$unset = array();
while ($row = $_CLASS['core_db']->fetch_row_assoc($result)) {
$unset[] = $row['group_id'];
}
$_CLASS['core_db']->free_result($result);
$group_id = array_diff($group_id, $unset);
unset($unset);
if (!empty($group_id)) {
$sql = 'SELECT group_id, group_status, group_type FROM ' . GROUPS_TABLE . '
WHERE group_id IN (' . implode(', ', $group_id) . ')';
$result = $_CLASS['core_db']->query($sql);
$group_id = array();
while ($row = $_CLASS['core_db']->fetch_row_assoc($result)) {
$status = $row['group_type'] == GROUP_UNRESTRAINED ? STATUS_ACTIVE : STATUS_PENDING;
if ($row['group_status'] == STATUS_ACTIVE) {
$group_id[$status][] = $row['group_id'];
}
}
$_CLASS['core_db']->free_result($result);
foreach ($group_id as $status => $ids) {
groups_user_add($ids, $_CLASS['core_user']->data['user_id'], $status);
}
}
break;
}
}
$error = $data = array();
$sql = 'SELECT g.group_id, g.group_name, g.group_description, g.group_type, ug.member_status
FROM ' . GROUPS_TABLE . ' g, ' . USER_GROUP_TABLE . ' ug
WHERE ug.user_id = ' . $_CLASS['core_user']->data['user_id'] . '
AND g.group_id = ug.group_id
ORDER BY g.group_type DESC, g.group_name';
$result = $_CLASS['core_db']->query($sql);
$group_array = array();
while ($row = $_CLASS['core_db']->fetch_row_assoc($result)) {
$row['group_status'] = STATUS_ACTIVE;
$block = $row['member_status'] == STATUS_LEADER ? 'leader' : ($row['member_status'] == STATUS_PENDING ? 'pending' : 'member');
$_CLASS['core_template']->assign_vars_array($block, array('GROUP_ID' => $row['group_id'], 'GROUP_NAME' => isset($_CLASS['core_user']->lang['G_' . $row['group_name']]) ? $_CLASS['core_user']->lang['G_' . $row['group_name']] : $row['group_name'], 'GROUP_DESC' => $row['group_description'], 'GROUP_RESIGN' => $row['member_status'] == STATUS_PENDING || $row['group_type'] != GROUP_SYSTEM && $row['group_type'] != GROUP_SPECIAL, 'U_VIEW_GROUP' => generate_link('Members_List&mode=group&g=' . $row['group_id']), 'S_GROUP_DEFAULT' => $row['group_id'] == $_CLASS['core_user']->data['user_group'] ? true : false));
$group_array[] = $row['group_id'];
}
$_CLASS['core_db']->free_result($result);
$sql_and = 'AND group_type NOT IN (' . GROUP_SYSTEM . ', ' . GROUP_HIDDEN . ')';
$sql = 'SELECT group_id, group_name, group_description, group_type
FROM ' . GROUPS_TABLE . '
WHERE group_id NOT IN (' . implode(', ', $group_array) . ')
AND group_status = ' . STATUS_ACTIVE . " {$sql_and}\n\t\t\tORDER BY group_type DESC, group_name";
$result = $_CLASS['core_db']->query($sql);
while ($row = $_CLASS['core_db']->fetch_row_assoc($result)) {
$_CLASS['core_template']->assign_vars_array('nonmember', array('GROUP_ID' => $row['group_id'], 'GROUP_NAME' => isset($_CLASS['core_user']->lang['G_' . $row['group_name']]) ? $_CLASS['core_user']->lang['G_' . $row['group_name']] : $row['group_name'], 'GROUP_DESC' => $row['group_description'], 'GROUP_APPLY' => true, 'U_VIEW_GROUP' => generate_link('Members_List&mode=group&g=' . $row['group_id'])));
}
$_CLASS['core_db']->free_result($result);
$_CLASS['core_template']->assign('S_UCP_ACTION', generate_link("Control_Panel&i={$id}&mode={$mode}"));
$this->display($_CLASS['core_user']->get_lang('UCP_GROUPS'), 'ucp_groups_membership.html');
}
function get_playoption($object_id)
{
?>
<ul class="nav nav-pills">
<li role="presentation" class="active"><a href="<?php
echo get_variable("player", $object_id);
?>
&object=<?php
echo $object_id;
?>
">
<span class="glyphicon glyphicon-play" aria-hidden="true"> Continua</a>
</li>
</ul>
<?php
}
$_CLASS['core_user']->add_lang('admin/blocks.php');
$mode = get_variable('mode', 'GET', false);
function check_type($type, $redirect = true)
{
$appoved_type = array(MODULE_NORMAL);
$type = (int) $type;
if (!in_array($type, $appoved_type, true)) {
if ($redirect) {
redirect(generate_link('modules', array('admin' => true, 'full' => true)));
}
return false;
}
return true;
}
if (isset($_REQUEST['mode'])) {
if ($id = get_variable('id', 'GET', false, 'integer')) {
switch ($_REQUEST['mode']) {
case 'change':
$result = $_CLASS['core_db']->query('SELECT module_name, module_status, module_type FROM ' . CORE_MODULES_TABLE . ' WHERE module_id = ' . $id);
$module = $_CLASS['core_db']->fetch_row_assoc($result);
$_CLASS['core_db']->free_result($result);
if (!$module) {
trigger_error('MODULE_NOT_FOUND');
}
check_type($module['module_type']);
$status = $module['module_status'] == STATUS_ACTIVE ? STATUS_DISABLED : STATUS_ACTIVE;
if (file_exists($site_file_root . 'modules/' . $module['module_name'] . '/configurator.php')) {
require_once $site_file_root . 'modules/' . $module['module_name'] . '/configurator.php';
$name = $module['module_name'] . '_configurator';
if (class_exists($name)) {
$module_configurer = new $name();
