[問題]在線狀態
發表於 : 2003-07-21 21:54
請教各位..
我案文章所以交ㄉ方法是過一邊...
可以顯示...
但都是離線中.......
可是我已經登入ㄌ...卻沒顯示上線中....
因為收詢ㄉ教學文章我都不能回覆問問題...
所以來這請教各位...謝謝...
我之錢莊過虛擬貨幣..
所以我適用..比較過之後才貼
代碼:
//
// Go ahead and pull all data for this topic
//
$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_money, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile,
u.user_allow_viewonline, u.user_session_time, 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
AND p.poster_id = u.user_id
AND p.post_id = pt.post_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'];
我案文章所以交ㄉ方法是過一邊...
可以顯示...
但都是離線中.......
可是我已經登入ㄌ...卻沒顯示上線中....
因為收詢ㄉ教學文章我都不能回覆問問題...
所以來這請教各位...謝謝...
我之錢莊過虛擬貨幣..
所以我適用..比較過之後才貼
代碼:
//
// Go ahead and pull all data for this topic
//
$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_money, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile,
u.user_allow_viewonline, u.user_session_time, 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
AND p.poster_id = u.user_id
AND p.post_id = pt.post_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'];