1 頁 (共 1 頁)

[外掛][問題]有關Point System的安裝問題

發表於 : 2003-10-13 20:41
alexpan
外掛名稱:Point System
位置:
http://phpbb-tw.net/phpbb/viewtopic.php ... ghlight=積分
php版本:2.0.5
問題描述:
1.可以裝載phpbb2.0.5嗎
2.

代碼: 選擇全部

#-----[ 尋找 ]------------------------------------------ 
# 
$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid 
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt 
WHERE p.topic_id = $topic_id 
$limit_posts_time 
AND pt.post_id = p.post_id 
AND u.user_id = p.poster_id 
ORDER BY p.post_time $post_time_order 
LIMIT $start, ".$board_config['posts_per_page']; 

# 
\n#-----[ 如未更改過任何外掛請直接覆蓋 ]---------------------------------- [color=#ff0022]那如果有改過外掛的話要怎麼辦?改什麼??[/color]
# 
$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_points, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid 
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt 
WHERE p.topic_id = $topic_id 
$limit_posts_time 
AND pt.post_id = p.post_id 
AND u.user_id = p.poster_id 
ORDER BY p.post_time $post_time_order 
LIMIT $start, ".$board_config['posts_per_page']; 

請問這裡面新增了什麼??如果有裝其他Mod,要改哪裡??

發表於 : 2003-10-13 21:30
動機不明
多了一個

u.user_points

這東西~
其實你自己比對一下也知道哪邊不一樣的... ;)

發表於 : 2003-10-14 04:31
h23456789
反正就是給他加在這一段

代碼: 選擇全部

$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile[color=red], u.user_points[/color], p.*, pt.post_text, pt.post_subject, pt.bbcode_uid 
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt 
WHERE p.topic_id = $topic_id 
$limit_posts_time 
AND pt.post_id = p.post_id 
AND u.user_id = p.poster_id 
ORDER BY p.post_time $post_time_order 
LIMIT $start, ".$board_config['posts_per_page']; 
, u.user_allowsmile 這個的後面就是了@"@