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); $countryval="Unknown"; $stateval=" "; $cityval=" "; if($hits>0){ $row = mysql_fetch_assoc($countrylist); $countryval=$row['country']; $stateval=$row['state']; $cityval=$row['city']; } // echo ("hits: ".$hits." IP: ".$ip." Decimal IP: ".$decimalip." Retval: ".$retval); $_SESSION['country']=$countryval; $_SESSION['state']=$stateval; $_SESSION['city']=$cityval; $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"); $ip=$_SESSION['hostip']; $kw=$_SESSION['keyword']; $country=$_SESSION['country']; $engine=$_SESSION['engine']; $thissession=session_id(); $referertext=$_SESSION['referer']; $pagename="toolsarticle"; $qry="INSERT INTO `clicks` (`date_clicked` , `justdate`, `ip_address` , `page`, `keyword`,`engine`,`session`, `dest_url`, `country`, `referer`, `city`, `state`) VALUES ('$time', '$justdate','$ip' , '$pagename' , '$kw', '$engine', '$thissession', '$destination', '$country','$referertext','$cityval','$stateval');"; mysql_query($qry) or die("something went wrong"); ?>
Tips for Reducing Your Credit Card DebtMillions of people have a credit card account, and often more than one. Most people who have credit cards hold some kind of balance on the card, which is also known as credit card debt. The average credit card debt per household is $16,007. This debt can last for years and can often be difficult to pay off because of the attached interest rate. Fortunately, there are ways to reduce this debt faster and to keep track of what credit card debt you have. First, it's important to try and stop spending money using a credit card. Credit cards should only be used for emergencies when there is not enough cash to cover the cost. Buying things on impulse with a credit card is a surefire way to increase your debt and make it more difficult to pay off later. Find out how much debt you currently carry, and how much you owe monthly. Knowing how much your monthly expenses are on your credit card payments can be a real wake up call.
For those who have a balance on their credit card, the best way to eliminate it is to pay the balance off in full each month. This way, your debt total is completely reduced monthly. As you spend money, try to replace it by also adding the same amount into a savings account. This is a good way to discipline yourself and help you save as well as pay off debt. Create a budget for yourself and your family, and try not to spend money outside of that budget. Budgets are an excellent way to help create a boundary and guideline that will provide you with a better way to gauge how much you spend, and where your money goes. Try to track your spending, and make a list of things you want versus things you need. Include monthly bills such as a mortgage or rent payment, car payment, and utilities. Be sure to include your credit card payments into the budget as well as your spending tracking.
An essential part of paying off credit cards is coming up with a game plan. Remember that paying only the monthly minimum amount due will only add to the amount of time it takes to pay the total debt off. In addition, interest continues to grow and the time spent to pay off the debt increases. Come up with some kind of payoff plan, and determine how much over the monthly minimum you will pay, along with how many months it will take to pay off the total due in full. Create a spreadsheet or some other type of file, so you can track your progress. Coming up with new strategies, especially minimizing spending and maximizing saving, will help you to get rid of that pesky credit card debt much more quickly.
|