forums.php

xm2sv1.0寻梦二手网 v1.0,一个经过我调试的PHP原代码,有机会大家多交流哈

<tr align="center"><td bgcolor="<?=ALTBG1?>" width="40%">目标论坛：</td>
<td bgcolor="<?=ALTBG2?>" width="60%"><?=sprintf($forumselect, "target")?></td></tr>
</table></td></tr></table><br><center><input type="submit" name="mergesubmit" value="合并论坛"></center></form>
<?

	} else {

	        $query = $db->query("SELECT COUNT(*) FROM $table_forums WHERE fup='$source'");
	        if($db->result($query, 0)) {
        		cpmsg("源论坛下级论坛不为空，请先返回修改相关下级论坛的上级设置。");
        	}

		$db->query("UPDATE $table_threads SET fid='$target' WHERE fid='$source'");
		$db->query("UPDATE $table_posts SET fid='$target' WHERE fid='$source'");

		$query = $db->query("SELECT threads, posts FROM $table_forums WHERE fid='$source'");
		$sourceforum = $db->fetch_array($query);
		$db->query("UPDATE $table_forums SET threads=threads+$sourceforum[threads], posts=posts+$sourceforum[posts] WHERE fid='$target'");
		$db->query("DELETE FROM $table_forums WHERE fid='$source'");

		updatecache("forums");
		cpmsg("论坛合并成功。");
	}

} elseif($action == "forumdetail") {

	$perms = array("viewperm", "postperm", "getattachperm", "postattachperm");

        if(!$detailsubmit) {
        	$query = $db->query("SELECT * FROM $table_forums WHERE fid='$fid'");
        	$forum = $db->fetch_array($query);
        	$forum['name'] = dhtmlspecialchars($forum[name]);

        	echo "<br><form method=\"post\" action=\"admincp.php?action=forumdetail&fid=$fid\">\n".
        		"<input type=\"hidden\" name=\"type\" value=\"$forum[type]\">\n";

        	if($forum[type] == "group") {

			showtype("分类名称设置 - $forum[name]", "top");
			showsetting("分类名称：", "namenew", $forum[name], "text", "");
			showtype("", "bottom");

        	} else {

			$fupselect = "<select name=\"fupnew\">\n<option value=\"0\" ".(!$forum[fup] ? "selected=\"selected\"" : NULL)."> - 无 - </option>\n";
			$query = $db->query("SELECT fid, name FROM $table_forums WHERE fid<>'$fid' AND type<>'sub' ORDER BY displayorder");
			while($fup = $db->fetch_array($query)) {
				$selected = $fup[fid] == $forum[fup] ? "selected=\"selected\"" : NULL;
				$fupselect .= "<option value=\"$fup[fid]\" $selected>$fup[name]</option>\n";
			}
			$fupselect .= "</select>";
			$query = $db->query("SELECT groupid, grouptitle FROM $table_usergroups");
			while($group = $db->fetch_array($query)) {
				$groups[] = $group;
			}

			$styleselect = '<select name="styleidnew"><option value="0">--使用默认--</option>';
			$query = $db->query("SELECT styleid, name FROM $table_styles");
			while($style = $db->fetch_array($query)) {
				$styleselect .= "<option value=\"$style[styleid]\" ".
					($style['styleid'] == $forum['styleid'] ? 'selected="selected"' : NULL).
					">$style[name]</option>\n";
			}
			$styleselect .= '</select>';

                	foreach($perms as $perm) {
	                	$num = -1;
                		$$perm = "<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\" align=\"center\"><tr>";
				foreach($groups as $group) {
					$num++;
					if($num && $num % 4 == 0) {
						$$perm .= "</tr><tr>";
					}
	                        	$checked = strstr($forum[$perm], "\t$group[groupid]\t") ? "checked" : NULL;
                        		$$perm .= "<td><input type=\"checkbox\" name=\"{$perm}[]\" value=\"$group[groupid]\" $checked> $group[grouptitle]</td>\n";
				}
                		$$perm .= "</tr></table>";
                	}

			$forum['description'] = str_replace("&lt;", "<", $forum['description']);
			$forum['description'] = str_replace("&gt;", ">", $forum['description']);

			showtype("论坛详细设置 - $forum[name]", "top");
			showsetting("显示论坛：", "statusnew", $forum['status'], "radio", "选择“否”将暂时将论坛隐藏不显示，但论坛内容仍将保留");
			showsetting("上级论坛：", "", "", $fupselect, "本论坛的上级论坛或分类");
			showsetting("上级论坛：", "", "", $styleselect, '访问者进入本论坛所使用的风格方案');
			showsetting("论坛名称：", "namenew", $forum['name'], "text");
			showsetting("论坛图标：", "iconnew", $forum['icon'], "text", "论坛名称和简介左侧的小图标，可填写相对或绝对地址");
			showsetting("论坛简介：", "descriptionnew", $forum['description'], "textarea", "将显示于论坛名称的下面，提供对本论坛的简短描述");

			showtype("贴子选项");
			showsetting("允许使用 html 代码：", "allowhtmlnew", $forum[allowhtml], "radio", "注意：选择“是”将不屏蔽贴子中的任何代码，有可能造成不安全因素，请慎用");
			showsetting("允许使用 Discuz! 代码：", "allowbbcodenew", $forum[allowbbcode], "radio", "Discuz! 代码是一种简化和安全的页面格式代码，可<a href=\"./faq.php?page=misc#1\" target=\"_blank\">点击这里查看本论坛提供的 Discuz! 代码</a>");
			showsetting("允许使用 [img] 代码：", "allowimgcodenew", $forum[allowimgcode], "radio", "允许 [img] 代码作者将可以在贴子插入其他网站的图片并显示");
			showsetting("允许使用 Smilies：", "allowsmiliesnew", $forum[allowsmilies], "radio", "Smilies 提供对表情符号，如“:)”的解析，使之作为图片显示");
			
			showtype("论坛权限 - 全不选则按照默认设置");
			showsetting("访问密码：", "passwordnew", $forum[password], "text", "", "15%");
			showsetting("浏览论坛许可", "", "", str_replace("cdb_groupname", "viewperm", $viewperm), "", "15%");
			showsetting("发帖许可", "", "", str_replace("cdb_groupname", "postperm", $postperm), "", "15%");
			showsetting("下载附件许可", "", "", str_replace("cdb_groupname", "getattachperm", $getattachperm), "", "15%");
			showsetting("上传附件许可", "", "", str_replace("cdb_groupname", "postattachperm", $postattachperm), "", "15%");
			showtype('', 'bottom');

        	}

		echo "<br><br><center><input type=\"submit\" name=\"detailsubmit\" value=\"确认更改\"></form>";

	} else {

		if($type == 'group') {

			if($namenew) {
				$db->query("UPDATE $table_forums SET name='$namenew' WHERE fid='$fid'");
				updatecache("forums");
				cpmsg("分类名称成功更新。");
			} else {
				cpmsg("您没有输入分类名称，请返回修改。");
			}
			
		} else {

			foreach($perms as $perm) {
				if(is_array($$perm)) {
					${$perm."new"} = "\t";
					foreach($$perm as $groupid) {
						${$perm."new"} .= "\t$groupid";
					}
					${$perm."new"} .= "\t\t";
				}
			}

			$query = $db->query("SELECT type FROM $table_forums WHERE fid='$fupnew'");
			$fuptype = $db->result($query, 0);
			$typenew = $fuptype == "forum" ? "sub" : "forum";
			$db->query("UPDATE $table_forums SET type='$typenew', status='$statusnew', fup='$fupnew', name='$namenew', icon='$iconnew',
				description='$descriptionnew', styleid='$styleidnew', allowhtml='$allowhtmlnew', allowbbcode='$allowbbcodenew',
				allowimgcode='$allowimgcodenew', allowsmilies='$allowsmiliesnew', password='$passwordnew', viewperm='$viewpermnew',
				postperm='$postpermnew', getattachperm='$getattachpermnew', postattachperm='$postattachpermnew' WHERE fid='$fid'");

			updatecache("forums");
			cpmsg("论坛设置成功更新。");
		}

	}

} elseif($action == "forumdelete") {

        $query = $db->query("SELECT COUNT(*) FROM $table_forums WHERE fup='$fid'");
        if($db->result($query, 0)) {
        	cpmsg("下级论坛不为空，请先返回删除本分类或论坛的下级论坛。");
        }

        if(!$confirmed) {
		cpmsg("本操作不可恢复，您确定要删除该论坛，清除其中贴子<br>和附件并处理相关会员的发帖和积分数据吗？", "admincp.php?action=forumdelete&fid=$fid", "form");
        } else {
       		require $discuz_root.'./include/post.php';
        	$query = $db->query("SELECT COUNT(*) AS postnum, author FROM $table_posts WHERE fid='$fid' GROUP BY author");
        	while($post = $db->fetch_array($query)) {
        		updatemember('-', $post['author'], $post['postnum']);
        	}

        	$query = $db->query("SELECT pid FROM $table_posts WHERE aid<>'0' AND fid='$fid'");
        	$aid = $comma = "";
        	while($post = $db->fetch_array($query)) {
        		$aid .= "$comma'$post[aid]'";
        		$comma = ", ";
        	}

        	if($aid) {
        		$query = $db->query("SELECT filename FROM $table_attachments WHERE aid IN ($aid)");
        		while($attach = $db->fetch_array($query)) {
        			@unlink("$attachdir/$attach[filename]");
        		}
			$db->query("DELETE FROM $table_attachments WHERE aid IN ($aid)");
        	}

		$db->query("DELETE FROM $table_threads WHERE fid='$fid'");
		$db->query("DELETE FROM $table_posts WHERE fid='$fid'");
		$db->query("DELETE FROM $table_forums WHERE fid='$fid'");

		updatecache("forums");
		cpmsg("论坛成功删除。");
        }

}

?>