nie mam gdzie przetestowac ale powinno działac
[phpbb]#
#-----[ ZNAJDŹ W shoutbox_send.php ]-----------------------------------------
#
'SB_HIDE' => $hide_txt,
#
#-----[ WKLEJ PRZED ]-----------------------------------------
#
'L_MOST_ACTIVE' => ($overlib) ? $overlib_show : (($list) ? $lang['Shouters'].': ' : ''),
#
#-----[ ZNAJDŹ ]-----------------------------------------
#
$template->set_filenames(array(
'shoutbox' => 'shoutbox_send_body.tpl')
);
#
#-----[ WKLEJ PO ]-----------------------------------------
#
$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_level
FROM " . SHOUTBOX_TABLE . " a, " . USERS_TABLE . " b
WHERE b.user_id=a.sb_user_id
GROUP BY b.username, b.user_id, b.user_level. 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 = color_username($line['user_id'], $line['username'], $line['user_rank'], $line['user_posts']);
$line_user_name = $colored_username[0];
if($overlib)
{
$i++;
$percent = floor(($line['how_many']/$total)*100).'%';
$who_overlib = $colored_username[1];
$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[1];
$how_many = '(' . $line['how_many'] . ')';
$template->assign_block_vars('mostactive', array(
'WHO' => $who,
'HOW_MANY' => $how_many)
);
}
$shouters_under--;
}
#
#-----[ ZNAJDŹ W templates/styl/shoutbox_send_body.tpl ]-----------------------------------------
#
</form>
</tr>
#
#-----[ WKLEJ PO ]-----------------------------------------
#
<tr>
<td class="row1" align="center" valign="bottom" nowrap="nowrap"><span class="gensmall">{L_MOST_ACTIVE}
<!-- BEGIN mostactive -->
{mostactive.WHO}{mostactive.HOW_MANY}
<!-- END mostactive --></span></td>
</tr>
#
#-----[ EOM ]-----------------------------------------
#[/phpbb]
Autor postu otrzymał pochwałę
AIFM [1%] - kiedyś powstanie
Uwagi moderatora abc (dodane 20 Maj 2006, 20:03):
Ostatnio edytowany przez abc 20 Maj 2006, 20:03, edytowano w sumie 4 razy