Popular Searches:

""){ if ($scount<24){ echo "$row[1]
"; } $scount++; } } } function insertTopBlock($topLine, $subLine){ ?>

0){ //echo("start=$stpos
"); //echo("end=$enpos
"); //echo("raw=".substr($raw,$stpos,$enpos-$stpos)."
"); $raw=substr($raw,$stpos,$enpos-$stpos); //echo("raw=$raw
"); } $temp=$pg; //$temp=str_replace($raw,"",$temp); //echo("temp=$temp
"); $temp2=str_replace($raw,"",$temp); //echo("temp2=$temp2
"); if($temp2==""){ $temp2=$row2[5]; } $result = mysql_query("SELECT * FROM PAGEHits WHERE yr='$y' AND month='$m' AND dy='$d' AND PAGE='$temp2'"); $num_rows = mysql_num_rows($result); if($num_rows==0){ $sql="INSERT INTO PAGEHits (yr,month,hits,dy,PAGE ) VALUES('$y','$m',1,'$d','$temp2')"; $result2 = mysql_query($sql); }else{ $result = mysql_query("SELECT * FROM PAGEHits WHERE yr='$y' AND month='$m' AND dy='$d' AND PAGE='$temp2'"); $row=mysql_fetch_row($result); $curval=$row[3]; $curval=($curval+1); //echo("incremented is ".$curval); $query="UPDATE PAGEHits set yr='$y', month='$m', hits=$curval, dy='$d', PAGE='$temp2' WHERE id='$row[0]'"; $result=mysql_query($query); } //now log hosts //now deal with USER AGENT TRACKING $sql="CREATE TABLE HOSTHits (id INT AUTO_INCREMENT PRIMARY KEY, yr TEXT, month TEXT, hits INT)"; $result = mysql_query($sql); mysql_query("ALTER TABLE HOSTHits ADD dy TEXT"); mysql_query("ALTER TABLE HOSTHits ADD HOST TEXT"); $m=date("m"); $y=date("y"); $d=date("d"); $pg=$_SERVER['REMOTE_ADDR']; $result = mysql_query("SELECT * FROM HOSTHits WHERE yr='$y' AND month='$m' AND dy='$d' AND HOST='$pg'"); $num_rows = mysql_num_rows($result); if($num_rows==0){ $sql="INSERT INTO HOSTHits (yr,month,hits,dy,HOST ) VALUES('$y','$m',1,'$d','$pg')"; $result2 = mysql_query($sql); }else{ $result = mysql_query("SELECT * FROM HOSTHits WHERE yr='$y' AND month='$m' AND dy='$d' AND HOST='$pg'"); $row=mysql_fetch_row($result); $curval=$row[3]; $curval=($curval+1); //echo("incremented is ".$curval); $query="UPDATE HOSTHits set yr='$y', month='$m', hits=$curval, dy='$d', HOST='$pg' WHERE id='$row[0]'"; $result=mysql_query($query); } //finally look for where linked from $sql="CREATE TABLE REFHits (id INT AUTO_INCREMENT PRIMARY KEY, yr TEXT, month TEXT, hits INT)"; $result = mysql_query($sql); mysql_query("ALTER TABLE REFHits ADD dy TEXT"); mysql_query("ALTER TABLE REFHits ADD REF TEXT"); $m=date("m"); $y=date("y"); $d=date("d"); $pg=$_SERVER['HTTP_REFERER']; $stpos=strpos($pg,"crumb.sunderland.ac.uk/~admin/beta"); if($stpos==false){ //echo("$pg tracking $stpos"); $result = mysql_query("SELECT * FROM REFHits WHERE yr='$y' AND month='$m' AND dy='$d' AND REF='$pg'"); $num_rows = mysql_num_rows($result); if($num_rows==0){ $sql="INSERT INTO REFHits (yr,month,hits,dy,REF ) VALUES('$y','$m',1,'$d','$pg')"; $result2 = mysql_query($sql); }else{ $result = mysql_query("SELECT * FROM REFHits WHERE yr='$y' AND month='$m' AND dy='$d' AND REF='$pg'"); $row=mysql_fetch_row($result); $curval=$row[3]; $curval=($curval+1); //echo("incremented is ".$curval); $query="UPDATE REFHits set yr='$y', month='$m', hits=$curval, dy='$d', REF='$pg' WHERE id='$row[0]'"; $result=mysql_query($query); } } } } } function insertFinalSideMenu(){ if(1==1){ gatherInfo(); //page tracking ?> $row[5]){ ?>