groupfield.php

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

<?php
/*
[BBWPS!] (C)2006-2010 小蜜蜂版权所有.
This is NOT a freeware, use is subject to license terms
功能：设置注册的扩展字段
*/

error_reporting(0);
//-------------------------------------------------
//验证是否是合法引用
//-------------------------------------------------
function_exists("CheckRequire")?null:exit("Forbidden");
$action =$_GET["action"];
$db= new DB($hostname,$username,$password,$database);
$p=new Template("./template/member");
if($action=="add"){
	$sql="delete from {$prefix}groupfield where pgid='{$_GET["pgid"]}'";
	$db->update($sql);
	$arr_fid=$_POST["fid"];
	foreach ($arr_fid as $fid){
		$sql="insert into {$prefix}groupfield set fid='{$fid}',pgid='{$_GET["pgid"]}'";
		$db->insert($sql);
	}
	$sql="select s.*,g.pgid as vipnum from {$prefix}setfield as s,{$prefix}groupfield as g where g.fid=s.fid";
	$db->query($sql,true);
	$setfieldStr="<?php\n";
	while ($rs=$db->fetch_array()){
		$str=array();
		foreach ($rs as $key=>$value){
			$str[]="\"{$key}\"=>'{$value}'";
		}
		$setfieldStr.='$setfieldArray[]=array('.implode(",",$str).');'."\n";
	}
	$setfieldStr.="?>";
	$fp=fopen("../data/setfield.php","w");
	fwrite($fp,$setfieldStr,strlen($setfieldStr));
	fclose($fp);
	ExeSuccess($langAdminArray["bank_succ"],"./admin.php?mod=member&f=permit_group");
}
else{
	$p->set_file("handle","groupfield.html");
	$p->set_block("handle","setfieldrow","set");
	$sql="select * from {$prefix}groupfield where pgid='{$_GET["pgid"]}'";
	$db->query($sql,true);
	while ($rs=$db->fetch_array()){
		$arr_fid[]=$rs["fid"];
	}
	$sql="select s.* from {$prefix}setfield as s where tablename='{$_GET["pgtype"]}'";
	$db->query($sql,true);
	while ($rs=$db->fetch_array()){
		$p->set_var($rs);
		if(in_array($rs["fid"],$arr_fid)){
			$p->set_var("checked","checked");
		}
		else{
			$p->set_var("checked","");
		}
		$p->parse("set","setfieldrow",true);
	}
	$p->set_var("pgid",$_GET["pgid"]);
	$p->parse("output","handle");
	$p->p("output");
}
?>