স্ট্যাট

$month = 10;
$year = 2008;

$month_days=array();
$month_days[1]=31;
$month_days[2]=28;
$month_days[3]=31;
$month_days[4]=30;
$month_days[5]=31;
$month_days[6]=30;
$month_days[7]=31;
$month_days[8]=31;
$month_days[9]=30;
$month_days[10]=31;
$month_days[11]=30;
$month_days[12]=31;

$month_names=array();
$month_names[1]="জানুয়ারী";
$month_names[2]="ফেব্রুয়ারী";
$month_names[3]="মার্চ";
$month_names[4]="এপ্রিল";
$month_names[5]="মে";
$month_names[6]="জুন";
$month_names[7]="জুলাই";
$month_names[8]="আগস্ট";
$month_names[9]="সেপ্টেম্বর";
$month_names[10]="অক্টোবর";
$month_names[11]="নভেম্বর";
$month_names[12]="ডিসেম্বর";

$month_enames=array();
$month_enames[1]="January";
$month_enames[2]="February";
$month_enames[3]="March";
$month_enames[4]="April";
$month_enames[5]="May";
$month_enames[6]="June";
$month_enames[7]="July";
$month_enames[8]="August";
$month_enames[9]="September";
$month_enames[10]="October";
$month_enames[11]="November";
$month_enames[12]="December";

$month_day=$month_days[$month];
$month_name=$month_names[$month];

$start_date=mktime(0,0,0,$month,1,$year);
$end_date=mktime(0,0,0,$month+1,1,$year);

/*
$comments = db_fetch_object(db_query('SELECT COUNT(timestamp) AS count FROM {comments} WHERE timestamp >= %d AND timestamp < %d',$start_date, $end_date));
echo $month_name." এ মোট কমেন্ট সংখ্যা ".bnnum($comments->count).", গড়ে ".bnnum(round($comments->count/$month_day,2))." প্রতিদিন
";

$posts = db_fetch_object(db_query('SELECT COUNT(created) AS count FROM {node} WHERE created >= %d AND created < %d AND type in ("blog", "book", "audio")',$start_date, $end_date));
echo $month_name." এ মোট পোস্ট সংখ্যা ".bnnum($posts->count).", গড়ে ".bnnum(round($posts->count/$month_day,2))." প্রতিদিন
";

echo $month_name." এ মোট মন্তব্য/পোস্ট ".bnnum(round($comments->count/$posts->count,2)).
"
";

$comments = db_fetch_object(db_query('SELECT COUNT(timestamp) AS count FROM {comments}'));
echo "এ যাবৎ মোট কমেন্ট সংখ্যা ".bnnum($comments->count)."
";

$posts = db_fetch_object(db_query('SELECT COUNT(created) AS count FROM {node} WHERE type in ("blog", "book", "audio")'));
echo "এ যাবৎ মোট পোস্ট সংখ্যা ".bnnum($posts->count)."
";

echo "এ যাবৎ মোট মন্তব্য/পোস্ট ".bnnum(round($comments->count/$posts->count,2)).
"
";
*/

// একটি মাসের দিন প্রতি পোস্ট ও কমেন্ট
$month_first = 9;
$month_last = 10;
$year = 2008;

for($month=$month_first;$month<=$month_last;$month++) {
echo "

";

$month_day=$month_days[$month];
$month_name=$month_enames[$month];

// echo $month_name. " মাসে মন্তব্য ও পোস্ট
";
echo $month_name." ".$year. "
";
echo "Date - Comment - Post
";
echo "----------------------------------
";
for($day=1; $day<=$month_day; $day++) {
$start_date=mktime(0,0,0,$month,$day,$year);
$end_date=mktime(23,59,59,$month,$day,$year);

// echo $month_name." ".bnnum($day).", ". bnnum($year);
// echo " - ";

echo $month_name." ".$day.", ". $year;
echo " - ";

$comments = db_fetch_object(db_query('SELECT COUNT(timestamp) AS count FROM {comments} WHERE timestamp >= %d AND timestamp < %d',$start_date, $end_date));
// echo "মন্তব্য: ". bnnum($comments->count);
echo $comments->count;

echo " - ";

$posts = db_fetch_object(db_query('SELECT COUNT(created) AS count FROM {node} WHERE created >= %d AND created < %d AND type in ("blog", "book", "audio")',$start_date, $end_date));

// echo "পোস্ট: ". bnnum($posts->count);
echo $posts->count;

if($posts->count != 0) {
// echo ", ";

// echo "মন্তব্য/পোস্ট: ". bnnum(round($comments->count/$posts->count,2));
}

echo "
";

}

}

/*
echo "

";

$uinfolist=db_query('SELECT name, mail FROM {users} WHERE status=1');

$items = array();
while ($uinfo = db_fetch_object($uinfolist)) {
// $item = $uinfo->name ." <". $uinfo->mail. ">";
$item = $uinfo->mail;
echo $item."; ";
$items[] = $item;

}
// print theme('item_list', $items);
*/

?>