吉川拓也 寫:其實可以學天霜版主用中英文並進 ...
#
#--- [ IN LINE FIND / 在行內找到 ]---
#
#
#--- [ IN LINE AFTER ADD / 在該行之後加入 ]---
#
我說的那個部分
用這個方式,很難表示出來
找到========================
代碼: 選擇全部
$sql = "UPDATE " . FORUMS_TABLE . "
SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
取代為======================
代碼: 選擇全部
//forum_sub start
$forum_set=$HTTP_POST_VARS[POST_CAT_URL];
if(empty($forum_set))
{
message_die(GENERAL_ERROR, "設定錯誤");
}
else
{
$sql = "select count(forum_sub) as id from " . FORUMS_TABLE . " WHERE forum_sub = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "設定錯誤");
}
$get_sub_Id = $db->sql_fetchrow($result);
if($get_sub_Id[id]>0)
{
message_die(GENERAL_ERROR, "此版面有其他子版面相連,無法設定成子版面");
}
$temp=split(",",$forum_set);
$c=intval($temp[0]);
$forum_sub=intval($temp[1]);
if(intval($HTTP_POST_VARS[POST_FORUM_URL])== $forum_sub)
{
$sort_sub=intval($temp[2]);
$sql = "UPDATE " . FORUMS_TABLE . "
SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
}else
{
if(intval($temp[1])>0)
{
$sort_sub=intval($temp[2])+1;
}else
{
$sort_sub=intval($temp[2]);
}
$sql = "UPDATE " . FORUMS_TABLE . "
SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . $c . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
,forum_sub=".$forum_sub.",sort_sub=".$sort_sub."
WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
}
}
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't update forum information", "", __LINE__, __FILE__, $sql);
}
//forum_sub end