我已經試過2次了, 結果都如下面一樣
Could not obtain post/user information.
DEBUG MODE
SQL Error : 1054 Unknown column 'u.user_bank' in 'field list'
SELECT u.username, u.user_points, u.user_money, u.user_id, u.user_posts, u.user_level, u.user_from, u.user_website, u.user_bank , 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 phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 1 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
Line : 402
File : viewtopic.php
↓我既view topic.php↓
呢個係 391 行至 399 行的一段
$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_level, u.user_from, u.user_website, u.user_bank , 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'];
$cm_viewtopic->generate_columns($template,$forum_id,$sql);
呢段係 844 至到 855
$poster_joined = ( $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Joined'] . ': ' . create_date($lang['DATE_FORMAT'], $postrow[$i]['user_regdate'], $board_config['board_timezone']) : '';
if( $postrow[$i]['user_id'] != ANONYMOUS && $postrow[$i]['user_id'] != $userdata['user_id'] )
{
$bank="保密";
}else{
$bank=$postrow[$i]['user_bank'];
}
if( $postrow[$i]['user_id'] != ANONYMOUS && $postrow[$i]['user_id'] != $userdata['user_id'] )
{
$loan="保密";
}
$poster_bank = "銀行存款: " . $bank . "";
其實我照你給我的post做的...但因為我還未裝loan 所以我自己改左下~~~
但其實我想做的是 有
↓↓
銀行存款:
銀行貸款:
總資產 :
但我真的不知怎樣做
