[建議] 文章排序問題 for phpbb2.0.4

文章由 **zengpx** » 2003-07-24 23:05

原文出處：文章排序問題

以下部份不適用於 phpbb 2.0.4

# 
#--- [ OPEN ] -------- 
# 

viewtopic.php 

# 
#-- [ FIND (line 200) ]---- 
# 

if(!empty($post_id) ) 
{ 
$start = floor( ($forum_row['prev_posts'] - 1) / $board_config['posts_per_page']) * $board_config['posts_per_page']; 
} 

# 
#---- [ REPLACE WITH ]----- 
# 

// 
// Decide how to order the post display 
// 
if ( !empty($HTTP_POST_VARS['postorder']) || !empty($HTTP_GET_VARS['postorder']) ) 
{ 
$post_order = (!empty($HTTP_POST_VARS['postorder'])) ? $HTTP_POST_VARS['postorder'] : $HTTP_GET_VARS['postorder']; 
$post_time_order = ($post_order == "asc") ? "ASC" : "DESC"; 
} 
else 
{ 
$post_order = ( $userdata['user_post_sort'] == TRUE ) ? 'desc' : 'asc'; 
$post_time_order = ( $userdata['user_post_sort'] == TRUE ) ? 'DESC' : 'ASC'; 
} 

if(!empty($post_id) ) 
{ 
$posts_before = ( $post_order == 'desc' )? (($forum_row['topic_replies'] + 1) - $forum_row['prev_posts']) : ($forum_row['prev_posts'] - 1); 
$start = floor( $posts_before / $board_config['posts_per_page']) * $board_config['posts_per_page']; 
} 


# 
#--- [ DELETE (line 358) ] -------- 
# 

// 
// Decide how to order the post display 
// 
if ( !empty($HTTP_POST_VARS['postorder']) || !empty($HTTP_GET_VARS['postorder']) ) 
{ 
$post_order = (!empty($HTTP_POST_VARS['postorder'])) ? $HTTP_POST_VARS['postorder'] : $HTTP_GET_VARS['postorder']; 
$post_time_order = ($post_order == "asc") ? "ASC" : "DESC"; 
} 
else 
{ 
$post_order = 'asc'; 
$post_time_order = 'ASC'; 
}

請改為：
否則無法連結到正確的最新發表文章

代碼: 選擇全部

# 
#--- [ OPEN ] -------- 
# 

viewtopic.php 

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

//
// Decide how to order the post display
//
if ( !empty($HTTP_POST_VARS['postorder']) || !empty($HTTP_GET_VARS['postorder']) )
{
$post_order = (!empty($HTTP_POST_VARS['postorder'])) ? $HTTP_POST_VARS['postorder'] : $HTTP_GET_VARS['postorder'];
$post_time_order = ($post_order == "asc") ? "ASC" : "DESC";
}
else
{
$post_order = 'asc';
$post_time_order = 'ASC';
}

# 
#---- [ REPLACE WITH ]----- 
# 
// 
// Decide how to order the post display 
// 
if ( !empty($HTTP_POST_VARS['postorder']) || !empty($HTTP_GET_VARS['postorder']) ) 
{ 
$post_order = (!empty($HTTP_POST_VARS['postorder'])) ? $HTTP_POST_VARS['postorder'] : $HTTP_GET_VARS['postorder']; 
$post_time_order = ($post_order == "asc") ? "ASC" : "DESC"; 
} 
else 
{ 
$post_order = ( $userdata['user_post_sort'] == TRUE ) ? 'desc' : 'asc'; 
$post_time_order = ( $userdata['user_post_sort'] == TRUE ) ? 'DESC' : 'ASC'; 
} 

if(!empty($post_id) ) 
{ 
$posts_before = ( $post_order == 'desc' )? (($forum_topic_data['topic_replies'] + 1) - $forum_topic_data['prev_posts']) : ($forum_topic_data['prev_posts'] - 1); 
$start = floor( $posts_before / intval($board_config['posts_per_page'])) * intval($board_config['posts_per_page']); 
}
###

以下有個變數名稱需要更正

代碼: 選擇全部

# 
#--- [ FIND (line 491) ] -------- 
# 

$sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) 
VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popuppm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, "; 


# 
#--- [ REPLACE WITH ] -------- 
# 



$sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_post_sort, user_level, user_allow_pm, user_active, user_actkey) 
VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popuppm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, $user_post_sort, 0, 1, ";

請將上述 REPLACE WITH 部份中的 $password
改成 $new_password
否則註冊時，無法將密碼寫入 MySQL