no to było tak
Kod:
$lang['Shouters'] = 'Rozkrzyczani';
$lang['User'] = 'Użytkownik';
$lang['msg_cnt'] = 'Wiadomości';
$lang['msg_percent'] = 'Udział %';
$overlib = true; //true włącza overliba, false wyłącza
$list = true; //true włącza listę na dole shoutboxa, false wyłącza
$shouters_under = 3; //liczba użytkowników do wyświetlenia na dole shoutboxa
$shouters_overlib = 12; //liczba użytkowników do wyświetlenia w overlibie (powinna być większa lub równa liczbie powyżej)
$sql = "SELECT COUNT(*) AS 'how_many', b.username, b.user_id, b.user_rank, b.user_posts
FROM " . SHOUTBOX_TABLE . " a, " . USERS_TABLE . " b
WHERE b.user_id=a.sb_user_id
GROUP BY b.user_id, b.username, b.user_rank, b.user_posts
ORDER BY 'how_many' DESC
LIMIT $shouters_overlib";
$most_active = mysql_query($sql);
if($overlib)
{
$sql_2 = "SELECT COUNT(*) AS total FROM " . SHOUTBOX_TABLE;
$most_active_2 = mysql_query($sql_2);
$line_2 = mysql_fetch_array($most_active_2); $total = $line_2['total'];
}
$i=0;
while ($line = mysql_fetch_array($most_active))
{
$colored_username = cr($line);
$line_user_name = $colored_username[0];
if($overlib)
{
$i++;
$percent = floor(($line['how_many']/$total)*100).'%';
$who_overlib = '<span class=row2' . $colored_username[1] . '>' . $line_user_name . '</span>';
$who_overlib = str_replace("\"", "", $who_overlib);
if ($i%2!=0) $show_1 = '<tr><td align=center class=row1>' . $i . '. </td><td align=center class=row1>' . $who_overlib . '</td><td align=center class=row1>' . $line['how_many'] . '</td><td align=center class=row1>' . $percent . '</td></tr>';
else $show_1 = '<tr><td align=center class=row2>' . $i . '. </td><td align=center class=row2>' . $who_overlib . '</td><td align=center class=row2>' . $line['how_many'] . '</td><td align=center class=row2>' . $percent . '</td></tr>';
$show .= $show_1;
$overlib_show = '<span onMouseOver="return overlib(\'<left><table cellspacing=2 cellpadding=4 width=100%><tr><td align=center class=cat><b>#</b></td><td align=center class=cat><b>' . $lang['User'] . '</b></td><td align=center class=cat><b>' . $lang['msg_cnt'] . '</b></td><td align=center class=cat><b>' . $lang['msg_percent'] . '</b></td></tr>' . $show . '</table></left>\', ol_width=400, ol_offsetx=10, ol_offsety=10, ABOVE, CAPTION, \'<center>' . $lang['Shouters'] . '</center>\')" onMouseOut="nd();" style="cursor: pointer">' . $lang['Shouters'] . (($list) ? ': ' : '') . '</span> ';
}
if($list && $shouters_under>0)
{
$who = $colored_username;
$how_many = '(' . $line['how_many'] . ')';
$template->assign_block_vars('mostactive', array(
'WHO' => $who,
'HOW_MANY' => $how_many)
);
}
$shouters_under--;
}
Autor postu otrzymał pochwałę
AIFM [1%] - kiedyś powstanie
Uwagi moderatora abc (dodane 21 Maj 2006, 09:42):
Ostatnio edytowany przez abc 21 Maj 2006, 09:42, edytowano w sumie 2 razy