<?
function mydate() {
        $now = getdate();
        $h = $now['hours'];
        $min = $now['minutes'];
        $s = $now['seconds'];
        $y = $now['year'];
        $mon = $now['mon'];
        $day = $now['mday'];
        $xdate = mktime($h,$min,$s,$mon,$day,$y,-1);
        $mydate = date("Y-m-d H:i:s",$xdate);
return $mydate;
}

$dsn = 'mysql:host=localhost;dbname=wp_143285_dp8et5gy';
$user = 'wp_143285_bnysgi';
$password = 'Bw60WxKtYO';
$pdo = new PDO($dsn, $user, $password);

$sql= "SELECT * FROM ClickListTin WHERE ClickKey ='" .  $_GET['tid'] . "'";
$stmt = $pdo->query($sql);
$row =$stmt->fetchObject();
$passthru = $row->ClickLink;

//$save_ref = "INSERT INTO click_track2 (filename,referer,HitDate,HostIP,afid1,afid2) VALUES ('";
//$save_ref .= $passthru;
//$save_ref .= "','";
//$save_ref .= $_SERVER["HTTP_REFERER"];
//$save_ref .= "','";
//$save_ref .= mydate();
//$save_ref .= "','";
//$save_ref .= $_SERVER["REMOTE_ADDR"];
//$save_ref .= "','";
//$save_ref .= $_GET['tid'];
//$save_ref .= "','')";

//echo $save_ref;

//mysql_query($save_ref,$db) or die("Couldn't save ref.");

header("Location: " . $passthru, true, 301);
?>