[問題]進階隱藏 for CashMod2 1.0.4
發表於 : 2004-08-19 14:20
我setup了後一按送出就會:
Error in posting
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use 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 (49, 2, 2, '', 1092849460, 'cbdae283', 1, 0, 1, 0, 0, 0, )
Line : 271
File : d:\appserv\www\phpbb\includes\functions_post.php
我的fuctions_post.php line 266-276:
266
$edited_sql = ($mode == 'editpost' && !$post_data['last_post'] && $post_data['poster_post']) ? ", post_edit_time = $current_time, post_edit_count = post_edit_count + 1 " : "";267
$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";268
if (!$db->sql_query($sql, BEGIN_TRANSACTION))269
{270
message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);271
}272
273
if ($mode != 'editpost')274
{275
$post_id = $db->sql_nextid();276
Error in posting
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use 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 (49, 2, 2, '', 1092849460, 'cbdae283', 1, 0, 1, 0, 0, 0, )
Line : 271
File : d:\appserv\www\phpbb\includes\functions_post.php
我的fuctions_post.php line 266-276:
266
$edited_sql = ($mode == 'editpost' && !$post_data['last_post'] && $post_data['poster_post']) ? ", post_edit_time = $current_time, post_edit_count = post_edit_count + 1 " : "";267
$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";268
if (!$db->sql_query($sql, BEGIN_TRANSACTION))269
{270
message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);271
}272
273
if ($mode != 'editpost')274
{275
$post_id = $db->sql_nextid();276