# *********************************************************
# °³¹ßÀÚ : ÀÌ»óºÀ(webin)
#
# »ý¼ºÀÏ : 2001/06/29
# homepage : http://webin.sarang.net
# e-mail : webin@webin.sarang.net
# ICQ : 69796775
#
# CopyRight2001¨Ïwebin
# ¢Ñmade by sangbong lee¢Ð
#
# °³ÀÎÀûÀÎ »ç¿ëÀº ÇÁ¸®ÀÔ´Ï´Ù. ^^;
# »ó¾÷ÀûÀÎ ¿ëµµÀÇ »ç¿ëÀº °³¹ßÀÚÀÇ µ¿ÀǸ¦ ÇÊ¿ä·Î ÇÕ´Ï´Ù.
# *********************************************************
include "db_con.php";
//Àüü Ä«¿îÆ®
if(!$year){
$query = "select total from webin_static where id='$id' order by num desc limit 1";
}else{
$query = "select total from webin_static where id='$id' and year=$year and month=$month order by num desc limit 1";
}
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result) or die(mysql_error());
$total_count = $row[total];
mysql_free_result($result);
?>
Untitled Document
½Ã°£º° |
HIT |
½Ã°£º° Á¢¼Ó Åë°è |
// ÃÑ Ä«¿îÆ® ÀúÀå -> $total_day[$i], Ä«¿îÆ®À² ÀúÀå -> $per_day[$i]
$scale = 4.5;
$hour = array('time0','time1','time2','time3','time4','time5','time6','time7','time8','time9','time10','time11','time12','time13','time14','time15','time16','time17','time18','time19','time20','time21','time22','time23');
$hour_2 = array('0½Ã','1½Ã','2½Ã','3½Ã','4½Ã','5½Ã','6½Ã','7½Ã','8½Ã','9½Ã','10½Ã','11½Ã','12½Ã','13½Ã','14½Ã','15½Ã','16½Ã','17½Ã','18½Ã','19½Ã','20½Ã','21½Ã','22½Ã','23½Ã');
for($i=0; $i<24; $i++){
if(!$year){
$result = mysql_query("select SUM($hour[$i]) from webin_static where id='$id' and ${hour[$i]}>0 ");
}else{
$result = mysql_query("select SUM($hour[$i]) from webin_static where id='$id' and year=$year and month=$month and ${hour[$i]}>0 ");
}
$row = @mysql_fetch_array($result) or die(mysql_error());
$total_time[$i] = $row[0];
if($row[0]==""){ $row[0] = 0;}else{ $time_var++; }
$per_time[$i] = round(($total_time[$i]/$total_count)*100);
$width = $per_time[$i]*$scale;
echo "
$hour_2[$i] |
$row[0] |
${per_time[$i]}% |
";
} //for($i=0;$i<$num_day;$i++){
mysql_free_result($result);
$avr_count = $total_count / $time_var ;
$per_total = round(($avr_count/$total_count)*100);
$avr_width = $per_total*$scale;
$avr_count = substr($avr_count,0,5);
echo "
Æò±Õ |
$avr_count |
|
";
?>
|
include "db_close.php"; ?>