1 頁 (共 1 頁)

[問題] 全區公告裝後無法顯示搜尋[已解決]

發表於 : 2005-07-16 17:30
infixman
問題外掛:全區公告global_announcement1.2.8em
使用版本:phpBB 2.0.16
錯誤位置:搜尋頁http://oursa.sbun.org/phpbb/search.php
裝過外掛以及修正:
1.主題類型+強制使用\r
2.YOU顯示瀏覽者稱號
3.黃牌警告系統
狀況描述:
打開網頁出現\r

代碼: 選擇全部

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/httpd/vhosts/oursa.sbun.org/httpdocs/phpbb/search.php on line 1322
1322行是外掛要我AFTER,ADD的

代碼: 選擇全部

# 
#-----[ FIND ]------------------------------------------------ 
# 
$sql = "SELECT c.cat_title, c.cat_id, f.forum_name, f.forum_id  
	FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f
	WHERE f.cat_id = c.cat_id

# 
#-----[ AFTER, ADD ]------------------------------------------
#
	".(($userdata['user_level'] == ADMIN)? "" : " AND c.cat_id<>'".HIDDEN_CAT."'" )."
以下為search.php

代碼: 選擇全部

//
// Search forum
//
$sql = "SELECT c.cat_title, c.cat_id, f.forum_name, f.forum_id  
	FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f
	WHERE f.cat_id = c.cat_id 
	ORDER BY c.cat_id, f.forum_order";
	".(($userdata['user_level'] == ADMIN)? "" : " AND c.cat_id<>'".HIDDEN_CAT."'" )."
$result = $db->sql_query($sql);
if ( !$result )
{
	message_die(GENERAL_ERROR, 'Could not obtain forum_name/forum_id', '', __LINE__, __FILE__, $sql);
}

發表於 : 2005-07-16 17:38
心靈捕手
To infixman:

建議您做以下的修改\r
#
#-----[ Find ]-----
#
$sql = "SELECT c.cat_title, c.cat_id, f.forum_name, f.forum_id
FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f
WHERE f.cat_id = c.cat_id
ORDER BY c.cat_id, f.forum_order";
".(($userdata['user_level'] == ADMIN)? "" : " AND c.cat_id<>'".HIDDEN_CAT."'" )."

#
#-----[ Replace With ]-----
#
$sql = "SELECT c.cat_title, c.cat_id, f.forum_name, f.forum_id
FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f
WHERE f.cat_id = c.cat_id
".(($userdata['user_level'] == ADMIN)? "" : " AND c.cat_id<>'".HIDDEN_CAT."'" )."
ORDER BY c.cat_id, f.forum_order";
ps. 其實, 您只要貼出發生錯誤行數, 附近的程式碼, 即可.

發表於 : 2005-07-16 18:07
infixman
喔喔~
謝謝老大!!
原來是我太笨...弄錯行@@