hello!
great job and nice mod!
i want to modify the mod. is it possible to show the last top user given the most comments at the last day?
my modification looks like this:
insert this
$time=time();
$m1 =60;
$h1 =$m1*60;
$T1 =$h1*24;
$T7 =$T1*7;
$T30=$T1*30;
(date("w",$time)==0) ? $date_w = 7 : $date_w = date("w",$time);
$ts_today_at_0 =mktime(0,0,0,date("m",$time),date("d",$time),date("Y",$time));
$ts_yesterday_at_0 =$ts_today_at_0-$T1;
$ts_1st_of_month =mktime(0,0,0,date("m",$time),1,date("Y",$time));
$ts_1st_of_month_before =mktime(0,0,0,date("m",$ts_1st_of_month-1),1,date("Y",$ts_1st_of_month-1));
$ts_this_monday =$ts_today_at_0-$T1*($date_w-1);
$ts_last_monday =$ts_this_monday-$T7;
$ts_24h_before =$time-$T1;
$ts_7days_before =$time-$T7;
$ts_30days_before =$time-$T30;
and change the order to this:
ORDER BY user_comments DESC
the problem is, i don't know where i have to insert the date...