>".$val."";
}
elseif($type=='checkbox')
{
$change.=">".$val;
}
else
{
$change.=">".$val;
}
}
if($type=="select")
{
if($fformsize)
{
$addsize=' style="width:'.$fformsize.'"';
}
$change="";
}
return $change;
}
//替换表单元素长度
function RepMFformSize($f,$string,$type,$fformsize=''){
$fformsize=ReturnDefMFformSize($f,$type,$fformsize);
if($type=='textarea')
{
$r=explode(',',$fformsize);
$string=str_replace('[!--fsize.w--]',$r[0],$string);
$string=str_replace('[!--fsize.h--]',$r[1],$string);
}
else
{
$string=str_replace('[!--fsize.w--]',$fformsize,$string);
}
return $string;
}
//返回默认长度
function ReturnDefMFformSize($f,$type,$fformsize){
if(empty($fformsize))
{
if($type=='textarea')
{
$fformsize='60,10';
}
elseif($type=='img')
{
$fformsize='45';
}
elseif($type=='file')
{
$fformsize='45';
}
elseif($type=='flash')
{
$fformsize='45';
}
elseif($type=='date')
{
$fformsize='12';
}
elseif($type=='color')
{
$fformsize='10';
}
elseif($type=='linkfield')
{
$fformsize='45';
}
elseif($type=='downpath')
{
$fformsize='45';
}
elseif($type=='onlinepath')
{
$fformsize='45';
}
}
return $fformsize;
}
//增加会员字段
function AddMemberF($add,$userid,$username){
global $empire,$dbtbpre;
//验证权限
CheckLevel($userid,$username,$classid,"memberf");
$add[f]=RepPostVar($add[f]);
if(empty($add[f])||empty($add[fname]))
{
printerror("EmptyF","");
}
//字段是否重复
$s=$empire->query("SHOW FIELDS FROM {$dbtbpre}enewsmemberadd");
$b=0;
while($r=$empire->fetch($s))
{
if($r[Field]==$add[f])
{
$b=1;
break;
}
}
if($b)
{
printerror("ReF","");
}
$s=$empire->query("SHOW FIELDS FROM {$dbtbpre}enewsmember");
$b=0;
while($r=$empire->fetch($s))
{
if($r[Field]==$add[f])
{
$b=1;
break;
}
}
if($b)
{
printerror("ReF","");
}
$add[fvalue]=ReturnMFvalue($add[fvalue]);//初始化值
//字段类型
if($add[ftype]=="TINYINT"||$add[ftype]=="SMALLINT"||$add[ftype]=="INT"||$add[ftype]=="BIGINT"||$add[ftype]=="FLOAT"||$add[ftype]=="DOUBLE")
{
$def=" default '0'";
}
elseif($add[ftype]=="VARCHAR")
{
$def=" default ''";
}
else
{
$def="";
}
$type=$add[ftype];
//VARCHAR
if($add[ftype]=='VARCHAR'&&empty($add[flen]))
{
$add[flen]='255';
}
//字段长度
if($add[flen]){
if($add[ftype]!="TEXT"&&$add[ftype]!="MEDIUMTEXT"&&$add[ftype]!="LONGTEXT"){
$type.="(".$add[flen].")";
}
}
$field="`".$add[f]."` ".$type." NOT NULL".$def;
//新增字段
$asql=$empire->query("alter table {$dbtbpre}enewsmemberadd add ".$field);
//替换代码
$fhtml=GetMemberFform($add[fform],$add[f],$add[fvalue],$add[fformsize]);
if($add[fform]=='select'||$add[fform]=='radio'||$add[fform]=='checkbox')
{
$fhtml=str_replace("\$r[","\$addr[",$fhtml);
}
//处理变量
$add[myorder]=(int)$add[myorder];
$sql=$empire->query("insert into {$dbtbpre}enewsmemberf(f,fname,fform,fhtml,fzs,myorder,ftype,flen,fvalue,fformsize) values('$add[f]','$add[fname]','$add[fform]','".eaddslashes2($fhtml)."','".eaddslashes($add[fzs])."',$add[myorder],'$add[ftype]','$add[flen]','".eaddslashes2($add[fvalue])."','$add[fformsize]');");
$lastid=$empire->lastid();
if($asql&&$sql)
{
//操作日志
insert_dolog("fid=".$lastid."
f=".$add[f]);
printerror("AddFSuccess","member/AddMemberF.php?enews=AddMemberF".hReturnEcmsHashStrHref2(0));
}
else
{
printerror("DbError","history.go(-1)");
}
}
//修改会员字段
function EditMemberF($add,$userid,$username){
global $empire,$dbtbpre;
//验证权限
CheckLevel($userid,$username,$classid,"memberf");
$fid=(int)$add['fid'];
$add[f]=RepPostVar($add[f]);
$add[oldf]=RepPostVar($add[oldf]);
if(empty($add[f])||empty($add[fname])||!$fid){
printerror("EmptyF","history.go(-1)");
}
if($add[f]<>$add[oldf]){
//字段是否重复
$s=$empire->query("SHOW FIELDS FROM {$dbtbpre}enewsmemberadd");
$b=0;
while($r=$empire->fetch($s)){
if($r[Field]==$add[f]){
$b=1;
break;
}
}
if($b){
printerror("ReF","history.go(-1)");
}
$s=$empire->query("SHOW FIELDS FROM {$dbtbpre}enewsmember");
$b=0;
while($r=$empire->fetch($s))
{
if($r[Field]==$add[f])
{
$b=1;
break;
}
}
if($b)
{
printerror("ReF","");
}
}
$add[fvalue]=ReturnMFvalue($add[fvalue]);//初始化值
//字段类型
if($add[ftype]=="TINYINT"||$add[ftype]=="SMALLINT"||$add[ftype]=="INT"||$add[ftype]=="BIGINT"||$add[ftype]=="FLOAT"||$add[ftype]=="DOUBLE")
{
$def=" default '0'";
}
elseif($add[ftype]=="VARCHAR")
{
$def=" default ''";
}
else
{
$def="";
}
$type=$add[ftype];
//VARCHAR
if($add[ftype]=='VARCHAR'&&empty($add[flen]))
{
$add[flen]='255';
}
//字段长度
if($add[flen]){
if($add[ftype]!="TEXT"&&$add[ftype]!="MEDIUMTEXT"&&$add[ftype]!="LONGTEXT"){
$type.="(".$add[flen].")";
}
}
$field="`".$add[f]."` ".$type." NOT NULL".$def;
$usql=$empire->query("alter table {$dbtbpre}enewsmemberadd change `".$add[oldf]."` ".$field);
//替换代码
if($add[f]<>$add[oldf]||$add[fform]<>$add[oldfform]||$add[fvalue]<>$add[oldfvalue]||$add[fformsize]<>$add[oldfformsize]){
$fhtml=GetMemberFform($add[fform],$add[f],$add[fvalue],$add[fformsize]);
if($add[fform]=='select'||$add[fform]=='radio'||$add[fform]=='checkbox')
{
$fhtml=str_replace("\$r[","\$addr[",$fhtml);
}
}
else{
$fhtml=$add[fhtml];
}
//处理变量
$add[myorder]=(int)$add[myorder];
$sql=$empire->query("update {$dbtbpre}enewsmemberf set f='$add[f]',fname='$add[fname]',fform='$add[fform]',fhtml='".eaddslashes2($fhtml)."',fzs='".eaddslashes($add[fzs])."',myorder=$add[myorder],ftype='$add[ftype]',flen='$add[flen]',fvalue='".eaddslashes2($add[fvalue])."',fformsize='$add[fformsize]' where fid=$fid");
//更新表单
$record="";
$field="";
$like=$field.$add[oldf].$record;
$newlike=$field.$add[f].$record;
$slike=",".$add[oldf].",";
$newslike=",".$add[f].",";
$csql=$empire->query("select fid,ftemp,enter,mustenter,filef,imgf,tobrf,viewenter,searchvar,canaddf,caneditf,checkboxf from {$dbtbpre}enewsmemberform where enter like '%$like%'");
while($cr=$empire->fetch($csql))
{
$setf="";
$newftemp=str_replace('[!--'.$add[oldf].'--]','[!--'.$add[f].'--]',stripSlashes($cr['ftemp']));
$setf.=",ftemp='".addslashes($newftemp)."'";
if(strstr($cr['mustenter'],$slike)){
$setf.=",mustenter=REPLACE(mustenter,'$slike','$newslike')";
}
if(strstr($cr['filef'],$slike)){
$setf.=",filef=REPLACE(filef,'$slike','$newslike')";
}
if(strstr($cr['imgf'],$slike)){
$setf.=",imgf=REPLACE(imgf,'$slike','$newslike')";
}
if(strstr($cr['tobrf'],$slike)){
$setf.=",tobrf=REPLACE(tobrf,'$slike','$newslike')";
}
if(strstr($cr[viewenter],$like)){
$setf.=",viewenter=REPLACE(viewenter,'$like','$newlike')";
}
if(strstr($cr['searchvar'],$slike)){
$setf.=",searchvar=REPLACE(searchvar,'$slike','$newslike')";
}
if(strstr($cr['canaddf'],$slike)){
$setf.=",canaddf=REPLACE(canaddf,'$slike','$newslike')";
}
if(strstr($cr['caneditf'],$slike)){
$setf.=",caneditf=REPLACE(caneditf,'$slike','$newslike')";
}
if(strstr($cr['checkboxf'],$slike))
{
$setf.=",checkboxf=REPLACE(checkboxf,'$slike','$newslike')";
}
$cusql=$empire->query("update {$dbtbpre}enewsmemberform set enter=REPLACE(enter,'$like','$newlike')".$setf." where fid='$cr[fid]'");
//生成表单页面
ChangeMemberForm($cr[fid],$newftemp);
}
if($usql&&$sql)
{
insert_dolog("fid=".$fid."
f=".$add[f]);//操作日志
printerror("EditFSuccess","member/ListMemberF.php".hReturnEcmsHashStrHref2(1));
}
else
{printerror("DbError","history.go(-1)");}
}
//删除会员字段
function DelMemberF($add,$userid,$username){
global $empire,$dbtbpre;
//验证权限
CheckLevel($userid,$username,$classid,"memberf");
$fid=(int)$add['fid'];
if(empty($fid)){
printerror("EmptyFid","history.go(-1)");
}
$r=$empire->fetch1("select f from {$dbtbpre}enewsmemberf where fid=$fid");
if(!$r[f]){
printerror("EmptyFid","history.go(-1)");
}
$usql=$empire->query("alter table {$dbtbpre}enewsmemberadd drop COLUMN `".$r[f]."`");
$sql=$empire->query("delete from {$dbtbpre}enewsmemberf where fid=$fid");
//更新表单表
$record="";
$field="";
$like=$field.$r[f].$record;
$slike=",".$r[f].",";
$csql=$empire->query("select fid,ftemp,enter,mustenter,filef,imgf,tobrf,viewenter,searchvar,canaddf,caneditf,checkboxf from {$dbtbpre}enewsmemberform where enter like '%$like%'");
while($cr=$empire->fetch($csql))
{
$setf="";
if(strstr($cr['mustenter'],$slike))
{
$setf.=",mustenter=REPLACE(mustenter,'$slike',',')";
}
if(strstr($cr['filef'],$slike))
{
$setf.=",filef=REPLACE(filef,'$slike',',')";
}
if(strstr($cr['imgf'],$slike))
{
$setf.=",imgf=REPLACE(imgf,'$slike',',')";
}
if(strstr($cr['tobrf'],$slike))
{
$setf.=",tobrf=REPLACE(tobrf,'$slike',',')";
}
//录入项
$enter="";
$re1=explode($record,$cr[enter]);
for($i=0;$iquery("update {$dbtbpre}enewsmemberform set enter='$enter'".$setf." where fid='$cr[fid]'");
}
if($usql&&$sql)
{
insert_dolog("fid=".$fid."
f=".$r[f]);//操作日志
printerror("DelFSuccess","member/ListMemberF.php".hReturnEcmsHashStrHref2(1));
}
else
{printerror("DbError","history.go(-1)");}
}
//修改会员字段顺序
function EditMemberFOrder($fid,$myorder,$userid,$username){
global $empire,$dbtbpre;
//验证权限
CheckLevel($userid,$username,$classid,"memberf");
for($i=0;$iquery("update {$dbtbpre}enewsmemberf set myorder=$newmyorder where fid='$fid[$i]'");
}
printerror("EditFOrderSuccess","member/ListMemberF.php".hReturnEcmsHashStrHref2(1));
}
//********************************** 会员表单 **********************************
//返回自动生成会员表单模板
function ReturnMemberFtemp($cname,$center){
$temp="| enews.name | [!--enews.var--] |
";
for($i=0;$i".$data."";
}
//更新会员表单文件
function ChangeMemberForm($fid,$mtemp){
global $empire,$dbtbpre;
$file="../data/html/memberform".$fid.".php";
$sql=$empire->query("select f,fhtml from {$dbtbpre}enewsmemberf");
while($r=$empire->fetch($sql)){
$mtemp=str_replace("[!--".$r[f]."--]",$r[fhtml],$mtemp);
}
$mtemp="".$mtemp;
WriteFiletext($file,$mtemp);
}
//组合投稿项
function TogMemberqenter($cname,$cqenter){
$record="";
$field="";
$c="";
for($i=0;$iquery("insert into {$dbtbpre}enewsmemberform(fname,ftemp,fzs,enter,mustenter,filef,imgf,tobrf,viewenter,searchvar,canaddf,caneditf,checkboxf) values('$add[fname]','".eaddslashes2($add[ftemp])."','".addslashes($add[fzs])."','$enter','$mustenter','$filef','$imgf','$tobrf','$viewenter','$searchvar','$canaddf','$caneditf','$checkboxf');");
$fid=$empire->lastid();
//生成表单页面
ChangeMemberForm($fid,$add[ftemp]);
if($sql)
{
insert_dolog("fid=".$fid."
fname=".$add[fname]);//操作日志
printerror("AddMemberFormSuccess","member/AddMemberForm.php?enews=AddMemberForm".hReturnEcmsHashStrHref2(0));
}
else
{printerror("DbError","history.go(-1)");}
}
//修改会员表单
function EditMemberForm($add,$userid,$username){
global $empire,$dbtbpre;
$fid=(int)$add['fid'];
if(empty($add[fname])||!$fid)
{
printerror("EmptyMemberForm","history.go(-1)");
}
//验证权限
CheckLevel($userid,$username,$classid,"memberf");
$enter=TogMemberqenter($add['cname'],$add['center']);//录入项
$viewenter=TogMemberqenter($add['cname'],$add['venter']);//显示项
$mustenter=TogMemberMustf($add['cname'],$add['menter']);//必填项
$canaddf=TogMemberMustf($add['cname'],$add['canadd']);//增加项
$caneditf=TogMemberMustf($add['cname'],$add['canedit']);//修改项
$searchvar=TogMemberMustf($add['cname'],$add['schange']);//搜索项
$filef=ReturnMFileF($enter,$dbtbpre."enewsmemberf",0,"file");
$imgf=ReturnMFileF($enter,$dbtbpre."enewsmemberf",0,"img");
$tobrf=ReturnMFileF($enter,$dbtbpre."enewsmemberf",0,"textarea");
$checkboxf=ReturnMFileF($enter,$dbtbpre."enewsmemberf",0,"checkbox");
//自动生成表单
if($add[ftype])
{
$add[ftemp]=ReturnMemberFtemp($add['cname'],$add['center']);
}
$sql=$empire->query("update {$dbtbpre}enewsmemberform set fname='$add[fname]',ftemp='".eaddslashes2($add[ftemp])."',fzs='".addslashes($add[fzs])."',enter='$enter',mustenter='$mustenter',filef='$filef',imgf='$imgf',tobrf='$tobrf',viewenter='$viewenter',searchvar='$searchvar',canaddf='$canaddf',caneditf='$caneditf',checkboxf='$checkboxf' where fid=$fid");
//生成表单页面
ChangeMemberForm($fid,$add[ftemp]);
if($sql)
{
insert_dolog("fid=".$fid."
fname=".$add[fname]);//操作日志
printerror("EditMemberFormSuccess","member/ListMemberForm.php".hReturnEcmsHashStrHref2(1));
}
else
{printerror("DbError","history.go(-1)");}
}
//删除会员表单
function DelMemberForm($add,$userid,$username){
global $empire,$dbtbpre;
$fid=(int)$add['fid'];
if(!$fid)
{
printerror("EmptyMemberFormId","history.go(-1)");
}
//验证权限
CheckLevel($userid,$username,$classid,"memberf");
$r=$empire->fetch1("select fid,fname from {$dbtbpre}enewsmemberform where fid=$fid;");
if(!$r['fid'])
{
printerror("EmptyMemberFormId","history.go(-1)");
}
$sql=$empire->query("delete from {$dbtbpre}enewsmemberform where fid=$fid;");
//删除表单文件
$file="../data/html/memberform".$fid.".php";
DelFiletext($file);
if($sql)
{
insert_dolog("fid=".$fid."
fname=".$r[fname]);//操作日志
printerror("DelMemberFormSuccess","member/ListMemberForm.php".hReturnEcmsHashStrHref2(1));
}
else
{printerror("DbError","history.go(-1)");}
}
//********************************** 会员组 **********************************
//增加会员组
function AddMemberGroup($add,$userid,$username){
global $empire,$dbtbpre;
if(empty($add[groupname])||empty($add[level]))
{printerror("EmptyMemberGroupname","history.go(-1)");}
//验证权限
CheckLevel($userid,$username,$classid,"membergroup");
//处理文件
$add[level]=(int)$add[level];
$add[checked]=(int)$add[checked];
$add[favanum]=(int)$add[favanum];
$add[daydown]=(int)$add[daydown];
$msgnum=(int)$add['msgnum'];
$msglen=(int)$add['msglen'];
$canreg=(int)$add['canreg'];
$formid=(int)$add['formid'];
$regchecked=(int)$add['regchecked'];
$spacestyleid=(int)$add['spacestyleid'];
$add[dayaddinfo]=(int)$add[dayaddinfo];
$add[infochecked]=(int)$add[infochecked];
$add[plchecked]=(int)$add[plchecked];
$sql=$empire->query("insert into {$dbtbpre}enewsmembergroup(groupname,level,checked,favanum,daydown,msglen,msgnum,canreg,formid,regchecked,spacestyleid,dayaddinfo,infochecked,plchecked) values('$add[groupname]',$add[level],$add[checked],$add[favanum],$add[daydown],$msglen,$msgnum,$canreg,$formid,$regchecked,$spacestyleid,'$add[dayaddinfo]','$add[infochecked]','$add[plchecked]');");
$groupid=$empire->lastid();
//更新缓存
GetMemberLevel();
if($sql)
{
//操作日志
insert_dolog("groupid=".$groupid."
groupname=".$add[groupname]);
printerror("AddMemberGroupSuccess","member/AddMemberGroup.php?enews=AddMemberGroup".hReturnEcmsHashStrHref2(0));
}
else
{printerror("DbError","history.go(-1)");}
}
//修改会员组
function EditMemberGroup($add,$userid,$username){
global $empire,$dbtbpre;
$add[groupid]=(int)$add[groupid];
if(empty($add[groupid])||empty($add[groupname])||empty($add[level]))
{printerror("EmptyMemberGroupname","history.go(-1)");}
//验证权限
CheckLevel($userid,$username,$classid,"membergroup");
//处理文件
$add[level]=(int)$add[level];
$add[checked]=(int)$add[checked];
$add[favanum]=(int)$add[favanum];
$add[daydown]=(int)$add[daydown];
$msgnum=(int)$add['msgnum'];
$msglen=(int)$add['msglen'];
$canreg=(int)$add['canreg'];
$formid=(int)$add['formid'];
$regchecked=(int)$add['regchecked'];
$spacestyleid=(int)$add['spacestyleid'];
$add[dayaddinfo]=(int)$add[dayaddinfo];
$add[infochecked]=(int)$add[infochecked];
$add[plchecked]=(int)$add[plchecked];
$sql=$empire->query("update {$dbtbpre}enewsmembergroup set groupname='$add[groupname]',level=$add[level],checked=$add[checked],favanum=$add[favanum],daydown=$add[daydown],msglen=$msglen,msgnum=$msgnum,canreg=$canreg,formid=$formid,regchecked=$regchecked,spacestyleid=$spacestyleid,dayaddinfo='$add[dayaddinfo]',infochecked='$add[infochecked]',plchecked='$add[plchecked]' where groupid='$add[groupid]'");
//更新缓存
GetMemberLevel();
if($sql)
{
//操作日志
insert_dolog("groupid=".$add[groupid]."
groupname=".$add[groupname]);
printerror("EditMemberGroupSuccess","member/ListMemberGroup.php".hReturnEcmsHashStrHref2(1));
}
else
{printerror("DbError","history.go(-1)");}
}
//删除会员组
function DelMemberGroup($groupid,$userid,$username){
global $empire,$dbtbpre;
$groupid=(int)$groupid;
if(empty($groupid))
{printerror("NotDelMemberGroupid","history.go(-1)");}
//验证权限
CheckLevel($userid,$username,$classid,"membergroup");
$r=$empire->fetch1("select groupname from {$dbtbpre}enewsmembergroup where groupid='$groupid'");
$sql=$empire->query("delete from {$dbtbpre}enewsmembergroup where groupid='$groupid'");
//更新缓存
GetMemberLevel();
if($sql)
{
//操作日志
insert_dolog("groupid=".$groupid."
groupname=".$r[groupname]);
printerror("DelMemberGroupSuccess","member/ListMemberGroup.php".hReturnEcmsHashStrHref2(1));
}
else
{printerror("DbError","history.go(-1)");}
}
?>