cvs: docweb /scripts notes_stats.php notes_stats_output.php /www .cvsignore notes_stats.php

nlopess Fri Feb 4 06:20:36 2005 EDT Added files: /docweb/scripts notes_stats_output.php Removed files: /docweb/www notes_stats.php Modified files: /docweb/scripts notes_stats.php /docweb/www .cvsignore Log: generate the ouput of the notes stats in the cron job http://cvs.php.net/diff.php/docweb/scripts/notes_stats.php?r1=1.4&r2=1.5&ty=u Index: docweb/scripts/notes_stats.php diff -u docweb/scripts/notes_stats.php:1.4 docweb/scripts/notes_stats.php:1.5 --- docweb/scripts/notes_stats.php:1.4 Fri Feb 4 06:05:58 2005 +++ docweb/scripts/notes_stats.php Fri Feb 4 06:20:36 2005 @@ -17,7 +17,7 @@ | Vincent Gevers <vincent@php.net> | | Credits: Sean Coates <sean@php.net> | +----------------------------------------------------------------------+ -$Id: notes_stats.php,v 1.4 2005/02/04 11:05:58 nlopess Exp $ +$Id: notes_stats.php,v 1.5 2005/02/04 11:20:36 nlopess Exp $ */ require_once '../build-ops.php'; @@ -92,6 +92,18 @@ sqlite_close($sqlite); +/* write the output to the /www folder */ +ob_start(); +include './notes_stats_output.php'; +$output = ob_get_clean(); + +$fp = fopen(PATH_ROOT . '/www/notes_stats.php', 'w'); +fputs($fp, $output); +fclose($fp); + +/* end of the script */ + + /* Open a connection to a NTTP server */ function nntp_connect($server, $port = 119) { http://cvs.php.net/diff.php/docweb/www/.cvsignore?r1=1.8&r2=1.9&ty=u Index: docweb/www/.cvsignore diff -u docweb/www/.cvsignore:1.8 docweb/www/.cvsignore:1.9 --- docweb/www/.cvsignore:1.8 Sat Jan 22 02:03:44 2005 +++ docweb/www/.cvsignore Fri Feb 4 06:20:36 2005 @@ -1,2 +1,3 @@ robots.txt orphan_notes.php +notes_stats.php http://cvs.php.net/co.php/docweb/scripts/notes_stats_output.php?r=1.1&p=1 Index: docweb/scripts/notes_stats_output.php +++ docweb/scripts/notes_stats_output.php <?php /* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: +----------------------------------------------------------------------+ | PHP Documentation Site Source Code | +----------------------------------------------------------------------+ | Copyright (c) 1997-2005 The PHP Group | +----------------------------------------------------------------------+ | This source file is subject to version 3.0 of the PHP license, | | that is bundled with this package in the file LICENSE, and is | | available at through the world-wide-web at | | http://www.php.net/license/3_0.txt. | | If you did not receive a copy of the PHP license and are unable to | | obtain it through the world-wide-web, please send a note to | | license@php.net so we can mail you a copy immediately. | +----------------------------------------------------------------------+ | Authors: Vincent Gevers <vincent@php.net> | +----------------------------------------------------------------------+ $Id: notes_stats_output.php,v 1.1 2005/02/04 11:20:36 nlopess Exp $ */ echo "<?php require_once '../include/init.inc.php';"; $minact = 100; $DBFile = SQLITE_DIR.'notes_stats.sqlite'; if (@filesize($DBFile) < 10) { echo site_header('Statistics not available'); echo '<h2>Statistics not available</h2>'; echo site_footer(); exit; } $sqlite = sqlite_open($DBFile); $info = sqlite_fetch_array(sqlite_query($sqlite, 'SELECT * FROM info'), SQLITE_ASSOC); if ($info['last_article'] < 50000) { echo site_header('Statistics not available yet'); echo '<h2>Statistics not available yet</h2>'; echo site_footer(); exit; } echo "echo site_header('Note Statistics for " . date('j F Y', $info['build_date']) . "'); ?>"; ?> <h3><strong><?php echo $info['last_article']; ?></strong> subjects parsed</h1> <table border='0' cellspacing="10"><tr valign="top"><td valign="top"> <table border='0'> <tr> <th colspan="5" align="center">Total Editors Stats</th> </tr> <tr> <th>user</th> <th>deleted</th> <th>rejected</th> <th>modified</th> <th>total</th> </tr> <?php $array = sqlite_fetch_all(sqlite_query($sqlite, 'SELECT * FROM notes'), SQLITE_ASSOC); $time = time() - 60*60*24*180; foreach($array as $row) { @++$data[$row['who']][$row['action']]; @++$total[$row['who']]; @++$manual[$row['manpage']]; if ($row['time'] >= $time) { @++$data_new[$row['who']][$row['action']]; @++$data_new[$row['who']]['total']; } } unset($data['']); ksort($data); ksort($data_new); $bg = '#EBEBEB'; foreach ($data as $id => $c) { echo "<tr bgcolor=\""; $bg = ($bg == '#EBEBEB') ? '#BEBEBE' : '#EBEBEB'; echo "$bg\">\n\t<td>".$id."</td>\n\t<td>"; echo isset($c['deleted']) ? $c['deleted'] : '0'; echo "</td>\n\t<td>"; echo isset($c['rejected']) ? $c['rejected'] : '0'; echo "</td>\n\t<td>"; echo isset($c['modified']) ? $c['modified'] : '0'; echo "</td>\n\t<td>"; echo $total[$id]; echo "</td>\n</tr>\n"; } unset($data); ?> </table> </td><td valign="top"> Last half year (with more than <?php echo $minact; ?> actions counted) <table border='0'> <tr> <th colspan="5" align="center">Recent Editors stats</th> </tr> <tr> <th>user</th> <th>deleted</th> <th>rejected</th> <th>modified</th> <th>total</th> </tr> <?php $bg = '#EBEBEB'; foreach ($data_new as $id => $c) { if($c['total'] >= $minact) { echo "<tr bgcolor=\""; $bg = ($bg == '#EBEBEB') ? '#BEBEBE' : '#EBEBEB'; echo "$bg\">\n\t<td>".$id."</td>\n\t<td>"; echo isset($c['deleted']) ? $c['deleted'] : '0'; echo "</td>\n\t<td>"; echo isset($c['rejected']) ? $c['rejected'] : '0'; echo "</td>\n\t<td>"; echo isset($c['modified']) ? $c['modified'] : '0'; echo "</td>\n\t<td>"; echo $c['total']; echo "</td>\n</tr>\n"; } } unset($data_new); ?> </table> </td><td valign="top"> <table border='0'> <tr> <th colspan="3" align="center">Editors top 15</th> </tr> <tr> <th>rank</th> <th>user</th> <th>total</th> </tr> <?php arsort($total); $i = 0; foreach($total as $id => $val) { ++$i; echo "<tr bgcolor=\""; $bg = ($bg == '#EBEBEB') ? '#BEBEBE' : '#EBEBEB'; echo "$bg\">\n\t". "<td>".$i."</td>\n\t". "<td>".$id."</td>\n\t". "<td>".$val."</td>\n". "</tr>\n"; if ($i == 15) break; } unset($total); ?> </table> <br /> <table border='0'> <tr> <th colspan="3" align="center">Manual pages most active top 20</th> </tr> <tr> <th>rank</th> <th>page</th> <th>total</th> </tr> <?php arsort($manual); $i = 0; foreach($manual as $id => $c) { ++$i; echo "<tr bgcolor=\""; $bg = ($bg == '#EBEBEB') ? '#BEBEBE' : '#EBEBEB'; echo "$bg\">\n\t". "<td>".$i."</td>\n\t". "<td>".$id."</td>\n\t". "<td>".$c."</td>\n". "</tr>\n"; if ($i == 20) break; } ?> </table> </td></tr></table> <?php echo 'Last updated ' . date('r', $info['build_date']) . "\n"; sqlite_close($sqlite); echo '<?php echo site_footer(); ?>'; ?>