1#@!#!123s

��JFIF�� 1#@!#!123s
: / home4 / mcspunei / MCS_Backup / shubha27Aug /
Filename : counter.php
back
<?php
include ('includes/config.php');
$dbtablehits= 'hits';
$dbtableinfo= 'info';
$maxrows = 50;
function addinfo($page)
{ 
	
	global $dbtablehits,$dbtableinfo,$maxrows,$db; 
    $pagecount = $db->Extract_Single("SELECT count(page) FROM $dbtablehits WHERE page = '$page'");
	
	
	if(!empty($pagecount))
	{
	
     	$updatecounter = $db->insertrec("UPDATE $dbtablehits SET count = count+1 WHERE page = '$page'");
		if (!$updatecounter) 
		{
		    //die ("Can't update the counter : " . mysql_error()); 
		}
	
	} 
	else
	{
	    $injquery="INSERT INTO $dbtablehits (page, count)VALUES ('$page', '1')";
		$query1 = strip_tags($injquery,'<a><p><em><i><strong><h1><h2><h3><h4><h5><h6><div>');

		$insert = $db->insertrec("$query1");
		
	
		if (!$insert) 
		{
    		//die ("Can\'t insert into $dbtablehits : " . mysql_error()); // remove ?
		}
	}
	
	$ip= $_SERVER["REMOTE_ADDR"]; 
	$agent =$_SERVER["HTTP_USER_AGENT"];
	$datetime = @date("Y/m/d") . ' ' . @date('H:i:s') ;

    $ipcount = $db->Extract_single("SELECT count(ip_address) FROM info WHERE ip_address = '$ip'");
	if(!empty($ipcount)) 
	{
		$adddata = $db->insertrec("INSERT INTO $dbtableinfo (ip_address, user_agent, datetime) VALUES('$ip' , '$agent','$datetime' ) ") ;
		if (!$adddata) 
		{
			//die('Could not add IP : ' . mysql_error()); // remove ?
		}
	}


	$num_rows = $db->Extract_single("SELECT count(*) as tot FROM $dbtableinfo");
	$to_delete = $num_rows- $maxrows;
	if($to_delete > 0)
	{
		for ($i = 1; $i <= $to_delete; $i++) 
		{

			$delete = $db->insertrec("DELETE FROM $dbtableinfo ORDER BY id LIMIT 1") ;
			if (!$delete) 
			{
				//die('Could not delete : ' . mysql_error()); // remove ?
			}
		}
	}	

}



function totalvisits(){
    $query = "SELECT SUM(count)  AS totalhits FROM hits"; 
	$result = $db->singlerec($query);
    foreach($result as $i=>$row)
    {
		$totalhits = $row['totalhits']  ;
	}
    if($totalhits ==0)
        return 0;
    else
        return $totalhits;
} 

?>