|
|
| | Top 10 Full İstatistikler [Anlatım] | |
| | Yazar | Mesaj |
---|
ExaLTeD_Gs Administratör
Mesaj Sayısı : 2513 Yaş : 32 Nerden : Alemden İş/Hobiler : Bilişim <FONT color=orange><B><center>Ka : Kayıt tarihi : 19/05/08
| Konu: Top 10 Full İstatistikler [Anlatım] Çarş. Kas. 19, 2008 11:28 pm | |
| Sources/recent.php yi aç bul:
[php]IFNULL(mem.realName, m.posterName) AS posterName, t.ID_BOARD, b.name AS bName,[/php]
Değiştir
[php]IFNULL(mem.realName, m.posterName) AS posterName, t.ID_BOARD, t.numViews, b.name AS bName,[/php]
Bul: [php]// Build the array. $posts[] = array( 'board' => array( 'id' => $row['ID_BOARD'], 'name' => $row['bName'], 'href' => $scripturl . '?board=' . $row['ID_BOARD'] . '.0',[/php] Değiştir:
[php]// Build the array. $posts[] = array( 'ivan_hit' => $row['numViews'], 'board' => array( 'id' => $row['ID_BOARD'], 'name' => $row['bName'], 'href' => $scripturl . '?board=' . $row['ID_BOARD'] . '.0',[/php] Bul
[php]['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]" : '') . "[/php] Değiştir:
[php]['maxMsgID'] - 20 * $showlatestcount) . " AND m.ID_MSG = t.ID_LAST_MSG AND b.ID_BOARD = t.ID_BOARD " . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? " AND b.ID_BOARD != $modSettings[recycle_board]" : '') . "[/php]
Sources/Board.index.php yi aç bul [php]// 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.[/php]
Hemen Üzerine Ekle:
[php]// 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' => '' . $row_members['realName'] . '' );
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'] = '' . $profile['realName'] . ''; } } 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'] = '' . $profile['realName'] . ''; } } // 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' => '' . $row_members['realName'] . '' );
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'] = '' . $profile['realName'] . ''; } } 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'] = '' . $profile['realName'] . ''; } } // 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' =>'' . $row_members['realName'] . '' );
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'] = '' . $profile['realName'] . ''; } } 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'] = '' . $profile['realName'] . ''; } } // 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' => '' . $row_topic_views['name'] . '' ), 'num_views' => $row_topic_views['numViews'], 'href' => $scripturl . '?topic=' . $row_topic_views['ID_TOPIC'] . '.0', 'link' => '' . $row_topic_views['subject'] . '' );
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' => '' . $row_members['realName'] . '' );
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'] = '' . $profile['realName'] . ''; } } 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'] = '' . $profile['realName'] . ''; } }[/php] | |
| | | ExaLTeD_Gs Administratör
Mesaj Sayısı : 2513 Yaş : 32 Nerden : Alemden İş/Hobiler : Bilişim <FONT color=orange><B><center>Ka : Kayıt tarihi : 19/05/08
| Konu: Geri: Top 10 Full İstatistikler [Anlatım] Çarş. Kas. 19, 2008 11:29 pm | |
| Şimdi sıra anasayfamıza Full istatistikleri koymaya geldi. eğer üstte çıkmasını istiyorsanız bu kodun
Board.index.template.php de bul Kod: /* Each category in categories is made up of: Hemen Üzerine Ekleyin: PHP- Kodu: // 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>';
Kurulum bitti.. şimdi bir kaç ayarlama yapacağız
*admin<kullanılan tema<anasayfada görünmesini istediğiniz son mesajların sayısını 10 olarak ayarlayın
*Tarih bloğunda satır atlamasına engel olmak için admin<Forum Seçenekler< Varsayılan zaman biçimini %d %B %Y, %H:%M:%S olarak değiştirin.
*Yine Tarih bloğunda satır atlamasına engel olmak için admin<Düzen ve Seçenekler< "Bugün" özelliği ni dün_bugüne ayarlayın
*Dil dosyasında languages/index.turkish.php nin içinde Ynt: diye arattırın bulunca sadece Ynt: yazısını silin ,oraya bir boşluk bırakın. | |
| | | | Top 10 Full İstatistikler [Anlatım] | |
|
| Bu forumun müsaadesi var: | Bu forumdaki mesajlara cevap veremezsiniz
| |
| |
| |
|