['maxMsgID'] - 20 * $showlatestcount) . "
AND t.ID_TOPIC = m.ID_TOPIC
AND b.ID_BOARD = t.ID_BOARD" . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? "
AND b.ID_BOARD != $modSettings[recycle_board]" : '') . "

// Find all boards and categories, as well as related information.  This will be sorted by the natural order of boards and categories, which we control.

// Statistics such as number of boards, categories, etc. full top 10 ivan_ . . .
$result = db_query("
SELECT COUNT(b.ID_BOARD)
FROM {$db_prefix}boards AS b", __FILE__, __LINE__);
list ($context['num_boards']) = mysql_fetch_row($result);
mysql_free_result($result);

$result = db_query("
SELECT COUNT(c.ID_CAT)
FROM {$db_prefix}categories AS c", __FILE__, __LINE__);
list ($context['num_categories']) = mysql_fetch_row($result);
mysql_free_result($result);

$context['num_members'] = &$modSettings['totalMembers'];
$context['num_posts'] = &$modSettings['totalMessages'];
$context['num_topics'] = &$modSettings['totalTopics'];
$context['most_members_online'] = array(
'number' => &$modSettings['mostOnline'],
'date' => timeformat($modSettings['mostDate'])
);
$context['latest_member'] = &$context['common_stats']['latest_member'];


// Poster full top 10. ivan_ . . .


$members_result = db_query("
SELECT ID_MEMBER, realName, posts
FROM {$db_prefix}members
ORDER BY posts DESC
LIMIT 10", __FILE__, __LINE__);
$context['top_posters'] = array();
$max_num_posts = 1;
while ($row_members = mysql_fetch_assoc($members_result))
{
$context['top_posters'][] = array(
'name' => $row_members['realName'],
'id' => $row_members['ID_MEMBER'],
'num_posts' => $row_members['posts'],
'href' => $scripturl . '?action=profile;u=' . $row_members['ID_MEMBER'],
'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['ID_MEMBER'] . '">' . $row_members['realName'] . '</a>'
);

if (!empty($modSettings['MemberColorStats']))
$MemberColor_ID_MEMBER[$row_members['ID_MEMBER']] = $row_members['ID_MEMBER'];

if ($max_num_posts < $row_members['posts'])
$max_num_posts = $row_members['posts'];
}
mysql_free_result($members_result);

foreach ($context['top_posters'] as $i => $poster)
$context['top_posters'][$i]['post_percent'] = round(($poster['num_posts'] * 100) / $max_num_posts);

if (!empty($modSettings['latestMember']) && !empty($modSettings['MemberColorLatestMember']))
$MemberColor_ID_MEMBER[$modSettings['latestMember']] = $modSettings['latestMember'];
 
        //Yeah baby give me some colors =).
if (!empty($MemberColor_ID_MEMBER)) {
//Now Load the Missing global :)
global $user_profile;
loadMemberData($MemberColor_ID_MEMBER);
$cmemcolid = NULL;
if (!empty($modSettings['MemberColorStats'])) {
// Poster top.
foreach($context['top_posters'] as $key => $value) {
$cmemcolid = $context['top_posters'][$key]['id'];
$profile = &$user_profile[$cmemcolid];
if(!empty($profile['member_group_color']) || !empty($profile['post_group_color']))
$context['top_posters'][$key]['link'] = '<a href="' . $scripturl . '?action=profile;u=' . $profile['ID_MEMBER'] . '" title="' . $txt[92] . ' ' . $profile['realName'] . '"><font color="'.(!empty($profile['member_group_color']) ? $profile['member_group_color'] : $profile['post_group_color']).'">' . $profile['realName'] . '</font></a>';
}
        }
if (!empty($modSettings['latestMember']) && !empty($modSettings['MemberColorLatestMember'])) {
$profile = &$user_profile[$modSettings['latestMember']];
if(!empty($profile['member_group_color']) || !empty($profile['post_group_color']))
$context['latest_member']['link'] = '<a href="' . $scripturl . '?action=profile;u=' . $profile['ID_MEMBER'] . '" title="' . $txt[92] . ' ' . $profile['realName'] . '"><font color="'.(!empty($profile['member_group_color']) ? $profile['member_group_color'] : $profile['post_group_color']).'">' . $profile['realName'] . '</font></a>';
}
}
// yeni uyeler full top 10. 10 ivan_ . . .
$members_result = db_query("
SELECT ID_MEMBER, realName, posts
FROM {$db_prefix}members
ORDER BY ID_MEMBER DESC
LIMIT 10", __FILE__, __LINE__);
$context['yeniuyeler'] = array();
$max_num_posts = 1;
while ($row_members = mysql_fetch_assoc($members_result))
{

$context['yeniuyeler'][] = array(
'name' => $row_members['realName'],
'id' => $row_members['ID_MEMBER'],
'num_posts' => $row_members['posts'],
'href' => $scripturl . '?action=profile;u=' . $row_members['ID_MEMBER'],
'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['ID_MEMBER'] . '">' . $row_members['realName'] . '</a>'
);


if (!empty($modSettings['MemberColorStats']))
$MemberColor_ID_MEMBER[$row_members['ID_MEMBER']] = $row_members['ID_MEMBER'];


if ($max_num_posts < $row_members['posts'])
$max_num_posts = $row_members['posts'];
}
mysql_free_result($members_result);

foreach ($context['yeniuyeler'] as $i => $poster)
$context['yeniuyeler'][$i]['post_percent'] = round(($poster['num_posts'] * 100) / $max_num_posts);
//Yeah baby give me some colors =).
if (!empty($MemberColor_ID_MEMBER)) {
//Now Load the Missing global :)
global $user_profile;
loadMemberData($MemberColor_ID_MEMBER);
$cmemcolid = NULL;
if (!empty($modSettings['MemberColorStats'])) {
// karma
foreach($context['yeniuyeler'] as $key => $value) {
$cmemcolid = $context['yeniuyeler'][$key]['id'];
$profile = &$user_profile[$cmemcolid];
if(!empty($profile['member_group_color']) || !empty($profile['post_group_color']))
$context['yeniuyeler'][$key]['link'] = '<a href="' . $scripturl . '?action=profile;u=' . $profile['ID_MEMBER'] . '" title="' . $txt[92] . ' ' . $profile['realName'] . '"><font color="'.(!empty($profile['member_group_color']) ? $profile['member_group_color'] : $profile['post_group_color']).'">' . $profile['realName'] . '</font></a>';
}
        }
if (!empty($modSettings['latestMember']) && !empty($modSettings['MemberColorLatestMember'])) {
$profile = &$user_profile[$modSettings['latestMember']];
if(!empty($profile['member_group_color']) || !empty($profile['post_group_color']))
$context['latest_member']['link'] = '<a href="' . $scripturl . '?action=profile;u=' . $profile['ID_MEMBER'] . '" title="' . $txt[92] . ' ' . $profile['realName'] . '"><font color="'.(!empty($profile['member_group_color']) ? $profile['member_group_color'] : $profile['post_group_color']).'">' . $profile['realName'] . '</font></a>';
}
}
// karma full top 10. ivan_ . . .


$members_result = db_query("
SELECT ID_MEMBER, realName, posts , karmaGood
FROM {$db_prefix}members
ORDER BY karmaGood DESC
LIMIT 10", __FILE__, __LINE__);
$context['karma'] = array();
$max_num_posts = 1;
while ($row_members = mysql_fetch_assoc($members_result))
{
$context['karma'][] = array(
'name' => $row_members['realName'],
'id' => $row_members['ID_MEMBER'],
'karma' => $row_members['karmaGood'],
'num_posts' => $row_members['posts'],
'href' => $scripturl . '?action=profile;u=' . $row_members['ID_MEMBER'],
'link' =>'<a href="' . $scripturl . '?action=profile;u=' . $row_members['ID_MEMBER'] . '">' . $row_members['realName'] . '</a>'
);

if (!empty($modSettings['MemberColorStats']))
$MemberColor_ID_MEMBER[$row_members['ID_MEMBER']] = $row_members['ID_MEMBER'];

if ($max_num_posts < $row_members['posts'])
$max_num_posts = $row_members['posts'];
}
mysql_free_result($members_result);

foreach ($context['karma'] as $i => $poster)
$context['karma'][$i]['post_percent'] = round(($poster['num_posts'] * 100) / $max_num_posts);
//Yeah baby give me some colors =).
if (!empty($MemberColor_ID_MEMBER)) {
//Now Load the Missing global :)
global $user_profile;
loadMemberData($MemberColor_ID_MEMBER);
$cmemcolid = NULL;
if (!empty($modSettings['MemberColorStats'])) {
// karma
foreach($context['karma'] as $key => $value) {
$cmemcolid = $context['karma'][$key]['id'];
$profile = &$user_profile[$cmemcolid];
if(!empty($profile['member_group_color']) || !empty($profile['post_group_color']))
$context['karma'][$key]['link'] = '<a href="' . $scripturl . '?action=profile;u=' . $profile['ID_MEMBER'] . '" title="' . $txt[92] . ' ' . $profile['realName'] . '"><font color="'.(!empty($profile['member_group_color']) ? $profile['member_group_color'] : $profile['post_group_color']).'">' . $profile['realName'] . '</font></a>';
}
        }
if (!empty($modSettings['latestMember']) && !empty($modSettings['MemberColorLatestMember'])) {
$profile = &$user_profile[$modSettings['latestMember']];
if(!empty($profile['member_group_color']) || !empty($profile['post_group_color']))
$context['latest_member']['link'] = '<a href="' . $scripturl . '?action=profile;u=' . $profile['ID_MEMBER'] . '" title="' . $txt[92] . ' ' . $profile['realName'] . '"><font color="'.(!empty($profile['member_group_color']) ? $profile['member_group_color'] : $profile['post_group_color']).'">' . $profile['realName'] . '</font></a>';
}
}
// Topic views full top 10 10 ivan_ . . .
$topic_view_result = db_query("
SELECT m.subject, t.numViews, t.ID_BOARD, t.ID_TOPIC, b.name
FROM ({$db_prefix}topics AS t, {$db_prefix}messages AS m, {$db_prefix}boards AS b)
WHERE m.ID_MSG = t.ID_FIRST_MSG
AND $user_info[query_see_board]" . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? "
AND b.ID_BOARD != $modSettings[recycle_board]" : '') . "
AND t.ID_BOARD = b.ID_BOARD" . (!empty($topic_ids) ? "
AND t.ID_TOPIC IN (" . implode(', ', $topic_ids) . ")" : '') . "
ORDER BY t.numViews DESC
LIMIT 10", __FILE__, __LINE__);
$context['top_topics_views'] = array();
$max_num_views = 1;
while ($row_topic_views = mysql_fetch_assoc($topic_view_result))
{
censorText($row_topic_views['subject']);
$row_topic_views['subject'] = shorten_subject($row_topic_views['subject'], 24);
$context['top_topics_views'][] = array(
'id' => $row_topic_views['ID_TOPIC'],
'board' => array(
'id' => $row_topic_views['ID_BOARD'],
'name' => $row_topic_views['name'],
'href' => $scripturl . '?board=' . $row_topic_views['ID_BOARD'] . '.0',
'link' => '<a href="' . $scripturl . '?board=' . $row_topic_views['ID_BOARD'] . '.0">' . $row_topic_views['name'] . '</a>'
),
'num_views' => $row_topic_views['numViews'],
'href' => $scripturl . '?topic=' . $row_topic_views['ID_TOPIC'] . '.0',
'link' => '<a href="' . $scripturl . '?topic=' . $row_topic_views['ID_TOPIC'] . '.0">' . $row_topic_views['subject'] . '</a>'
);

if ($max_num_views < $row_topic_views['numViews'])
$max_num_views = $row_topic_views['numViews'];
}
mysql_free_result($topic_view_result);

foreach ($context['top_topics_views'] as $i => $topic)
$context['top_topics_views'][$i]['post_percent'] = round(($topic['num_views'] * 100) / $max_num_views);

// Try to cache this when possible, because it's a little unavoidably slow.
if (($members = cache_get_data('stats_top_starters', 360)) == null)
{
$request = db_query("
SELECT ID_MEMBER_STARTED, COUNT(ID_TOPIC) AS hits
FROM {$db_prefix}topics" . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? "
WHERE ID_BOARD != $modSettings[recycle_board]" : '') . "
GROUP BY ID_MEMBER_STARTED
ORDER BY hits DESC
LIMIT 20", __FILE__, __LINE__);
$members = array();
while ($row = mysql_fetch_assoc($request))
$members[$row['ID_MEMBER_STARTED']] = $row['hits'];
mysql_free_result($request);

cache_put_data('stats_top_starters', $members, 360);
}

if (empty($members))
$members = array(0 => 0);
// Topic poster full top 10 10 ivan_ . . .
$members_result = db_query("
SELECT ID_MEMBER, realName
FROM {$db_prefix}members
WHERE ID_MEMBER IN (" . implode(', ', array_keys($members)) . ")
GROUP BY ID_MEMBER
ORDER BY FIND_IN_SET(ID_MEMBER, '" . implode(',', array_keys($members)) . "')
LIMIT 10", __FILE__, __LINE__);
$context['top_starters'] = array();
$max_num_topics = 1;
while ($row_members = mysql_fetch_assoc($members_result))
{
$context['top_starters'][] = array(
'name' => $row_members['realName'],
'id' => $row_members['ID_MEMBER'],
'num_topics' => $members[$row_members['ID_MEMBER']],
'href' => $scripturl . '?action=profile;u=' . $row_members['ID_MEMBER'],
'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['ID_MEMBER'] . '">' . $row_members['realName'] . '</a>'
);

if (!empty($modSettings['MemberColorStats']))
$MemberColor_ID_MEMBER[$row_members['ID_MEMBER']] = $row_members['ID_MEMBER'];

if ($max_num_topics < $members[$row_members['ID_MEMBER']])
$max_num_topics = $members[$row_members['ID_MEMBER']];
}
mysql_free_result($members_result);

foreach ($context['top_starters'] as $i => $topic)
$context['top_starters'][$i]['post_percent'] = round(($topic['num_topics'] * 100) / $max_num_topics);

//Yeah baby give me some colors =).
if (!empty($MemberColor_ID_MEMBER)) {
//Now Load the Missing global :)
global $user_profile;
loadMemberData($MemberColor_ID_MEMBER);
$cmemcolid = NULL;
if (!empty($modSettings['MemberColorStats'])) {
// top_starters
foreach($context['top_starters'] as $key => $value) {
$cmemcolid = $context['top_starters'][$key]['id'];
$profile = &$user_profile[$cmemcolid];
if(!empty($profile['member_group_color']) || !empty($profile['post_group_color']))
$context['top_starters'][$key]['link'] = '<a href="' . $scripturl . '?action=profile;u=' . $profile['ID_MEMBER'] . '" title="' . $txt[92] . ' ' . $profile['realName'] . '"><font color="'.(!empty($profile['member_group_color']) ? $profile['member_group_color'] : $profile['post_group_color']).'">' . $profile['realName'] . '</font></a>';
}
        }
if (!empty($modSettings['latestMember']) && !empty($modSettings['MemberColorLatestMember'])) {
$profile = &$user_profile[$modSettings['latestMember']];
if(!empty($profile['member_group_color']) || !empty($profile['post_group_color']))
$context['latest_member']['link'] = '<a href="' . $scripturl . '?action=profile;u=' . $profile['ID_MEMBER'] . '" title="' . $txt[92] . ' ' . $profile['realName'] . '"><font color="'.(!empty($profile['member_group_color']) ? $profile['member_group_color'] : $profile['post_group_color']).'">' . $profile['realName'] . '</font></a>';
}
}

/* Each category in categories is made up of:

// Here's where the "Info Center" starts...

// Full istatistikler ivan_ . . .
echo '<br><div class="tborder" ', $context['browser']['needs_size_fix'] && !$context['browser']['is_ie6'] ? 'style="width: 100%;"' : '', '>
<table border="0" width="100%" cellspacing="1" cellpadding="2" class="bordercolor"><tr>
<td width="100%" colspan="5" class="catbg" height="24">
<font color="#FFFFFF"><b>FuLL - TOP 10</b></font></td>  </tr>
<tr class="titlebg"><span class="smalltext">
<td width="18%"><span class="smalltext">Top 10 Mesaj</font></td>
<td width="18%"><span class="smalltext">Top 10 Karma</font></td>
<td width="18%"><span class="smalltext">Top 10 Konu </font></td>
<td width="32%"><span class="smalltext">Top 10 Popüler Konu</font></td>
<td width="14%"><span class="smalltext">Yeni Uyeler</font></td></tr>
<tr class="windowbg">
<td width="18%" valign="top"><table width="100%"><tr>
<td width="75%" class="windowbg2"><b><span class="smalltext"><u>Üye</u></font></b></td>
<td width="25%" class="windowbg2" align="right"><span class="smalltext"><b><u>Mesaj</u></b></td></tr><tr>';
foreach ($context['top_posters'] as $poster)
{echo '
<td width="75%" class="windowbg2"><span class="smalltext"><img src="', $settings['images_url'], '/1top10.gif" />', $poster['link'], '</td>
<td width="25%" class="windowbg2" align="right"><span class="smalltext">', $poster['num_posts'], '</td></tr>'; 
}echo '</table></td>
<td width="18%" valign="top"><table width="100%"class="windowbg" ><tr>
<td width="75%" class="windowbg2"><span class="smalltext"><b><u>Üye</u></b></td>
<td width="25%" class="windowbg2" align="right"><span class="smalltext"><b><u>Karma</u></b></td></tr><tr>';
foreach ($context['karma'] as $poster)
{echo '
<td width="75%" class="windowbg2" valign="top"><span class="smalltext"><img src="', $settings['images_url'], '/2top10.gif" />',$poster['link'], '</td>
<td width="25%" class="windowbg2" align="right" valign="top"><span class="smalltext"><center>',$poster['karma'], '</center></td></tr>';
}echo '</table></td>
<td width="18%" valign="top"><table width="100%"class="windowbg" ><tr>
<td width="75%" class="windowbg2"><span class="smalltext"><b><u>Üye</u></b></td>
<td width="25%" class="windowbg2" align="right"><span class="smalltext"><center><b><u>Konu</u></b></center></td></tr><tr>';
foreach ($context['top_starters'] as $poster)
{echo '
<td width="75%" class="windowbg2" valign="top"><span class="smalltext"><img src="', $settings['images_url'], '/3top10.gif" />', $poster['link'], '</td>
<td width="25%" class="windowbg2" align="right" valign="top"><span class="smalltext"><center>',$poster['num_topics'], '</center></td></tr>';
}echo '</table></td>
<td width="32%" valign="top"><table width="100%"class="windowbg" ><tr>
<td width="80%" class="windowbg2"><span class="smalltext"><b><u>Konu</u></b></td>
<td width="20%" class="windowbg2" align="right"><span class="smalltext"><center><b><u>Hit</u></b></center></td></tr><tr>';
foreach ($context['top_topics_views'] as $topic)
{echo '
<td width="80%" class="windowbg2" valign="top"><span class="smalltext"><img src="', $settings['images_url'], '/4top10.gif" />', $topic['link'], '</td>
<td width="20%" class="windowbg2" align="right" valign="top"><span class="smalltext"><center>', $topic['num_views'], '<img src="', $settings['images_url'], '/ivan_hit.gif" /></center></td></tr>';
}echo '</table></td>
<td width="14%" valign="top"><table width="100%"class="windowbg" ><tr>
<td width="100%" class="windowbg2"><span class="smalltext"><b><u>Üye</u></b></td></tr><tr>';
foreach ($context['yeniuyeler'] as $poster)
{echo '
<td width="100%" class="windowbg2" valign="top"><span class="smalltext"><img src="', $settings['images_url'], '/5top10.gif" />',$poster['link'], '</td></tr>'; 
}echo '</table></td></tr>';
echo '<tr class="windowbg">
<td width="100%"colspan="5" height="0"><table width="100%"><tr>
<tr class="titlebg"><span class="smalltext">
<td width="32%"><span class="smalltext"><b><u>Yanitlanan Kategori</u></b></td>
<td width="28%"><span class="smalltext"><b><u>Yanitlanan Konu</u></b></td>
<td width="7%"><span class="smalltext"><center><b><u>Hit</u></b></center></td>
<td width="15%"><span class="smalltext"><b><u>Gönderen</u></b></td>
<td width="18%"><b><span class="smalltext"><u>Tarih</u></b></td></tr> </table>
<table cellspacing="1" width="100%" cellpadding="0"  border="0"><tr>';
foreach ($context['latest_posts'] as $post)
echo '
<td class="windowbg2" valign="top" width="32%"><span class="smalltext"><img src="', $settings['images_url'], '/6top10.gif" />', $post['board']['link'],  '</td>
<td class="windowbg2" valign="top" width="28%"><span class="smalltext"><img src="', $settings['images_url'], '/7top10.gif" /><a href="',$post['href'],'">', $post['short_subject'], '</td>
<td class="windowbg2" valign="top" width="8%"><span class="smalltext"><center>', $post['ivan_hit'], '<img src="', $settings['images_url'], '/ivan_hit.gif" /></center></td>
<td class="windowbg2" valign="top" width="15%"><span class="smalltext"><img src="', $settings['images_url'], '/8top10.gif" />', $post['poster']['link'],'</td>
<td class="windowbg2" valign="top" width="18%"><span class="smalltext"><img src="', $settings['images_url'], '/9top10.gif" />', $post['time'], '</td></tr>';
echo '</table></td></tr></table></div>';