Alstublieft Mensen,
<?php
/* declaraties */
$domains_base = "/home/domains";
$history_file = "stats/webalizer.hist";
$hostname = "localhost";
$username = "user";
$dbName = "database";
$password = "password";
/* verbinding met de database */
MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database");
@mysql_select_db( "$dbName" ) or die( "Unable to select database");
function find_history_file($site)
{
global $domains_base;
global $history_file;
$current_dir = basename($site);
if (($current_dir == ".") OR ($current_dir == ".."))
{
return;
}
// echo "$domains_base $site $history_file <br>\n";
$stats_file = "$site" . "/" . "$history_file";
parse_history_file($current_dir, $stats_file);
}
function parse_history_file($site, $stats_file)
{
if (is_file($stats_file))
{
$row = 1;
$handle = fopen ("$stats_file","r");
while ($data = fgetcsv ($handle, 1000, " "))
{
// $num = count ($data);
// print "<p> $num fields in line $row: <br>\n";
$mbytes = round(($data[5] / 1024), 2);
$date = "$data[1]" . "-" . "$data[0]" . "-00";
// echo $date;
$query = "DELETE FROM stats WHERE site=\"$site\" AND date=\"$date\"";
$result = MYSQL_QUERY($query);
$query = "INSERT INTO stats (site, date, kbytes) values(\"$site\", \"$date\", $data[5])";
$result = MYSQL_QUERY($query) or die ("Kan nieuwe records niet in de database stoppen");
$row++;
}
fclose ($handle);
}
}
function scan_domains()
{
global $domains_base;
global $history_file;
if ($handle = opendir('/home/domains/'))
{
/* This is the correct way to loop over the directory. */
while (false !== ($file = readdir($handle)))
{
$directory = "$domains_base" . "/" . "$file";
if (is_dir($directory))
{
// echo "$file <br>\n";
find_history_file($directory);
}
}
closedir($handle);
}
}
function fetch_domains_list()
{
$query = "SELECT DISTINCT site FROM stats ORDER BY site";
$result = @MYSQL_QUERY($query) or die ("Kan de lijst met domeinnamen niet ophalen");
$number = @MYSQL_NUMROWS($result);
print "<form name=site action=\"sites_stats.php\" method=GET >";
print "<select name=site size=1 >";
if( $number == 0 )
{
// nothing to see here, move along
print "<option value=\"\">Leeg</option>";
}
$i = 0;
while ($i < $number)
{
$site = mysql_result($result,$i,"site");
print "<option value=\"$site\">$site</option>";
$i++;
}
print "</select>";
print "<input type=submit Value=Go >";
print "</form>";
}
function fetch_date_list()
{
$query = "SELECT DISTINCT date FROM stats ORDER BY date DESC";
$result = @MYSQL_QUERY($query) or die ("Kan de lijst met datums niet ophalen");
$number = @MYSQL_NUMROWS($result);
print "<form name=date action=\"sites_stats.php\" method=GET >";
print "<select name=date size=1 >";
if( $number == 0 )
{
// nothing to see here, move along
print "<option value=\"\">Leeg</option>";
}
$i = 0;
while ($i < $number)
{
$date = mysql_result($result,$i,"date");
print "<option value=\"$date\">$date</option>";
$i++;
}
print "</select>";
print "<input type=submit Value=Go >";
print "</form>";
}
function fetch_date_results($date)
{
$query = "SELECT SUM(kbytes) FROM stats WHERE date=\"$date\"";
$result = @MYSQL_QUERY($query) or die ("Kan de lijst met gegevens niet ophalen");
$number = @MYSQL_NUMROWS($result);
$totalkb = @MYSQL_FETCH_ROW($result);
$totalmb = round(($totalkb[0] / 1024), 2);
$totalgb = round(($totalkb[0] / 1048576), 2);
print "Totaal verkeer geserveerd door webserver: $totalmb MB / $totalgb GB";
$query = "SELECT * FROM stats WHERE date=\"$date\" ORDER BY kbytes DESC";
$result = @MYSQL_QUERY($query) or die ("Kan de lijst met gegevens niet ophalen");
$number = @MYSQL_NUMROWS($result);
print "<table border=1 >";
print "<tr><td>Site</td><td>Date</td><td>Traffic (MB)</td><td>Traffic (GB)</td></tr>";
if( $number == 0 )
{
// nothing to see here, move along
print "<tr><td>Leeg</td></tr>";
}
$i = 0;
while ($i < $number)
{
$site = mysql_result($result,$i,"site");
$kbytes = mysql_result($result,$i,"kbytes");
$mbytes = round(($kbytes / 1024), 2);
$gbytes = round(($kbytes / 1048576), 2);
print "<tr><td><a href=\"http://$site/\">$site</a> <a href=\"http://$site/stats/\">stats</a>
<a href=\"sites_stats.php?site=$site\">totals</a></td>
<td>$date</td><td>$mbytes MB</td><td>$gbytes GB</td></tr>";
$i++;
}
print "</table>";
}
function fetch_site_results($site)
{
$query = "SELECT SUM(kbytes) FROM stats WHERE site=\"$site\"";
$result = @MYSQL_QUERY($query) or die ("Kan de lijst met gegevens niet ophalen");
$number = @MYSQL_NUMROWS($result);
$totalkb = @MYSQL_FETCH_ROW($result);
$totalmb = round(($totalkb[0] / 1024), 2);
$totalgb = round(($totalkb[0] / 1048576), 2);
print "Totaal verkeer geserveerd door webserver: $totalmb MB / $totalgb GB";
$query = "SELECT * FROM stats WHERE site=\"$site\" ORDER BY date DESC";
$result = @MYSQL_QUERY($query) or die ("Kan de lijst met gegevens niet ophalen");
$number = @MYSQL_NUMROWS($result);
print "<table border=1 >";
print "<tr><td>Site</td><td>Date</td><td>Traffic (MB)</td><td>Traffic (GB)</td></tr>";
if( $number == 0 )
{
// nothing to see here, move along
print "<tr><td>Leeg</td></tr>";
}
$i = 0;
while ($i < $number)
{
$site = mysql_result($result,$i,"site");
$date = mysql_result($result,$i,"date");
$kbytes = mysql_result($result,$i,"kbytes");
$mbytes = round(($kbytes / 1024), 2);
$gbytes = round(($kbytes / 1048576), 2);
print "<tr><td>$site</td><td>$date</td><td>$mbytes MB</td><td>$gbytes GB</td></tr>";
$i++;
}
print "</table>";
}
if ($date == "")
{
if ($site == "")
{
scan_domains();
$today = date("Y-m-00");
header("Location: sites_stats.php?date=$today");
}
}
print "<html>";
print "<head><title>Traffic overzicht alle websites</title></head>";
print "<body>";
fetch_domains_list();
fetch_date_list();
if ($date)
{
fetch_date_results($date);
}
if ($site)
{
fetch_site_results($site);
}
MYSQL_CLOSE();
print "</body>";
print "</html>";
?>
En hier de db:
CREATE TABLE stats (
id int(11) NOT NULL auto_increment,
site varchar(50) NOT NULL default '',
date date NOT NULL default '0000-00-00',
kbytes int(32) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;