Untitled

<?
/* Get Variable Pass-thru Mod, by Mark -- http://ctrtard.com -- added 8-3-2010
This mod will allow you to pass additional variables to the P202 redirect. E.g.
$tracking202outbound = 'http://your202.com/tracking202/redirect/off.php?acip=123&pci='.$_COOKIE['tracking202pci'] . '&zip=10010';
*/
$stack ="";
foreach($_GET as $key => $value) {
    if ($key != "acip" AND $key != "pci"){
    $stack .= "&$key=" . urlencode($value);
    }
}
/* End Get Variable Pass-thru Mod */

#only allow numeric acip's
$acip = $_GET['acip'];
if (!is_numeric($acip)) die();

#cached redirects stored here:
$myFile = "cached/off-cached.csv";


# check to see if mysql connection works, if not fail over to cached .CSV stored redirect urls
include_once($_SERVER['DOCUMENT_ROOT'] . '/202-config.php');

$usedCachedRedirect = false;
$dbconnect = @mysql_connect($dbhost,$dbuser,$dbpass);
if (!$dbconnect) $usedCachedRedirect = true;

if ($usedCachedRedirect==false) $dbselect = @mysql_select_db($dbname);
if (!$dbselect) $usedCachedRedirect = true;

#the mysql server is down, use the txt cached redirect
if ($usedCachedRedirect==true) {

    $handle = @fopen($myFile, 'r');
    while ($row = @fgetcsv($handle, 100000, ",")) {

        //if a cached key is found for this t202id, redirect to that url
        if ($row[0] == $acip) {
            header('location: '. $row[1]);
            die();
        }
    }
    @fclose($handle);

    die("<h2>Error establishing a database connection - please contact the webhost</h2>");
}


include_once($_SERVER['DOCUMENT_ROOT'] . '/202-config/connect2.php');

/* OK FIRST IF THERE IS NO PUBLIC CLICK_ID, JUST REDIRECT TO THE NORMAL CAMPAIGN */
if (!$_GET['pci']) {

    $mysql['aff_campaign_id_public'] = mysql_real_escape_string($acip);
    $aff_campaign_sql = "SELECT   aff_campaign_rotate,
                                    aff_campaign_url,
                                    aff_campaign_url_2,
                                    aff_campaign_url_3,
                                    aff_campaign_url_4,
                                    aff_campaign_url_5,
                                    aff_campaign_name,
                                    aff_campaign_cloaking
                            FROM    202_aff_campaigns
                            WHERE   aff_campaign_id_public='".$mysql['aff_campaign_id_public']."'";
    $aff_campaign_row = memcache_mysql_fetch_assoc($aff_campaign_sql);

    if (empty($aff_campaign_row['aff_campaign_url'])) { die(); } //if there is no aff_url to redirect to DIEEEEEE!!!!!!! EEEEEE!!!

    #cache the results
    if ( is_writable(dirname(__FILE__) . '/cached' )) {

        #if the file does not exist create it
        if (!file_exists($myFile)) {
            $handle = @fopen($myFile, 'w');
            @fclose($handle);
        }

        # now save this link to the
        $handle = @fopen($myFile, 'r');
        $writeNewIndex = true;
        while (($row = @fgetcsv($handle, 100000, ",")) and ($writeNewIndex == true)) {
            if ($row[0] == $acip) $writeNewIndex = false;
        }
        @fclose($handle);

        if ($writeNewIndex) {
            //write this index to the txt file
            $newLine = "$acip, {$aff_campaign_row['aff_campaign_url']} \n";
            $newHandle = @fopen($myFile, 'a+');
            @fwrite($newHandle, $newLine);
            @fclose($newHandle);
        }
    }

    $redirect_site_url = rotateTrackerUrl($aff_campaign_row);
    //$redirect_site_url = $redirect_site_url . $click_id;
    $redirect_site_url = replaceTrackerPlaceholders($redirect_site_url,$click_id);

    /* Get Variable Pass-thru Mod */
    $redirect_site_url .= $stack;
    /* End Variable Pass-thru Mod */

    //ok if there is a url that exists, if redirect php style, or if its cloaked, redirect meta refresh style.
    if ($aff_campaign_row['aff_campaign_cloaking'] == 0) {

        //cloaking OFF, so do a php header redirect
        header('location: '.$redirect_site_url);

    } else {

        //cloaking ON, so do a meta REFRESH
        $html['aff_campaign_name'] = $aff_campaign_row['aff_campaign_name']; ?>

        <html>
            <head>
                <title><? echo $html['aff_campaign_name']; ?></title>
                <meta name="robots" content="noindex">
                <meta http-equiv="refresh" content="1; url=<? echo $redirect_site_url; ?>">
            </head>
            <body>

            <form name="form1" id="form1" method="get" action="/tracking202/redirect/cl2.php">
                <input type="hidden" name="q" value="<? echo $redirect_site_url; ?>"/>
            </form>
                <script type="text/javascript">
                    document.form1.submit();
                </script>

                <div style="padding: 30px; text-align: center;">
                    You are being automatically redirected to <? echo $html['aff_campaign_name']; ?>.<br/><br/>
                    Page Stuck? <a href="<? echo $redirect_site_url; ?>">Click Here</a>.
                </div>
            </body>
        </html>

 <? }

    //terminate this script, this is the end, if there was no public_click_id
    die();
}


/* ------------------------------------------------------- */
/* ------------------------------------------------------- */
/* ------------------------------------------------------- */
//
//
//
//  ANYTHING BELOW THIS ASSUMES THERE IS A PUBLIC CLICK ID
//
//
/* ------------------------------------------------------- */
/* ------------------------------------------------------- */
/* ------------------------------------------------------- */


$mysql['aff_campaign_id_public'] = mysql_real_escape_string($_GET['acip']);
$mysql['click_id_public'] = mysql_real_escape_string($_GET['pci']);

$info_sql = "
    SELECT
        2c.click_id,
        2c.user_id,
        click_filtered,
        landing_page_id,
        click_cloaking,
        click_cloaking_site_url_id,
        click_redirect_site_url_id,
        2ac.aff_campaign_id,
        aff_campaign_rotate,
        aff_campaign_url,
        aff_campaign_url_2,
        aff_campaign_url_3,
        aff_campaign_url_4,
        aff_campaign_url_5,
        aff_campaign_name,
        aff_campaign_cloaking,
        aff_campaign_payout
    FROM
        202_aff_campaigns AS 2ac,
        202_clicks_record AS 2cr
        LEFT JOIN 202_clicks AS 2c ON (2c.click_id = 2cr.click_id)
        LEFT JOIN 202_clicks_site AS 2cs ON (2cs.click_id = 2cr.click_id)
    WHERE
        2ac.aff_campaign_id_public='".$mysql['aff_campaign_id_public']."'
        AND 2cr.click_id_public='".$mysql['click_id_public']."'
";
$info_row = memcache_mysql_fetch_assoc($info_sql);


#cache the results
if ( is_writable(dirname(__FILE__) . '/cached' )) {

    #if the file does not exist create it
    if (!file_exists($myFile)) {
        $handle = @fopen($myFile, 'w');
        @fclose($handle);
    }

    # now save this link to the
    $handle = @fopen($myFile, 'r');
    $writeNewIndex = true;
    while (($row = @fgetcsv($handle, 100000, ",")) and ($writeNewIndex == true)) {
        if ($row[0] == $acip) $writeNewIndex = false;
    }
    @fclose($handle);

    if ($writeNewIndex) {
        //write this index to the txt file
        $newLine = "$acip, {$info_row['aff_campaign_url']} \n";
        $newHandle = @fopen($myFile, 'a+');
        @fwrite($newHandle, $newLine);
        @fclose($newHandle);
    }
}


$click_id = $info_row['click_id'];
$mysql['click_id'] = mysql_real_escape_string($click_id);
/****** THESES ARE THE VARIABLES I NEED TO UPDATE TO THE PUBLIC_CLICK_ID *********/

// click spy & clicks
//  aff_campaign_id
//  click_payout

$mysql['aff_campaign_id'] = mysql_real_escape_string($info_row['aff_campaign_id']);
$mysql['click_payout'] = mysql_real_escape_string($info_row['aff_campaign_payout']);

$update_sql = "
    UPDATE
        202_clicks AS 2c
        LEFT JOIN 202_clicks_spy AS 2cs ON (2c.click_id = 2cs.click_id)
    SET
        2c.aff_campaign_id='".$mysql['aff_campaign_id']."',
        2cs.aff_campaign_id='".$mysql['aff_campaign_id']."',
        2c.click_payout='".$mysql['click_payout']."',
        2cs.click_payout='".$mysql['click_payout']."'
    WHERE
        2c.click_id='".$mysql['click_id']."'
";
//this function delays the sql, because UPDATING is very very slow
delay_sql($update_sql);

//clicks_record
//  click_cloaking
//  click_out

$mysql['click_out'] = 1;

if (($info_row['click_cloaking'] == 1) or //if tracker has overrided cloaking on
    (($info_row['click_cloaking'] == -1) and ($info_row['aff_campaign_cloaking'] == 1)) or
    ((!isset($info_row['click_cloaking'])) and ($info_row['aff_campaign_cloaking'] == 1)) //if no tracker but but by default campaign has cloaking on
) {
    $cloaking_on = true;
    $mysql['click_cloaking'] = 1;
    //if cloaking is on, add in a click_id_public, because we will be forwarding them to a cloaked /cl/xxxx link
} else {
    $mysql['click_cloaking'] = 0;
}

$update_sql = "
    UPDATE
        202_clicks_record
    SET
        click_out='".$mysql['click_out']."',
        click_cloaking='".$mysql['click_cloaking']."'
    WHERE
        click_id='".$mysql['click_id']."'
";
delay_sql($update_sql);


//clicks_site
//  click_outbound_site_url_id='".$mysql['click_outbound_site_url_id']."',
//  click_cloaking_site_url_id='".$mysql['click_cloaking_site_url_id']."',
//  click_redirect_site_url_id='".$mysql['click_redirect_site_url_id']."'";

$outbound_site_url = 'http://'.$_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
$click_outbound_site_url_id = INDEXES::get_site_url_id($outbound_site_url);
$mysql['click_outbound_site_url_id'] = mysql_real_escape_string($click_outbound_site_url_id);

if ($cloaking_on == true) {
    $cloaking_site_url = 'http://'.$_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
}


$redirect_site_url = rotateTrackerUrl($info_row);
//$redirect_site_url = $redirect_site_url . $click_id;
$redirect_site_url = replaceTrackerPlaceholders($redirect_site_url,$click_id);

$click_redirect_site_url_id = INDEXES::get_site_url_id($redirect_site_url);
$mysql['click_redirect_site_url_id'] = mysql_real_escape_string($click_redirect_site_url_id);

$update_sql = "
    UPDATE
        202_clicks_site
    SET
        click_outbound_site_url_id='".$mysql['click_outbound_site_url_id']."',
        click_redirect_site_url_id='".$mysql['click_redirect_site_url_id']."'
    WHERE
        click_id='".$mysql['click_id']."'
";
delay_sql($update_sql);


//alright now the updates,
//WE WANT TO DELAY THESES UPDATES, in a MYSQL DATBASES? Or else the UPDATES lag the server, the UPDATES have to wait until it locks to update the server
//so what happens is if there not delayed, if someone is pulling MASSIVE queries on the t202 website, it'll wait till they load before our update runs,
//and that means if this update wasn't delayed it'd wait untill their queries were done on the site before moving forward.  Massive slowness, so we update delays theses in  cronjobs a at a lter time.


//ADD TO CLICK SUMMARY TABLE?

//update the click summary table if this is a 'real click'
#if ($info_row['click_filtered'] == 0) {

    $mysql['landing_page_id'] = mysql_real_escape_string($info_row['landing_page_id']);
    $mysql['user_id'] = mysql_real_escape_string($info_row['user_id']);

    //set timezone correctly
    $user_sql = "SELECT user_timezone FROM 202_users WHERE user_id='".$mysql['user_id']."'";
    $user_row = memcache_mysql_fetch_assoc($user_sql);
    AUTH::set_timezone($user_row['user_timezone']);


    $now = time();

    $today_day = date('j', time());
    $today_month = date('n', time());
    $today_year = date('Y', time());

    //the click_time is recorded in the middle of the day
    $click_time = mktime(12,0,0,$today_month,$today_day,$today_year);
    $mysql['click_time'] = mysql_real_escape_string($click_time);

    //check to make sure this click_summary doesn't already exist
    $check_sql = "SELECT  COUNT(*)
                  FROM    202_summary_overview
                  WHERE user_id='".$mysql['user_id']."'
                  AND     landing_page_id='".$mysql['landing_page_id']."'
                  AND     aff_campaign_id='".$mysql['aff_campaign_id']."'
                  AND     click_time='".$mysql['click_time']."'";
    $check_result = mysql_query($check_sql) or record_mysql_error($check_sql);
    $check_count = mysql_result($check_result,0,0);

    //if this click summary hasn't been recorded do this now
    if ($check_count == 0 ) {

        $insert_sql = "INSERT INTO 202_summary_overview
                        SET         user_id='".$mysql['user_id']."',
                                   landing_page_id='".$mysql['landing_page_id']."',
                                   aff_campaign_id='".$mysql['aff_campaign_id']."',
                                   click_time='".$mysql['click_time']."'";
        $insert_result = mysql_query($insert_sql);
    }
#}

//set the cookie
setClickIdCookie($mysql['click_id'],$mysql['aff_campaign_id']);

//NOW LETS REDIRECT

/* Get Variable Pass-thru Mod */
$redirect_site_url .= $stack;
/* End Variable Pass-thru Mod */

if ($cloaking_on == true) {

    //if cloaking is turned on, meta refresh out

?> <html>
    <head>
        <title><? echo $html['aff_campaign_name']; ?></title>
        <meta name="robots" content="noindex">
        <meta http-equiv="refresh" content="1; url=<? echo $redirect_site_url; ?>">
    </head>
    <body>

        <form name="form1" id="form1" method="get" action="/tracking202/redirect/cl2.php">
            <input type="hidden" name="q" value="<? echo $redirect_site_url; ?>"/>
        </form>
        <script type="text/javascript">
            document.form1.submit();
        </script>

        <div style="padding: 30px; text-align: center;">
            You are being automatically redirected to <? echo $html['aff_campaign_name']; ?>.<br/><br/>
            Page Stuck? <a href="<? echo $redirect_site_url; ?>">Click Here</a>.
        </div>
    </body>
</html>
<? } else {

    //if cloaking is turned off, php header redirect out
    header('location: '.$redirect_site_url);

}

die();