#!/usr/bin/php -q 
<?php
// You may have to change the path to php above many distros
// have it at /usr/local/bin/php
// Change this path to point to your lib-common.php file
include('/path/to/geeklog/lib-common.php');

$today = date("D d M Y",time()-86400);
$out = "Stats for " . $_CONF['site_name'] . " for " . $today . "\n";

$today = date("Ymd",time()-86400);

$result = DB_query("select pi_enabled from gl_plugins where pi_name='stats'");
$A = DB_fetchArray($result);
if ($A['pi_enabled']) {
	$result = DB_query("select count(distinct ip) as users, count(*) as pages from {$_TABLES['userstats']} where date='{$today}'");
	$A = DB_fetchArray($result);
	$out .= "\n{$A['users']} users and {$A['pages']} pageviews";
}
$result = DB_query("SELECT COUNT(*) AS count FROM {$_TABLES['stories']} WHERE (date >= (date_sub(NOW(), INTERVAL 1 day))) AND (date <= NOW()) AND (draft_flag = 0)");
$B = DB_fetchArray($result);
$result = DB_query("SELECT COUNT(*) AS count FROM {$_TABLES['comments']} WHERE (date >= (date_sub(NOW(), INTERVAL 1 day))) AND (date <= NOW())");
$C = DB_fetchArray($result);


$today = date("D d M Y",time()-86400);
$out .= "\n{$B['count']} new stories and {$C['count']} new comments\n\n";

if (file_exists("{$_CONF['path']}logs/access.log")) {

    $out .= "------------- Access.log --------------\n";


    exec("grep '^{$today}' {$_CONF['path']}logs/access.log",$buff);

    $i = 0;
    foreach($buff as $line) {
	$out .= "$line\n";
	$i = $i + 1;
    }
    $out .= "\n\n";
}

if (file_exists("{$_CONF['path']}logs/error.log")) {

    $out .= "------------- Error.log ---------------\n";

    unset($buff);
    exec("grep '^{$today}' {$_CONF['path']}logs/error.log",$buff);

    $i = 0;
    foreach($buff as $line) {
	$out .= "$line\n";
	$i = $i + 1;
   }
   $out .= "\n $i errors\n\n";

}

if (file_exists("{$_CONF['path']}logs/ban.log")) {

	$out .= "------------- Ban.log -----------------\n";

	unset($buff);
	exec("grep '^{$today}' {$_CONF['path']}logs/ban.log",$buff);

	$i = 0;
	foreach($buff as $line) {
		$out .= "$line\n";
		$i = $i + 1;
	}
	$out .= "\n $i Bans\n\n";
}

if (file_exists("{$_CONF['path']}logs/spamx.log")) {

	$out .= "------------- spamx.log ---------------\n";
	unset($buff);
	exec("grep '^{$today}' {$_CONF['path']}logs/spamx.log",$buff);

	$i = 0;
	foreach($buff as $line) {
		$out .= "$line\n";
		if (stristr($line,"Found Spam")) {
			$i = $i + 1;
			}
	}

	$out .= "\n $i Spam comments found\n";
}

COM_mail($_CONF['site_mail'],$_CONF['site_name'] . ' Stats for ' . $today,$out);

?>