oddconmanage.php

在传统CMS文章内容管理功能基础上

							}
							else{
								$selected=null;
							}
							$input.='<option value="'.$v.'" '.$selected.'>'.$text[$k].'</option>';
						}
						$input.='</select>';
						break;
					}
					$p->set_var("input",$input);
					$p->parse("ext","regextend",true);
				}
			}
		}

		$p->parse("output","handleregctrl0");
		$p->p("output");
		//---------------------------------------
		//公司用户编辑  更新时间2006-11-07 11:25
		//---------------------------------------
	}elseif ($row->regctrl==1){
		$p->set_file("handleregctrl1","companyMess.html");
		$p->set_block("handleregctrl1","regextend","ext");
		//------------------------------------
		//查出vip的名称
		//------------------------------------
		$vipNumSql = "select `pgname` from {$prefix}permitgroup where `pgid`='$row->vipnum'";
		$vipnum=$row->vipnum;
		$vipNumObj = $db->get_one($vipNumSql);
		if($vipNumObj)($row->vipwait==0)?$p->set_var("vipnum",$langAdminArray["mem_vip_iswait"].$vipNumObj->pgname):$p->set_var("vipnum",$vipNumObj->pgname);
		else $p->set_var("vipnum",$langAdminArray["mem_unvip"]);

		//------------------------------------
		//更改会员的组属性
		//------------------------------------
		$vipnameSql = "select `pgid`,`pgname` from {$prefix}permitgroup";
		$vipnameRes = $db->query($vipnameSql,true);
		while ($vipnameObj = $db->fetch_object($vipnameRes)){
			if($row->vipnum==$vipnameObj->pgid) $inputStr.="<input type='radio' name='vipnum' value='".$vipnameObj->pgid."' checked>".$vipnameObj->pgname;
			else $inputStr.="<input type='radio' name='vipnum' value='".$vipnameObj->pgid."'>".$vipnameObj->pgname;
		}
		$p->set_var("inputradio",$inputStr);
		unset($vipNumSql,$vipNumObj,$vipnameObj,$vipnameRes,$vipnameSql,$inputStr);
		$vipwait = "vipwait_$row->vipwait";
		$p->set_var($vipwait,"checked");

		$membersSql = "SELECT * FROM ".$prefix."members WHERE username='$username'";
		$membersRes = $db->query($membersSql,true);
		$membersRow = $db->fetch_array($membersRes);
		foreach ($membersRow as $key=>$value){
			$membersVar[$key] = $value;
		}
		$p->set_var("available_".$membersRow['available'],"checked");
		$p->set_var($membersVar);
		$memberfieldsSql = "SELECT * FROM ".$prefix."company WHERE username='$username'";
		$memberfieldsRes = $db->query($memberfieldsSql,true);
		$memberfieldsRow = $db->fetch_array($memberfieldsRes);
		foreach ($memberfieldsRow as $key=>$value){
			$memberfieldsVar[$key] = $value;
		}
		$p->set_var($memberfieldsVar);

		include_once("../data/setfield.php");
		if(is_array($setfieldArray)){
			foreach ($setfieldArray as $field){
				$input=null;
				if($field["tablename"]=="company"&&$field["vipnum"]==$vipnum){
					$p->set_var("text",$field["descript"]);
					$dbvalue=$memberfieldsRow[$field["field"]];
					switch ($field["input"]){
						//文本输入框的时候
						case "text":
						$input='<input type="text" name="setfield['.$field["field"].']" value="'.$dbvalue.'">';
						break;
						//多行文本输入框
						case "textarea":
						$input='<textarea rows="5" cols="60" name="setfield['.$field["field"].']">'.$dbvalue.'</textarea>';
						break;
						case "radio":
						$value=unserialize($field["value"]);
						$text=unserialize($field["text"]);
						foreach ($value as $k=>$v){
							if($dbvalue==$v){
								$checked="checked";
							}
							else{
								$checked=null;
							}
							$input.='<input type="radio" name="setfield['.$field["field"].']" value="'.$v.'" '.$checked.'>'.$text[$k];
						}
						break;
						case "checkbox":
						$value=unserialize($field["value"]);
						$text=unserialize($field["text"]);
						$dbvalue=unserialize($dbvalue);
						foreach ($value as $k=>$v){
							if(in_array($v,$dbvalue)){
								$checked="checked";
							}
							else{
								$checked=null;
							}
							$input.='<input type="checkbox" name="setfield['.$field["field"].'][]" value="'.$v.'" '.$checked.'>'.$text[$k];
						}
						break;
						case "select":
						$value=unserialize($field["value"]);
						$text=unserialize($field["text"]);
						$input='<select name="setfield['.$field["field"].']">';
						foreach ($value as $k=>$v){
							if($dbvalue==$v){
								$selected="selected";
							}
							else{
								$selected=null;
							}
							$input.='<option value="'.$v.'" '.$selected.'>'.$text[$k].'</option>';
						}
						$input.='</select>';
						break;
					}
					$p->set_var("input",$input);
					$p->parse("ext","regextend",true);
				}
			}
		}
		$p->parse("output","handleregctrl1");
		$p->p("output");
	}
	exit();
}elseif($action=="search"){
	$sql = "select uid,username,oltime,regdate,lastvisit,regip,lastip,vipnum,vipwait,available,regctrl from ".$prefix."members where";
	$sql.=" username like '%$_POST[username]%' and";
	$sql.=" email like '%$_POST[email]%' and";
	$sql.=" vipnum={$_POST['vipnum']}";
	$sql=str_replace("*","",$sql);
}
elseif ($action=="viplist"){
	$sql = "select uid,username,oltime,regdate,lastvisit,regip,lastip,vipnum,vipwait,available,regctrl from ".$prefix."members where";
	$sql.=" vipnum={$_GET['pgid']}";
	$_POST["vipnum"]=$_GET['pgid'];
	$_POST["username"]=null;
}
elseif ($action=="delete"){
	$articleidA=$_POST["uid"];
	foreach ($articleidA as $articleid){
		$usernameSql = "select username from ".$prefix."members where uid=$articleid";
		$usernameObj = $db->get_one($usernameSql);
		$db->update("delete from ".$prefix."members where uid=$articleid");                        //删除基本信息表中的信息
		$db->update("delete from ".$prefix."memberfields where username='$usernameObj->username'");//删除详细信息表中的信息
		$db->update("delete from ".$prefix."company where username='$usernameObj->username'");     //删除公司库中的信息
		$db->update("delete from ".$prefix."pm where from='$usernameObj->username'");              //删除收件箱中的信息
		$db->update("delete from ".$prefix."pmbox where to='$usernameObj->username'");             //删除发件箱，垃圾箱，草稿箱中的信息
		$db->update("delete from ".$prefix."friend where username='$usernameObj->username'");      //删除好友中的信息
	}
	Meta(0,'?mod=member&f=oddconmanage&passvip=pass');
}
elseif ($action=="delface"){
	$username=$_GET["username"];
	$regctrl =$_GET["regctrl"];
	$face    =$_GET["face"];
	if(!$username||!$face){
		exit("Forbidden");
	}
	if(intval(substr($face,0,1))>0){
		if($regctrl==1){
			if($db->update("update {$prefix}company set face='d0.gif' where username='$username' and face='$face' limit 1")){
				unlink("../upload/$face");
			}
		}
		else{
			if($db->update("update {$prefix}memberfields set face='d0.gif' where username='$username' and face='$face' limit 1")){
				unlink("../upload/$face");
			}
		}
		Meta(0,"?mod=member&f=oddconmanage");
	}
	else{
		MsgError($langAdminArray["mem_undelface"]);
	}
}
elseif ($action=="able"){
	$ableidA=$_POST["uid"];
	foreach ($ableidA as $ableid){
		$db->update("update ".$prefix."members set available=1 where uid=$ableid");
	}
	Meta(0,'?mod=member&f=oddconmanage&passvip=pass');
}elseif ($action=="unable"){
	$ableidA=$_POST["uid"];
	foreach ($ableidA as $ableid){
		$db->update("update ".$prefix."members set available=0 where uid=$ableid");
	}
	Meta(0,'?mod=member&f=oddconmanage&passvip=pass');
}
elseif ($action=="vippass"){
	$ableidA=$_POST["uid"];
	foreach ($ableidA as $ableid){
		//--------------------------------------------------
		//$isSendMessage 后台设置参数 验证成功是否发送短消息
		//查出原来的会员是否处于等待验证状态
		//处于等待验证状态并且现在通过
		//发出短信通知
		//--------------------------------------------------
		if($isSendMessage==1){
			$vipWaitSql = "select `vipwait`,`username` from ".$prefix."members where uid='$ableid'";
			$vipWaitObj = $db->get_one($vipWaitSql);
			if($vipWaitObj->vipwait==0){
				//--------------------------
				//载入短消息的函数
				//--------------------------
				include_once("../function/func_pm.php");
				systempm($vipWaitObj->username,$langAdminArray["mem_system_msg"],$message);
			}
			unset($vipWaitSql,$vipWaitObj);
		}
		$db->update("update ".$prefix."members set vipwait=1 where uid=$ableid");
	}
	Meta(0,'?mod=member&f=oddconmanage&passvip=pass');
}
elseif ($action=="movevip"){
	$ableidA=$_POST["uid"];
	$vipnum =$_POST["vipnum"];
	foreach ($ableidA as $ableid){
		$db->update("update ".$prefix."members set vipnum=$vipnum where uid=$ableid");
	}
	Meta(0,'?mod=member&f=oddconmanage&passvip=pass');
}
//=======================================================
//显示平台的会员组
$sqlPermit="select * from {$prefix}permitgroup";
$db->query($sqlPermit,true);
while($rsPermit=$db->fetch_array()){
	$rsPermit["pgid"]==$_POST['vipnum']?$selected="selected":$selected="";
	$stringPermit.="<option value=\"{$rsPermit["pgid"]}\" {$selected}>{$rsPermit["pgname"]}</option>";
	$arr_permit[$rsPermit["pgid"]]=$rsPermit["pgname"];
}
//=======================================================
$currentpage=$_GET["next"];
if(!$currentpage){$whichpage=1;}
else{$whichpage=$currentpage;}
$lower_item=($whichpage-1)*20;
$rs=$db->get_one($sql_count);
$allMsg=$rs->num;
$allPage=ceil($allMsg/20);
$db->query($sql." limit $lower_item,20",true);
$p->set_file("handle","memberbrowselist.html");
$p->set_block("handle","link","lk");
while ($rs=$db->fetch_object()){
	$p->set_var("uid",$rs->uid);
	$p->set_var("username",$rs->username);
	if($rs->available=="1"){$p->set_var("available",$langAdminArray["mem_unlock"]);
	}else {$p->set_var("available",$langAdminArray["mem_lock"]);}
	$regctrl = $langAdminArray["mem_regctrl_".$rs->regctrl];
	($rs->vipwait==0)?$p->set_var("vipnum",$langAdminArray["mem_vip_iswait"].$arr_permit[$rs->vipnum]):$p->set_var("vipnum",$arr_permit[$rs->vipnum]);
	$p->set_var("regctrl",$regctrl);
	$p->set_var("oltime",$rs->oltime);
	$p->set_var("regdate",date("Y-m-d",$rs->regdate));
	$p->set_var("lastvisit",date("Y-m-d",$rs->lastvisit));
	$p->set_var("regip",$rs->regip);
	$p->set_var("lastip",$rs->lastip);
	$p->parse("lk","link",true);
	unset($value,$values,$targetStr);
}
$split_page=show_split_page($whichpage,$allPage,"?mod=member&f=oddconmanage&act=".$action."&passvip={$passvip}");
$p->set_var("split_page",$split_page);
$p->set_var("allpage",$allPage);
$p->set_var("allmsg",$allMsg);
$p->set_var("whichpage",$whichpage);
$p->set_var("permitgroup",$stringPermit);
$_POST["username"]?null:$_POST["username"]="*";
$_POST["email"]?null:$_POST["email"]="*";
$p->set_var($_POST);
$p->parse("output","handle");
$p->p("output");
?>