query("insert into ".$table."(bname".$mychecked.") values('$add[bname]'".$mycheckedvalue.");");
if($sql)
{
$bid=$empire->lastid();
//操作日志
insert_dolog("bid=".$bid."
bname=".$add[bname]);
printerror("AddGbookClassSuccess",$location);
}
else
{printerror("DbError","history.go(-1)");}
}
//修改留言分类
function EditGbookClass($add,$do=0,$userid,$username){
global $empire,$dbtbpre;
$add[bid]=(int)$add[bid];
if(empty($add[bname])||!$add[bid])
{
printerror("EmptyGbookClass","history.go(-1)");
}
if(empty($do))
{
$add['checked']=(int)$add['checked'];
$add['groupid']=(int)$add['groupid'];
$level="gbook";
$table="{$dbtbpre}enewsgbookclass";
$location="GbookClass.php".hReturnEcmsHashStrHref2(1);
$mychecked=",checked=".$add['checked'].",groupid=".$add['groupid'];
}
else
{
$level="feedback";
$table="{$dbtbpre}enewsfeedbackclass";
$location="FeedbackClass.php".hReturnEcmsHashStrHref2(1);
$mychecked="";
}
//验证权限
CheckLevel($userid,$username,$classid,$level);
$add['bname']=hRepPostStr($add['bname'],1);
$sql=$empire->query("update ".$table." set bname='$add[bname]'".$mychecked." where bid='$add[bid]';");
if($sql)
{
//操作日志
insert_dolog("bid=".$add[bid]."
bname=".$add[bname]);
printerror("EditGbookClassSuccess",$location);
}
else
{printerror("DbError","history.go(-1)");}
}
//删除留言分类
function DelGbookClass($bid,$do=0,$userid,$username){
global $empire,$dbtbpre;
$bid=(int)$bid;
if(!$bid)
{
printerror("NotChangeGbookClassid","history.go(-1)");
}
if(empty($do))
{
$level="gbook";
$table="{$dbtbpre}enewsgbookclass";
$tabledata="{$dbtbpre}enewsgbook";
$location="GbookClass.php".hReturnEcmsHashStrHref2(1);
}
else
{
$level="feedback";
$table="{$dbtbpre}enewsfeedbackclass";
$tabledata="{$dbtbpre}enewsfeedback";
$location="FeedbackClass.php".hReturnEcmsHashStrHref2(1);
}
//验证权限
CheckLevel($userid,$username,$classid,$level);
$r=$empire->fetch1("select bname from ".$table." where bid='$bid';");
$sql=$empire->query("delete from ".$table." where bid='$bid';");
$sql1=$empire->query("delete from ".$tabledata." where bid='$bid';");
if($sql)
{
//操作日志
insert_dolog("bid=".$bid."
bname=".$r[bname]);
printerror("DelGbookClassSuccess",$location);
}
else
{printerror("DbError","history.go(-1)");}
}
//---------返回留言/反馈分类
function ReturnGbookClass($bid,$do=0){
global $empire,$dbtbpre;
$bid=(int)$bid;
if(empty($do))
{
$table="{$dbtbpre}enewsgbookclass";
}
else
{
$table="{$dbtbpre}enewsfeedbackclass";
}
$sql=$empire->query("select bid,bname from ".$table." order by bid");
while($r=$empire->fetch($sql))
{
if($bid==$r[bid])
{$selected=" selected";}
else
{$selected="";}
$select.="";
}
return $select;
}
//回复留言板
function ReGbook($lyid,$retext,$bid,$userid,$username){
global $empire,$dbtbpre;
$lyid=(int)$lyid;
$bid=(int)$bid;
if(!$lyid||!$retext)
{
printerror("EmptyReGbooktext","history.go(-1)");
}
//验证权限
CheckLevel($userid,$username,$classid,"gbook");
$retext=hRepPostStr2($retext);
$sql=$empire->query("update {$dbtbpre}enewsgbook set retext='$retext' where lyid='$lyid';");
if($sql)
{
//操作日志
insert_dolog("lyid=".$lyid);
echo"";
exit();
}
else
{printerror("DbError","history.go(-1)");}
}
//删除留言
function DelGbook($lyid,$bid,$userid,$username){
global $empire,$dbtbpre;
$lyid=(int)$lyid;
$bid=(int)$bid;
if(!$lyid)
{
printerror("NotChangeLyid","history.go(-1)");
}
//验证权限
CheckLevel($userid,$username,$classid,"gbook");
$sql=$empire->query("delete from {$dbtbpre}enewsgbook where lyid='$lyid';");
if($sql)
{
//操作日志
insert_dolog("lyid=".$lyid);
printerror("DelGbookSuccess",EcmsGetReturnUrl());
}
else
{printerror("DbError","history.go(-1)");}
}
//--------------------------批量删除留言(3.6)
function DelGbook_all($lyid,$bid,$userid,$username){
global $empire,$dbtbpre;
//验证权限
CheckLevel($userid,$username,$classid,"gbook");
$bid=(int)$bid;
$count=count($lyid);
if(empty($count))
{printerror("NotChangeLyid","history.go(-1)");}
for($i=0;$i<$count;$i++)
{
$lyid[$i]=(int)$lyid[$i];
$add.="lyid='$lyid[$i]' or ";
}
$add=substr($add,0,strlen($add)-4);
$sql=$empire->query("delete from {$dbtbpre}enewsgbook where ".$add);
if($sql)
{
//操作日志
insert_dolog("");
printerror("DelGbookSuccess",EcmsGetReturnUrl());
}
else
{printerror("DbError","history.go(-1)");}
}
//--------------------------批量审核留言(3.6)
function CheckGbook_all($lyid,$bid,$userid,$username){
global $empire,$dbtbpre;
//验证权限
CheckLevel($userid,$username,$classid,"gbook");
$bid=(int)$bid;
$count=count($lyid);
if(empty($count))
{printerror("NotChangeCheckLyid","history.go(-1)");}
for($i=0;$i<$count;$i++)
{
$lyid[$i]=(int)$lyid[$i];
$add.="lyid='$lyid[$i]' or ";
}
$add=substr($add,0,strlen($add)-4);
$sql=$empire->query("update {$dbtbpre}enewsgbook set checked=0 where ".$add);
if($sql)
{
//操作日志
insert_dolog("");
printerror("CheckLysuccess",EcmsGetReturnUrl());
}
else
{printerror("DbError","history.go(-1)");}
}
//删除反馈附件
function DelFeedbackFile($filename,$filepath){
global $empire,$dbtbpre,$public_r,$efileftp_dr;
if($filename)
{
$fpath=0;
$getfpath=0;
$addfilepath=$filepath?$filepath.'/':'';
$filer=explode(",",$filename);
$fcount=count($filer);
for($j=0;$j<$fcount;$j++)
{
if(!$getfpath)
{
$ftr=$empire->fetch1("select fpath from {$dbtbpre}enewsfile_other where modtype=4 and path='$filepath' and filename='".$filer[$j]."' limit 1");
$fpath=$ftr[fpath];
$getfpath=1;
}
$fspath=ReturnFileSavePath(0,$fpath);
$delfile=eReturnEcmsMainPortPath().$fspath['filepath'].$addfilepath.$filer[$j];//moreport
DelFiletext($delfile);
$where.=$or."filename='".$filer[$j]."'";
$or=" or ";
//FileServer
if($public_r['openfileserver'])
{
$efileftp_dr[]=$delfile;
}
}
$delsql=$empire->query("delete from {$dbtbpre}enewsfile_other where modtype=4 and path='$filepath' and (".$where.")");
}
}
//删除反馈信息
function DelFeedback($id,$bid,$userid,$username){
global $empire,$dbtbpre;
$id=(int)$id;
$bid=(int)$bid;
if(!$id)
{
printerror("NotChangeFeedbackid","history.go(-1)");
}
//验证权限
//CheckLevel($userid,$username,$classid,"feedback");
$r=$empire->fetch1("select id,title,filepath,filename,bid from {$dbtbpre}enewsfeedback where id='$id';");
if(!$r['id'])
{
printerror("NotChangeFeedbackid","history.go(-1)");
}
//反馈权限
$bidr=ReturnAdminFeedbackClass($r['bid'],$userid,$username);
$sql=$empire->query("delete from {$dbtbpre}enewsfeedback where id='$id';");
//删除附件
DelFeedbackFile($r['filename'],$r['filepath']);
if($sql)
{
//操作日志
insert_dolog("id=".$id."
title=$r[title]");
printerror("DelFeedbackSuccess",EcmsGetReturnUrl());
}
else
{printerror("DbError","history.go(-1)");}
}
//批量删除反馈信息
function DelFeedback_all($id,$bid,$userid,$username){
global $empire,$dbtbpre;
$bid=(int)$bid;
$count=count($id);
if(!$count)
{
printerror("NotChangeFeedbackid","history.go(-1)");
}
//反馈权限
$bidr=ReturnAdminFeedbackClass(0,$userid,$username);
$dh='';
$inid='';
for($i=0;$i<$count;$i++)
{
$id[$i]=(int)$id[$i];
//删除附件
$r=$empire->fetch1("select id,filepath,filename,bid from {$dbtbpre}enewsfeedback where id='".$id[$i]."';");
if(!strstr(','.$bidr['bids'].',',','.$r['bid'].','))
{
continue;
}
DelFeedbackFile($r['filename'],$r['filepath']);
$inid.=$dh.$id[$i];
$dh=",";
}
if($inid)
{
$sql=$empire->query("delete from {$dbtbpre}enewsfeedback where id in (".$inid.");");
}
if($sql)
{
//操作日志
insert_dolog("");
printerror("DelFeedbackSuccess",EcmsGetReturnUrl());
}
else
{printerror("DbError","history.go(-1)");}
}
//返回字段值
function ReturnFBFvalue($value){
$value=str_replace("\r\n","|",$value);
return $value;
}
//增加反馈字段
function AddFeedbackF($add,$userid,$username){
global $empire,$dbtbpre;
$add[f]=RepPostVar($add[f]);
if(empty($add[f])||empty($add[fname]))
{printerror("EmptyF","history.go(-1)");}
//验证权限
//CheckLevel($userid,$username,$classid,"feedbackf");
//字段是否重复
$s=$empire->query("SHOW FIELDS FROM {$dbtbpre}enewsfeedback");
$b=0;
while($r=$empire->fetch($s))
{
if($r[Field]==$add[f])
{
$b=1;
break;
}
}
if($b)
{printerror("ReF","history.go(-1)");}
$add[fvalue]=ReturnFBFvalue($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}enewsfeedback add ".$field);
//处理变量
$add[myorder]=(int)$add[myorder];
$sql=$empire->query("insert into {$dbtbpre}enewsfeedbackf(f,fname,fform,fzs,myorder,ftype,flen,fformsize,fvalue) values('$add[f]','$add[fname]','$add[fform]','".eaddslashes($add[fzs])."',$add[myorder],'$add[ftype]','$add[flen]','$add[fformsize]','".eaddslashes2($add[fvalue])."');");
$lastid=$empire->lastid();
if($asql&&$sql)
{
//操作日志
insert_dolog("fid=".$lastid."
f=".$add[f]);
printerror("AddFSuccess","AddFeedbackF.php?enews=AddFeedbackF".hReturnEcmsHashStrHref2(0));
}
else
{
printerror("DbError","history.go(-1)");
}
}
//修改反馈字段
function EditFeedbackF($add,$userid,$username){
global $empire,$dbtbpre;
$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)");}
//验证权限
//CheckLevel($userid,$username,$classid,"feedbackf");
if($add[f]<>$add[oldf])
{
//字段是否重复
$s=$empire->query("SHOW FIELDS FROM {$dbtbpre}enewsfeedback");
$b=0;
while($r=$empire->fetch($s))
{
if($r[Field]==$add[f])
{
$b=1;
break;
}
}
if($b)
{printerror("ReF","history.go(-1)");}
}
$add[fvalue]=ReturnFBFvalue($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}enewsfeedback change `".$add[oldf]."` ".$field);
//处理变量
$add[myorder]=(int)$add[myorder];
$sql=$empire->query("update {$dbtbpre}enewsfeedbackf set f='$add[f]',fname='$add[fname]',fform='$add[fform]',fzs='".eaddslashes($add[fzs])."',myorder=$add[myorder],ftype='$add[ftype]',flen='$add[flen]',fformsize='$add[fformsize]',fvalue='".eaddslashes2($add[fvalue])."' where fid=$fid");
//字段名更换
if($add[f]<>$add[oldf])
{
$record="";
$field="";
$like=$field.$add[oldf].$record;
$newlike=$field.$add[f].$record;
$slike=",".$add[oldf].",";
$newslike=",".$add[f].",";
$csql=$empire->query("select bid,enter,mustenter,filef,checkboxf from {$dbtbpre}enewsfeedbackclass where enter like '%$like%'");
while($cr=$empire->fetch($csql))
{
$setf="";
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['checkboxf'],$slike))
{
$setf.=",checkboxf=REPLACE(checkboxf,'$slike','$newslike')";
}
$cusql=$empire->query("update {$dbtbpre}enewsfeedbackclass set enter=REPLACE(enter,'$like','$newlike')".$setf." where bid='$cr[bid]'");
}
}
if($usql&&$sql)
{
//操作日志
insert_dolog("fid=".$fid."
f=".$add[f]);
printerror("EditFSuccess","ListFeedbackF.php".hReturnEcmsHashStrHref2(1));
}
else
{printerror("DbError","history.go(-1)");}
}
//删除反馈字段
function DelFeedbackF($add,$userid,$username){
global $empire,$dbtbpre;
$fid=(int)$add['fid'];
if(empty($fid))
{printerror("EmptyFid","history.go(-1)");}
//验证权限
//CheckLevel($userid,$username,$classid,"feedbackf");
$r=$empire->fetch1("select f from {$dbtbpre}enewsfeedbackf where fid=$fid");
if(!$r[f])
{
printerror("EmptyFid","history.go(-1)");
}
if($r[f]=="title")
{
printerror("NotIsAdd","history.go(-1)");
}
$usql=$empire->query("alter table {$dbtbpre}enewsfeedback drop COLUMN `".$r[f]."`");
$sql=$empire->query("delete from {$dbtbpre}enewsfeedbackf where fid=$fid");
//更新分类表
$record="";
$field="";
$like=$field.$r[f].$record;
$slike=",".$r[f].",";
$csql=$empire->query("select bid,enter,mustenter,filef,checkboxf from {$dbtbpre}enewsfeedbackclass 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['checkboxf'],$slike))
{
$setf.=",checkboxf=REPLACE(checkboxf,'$slike',',')";
}
//录入项
$enter="";
$re1=explode($record,$cr[enter]);
for($i=0;$iquery("update {$dbtbpre}enewsfeedbackclass set enter='$enter'".$setf." where bid='$cr[bid]'");
}
if($usql&&$sql)
{
//操作日志
insert_dolog("fid=".$fid."
f=".$r[f]);
printerror("DelFSuccess","ListFeedbackF.php".hReturnEcmsHashStrHref2(1));
}
else
{printerror("DbError","history.go(-1)");}
}
//修改反馈字段顺序
function EditFeedbackFOrder($fid,$myorder,$userid,$username){
global $empire,$dbtbpre;
//验证权限
//CheckLevel($userid,$username,$classid,"feedbackf");
for($i=0;$iquery("update {$dbtbpre}enewsfeedbackf set myorder=$newmyorder where fid='$fid[$i]'");
}
printerror("EditFOrderSuccess","ListFeedbackF.php".hReturnEcmsHashStrHref2(1));
}
//返回有权限的反馈分类
function ReturnAdminFeedbackClass($bid,$userid,$username){
global $empire,$dbtbpre;
$bids='';
$dh='';
$select='';
$no=0;
$sql=$empire->query("select bid,bname from {$dbtbpre}enewsfeedbackclass where usernames='' or usernames like '%,".$username.",%'");
while($r=$empire->fetch($sql))
{
$no++;
$bids.=$dh.$r['bid'];
$dh=',';
if($bid==$r['bid'])
{$selected=' selected';}
else
{$selected='';}
$select.='';
}
if(!$bids)
{
printerror('NotLevel','history.go(-1)');
}
if($bid&&!strstr(','.$bids.',',','.$bid.','))
{
printerror('NotLevel','history.go(-1)');
}
$num=$empire->gettotal("select count(*) as total from {$dbtbpre}enewsfeedbackclass");
$ret_r['allbid']=0;
if($num==$no)
{
$ret_r['allbid']=1;
}
$ret_r['bids']=$bids;
$ret_r['selects']=$select;
return $ret_r;
}
//取得select/radio元素代码
function GetBFFformSelect($type,$f,$fvalue,$fformsize=''){
$vr=explode("|",$fvalue);
$count=count($vr);
$change="";
$def=':default';
for($i=0;$i<$count;$i++)
{
$val=$vr[$i];
$isdef="";
if(strstr($val,$def))
{
$dr=explode($def,$val);
$val=$dr[0];
$isdef=1;
}
if($type=='select')
{
$change.="";
}
elseif($type=='checkbox')
{
$change.="".$val;
}
else
{
$change.="".$val;
}
}
if($type=="select")
{
if($fformsize)
{
$addsize=' style="width:'.$fformsize.'"';
}
$change="";
}
return $change;
}
//自动生成反馈表单
function ReturnFeedbackBtemp($cname,$center,$mustenter){
global $empire,$dbtbpre,$fun_r;
//表单元素
$temp="| enews.name | enews.var |
";
for($i=0;$ifetch1("select fform,fformsize,fvalue from {$dbtbpre}enewsfeedbackf where f='".RepPostVar($v)."' limit 1");
if($fr['fform']=="file")
{
$fsize=$fr[fformsize]?" size='".$fr[fformsize]."'":"";
$repform="";
}
elseif($fr['fform']=="textarea")
{
$fsr=explode(',',$fr[fformsize]);
$cols=$fsr[0]?$fsr[0]:60;
$rows=$fsr[1]?$fsr[1]:12;
$repform="";
}
elseif($fr['fform']=="select"||$fr['fform']=="radio"||$fr['fform']=="checkbox")
{
$repform=GetBFFformSelect($fr['fform'],$v,$fr[fvalue],$fr[fformsize]);
}
else
{
$fsize=$fr[fformsize]?" size='".$fr[fformsize]."'":"";
$repform="";
}
//必填
$star="";
if(strstr($mustenter,",".$v.","))
{
$star="(*)";
}
$data.=str_replace("enews.var",$repform.$star,str_replace("enews.name",$cname[$v],$temp));
}
return "[!--cp.header--][!--cp.footer--]";
}
//生成反馈表单文件
function ReFeedbackClassFile($bid){
global $empire,$dbtbpre;
$bid=(int)$bid;
$r=$empire->fetch1("select btemp from {$dbtbpre}enewsfeedbackclass where bid='$bid'");
//替换公共变量
$url="";
$pagetitle="";
$btemp=ReplaceSvars($r['btemp'],$url,0,$pagetitle,$pagetitle,$pagetitle,$add,1);
$btemp=str_replace("[!--cp.header--]","",$btemp);
$btemp=str_replace("[!--cp.footer--]","",$btemp);
$btemp=str_replace("[!--member.header--]","",$btemp);
$btemp=str_replace("[!--member.footer--]","",$btemp);
$file=eReturnTrueEcmsPath()."e/tool/feedback/temp/feedback".$bid.".php";
$btemp="".$btemp;
WriteFiletext($file,$btemp);
}
//批量生成反馈表单文件
function ReMoreFeedbackClassFile($start=0,$userid,$username){
global $empire,$dbtbpre;
//验证权限
CheckLevel($userid,$username,$classid,"changedata");
$sql=$empire->query("select bid from {$dbtbpre}enewsfeedbackclass order by bid");
while($r=$empire->fetch($sql))
{
ReFeedbackClassFile($r['bid']);
}
printerror("ReMFeedbackFileSuccess","");
}
//组合投稿项
function TogFBqenter($cname,$cqenter){
$record="";
$field="";
$c="";
for($i=0;$iquery("insert into {$dbtbpre}enewsfeedbackclass(bname,btemp,bzs,enter,mustenter,filef,groupid,checkboxf,usernames) values('$add[bname]','".eaddslashes2($add[btemp])."','".eaddslashes($add[bzs])."','$enter','$mustenter','$filef',$groupid,'$checkboxf','$add[usernames]');");
$bid=$empire->lastid();
//生成表单页面
ReFeedbackClassFile($bid);
if($sql)
{
//操作日志
insert_dolog("bid=".$bid."
bname=".$add[bname]);
printerror("AddGbookClassSuccess","AddFeedbackClass.php?enews=AddFeedbackClass".hReturnEcmsHashStrHref2(0));
}
else
{printerror("DbError","history.go(-1)");}
}
//修改反馈分类
function EditFeedbackClass($add,$userid,$username){
global $empire,$dbtbpre;
$bid=(int)$add['bid'];
if(empty($add[bname])||!$bid)
{printerror("EmptyGbookClass","history.go(-1)");}
//验证权限
//CheckLevel($userid,$username,$classid,"feedbackf");
$enter=TogFBqenter($add['cname'],$add['center']);
$mustenter=TogFBMustf($add['cname'],$add['menter']);
$filef=ReturnMFileF($enter,$dbtbpre."enewsfeedbackf",0,"file");
$checkboxf=ReturnMFileF($enter,$dbtbpre."enewsfeedbackf",0,"checkbox");
//自动生成表单
if($add[btype])
{
$add[btemp]=ReturnFeedbackBtemp($add['cname'],$add['center'],$mustenter);
}
$groupid=(int)$add['groupid'];
if($add['usernames'])
{
$add['usernames']=','.$add['usernames'].',';
}
$add['bname']=hRepPostStr($add['bname'],1);
$enter=eaddslashes($enter);
$mustenter=eaddslashes($mustenter);
$filef=eaddslashes($filef);
$checkboxf=eaddslashes($checkboxf);
$add['usernames']=eaddslashes($add['usernames']);
$sql=$empire->query("update {$dbtbpre}enewsfeedbackclass set bname='$add[bname]',btemp='".eaddslashes2($add[btemp])."',bzs='".eaddslashes($add[bzs])."',enter='$enter',mustenter='$mustenter',filef='$filef',groupid=$groupid,checkboxf='$checkboxf',usernames='$add[usernames]' where bid=$bid");
//生成表单页面
ReFeedbackClassFile($bid);
if($sql)
{
//操作日志
insert_dolog("bid=".$bid."
bname=".$add[bname]);
printerror("EditGbookClassSuccess","FeedbackClass.php".hReturnEcmsHashStrHref2(1));
}
else
{printerror("DbError","history.go(-1)");}
}
//删除反馈分类
function DelFeedbackClass($add,$userid,$username){
global $empire,$dbtbpre;
$bid=(int)$add['bid'];
if(!$bid)
{printerror("NotChangeGbookClassid","history.go(-1)");}
//验证权限
//CheckLevel($userid,$username,$classid,"feedbackf");
$r=$empire->fetch1("select bid,bname from {$dbtbpre}enewsfeedbackclass where bid=$bid;");
if(!$r['bid'])
{printerror("NotChangeGbookClassid","history.go(-1)");}
$sql=$empire->query("delete from {$dbtbpre}enewsfeedbackclass where bid=$bid;");
//删除附件
$fsql=$empire->query("select id,filepath,filename from {$dbtbpre}enewsfeedback where bid=$bid");
while($fr=$empire->fetch($fsql))
{
DelFeedbackFile($fr['filename'],$fr['filepath']);
}
$sql1=$empire->query("delete from {$dbtbpre}enewsfeedback where bid=$bid;");
//删除表单文件
$file="../../tool/feedback/temp/feedback".$bid.".php";
DelFiletext($file);
if($sql)
{
//操作日志
insert_dolog("bid=".$bid."
bname=".$r[bname]);
printerror("DelGbookClassSuccess","FeedbackClass.php".hReturnEcmsHashStrHref2(1));
}
else
{printerror("DbError","history.go(-1)");}
}
//删除短消息
function DelMoreMsg($add,$userid,$username){
global $empire,$dbtbpre;
$starttime=RepPostVar($add['starttime']);
$endtime=RepPostVar($add['endtime']);
if(!$starttime||!$endtime)
{
printerror("EmptyDelMoreMsg","history.go(-1)");
}
//信箱类型
$msgtype=(int)$add['msgtype'];
if($msgtype==1)//后台
{
$a='';
$tbname="{$dbtbpre}enewshmsg";
}
elseif($msgtype==2)//前台系统消息
{
$a=' and issys=1';
$tbname="{$dbtbpre}enewsqmsg";
}
elseif($msgtype==3)//后台系统消息
{
$a=' and issys=1';
$tbname="{$dbtbpre}enewshmsg";
}
else//前台
{
$a='';
$tbname="{$dbtbpre}enewsqmsg";
}
//发件人
$from_username=RepPostVar($add['from_username']);
if($from_username)
{
if($add['fromlike']==1)
{
$a.=" and from_username like '%$from_username%'";
}
else
{
$a.=" and from_username='$from_username'";
}
}
$to_username=RepPostVar($add['to_username']);
if($to_username)
{
if($add['tolike']==1)
{
$a.=" and to_username like '%$to_username%'";
}
else
{
$a.=" and to_username='$to_username'";
}
}
//关键字
$keyboard=RepPostVar2($add['keyboard']);
if(trim($keyboard))
{
//检索字段
$keyfield=(int)$add['keyfield'];
if($keyfield==1)
{
$likef="title like '%[!--key--]%'";
}
elseif($keyfield==2)
{
$likef="msgtext like '%[!--key--]%'";
}
else
{
$likef="title like '%[!--key--]%' or msgtext like '%[!--key--]%'";
}
$r=explode(",",$keyboard);
$likekey="";
$count=count($r);
for($i=0;$i<$count;$i++)
{
if($i==0)
{
$or="";
}
else
{
$or=" or ";
}
$likekey.=$or.str_replace("[!--key--]",$r[$i],$likef);
}
$a.=" and (".$likekey.")";
}
$sql=$empire->query("delete from ".$tbname." where msgtime>'$starttime' and msgtime<'$endtime'".$a);
if($sql)
{
//操作日志
insert_dolog("starttime=$starttime&endtime=$endtime
msgtype=$msgtype");
printerror("DelMoreMsgSuccess","DelMoreMsg.php".hReturnEcmsHashStrHref2(1));
}
else
{printerror("DbError","history.go(-1)");}
}
//返回会员组
function ReturnSendMemberGroup($r){
global $public_r,$ecms_config;
$user_groupid=eReturnMemberDefGroupid();
$count=count($r);
if($count==0)
{
printerror("EmptySendMemberGroup","");
}
for($i=0;$i<$count;$i++)
{
$r[$i]=(int)$r[$i];
if($i==0)
{
$or="";
}
else
{
$or=" or ";
}
$a.=$or.egetmf('groupid')."='".$r[$i]."'";
if($user_groupid==$r[$i])
{
$a.=" or ".egetmf('groupid')."=0";
}
$checkbox.="";
}
$re[0]="(".$a.")";
$re[1]=$checkbox;
return $re;
}
//返回会员用户名
function ReturnSendMemberUsername($username){
$r=explode('|',$username);
$count=count($r);
for($i=0;$i<$count;$i++)
{
$r[$i]=RepPostVar($r[$i]);
if($i==0)
{
$or="";
}
else
{
$or=" or ";
}
$a.=$or.egetmf('username')."='".$r[$i]."'";
}
$re[0]="(".$a.")";
$re[1]='';
return $re;
}
//批量发送站内信息
function DoSendMsg($add,$ecms=0,$userid,$username){
global $empire,$dbtbpre;
$start=(int)$add['start'];
$line=(int)$add['line'];
$title=ClearAddsData($add['title']);
$msgtext=ClearAddsData($add['msgtext']);
if(empty($title)||empty($msgtext))
{printerror("EmptySendMsg","history.go(-1)");}
if($ecms==1)//发送邮件
{
$enews="SendEmail";
$mess="SendEmailSuccess";
$returnurl="SendEmail.php";
$pr=$empire->fetch1("select sendmailtype,smtphost,fromemail,loginemail,emailusername,emailpassword,smtpport,emailname from {$dbtbpre}enewspublic limit 1");
//发送初使化
$mailer=FirstSendMail($pr,$title,$msgtext);
}
else//发送短消息
{
$enews="SendMsg";
$mess="SendMsgSuccess";
$returnurl="SendMsg.php";
}
if($add['username'])//用户名
{
$gr=ReturnSendMemberUsername($add['username']);
}
else//会员组
{
$gr=ReturnSendMemberGroup($add['groupid']);
}
$a=" and ".$gr[0];
$b=0;
$msgtime=date("Y-m-d H:i:s");
$sql=$empire->query("select ".eReturnSelectMemberF('userid,username,havemsg,groupid,email')." from ".eReturnMemberTable()." where ".egetmf('userid').">$start".$a." order by ".egetmf('userid')." limit ".$line);
while($r=$empire->fetch($sql))
{
$b=1;
$newstart=$r['userid'];
$r['email']=RepPostVar($r['email']);
if($ecms==1)
{
$mailer->AddAddress($r['email']);
}
else
{
$ititle=str_replace("[!--username--]",$r['username'],$title);
$imsgtext=str_replace("[!--username--]",$r['username'],$msgtext);
SendSiteMsg($ititle,$imsgtext,$msgtime,$r['userid'],$r['username'],$r['havemsg']);
}
}
if(empty($b))
{
//操作日志
insert_dolog("title=$title");
printerror($mess,$returnurl.hReturnEcmsHashStrHref2(1));
}
if($ecms==1)
{
if(!$mailer->Send())
{
echo $mailer->ErrorInfo;
}
}
//输出下一组提交表单
EchoSendMsgForm($enews,$returnurl,$newstart,$line,$gr[1],$add);
}
//输出一组提交表单
function EchoSendMsgForm($enews,$returnurl,$start,$line,$checkbox,$add){
global $fun_r;
?>
()
query("insert into {$dbtbpre}enewsqmsg(title,msgtext,haveread,msgtime,to_username,from_userid,from_username,isadmin,issys) values('".addslashes($title)."','".addslashes($msgtext)."',0,'".addslashes($msgtime)."','".addslashes($username)."',0,'',1,1);");
if(!$havemsg)
{
$newhavemsg=eReturnSetHavemsg($havemsg,0);
$newhavemsg=(int)$newhavemsg;
$usql=$empire->query("update ".eReturnMemberTable()." set ".egetmf('havemsg')."='$newhavemsg' where ".egetmf('userid')."='".$userid."' limit 1");
}
}
?>