session_start(); ?>
= $i){
$i = $offset;
$result[] = $offset;
}
}
}
$firstdot= $result[0];
$seconddot= $result[1];
$thirddot=$result[2];
$part1=substr ( $ip, 0, $firstdot);
$part2=substr ( $ip, $firstdot+1, $seconddot-$firstdot-1);
$part3=substr ( $ip, $seconddot+1, $thirddot-$seconddot-1);
$part4=substr ( $ip, $thirddot+1, 3);
$decimalip= $part1*16777216+$part2*65536+$part3*256+$part4;
$sql = "SELECT * FROM `iplist` WHERE `ipfrom` <= $decimalip and `ipto` >= $decimalip";
$countrylist = mysql_query($sql) or die("$sql");
$hits=mysql_num_rows ($countrylist);
$retval="Unknown";
if($hits>0){
$row = mysql_fetch_assoc($countrylist);
$retval=$row['country'];
}
// echo ("hits: ".$hits." IP: ".$ip." Decimal IP: ".$decimalip." Retval: ".$retval);
$_SESSION['country']=$retval;
$rawkeyword_string = $_GET['searchval']; // In case the search value is passed between pages
$referertext=$_SERVER['HTTP_REFERER'];
$_SESSION['refererstring']=$referertext;
$parsed_url=parse_url($referertext);
$querystring=$parsed_url;
$googleresult=strpos($parsed_url['host'],'google');
$yahooresult=strpos($parsed_url['host'],'yahoo');
$bingresult=strpos($parsed_url['host'],'bing');
$AOLresult=strpos($parsed_url['host'],'aol');
$askresult=strpos($parsed_url['host'],'ask.com');
$dogpileresult=strpos($parsed_url['host'],'dogpile.com');
if($googleresult !== false):
parse_str($parsed_url['query'],$parsed_query_string);
$rawkeyword_string=$parsed_query_string['q'].'[G]';
$_SESSION['keyword']=$rawkeyword_string;
$_SESSION['engine']="Google";
elseif($yahooresult !== false):
parse_str($parsed_url['query'],$parsed_query_string);
$rawkeyword_string=$parsed_query_string['p'].'[Y]';
$_SESSION['keyword']=$rawkeyword_string;
$_SESSION['engine']="Yahoo";
elseif($bingresult !== false):
parse_str($parsed_url['query'],$parsed_query_string);
$rawkeyword_string=$parsed_query_string['q'].'[B]';
$_SESSION['keyword']=$rawkeyword_string;
$_SESSION['engine']="Bing";
elseif($AOLresult !== false):
parse_str($parsed_url['query'],$parsed_query_string);
$rawkeyword_string=$parsed_query_string['query'].'[AOL]';
$_SESSION['keyword']=$rawkeyword_string;
$_SESSION['engine']="AOL";
elseif($askresult !== false):
parse_str($parsed_url['query'],$parsed_query_string);
$rawkeyword_string=$parsed_query_string['q'].'[Ask]';
$_SESSION['keyword']=$rawkeyword_string;
$_SESSION['engine']="Ask.com";
else:
$_SESSION['engine']="None";
$_SESSION['keyword']="None";
$destination="Landed";
endif;
} // Session variables are now defined
$keyword_string=rawurlencode($_SESSION['keyword']);
// Write to Database
$db = MYSQL_CONNECT($roothostname,$rootusername, $rootpassword) OR DIE("Unable to connect to database");
$db1 = mysql_select_db($dbName, $db) or die ("Couldn't select database.");
$time = date("Y-m-d H:i:s");
$justdate = date("Y-m-d");
$pagename="/reward_cards";
$ip=$_SESSION['hostip'];
$kw=$_SESSION['keyword'];
$country=$_SESSION['country'];
$engine=$_SESSION['engine'];
$thissession=session_id();
$qry="INSERT INTO `clicks` (`date_clicked` , `justdate`, `ip_address` , `page`, `keyword`,`engine`,`session`, `dest_url`, `country`) VALUES ('$time', '$justdate','$ip' , '$pagename' , '$kw', '$engine', '$thissession', '$destination', '$country');";
mysql_query($qry) or die("something went wrong");
$linkbase="';
// External links
$escapelink=$linkbase."Escape%20By%20Discover&searchval=".$keyword_string."'>";
$bestwesternlink=$linkbase."Best%20Western%20MasterCard&searchval=".$keyword_string."'>";
$mbnalink=$linkbase."MBNA%20PremierRewards&searchval=".$keyword_string."'>";
$mbnaworldpointslink=$linkbase."MBNA%20WorldPoints&searchval=".$keyword_string."'>";
$mbnaplatinumlink=$linkbase."MBNA%20Platinum%20Plus&searchval=".$keyword_string."'>";
$iberiaclassiclink=$linkbase."IBERIA%20Bank%20Classic&searchval=".$keyword_string."'>";
$amexpreferredlink=$linkbase."American%20Express%20Preferred%20Rewards%20Gold&searchval=".$keyword_string."'>";
$freedomlink=$linkbase."Chase Freedom Card&searchval=".$keyword_string."'>";
$zynclink=$linkbase."Zync from American Express&searchval=".$keyword_string."'>";
// $blueskylink=$linkbase."Blue Sky from American Express&searchval=".$keyword_string."'>";
// These have no keyword subid yet Use the carat to omit keyword
$americandreamlink=$linkbase."American%20DreamCard%20Mastercard&searchval="."^"."'>";
$iberiavisagoldlink=$linkbase."IBERIA%20Bank%20Visa%20Gold&searchval="."^"."'>";
$iberiavisaplatinumlink=$linkbase."IBERIA%20Bank%20Visa%20Platinum&searchval="."^"."'>";
?>
Credit Reports|3 Bureau Credit Report|Get Your Credit Report-CreditScoreQuick.com
|
Featured Offer
|
Check Out Our Offers And Apply For A Credit Card
Credit allows you to get more from every dollar you spend.
Choose from the following to see our best credit card offers:
|
|