查看您的 admin_forums.php
發現您在 $sql 的部分原來已經有新增兩個值(
forum_icon, forum_access),
而針對簡易子版面外掛, 您在該處增值(
forum_sub, sort_sub, main_sub) 的語法, 顯得有些錯亂.
以下的修改, 提供您參考:
#
#-----[ FIND ]-----
#
代碼: 選擇全部
$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, forum_icon, forum_access, prune_enable,forum_sub,sort_sub" . $field_sql . ")
VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "', " . intval($HTTP_POST_VARS['forumaccess']) . ", " . intval($HTTP_POST_VARS['prune_enable']). ", " .$forum_sub.",".$sort_sub."," . $value_sql . ")";
#
#-----[ REPLACE WITH ]-----
#
$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, forum_sub, sort_sub, main_sub, forum_icon, forum_access, prune_enable " . $field_sql . ")
VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . $c . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . $forum_sub . ", " . $sort_sub . ", " . $main_sub . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "', " . intval($HTTP_POST_VARS['forumaccess']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";
#
#-----[ FIND ]-----
#
代碼: 選擇全部
//forum_sub start
$forum_set=$HTTP_POST_VARS[POST_CAT_URL];
if(empty($forum_set))
{
message_die(GENERAL_ERROR, "?#93;定錯誤");
}
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, "?#93;定錯誤");
}
$get_sub_Id = $db->sql_fetchrow($result);
if($get_sub_Id[id]>0)
{
message_die(GENERAL_ERROR, "此版面有其他子版面相連,無法?#93;定成子版面");
}
$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']) . "', cat_id = " . $c . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", forum_icon = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "', forum_access = " . intval($HTTP_POST_VARS['forumaccess']) . ", 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
}else
{
if(intval($temp[1])>0)
{
$sort_sub=intval($temp[2])+1;
}else
{
$sort_sub=intval($temp[2]);
}
#
#-----[ REPLACE WITH ]-----
#
//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]);
$HTTP_POST_VARS['forumname']=str_replace("<","",$HTTP_POST_VARS['forumname']);
$HTTP_POST_VARS['forumdesc']=str_replace("<","",$HTTP_POST_VARS['forumdesc']);
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']) . ", forum_icon = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "', forum_access = " . intval($HTTP_POST_VARS['forumaccess']) . ", 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]);
}
$main_sub=intval($temp[3]);
$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']) . ", forum_icon = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "', forum_access = " . intval($HTTP_POST_VARS['forumaccess']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . ",forum_sub=".$forum_sub.",sort_sub=".$sort_sub.",main_sub=".$main_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