session_functions.php

jsp程序开发系统

		$tech = 1;
	} elseif (defined('ADMINZONE')) {
		$tech = 0;
	}

	$db->query("INSERT INTO $table SET
		sessionid = '" . mysql_escape_string($sessionid) . "',
		lastactivity = '$time',
		location = 'Logging in',
		useragent = '" . mysql_escape_string($_SERVER['HTTP_USER_AGENT']) . "',
		".$type."id = '" . mysql_escape_string($userid) . "'"
		. iff($type == 'tech', ", techzone = '$tech'")
	);

	// need to delete any other sessions set for this user
	if ($userid) {
		$db->query("
			DELETE FROM $table 
			WHERE ".$type."id = '" . mysql_escape_string($userid) . "' 
			AND sessionid != '" . mysql_escape_string($sessionid) . "'"
			. iff($type == 'tech', "AND techzone = '$tech'")
		);
	}

	$location = find_location($session);

	return array(
		'user_type' => $type,
		'sessionid' => $sessionid,
		'language' => $language,
		'lastactivity' => $time,
		'location' => $location,
		'userid' => $userid
	);
}

/*****************************************************
	function find_location

----- DESCRIPTION: -----------------------------------
	- if tech/admin we find where we are; pass in 
	  $session array

----- RETURNS:----------------------------------------
	the location

*****************************************************/

function find_location($session) {

	global $db;

	if ($session[user_type] == 'tech') {
		if (stristr($_SERVER['PHP_SELF'], '/admin/backup.php')) {
				$location = "Admin::Backup";
			} elseif (stristr($_SERVER['PHP_SELF'], '/admin/ban.php')) {
				switch ($_REQUEST['do']) {
					case 'update_email':
						$location = 'Admin::Bans::Adding/Editing E-mail';
						break;
					case 'update_ip':
						$location = 'Admin::Bans::Adding/Editing IP Address';
						break;
					case 'email':
						$location = 'Admin::Bans::Add E-mail Form';
						break;
					case 'ip':
						$location = 'Admin::Bans::Add/Edit IP Form';
						break;
					case 'ip':
						$location = 'Admin::Bans::Add/Edit IP Form';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], '/admin/category.php')) {
				switch ($_REQUEST['do']) {
					case 'settings':
						$location = 'Admin::Categories::View Category Settings';
						break;
					case 'cat_orders':
						$location = 'Admin::Categories::Updating Category Ordering';
						break;
					case 'delete':
						$location = 'Admin::Categories::Delete Category Form';
						break;
					case 'delete2':
						$location = 'Admin::Categories::Deleting Category';
						break;
					case 'add':
						$location = 'Admin::Categories::Add Category Form';
						break;
					case 'edit':
						$location = 'Admin::Categories::Edit Category Form';
						break;
					case 'add2':
						$location = 'Admin::Categories::Adding Category';
						break;
					case 'edit2':
						$location = 'Admin::Categories::Editing Category';
						break;
					case 'edit2':
						$location = 'Admin::Categories::Viewing Categories';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], '/admin/chat.php')) {
				switch ($_REQUEST['do']) {
					case 'update':
						$location = 'Admin::Chat::Update Settings Form';
						break;
					case 'list':
						$location = 'Admin::Chat::Viewing Chat Room Settings';
						break;
					case 'add':
						$location = 'Admin::Chat::Add Chat Room Form';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], '/admin/cron.php')) {
				switch ($_REQUEST['do']) {
					case 'list':
					case 'view':
						$location = 'Admin::Cron::Viewing Scheduled Tasks';
						break;
					case 'update':
					case 'update2':
						$location = 'Admin::Cron::Updating Task(s)';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/diagnose.php')) {
				switch ($_REQUEST['do']) {
					case 'mysql_vars':
						$location = 'Admin::Sanity Check::MySQL Vars';
						break;
					case 'mysql_status':
						$location = 'Admin::Sanity Check::MySQL Status';
						break;
					case 'table_status':
						$location = 'Admin::Sanity Check::Table Status';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/email.php')) {
				switch ($_REQUEST['do']) {
					case 'update':
						$location = 'Admin::E-mail Gateway::Updating Settings';
						break;
					case 'list':
					case 'view':
						$location = 'Admin::E-mail Gateway::Listing Gateway Accounts';
						break;
					case 'config':
						$location = 'Admin::E-mail Gateway::Viewing Settings';
						break;
					case 'add2':
						$location = 'Admin::E-mail Gateway::Adding Gateway Account';
						break;
					case 'delete':
						$location = 'Admin::E-mail Gateway::Deleting Gateway Account';
						break;
					case 'add':
					case 'edit':
						$location = 'Admin::E-mail Gateway::Add/Edit Gateway Account Form';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/emailtemplates.php')) {
				switch ($_REQUEST['do']) {
					case 'view':
						$location = 'Admin::E-mail Gateway::Viewing Templates';
						break;
					case 'edit2':
						$location = 'Admin::E-mail Gateway::Editing Template';
						break;
					case 'newcustom2':
						$location = 'Admin::E-mail Gateway::Adding Custom Template';
						break;
					case 'editcustom':
						$location = 'Admin::E-mail Gateway::Edit Custom Template Form';
						break;
					case 'newcustom':
						$location = 'Admin::E-mail Gateway::New Custom Template Form';
						break;
					case 'delete':
						$location = 'Admin::E-mail Gateway::Deleting Custom Template';
						break;
					case 'delete_all':
						$location = 'Admin::E-mail Gateway::Deleting ALL Custom Templates';
						break;
					case 'restore':
						$location = 'Admin::E-mail Gateway::Restoring Custom Template from Backup';
						break;
					case 'preg_replace':
						$location = 'Admin::E-mail Gateway::Search/Replace Form';
						break;
					case 'xhtml':
						$location = 'Admin::E-mail Gateway::XHTML Redirection';
						break;
					case 'xhtml2':
						$location = 'Admin::E-mail Gateway::XHTML Update';
						break;
					case 'preg_replace2':
						$location = 'Admin::E-mail Gateway::Search/Replace Execution';
						break;
					case 'find':
						$location = 'Admin::E-mail Gateway::Search Form';
						break;
					case 'find2':
						$location = 'Admin::E-mail Gateway::Search Execution';
						break;
					case 'translate2':
						$location = 'Admin::E-mail Gateway::Translation Execution';
						break;
					case 'translate':
						$location = 'Admin::E-mail Gateway::Translation Form';
						break;
					case 'export':
						$location = 'Admin::E-mail Gateway::Exporting Template';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/errors.php')) {
				switch ($_REQUEST['do']) {
					case '':
						$location = 'Admin::E-mail Gateway::Viewing Errors';
						break;
					case 'source':
						$location = 'Admin::E-mail Gateway::Viewing Error Details';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/escalate.php')) {
				switch ($_REQUEST['do']) {
					case 'delete':
						$location = 'Admin::Escalations::Deleting Escalation';
						break;
					case 'new2':
						$location = 'Admin::Escalations::Adding New Escalation';
						break;
					case 'edit2':
						$location = 'Admin::Escalations::Editing Escalation';
						break;
					case 'new':
					case 'edit':
						$location = 'Admin::Escalations::Add/Edit Escalation Form';
						break;
					case 'view':
						$location = 'Admin::Escalations::Viewing Escalations';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/filters.php')) {
				switch ($_REQUEST['do']) {
					default:
						$location = 'Admin::Filters::Other';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/help.php')) {
				$location = 'Admin::Help::Viewing Help Topic';
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/index.php')) {
				$location = 'Admin::Main Page';
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/languages.php')) {
				switch ($_REQUEST['do']) {
					case 'update':
						$location = 'Admin::Languages::Updating Language';
						break;
					case 'add':
						$location = 'Admin::Languages::Add Language Form';
						break;
					case 'new2':
						$location = 'Admin::Languages::Adding Language';
						break;
					case 'delete':
						$location = 'Admin::Languages::Deleting Language';
						break;
					case 'view':
						$location = 'Admin::Languages::Viewing Languages';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/payment.php')) {
				switch ($_REQUEST['do']) {
					default:
						$location = 'Admin::Payments';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/priority.php')) {
				switch ($_REQUEST['do']) {
					case 'settings':
						$location = 'Admin::Priorities::Viewing Priority Settings';
						break;
					case 'pri_orders':
						$location = 'Admin::Priorities::Re-Ordering Priorities';
						break;
					case 'delete':
						$location = 'Admin::Priorities::Delete Priority Form';
						break;
					case 'delete2':
						$location = 'Admin::Priorities::Deleting Priority';
						break;
					case 'add':
					case 'edit':
						$location = 'Admin::Priorities::Add/Edit Priority Form';
						break;
					case 'edit2':
						$location = 'Admin::Priorities::Editing Priority';
						break;
					case 'add2':
						$location = 'Admin::Priorities::Adding Priority';
						break;
					case 'view':
						$location = 'Admin::Priorities::Viewing Priorities';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/replace.php')) {
				switch ($_REQUEST['do']) {
					case 'add':
						$location = 'Admin::Replacement Variables::Add Form';
						break;
					case 'add2':
						$location = 'Admin::Replacement Variables::Adding';
						break;
					case 'delete':
						$location = 'Admin::Replacement Variables::Deleting';
						break;
					case 'view':
						$location = 'Admin::Replacement Variables::Viewing';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/reports.php')) {
				switch ($_REQUEST['do']) {
					case 'viewreports':
						$location = 'Admin::Reports::Listing Reports';
						break;
					case 'deletereports':
						$location = 'Admin::Reports::Deleting Report';
						break;
					case 'viewstats':
						$location = 'Admin::Reports::Listing Statistics';
						break;
					case 'editreport':
					case 'newreport':
						$location = 'Admin::Reports::Add/Edit Report Form';
						break;
					case 'newreport2':
					case 'editreport2':
						$location = 'Admin::Reports::Adding/Editing Report';
						break;
					case 'newstat2':
					case 'editstat2':
						$location = 'Admin::Reports::Adding/Editing Statistic';
						break;
					case 'editstat':
					case 'newstat':
						$location = 'Admin::Reports::Add/Edit Statistic';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/runreport.php')) {
				$location = 'Admin::Reports::Running Report';
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/settings.php')) {
				switch ($_REQUEST['do']) {
					case 'update':
						$location = 'Admin::Settings::Updating Setting';
						break;
					case 'list':
						$location = 'Admin::Settings::Listing Settings';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/spam.php')) {
				switch ($_REQUEST['do']) {
					case 'delete2':
						$location = 'Admin::Spam::Deleting Spam Entry';
						break;
					case 'edit':
					case 'add':
						$location = 'Admin::Spam::Add/Edit Spam Entry';
						break;
					case 'edit2':
						$location = 'Admin::Spam::Editing Spam Entry';
						break;
					case 'add2':
						$location = 'Admin::Spam::Adding Spam Entry';
						break;
					case 'view':
						$location = 'Admin::Spam::Viewing Spam Entries';
						break;
				}
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/stats.php')) {
				$location = 'Admin::Stats::Viewing Ticket Statistics';
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/online.php')) {
				$location = 'Admin::Stats::Viewing Technician Activity Log';
			} elseif (stristr($_SERVER['PHP_SELF'], 'admin/tech.php')) {
				switch ($_REQUEST['do']) {
					case 'email':
						$location = 'Admin::Spam::E-mail Techs Form';
						break;
					case 'email2':
						$location = 'Admin::Spam::E-mailing Techs';
						break;
					case 'add':
						$location = 'Admin::Spam::Add Tech Form';
						break;
					case 'submit':
					case 'update':
						$location = 'Admin::Spam::Adding/Editing Tech';
						break;
					case 'add2':
					case 'edit':
					case 'redo':
						$location = 'Admin::Spam::Add/Edit Tech Form';
						break;
					case 'delete':
						$location = 'Admin::Spam::Deleting Tech';
						break;
					case 'disable':
						$location = 'Admin::Spam::Disabling Tech';