= $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="/insurance"; $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 $loanlink=$linkbase."Personal%20Loan&searchval=".$keyword_string."'>"; $allstatelink=$linkbase."Allstate%20Insurance&searchval=".$keyword_string."'>"; $smartcreditlink=$linkbase."smartcredit.com&searchval=".$keyword_string."'>"; // These have no keyword subid yet Use the carat to omit keyword // $idlookoutlink=$linkbase."ID%20Lookout&searchval="."^"."'>"; ?> Get Auto Insurance, Auto Insurance Quotes, Online Health and Life Insurance today at CreditScoreQuick.com
credit score quick
Services
Personal Loan
Qualify for a personal loan. Immediately access cash, and put money in your wallet. Get up to $15,000*
Personal Identity
Keep up with your account activity, collections, credit limit increases, credit inquires today!
Secured Credit Cards
Your deposit guarantes payment for the charges on your card in your interest earning savings account!
Free Credit Report
Information you need when dealing with creditors and helps you rebuilding credit.
My FICO
Monitor, improve, and protect your credit so that you can rest assured that your financial future is safe.
Insurance
Control access to your credit score
AllState Insurance
The Nations Largest Publicly Held Personal Lines Insurer

Allstate, Auto Insurance Made Easy!
 People who switched to Allstate saved an average of $353 per year.
 • Instant access 24/7
•Online or over the phone
• Fast, fair claims
• Guaranteed workmanship on repairs
Click Here
We represent highly rated carriers you know and trust.

Allstate
• People who switched to Allstate saved an average of $353 per year.
• Nearly 7 out of 10 people who switched to Allstate saved.
Get Your Quote Now!

 
Blogs

Google
Blog
Free Credit Report Tips and Faqs.

See how lenders, and creditors evaluate your credit history, and read articles for anyone wanting a higher credit score and understand credit reports.
Credit Report Articles

 

Credit Blog Opt-in
web-based news readers. Choose My Yahoo, Rojo, newsgator, My AOL, Google, and Pageflakes.

 
Better Business Bureau