Son okunan 20 konu encok okunan

[ufoss]

Slm arkadaslar.
Bende http://lezzetler.com/ sitesinin en altinda kayan yazi calisan mod dan istiyorum...
bu sitemizde mevcutmu mevcutsa hangi isimli...


Ilginize cok tesekkurler

[Amca62]

Arkadaşım mesajını çok geç gördüm.

O MODu birkaç modu birleştirerek kendim yazmıştım hala ilgileniyorsan buraya yapıştırıyorum.

Sevgiler

##############################################################
## MOD Başlığı: Son eklenen ve çok okunan X kadar konu ana sayfada gösterim
## MOD Yazarı1: zparta < zparta@hispan.se > (Jens Holmqvist) http://www.hispan.se (Latest active topics on index)
## MOD Yazarı2: Andrey Politov aka Sergeant < andypolv@mail.ru > (The last Five and the Five popular 'answers/views' on index.php)
## MOD'ları Birleştiren: Çetin Atabay < ca@park-foto.com >
## MOD Açıklaması: Son eklenen ve çok okunan konular ana sayfanın altında kayan yazı ile gösterilir. Konu adedi Admin Kontrol panelinden ayarlanabilir
## varsayılan başlık değeri değeri 10 olup değiştirilebilir. MySql veri tabanını biraz şişmanlatır.
## MOD Versiyonu: 0.0.1 (Bismillah)
##
## Kurulum Düzeyi: Basit
## Kurulum Süresi: ~1 dakika
## Hazırlama Süresi: Gel de bana sor
## Düzenlenecek dosyalar: (6 adet)
## index.php
## templates/subSilver/index_body.tpl
## language/lang_turkish/lang_main.php
## language/lang_turkish/lang_admin.php,
## admin/admin_board.php
## templates/subSilver/admin/board_config_body.tpl
## İlave dosyalar: YOK
##############################################################
##
## Örneğini; http://lezzetler.com adresinin en altında görebilirsiniz.
##
##############################################################
## Amca'nın Notu: Yukarıdaki yazarların yazdığı ayrı ayrı 2 MOD'u birleştirerek
## çalışır vaziyette kullanıma sunduk. Vatana Millete hayırlı olsun.
## Öyle fazla php bilgim falan olduğunu sanmayın deneme yanılma yoluyla bu işi çıkarttık
## Yukarıdaki yabancı elemanlara teşekkürler
## Bu kodları istediğiniz gibi mıncıklayıp değiştirebilirsiniz. Yabancı dile çevirmeyin/çevirseniz de olur farketmez.
## O artık "Made in Turkey". Bir kusurumuz varsa affola, kalın sağlıcakla.
##
##############################################################
## MOD Tarihçesi:
##
## Abi, daha tarihçemiz yok, yeni Bismillah dedik.
##
##############################################################
## MOD'ları uygulamadan önce dosyaların mutlaka yedeklerini alın, benim sağım solum belli olmaz.
##############################################################

#
#-----[ SQL ]------------------------------------------
#
INSERT INTO phpbb_config ( config_name, config_value ) VALUES ('topics_on_index', '10');

#
#-----[ OPEN ]------------------------------------------
#
index.php

#
#-----[ FIND ]------------------------------------------
#
//
// Start output of page
//

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// AMCANIZ BAŞLADI

function array_merge_replace($array, $newValues)
{
foreach ($newValues as $key => $value)
{
if ( is_array($value) )
{
if ( !isset($array[$key]) )
{
$array[$key] = array();
}
$array[$key] = array_merge_replace($array[$key], $value);
}
else
{
if ( isset($array[$key]) && is_array($array[$key]) )
{
$array[$key][0] = $value;
}
else
{
if ( isset($array) && !is_array($array) )
{
$temp = $array;
$array = array();
$array[0] = $temp;
}
$array[$key] = $value;
}
}
}
return $array;
}
$ary = array();
$ary2 = array();
$ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata, $forum_data);
$ary2 = auth(AUTH_READ, AUTH_LIST_ALL, $userdata, $forum_data);
$is_auth_ary = array_merge_replace($ary, $ary2);
$auth_view_forum_sql = '';
for($i = 0; $i < $total_categories; $i++)
{
$cat_id = $category_rows[$i]['cat_id'];
$display_forums = false;
for($j = 0; $j < $total_forums; $j++)
{
if ( $is_auth_ary[$forum_data[$j]['forum_id']]['auth_view'] && $is_auth_ary[$forum_data[$j]['forum_id']]['auth_read'] && $forum_data[$j]['cat_id'] == $cat_id )
{
$display_forums = true;
$auth_view_forum_sql .= ($auth_view_forum_sql == '' ? '' : ', ' ) . $forum_data[$j]['forum_id'];
}
}
}
$auth_view_forum_sql = ($auth_view_forum_sql == '' ? '(0)' : '(' . $auth_view_forum_sql . ')');

$template->assign_vars(array(
'MARQUEE_TOPIC' => str_replace("%s",$board_config['topics_on_index'],$lang['marquee_topic']) )
);

$sql = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, t.topic_type, t.topic_status, p.post_id, p.poster_id,
p.post_time, u.user_id, u.username, u.user_lastvisit
FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
WHERE t.forum_id IN " . $auth_view_forum_sql . " AND t.topic_id = p.topic_id
AND f.forum_id = t.forum_id
AND t.topic_status <> 2
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u.user_id
ORDER BY t.topic_last_post_id DESC";

if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query recent posts marquee information', '', __LINE__, __FILE__, $sql);
}

if ($row = $db->sql_fetchrowset($result))
{
$db->sql_freeresult($result);
}

if( count($row) <= $board_config['topics_on_index'] )
{
$topics = count($row);
}
else
{
$topics = $board_config['topics_on_index'];
}

for($i = 0; $i < $topics; $i++)
{
$mar_title = $row[$i]["topic_title"];
$mar_url = $phpbb_root_path . 'viewtopic.'.$phpEx.'?'.POST_TOPIC_URL.'='.$row[$i]["topic_id"];
$mar_user = $row[$i]["username"];
if ( $row[$i]["topic_status"] == TOPIC_LOCKED )
{
if ( $row[$i]["post_time"] > $row[$i]["user_lastvisit"] )
{
$pic = $images['folder_locked_new'];
}
else
{
$pic = $images['folder_locked'];
}
}
else
{
if ( $row[$i]["topic_type"] == POST_GLOBAL_ANNOUNCE )
{
if ( $row[$i]["post_time"] > $row[$i]["user_lastvisit"] )
{
$pic = $images['folder_global_announce_new'];
}
else
{
$pic = $images['folder_global_announce'];
}
}
else if ( $row[$i]["topic_type"] == POST_ANNOUNCE )
{
if ( $row[$i]["post_time"] > $row[$i]["user_lastvisit"] )
{
$pic = $images['folder_announce_new'];
}
else
{
$pic = $images['folder_announce'];
}
}
else if ( $row[$i]["topic_type"] == POST_STICKY )
{
if ( $row[$i]["post_time"] > $row[$i]["user_lastvisit"] )
{
$pic = $images['folder_sticky_new'];
}
else
{
$pic = $images['folder_sticky'];
}
}
else { if ( $row[$i]["post_time"] > $userdata['user_lastvisit'] )
{
$pic = $images['folder_new']; }else{ $pic = $images['folder'];
}
}
}
$template->assign_block_vars('marqueerow', array(
'FOLD_URL' => $pic,
'TOPIC_TITLE' => $row[$i]["topic_title"],
'TOPIC_URL' => append_sid($phpbb_root_path . 'viewtopic.'.$phpEx.'?'.POST_TOPIC_URL.'='.$row[$i]["topic_id"]),
'USERNAME' => $row[$i]["username"],
'USER_PROF' => append_sid($phpbb_root_path . 'profile.'.$phpEx.'?mode=viewprofile&u='.$row[$i]["user_id"]),
'POST_DATE' => create_date($board_config['default_dateformat'], $row[$i]["post_time"], $board_config['board_timezone']))
);
}

$template->assign_vars(array(
'L_TOPICSPOPULARVIEW' => str_replace("%s",$board_config['topics_on_index'],$lang['TopicsPopularView']))
);

// 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;
}
}

if( empty($topics_auth_sql) )
{
$template->assign_block_vars('topicrecentpopular', array(
'TOPICSRECENT' => $lang['No_Posts']
));
}
else
{

$active_topics_sql = 'SELECT t.topic_id, t.topic_title, t.topic_views, t.topic_poster, u.username, u.user_id
FROM ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE. ' f, ' . USERS_TABLE. ' u
WHERE t.forum_id IN (' . $topics_auth_sql . ')
AND f.forum_id = t.forum_id
AND t.topic_poster = u.user_id
ORDER BY t.topic_views DESC';

$active_topics_sql_c = sprintf($active_topics_sql, 'topic_views');
$recent_row = $popular_row = $viewed_row = array();

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);

for( $i = 0; $i < $topics; $i++ )
{

$viewed_topic_title = $viewed_row[$i]['topic_title'];
$basliklink = $viewed_row[$i]['topic_id'];
$kullanici = $viewed_row[$i]['username'];
$kullanicilink = $viewed_row[$i]['user_id'];

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

$recent_post = '' . $recent_topic_title . '';
$popular_post = '' . $popular_topic_title . '';
$popular_total_replies = $popular_row[$i]['topic_replies'];
$viewed_post = '' . $viewed_topic_title . '';
$viewed_total_replies = $viewed_row[$i]['topic_views'];
$basliklink2 = append_sid($phpbb_root_path . 'viewtopic.'.$phpEx.'?t='.$basliklink);
$kullanicilink2 = append_sid($phpbb_root_path . 'profile.'.$phpEx.'?mode=viewprofile&u='.$kullanicilink);

$template->assign_block_vars('topicrecentpopular', array(
'TOPICSPOPULARVIEW' => $viewed_post,
'TOPICSPOPULARVIEWC' => $viewed_total_replies,
'BASLIKLINK' => $basliklink2,
'KULLANICILINK' => $kullanicilink2,
'KULLANICI' => $kullanici)
);
}
}
// AMCANIZ BITTI
#-----[ OPEN ]------------------------------------------
#
#
templates/subSilver/index_body.tpl

#
#-----[ FIND ]------------------------------------------
#
<!-- END switch_user_logged_out -->

#
#-----[ AFTER, ADD ]------------------------------------------
#
<table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline" height="100%">
<tr>
<td class="catHead" height="28" width="50%"><a name="login"></a><span class="cattitle">{MARQUEE_TOPIC}</span></td>
<td class="catHead" height="28" width="50%"><a name="login"></a><span class="cattitle">{L_TOPICSPOPULARVIEW}</span></td>
</tr>
<tr>
<td class="row1" valign="top" width="50%"><span class="gen">
<marquee id="recent_topics" behavior="scroll" direction="up" height="100" scrolldelay="100" scrollamount="2">
<table cellpadding="4" cellSpacing="1" width="100%">
<!-- BEGIN marqueerow -->
<tr valign="top">
<td class="row2" vAlign="center" align="middle" width="20"><img src="{marqueerow.FOLD_URL}"></td>
<td class="row2">
<span class="forumlink"><a href="{marqueerow.TOPIC_URL}" onMouseOver="document.all.recent_topics.stop()" onMouseOut="document.all.recent_topics.start()">{marqueerow.TOPIC_TITLE}</a></span>
<span class="gensmall"><br /></span>
</td>
<td class="row2" vAlign="center" align="middle" width="85"><span class="gensmall"><a href="{marqueerow.USER_PROF}" onMouseOver="document.all.recent_topics.stop()" onMouseOut="document.all.recent_topics.start()">{marqueerow.USERNAME}</a></span>
</td>
<td class="row2" vAlign="center" noWrap align="middle" width="190">
<span class="gensmall">{marqueerow.POST_DATE}</span>
</td>
</tr>
<!-- END marqueerow -->
</table></marquee></td>


<td class="row1" valign="top" width="50%"><span class="gen">
<marquee id="popular_topics" behavior="scroll" direction="up" height="100" scrolldelay="100" scrollamount="2">
<table cellpadding="4" cellSpacing="1" width="100%">
<!-- BEGIN topicrecentpopular -->

<td class="row2" vAlign="center" align="middle" width="20"><img src="templates/subSilver/images/folder_new.gif"></td>
<td class="row2" align="left" valign="middle"><span class="forumlink"><a href="{topicrecentpopular.BASLIKLINK}" onMouseOver="document.all.popular_topics.stop()" onMouseOut="document.all.popular_topics.start()">{topicrecentpopular.TOPICSPOPULARVIEW}</a></span></td>
<td class="row2" vAlign="center" align="middle" width="85"><span class="gensmall"><a href="{topicrecentpopular.KULLANICILINK}" onMouseOver="document.all.popular_topics.stop()" onMouseOut="document.all.popular_topics.start()">{topicrecentpopular.KULLANICI}</a></span></td>
<td class="row2" width="50" align="right" valign="middle"><span class="forumlink"><b>{topicrecentpopular.TOPICSPOPULARVIEWC}</b></span></td>

</tr>
<!-- END topicrecentpopular -->
</table></marquee></td>
</table>

#
#-----[ OPEN ]------------------------------------------
#
language/lang_turkish/lang_main.php

#
#-----[ FIND ]------------------------------------------
#

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

#
#-----[ BEFORE, ADD ]------------------------------------------
#

$lang['marquee_topic'] = 'Son Eklenen %s Konu';
$lang['TopicsPopularView'] = "En Çok Okunan %s Konu";

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/admin/board_config_body.tpl

#
#-----[ FIND ]------------------------------------------
#
<td class="row2"><input type="radio" name="prune_enable" value="1" {PRUNE_YES} /> {L_YES}&nbsp;&nbsp;<input type="radio" name="prune_enable" value="0" {PRUNE_NO} /> {L_NO}</td>
</tr>

#
#-----[ AFTER, ADD ]------------------------------------------
#
<tr>
<td class="row1">{L_TOPICS_ON_INDEX}</td>
<td class="row2"><input class="post" type="text" name="topics_on_index" size="3" maxlength="2" value="{TOPICS_ON_INDEX}" /></td>
</tr>


#
#-----[ OPEN ]------------------------------------------
#
language/lang_turkish/lang_admin.php

#
#-----[ FIND ]------------------------------------------
#
$lang['Enable_prune'] = 'Mesaj temizliği';

#
#-----[ AFTER, ADD ]------------------------------------------
#
$lang['Topics_on_index'] = 'Kayan Yazıda Son Eklenen ve Çok Okunan kaç başlık gösterilsin';

#
#-----[ OPEN ]------------------------------------------
#
admin/admin_board.php

#
#-----[ FIND ]------------------------------------------
#
"L_ENABLE_PRUNE" => $lang['Enable_prune'],

#
#-----[ AFTER, ADD ]------------------------------------------
#
"L_TOPICS_ON_INDEX" => $lang['Topics_on_index'],

#
#-----[ FIND ]------------------------------------------
#
"PRUNE_NO" => $prune_no,

#
#-----[ AFTER, ADD ]------------------------------------------
#
"TOPICS_ON_INDEX" => $new['topics_on_index'],

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM