ChangeField.php 6.47 KB

Raw Blame History Permalink

<?php
define('EmpireCMSAdmin','1');
require("../../class/connect.php");
require("../../class/db_sql.php");
require("../../class/functions.php");
require "../".LoadLang("pub/fun.php");
$link=db_connect();
$empire=new mysqlquery();
$editor=1;
//驗證用戶
$lur=is_login();
$logininid=$lur['userid'];
$loginin=$lur['username'];
$loginrnd=$lur['rnd'];
$loginlevel=$lur['groupid'];
$loginadminstyleid=$lur['adminstyleid'];
//ehash
$ecms_hashur=hReturnEcmsHashStrAll();

$tid=(int)$_GET['tid'];
if($tid)
{
	$tbwhere="tid='$tid'";
	$search="&tid=$tid";
}
else
{
	$tbname=RepPostVar($_GET['tbname']);
	$tbwhere="tbname='$tbname'";
	$search="&tbname=$tbname";
}
$search.=$ecms_hashur['ehref'];
$viewf=RepPostVar($_GET['viewf']);
$changef=RepPostVar($_GET['changef']);
if(!$viewf||!$changef)
{
	printerror('ErrorUrl','');
}
//取得表名
$tbr=$empire->fetch1("select tbname from {$dbtbpre}enewstable where ".$tbwhere);
if(!$tbr['tbname'])
{
	printerror('ErrorUrl','');
}
$tbname=$tbr['tbname'];
//字段
$sysf=',id,classid,onclick,newspath,keyboard,userid,username,istop,truetime,ismember,userfen,isgood,titlefont,isurl,filename,groupid,plnum,firsttitle,isqf,totaldown,havehtml,lastdotime,stb,ttid,';
$viewfr=$empire->fetch1("select f,fname from {$dbtbpre}enewsf where ".$tbwhere." and f='$viewf' and tbdataf=0 limit 1");
$changefr=$empire->fetch1("select f,fname from {$dbtbpre}enewsf where ".$tbwhere." and f='$changef' and tbdataf=0 limit 1");
if(!$viewfr[f]&&!strstr($sysf,','.$viewf.','))
{
	printerror('ErrorUrl','');
}
if(!$changefr[f]&&!strstr($sysf,','.$changef.','))
{
	printerror('ErrorUrl','');
}
if(strstr($sysf,','.$viewf.','))
{
	$viewfr[fname]=$viewf;
}
if(strstr($sysf,','.$changef.','))
{
	$changefr[fname]=$changef;
}
$form=RepPostVar($_GET['form']);
if(empty($form))
{
	$form='add';
}
$field=RepPostVar($_GET['field']);
$add='';
//關鍵字
$keyboard=RepPostVar2($_GET['keyboard']);
if(!empty($keyboard))
{
	$show=RepPostVar($_GET['show']);
	if($show==$viewf||$show==$changef)
	{
		$add=" where ".$show." like '%".$keyboard."%'";
	}
	if($show==$changef)
	{
		$searchoptionselect=' selected';
	}
}
$changeline=(int)$_GET['changeline'];
if($changeline<1)
{
	$changeline=2;
}
$search.="&viewf=$viewf&changef=$changef&form=$form&field=$field&show=$show&keyboard=$keyboard&changeline=$changeline";
if($viewf==$changef)
{
	$searchoption="<option value='$viewf'>$viewfr[fname]</option>";
}
else
{
	$searchoption="<option value='$viewf'>$viewfr[fname]</option><option value='$changef'".$searchoptionselect.">$changefr[fname]</option>";
}
//分頁
$page=(int)$_GET['page'];
$page=RepPIntvar($page);
$start=0;
$line=50;//每頁顯示條數
$page_line=12;//每頁顯示鏈接數
$offset=$page*$line;//總偏移量
$query="select ".$viewf.",".$changef." from {$dbtbpre}ecms_".$tbname.$add;
$totalquery="select count(*) as total from {$dbtbpre}ecms_".$tbname.$add;
$num=$empire->gettotal($totalquery);//取得總條數
$query=$query." order by id desc limit $offset,$line";
$sql=$empire->query($query);
$returnpage=page2($num,$line,$page_line,$start,$page,$search);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>選擇</title>
<link href="edit.css" rel="stylesheet" type="text/css">
<link href="../adminstyle/<?=$loginadminstyleid?>/adminstyle.css" rel="stylesheet" type="text/css">
<script>
function ChangeFieldVal(val)
{
	opener.document.<?=$form?>.<?=$field?>.value=val;
	window.close();
}
</script>
</head>
<body>
<form name="form1" id="form1" method="get" action="ChangeField.php">
  <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
  <?=$ecms_hashur['eform']?>
    <tr>
      <td width="70%"><div align="center">搜索：
          <input name="keyboard" type="text" value="<?=$keyboard?>">
          <select name="show">
            <?=$searchoption?>
          </select>
          <input type="submit" name="Submit" value="搜索">
          <input type=hidden name="form" value="<?=$form?>">
          <input type=hidden name="field" value="<?=$field?>">
          <input name="tid" type="hidden" id="tid" value="<?=$tid?>">
          <input name="tbname" type="hidden" value="<?=$tbname?>">
          <input name="viewf" type="hidden" id="viewf" value="<?=$viewf?>">
          <input name="changef" type="hidden" id="changef" value="<?=$changef?>">
          <input name="changeline" type="hidden" value="<?=$changeline?>">
        </div></td>
      <td width="30%">
	  <span id="showaddclassnav"></span>
      <input type="button" name="Submit" value="增加信息" onclick="if(document.getElementById('addclassid').value!=0){window.open('../AddNews.php?<?=$ecms_hashur['ehref']?>&enews=AddNews&classid='+document.getElementById('addclassid').value,'','');}else{alert('請選擇要增加信息的欄目');document.getElementById('addclassid').focus();}">
	  </td>
    </tr>
  </table>
</form>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
  <tr>
    <td height="25" bgcolor="#FFFFFF"> <div align="center">
    <?php
	//輸出
	$i=0;
	$class_text="";
	while($r=$empire->fetch($sql))
	{
		$i++;
        if(($i-1)%$changeline==0||$i==1)
		{
			$class_text.="<tr>";
		}
		$class_text.="<td align=center height=25><a href='#ecms' onclick=\"ChangeFieldVal('".ehtmlspecialchars(stripSlashes($r[$changef]))."');\" title='選擇'>".stripSlashes($r[$viewf])."</a></td>";
		//分割
        if($i%$changeline==0)
		{
			$class_text.="</tr>";
		}
	}
	if($i<>0)
	{
		 $table="<table width=100% border=0 cellpadding=3 cellspacing=0>";$table1="</table>";
         $ys=$changeline-$i%$changeline;
		 $p=0;
         for($j=0;$j<$ys&&$ys!=$changeline;$j++)
		 {
			  $p=1;
              $class_text.="<td></td>";
         }
		 if($p==1)
		 {
			  $class_text.="</tr>";
		 }
	 }
     $text=$table.$class_text.$table1;
     echo"$text";
	?>
      </div></td>
  </tr>
  <tr>
    <td height="25" bgcolor="#FFFFFF" align=center>
      <?=$returnpage?>
    </td>
  </tr>
</table>
<div align="center"> <br>
  [<a href="#empirecms" onclick="window.close();">關閉</a>]</div>
<IFRAME frameBorder="0" id="showclassnav" name="showclassnav" scrolling="no" src="../ShowClassNav.php?ecms=7<?=$ecms_hashur['ehref']?>" style="HEIGHT:0;VISIBILITY:inherit;WIDTH:0;Z-INDEX:1"></IFRAME>
</body>
</html>
<?php
db_close();
$empire=null;
?>