members.php

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

		$db->query("UPDATE $table_members SET status='$statusnew', email='$emailnew', credit='$creditnew', postnum='$userpostnum', regip='$regip', regdate='$regdate', lastvisit='$lastvisittime', site='$site', oicq='$oicq', icq='$icq', yahoo='$yahoo', msn='$msn', location='$memlocation', bday='$bday', bio='$bio', styleid='$styleidnew', tpp='$tppnew', ppp='$pppnew', timeformat='$timeformatnew', customstatus='$cstatus', ignorepm='$ignorepm', showemail='$showemail', newsletter='$newsletter', timeoffset='$timeoffset1', avatar='$avatar', signature='$sig' $passwdadd WHERE username='$username'");
		if($username != $newusername) {
			$query = $db->query("SELECT COUNT(*) FROM $table_members WHERE username='$newusername'");
			if($db->result($query, 0)) {
				$usernameadd = "但新用户名与现有用户名重复，无法修改。";
			} else {
				$db->query("UPDATE $table_buddys SET username='$newusername' WHERE username='$username'");
				$db->query("UPDATE $table_buddys SET buddyname='$newusername' WHERE buddyname='$username'");
				$db->query("UPDATE $table_favorites SET username='$newusername' WHERE username='$username'");
				$db->query("UPDATE $table_subscriptions SET username='$newusername' WHERE username='$username'");
				$db->query("UPDATE $table_members SET username='$newusername' WHERE username='$username'");
				$db->query("UPDATE $table_posts SET author='$newusername' WHERE author='$username'");
				$db->query("UPDATE $table_threads SET author='$newusername' WHERE author='$username'");
				$db->query("UPDATE $table_threads SET lastposter='$newusername' WHERE lastposter='$username'");
				$db->query("UPDATE $table_forums SET lastpost=REPLACE(lastpost, '\t$username', '\t$newusername')");
				$db->query("UPDATE $table_pm SET msgfrom='$newusername' WHERE msgfrom='$username'");
				$db->query("UPDATE $table_pm SET msgto='$newusername' WHERE msgto='$username'");
			}
		}
		cpmsg("用户资料成功更新。$usernameadd");
	}

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

	if(!$groupsubmit) {

		if($type != "detail" || !$id) {
			$membergroup = $specifiedgroup = $sysgroup = "";
			$upperlimit = $lowerlimit = $misconfig = 0;
			$query = $db->query("SELECT groupid, specifiedusers, status, grouptitle, creditshigher, creditslower, stars, groupavatar FROM $table_usergroups ORDER BY creditslower");
			while($group = $db->fetch_array($query)) {
				if($group[status] == "Member" && !$group[specifiedusers]) {
					$membergroup .= "<tr align=\"center\"><td bgcolor=\"".ALTBG1."\"><input type=\"checkbox\" name=\"delete[{$group[groupid]}]\" value=\"$group[groupid]\"></td>\n".
						"<td bgcolor=\"".ALTBG2."\"><input type=\"text\" size=\"12\" name=\"group_title[{$group[groupid]}]\" value=\"$group[grouptitle]\"></td>\n".
						"<td bgcolor=\"".ALTBG1."\"><input type=\"text\" size=\"6\" name=\"group_creditshigher[{$group[groupid]}]\" value=\"$group[creditshigher]\">\n".
						"<td bgcolor=\"".ALTBG2."\"><input type=\"text\" size=\"6\" name=\"group_creditslower[{$group[groupid]}]\" value=\"$group[creditslower]\"></td>\n".
						"<td bgcolor=\"".ALTBG1."\"><input type=\"text\" size=\"2\"name=\"group_stars[{$group[groupid]}]\" value=\"$group[stars]\"></td>\n".
						"<td bgcolor=\"".ALTBG2."\"><input type=\"text\" size=\"20\" name=\"group_avatar[{$group[groupid]}]\" value=\"$group[groupavatar]\"></td>".
						"<td bgcolor=\"".ALTBG1."\"><a href=\"admincp.php?action=usergroups&type=detail&id=$group[groupid]\">[详情]</a></td></tr>\n";
					if($group[creditshigher] > 0 && $upperlimit != $group[creditshigher]) {
						//echo "$upperlimit $group[creditshigher]<br>"; //debug
						$misconfig = 1;
					}
					$lowerlimit = $group[creditshigher] < $lowerlimit ? $group[creditshigher] : $lowerlimit;
					$upperlimit = $group[creditslower] > $upperlimit ? $group[creditslower] : $upperlimit;
				} elseif($group[specifiedusers]) {
					$group[specifiedusers] = str_replace("\t", ", ", substr($group[specifiedusers], 1, -1));
					$specifiedgroup .= "<tr align=\"center\"><td bgcolor=\"".ALTBG1."\"><input type=\"checkbox\" name=\"delete[{$group[groupid]}]\" value=\"$group[groupid]\"></td>\n".
						"<td bgcolor=\"".ALTBG2."\"><input type=\"text\" size=\"12\" name=\"group_title[{$group[groupid]}]\" value=\"$group[grouptitle]\"></td>\n".
						"<td bgcolor=\"".ALTBG1."\"><input type=\"text\" size=\"20\" name=\"group_specifiedusers[{$group[groupid]}]\" value=\"$group[specifiedusers]\">\n".
						"<td bgcolor=\"".ALTBG2."\"><input type=\"text\" size=\"2\"name=\"group_stars[{$group[groupid]}]\" value=\"$group[stars]\"></td>\n".
						"<td bgcolor=\"".ALTBG1."\"><input type=\"text\" size=\"20\" name=\"group_avatar[{$group[groupid]}]\" value=\"$group[groupavatar]\"></td>\n".
						"<td bgcolor=\"".ALTBG2."\"><a href=\"admincp.php?action=usergroups&type=detail&id=$group[groupid]\">[详情]</a></td></tr>\n";
				} else {
					$sysgroup .= "<tr align=\"center\">\n".
						"<td bgcolor=\"".ALTBG2."\"><input type=\"text\" size=\"12\" name=\"group_title[{$group[groupid]}]\" value=\"$group[grouptitle]\"></td>\n".
						"<td bgcolor=\"".ALTBG1."\">$group[status]</td>\n".
						"<td bgcolor=\"".ALTBG2."\"><input type=\"text\" size=\"2\"name=\"group_stars[{$group[groupid]}]\" value=\"$group[stars]\"></td>\n".
						"<td bgcolor=\"".ALTBG1."\"><input type=\"text\" size=\"20\" name=\"group_avatar[{$group[groupid]}]\" value=\"$group[groupavatar]\"></td>\n".
						"<td bgcolor=\"".ALTBG2."\"><a href=\"admincp.php?action=usergroups&type=detail&id=$group[groupid]\">[详情]</a></td></tr>\n";
				}
			}
			if($misconfig || $upperlimit < 9999 || $lowerlimit > -999) {
				$warning = "<script>alert('当前积分设定存在明显问题，请根据提示尽快修正。');</script><span class=\"mediumtxt\"><b>警告！</b>您当前的设定并未覆盖整个积分范围(建议 -99999 到 99999)，或相邻两组间积分上下限存在<br>空隙或重叠。请立即完善会员组设定或恢复到默认，否则将导致部分用户无法访问论坛的严重问题！</span><br><br>";
			}

?>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr class="header"><td>特别提示</td></tr>
<tr bgcolor="<?=ALTBG1?>"><td>
<br><ul><li>Discuz! 论坛的用户组分为系统组、特殊组和会员组，区别在于确定所在用户组的方式：系统组按照用户的系统头衔确定；特殊组按照指定的特别用户名确定；会员组按照会员的积分来确定。每个组可以分别设置相应的权限。</ul>
<ul><li>系统组和特殊组的设定不需要指定积分，Discuz! 预留了从论坛管理员到游客等的 8 个系统头衔，特殊组的多个用户名之间可用半角逗号 "," 分割。</ul>
<ul><li>会员组积分设定的总体范围必须能满足实际的要求，如 -99999 到 99999，而且，不同的组之间积分范围不要出现重叠，否则将出现混乱。</ul>
<ul><li>如果您不小心误操作，导致问题，可点击“恢复默认”按钮将设定恢复到初始状态。</ul>
</td></tr></table></td></tr></table>

<form method="post" action="admincp.php?action=usergroups&type=member">
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr class="header"><td colspan="7">会员用户组 - 点击组头衔编辑详细权限设置</td></tr>
<tr class="header" align="center"><td width="45"><input type="checkbox" name="chkall" class="header" onclick="checkall(this.form)">删?</td>
<td>组头衔</td><td>积分下限</td><td>积分上限</td><td>星星数</td><td>组头像</td><td>编辑</td></tr>
<?=$membergroup?>
<tr height="1" bgcolor="<?=ALTBG2?>"><td colspan="7"></td></tr>
<tr align="center" bgcolor="<?=ALTBG1?>"><td>新增：</td>
<td><input type="text" size="12" name="grouptitlenew"></td>
<td><input type="text" size="6" name="creditshighernew"></td>
<td><input type="text" size="6" name="creditslowernew"></td>
<td><input type="text" size="2" name="starsnew"></td>
<td><input type="text" size="20" name="groupavatarnew"></td>
<td>&nbsp;</td>
</tr></table></td></tr></table><br><center><?=$warning?>
<input type="submit" name="groupsubmit" value="编辑会员用户组">&nbsp;
<input type="button" name="reset" value="恢复到默认设定" onClick="top.main.location.href='admincp.php?action=usergroups&type=member&reset=yes&groupsubmit=yes';"></center></form><br><br>

<form method="post" action="admincp.php?action=usergroups&type=specified">
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr class="header"><td colspan="6">特殊用户组 - 点击组头衔编辑详细权限设置</td></tr>
<tr class="header" align="center"><td width="45"><input type="checkbox" name="chkall" class="header" onclick="checkall(this.form)">删?</td>
<td>组头衔</td><td>包含用户</td><td>星星数</td><td>组头像</td><td>编辑</td></tr>
<?=$specifiedgroup?>
<tr height="1" bgcolor="<?=ALTBG2?>"><td colspan="6"></td></tr>
<tr align="center" bgcolor="<?=ALTBG1?>"><td>新增：</td>
<td><input type="text" size="12" name="grouptitlenew"></td>
<td><input type="text" size="20" name="specifiedusersnew"></td>
<td><input type="text" size="2" name="starsnew"></td>
<td><input type="text" size="20" name="groupavatarnew"></td>
<td>&nbsp;</td>
</tr></table></td></tr></table><br><center>
<input type="submit" name="groupsubmit" value="编辑特殊用户组"></center></form><br><br>

<form method="post" action="admincp.php?action=usergroups&type=system">
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr class="header"><td colspan="5">系统用户组 - 点击组头衔编辑详细权限设置</td></tr>
<tr class="header" align="center">
<td>组头衔</td><td>系统头衔</td><td>星星数</td><td>组头像</td><td>编辑</td></tr>
<?=$sysgroup?>
</table></td></tr></table><br><center>
<input type="submit" name="groupsubmit" value="编辑系统用户组"></center></form>
<?

		} else {

			if(!$detailsubmit) {
				$query = $db->query("SELECT * FROM $table_usergroups WHERE groupid='$id'");
				$group = $db->fetch_array($query);
				$checksearch = array($group['allowsearch'] => 'checked');
				$checkavatar = array($group['allowavatar'] => 'checked');

				echo "<form method=\"post\" action=\"admincp.php?action=usergroups&type=detail&id=$id\">\n";

				showtype("编辑用户组", "top");
				showsetting("用户组头衔", "grouptitlenew", $group[grouptitle], "text");

				showtype("基本权限");
				if($group[status] == "Guest") {
					echo "<input type=\"hidden\" name=\"allowvisitnew\" value=\"1\">\n";
				} else {
					showsetting("允许访问论坛：", "allowvisitnew", $group[allowvisit], "radio", "选择“否”将彻底禁止用户访问论坛的任何页面");
				}
				showsetting("允许浏览贴子：", "allowviewnew", $group[allowview], "radio", "设置是否允许浏览没有设置特殊权限的一般贴子");
				showsetting("允许查看统计数据：", "allowviewstatsnew", $group[allowviewstats], "radio", "设置是否允许用户查看论坛统计数据");
				showsetting("允许使用搜索：", '', '', "<input type=\"radio\" name=\"allowsearchnew\" value=\"0\" $checksearch[0]> 禁用搜索<br><input type=\"radio\" name=\"allowsearchnew\" value=\"1\" $checksearch[1]> 只允许搜索标题<br><input type=\"radio\" name=\"allowsearchnew\" value=\"2\" $checksearch[2]> 允许搜索贴子内容", "设置是否允许论坛贴子搜索功能");
				showsetting("允许使用头像：", '', '', "<input type=\"radio\" name=\"allowavatarnew\" value=\"0\" $checkavatar[0]> 禁用头像<br><input type=\"radio\" name=\"allowavatarnew\" value=\"1\" $checkavatar[1]> 允许使用论坛提供头像<br><input type=\"radio\" name=\"allowavatarnew\" value=\"2\" $checkavatar[2]> 允许自定义头像", "设置是否允许使用头像和可用头像的类型");
				showsetting("允许自定义头衔：", "allowcstatusnew", $group[allowcstatus], "radio", "设置是否允许用户设置自己的头衔名字并在贴子中显示");
				showsetting("允许参与评分：", "allowkarmanew", $group[allowkarma], "radio", "设置是否可以给别人的贴子评分");
				showsetting("每次最大评价分数：", "maxkarmaratenew", $group[maxkarmarate], "text", "设置每次评分允许的最大分数，需要拥有参与评分的权限才有效");
				showsetting("每天最大评价分数：", "maxrateperdaynew", $group[maxrateperday], "text", "设置每 24 小时允许评分的最大分数，需要拥有参与评分的权限才有效");
				showsetting("短消息收件箱容量：", "maxpmnumnew", $group[maxpmnum], "text", "设置用户短消息最大可保存的消息数目");
				showsetting("备忘录容量：", "maxmemonumnew", $group[maxmemonum], "text", "设置用户备忘录最大可保存的数目，如为 0 则禁止用户使用");

				showtype("贴子相关");
				showsetting("允许发贴：", "allowpostnew", $group[allowpost], "radio", "设置是否允许发新话题或发表回复");
				showsetting("允许设置贴子权限：", "allowsetviewpermnew", $group[allowsetviewperm], "radio", "设置是否允许设置贴子需要指定积分以上才可浏览");
				showsetting("允许发起投票：", "allowpostpollnew", $group[allowpostpoll], "radio", "设置是否允许发布投票贴");
				showsetting("允许参与投票：", "allowvotenew", $group[allowvote], "radio", "设置是否允许参与论坛的投票");
				showsetting("允许签名中使用 BB 代码：", "allowsigbbcodenew", $group[allowsigbbcode], "radio", "设置是否解析用户签名中的 BB 代码");
				showsetting("允许签名中使用 [img] 代码：", "allowsigimgcodenew", $group[allowsigimgcode], "radio", "设置是否解析用户签名中的 [img] 代码");
				showsetting("最大签名长度：", "maxsigsizenew", $group[maxsigsize], "text", "设置用户签名最大字节数");

				showtype("附件相关");
				showsetting("允许下载附件：", "allowgetattachnew", $group[allowgetattach], "radio", "设置是否允许从没有设置特殊权限的论坛中下载附件");
				showsetting("允许发布附件：", "allowpostattachnew", $group[allowpostattach], "radio", "设置是否允许上传附件到没有设置特殊权限的论坛中。需要 PHP 设置允许才有效，请参考系统设置首页");
				showsetting("允许设置附件权限：", "allowsetattachpermnew", $group[allowsetattachperm], "radio", "设置是否允许设置附件需要指定积分以上才可下载");
				showsetting("最大附件尺寸：", "maxattachsizenew", $group[maxattachsize], "text", "设置附件最大字节数，需要 PHP 设置允许才有效，请参考系统设置首页");
				showsetting("允许附件类型：", "attachextensionsnew", $group[attachextensions], "text", "设置允许上传的附件扩展名，多个扩版名之间用半角逗号 \",\" 分割");

				showtype("管理权限");
				showsetting("拥有版主权限：", "ismoderatornew", $group[ismoderator], "radio", "设置是否拥有版主权限");
				showsetting("拥有超级版主权限：", "issupermodnew", $group[issupermod], "radio", "设置是否拥有超级版主权限");
				showsetting("拥有管理员权限：", "isadminnew", $group[isadmin], "radio", "设置是否拥有管理员权限");

				showtype("", "bottom");

				echo "<br><center><input type=\"submit\" name=\"detailsubmit\" value=\"更新权限设置\"><center></form>";

			} else {

				if($isadminnew) {
					$ismoderatornew = $issupermodnew = 1;
				} elseif($issupermodnew) {
					$ismoderatornew = 1;
				}
				$db->query("UPDATE $table_usergroups SET grouptitle='$grouptitlenew', allowvisit='$allowvisitnew',
					allowview='$allowviewnew', allowviewstats='$allowviewstatsnew', allowsearch='$allowsearchnew',
					allowavatar='$allowavatarnew', allowcstatus='$allowcstatusnew', allowkarma='$allowkarmanew',
					maxkarmarate='$maxkarmaratenew', maxrateperday='$maxrateperdaynew', maxpmnum='$maxpmnumnew', allowpost='$allowpostnew',
					maxmemonum='$maxmemonumnew', allowsetviewperm='$allowsetviewpermnew', allowpostpoll='$allowpostpollnew',
					allowvote='$allowvotenew', allowsigbbcode='$allowsigbbcodenew', allowsigimgcode='$allowsigimgcodenew',
					maxsigsize='$maxsigsizenew', allowgetattach='$allowgetattachnew',
					allowpostattach='$allowpostattachnew', allowsetattachperm='$allowsetattachpermnew',
					maxattachsize='$maxattachsizenew', attachextensions='$attachextensionsnew',
					ismoderator='$ismoderatornew', issupermod='$issupermodnew', isadmin='$isadminnew' WHERE groupid='$id'");

				updatecache("usergroups");
				cpmsg("用户组权限设置成功更新。");

			}

		}

	} else {

		if($type == "member") {
			if($reset != "yes") {