I really need help with my stats-script!!

[Michiel]

Hi,

I've been working on a stats-script for some time now and I'm experiencing some problems. The stats-script stores the data in .dat-files that are created by the php-script it self (when needed). I tried this on my own computer (Apache-server) and it work just like I planned it. When I uploaded the script to my internet server something strange happens: the .dat-files are created correctly, sometimes the data is written to it correctly and some-times not at all. Furthermore the .dat files cannot be deleted or edited via WS-ftp. When I try to view the stats the script prompts that 9.dat (the file for september) cannot be read. I don't understand what is going wrong. I hope someone would be kind enough to 'dig' through my code to find a solution! I've posted the code of my script below.

Thanx in advance Michiel

Code:

addstat.php

<?php

/* Browser-info */ 

if (eregi("MSIE ([0-9]+\.[0-9]+)", $HTTP_USER_AGENT, $regs)) 
   { 
   $name = "Internet Explorer"; 
   $version = $regs[1]; 
   }

elseif (eregi("Opera ([0-9]+\.[0-9]+)", $HTTP_USER_AGENT, $regs)) 
       { 
       $name = "Opera"; 
       $version = $regs[1]; 
       }

elseif (eregi("Mozilla/([0-9]+\.[0-9]+)", $HTTP_USER_AGENT, $regs)) 
       { 
       $name = "Netscape"; 
       $version = $regs[1]; 
       } 

else { 
     $name = "Overig"; 
     $version = ""; 
     }

$browser = $name." ".$version;


/* OS-info */

if (eregi("(win|windows)[ ]*((nt)*[ /]*([0-9]+(\.?[0-9]+))*)", $HTTP_USER_AGENT, $regs)) 
   $os = "Windows $regs[2]";

elseif (stristr($HTTP_USER_AGENT, "Linux")) 
       $os = "Linux"; 

elseif (stristr($HTTP_USER_AGENT, "Unix")) 
       $os = "Unix"; 

elseif (stristr($HTTP_USER_AGENT, "Mac")) 
       $os = "Macintosh"; 

else $os = "Overig"; 


// Register user's operating system
AddStat(os, $os, $thisyear);

// Register user's browser
AddStat(browser, $browser, $thisyear);

// Register user's screenresolution
AddStat(screenresolution, $ss, $thisyear);

// Register user's screencolors
AddStat(screencolors, $sc, $thisyear);

// Register user's referrer
AddStat(referrers, $ref, $thisyear);

// Register visitor

AddVisit($thishour, $thisday);

// Finaly update cookies
AddCookies();


/* Functions */

function AddStat($table, $new_value, $unique_visit) {

$dir = date("Y");

if (!is_dir($dir)) mkdir("$dir", 0777);

if (file_exists("$dir/$table.dat")) $fp=file("$dir/$table.dat");

else $fp=Array();

$match=false;

foreach ($fp as $line)
        {
        list($value,$hits,$unique)=explode('|',trim($line));
        $stat[$value]=Array('hits'=>$hits,'unique'=>$unique);
        if ($value==$new_value) $match=true;
        }

if ($match)
   {
   $stat[$new_value]['hits']++;
   if (!$unique_visit == 1) $stat[$new_value]['unique']++;
   }

else $stat[$new_value]=Array('hits'=>1,'unique'=>1);

if (!$fp = fopen("$dir/$table.dat", "w")) die("Couldn't open $dir/$table.dat for writing!");

foreach ($stat as $key=>$value)
        {
        $line="$key|{$value['hits']}|{$value['unique']}\r\n";
        fputs($fp,$line,strlen($line));
        }

fclose($fp);

}

function AddVisit($unique_visit_hour, $unique_visit_day) {

$dir = date("Y");
$table = date("n");
$new_day = date("j");
$new_hour = date("H");

if (!is_dir($dir)) mkdir("$dir", 0775);

if (file_exists("$dir/$table.dat")) $fp=file("$dir/$table.dat");

else $fp=Array();

$match=false;

foreach ($fp as $line)
        {
        list($day,$hour,$hits,$unique_hour,$unique_day)=explode('|',trim($line));
        $stat[$day][$hour]= Array('hits'=>$hits,'unique_hour'=>$unique_hour,'unique_day'=>$unique_day);
        if ($stat[$new_day][$new_hour]) $match=true;
        }

if ($match)
   {
   $stat[$new_day][$new_hour]['hits']++;
   if (!$unique_visit_hour == 1) $stat[$new_day][$new_hour]['unique_hour']++;
   if (!$unique_visit_day == 1) $stat[$new_day][$new_hour]['unique_day']++;
   }

else
   {
   if (!$unique_visit_day == 1)
      {
      $stat[$new_day][$new_hour]= Array('hits'=>1,'unique_hour'=>1,'unique_day'=>1);
      }
   else
      {
      $stat[$new_day][$new_hour]= Array('hits'=>1,'unique_hour'=>1,'unique_day'=>0);
      }
   }


if (!$fp = fopen("$dir/$table.dat", "w")) die("Couldn't open $dir/$table.dat for writing!");

foreach ($stat as $key=>$day)
        {
        $key_day = $key;
        foreach ($day as $key=>$hour)
                {
                $line ="$key_day|$key|{$hour['hits']}|{$hour['unique_hour']}|{$hour['unique_day']}\r\n";
                fputs($fp,$line,strlen($line));
		}
        }

fclose($fp);

}

function AddCookies() {

$now = time();

if (!$thishour)
   {
   $next_hour = mktime(date("G")+1, 0, 0, date("n"), date("d"), date("Y"));
   $sec_to_next_hour = $next_hour-$now;
   setcookie('thishour', '1', $sec_to_next_hour);
   }

if (!$thisday)
   {
   $next_day = mktime(0, 0, 0, date("n"), date("d")+1, date("Y"));
   $sec_to_next_day = $next_day-$now;
   setcookie('thisday', '1', $sec_to_next_day);
   }

if (!$thisyear)
   {
   $next_year = mktime(0, 0, 0, 1, 1, date("Y")+1);
   $sec_to_next_year = $next_year-$now;
   setcookie('thisyear', '1', $sec_to_next_year);
   }
}

?>

Part II in the next message

[Michiel]

Part II: (sorry for the large size)

showstat.php

<?php

function ShowUserStats($table) {

if (file_exists("$table.dat")) $fp=file("$table.dat");

else die("Couldn't open $table.dat for reading!");

foreach ($fp as $line)
        {
        list($value,$hits,$unique)=explode('|',trim($line));
        $stat[$value]=Array('hits'=>$hits,'unique'=>$unique);
        }


foreach ($stat as $key=>$value)
        {
        $hits = $value['hits'] * $factor;
        $unique = $value['unique'] * $factor;

    $hits_perc = ($value['hits'] /($value['hits'] + $value['unique'])) * 100;
    $hits_perc = round($hits_perc);

    print "<TABLE><TR><TD rowspan=\"2\">";
    print "<B>$key</B>";
    print "</TD><TD>";
    print "<IMG src=\"hits.gif\" height=\"10\" width=\"$hits\" border=\"1\"> {$value['hits']}";
    print "</TD><TR><TD>";
    print "<IMG src=\"unique.gif\" height=\"10\" width=\"$unique\" border=\"1\"> {$value['unique']}";
    print "</TD></TR></TABLE>";
    }

} 


function ShowStat($table) {

if (file_exists("$table.dat")) $fp=file("$table.dat");

else die("Could not open $table.dat for reading!");


foreach ($fp as $line)
        {
        list($value,$hits,$unique)=explode('|',trim($line));
        $stat[$value]= Array('hits'=>$hits,'unique'=>$unique);
        }

$i = 0;
foreach ($stat as $key=>$value)
        {
        $myvalue[$i] = $key;
        $myhits[$i] = $value['hits'];
        $myunique[$i] = $value['unique'];
        $i++;
        }
/*
for ($i = 0; $i < 24; $i++)
    {
    $myvalue[$i] = $stat[];
    $myhits[$i] = $stat[$i]['hits'] + 0;
    $myunique[$i] = $stat[$i]['unique_hour'] + 0;
    }
*/
PrintStats($table, $myvalue, $myhits, $myunique);
}

function ShowVisitMonth($table) {

print $table;

if (file_exists("$table.dat")) $fp=file("$table.dat");

else die("Could not open $table.dat for reading!");

foreach ($fp as $line)
        {
        list($day,$hour,$hits,$unique_hour,$unique_day)=explode('|',trim($line));
        $stat[$day][$hour]= Array('hits'=>$hits,'unique_hour'=>$unique_hour,'unique_day'=>$unique_day);
        }

for ($i = 1; $i < 32; $i++)
    {
    for ($j = 0; $j < 24; $j++)
        {
        $daily_hits[$i] = $daily_hits[$i] + $stat[$i][$j]['hits'];
        $daily_unique[$i] = $daily_unique[$i] + $stat[$i][$j]['unique_day'];
        }
    }

PrintVisits('Augustus 2002', $daily_hits, $daily_unique);
}


function ShowVisitDay($table, $the_day) {

if (file_exists("$table.dat")) $fp=file("$table.dat");

else die("Could not open $table.dat for reading!");


foreach ($fp as $line)
        {
        list($day,$hour,$hits,$unique_hour,$unique_day)=explode('|',trim($line));
        $stat[$day][$hour]= Array('hits'=>$hits,'unique_hour'=>$unique_hour,'unique_day'=>$unique_day);
        }


for ($i = 0; $i < 24; $i++)
    {
    $hourly_hits[$i] = $stat[$the_day][$i]['hits'] + 0;
    $hourly_unique[$i] = $stat[$the_day][$i]['unique_hour'] + 0;
    }

PrintVisits("$the_day Augustus 2002", $hourly_hits, $hourly_unique);
}

function PrintStats($title, $value, $hits, $unique) {

$max = max($hits);
$factor = 200 / $max;
$num = count($hits);

$sum = 0;
for ($i = 0; $i < $num; $i++)
    {
    $sum = $sum + $hits[$i];
    }

print "<TABLE bgcolor=\"#000000\" cellpadding=\"0\" cellspacing=\"1\"><TR><TD>";
print "<TABLE bgcolor=\"#eeeeee\" cellpadding=\"0\">";
print "<TR><TD><FONT face=\"arial\" size=\"2\"><B>$title</FONT><BR><IMG src=\"hits.gif\" width=\"10\" height=\"10\" border=\"1\"> <FONT face=\"arial\" size=\"1\">Hits<BR><IMG src=\"unique.gif\" width=\"10\" height=\"10\" border=\"1\"> <FONT face=\"arial\" size=\"1\">Unieke bezoekers</TD></TR>";
print "<TR><TD><TABLE>";

for ($i = 0; $i < $num; $i++)
    {
    $width_hits = $hits[$i] * $factor;
    $width_unique = $unique[$i] * $factor;
    $perc = round($hits[$i]/$sum * 100);
?>

<TR>
<TD><FONT face="arial" size="2"><?php print $value[$i] ?></TD>
<TD><IMG src="hits.gif" height="5" width="<?php print $width_hits ?>" border="1" vspace="1" alt="<?php print $hits[$i] ?>"><BR>
<IMG src="unique.gif" height="5" width="<?php print $width_unique ?>" border="1" vspace="1"alt="<?php print $unique[$i] ?>"></TD>
<TD><FONT face="arial" size="2"><?php print $perc ?>%</TD>
</TR>
<?php
    }
print "
</TABLE>
</TD>
</TR>";
print "</TABLE>";
print "</TD></TR></TABLE><BR>";
}

function PrintVisits($title, $hits, $unique) {

$max = max($hits);
if ($max == 0) $factor = 1;
else $factor = 200 / $max;
$num = count($hits);
print "<TABLE bgcolor=\"#000000\" cellpadding=\"0\" cellspacing=\"1\"><TR><TD>";
print "<TABLE bgcolor=\"#eeeeee\" cellpadding=\"0\">";
print "<TR><TD colspan=\"$num\"><FONT face=\"arial\" size=\"2\"><B>$title</FONT><BR><IMG src=\"hits.gif\" width=\"10\" height=\"10\" border=\"1\"> <FONT face=\"arial\" size=\"1\">Hits<BR><IMG src=\"unique.gif\" width=\"10\" height=\"10\" border=\"1\"> <FONT face=\"arial\" size=\"1\">Unieke bezoekers</TD></TR>";
print "<TR>";

for ($i = 0; $i < $num; $i++)
    {
    $height_hits = $hits[$i] * $factor;
    $height_unique = $unique[$i] * $factor;
?>
<TD valign="bottom">
<TABLE cellpadding="0" cellspacing="2">
<TR valign="bottom">
<TD>
<IMG src="hits.gif" width="5" height="<?php print $height_hits ?>" border="1" alt="<?php print $hits[$i] ?>">
</TD>
<TD>
<IMG src="unique.gif" width="5" height="<?php print $height_unique ?>" border="1" alt="<?php print $unique[$i] ?>">
</TD>
</TR>
<TR>
<TD colspan="2" align="center">
<FONT face="arial" size="1"><?php print "<A href=\"$PHP_SELF?today=$i\">$i"; ?></A>
</TD>
</TR>
</TABLE>
</TD>
<?php
    }
print "</TR></TABLE>";
print "</TD></TR></TABLE><BR>";
} 



ShowVisitMonth('9');

if (!IsSet($today))
   { 
   $today = date("j");
   }

ShowVisitDay('9', $today);

ShowStat('browser');

ShowStat('os');

ShowStat('screenresolution');

ShowStat('screencolors');

ShowStat('referrers');

?>

Thanx again, Michiel