bug in win2000 [message #2979] |
Thu, 06 June 2002 08:47 |
|
sorry for my bad english !:(
just in nt/2000
$tmp=do [Report message to a moderator];
if($tmp){
if(Logout [ ezdb ]){
echo"
Query Failed: SELECT fud2_msg.*, fud_msg_2.subject AS thread_subject, fud2_thread.root_msg_id, fud2_thread.locked, fud2_thread.forum_id, fud2_avatar.img AS avatar, fud2_users.id AS user_id, fud2_users.login, fud2_users.custom_status, fud2_users.display_email, fud2_users.email, fud2_users.posted_msg_count, fud2_users.join_date, fud2_users.location, fud2_users.sig, fud2_users.icq, fud2_users.aim, fud2_users.jabber, fud2_users.msnm, fud2_users.yahoo, fud2_users.is_mod, fud2_users.avatar_loc, fud2_users.avatar_approved, fud2_users.invisible_mode, fud2_users.email_messages, fud2_msg_report.id AS report_id, fud2_msg_report.stamp AS report_stamp, fud2_msg_report.reason AS report_reason, fud_users_r.id AS report_user_id, fud_users_r.login AS report_user_login, fud2_ses.time_sec AS time_sec, fud2_level.name AS level_name, fud2_level.pri AS level_pri, fud2_level.img AS level_img, fud2_forum.name AS frm_name, fud_ses_r.time_sec AS time_sec_r FROM fud2_msg_report LEFT JOIN fud2_msg ON fud2_msg_report.msg_id=fud2_msg.id LEFT JOIN fud2_users ON fud2_msg.poster_id=fud2_users.id LEFT JOIN fud2_avatar ON fud2_users.avatar=fud2_avatar.id LEFT JOIN fud2_thread ON fud2_msg.thread_id=fud2_thread.id LEFT JOIN fud2_msg AS fud_msg_2 ON fud_msg_2.id=fud2_thread.root_msg_id LEFT JOIN fud2_forum ON fud2_thread.forum_id=fud2_forum.id INNER JOIN fud2_mod ON fud2_forum.id=fud2_mod.forum_id AND fud2_mod.user_id= LEFT JOIN fud2_users AS fud_users_r ON fud2_msg_report.user_id=fud_users_r.id LEFT JOIN fud2_ses ON fud2_ses.user_id=fud2_msg.poster_id LEFT JOIN fud2_ses AS fud_ses_r ON fud2_msg_report.user_id=fud_ses_r.user_id LEFT JOIN fud2_level ON fud2_users.level_id=fud2_level.id ORDER BY fud2_msg_report.id
Reason: You have an error in your SQL syntax near 'JOIN fud2_users AS fud_users_r ON fud2_msg_report.user_id=fud_users_r.id ' at line 53
From: c:/php4/php.exe
Server Version: 3.23.46-nt
";
}else{
echo "ok!";
}
}else{
echo "ok";
}
|
|
|