<?php
define('EmpireCMSAdmin','1');
require("../../../e/class/connect.php");
require("../../../e/class/functions.php");
$link=db_connect();
$empire=new mysqlquery();
$editor=1;
//驗證用戶
$lur=is_login();
$logininid=(int)$lur['userid'];
$loginin=$lur['username'];
$loginrnd=$lur['rnd'];
$loginlevel=(int)$lur['groupid'];
$loginadminstyleid=(int)$lur['adminstyleid'];
//ehash
$ecms_hashur=hReturnEcmsHashStrAll();
//驗證權限
CheckLevel($logininid,$loginin,$classid,"repnewstext");
$url="<a href=RepNewstext.php".$ecms_hashur['whehref'].">批量替換信息內容</a>";
//欄目
$fcfile="../../../c/ecachepub/eclassfc/ListEnews.php";
$class="<script src=../../../c/ecachepub/eclassfc/cmsclass.js></script>";
if(!file_exists($fcfile))
{$class=ShowClass_AddClass("",0,0,"|-",0,0);}
//數據表
$tbname=RepPostVar($_GET['tbname']);
eCheckStrType(4,$tbname,1);
$table='';
$first=1;
$htb=0;
$tsql=$empire->query("select tid,tbname,tname from {$dbtbpre}enewstable order by tid");
while($tr=$empire->fetch($tsql))
{
	if($first==1)
	{
		$firsttable=$tr['tbname'];
		$firsttid=$tr['tid'];
		$first=0;
	}
	else
	{$first=0;}
	if($tbname==$tr['tbname'])
	{
		$htb=1;
		$select=" selected";
		$thistid=$tr['tid'];
	}
	else
	{
		$select="";
	}
	$table.="<option value='".$tr['tbname']."'".$select.">".$tr['tname']."</option>";
}
if(!$table)
{printerror("NotRepNewstextTb","history.go(-1)");}
$table="<select name='tbname' onchange=self.location='RepNewstext.php?".$ecms_hashur['ehref']."&tbname='+this.options[this.selectedIndex].value>".$table."</select>";
//字段
if(empty($tbname))
{
	$showtable=$firsttable;
	$showtid=$firsttid;
}
else
{
	if($htb==0)
	{
		printerror("ErrorUrl","history.go(-1)");
	}
	$showtable=$tbname;
	$showtid=$thistid;
}
$field='';
$s=do_dbFieldRowList($dbtbpre.'ecms_'.$showtable);
$noshowfield=",id,onclick,newspath,keyboard,keyid,userid,username,istop,truetime,ismember,dokey,isgood,titlecolor,titlefont,isurl,titleurl,filename,plnum,firsttitle,totaldown,";
while($r=$empire->fetch($s))
{
	//不顯示字段
	if(strstr($noshowfield,",".$r['Field'].","))
	{
		//continue;
	}
	$field.="<option value='".$r['Field']."'>".$r['Field']."</option>";
}
$datafsql=do_dbFieldRowList($dbtbpre.'ecms_'.$showtable.'_data_1');
while($dfr=$empire->fetch($datafsql))
{
	if($dfr['Field']=='classid'||$dfr['Field']=='id')
	{
		continue;
	}
	$field.="<option value='".$dfr['Field']."'>".$dfr['Field']."</option>";
}

?>
<!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="../adminstyle/<?=$loginadminstyleid?>/adminstyle.css" rel="stylesheet" type="text/css">
</head>

<body>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
  <tr>
    <td height="32">位置：<?=$url?></td>
  </tr>
</table>

<form action="../ecmscom.php" method="post" name="form1" target="_blank" onsubmit="return confirm('確認要替換？');">
  <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
  <?=$ecms_hashur['form']?>
  <?php echo heformhash_get('DoRepNewstext'); ?>
    <tr class="header"> 
      <td height="25" colspan="2">批量替換信息內容 
        <input name="enews" type="hidden" id="enews" value="DoRepNewstext"> <input name="tid" type="hidden" id="tid" value="<?=$showtid?>"></td>
    </tr>
    <tr bgcolor="#FFFFFF"> 
      <td height="25">選擇替換表(*)：</td>
      <td height="25"> 
        <?=$table?>
      </td>
    </tr>
    <tr bgcolor="#FFFFFF"> 
      <td width="15%" height="25">操作欄目：</td>
      <td width="85%" height="25"><select name="classid" id="classid">
          <option value=0>所有欄目</option>
          <?=$class?>
        </select> <font color="#666666">(如選擇父欄目，將應用於所有子欄目)</font></td>
    </tr>
    <tr bgcolor="#FFFFFF"> 
      <td height="25">替換字段(*)：</td>
      <td height="25"><select name="field" size="12" id="field" style="width:180">
          <?=$field?>
        </select> </td>
    </tr>
    <tr bgcolor="#FFFFFF"> 
      <td height="26">替換內容：</td>
      <td height="26"> <table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#DBEAF5">
          <tr> 
            <td> <div align="center">原字符</div></td>
            <td bgcolor="#FFFFFF"> <div align="left"> 
                <textarea name="oldword" cols="100" rows="5" id="textarea"></textarea>
                (*)</div></td>
          </tr>
          <tr> 
            <td> <div align="center">新字符 </div></td>
            <td bgcolor="#FFFFFF"> <div align="left"> 
                <textarea name="newword" cols="100" rows="5" id="newword2"></textarea>
              </div></td>
          </tr>
        </table></td>
    </tr>
    <tr bgcolor="#FFFFFF">
      <td height="26">更新方式：</td>
      <td height="26"><input name="dotype" type="radio" value="0" checked>
        替換
        <input type="radio" name="dotype" value="1">
        覆蓋 <font color="#666666">(覆蓋方式為將字段全部內容更新為新字符內容，覆蓋方式原字符可以不設置)</font></td>
    </tr>
    <tr bgcolor="#FFFFFF"> 
      <td rowspan="2">選項設置：</td>
      <td height="26"><p>相同更新 
          <input name="over" type="checkbox" id="over" value="1">
          <font color="#666666">(相同更新:當「字段值=原字符」的條件下才替換或覆蓋)</font></p>
      </td>
    </tr>
    <tr bgcolor="#FFFFFF"> 
      <td height="26">正則替換 
        <input name="dozz" type="checkbox" id="dozz" value="1">
        <font color="#666666"> (正則替換:原字符可以是用正則表示，用「*」表示任意字符)</font></td>
    </tr>
    <tr bgcolor="#FFFFFF"> 
      <td height="25">&nbsp;</td>
      <td height="25"><input type="submit" name="Submit" value="提交"> <input type="reset" name="Submit2" value="重置"></td>
    </tr>
    <tr bgcolor="#FFFFFF"> 
      <td height="25" colspan="2">備註：替換時最好備份一下數據．</td>
    </tr>
  </table>
</form>
<br>
</body>
</html>
<?php
db_close();
$empire=null;
?>