<?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,"f");
$tid=(int)$_GET['tid'];
$tbname=RepPostVar($_GET['tbname']);
if(empty($tid)||empty($tbname))
{
	printerror("ErrorUrl","history.go(-1)");
}
$enews=RepPostStr($_GET['enews'],1);
eCheckStrType(4,$tbname,1);
eCheckStrType(4,$enews,1);
if($enews=='EditF')
{
	$enews='EditF';
}
else
{
	$enews='AddF';
}
//formhash
$efh=heformhash_get($enews);

$fid=0;
$r['iscj']=1;
$r['tobr']=0;
$r['dohtml']=1;
$r['myorder']=0;
$disabled='';
$tbdatafhidden='';
$savetxthidden='';
$fmvnum=1;
$fmvline=3;
$fmvmust=1;
$url="數據表:[".$dbtbpre."ecms_".$tbname."]&nbsp;>&nbsp;<a href=ListF.php?tid=$tid&tbname=$tbname".$ecms_hashur['ehref'].">字段管理</a>&nbsp;>&nbsp;增加字段";
$postword='增加';
//修改字段
if($enews=="EditF")
{
	$fid=(int)$_GET['fid'];
	$url="數據表:[".$dbtbpre."ecms_".$tbname."]&nbsp;>&nbsp;<a href=ListF.php?tid=$tid&tbname=$tbname".$ecms_hashur['ehref'].">字段管理</a>&nbsp;>&nbsp;修改字段";
	$postword='修改';
	$r=$empire->fetch1("select * from {$dbtbpre}enewsf where fid='$fid' and tid='$tid'");
	if(!$r['fid'])
	{
		printerror("ErrorUrl","history.go(-1)");
	}
	//元素長度
	if($r['fform']=='textarea'||$r['fform']=='editor')
	{
		$fsr=explode(',',$r['fformsize']);
		$fformwidth=$fsr[0];
		$fformheight=$fsr[1];
	}
	//多值元素
	if($r['fform']=='morevaluefield')
	{
		$fmvr=explode(',',$r['fmvnum']);
		$fmvnum=$fmvr[0];
		$fmvline=$fmvr[1];
		$fmvmust=$fmvr[2];
	}
	$oftype="type".$r['ftype'];
	$$oftype=" selected";
	$ofform="form".$r['fform'];
	$$ofform=" selected";
	$disabled=' disabled';
	$tbdatafhidden='<input type="hidden" name="tbdataf" value="'.$r['tbdataf'].'">';
	$savetxthidden='<input type="hidden" name="savetxt" value="'.$r['savetxt'].'">';
}

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title><?=$postword?>字段</title>
<link href="../adminstyle/<?=$loginadminstyleid?>/adminstyle.css" rel="stylesheet" type="text/css">
<script>
function ShowFieldFormSet(obj,val){
	if(val=='text'||val=='password'||val=='flash'||val=='file'||val=='date'||val=='color'||val=='datetime')
	{
		fsizediv.style.display="";
		fwidthdiv.style.display="none";
		flinkfielddiv.style.display="none";
		feditordiv.style.display="none";
		defvaldiv.style.display="none";
		fmorevaluediv.style.display="none";
		faddlinkfielddiv.style.display="";
	}
	else if(val=='img')
	{
		fsizediv.style.display="";
		fwidthdiv.style.display="none";
		flinkfielddiv.style.display="none";
		feditordiv.style.display="none";
		defvaldiv.style.display="none";
		fmorevaluediv.style.display="none";
		faddlinkfielddiv.style.display="";
	}
	else if(val=='editor')
	{
		fsizediv.style.display="none";
		fwidthdiv.style.display="";
		flinkfielddiv.style.display="none";
		feditordiv.style.display="";
		defvaldiv.style.display="none";
		fmorevaluediv.style.display="none";
		faddlinkfielddiv.style.display="";
	}
	else if(val=='textarea'||val=='ubbeditor')
	{
		fsizediv.style.display="none";
		fwidthdiv.style.display="";
		flinkfielddiv.style.display="none";
		feditordiv.style.display="none";
		defvaldiv.style.display="none";
		fmorevaluediv.style.display="none";
		faddlinkfielddiv.style.display="";
	}
	else if(val=='select'||val=='radio'||val=='checkbox')
	{
		fsizediv.style.display="none";
		fwidthdiv.style.display="none";
		flinkfielddiv.style.display="none";
		feditordiv.style.display="none";
		defvaldiv.style.display="";
		fmorevaluediv.style.display="none";
		faddlinkfielddiv.style.display="";
	}
	else if(val=='linkfield')
	{
		fsizediv.style.display="";
		fwidthdiv.style.display="none";
		flinkfielddiv.style.display="";
		feditordiv.style.display="none";
		defvaldiv.style.display="none";
		fmorevaluediv.style.display="none";
		faddlinkfielddiv.style.display="";
	}
	else if(val=='linkfieldselect')
	{
		fsizediv.style.display="none";
		fwidthdiv.style.display="none";
		flinkfielddiv.style.display="";
		feditordiv.style.display="none";
		defvaldiv.style.display="none";
		fmorevaluediv.style.display="none";
		faddlinkfielddiv.style.display="";
	}
	else if(val=='fieldchid')
	{
		fsizediv.style.display="";
		fwidthdiv.style.display="none";
		flinkfielddiv.style.display="";
		feditordiv.style.display="none";
		defvaldiv.style.display="none";
		fmorevaluediv.style.display="none";
		faddlinkfielddiv.style.display="none";
	}
	else if(val=='morevaluefield')
	{
		fsizediv.style.display="none";
		fwidthdiv.style.display="none";
		flinkfielddiv.style.display="none";
		feditordiv.style.display="none";
		defvaldiv.style.display="none";
		fmorevaluediv.style.display="";
		faddlinkfielddiv.style.display="";
	}
}
</script>
</head>

<body onload="ShowFieldFormSet(document.addfform,'<?=$r['fform']?$r['fform']:'text'?>')">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
  <tr>
    <td height="32">位置：<?=$url?></td>
  </tr>
</table>
<form name="addfform" method="post" action="../ecmsmod.php">
  <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
    <tr> 
      <td height="25" colspan="2" class="header"> 
        <?=$postword?>
        數據表( 
        <?=$dbtbpre?>
        ecms_ 
        <?=$tbname?>
        )字段 
        <input name="fid" type="hidden" id="fid" value="<?=$fid?>"> <input name="enews" type="hidden" id="enews" value="<?=$enews?>"> 
        <input name="oldfform" type="hidden" id="oldfform" value="<?=$r['fform']?>"> 
        <input name="oldf" type="hidden" id="oldf" value="<?=$r['f']?>"> <input name="tbname" type="hidden" id="tbname" value="<?=$tbname?>"> 
        <input name="tid" type="hidden" id="tid" value="<?=$tid?>"> <input name="oldfvalue" type="hidden" id="oldfvalue" value="<?=ehtmlspecialchars(stripSlashes($r['fvalue']))?>"> 
        <input name="oldsavetxt" type="hidden" id="oldsavetxt" value="<?=$r['savetxt']?>"> 
        <input name="oldlinkfieldval" type="hidden" id="oldlinkfieldval" value="<?=$r['linkfieldval']?>"> 
        <input name="oldfformsize" type="hidden" id="oldfformsize" value="<?=$r['fformsize']?>"> 
		<?=$ecms_hashur['form']?>
		<?php echo $efh; ?>
      </td>
    </tr>
    <tr> 
      <td height="25" colspan="2">基本設置</td>
    </tr>
    <tr> 
      <td width="25%" height="25" bgcolor="#FFFFFF">字段名</td>
      <td width="75%" height="25" bgcolor="#FFFFFF"> <input name="f" type="text" id="f" value="<?=$r['f']?>">
        <font color="#666666">(由英文與數字組成，且不能以數字開頭。比如：&quot;title&quot;)</font></td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">字段標識</td>
      <td height="25" bgcolor="#FFFFFF"> <input name="fname" type="text" id="fname" value="<?=$r['fname']?>"> 
        <font color="#666666">(比如：&quot;標題&quot;)</font></td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">字段類型</td>
      <td height="25" bgcolor="#FFFFFF"> <select name="ftype" id="select">
          <option value="VARCHAR"<?=$typeVARCHAR?>>字符型0-255字節(VARCHAR)</option>
		  <option value="CHAR"<?=$typeCHAR?>>定長字符型0-255字節(CHAR)</option>
          <option value="TEXT"<?=$typeTEXT?>>小型字符型(TEXT)</option>
          <option value="MEDIUMTEXT"<?=$typeMEDIUMTEXT?>>中型字符型(MEDIUMTEXT)</option>
          <option value="LONGTEXT"<?=$typeLONGTEXT?>>大型字符型(LONGTEXT)</option>
          <option value="TINYINT"<?=$typeTINYINT?>>小數值型(TINYINT)</option>
          <option value="SMALLINT"<?=$typeSMALLINT?>>中數值型(SMALLINT)</option>
          <option value="INT"<?=$typeINT?>>大數值型(INT)</option>
          <option value="BIGINT"<?=$typeBIGINT?>>超大數值型(BIGINT)</option>
          <option value="FLOAT"<?=$typeFLOAT?>>數值浮點型(FLOAT)</option>
          <option value="DOUBLE"<?=$typeDOUBLE?>>數值雙精度型(DOUBLE)</option>
          <option value="DATE"<?=$typeDATE?>>日期型(DATE)</option>
          <option value="DATETIME"<?=$typeDATETIME?>>日期時間型(DATETIME)</option>
        </select>
        長度 
        <input name="flen" type="text" id="flen" value="<?=$r['flen']?>" size="6"> 
      </td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">存放表</td>
      <td height="25" bgcolor="#FFFFFF"> <input type="radio" name="tbdataf" value="0"<?=$r['tbdataf']==0?' checked':''?><?=$disabled?>>
        主表 
        <input type="radio" name="tbdataf" value="1"<?=$r['tbdataf']==1?' checked':''?><?=$disabled?>>
        副表<?=$tbdatafhidden?><font color="#666666"> (設置後不能修改)</font></td>
    </tr>
    <tr> 
      <td height="25" colspan="2">特殊屬性</td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">加索引</td>
      <td height="25" bgcolor="#FFFFFF"> <input type="radio" name="iskey" value="1"<?=$r['iskey']==1?' checked':''?>>
        是 
        <input type="radio" name="iskey" value="0"<?=$r['iskey']==0?' checked':''?>>
        否 
        <input name="oldiskey" type="hidden" id="oldiskey" value="<?=$r['iskey']?>"></td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">值唯一</td>
      <td height="25" bgcolor="#FFFFFF"> <input type="radio" name="isonly" value="1"<?=$r['isonly']==1?' checked':''?>>
        是 
        <input type="radio" name="isonly" value="0"<?=$r['isonly']==0?' checked':''?>>
        否 
        <input name="oldisonly" type="hidden" id="oldisonly" value="<?=$r['isonly']?>"></td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">採集項</td>
      <td height="25" bgcolor="#FFFFFF"> <input name="iscj" type="radio" value="1"<?=$r['iscj']==1?' checked':''?>>
        是 
        <input name="iscj" type="radio" value="0"<?=$r['iscj']==0?' checked':''?>>
        否 
        <input name="oldiscj" type="hidden" id="oldiscj" value="<?=$r['iscj']?>"></td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">分頁字段</td>
      <td height="25" bgcolor="#FFFFFF"><input type="radio" name="ispage" value="1"<?=$r['ispage']==1?' checked':''?>>
        是 
        <input type="radio" name="ispage" value="0"<?=$r['ispage']==0?' checked':''?>>
        否<font color="#666666">(表只可設置一個字段)</font></td>
    </tr>
    <tr>
      <td height="25" bgcolor="#FFFFFF">簡介字段</td>
      <td height="25" bgcolor="#FFFFFF"><input type="radio" name="issmalltext" value="1"<?=$r['issmalltext']==1?' checked':''?>>
        是 
        <input type="radio" name="issmalltext" value="0"<?=$r['issmalltext']==0?' checked':''?>>
        否<font color="#666666">(模板裡設置截取簡介字數的字段)</font></td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">內容存文本</td>
      <td height="25" bgcolor="#FFFFFF"> <input type="radio" name="savetxt" value="1"<?=$r['savetxt']==1?' checked':''?><?=$disabled?>>
        是 
        <input type="radio" name="savetxt" value="0"<?=$r['savetxt']==0?' checked':''?><?=$disabled?>>
        否<?=$savetxthidden?><font color="#666666">(設置後不能修改,表只可設置一個字段)</font></td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">前台內容顯示</td>
      <td height="25" bgcolor="#FFFFFF"> <input name="tobr" type="checkbox" id="tobr" value="1"<?=$r['tobr']==1?' checked':''?>>
        將回車替換成換行符, 
        <input name="dohtml" type="checkbox" id="dohtml" value="1"<?=$r['dohtml']==1?' checked':''?>>
        支持html代碼</td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">後台增加信息處理函數</td>
      <td height="25" bgcolor="#FFFFFF"><input name="adddofun" type="text" id="adddofun" value="<?=$r['adddofun']?>">
        <font color="#666666">(一般不設置，格式「函數名##參數」參數可不設置)</font></td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">後台修改信息處理函數</td>
      <td height="25" bgcolor="#FFFFFF"><input name="editdofun" type="text" id="editdofun" value="<?=$r['editdofun']?>">
        <font color="#666666">(一般不設置，格式「函數名##參數」參數可不設置)</font></td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">前台增加信息處理函數</td>
      <td height="25" bgcolor="#FFFFFF"><input name="qadddofun" type="text" id="qadddofun" value="<?=$r['qadddofun']?>">
        <font color="#666666">(一般不設置，格式「函數名##參數」參數可不設置)</font></td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">前台修改信息處理函數</td>
      <td height="25" bgcolor="#FFFFFF"><input name="qeditdofun" type="text" id="qeditdofun" value="<?=$r['qeditdofun']?>">
        <font color="#666666">(一般不設置，格式「函數名##參數」參數可不設置)</font></td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">顯示順序</td>
      <td height="25" bgcolor="#FFFFFF"> <input name="myorder" type="text" id="myorder" value="<?=$r['myorder']?>"> 
        <font color="#666666">(數字越小越前面)</font></td>
    </tr>
    <tr> 
      <td height="25" colspan="2">表單顯示設置</td>
    </tr>
    <tr> 
      <td bgcolor="#FFFFFF">輸入表單顯示元素</td>
      <td height="25" bgcolor="#FFFFFF"> <select name="fform" id="fform" onchange="ShowFieldFormSet(document.addfform,this.options[this.selectedIndex].value)">
          <option value="text"<?=$formtext?>>單行文本框(text)</option>
          <option value="password"<?=$formpassword?>>密碼框(password)</option>
          <option value="select"<?=$formselect?>>下拉框(select)</option>
          <option value="radio"<?=$formradio?>>單選框(radio)</option>
          <option value="checkbox"<?=$formcheckbox?>>復選框(checkbox)</option>
          <option value="textarea"<?=$formtextarea?>>多行文本框(textarea)</option>
          <option value="editor"<?=$formeditor?>>編輯器(editor)</option>
          <option value="img"<?=$formimg?>>圖片(img)</option>
          <option value="flash"<?=$formflash?>>FLASH文件(flash)</option>
          <option value="file"<?=$formfile?>>文件(file)</option>
          <option value="date"<?=$formdate?>>日期(date)</option>
		  <option value="datetime"<?=$formdatetime?>>日期時間(datetime)</option>
          <option value="color"<?=$formcolor?>>顏色(color)</option>
		  <option value="morevaluefield"<?=$formmorevaluefield?>>多值字段(morevaluefield)</option>
          <option value="linkfield"<?=$formlinkfield?>>選擇外表關聯字段(linkfield)</option>
          <option value="linkfieldselect"<?=$formlinkfieldselect?>>下拉外表關聯字段(linkfieldselect)</option>
		  <option value="fieldchid"<?=$formfieldchid?>>信息ID列表字段(fieldchid)</option>
        </select> </td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">選項</td>
      <td height="25" bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="1" cellpadding="2">
          <tr id="fsizediv"> 
            <td height="23"><strong>元素長度</strong><br> <input name="fformsize" type="text" id="fformsize" value="<?=$r['fformsize']?>"> 
              <font color="#666666">(空為按默認)</font></td>
          </tr>
          <tr id="fwidthdiv"> 
            <td height="23"><strong>元素大小</strong><br>
              寬度 
              <input name="fformwidth" type="text" id="fformwidth" value="<?=$fformwidth?>" size="6">
              ×高度 
              <input name="fformheight" type="text" id="fformheight" value="<?=$fformheight?>" size="6"> 
              <font color="#666666">(空為按默認)</font></td>
          </tr>
          <tr id="flinkfielddiv"> 
            <td height="23"><strong>選擇模型字段設置</strong><br>
              數據表名 
              <input name="linkfieldtb" type="text" id="linkfieldtb" value="<?=$r['linkfieldtb']?>"> 
              <span id="faddlinkfielddiv">
			  <br>
              值字段名 
              <input name="linkfieldval" type="text" id="linkfieldval" value="<?=$r['linkfieldval']?>"> 
              <input name="samedata" type="checkbox" id="samedata" value="1"<?=$r['samedata']==1?' checked':''?>>
              數據同步<br>
              顯示字段 
              <input name="linkfieldshow" type="text" id="linkfieldshow" value="<?=$r['linkfieldshow']?>"> 
			  </span>
            </td>
          </tr>
          <tr id="feditordiv"> 
            <td height="23"><strong>編輯器樣式</strong><br> <input type="radio" name="editorys" value="0"<?=$r['editorys']==0?' checked':''?>>
              標準型 
              <input type="radio" name="editorys" value="1"<?=$r['editorys']==1?' checked':''?>>
              簡潔型</td>
          </tr>
		  <tr id="fmorevaluediv"> 
            <td height="23"><strong>多值字段元素格式</strong><br>
              設置列數 
              <input name="fmvnum" type="text" id="fmvnum" value="<?=$fmvnum?>" size="6">
              ，默認行數 
              <input name="fmvline" type="text" id="fmvline" value="<?=$fmvline?>" size="6">
              ，第
              <input name="fmvmust" type="text" id="fmvmust" value="<?=$fmvmust?>" size="6">
              列必填</td>
          </tr>
        </table></td>
    </tr>
    <tr> 
      <td valign="top" bgcolor="#FFFFFF"><p>初始值<br>
          <font color="#666666"><span id="defvaldiv">(多個值用&quot;回車&quot;格開；<br>
          「下拉/單選/復選」格式用：值==名稱；<br>
          當值等於名稱時，名稱可省略；<br>
          默認選項後面加：:default)</span></font></p></td>
      <td height="25" bgcolor="#FFFFFF"> <textarea name="fvalue" cols="65" rows="8" id="fvalue" style="WIDTH: 100%"><?=ehtmlspecialchars(stripSlashes(str_replace("|","\r\n",$r['fvalue'])))?></textarea></td>
    </tr>
    <tr> 
      <td height="25" valign="top" bgcolor="#FFFFFF">輸入表單替換html代碼<br> <font color="#666666">(增加字段時請留空)</font></td>
      <td height="25" bgcolor="#FFFFFF"> <textarea name="fhtml" cols="65" rows="10" id="fhtml" style="WIDTH: 100%"><?=ehtmlspecialchars(stripSlashes($r['fhtml']))?></textarea></td>
    </tr>
    <tr> 
      <td height="25" valign="top" bgcolor="#FFFFFF">投稿表單替換html代碼<br> <font color="#666666">(增加字段時請留空)</font></td>
      <td height="25" bgcolor="#FFFFFF"> <textarea name="qfhtml" cols="65" rows="10" id="qfhtml" style="WIDTH: 100%"><?=ehtmlspecialchars(stripSlashes($r['qfhtml']))?></textarea></td>
    </tr>
    <tr> 
      <td height="25" valign="top" bgcolor="#FFFFFF">註釋</td>
      <td height="25" bgcolor="#FFFFFF"> <textarea name="fzs" cols="65" rows="6" id="fzs" style="WIDTH: 100%"><?=stripSlashes($r['fzs'])?></textarea></td>
    </tr>
    <tr> 
      <td height="25" bgcolor="#FFFFFF">&nbsp;</td>
      <td height="25" bgcolor="#FFFFFF"> <input type="submit" name="Submit" value="提交"> 
        <input type="reset" name="Submit2" value="重置"></td>
    </tr>
  </table>
  <table width="100%" border="0" cellspacing="1" cellpadding="3">
    <tr>
      <td height="25"><font color="#666666">說明：主表字段越少效率越高，不在列表調用字段建議將字段存在副表。</font></td>
    </tr>
  </table>
</form>
<br>
</body>
</html>
<?php
db_close();
$empire=null;
?>