Top10 İstatistik Eklemek

// 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. by rallyproco
    $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 top 10. by rallyproco
    $members_result = db_query("
        SELECT ID_MEMBER, realName, posts
        FROM {$db_prefix}members
        WHERE posts > 0
        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 ($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);

        // yeni uyeler. by rallyproco
    $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 ($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);

// This is the "Recent Posts" bar.
    if (!empty($settings['number_recent_posts']))
    {
        echo '
                <tr>
                    <td class="titlebg" colspan="2">', $txt[214], '</td>
                </tr>
                <tr>
                    <td class="windowbg" width="20" valign="middle" align="center">
                        <a href="', $scripturl, '?action=recent"><img src="', $settings['images_url'], '/post/xx.gif" alt="', $txt[214], '" /></a>
                    </td>
                    <td class="windowbg2">';

        // Only show one post.
        if ($settings['number_recent_posts'] == 1)
        {
            // latest_post has link, href, time, subject, short_subject (shortened with...), and topic. (its id.)
            echo '
                        <b><a href="', $scripturl, '?action=recent">', $txt[214], '</a></b>
                        <div class="smalltext">
                                ', $txt[234], ' "', $context['latest_post']['link'], '" ', $txt[235], ' (', $context['latest_post']['time'], ')<br />
                        </div>';
        }
        // Show lots of posts.
        elseif (!empty($context['latest_posts']))
        {
            echo '
                        <table cellpadding="0" cellspacing="0" width="100%" border="0">';

            /* Each post in latest_posts has:
                    board (with an id, name, and link.), topic (the topic's id.), poster (with id, name, and link.),
                    subject, short_subject (shortened with...), time, link, and href. */
            foreach ($context['latest_posts'] as $post)
                echo '
                            <tr>
                                <td class="middletext" valign="top" nowrap="nowrap"><b>', $post['link'], '</b> ', $txt[525], ' ', $post['poster']['link'], ' (', $post['board']['link'], ')</td>
                                <td class="middletext" align="right" valign="top" nowrap="nowrap">', $post['time'], '</td>
                            </tr>';
            echo '
                        </table>';
        }
        echo '
                    </td>
                </tr>';
    }

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

 // istatistik top 10...by rallyproco

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="4" class="catbg" height="24">
    <font color="#FFFFFF"><b>İstatistikler - Top 10</b></font></td>
  </tr>
<tr class="titlebg">
<td width="21%"><font style="font-size: 8pt">En çok mesaj gönderenler</font></td>
    <td width="20%"><font style="font-size: 8pt">Yeni üyeler</font></td>
    <td width="59%"><font style="font-size: 8pt">Son Mesajlar</font></td>
</tr>
<tr class="windowbg2">
<td width="21%" valign="top"><table width="100%"><tr>

<td width="60%" class="windowbg2"><b><font style="font-size: 8pt">Üye:</font></b></td><td width="40%" class="windowbg2" align="right"><b><font style="font-size: 8pt">Mesaj:</font></b></td>
</tr><tr>
';
foreach ($context['top_posters'] as $poster)
{
echo '



<td width="60%" class="windowbg2"><font style="font-size: 8pt">', $poster['link'], '</font></td>

<td width="40%" class="windowbg2" align="right"><font style="font-size: 8pt">', $poster['num_posts'], '</font></td>


</tr>'; 

} echo '</table></td>
<td width="20%" valign="top"> 

<table width="100%"><tr>

<td width="60%" class="windowbg2"><b><font style="font-size: 8pt">Üye:</font></b></td><td width="40%" class="windowbg2" align="right"><b><font style="font-size: 8pt">Mesaj:</font></b></td>
</tr><tr>
';
foreach ($context['yeniuyeler'] as $poster)
{
echo '



<td width="60%" class="windowbg2" valign="top"><font style="font-size: 8pt">',$poster['link'], '</font></td>

<td width="40%" class="windowbg2" align="right" valign="top"><font style="font-size: 8pt">',$poster['num_posts'], '</font></td>


</tr>'; 

} echo '</table>



</td>
<td width="59%" valign="top">';

// This is the "Recent Posts" bar.
if (!empty($settings['number_recent_posts']))
{


// Only show one post.
if ($settings['number_recent_posts'] == 1)
{
// latest_post has link, href, time, subject, short_subject (shortened with...), and topic. (its id.)
echo '
<b><a href="', $scripturl, '?action=recent">', $txt[214], '</a></b>
<div class="smalltext">
', $txt[234], ' "', $context['latest_post']['link'], '" ', $txt[235], ' (', $context['latest_post']['time'], ')<br />
</div>';
}
// Show lots of posts.
elseif (!empty($context['latest_posts']))
{
echo '
<table width="100%" >
<tr class="windowbg2">
<td width="42%"><b><font style="font-size: 8pt">Konu:</font></b></td>
<td width="22%"><b><font style="font-size: 8pt">Gönderen:</font></b></td>
<td width="36%"><b><font style="font-size: 8pt">Tarih:</font></b></td>
</tr><span class="smalltext">';


/* Each post in latest_posts has:
board (with an id, name, and link.), topic (the topic's id.), poster (with id, name, and link.),
subject, short_subject (shortened with...), time, link, and href. */
foreach ($context['latest_posts'] as $post)
echo '

<tr>

<td class="windowbg2" valign="top" width="42%"><font style="font-size: 8pt">', $post['link'], '</font></td>
<td class="windowbg2" valign="top" width="22%"><font style="font-size: 8pt">', $post['poster']['link'], '</font></td>
<td class="windowbg2" valign="top" width="36%"><font style="font-size: 8pt">', $post['time'], '</font></td></span>

</tr>';
echo '
</table>';
}
echo '
</td>
</tr></table></div>';
        }