<h2>File Contents: /home/planet5/www/tracking/202-config/connect.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/www/tracking/202-config/connect.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
$version = &#039;1.9.55&#039;;

DEFINE(&#039;TRACKING202_RSS_URL&#039;, &#039;http://rss.tracking202.com&#039;);
DEFINE(&#039;TRACKING202_ADS_URL&#039;, &#039;https://ads.tracking202.com&#039;);

//fix for nginx with no server name set
if($_SERVER[&#039;SERVER_NAME&#039;]==&#039;_&#039;){
    $_SERVER[&#039;SERVER_NAME&#039;]=$_SERVER[&#039;HTTP_HOST&#039;];
}

DEFINE(&#039;ROOT_PATH&#039;, substr(dirname( __FILE__ ), 0,-10));
DEFINE(&#039;CONFIG_PATH&#039;, dirname( __FILE__ ));
@ini_set(&#039;auto_detect_line_endings&#039;, TRUE);
@ini_set(&#039;register_globals&#039;, 0);
@ini_set(&#039;display_errors&#039;, &#039;On&#039;);
@ini_set(&#039;error_reporting&#039;, 6135);
@ini_set(&#039;safe_mode&#039;, &#039;Off&#039;);
@ini_set(&#039;set_time_limit&#039;, 0);

if(!$_SESSION[&#039;user_timezone&#039;])
{
   date_default_timezone_set(&#039;GMT&#039;);
} else {
	date_default_timezone_set($_SESSION[&#039;user_timezone&#039;]);
}

mysqli_report(MYSQLI_REPORT_STRICT);

$install_path = substr(ROOT_PATH,strlen($_SERVER[&#039;DOCUMENT_ROOT&#039;]));

$re = &#039;/\b(api|tracking202|202-\w+).*/&#039;;
$str = $_SERVER[&#039;REQUEST_URI&#039;];
preg_match_all($re, $str, $matches, PREG_SET_ORDER, 0);
$navigation=$matches[0][0];
$navigation = &#039;/&#039;.$navigation;

$navigation = explode(&#039;/&#039;, $navigation);
foreach($navigation as $key =&gt; $row ) {    
	$split_chars = preg_split(&#039;/\?{1}/&#039;,$navigation[$key],-1,PREG_SPLIT_OFFSET_CAPTURE); 
	$navigation[$key] = $split_chars[0][0];
}  

//get the real ip
switch(true){
    case (!empty($_SERVER[&#039;HTTP_CF_CONNECTING_IP&#039;])) : $_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;] = $_SERVER[&#039;HTTP_CF_CONNECTING_IP&#039;]; break;  
    case (!empty($_SERVER[&#039;HTTP_X_CLUSTER_CLIENT_IP&#039;])) : $_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;] = $_SERVER[&#039;HTTP_X_CLUSTER_CLIENT_IP&#039;]; break;
    case (!empty($_SERVER[&#039;HTTP_X_SUCURI_CLIENTIP&#039;])) : $_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;] = $_SERVER[&#039;HTTP_X_SUCURI_CLIENTIP&#039;]; break;
    case (!empty($_SERVER[&#039;HTTP_X_REAL_IP&#039;])) : $_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;] = $_SERVER[&#039;HTTP_X_REAL_IP&#039;]; break;
    case (!empty($_SERVER[&#039;HTTP_CLIENT_IP&#039;])) : $_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;] = $_SERVER[&#039;HTTP_CLIENT_IP&#039;]; break;
    case (!empty($_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;]) &amp;&amp; ($_SERVER[&#039;SERVER_ADDR&#039;] != $_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;])) : $_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;] = $_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;]; break;
          default : $_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;] = $_SERVER[&#039;REMOTE_ADDR&#039;];
  }
    

    $tempip= explode(&quot;,&quot;,$_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;]);
    $_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;]=trim($tempip[0]);
    $ip_address=ipAddress($_SERVER[&#039;HTTP_X_FORWARDED_FOR&#039;]);

if(file_exists(ROOT_PATH  . &#039;202-config.php&#039;)){
    include_once(ROOT_PATH  . &#039;202-config.php&#039;);    
}else{
     header(&#039;location: setup-config.php&#039;); die();
}  
include_once(ROOT_PATH  . &#039;202-config.php&#039;);
include_once(CONFIG_PATH . &#039;/sessions.php&#039;); 
include_once(CONFIG_PATH . &#039;/functions-tracking202.php&#039;);
include_once(CONFIG_PATH . &#039;/functions.php&#039;);
include_once(CONFIG_PATH . &#039;/template.php&#039;);

include_once(CONFIG_PATH . &#039;/functions-auth.php&#039;);
include_once(CONFIG_PATH . &#039;/class-filterengine.php&#039;);

include_once(CONFIG_PATH . &#039;/functions-tracking202api.php&#039;);
include_once(CONFIG_PATH . &#039;/functions-rss.php&#039;);
include_once(CONFIG_PATH . &#039;/l10n.php&#039;);
include_once(CONFIG_PATH . &#039;/formatting.php&#039;);
include_once(CONFIG_PATH . &#039;/class-curl.php&#039;);
include_once(CONFIG_PATH . &#039;/class-xmltoarray.php&#039;);
include_once(CONFIG_PATH . &#039;/Role.class.php&#039;);
include_once(CONFIG_PATH . &#039;/User.class.php&#039;);
include_once(CONFIG_PATH . &#039;/Slack.class.php&#039;);

$whatCache = false;

// try to connect to memcache server
if (extension_loaded(&#039;memcache&#039;)) {
    $whatCache = &#039;memcache&#039;;
    $memcacheInstalled = true;
    $memcache = new Memcache();
    if (@$memcache-&gt;connect($mchost, 11211))
        $memcacheWorking = true;
    else
        $memcacheWorking = false;
}
else
{
    if (extension_loaded(&#039;memcached&#039;)) {
        $whatCache = &#039;memcached&#039;;
        $memcacheInstalled = true;
        $memcache = new Memcached();
        if (@$memcache-&gt;addserver($mchost, 11211))
            $memcacheWorking = true;
        else
            $memcacheWorking = false;
    }    
}  

function setCache($key, $value, $exp = null) {
    global $whatCache, $memcache;
    switch ($whatCache) {
        case &#039;memcache&#039;:
            return $memcache-&gt;set($key, $value, false, $exp);
            break;

        case &#039;memcached&#039;:
            return $memcache-&gt;set($key, $value, $exp);
            break;
    }
}

function ipAddress($ip_address){
    $ip = new stdClass;

    if (filter_var($ip_address, FILTER_VALIDATE_IP)) {
        $ip-&gt;address=$ip_address;
        if (filter_var($ip_address, FILTER_VALIDATE_IP, FILTER_FLAG_IPV4)) {
            $ip-&gt;type=&#039;ipv4&#039;;
        } else {
            $ip-&gt;type=&#039;ipv6&#039;;
        }
    } else {
        $ip-&gt;type=&#039;invalid&#039;;
    }

    return $ip;
}

function inet6_ntoa($ip){
    return @inet_ntop($ip);
}

function inet6_aton($ip){
    return @inet_pton($ip);
}


try {
	$database = DB::getInstance();
	$db = $database-&gt;getConnection(); 
	// Error handling
	} catch (Exception $e) {
		_die(&quot;&lt;h6&gt;Error establishing a database connection&lt;/h6&gt;
			&lt;p&gt;&lt;small&gt;This either means that the username and password information in your &lt;code&gt;202-config.php&lt;/code&gt; file is incorrect or we can&#039;t contact the database server. This could mean your host&#039;s database server is down.&lt;/small&gt;&lt;/p&gt;
			&lt;small&gt;
			&lt;ul&gt; 
				&lt;li&gt;Are you sure you have the correct username and password?&lt;/li&gt;
				&lt;li&gt;Are you sure that you have typed the correct hostname?&lt;/li&gt;
				&lt;li&gt;Are you sure that you have typed the correct database name?&lt;/li&gt;
				&lt;li&gt;Are you sure that the database server is running?&lt;/li&gt;
			&lt;/ul&gt;
			&lt;/small&gt; 
			&lt;p&gt;&lt;small&gt;If you&#039;re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the &lt;a href=&#039;http://support.tracking202.com&#039;&gt;Prosper202 Support Center&lt;/a&gt;.&lt;/small&gt;&lt;/p&gt;
		&quot;);
}

//stop the sessions if this is a redirect or a javascript placement, we were recording sessions on every hit when we don&#039;t need it on
if ($navigation[1] == &#039;tracking202&#039;) { 
	switch ($navigation[2]) { 
		case &quot;redirect&quot;:
		case &quot;static&quot;:
			$stopSessions = true;
			break;
	}
} 
		
//if the mysql tables are all installed now
if (($navigation[1]) and ($navigation[1] != &#039;202-config&#039;)) {
	
	//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 . &#039;/202-cronjobs/index.php&#039;); 
}

//set token to prevent CSRF attacks
if (!isset($_SESSION[&#039;token&#039;])) { $_SESSION[&#039;token&#039;] = md5(uniqid(rand(), TRUE)); }


//don&#039;t run the upgrade, if regular users are being redirected through the self-hosted software
if (($navigation[1] == &#039;tracking202&#039;) and ($navigation[2] == &#039;static&#039;)) { $skip_upgrade = true; }
if (($navigation[1] == &#039;tracking202&#039;) and ($navigation[2] == &#039;redirect&#039;)) { $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] != &#039;202-config&#039;) and ($navigation[2] != &#039;upgrade.php&#039;))) {
			header(&#039;location: &#039;.get_absolute_url().&#039;202-config/upgrade.php&#039;); 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 &quot;offers202&quot;:
	case &quot;alerts202&quot;:
	case &quot;stats202&quot;:
		if (@ini_get(&#039;safe_mode&#039;)) { header(&#039;location: &#039;.get_absolute_url().&#039;202-account/disable-safe-mode.php&#039;); die();  }
		break;
}

$userObj = new User($_SESSION[&#039;user_own_id&#039;]);

if(!$_SESSION[&#039;ipv6&#039;]){
    $sql=&quot;select inet6_ntoa(0x00000000000000000000000000000001) as ipv6&quot;;
    $result = $db-&gt;query($sql);
    
    if($result){
        $_SESSION[&#039;ipv6&#039;]=&quot;ipv6&quot;;
    }else{
        $_SESSION[&#039;ipv6&#039;]=&#039;&#039;;
    }  
}

if(isset($_SESSION[&#039;ipv6&#039;]) &amp;&amp; $_SESSION[&#039;ipv6&#039;] != &#039;&#039;){
    $inet6_ntoa=&#039;inet6_ntoa&#039;; //decodes for display etc
    $inet6_aton=&#039;inet6_aton&#039;; //encodes for db
}
else{
    $inet6_ntoa=&#039;&#039;;
    $inet6_aton=&#039;&#039;;    
}

$user_sql = &quot;SET session sql_mode= &#039;&#039;&quot;;
$user_results = $db-&gt;query($user_sql);

function updateBlazerCache(&amp;$mysql,$blazerCacheType=&#039;&#039;){
	global $db;
	
	switch ($blazerCacheType) {
		case &#039;ac&#039;:
			$bc_results=($db-&gt;query(&quot;SELECT DISTINCT tracker_id_public from 202_trackers WHERE aff_campaign_id = 1&quot;));
		
		while($bc_row = $bc_results-&gt;fetch_assoc()){
			$bc_key=&quot;td_&quot;.$bc_row[&#039;tracker_id_public&#039;];
			setCache($bc_key, $mysql[&#039;aff_campaign_url&#039;]);
		}
		break;
		
		default:
			# code...
		
		break;
	}
	
}</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fwww%2Ftracking%2F202-config'>⬅ Back to Directory</a>