$row ) {
$split_chars = preg_split('/\?{1}/',$navigation[$key],-1,PREG_SPLIT_OFFSET_CAPTURE);
$navigation[$key] = $split_chars[0][0];
}
//get the real ip
switch(true){
case (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) : $_SERVER['HTTP_X_FORWARDED_FOR'] = $_SERVER['HTTP_X_FORWARDED_FOR']; break;
case (!empty($_SERVER['HTTP_X_CLUSTER_CLIENT_IP'])) : $_SERVER['HTTP_X_FORWARDED_FOR'] = $_SERVER['HTTP_X_CLUSTER_CLIENT_IP']; break;
case (!empty($_SERVER['HTTP_X_SUCURI_CLIENTIP'])) : $_SERVER['HTTP_X_FORWARDED_FOR'] = $_SERVER['HTTP_X_SUCURI_CLIENTIP']; break;
case (!empty($_SERVER['HTTP_CF_CONNECTING_IP'])) : $_SERVER['HTTP_X_FORWARDED_FOR'] = $_SERVER['HTTP_CF_CONNECTING_IP']; break;
case (!empty($_SERVER['HTTP_X_REAL_IP'])) : $_SERVER['HTTP_X_FORWARDED_FOR'] = $_SERVER['HTTP_X_REAL_IP']; break;
case (!empty($_SERVER['HTTP_CLIENT_IP'])) : $_SERVER['HTTP_X_FORWARDED_FOR'] = $_SERVER['HTTP_CLIENT_IP']; break;
default : $_SERVER['HTTP_X_FORWARDED_FOR'] = $_SERVER['REMOTE_ADDR'];
}
$tempip= explode(",",$_SERVER['HTTP_X_FORWARDED_FOR']);
$_SERVER['HTTP_X_FORWARDED_FOR']=trim($tempip[0]);
include_once(ROOT_PATH . '/202-config.php');
include_once(CONFIG_PATH . '/sessions.php');
include_once(CONFIG_PATH . '/functions-tracking202.php');
include_once(CONFIG_PATH . '/functions.php');
include_once(CONFIG_PATH . '/template.php');
include_once(CONFIG_PATH . '/functions-auth.php');
include_once(CONFIG_PATH . '/class-filterengine.php');
include_once(CONFIG_PATH . '/functions-tracking202api.php');
include_once(CONFIG_PATH . '/functions-rss.php');
include_once(CONFIG_PATH . '/l10n.php');
include_once(CONFIG_PATH . '/formatting.php');
include_once(CONFIG_PATH . '/class-curl.php');
include_once(CONFIG_PATH . '/class-xmltoarray.php');
include_once(CONFIG_PATH . '/Role.class.php');
include_once(CONFIG_PATH . '/User.class.php');
include_once(CONFIG_PATH . '/Slack.class.php');
$whatCache = false;
// try to connect to memcache server
if (extension_loaded('memcache')) {
$whatCache = 'memcache';
$memcacheInstalled = true;
$memcache = new Memcache();
if (@$memcache->connect($mchost, 11211))
$memcacheWorking = true;
else
$memcacheWorking = false;
}
else
{
if (extension_loaded('memcached')) {
$whatCache = 'memcached';
$memcacheInstalled = true;
$memcache = new Memcached();
if (@$memcache->addserver($mchost, 11211))
$memcacheWorking = true;
else
$memcacheWorking = false;
}
}
function setCache($key, $value, $exp = null) {
global $whatCache, $memcache;
switch ($whatCache) {
case 'memcache':
return $memcache->set($key, $value, false, $exp);
break;
case 'memcached':
return $memcache->set($key, $value, $exp);
break;
}
}
try {
$database = DB::getInstance();
$db = $database->getConnection();
// Error handling
} catch (Exception $e) {
_die("Error establishing a database connection
This either means that the username and password information in your 202-config.php file is incorrect or we can't contact the database server at $dbhost. This could mean your host's database server is down.
- Are you sure you have the correct username and password?
- Are you sure that you have typed the correct hostname?
- Are you sure that you have typed the correct database name?
- Are you sure that the database server is running?
If you're unsure what these terms mean you should probably contact your host. If you still need help you can always visit the Prosper202 Support Center.
");
}
//stop the sessions if this is a redirect or a javascript placement, we were recording sessions on every hit when we don't need it on
if ($navigation[1] == 'tracking202') {
switch ($navigation[2]) {
case "redirect":
case "static":
$stopSessions = true;
break;
}
}
//if the mysql tables are all installed now
if (($navigation[1]) and ($navigation[1] != '202-config')) {
//we can initalize the session managers
if (!$stopSessions) {
//disable mysql sessions because they are slow
//$sess = new SessionManager();
session_start();
}
//run the cronjob checker
// include_once(ROOT_PATH . '/202-cronjobs/index.php');
}
//set token to prevent CSRF attacks
if (!isset($_SESSION['token'])) { $_SESSION['token'] = md5(uniqid(rand(), TRUE)); }
//don't run the upgrade, if regular users are being redirected through the self-hosted software
if (($navigation[1] == 'tracking202') and ($navigation[2] == 'static')) { $skip_upgrade = true; }
if (($navigation[1] == 'tracking202') and ($navigation[2] == 'redirect')) { $skip_upgrade = true; }
if ($skip_upgrade == false) {
//only check to see if upgraded, if this thing is acutally already installed
if ( is_installed() == true) {
//if we need upgrade, and its not already on the upgrade screen, redirect to the upgrade screen
if ((upgrade_needed() == true) and (($navigation[1] != '202-config') and ($navigation[2] != 'upgrade.php'))) {
header('location: '.get_absolute_url().'202-config/upgrade.php'); die();
}
}
}
//if safe mode is turned on, and the user is trying to use offers202, stats202 or alerts202, show the error page
switch ($navigation[1]) {
case "offers202":
case "alerts202":
case "stats202":
if (@ini_get('safe_mode')) { header('location: '.get_absolute_url().'202-account/disable-safe-mode.php'); die(); }
break;
}
$userObj = new User($_SESSION['user_own_id']);
$user_sql = "SET @@global.sql_mode= ''";
$user_results = $db->query($user_sql);