Manu, this is for you:
For Top Poster question;
../Source/SPortal.php
Find:
function sp_topPoster($topNumber = 5)
{
global $db_prefix, $scripturl, $memberContext, $txt, $top_posters, $top_poster_id, $list_no;
if ($topNumber === null)
$topNumber = isset($_GET['limit']) ? (int) $_GET['limit'] : 5;
$list_no=1;
// Find the latest poster.
$request = db_query("
SELECT ID_MEMBER, realName, posts
FROM {$db_prefix}members
ORDER BY posts DESC
LIMIT $topNumber", __FILE__, __LINE__);
$top_posters = array();
while ($row = mysql_fetch_assoc($request))
$top_posters[] = array(
'list' => $list_no++,
'id' => $row['ID_MEMBER'],
'name' => $row['realName'],
'href' => $scripturl . '?action=profile;u=' . $row['ID_MEMBER'],
'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">' . $row['realName'] . '</a>',
'posts' => $row['posts']
);
mysql_free_result($request);
$top_poster_id = $top_posters[0]['id'];
loadMemberData($top_poster_id);
loadMemberContext($top_poster_id);
}
Replace:
function sp_topPoster($topNumber = 5)
{
global $db_prefix, $scripturl, $memberContext, $txt, $settings, $modSettings, $top_posters, $top_poster_id, $list_no;
if ($topNumber === null)
$topNumber = isset($_GET['limit']) ? (int) $_GET['limit'] : 5;
$list_no=1;
// Find the latest poster.
$request = db_query("
SELECT m.ID_MEMBER, m.realName, m.posts, m.avatar, a.ID_ATTACH, a.attachmentType, a.filename
FROM ({$db_prefix}members as m)
LEFT JOIN {$db_prefix}attachments AS a ON (a.ID_MEMBER = m.ID_MEMBER)
ORDER BY posts DESC
LIMIT $topNumber", __FILE__, __LINE__);
$top_posters = array();
while ($row = mysql_fetch_assoc($request)) {
if (stristr($row['avatar'], 'http://') && !empty($modSettings['avatar_check_size']))
{
$sizes = url_image_size($row['avatar']);
// Does your avatar still fit the maximum size?
if ($modSettings['avatar_action_too_large'] == 'option_refuse' && is_array($sizes) && (($sizes[0] > $modSettings['avatar_max_width_external'] && !empty($modSettings['avatar_max_width_external'])) || ($sizes[1] > $modSettings['avatar_max_height_external'] && !empty($modSettings['avatar_max_height_external']))))
{
// Fix it permanently!
$row['avatar'] = '';
updateMemberData($row['ID_MEMBER'], array('avatar' => '\'\''));
}
}
$top_posters[] = array(
'list' => $list_no++,
'id' => $row['ID_MEMBER'],
'name' => $row['realName'],
'href' => $scripturl . '?action=profile;u=' . $row['ID_MEMBER'],
'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">' . $row['realName'] . '</a>',
'posts' => $row['posts'],
'avatar' => array(
'name' => $row['avatar'],
'image' => $row['avatar'] == '' ? ($row['ID_ATTACH'] > 0 ? '<img src="' . (empty($row['attachmentType']) ? $scripturl . '?action=dlattach;attach=' . $row['ID_ATTACH'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $row['filename']) . '" alt="" class="avatar" border="0" />' : '') : (stristr($row['avatar'], 'http://') ? '<img src="' . $row['avatar'] . '" alt="" class="avatar" border="0" />' : '<img src="' . $modSettings['avatar_url'] . '/' . htmlspecialchars($row['avatar']) . '" alt="" class="avatar" border="0" />'),
'href' => $row['avatar'] == '' ? ($row['ID_ATTACH'] > 0 ? (empty($row['attachmentType']) ? $scripturl . '?action=dlattach;attach=' . $row['ID_ATTACH'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $row['filename']) : '') : (stristr($row['avatar'], 'http://') ? $row['avatar'] : $modSettings['avatar_url'] . '/' . $row['avatar']),
'url' => $row['avatar'] == '' ? '' : (stristr($row['avatar'], 'http://') ? $row['avatar'] : $modSettings['avatar_url'] . '/' . $row['avatar']),
)
);
}
mysql_free_result($request);
}
../Themes/default/SPortal.template.php
Find:
sp_topPoster($modSettings['tppcount']);
$list_no = $list_no - 1;
foreach ($top_posters as $member)
{
if ($member['list'] == 1)
{
if (!empty($memberContext[$top_poster_id]['avatar']['href']))
echo '<table>
<tr>
<td>' . $member['list'] . '-</td>
<td><img src="'.$memberContext[$top_poster_id]['avatar']['href'].'" alt="" width="35" /></td><td> </td>
<td>' . $member['link'] . '<br />' . $member['posts'] . $txt['sp-tposterpost'] . '</td>
</tr>
</table>';
else
echo '<table>
<tr>
<td>' . $member['list'] . '-</td>
<td>' . $member['link'] . '</td>
<td> </td>
<td>' . $member['posts'] . $txt['sp-tposterpost'] . '</td>
</tr>
</table>';
}
elseif ($member['list'] == 2)
{
if ($member['list'] == $list_no)
echo '<table>
<tr>
<td>' . $member['list'] . '-</td>
<td>' . $member['link'] . '</td>
<td> </td>
<td>' . $member['posts'] . $txt['sp-tposterpost'] . '</td>
</tr>
</table>';
else
echo '<table>
<tr>
<td>' . $member['list'] . '-</td>
<td>' . $member['link'] . '</td>
<td> </td>
<td>' . $member['posts'] . $txt['sp-tposterpost'] . '</td>
</tr>';
}
elseif ($member['list'] == $list_no)
echo ' <tr>
<td>' . $member['list'] . '-</td>
<td>' . $member['link'] . '</td>
<td> </td>
<td>' . $member['posts'] . $txt['sp-tposterpost'] . '</td>
</tr>
</table>';
else
echo ' <tr>
<td>' . $member['list'] . '-</td>
<td>' . $member['link'] . '</td>
<td> </td>
<td>' . $member['posts'] . $txt['sp-tposterpost'] . '</td>
</tr>';
}
Replace:
sp_topPoster($modSettings['tppcount']);
echo '<table>';
foreach ($top_posters as $member)
{
if (!empty($member['avatar']['href']))
echo ' <tr>
<td>' . $member['list'] . '-</td>
<td><img src="' . $member['avatar']['href'] . '" alt="" width="35" /></td><td> </td>
<td>' . $member['link'] . '<br />' . $member['posts'] . $txt['sp-tposterpost'] . '</td>
</tr>';
else
echo ' <tr>
<td>' . $member['list'] . '-</td>
<td> </td><td> </td>
<td>' . $member['link'] . '<br />' . $member['posts'] . $txt['sp-tposterpost'] . '</td>
</tr>';
}
echo '</table>';
Cleanfiles;
Admin CP >> Features and Settings >> Portal Settings >> Board News | News board:
enter the id of the board that you create.