function useSess(){ session_start(); $_SESSION['sitename']="CRUMB"; //$_SESSION['isadmin']=0; $_SESSION['debug']=1; } function insertHead($thisTitle){ $t=$thisTitle; ?>
selectDatabase("coredatabase");
//echo("trying");
$sql = mysql_query("SELECT * FROM popularsearches ORDER BY frequency DESC", $link_id);
while ($row = mysql_fetch_row($sql)) {
if (trim($row[1])<>""){
if ($scount<24){
echo "$row[1]
";
}
$scount++;
}
}
}
function insertTopBlock($topLine, $subLine){
?>
search
}
function gatherInfo(){
if(1==0){
//do logging
selectDatabase("TrackingDatabase");
if($_GET[nolog]==$nothing){
//first deal with basic hit tracking
$sql="CREATE TABLE BAHits (id INT AUTO_INCREMENT PRIMARY KEY, yr TEXT, month TEXT, hits INT)";
$result = mysql_query($sql);
mysql_query("ALTER TABLE BAHits ADD dy TEXT");
$sql="CREATE TABLE BAHitDetail (id INT AUTO_INCREMENT PRIMARY KEY, yr TEXT, month TEXT, URL TEXT, hits INT)";
$result = mysql_query($sql);
$m=date("m");
$y=date("y");
$d=date("d");
$result = mysql_query("SELECT * FROM BAHits WHERE yr='$y' AND month='$m' AND dy='$d'");
$num_rows = mysql_num_rows($result);
//echo("rows=".$num_rows);
if($num_rows==0){
$sql="INSERT INTO BAHits (yr,month,hits,dy) VALUES('$y','$m',1,'$d')";
$result2 = mysql_query($sql);
}else{
$result = mysql_query("SELECT * FROM BAHits WHERE yr='$y' AND month='$m' AND dy='$d'");
$row=mysql_fetch_row($result);
$curval=$row[3];
$curval=($curval+1);
//echo("incremented is ".$curval);
$query="UPDATE BAHits set yr='$y', month='$m', hits=$curval, dy='$d' WHERE id='$row[0]'";
$result=mysql_query($query);
}
//now deal with USER AGENT TRACKING
$sql="CREATE TABLE AGENTHits (id INT AUTO_INCREMENT PRIMARY KEY, yr TEXT, month TEXT, hits INT)";
$result = mysql_query($sql);
mysql_query("ALTER TABLE AGENTHits ADD dy TEXT");
mysql_query("ALTER TABLE AGENTHits ADD AGENT TEXT");
$m=date("m");
$y=date("y");
$d=date("d");
$ag=$_SERVER['HTTP_USER_AGENT'];
$result = mysql_query("SELECT * FROM AGENTHits WHERE yr='$y' AND month='$m' AND dy='$d' AND AGENT='$ag'");
$num_rows = mysql_num_rows($result);
if($num_rows==0){
$sql="INSERT INTO AGENTHits (yr,month,hits,dy,AGENT ) VALUES('$y','$m',1,'$d','$ag')";
$result2 = mysql_query($sql);
}else{
$result = mysql_query("SELECT * FROM AGENTHits WHERE yr='$y' AND month='$m' AND dy='$d' AND AGENT='$ag'");
$row=mysql_fetch_row($result);
$curval=$row[3];
$curval=($curval+1);
//echo("incremented is ".$curval);
$query="UPDATE AGENTHits set yr='$y', month='$m', hits=$curval, dy='$d', AGENT='$ag' WHERE id='$row[0]'";
$result=mysql_query($query);
}
//now deal with individual page hit tracking
//now deal with USER AGENT TRACKING -- THIS NEEDS TS REMOVAL
$sql="CREATE TABLE PAGEHits (id INT AUTO_INCREMENT PRIMARY KEY, yr TEXT, month TEXT, hits INT)";
$result = mysql_query($sql);
mysql_query("ALTER TABLE PAGEHits ADD dy TEXT");
mysql_query("ALTER TABLE PAGEHits ADD PAGE TEXT");
$m=date("m");
$y=date("y");
$d=date("d");
$pg=$_SERVER['PHP_SELF']."?".$_SERVER['QUERY_STRING'];
$raw=$pg;
$stpos=strpos($raw,"&ts=");
$enpos=strpos($raw,'&',$stpos+1);
if($enpos<=stpos){
$enpos=1000;
}
if($stpos>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
?>