[問題] 更新貨幣與版面後的問題[已解決]
發表於 : 2004-12-31 02:14
已解決
我重設了論壇的貨幣
同時 del了 i-shock 和 水怪\r
之後再 del 兩個版面..
之後，每當我發文或回覆均出現\r
以下是我在functions_post.php找到的 (很長=.=" )
有沒有前輩可指點小弟？
我重設了論壇的貨幣
同時 del了 i-shock 和 水怪\r
之後再 del 兩個版面..
之後，每當我發文或回覆均出現\r
代碼: 選擇全部
Error in posting
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near ')' at line 1
INSERT INTO phpbb_posts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig, hiding_type, hiding_condition_value, hiding_cash_id) VALUES (4969, 2, 2, '', 1104430341, 'db4dee10', 1, 0, 1, 1 , 0, 0, )
Line : 271
File : /home/ace-forum/includes/functions_post.php代碼: 選擇全部
$edited_sql = ($mode == 'editpost' && !$post_data['last_post'] && $post_data['poster_post']) ? ", post_edit_time = $current_time, post_edit_count = post_edit_count + 1 " : "";
$sql = ($mode != "editpost") ? "INSERT INTO " . POSTS_TABLE . " (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig, hiding_type, hiding_condition_value, hiding_cash_id) VALUES ($topic_id, $forum_id, " . $userdata['user_id'] . ", '$post_username', $current_time, '$user_ip', $bbcode_on, $html_on, $smilies_on, $attach_sig , $hiding_type, $hiding_value, $hiding_cash_id)" : "UPDATE " . POSTS_TABLE . " SET post_username = '$post_username', enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, enable_sig = $attach_sig, hiding_type = $hiding_type, hiding_condition_value=$hiding_value, hiding_cash_id=$hiding_cash_id" . $edited_sql . " WHERE post_id = $post_id";
if (!$db->sql_query($sql, BEGIN_TRANSACTION))