很遺憾的ycl6 寫:不知道到後台的"版面管理"使用重整對應資料有沒有用
~Mac
代碼: 選擇全部
$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) VALUES ($topic_id, $forum_id, " . $userdata['user_id'] . ", '$post_username', $current_time, '$user_ip', $bbcode_on, $html_on, $smilies_on, $attach_sig)" : "UPDATE " . POSTS_TABLE . " SET post_username = '$post_username', enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, enable_sig = $attach_sig" . $edited_sql . " WHERE post_id = $post_id";
if (!$db->sql_query($sql, BEGIN_TRANSACTION))
{
message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
}
if ($mode != 'editpost')
{
$post_id = $db->sql_nextid();
}
$sql = ($mode != 'editpost') ? "INSERT INTO " . POSTS_TEXT_TABLE . " (post_id, post_subject, bbcode_uid, post_text) VALUES ($post_id, '$post_subject', '$bbcode_uid', '$post_message')" : "UPDATE " . POSTS_TEXT_TABLE . " SET post_text = '$post_message', bbcode_uid = '$bbcode_uid', post_subject = '$post_subject' WHERE post_id = $post_id";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
}
代碼: 選擇全部
case 'forum':
代碼: 選擇全部
$del_id="";
$sql = "SELECT post_id,topic_id FROM " . POSTS_TABLE . "
WHERE forum_id = $id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not get post ID', '', __LINE__, __FILE__, $sql);
}
while( $row = $db->sql_fetchrow($result) )
{
$sql = "SELECT post_id FROM " . POSTS_TEXT_TABLE . "
WHERE post_id = $row[post_id]";
if ( !($result1 = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Could not get post_txt ID", '', __LINE__, __FILE__, $sql);
}
if (!$row1 = $db->sql_fetchrow($result1))
{
$del_id.=",".$row[post_id];
}
}
$del_id=substr($del_id,1,strlen($del_id));
$sql="delete from ".POSTS_TABLE." where post_id in(".$del_id.")";
$db->sql_query($sql);
unset($del_id);
