Estatísticas - Top 10 v2

[candidosa2]

Primeiro tem que entrar no Admin colocar 10 como ve na imagem

sources/boardindex.php

Pesquisar por

Código: [Seleccione]

// 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.
E colocar por cima o seguinte codigo

Código: [Seleccione]

// 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.


$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 10.
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. 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 (!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'])) {
// repkarma
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>';
}
}
// repkarma top 10. by rallyproco


$members_result = db_query("
SELECT ID_MEMBER, realName, posts , karmaGood
FROM {$db_prefix}members
ORDER BY karmaGood DESC
LIMIT 10", __FILE__, __LINE__);
$context['repkarma'] = array();
$max_num_posts = 1;
while ($row_members = mysql_fetch_assoc($members_result))
{
$context['repkarma'][] = 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['repkarma'] as $i => $poster)
$context['repkarma'][$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'])) {
// repkarma
foreach($context['repkarma'] as $key => $value) {
$cmemcolid = $context['repkarma'][$key]['id'];
$profile = &$user_profile[$cmemcolid];
if(!empty($profile['member_group_color']) || !empty($profile['post_group_color']))
$context['repkarma'][$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 top 10.
$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'], 22);
$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>'
),
'subject' => $row_topic_views['shorten_subject'],
'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);
depois tem que ir themes/default/boardindex.template.php
ou teu tema.....Ex. meu  themes/col_atesi/boardindex.template.php

Pesquisar por // This is the "Recent Posts" bar.
depois pesquisar por // Show information about events, birthdays, and holidays on the calendar.

Remover da Primeira a segunda pesquisa ......pode ver o exemplo do código que esta aqui

Código: [Seleccione]

// 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], ' &quot;', $context['latest_post']['link'], '&quot; ', $txt[235], ' (', $context['latest_post']['time'], ')<br />
</div>';
}
// Show lots of posts.
elseif (!empty($context['latest_posts']))
{
echo '
<table border="0" width="100%" cellspacing="1" cellpadding="0" class="bordercolor">
 <tr>
<th class="windowbg" align="left" width="42%">Konu</th>
<th class="windowbg" align="left" width="12%">Gönderen</th>
<th class="windowbg" align="left" width="25%">Bölüm</th>
<th class="windowbg" align="left" width="21%">Tarih</th>
 </tr>';


/* 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="middle" width="42%"><font style="font-size: 8pt">', $post['link'], '</font></td>
<td class="windowbg2" valign="middle" width="12%"><font style="font-size: 8pt">', $post['poster']['link'], '</font></td>
<td class="windowbg2" valign="middle" width="25%"><font style="font-size: 8pt">', $post['board']['link'], '</font></td>
<td class="windowbg2" valign="middle" width="21%"><font style="font-size: 8pt">', $post['time'], '</font></td>

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

Pesquisar por seguinte linha // Here's where the "Info Center" starts...

e depois colocar o seguinte código antes dessa linha

Código: [Seleccione]

// istatistik top 10...by rallyproco Translate By Candidosa2

 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>Estatísticas - Top 10</b></font></td>
  </tr>
<tr class="titlebg">
<td width="20%"><font style="font-size: 8pt">Melhor membro</font></td>
    <td width="20%"><font style="font-size: 8pt">Respondido</font></td>
   
<td width="28%"><font style="font-size: 8pt">Nivel dos membros</font></td>
<td width="32%"><font style="font-size: 8pt">Ultima Mensagem</font></td>
</tr>
<tr class="windowbg2">
<td width="20%" valign="top"><table width="100%"><tr>

<td width="60%" class="windowbg2"><b><font style="font-size: 8pt">Membro:</font></b></td><td width="40%" class="windowbg2" align="right"><b><font style="font-size: 8pt">Mensagem:</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">Membro:</font></b></td><td width="40%" class="windowbg2" align="right"><b><font style="font-size: 8pt">Mensagem:</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="28%" valign="top">   

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

<td width="50%" class="windowbg2"><b><font style="font-size: 8pt">Membro:</font></b></td><td width="30%" class="windowbg2"><b><font style="font-size: 8pt">Grau:</font></b></td><td width="20%" class="windowbg2" align="right"><b><font style="font-size: 8pt">Rep:</font></b></td>
</tr><tr>
';
foreach ($context['repkarma'] as $poster)
{
echo '



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


if($poster['karma'] <= 0) {
echo '<td width="30%" class="windowbg2" ></td>';
}
elseif($poster['karma'] <= 5) {
echo '<td width="30%" class="windowbg2" ><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /></td>';
}
elseif ($poster['karma'] <= 10) {
echo'<td width="30%" class="windowbg2" ><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /></td>';
}
elseif ($poster['karma'] <= 20) {
echo'<td width="30%" class="windowbg2" ><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /></td>';
}
elseif ($poster['karma'] <= 35) {
echo'<td width="30%" class="windowbg2" ><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /></td>';
}
elseif ($poster['karma'] <= 55) {
echo'<td width="30%" class="windowbg2" ><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep2.gif" border="0" /></td>';
}
elseif ($poster['karma'] <= 80) {
echo'<td width="30%" class="windowbg2" ><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep2.gif" border="0" /></td>';
}
elseif ($poster['karma'] <= 110) {
echo'<td width="30%" class="windowbg2" ><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep2.gif" border="0" /><img src="' . $settings['images_url'] . '/rep2.gif" border="0" /><img src="' . $settings['images_url'] . '/rep2.gif" border="0" /></td>';
}
elseif ($poster['karma'] <= 145) {
echo'<td width="30%" class="windowbg2" ><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep2.gif" border="0" /><img src="' . $settings['images_url'] . '/rep2.gif" border="0" /><img src="' . $settings['images_url'] . '/rep2.gif" border="0" /><img src="' . $settings['images_url'] . '/rep2.gif" border="0" /></td>';
}
elseif ($poster['karma'] >= 185) {
echo'<td width="30%" class="windowbg2" ><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep1.gif" border="0" /><img src="' . $settings['images_url'] . '/rep2.gif" border="0" /><img src="' . $settings['images_url'] . '/rep2.gif" border="0" /><img src="' . $settings['images_url'] . '/rep2.gif" border="0" /><img src="' . $settings['images_url'] . '/rep2.gif" border="0" /><img src="' . $settings['images_url'] . '/rep2.gif" border="0" /></td>';
}
echo'

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


</tr>'; 

} echo '</table>

</td>
<td width="32%" 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], ' &quot;', $context['latest_post']['link'], '&quot; ', $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">Topico:</font></b></td>
<td width="22%" align="right"><b><font style="font-size: 8pt">Enviado por:</font></b></td>
';


/* 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="middle" width="42%"><font style="font-size: 8pt"><a href="',$post['href'],'">', $post['short_subject'], '</font></a></td>
<td class="windowbg2" valign="top" width="22%" align="right"><font style="font-size: 8pt">', $post['poster']['link'], '</font></td>


</tr>';
echo '
</table>';
}
echo '
</td>
</tr></table></div>';
         }
Qualquer dificuldades poste aqui

[Sharkman]

Olá!!

Desde já os meus parabéns por mais um bom trabalho.

Eu ja testei esta nova Estatistica e funciona muito bem!!

 :palmas :palmas :palmas

[candidosa2]

Obrigado
Estamos aqui pra isso...aprender e ensinar.... pesquisar2: