<?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,"table");
$tid=(int)$_GET['tid'];
$tbname=RepPostVar($_GET['tbname']);
eCheckStrType(4,$tbname,1);
if(!$tid||!$tbname)
{
	printerror("ErrorUrl","history.go(-1)");
}
$r=$empire->fetch1("select tid,datatbs,deftb from {$dbtbpre}enewstable where tid='$tid'");
if(!$r['tid'])
{
	printerror("ErrorUrl","history.go(-1)");
}
$tr=explode(',',$r['datatbs']);
$url="數據表:[".$dbtbpre."ecms_".$tbname."]&nbsp;>&nbsp;<a href=ListDataTable.php?tid=$tid&tbname=$tbname".$ecms_hashur['ehref'].">管理副表分表</a>";
$datatbname=$dbtbpre.'ecms_'.$tbname.'_data_';
?>
<!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 name="adddatatableform" method="post" action="../ecmsmod.php" onsubmit="return confirm('確認要增加?');">
  <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
  <?=$ecms_hashur['form']?>
  <?php echo heformhash_get('AddDataTable'); ?>
    <tr class="header">
      <td>增加副表分表
        <input name="enews" type="hidden" id="enews" value="AddDataTable">
        <input name="tid" type="hidden" id="tid" value="<?=$tid?>"> <input name="tbname" type="hidden" id="tbname" value="<?=$tbname?>"></td>
    </tr>
    <tr> 
      <td bgcolor="#FFFFFF">
        <?=$datatbname?>
        <input name="datatb" type="text" id="datatb" value="0" size="6">
        <input type="submit" name="Submit" value="增加">
        <font color="#666666">(表名要用數字)</font></td>
    </tr>
  </table>
</form>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
  <tr class="header"> 
    <td width="38%" height="25"><div align="center">表名</div></td>
    <td width="33%" height="25"><div align="center">記錄數</div></td>
    <td width="29%" height="25"><div align="center">操作</div></td>
  </tr>
  <?php
  //formhash
  $efh=heformhash_get('DelDataTable',1);
  $efh1=heformhash_get('DefDataTable',1);
  
  $count=count($tr)-1;
  $maxtb=0;
  for($i=1;$i<$count;$i++)
  {
	$tbrownum=do_dbTableRowNum($datatbname.$tr[$i]);
	$bgcolor="#ffffff";
	$movejs=' onmouseout="this.style.backgroundColor=\'#ffffff\'" onmouseover="this.style.backgroundColor=\'#C3EFFF\'"';
	if($tr[$i]==$r['deftb'])
	{
		$bgcolor="#DBEAF5";
		$movejs='';
	}
	if($tr[$i]>$maxtb)
	{
		$maxtb=$tr[$i];
	}
	$dostr=$tr[$i]==1?"":"&nbsp;&nbsp;&nbsp;[<a href=\"../ecmsmod.php?tid=$tid&tbname=$tbname&enews=DelDataTable&datatb=".$tr[$i].$ecms_hashur['href'].$efh."\" onclick=\"return confirm('確認要刪除，刪除會刪除表裡的所有信息?');\">刪除</a>]";
  ?>
  <tr bgcolor="<?=$bgcolor?>"<?=$movejs?>> 
    <td height="25"> 
      <?=$datatbname?><b><?=$tr[$i]?></b>
    </td>
    <td height="25"><div align="center"> 
        <?=$tbrownum?>
      </div></td>
    <td height="25"><div align="center">[<a href="../ecmsmod.php?tid=<?=$tid?>&tbname=<?=$tbname?>&enews=DefDataTable&datatb=<?=$tr[$i]?><?=$ecms_hashur['href'].$efh1?>" onclick="return confirm('確認要將這個表設為當前存放表?');">設為當前存放表</a>]<?=$dostr?></div></td>
  </tr>
  <?php
	}
	?>
</table>
<script>
document.adddatatableform.datatb.value="<?=$maxtb+1?>";
</script>
<br>
</body>
</html>
<?php
db_close();
$empire=null;
?>
