##############################################################
##
## Geşitirilmiş MOD Başlığı: The Last Ten and The Ten Popular / Son 10 ve Popüler 10
## Orjinal MOD Yazarı: Andrey Politov aka Sergeant < andypolv@mail.ru >
##
## MOD Açıklaması:    Kurduğunuz forumun index.php sayfasına, En son cevaplanan,
##             en çok okunan ve en çok cevaplanan 10 konuyu tablo içinde
##             sunar. Sayfa üstünde duran, resim eklenmiş halidir.
##
##
## MOD Entegre Etme Zorluğu: Kolay
## MOD Entegre Süresi: 10 Dakika
##
## Düzenlenecek Dosyalar;         ( 3 )
##
##                       index.php
##                     language/lang_turkish/lang_main.php
##                     templates/SeninTeman/index_body.tpl
##
## Eklenecek Dosya:            ( 3 )
##                      
##############################################################
##
## Bu MOD u forumunuza eklemeden önce, dosyaların yedeklerini almayı unutmayın..
##
##############################################################

#
#-----[ KOPYALA ]------------------------------------------
#

modules/Forums/images/ten_topics_red.gif -- > root/images/ten_topics_red.gif
modules/Forums/images/ten_topics_blue.gif -- > root/images/ten_topics_blue.gif
modules/Forums/images/ten_topics_green.gif -- > root/images/ten_topics_green.gif

#
#-----[ DOSYAYI AÇ ]------------------------------------------
#

index.php

#
#-----[ BUL ]------------------------------------------
#

//
// Okay, let's build the index
//
for($i = 0; $i < $total_categories; $i++)
{
$cat_id = $category_rows[$i]['cat_id'];


#
#-----[ ÖNCESİNE EKLE ]------------------------------------------
#

//------------------------------------------------------------------------
//
// Get forum auth information to insure privacy of hidden topics
$topics_auth = auth(AUTH_ALL, AUTH_LIST_ALL, $userdata);
$topics_auth_sql = '';
foreach($topics_auth as $k=>$v)
{
if( $v['auth_view'] && $v['auth_read'] )
{
$topics_auth_sql .= (( empty($topics_auth_sql) ) ? '': ', ') . $k;
}
}
//
// Okay, let's build the topic recent and popular
//
$active_topics_sql = 'SELECT t.topic_id, t.topic_title, t.topic_replies, t.topic_views, t.topic_last_post_id
FROM ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE. ' f
WHERE t.forum_id IN (' . $topics_auth_sql . ')
AND f.forum_id = t.forum_id
ORDER BY %1$s DESC
LIMIT 0,10';
$active_topics_sql_a = sprintf($active_topics_sql, 'topic_last_post_id');
$active_topics_sql_b = sprintf($active_topics_sql, 'topic_replies');
$active_topics_sql_c = sprintf($active_topics_sql, 'topic_views');
$recent_row = $popular_row = $viewed_row = array();

if( !$active_topics_a = $db->sql_query($active_topics_sql_a))
{
message_die(GENERAL_ERROR, 'Could not retrieve recent topics', '', __LINE__, __FILE__, $active_topics_sql_a);
}
$recent_row = $db->sql_fetchrowset($active_topics_a);
$db->sql_freeresult($active_topics_a);

if( !$active_topics_b = $db->sql_query($active_topics_sql_b))
{
message_die(GENERAL_ERROR, 'Could not retrieve popular topics', '', __LINE__, __FILE__, $active_topics_sql_b);
}
$popular_row = $db->sql_fetchrowset($active_topics_b);
$db->sql_freeresult($active_topics_b);

if( !$active_topics_c = $db->sql_query($active_topics_sql_c))
{
message_die(GENERAL_ERROR, 'Could not retrieve most viewed topics', '', __LINE__, __FILE__, $active_topics_sql_c);
}
$viewed_row = $db->sql_fetchrowset($active_topics_c);
$db->sql_freeresult($active_topics_c);

$template->assign_vars(array(
'L_TOPICSRECENT' => $lang['TopicsRecent'],
'L_TOPICSPOPULAR' => $lang['TopicsPopular'],
'L_TOPICSPOPULARVIEW' => $lang['TopicsPopularView'])
);

for( $i = 0; $i < 10; $i++ )
{
$recent_topic_title = $recent_row[$i]['topic_title'];
$popular_topic_title = $popular_row[$i]['topic_title'];
$viewed_topic_title = $viewed_row[$i]['topic_title'];

if( strlen($recent_topic_title) > 40 )
{
$recent_topic_title = substr($recent_topic_title, 0, 40) . '...';
}

if( strlen($popular_topic_title) > 40 )
{
$popular_topic_title = substr($popular_topic_title, 0, 40) . '...';
}

if( strlen($viewed_topic_title) > 40 )
{
$viewed_topic_title = substr($viewed_topic_title, 0, 40) . '...';
}

$recent_post = '<a href="modules.php?name=Forums&file=viewtopic&' . POST_TOPIC_URL . '=' . $recent_row[$i]['topic_id'] . '" title="' . $recent_row[$i]['topic_title'] . '">' . $recent_topic_title . '</a>';
$popular_post = '<a href="modules.php?name=Forums&file=viewtopic&' . POST_TOPIC_URL . '=' . $popular_row[$i]['topic_id'] . '" title="' . $popular_row[$i]['topic_title'] . '">' . $popular_topic_title . '</a>';
$popular_total_replies = $popular_row[$i]['topic_replies'];
$viewed_post = '<a href="modules.php?name=Forums&file=viewtopic&' . POST_TOPIC_URL . '=' . $viewed_row[$i]['topic_id'] . '" title="' . $viewed_row[$i]['topic_title'] . '">' . $viewed_topic_title . '</a>';
$viewed_total_replies = $viewed_row[$i]['topic_views'];

$template->assign_block_vars('topicrecentpopular', array(
'TOPICSPOPULAR' => $popular_post,
'TOPICSPOPULARC' => $popular_total_replies,
'TOPICSPOPULARVIEW' => $viewed_post,
'TOPICSPOPULARVIEWC' => $viewed_total_replies,
'TOPICSRECENT' => $recent_post)
);
}
//
//------------------------------------------------------------------------

#
#-----[ KAYDET VE KAPAT ]------------------------------------------
#

#
#-----[ DOSYAYI AÇ ]------------------------------------------
#

templates/SeninTeman/index_body.tpl

#-----[ BUL ]------------------------------------------

<a href="{U_SEARCH_UNANSWERED}" class="gensmall">{L_SEARCH_UNANSWERED}</a></td>
</tr>
</table>

#-----[ ALTINA EKLE ]------------------------------------------

<!-- Ana Sayfada 3*10 Başlık - Kod Başlangıcı -->
<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
<tr>
<th width="29%" colspan="2" class="thTop" nowrap="nowrap">&nbsp;{L_TOPICSRECENT}&nbsp;</th>
<th width="37%" colspan="3" class="thTop" nowrap="nowrap">&nbsp;{L_TOPICSPOPULAR}&nbsp;</th>
<th width="35%" colspan="3" class="thTop" nowrap="nowrap">&nbsp;{L_TOPICSPOPULARVIEW}&nbsp;</th>
</tr>
<!-- BEGIN topicrecentpopular -->
<tr>
<td width="2%" class="row2" align="left" valign="middle"><center><img width="11" src="modules/Forums/images/ten_topics_red.gif" /></center></td>
<td width="32%" class="row2" align="left" valign="middle"><span class="gensmall">{topicrecentpopular.TOPICSRECENT}</span></td>
<td width="2%" class="row2" align="left" valign="middle"><center><img width="11" src="modules/Forums/images/ten_topics_blue.gif" /></center></td>
<td width="25%" class="row2" align="left" valign="middle"><span class="gensmall">{topicrecentpopular.TOPICSPOPULAR}</span></td>
<td width="6%" class="row2" align="center" valign="middle"><span class="gensmall">{topicrecentpopular.TOPICSPOPULARC}</span></td>
<td width="2%" class="row2" align="left" valign="middle"><center><img width="11" src="modules/Forums/images/ten_topics_green.gif" /></center></td>
<td width="25%" class="row2" align="left" valign="middle"><span class="gensmall">{topicrecentpopular.TOPICSPOPULARVIEW}</span></td>
<td width="6%" class="row2" align="center" valign="middle"><span class="gensmall">{topicrecentpopular.TOPICSPOPULARVIEWC}</span></td>
</tr>
<!-- END topicrecentpopular -->
</table>
<!-- Ana Sayfada 3*10 Başlık - Kod Sonu -->

#
#-----[ KAYDET VE KAPAT ]------------------------------------------
#

#
#-----[ DOSYAYI AÇ ]------------------------------------------
#

language/lang_turkish/lang_main.php

#-----[ BUL ]------------------------------------------
#

//
// That's all, Folks!
// -------------------------------------------------


#
#-----[ ÖNCESİNE EKLE ]------------------------------------------
#

//------------------------------------------------------------------------
//
$lang['TopicsRecent'] = "En Son Cevaplanan 10 Konu";
$lang['TopicsPopular'] = "En Çok Cevaplanan 10 Konu";
$lang['TopicsPopularView'] = "En Çok Okunan 10 Konu";
//
//------------------------------------------------------------------------

#
#-----[ KAYDET VE KAPAT ]------------------------------------------
#

#
#-----[ SON ]------------------------------------------
#

Yedeklerini aldıktan sonra; değişen dosyaları, sitenizdekilerle değiştirin.