38 lines
1.4 KiB
PHP
38 lines
1.4 KiB
PHP
<?php
|
|
require 'lib/function.php';
|
|
require 'lib/layout.php';
|
|
if(!$posttime) $posttime=86400;
|
|
$time=ctime()-$posttime;
|
|
if($id){
|
|
$user=mysql_fetch_array(mysql_query("SELECT name FROM users WHERE id=$id"));
|
|
$from=" from $user[name]";
|
|
}else $from=' on the board';
|
|
$posts=mysql_query("SELECT count(*) AS cnt, FROM_UNIXTIME(date,'%k') AS hour FROM posts WHERE ".($id?"user=$id AND ":'')."date>$time GROUP BY hour");
|
|
if($posttime<999999999) $during=' during the last '.timeunits2($posttime);
|
|
$link="<a href=postsbytime.php?id=$id&posttime";
|
|
print "$header$smallfont
|
|
$link=3600>During last hour</a> |
|
|
$link=86400>During last day</a> |
|
|
$link=604800>During last week</a> |
|
|
$link=2592000>During last 30 days</a> |
|
|
$link=999999999>Total</a><br>
|
|
$fonttag Posts$from by time of day$during:
|
|
$tblstart
|
|
$tccellh width=40>Hour</td>
|
|
$tccellh width=50>Posts</td>
|
|
$tccellh> <tr>";
|
|
for($i=0;$i<24;$i++) $postshour[$i]=0;
|
|
while($h=mysql_fetch_array($posts)) $postshour[$h[hour]]=$h[cnt];
|
|
for($i=0;$i<24;$i++) if($postshour[$i]>$max) $max=$postshour[$i];
|
|
for($i=0;$i<24;$i++){
|
|
if($i) print '<tr>';
|
|
$bar="<img src=images/$numdir".'bar-on.gif width='.(@floor($postshour[$i]/$max*10000)/100).'% height=8>';
|
|
print "
|
|
$tccell2s>$i</td>
|
|
$tccell2s>$postshour[$i]</td>
|
|
$tccell2ls width=100%>$bar
|
|
";
|
|
}
|
|
print $tblend.$footer;
|
|
printtimedif($startingtime);
|
|
?>
|