Open: index.php
Zoek
Tip: Dit hoeft niet de volledige regel te zijn.
Voeg ervoor toe
Tip: Voeg deze regels code op een nieuwe regel, voor de positie van de zoekactie, toe.
Code: Selecteer alles
//Generate top poster list if required
if ($config['amount_top_posters'])
{
$top_posters = $config['amount_top_posters'];
$sql = "SELECT username, user_id, user_colour, user_posts
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . "
AND user_posts > 0
ORDER BY user_posts DESC LIMIT $top_posters";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not Query Top Posting Users', '', __LINE__, __FILE__, $sql);
}
$top_posters_list = '';
while ($row = $db->sql_fetchrow($result))
{
if ($row['user_colour'])
{
$user_colour = ' style="color:#' . $row['user_colour'] . '"';
$row['username'] = '<strong>' . $row['username'] . '</strong>';
}
else
{
$user_colour = '';
}
$top_posters_list .= (($top_posters_list != '') ? ', ' : '') . '<a' . $user_colour . ' href="' . append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&u=' . $row['user_id']) . '">' . $row['username'] . '</a> ('. $row['user_posts'] .')';
}
$db->sql_freeresult($result);
}
//Generate top poster list if required
if ($config['amount_top_posters'])
{
$top_posters = $config['amount_top_posters'];
// count top x posters
$sql = "SELECT username, user_id, user_colour, user_posts
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . "
AND user_posts > 0
ORDER BY user_posts DESC LIMIT $top_posters";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not Query Top Posting Users', '', __LINE__, __FILE__, $sql);
}
$top_posters_list = '';
while ($row = $db->sql_fetchrow($result))
{
if ($row['user_colour'])
{
$user_colour = ' style="color:#' . $row['user_colour'] . '"';
$row['username'] = '<strong>' . $row['username'] . '</strong>';
}
else
{
$user_colour = '';
}
$top_posters_list .= (($top_posters_list != '') ? ', ' : '') . '<a' . $user_colour . ' href="' . append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&u=' . $row['user_id']) . '">' . $row['username'] . '</a> ('. $row['user_posts'] .')';
}
$db->sql_freeresult($result);
// count x top posters in the last x hours
if ( $config['top_posters_hours'] )
{
$xhours = ( $config['top_posters_hours'] * 3600 );
$time = time() - $xhours;
$sql = "SELECT u.user_id, u.username, u.user_colour, COUNT(p.post_id) as total_posts
FROM " . USERS_TABLE . " u, " . POSTS_TABLE . " p
WHERE p.post_time > " . $time . "
AND u.user_id = p.poster_id
AND u.user_id <> " . ANONYMOUS . "
GROUP BY u.user_id
ORDER BY total_posts DESC LIMIT $top_posters";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not Query Top Posting Users', '', __LINE__, __FILE__, $sql);
}
$top_posters_hours_list = '';
while ($row = $db->sql_fetchrow($result))
{
if ($row['user_colour'])
{
$user_colour = ' style="color:#' . $row['user_colour'] . '"';
$row['username'] = '<strong>' . $row['username'] . '</strong>';
}
else
{
$user_colour = '';
}
$top_posters_hours_list .= (($top_posters_hours_list != '') ? ', ' : '') . '<i><a' . $user_colour . ' href="' . append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&u=' . $row['user_id']) . '">' . $row['username'] . '</a> ('. $row['total_posts'] .')</i>';
}
$db->sql_freeresult($result);
}
$top_posters_hours = ( $config['top_posters_hours'] == 1 ) ? $user->lang['TOP_POSTERS_HOUR'] : sprintf($user->lang['TOP_POSTERS_HOURS'],$config['top_posters_hours']);
}
Zoek
Tip: Dit hoeft niet de volledige regel te zijn.
Voeg erna toe
Tip: Voeg deze regels code op een nieuwe regel, na de positie van de zoekactie, toe.
Code:Selecteer alles
Code: Selecteer alles
'TOP_POSTERS' => $user->lang['TOP_POSTERS'],
'TOP_POSTERS_LIST' => $top_posters_list,
'TOP_POSTERS_HOURS' => $top_posters_hours,
'TOP_POSTERS_HOURS_LIST' => $top_posters_hours_list,