Etiketler: Easy, Sub-Forums, (Alt, Forum, Eklentisi, Resimli..!), (Link, Yeni) |
| « Önceki başlık :: Sonraki başlık » |
| Yazar |
Mesaj |
SistemCesur Türk
Durum:  Çevrimdışı
Kayıt: 19.01.2006
Mesajlar: 12294
Level: 69
| Deneyim: |
12842 / 12842 |
|
|
|
100% |
|
 Tarih: Sun Jun 11, 2006 7:45 pm Mesaj konusu: Easy Sub-Forums (Alt Forum Eklentisi Resimli..!) (Link Yeni) |
|
|
ßen Kurdum vede paylaşıyorum sizlerde
MODlarda Geçen SQL Sorgularının Nasıl Yapılır için altı tıklayınız;
Bu forumdaki linkleri sadece kayıtlı kullanıcılar görebilir!
Kayıt olmak içinburaya tıklayınız... |
Mod Kurulumu -- MOD Türkçeleştirme ile İlgili Bilgiler;
Bu forumdaki linkleri sadece kayıtlı kullanıcılar görebilir!
Kayıt olmak içinburaya tıklayınız... |
Walla kusura bakmayın uğraşamadım konuları buraya açmayı idare edin artık çoğu arkadaşın benim sited eüyeliği var biliom ordan girersiniz
YEDEKLERİNİ ALMAYI UNUTMUYORSUNUZ...!!!
| Kod: |
##############################################################
## Kaynağın Türkçe Çevirisinde DMRY Mod Çeviri aracı kullanılmıştır. Mod Çeviricisi
## için http://www.dmry.net/mod-ceviri
##
## UYARI: Kendi sitelerinizdeki tüm eklentilerin çevirisini bu adresten yapabilirsiniz. Fakat
## kaynak tepesine eklediğimiz bu satırları lütfen emeğe saygı duyup silmeyiniz.
##
## Mod Çeviricisi : Hakan Demiray ||Bu forumdaki linkleri sadece kayıtlı kullanıcılar görebilir!
Kayıt olmak içinburaya tıklayınız... |
|| hakan[@]dmry[.]net
##############################################################
##############################################################
## MOD Başlık: Easy Sub-Forums
## MOD Yazar: acoolwelshbloke <> () http://www.www.tec2spec.co.uk/forum/
## MOD Açıklama: This mod allows you to "attach" specific forums to another so that they are not displayed on the main index page but inside another forum. This emulates the sub-forums features but does not really create true sub-forum functionality.
##
## MOD Sürüm: 1.0.8
##
## Kurulum zorluğu: (Easy)
## Kurulum süresi: 10 Dakika
## Düzenlenecek dosyalar:
## includes/functions.php
## admin/admin_forums.php
## index.php
## viewforum.php
## viewtopic.php
## posting.php
## templates/subSilver/index_body.tpl
## templates/subSilver/viewforum_body.tpl
## templates/subSilver/viewtopic_body.tpl
## templates/subSilver/admin/forum_edit_body.tpl
## templates/subSilver/admin/forum_admin_body.tpl
## templates/subSilver/posting_body.tpl
## language/lang_english/lang_main.php
## language/lang_english/lang_admin.php
##
## Yüklenecek dosyalar: (n/a)
##############################################################
## Yazar notları:
##
## This mod is based on pseudo attached forum mod by Harishankar (http://literaryforums.org).
## It has been re-written from the ground up.
## Test this MOD in a testing/isolated enviroment if you have heavy modded forum.
## Installs fine with EasyMod on vanilla phpBB setup
##
##############################################################
## Bu modu eklemeden önce lütfen dosyaların yedeğini alınız.
##############################################################
#
#-----[ SQL SORGUSU ]-------------------------------------------------
#
# If your phpbb table prefix is different, then change it to
# reflect the correct one.
#
#
ALTER TABLE `phpbb_topics` ADD INDEX (topic_last_post_id);
ALTER TABLE `phpbb_forums` ADD attached_forum_id MEDIUMINT(8) DEFAULT '-1' NOT NULL;
#
#-----[ AÇ ]------------------------------------------------
#
/includes/functions.php
#
#-----[ BUL ]------------------------------------------------
#
function get_db_stat($mode)
{
#
#-----[ ÖNCESİNE EKLE ]------------------------------------------
#
// Added by Easy Sub-Forums MOD
function check_unread($forum_id)
{
global $new_topic_data, $tracking_topics, $tracking_forums, $HTTP_COOKIE_VARS, $board_config;
if ( !empty($new_topic_data[$forum_id]) )
{
$forum_last_post_time = 0;
while( list($check_topic_id, $check_post_time) = @each($new_topic_data[$forum_id]) )
{
if ( empty($tracking_topics[$check_topic_id]) )
{
$unread_topics = true;
$forum_last_post_time = max($check_post_time, $forum_last_post_time);
}
else
{
if ( $tracking_topics[$check_topic_id] < $check_post_time )
{
$unread_topics = true;
$forum_last_post_time = max($check_post_time, $forum_last_post_time);
}
}
}
if ( !empty($tracking_forums[$forum_id]) )
{
if ( $tracking_forums[$forum_id] > $forum_last_post_time )
{
$unread_topics = false;
}
}
if ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all']) )
{
if ( $HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all'] > $forum_last_post_time )
{
$unread_topics = false;
}
}
}
return $unread_topics;
}
// END Added by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
function make_jumpbox($action, $match_forum_id = 0)
{
global $template, $userdata, $lang, $db, $nav_links, $phpEx, $SID;
#
#-----[ SONRASINA EKLE ]------------------------------------------
#
global $parent_lookup;
#
#-----[ BUL ]------------------------------------------------
#
if ( $forum_rows[$j]['cat_id'] == $category_rows[$i]['cat_id'] && $forum_rows[$j]['auth_view'] <= AUTH_REG )
{
#
#-----[BEFORE, ADD ]------------------------------------------
#
if ($parent_lookup==$forum_rows[$j]['forum_id'] && !$assigned)
{
$template->assign_block_vars('switch_parent_link', array() );
$template->assign_vars(array(
'PARENT_NAME' => $forum_rows[$j]['forum_name'],
'PARENT_URL'=>append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=" . $forum_rows[$j]['forum_id'])
));
$assigned=TRUE;
}
#
#-----[ AÇ ]------------------------------------------------
#
/admin/admin_forums.php
#
#-----[ BUL ]------------------------------------------------
#
$forumstatus = $row['forum_status'];
#
#-----[ SONRASINA EKLE ]------------------------------------------
#
// Added by Easy Sub-Forums MOD
$forum_attached_id = $row['attached_forum_id'];
$sql = "SELECT * from ". FORUMS_TABLE. " WHERE attached_forum_id = $forum_id";
if( !$r = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't get list of children Forums", "", __LINE__, __FILE__, $sql);
}
if( $db->sql_numrows($r) > 0 )
{
$not_attachable=1;
$has_subforums=1;
$template->assign_block_vars('switch_attached_no', array());
if (intval($HTTP_POST_VARS['detach_enabled'])) $detach_enabled = "checked="checked"";
}
else
{
// this forum is not a parent of any other forum
$sql = "SELECT * FROM ". FORUMS_TABLE. " WHERE attached_forum_id=-1 and cat_id= $cat_id and forum_id<>$forum_id ORDER BY forum_order";
if( !$result1 = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't get list of attachable Forums", "", __LINE__, __FILE__, $sql);
}
if( $db->sql_numrows($result1) > 0 )
{
$attachable_forums = '<option value = "-1"'.($forum_attached_id==-1?' selected':').'> NOT ATTACHED TO ANY FORUM </a>';
while( $row1 = $db->sql_fetchrow($result1) )
{
$s=';
if ($forum_attached_id == $row1['forum_id'])
{
$s = " selected="selected"";
}
$attachable_forums .= '<option value="'.$row1[forum_id].$s.">' . $row1[forum_name] . '</option>'n';
}
}
else
{
$no_attachable_forums=1;
}
}
// End Added by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
$forum_id = ';
$prune_enabled = ';
#
#-----[ SONRASINA EKLE ]------------------------------------------
#
// Added by Easy Sub-Forums MOD
$sql = "SELECT * FROM ". FORUMS_TABLE. " WHERE attached_forum_id=-1 and cat_id= $cat_id ORDER BY forum_order";
if( !$result1 = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't get list of Categories/Forums", "", __LINE__, __FILE__, $sql);
}
if( $db->sql_numrows($result1) > 0 )
{
$attachable_forums = '<option value = "-1"'.(($forum_attached_id==-1 || !$forum_attached_id)?' selected':').'> NOT ATTACHED TO ANY FORUM </a>';
while( $row1 = $db->sql_fetchrow($result1) )
{
if ($forum_attached_id == $row1['forum_id'])
{
$s = " selected="selected"";
}
$attachable_forums .= '<option value="'.$row1[forum_id].$s.">' . $row1[forum_name] . '</option>'n';
}
}
else
{
$no_attachable_forums=1;
}
// END Added by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
$catlist = get_list('category', $cat_id, TRUE);
#
#-----[ ÖNCESİNE EKLE ]------------------------------------------
#
// Added by Easy Sub-Forums MOD
$forum_attached_id = $attachable_forums;
// END Added by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
$s_hidden_fields = '<input type="hidden" name="mode" value="' . $newmode ." /><input type="hidden" name="' . POST_FORUM_URL . " value="' . $forum_id . " />';
#
#-----[ SONRASINA EKLE ]------------------------------------------
#
// Added by Easy Sub-Forums MOD
if ($not_attachable or $no_attachable_forums)
{
if ($has_subforums)
{
$lang['Attached_Description'] = $lang['Has_attachments'].'<br>'. $lang['Attached_Description'];
$s_hidden_fields .='<input type="hidden" name="has_subforums" value="1" />';
}
if ($no_attachable_forums) $lang['Attached_Description'] = $lang['No_attach_forums'].'<br>'. $lang['Attached_Description'];
$s_hidden_fields .='<input type="hidden" name="attached_forum_id" value="-1" />';
}
else
{
$template->assign_block_vars('switch_attached_yes', array());
}
$s_hidden_fields .='<input type="hidden" name="old_cat_id" value="'.$cat_id." />';
// END Added by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
'S_PRUNE_ENABLED' => $prune_enabled,
#
#-----[ SONRASINA EKLE ]------------------------------------------
#
// Added by Easy Sub-Forums MOD
'S_ATTACHED_FORUM_ID' => $forum_attached_id,
'S_DETACH_ENABLED'=> $detach_enabled,
// End Added by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
'L_CATEGORY' => $lang['Category'],
#
#-----[ SONRASINA EKLE ]------------------------------------------
#
// Added by Easy Sub-Forums MOD
'L_ATTACHED_FORUM' => $lang['Attached_Field_Title'] ,
'L_ATTACHED_DESC' => $lang['Attached_Description'],
'L_DETACH_DESC' => $lang['Detach_Description'],
// End Added by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, prune_enable" . $field_sql . ")
VALUES (" . $next_id . "', " . str_replace("", "", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", " . str_replace("", "", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";
#
#-----[ ile DEĞİŞTİR ]----------------------------------------
#
// Modified by Easy Sub-Forums MOD
if (intval($HTTP_POST_VARS['old_cat_id']) != intval($HTTP_POST_VARS[POST_CAT_URL]))
{
$HTTP_POST_VARS['attached_forum_id']=-1;
}
$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, attached_forum_id, forum_desc, forum_order, forum_status, prune_enable" . $field_sql . ")
VALUES (" . $next_id . "', " . str_replace("", "", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", " . intval($HTTP_POST_VARS['attached_forum_id']) . ", " . str_replace("", "", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";
// End Added by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
$sql = "UPDATE " . FORUMS_TABLE . "
SET forum_name = " . str_replace("", "", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", forum_desc = " . str_replace("", "", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
#
#-----[ ile DEĞİŞTİR ]----------------------------------------
#
// Modified by Easy Sub-Forums MOD
if (isset($HTTP_POST_VARS['detach_enabled']) && isset($HTTP_POST_VARS['has_subforums']))
{
$sql = "UPDATE ". FORUMS_TABLE. " SET attached_forum_id=-1 WHERE attached_forum_id=" . intval($HTTP_POST_VARS[POST_FORUM_URL]);
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't detach subforums", "", __LINE__, __FILE__, $sql);
}
}
if (intval($HTTP_POST_VARS['old_cat_id']) != intval($HTTP_POST_VARS[POST_CAT_URL]))
{
$HTTP_POST_VARS['attached_forum_id']=-1;
if (isset($HTTP_POST_VARS['has_subforums']) && !isset($HTTP_POST_VARS['detach_enabled']))
{
$sql = "UPDATE ". FORUMS_TABLE ." SET cat_id=". intval($HTTP_POST_VARS[POST_CAT_URL]) ." WHERE attached_forum_id=" . intval($HTTP_POST_VARS[POST_FORUM_URL]);
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't update subforums to new category", "", __LINE__, __FILE__, $sql);
}
}
}
$sql = "UPDATE " . FORUMS_TABLE . "
SET forum_name = " . str_replace("", "", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) .", attached_forum_id = " . intval($HTTP_POST_VARS['attached_forum_id']) . ", forum_desc = " . str_replace("", "", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
// End Added by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
if( $total_forums = $db->sql_numrows($q_forums) )
{
$forum_rows = $db->sql_fetchrowset($q_forums);
}
#
#-----[ SONRASINA EKLE ]------------------------------------------
#
$subforum_rows=$forum_rows;
#
#-----[ BUL ]------------------------------------------------
#
$template->assign_block_vars("catrow.forumrow", array(
'FORUM_NAME' => $forum_rows[$j]['forum_name'],
'FORUM_DESC' => $forum_rows[$j]['forum_desc'],
'ROW_COLOR' => $row_color,
'NUM_TOPICS' => $forum_rows[$j]['forum_topics'],
'NUM_POSTS' => $forum_rows[$j]['forum_posts'],
'U_VIEWFORUM' => append_sid($phpbb_root_path."viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id"),
'U_FORUM_EDIT' => append_sid("admin_forums.$phpEx?mode=editforum&" . POST_FORUM_URL . "=$forum_id"),
'U_FORUM_DELETE' => append_sid("admin_forums.$phpEx?mode=deleteforum&" . POST_FORUM_URL . "=$forum_id"),
'U_FORUM_MOVE_UP' => append_sid("admin_forums.$phpEx?mode=forum_order&move=-15&" . POST_FORUM_URL . "=$forum_id"),
'U_FORUM_MOVE_DOWN' => append_sid("admin_forums.$phpEx?mode=forum_order&move=15&" . POST_FORUM_URL . "=$forum_id"),
'U_FORUM_RESYNC' => append_sid("admin_forums.$phpEx?mode=forum_sync&" . POST_FORUM_URL . "=$forum_id"))
);
#
#-----[ ile DEĞİŞTİR ]----------------------------------------
#
$sub_error=false;
$do_template=false;
if ($forum_rows[$j]['attached_forum_id'] !=-1)
{
$ok=';
for($k = 0; $k < $total_forums; $k++)
{
$subforum_id = $subforum_rows[$k]['forum_id'];
if ($subforum_id == $forum_rows[$j]['attached_forum_id'] && $forum_rows[$k]['attached_forum_id']==-1)
{
$ok=TRUE;//normal parent found
}
}
if ($forum_rows[$j]['attached_forum_id']==$forum_id) $ok=FALSE; //attached to itself
if ($forum_rows[$j]['attached_forum_id']==0) $ok=FALSE; //invalid parent
if (!$ok)
{
$do_template=TRUE;
$sub_error=true;
}
}
else
{
$do_template=true;
}//attached_forum_id'] ==-1
if ($do_template)
{
$template->assign_block_vars("catrow.forumrow", array(
'FORUM_NAME' => $forum_rows[$j]['forum_name'],
'FORUM_DESC' => $forum_rows[$j]['forum_desc'],
'ROW_COLOR' => $row_color,
'NUM_TOPICS' => $forum_rows[$j]['forum_topics'],
'NUM_POSTS' => $forum_rows[$j]['forum_posts'],
'U_VIEWFORUM' => append_sid($phpbb_root_path."viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id"),
'U_FORUM_EDIT' => append_sid("admin_forums.$phpEx?mode=editforum&" . POST_FORUM_URL . "=$forum_id"),
'U_FORUM_DELETE' => append_sid("admin_forums.$phpEx?mode=deleteforum&" . POST_FORUM_URL . "=$forum_id"),
'U_FORUM_MOVE_UP' => append_sid("admin_forums.$phpEx?mode=forum_order&move=-15&" . POST_FORUM_URL . "=$forum_id"),
'U_FORUM_MOVE_DOWN' => append_sid("admin_forums.$phpEx?mode=forum_order&move=15&" . POST_FORUM_URL . "=$forum_id"),
'U_FORUM_RESYNC' => append_sid("admin_forums.$phpEx?mode=forum_sync&" . POST_FORUM_URL . "=$forum_id"))
);
if ($sub_error)
{
$template->assign_block_vars ('catrow.forumrow.switch_error',array());
}
for($k = 0; $k < $total_forums; $k++)
{
$subforum_id = $subforum_rows[$k]['forum_id'];
if ($subforum_rows[$k]['attached_forum_id'] == $forum_id)
{
$template->assign_block_vars("catrow.forumrow", array(
'FORUM_NAME' => $subforum_rows[$k]['forum_name'],
'FORUM_DESC' => $subforum_rows[$k]['forum_desc'],
'ROW_COLOR' => $row_color,
'NUM_TOPICS' => $subforum_rows[$k]['forum_topics'],
'NUM_POSTS' => $subforum_rows[$k]['forum_posts'],
'U_VIEWFORUM' => append_sid($phpbb_root_path."viewforum.$phpEx?" . POST_FORUM_URL . "=$subforum_id"),
'U_FORUM_EDIT' => append_sid("admin_forums.$phpEx?mode=editforum&" . POST_FORUM_URL . "=$subforum_id"),
'U_FORUM_DELETE' => append_sid("admin_forums.$phpEx?mode=deleteforum&" . POST_FORUM_URL . "=$subforum_id"),
'U_FORUM_MOVE_UP' => append_sid("admin_forums.$phpEx?mode=forum_order&move=-15&" . POST_FORUM_URL . "=$subforum_id"),
'U_FORUM_MOVE_DOWN' => append_sid("admin_forums.$phpEx?mode=forum_order&move=15&" . POST_FORUM_URL . "=$subforum_id"),
'U_FORUM_RESYNC' => append_sid("admin_forums.$phpEx?mode=forum_sync&" . POST_FORUM_URL . "=$subforum_id"))
);
$template->assign_block_vars ('catrow.forumrow.switch_attached_forum',array());
}
}
}
#
#-----[ AÇ ]------------------------------------------------
#
index.php
#
#-----[ BUL ]------------------------------------------------
#
$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
FROM (( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id )
ORDER BY f.cat_id, f.forum_order";
#
#-----[ ile DEĞİŞTİR ]----------------------------------------
#
// Modified by Easy Sub-Forums MOD
$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id, t.topic_id, t.topic_title
FROM ((( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id )
LEFT JOIN " . TOPICS_TABLE . " t ON t.topic_last_post_id = f.forum_last_post_id)
GROUP BY f.forum_id ORDER BY f.cat_id, f.forum_order";
// END Modified by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
{
$forum_data[] = $row;
}
#
#-----[ SONRASINA EKLE ]------------------------------------------
#
// Added by Easy Sub-Forums MOD
$attach=$forum_data;
// END Added by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
$forum_id = $forum_data[$j]['forum_id'];
#
#-----[ SONRASINA EKLE ]------------------------------------------
#
// Added by Easy Sub-Forums MOD
$attached_id = $forum_data[$j]['attached_forum_id'];
if ( $is_auth_ary[$forum_id]['auth_view'] && $attached_id == -1 )
{
$attached_forums = array();
foreach ($attach as $key => $value)
{
$sub_forum_id = $value['forum_id'];
if ($value['attached_forum_id']==$forum_id && $is_auth_ary[$sub_forum_id]['auth_view'])
{
//combining topic and post count for forum and subforums
$forum_data[$j]['forum_posts']=$forum_data[$j]['forum_posts']+$value['forum_posts'];
$forum_data[$j]['forum_topics']=$forum_data[$j]['forum_topics']+$value['forum_topics'];
//END combining topic and post count
//Last post link - check if any of subforums have newest posts and link to them instead
if ($value['post_time']>$forum_data[$j]['post_time'])
{
$forum_data[$j]['user_id'] = $value['user_id'];
$forum_data[$j]['post_username'] = $value['post_username'];
$forum_data[$j]['forum_last_post_id'] = $value['forum_last_post_id'];
$forum_data[$j]['post_time'] = $value['post_time'];
$forum_data[$j]['username'] = $value['username'];
$forum_data[$j]['topic_title'] = $value['topic_title'];
}
// END last post check
$unread_topics = false;
if ( $userdata['session_logged_in'] )
{
if (check_unread($value['forum_id']))
{
$attach_img = $images['icon_minipost_new'];
$l_attach_img = $lang['New_posts'];
}
else
{
$attach_img = $images['icon_minipost'];
$l_attach_img = $lang['No_new_posts'];
}
}
else
{
$attach_img = $images['icon_minipost'];
$l_attach_img = $lang['No_new_posts'];
}
$attached_forums[] = array(
'sub_img'=>$attach_img,
'sub_alt'=>$l_attach_img,
'sub_name'=>$value['forum_name'],
'sub_url'=>append_sid ('viewforum.php?f=' . $value['forum_id'] )
);
}
}
// END Added by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
if ( !empty($new_topic_data[$forum_id]) )
{
$forum_last_post_time = 0;
while( list($check_topic_id, $check_post_time) = @each($new_topic_data[$forum_id]) )
{
if ( empty($tracking_topics[$check_topic_id]) )
{
$unread_topics = true;
$forum_last_post_time = max($check_post_time, $forum_last_post_time);
}
else
{
if ( $tracking_topics[$check_topic_id] < $check_post_time )
{
$unread_topics = true;
$forum_last_post_time = max($check_post_time, $forum_last_post_time);
}
}
}
if ( !empty($tracking_forums[$forum_id]) )
{
if ( $tracking_forums[$forum_id] > $forum_last_post_time )
{
$unread_topics = false;
}
}
if ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all']) )
{
if ( $HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all'] > $forum_last_post_time )
{
$unread_topics = false;
}
}
}
#
#-----[ ile DEĞİŞTİR ]----------------------------------------
#
// Added by Easy Sub-Forums MOD
$unread_topics=check_unread($forum_id);
// END Added by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
$last_post_time = create_date($board_config['default_dateformat'], $forum_data[$j]['post_time'], $board_config['board_timezone']);
$last_post = $last_post_time . '<br />';
$last_post .= ( $forum_data[$j]['user_id'] == ANONYMOUS ) ? ( ($forum_data[$j]['post_username'] != ' ) ? $forum_data[$j]['post_username'] . ' ' : $lang['Guest'] . ' ' ) : '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '=' . $forum_data[$j]['user_id']) . ">' . $forum_data[$j]['username'] . '</a> ';
$last_post .= '<a href="' . append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $forum_data[$j]['forum_last_post_id']) . '#' . $forum_data[$j]['forum_last_post_id'] . "><img src="' . $images['icon_latest_reply'] . " border="0" alt="' . $lang['View_latest_post'] . " title="' . $lang['View_latest_post'] . " /></a>';
#
#-----[ ile DEĞİŞTİR ]----------------------------------------
#
// Modified by Easy Sub-Forums MOD
if (strlen($forum_data[$j]['topic_title'])>=25)
{
$forum_data[$j]['topic_title']=substr($forum_data[$j]['topic_title'],0,25). "...";
}
$last_post_time = create_date($board_config['default_dateformat'], $forum_data[$j]['post_time'], $board_config['board_timezone']);
$last_post = ' . $last_post_time . ' . '<br />';
$last_post .= ( $forum_data[$j]['user_id'] == ANONYMOUS ) ? ( ($forum_data[$j]['post_username'] != ' ) ? $forum_data[$j]['post_username'] . ' ' : $lang['Guest'] . ' ' ) : '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '=' . $forum_data[$j]['user_id']) . ">' . $forum_data[$j]['username'] . '</a> <a href="' . append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $forum_data[$j]['forum_last_post_id']) . '#' . $forum_data[$j]['forum_last_post_id'] . "><img src="' . $images['icon_latest_reply'] . " border="0" alt="' . $lang['View_latest_post'] . " title="' . $lang['View_latest_post'] . " /></a>';
// END Modified by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
$l_moderators = ' ';
$moderator_list = ' ';
#
#-----[ ile DEĞİŞTİR ]----------------------------------------
#
// Modified by Easy Sub-Forums MOD
$l_moderators = ';
$moderator_list = ';
// END Modified by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
'U_VIEWFORUM' => append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id"))
);
#
#-----[ SONRASINA EKLE ]------------------------------------------
#
// Added by Easy Sub-Forums MOD
$attached_forum_count = count($attached_forums);
if($attached_forum_count)
{
$template->assign_block_vars('catrow.forumrow.switch_attached_forums', array(
'L_ATTACHED_FORUMS' => ($attached_forum_count ==1)? $lang['Attached_forum']: $lang['Attached_forums']
));
if (count($forum_moderators[$forum_id]) > 0 )
{
$template->assign_block_vars('catrow.forumrow.switch_attached_forums.br', array());
}
for($k = 0; $k < $attached_forum_count; $k++)
{
$template->assign_block_vars('catrow.forumrow.switch_attached_forums.attached_forums', array(
'FORUM_IMAGE' => $attached_forums[$k]['sub_img'],
'FORUM_NAME' => $attached_forums[$k]['sub_name'],
'L_FORUM_IMAGE' => $attached_forums[$k]['sub_alt'],
'U_VIEWFORUM' => $attached_forums[$k]['sub_url']
));
}
}
// END added by Easy Sub-Forums MOD
#-----[ BUL ]------------------------------------------------
#
} // for ... categories
#
#-----[ SONRASINA EKLE ]------------------------------------------
#
}
#
#-----[ AÇ ]------------------------------------------------
#
viewforum.php
#
#-----[ BUL ]------------------------------------------------
#
$sql = "SELECT *
FROM " . FORUMS_TABLE . "
WHERE forum_id = $forum_id";
#
#-----[ ile DEĞİŞTİR ]----------------------------------------
#
// Modified by Easy Sub-Forums MOD
$sql = "SELECT *
FROM " . FORUMS_TABLE . "
WHERE forum_id = $forum_id OR attached_forum_id =$forum_id
ORDER BY attached_forum_id ASC";
// END Modified by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
if ( !($forum_row = $db->sql_fetchrow($result)) )
{
message_die(GENERAL_MESSAGE, 'Forum_not_exist');
}
#
#-----[ SONRASINA EKLE ]------------------------------------------
#
// added by Easy Sub-Forums MOD
$attachments=';
if ($db->sql_numrows ($result) > 1)
{
$attachments=TRUE;
}
// END added by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
make_jumpbox('viewforum.'.$phpEx);
#
#-----[ ÖNCESİNE EKLE ]------------------------------------------
#
// Added by Easy Sub-Forums MOD
if ($forum_row[attached_forum_id]>0)
{
$parent_lookup=$forum_row[attached_forum_id];
}
// END Added by Easy Sub-Forums MOD
#
#-----[ BUL ]------------------------------------------------
#
//
// Okay, lets dump out the page ...
//
#
#-----[ SONRASINA EKLE ]------------------------------------------
#
// Added by Easy Sub-Forums MOD
if ($attachments)
{
//
// Obtain a list of topic ids which contain
// posts made since user last visited
//
if ( $userdata['session_logged_in'] )
{
$sql = "SELECT t.forum_id, t.topic_id, p.post_time
FROM " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p
WHERE p.post_id = t.topic_last_post_id
AND p.post_time > " . $userdata['user_lastvisit'] . "
AND t.topic_moved_id = 0";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query new topic information', ', __LINE__, __FILE__, $sql);
}
$new_topic_data = array();
while( $topic_data = $db->sql_fetchrow($result) )
{
$new_topic_data[$topic_data['forum_id']][$topic_data['topic_id']] = $topic_data['post_time'];
}
}
$sql2 = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id, t.topic_id, t.topic_title
FROM ((( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id )
LEFT JOIN " . TOPICS_TABLE . " t ON t.topic_last_post_id = f.forum_last_post_id)
WHERE attached_forum_id = " . $forum_id . "
GROUP by f.forum_id ORDER BY f.forum_order";
$result2 = $db->sql_query ($sql2);
if (!$result2 )
{
message_die ('Could not gather attached forum info', __LINE__, __FILE__, $sql2);
}
if ($db->sql_numrows ($result2) != 0)
{
while( $row = $db->sql_fetchrow($result2) )
{
$forum_data[] = $row;
}
$is_auth_ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata, $forum_data);
$x=0;
foreach ($forum_data as $row2 => $value)
{
if ($is_auth_ary[$value['forum_id']]['auth_view'])
{
$x++;
if ($x==1)
{
$template->assign_block_vars ('switch_attached_list',
array( 'L_ATTACHED_FORUM' => $lang['Attached_forums'],
'L_ATTACHED_TOPICS' => $lang['Topics'],
'L_ATTACHED_POSTS' => $lang['Posts'],
'L_LAST_POST'=>$lang['Last_Post']
)
);
}
$attach_forum_link = append_sid('viewforum.php?f=' . $value['forum_id']);
$attach_forum_name = '<a href="' . append_sid('viewforum.php?f=' . $value['forum_id']) . ">' . $value['forum_name'] . '</a>' ;
$attach_forum_desc = $value['forum_desc'];
$attach_forum_topics = $value['forum_topics'];
$attach_forum_posts = $value['forum_posts'];
$last_post_id = $value['forum_last_post_id'];
if ( $value['forum_status'] == FORUM_LOCKED )
{
$folder_image = $images['forum_locked'];
$folder_alt = $lang['Forum_locked'];
}
else
{
$unread_topics = false;
if ( $userdata['session_logged_in'] )
{
$unread_topics=check_unread($value['forum_id']);
}
$folder_image = ( $unread_topics ) ? $images['forum_new'] : $images['forum'];
$folder_alt = ( $unread_topics ) ? $lang['New_posts'] : $lang['No_new_posts'];
}
if ( $value['forum_last_post_id'] )
{
if (strlen($value['topic_title'])>=25)
{
$value['topic_title']=substr($value['topic_title'],0,25). "...";
| | | |
Portal Anasayfa 
Arama 
Üye Listesi
Cesur Türk Üye Kayıt Sözleşmesi (Kuralları Okuyunuz)
Hesabınız 
Oturum Aç
