管理扩展变量

gettotal("select count(*) as total from {$dbtbpre}enewspubvar where myvar='$add[myvar]' limit 1"); if($num) { printerror("RePubVar","history.go(-1)"); } $add['varname']=hRepPostStr($add['varname'],1); $add['varsay']=hRepPostStr($add['varsay'],1); $classid=(int)$add[classid]; $tocache=(int)$add[tocache]; $add[myorder]=(int)$add[myorder]; $add[varvalue]=AddAddsData(RepPhpAspJspcode($add[varvalue])); $sql=$empire->query("insert into {$dbtbpre}enewspubvar(myvar,varname,varvalue,varsay,myorder,classid,tocache) values('$add[myvar]','$add[varname]','".$add[varvalue]."','$add[varsay]','$add[myorder]','$classid','$tocache');"); $lastid=$empire->lastid(); if($tocache) { GetConfig(); } if($sql) { //操作日志 insert_dolog("varid=".$lastid."
var=".$add[myvar]); printerror("AddPubVarSuccess","AddPubVar.php?enews=AddPubVar".hReturnEcmsHashStrHref2(0)); } else {printerror("DbError","history.go(-1)");} } //修改变量 function EditPubVar($add,$userid,$username){ global $empire,$dbtbpre; $add[varid]=(int)$add['varid']; $add[myvar]=RepPostVar($add[myvar]); if(!$add[varid]||!$add[myvar]||!$add[varname]) { printerror("EmptyPubVar","history.go(-1)"); } //验证权限 CheckLevel($userid,$username,$classid,"pubvar"); if($add[myvar]!=$add[oldmyvar]) { $num=$empire->gettotal("select count(*) as total from {$dbtbpre}enewspubvar where myvar='$add[myvar]' and varid<>$add[varid] limit 1"); if($num) { printerror("RePubVar","history.go(-1)"); } } $add['varname']=hRepPostStr($add['varname'],1); $add['varsay']=hRepPostStr($add['varsay'],1); $add[varvalue]=AddAddsData(RepPhpAspJspcode($add[varvalue])); $classid=(int)$add[classid]; $tocache=(int)$add[tocache]; $add[myorder]=(int)$add[myorder]; $sql=$empire->query("update {$dbtbpre}enewspubvar set myvar='$add[myvar]',varname='$add[varname]',varvalue='".$add[varvalue]."',varsay='$add[varsay]',myorder='$add[myorder]',classid='$classid',tocache='$tocache' where varid='$add[varid]'"); if($tocache||$add['oldtocache']) { GetConfig(); } if($sql) { //操作日志 insert_dolog("varid=".$add[varid]."
var=".$add[myvar]); printerror("EditPubVarSuccess","ListPubVar.php?classid=$add[cid]".hReturnEcmsHashStrHref2(0)); } else {printerror("DbError","history.go(-1)");} } //删除变量 function DelPubVar($varid,$cid,$userid,$username){ global $empire,$dbtbpre; $varid=(int)$varid; if(!$varid) { printerror("NotDelPubVarid","history.go(-1)"); } //验证权限 CheckLevel($userid,$username,$classid,"pubvar"); $r=$empire->fetch1("select myvar,tocache from {$dbtbpre}enewspubvar where varid='$varid'"); $sql=$empire->query("delete from {$dbtbpre}enewspubvar where varid='$varid'"); if($r['tocache']) { GetConfig(); } if($sql) { //操作日志 insert_dolog("varid=".$varid."
var=".$r[myvar]); printerror("DelPubVarSuccess","ListPubVar.php?classid=$cid".hReturnEcmsHashStrHref2(0)); } else {printerror("DbError","history.go(-1)");} } $enews=$_POST['enews']; if(empty($enews)) {$enews=$_GET['enews'];} if($enews) { hCheckEcmsRHash(); } //增加变量 if($enews=="AddPubVar") { $add=$_POST; AddPubVar($add,$logininid,$loginin); } //修改变量 elseif($enews=="EditPubVar") { $add=$_POST; EditPubVar($add,$logininid,$loginin); } //删除变量 elseif($enews=="DelPubVar") { $varid=$_GET['varid']; $cid=$_GET['cid']; DelPubVar($varid,$cid,$logininid,$loginin); } $search=''; $search.=$ecms_hashur['ehref']; $page=(int)$_GET['page']; $page=RepPIntvar($page); $start=0; $line=30;//每页显示条数 $page_line=12;//每页显示链接数 $offset=$page*$line;//总偏移量 $query="select varid,myvar,varvalue,varname,tocache,classid from {$dbtbpre}enewspubvar"; $totalquery="select count(*) as total from {$dbtbpre}enewspubvar"; //分类 $add=''; $classid=(int)$_GET['classid']; if($classid) { $add=" where classid='$classid'"; $search.="&classid=$classid"; } $query.=$add; $totalquery.=$add; $num=$empire->gettotal($totalquery);//取得总条数 $query=$query." order by myorder,varid desc limit $offset,$line"; $sql=$empire->query($query); $returnpage=page2($num,$line,$page_line,$start,$page,$search); //分类 $cstr=""; $csql=$empire->query("select classid,classname from {$dbtbpre}enewspubvarclass order by classid"); while($cr=$empire->fetch($csql)) { $select=""; if($cr[classid]==$classid) { $select=" selected"; } $cstr.=""; } ?> 管理扩展变量

位置: 管理扩展变量

选择分类：

fetch($sql)) { //分类 $cname='未分类'; if($r['classid']) { $lcr=$empire->fetch1("select classname from {$dbtbpre}enewspubvarclass where classid='$r[classid]'"); $cname=''.$lcr[classname].''; } if($r[tocache]) { $tocache='写入'; } else { $tocache='不写入'; } ?>

ID	变量名	变量标识	所属分类	写入缓存	操作
					[修改] [删除]

1、写入缓存的变量调用

在任意php或模板中用$public_r['add_变量名']可取得变量内容。

2、没有写入缓存的变量调用

可以用内置变量返回函数(数据库读取变量内容)：ReturnPublicAddVar(变量名)。取多个变量内容可用逗号隔开，例子：
取得单变量内容：$value=ReturnPublicAddVar('myvar'); //$value就是变量内容。
取得多个变量内容：$value=ReturnPublicAddVar('myvar1,myvar2,myvar3'); //$value['myvar1']才是变量内容。