// Groups to ignore
$groups = $config['comments_in_per_groups'];
// Counter
$i = 1;

$sql = $db->query( "SELECT autor, user_id, count(id) as comments_sum FROM ".PREFIX."_comments where date between '".$startDate."' and '".$endDate."' and autor not in (SELECT name FROM ".PREFIX."_users where user_group in (".$groups.")) and user_id != 0 group by autor order by count(id) DESC limit ".$limit );

$comments_in_period = "<div id=\\"utopBox\\">
    <div id=\\"popular\\" class=\\"block\\">
        <div class=\\"dtop\\"></div>
        <div class=\\"dcont\\">
        <div class=\\"utop-block\\">";

while( $row = $db->get_array($sql) ) {
if ($config['allow_alt_url'] == "yes") {
$user_link = "/user/".$row['autor']."/";
$userlink = "<a href=\\"".$user_link."\\" onclick=\\"ShowProfile('".$row['autor']."', '".$user_link."', '".$member_id['user_group']."'); return false;\\">";
} else {
$userlink = "<a href=\\"$PHP_SELF?subaction=userinfo&user=".$row['autor']."\\">";
}

$comments_in_period .="<div class=\\"utop_user\\" align=\\"center\\">";
$comments_in_period .="<span class=\\"hint-data\\" style=\\"display:none;\\"></span><div class=\\"utop_avatar\\">";
$comments_in_period .="<div class=\\"utop_user_number\\">".str_pad($i,1,"0",STR_PAD_LEFT)."</div>";
$comments_in_period .=$userlink;
$comments_in_period .="<img class=\\"utop_ava\\" src=\\"/uploads/fotos/".$row['foto']."\\" alt=\\"Аватар ".$row['autor']."\\" title=\\"".$row['autor']." на ".$i." месте<br />Комментариев: ".$row['comments_sum']."\\"/>";
$comments_in_period .="</a></div><div>";
$comments_in_period .=$userlink;
$comments_in_period .="<b>".$row['autor']."</b>";
$comments_in_period .="</a></div></div>";
    $i++;

    }

$comments_in_period .="</div></div><div class=\\"dbtm\\">&nbsp;</div></div></div>";

Источник: smartZone

Перейти на сайт

Другие материалы на сайте b.Z - Записки о гаджетах, людях и музыке