www.gusucode.com > 网猫影视系统NetMao Movie 4.6.6 开源版源码程序 > upload/admin/tpl/database.tpl.php

    <?php
/*
*######################################
* Netmao Movie 4.x - NetMao Movie System
* Copyright (c) 2007-2008 NetMao.cn
* For further information go to http://www.netmao.cn/
* This copyright notice must stay intact for use.
*######################################
*/
if(!defined('IN_NetMao')) exit('Access Denied');
?>
<? if($action == 'database_export') { ?>
<table cellpadding="0" cellspacing="0" border="0" width="100%" height="10">
  <tr>
    <td></td>
  </tr>
</table>
<table cellpadding="2" cellspacing="1" border="0" align=center class="tableBorder">
  <tr> 
    <td class="tablerow">当前操作 &gt; 数据库备份</td>
  </tr>
</table>
<table cellpadding="0" cellspacing="0" border="0" width="100%" height="10">
  <tr>
    <td></td>
  </tr>
</table>
<table cellpadding="2" cellspacing="1" class="tableborder">
  <form name="myform" method="post" action="?action=database_export">
  <input type="hidden" name="setup" value="1">
    <tr> 
      <th colspan="2">数据库备份类型</th>
    </tr>
    <tr> 
      <td width="200" height="25" class="tablerow" > 
        <input class="radio" type="radio" value="netmao" name="type" onclick="showtables.style.display='none'" checked="checked">
        全部数据备份</td>
      <td class="tablerow" >&nbsp; </td>
    </tr>
    <tr> 
      <td height="25" class="tablerow" > 
        <input class="radio" type="radio" value="custom" name="type" onclick="showtables.style.display=''">
        自定义备份</td>
      <td class="tablerow" > 根据需要自行选择需要备份的数据表</td>
    </tr>
<tbody id="showtables" style="display:none">
    <tr> 
        <td height="25" colspan="2" class="tablerow" > N<strong>etMao数据表</strong> 
          <input class="checkbox" type="checkbox" name="chkall" onclick="checkall(this.form, 'customtables')" checked="checked">
          <strong>全选</strong> </td>
    </tr>
    <tr> 
      <td height="25" colspan="2" class="tablerow" >
<table width="100%">
<? if(is_array($tabs)) foreach($tabs as $key=>$tab){ ?>
<? if($key%4==0){ ?> <tr> <? } ?>
<td width="25%"><input class="checkbox" type="checkbox" name="customtables[]" value="<?=$tab?>" checked><?=$tab?></td>
<? if($key%4==3){ ?></tr> <? }} ?>
</table>
      </td>
    </tr>
</tbody>
    <tr> 
      <td width="200" height="25" class="tablerow" >&nbsp;</td>
      <td align="right" class="tablerow" ><input class="checkbox" type="checkbox" value="1" onclick="advanceoption.style.display = advanceoption.style.display == 'none' ? '' : 'none'; this.value = this.value == 1 ? 0 : 1; this.checked = this.value == 1 ? false : true">
        更多选项 </td>
    </tr>
<tbody id="advanceoption" style="display: none;">
      <tr> 
        <th colspan="2">数据库备份选项</th>
      </tr>
      <tr> 
        <td width="25%" height="25" class="tablerow" >NetMao 分卷备份 - 文件长度限制(kb)</td>
        <td class="tablerow" ><input type="text" size="40" name="sizelimit" value="2048"></td>
      </tr>
      <tr> 
        <td height="25" class="tablerow" >使用扩展插入(Extended Insert)方式</td>
        <td class="tablerow" ><input class="radio" type="radio" name="extendins" value="1">
          是 &nbsp; <input class="radio" type="radio" name="extendins" value="0" checked>
          否</td>
      </tr>
      <tr> 
        <td height="25" class="tablerow" >添加字符集限定(SET NAMES)</td>
        <td class="tablerow" ><input class="radio" type="radio" name="addsetnames" value="1">
          是 &nbsp; <input class="radio" type="radio" name="addsetnames" value="0" checked>
          否</td>
      </tr>
      <tr> 
        <td height="25" class="tablerow" >建表语句格式</td>
        <td class="tablerow" ><input class="radio" type="radio" name="sqlcompat" value="" checked>
          是 &nbsp; <input class="radio" type="radio" name="sqlcompat" value="MYSQL40">
          MySQL 3.23/4.0.x &nbsp; <input class="radio" type="radio" name="sqlcompat" value="MYSQL41">
          MySQL 4.1.x/5.x</td>
      </tr>
      <tr> 
        <td height="25" class="tablerow" >强制字符集</td>
        <td class="tablerow" > 
          <?=$sqlcharsets?>
        </td>
      </tr>
      <tr> 
        <td height="25" class="tablerow" >十六进制方式</td>
        <td class="tablerow" ><input class="radio" type="radio" name="usehex" value="1">
          否 &nbsp; <input class="radio" type="radio" name="usehex" value="0" checked>
          否</td>
      </tr>
      <tr> 
        <td height="25" class="tablerow" >备份文件名:</td>
        <td class="tablerow" ><input type="text" size="40" name="filename" value="./mdata/<?=date('ymd').'_'.random(8)?>.sql" onclick="alert('注意: \n\n数据文件保存在服务器的可见目录下，其他人有    \n可能下载得到这些文件，这是不安全的。因此请    \n在使用随机文件名的同时，适时删除备份文件。');"></td>
      </tr>
</tbody>
    <tr> 
      <td colspan="2" bgcolor="#E1E1E1"><input name="exportsubmit" type="submit" value=" 提 交 "></td>
    </tr>
  </form>
</table>
<? }elseif($action == 'database_import'){ ?>
<table cellpadding="0" cellspacing="0" border="0" width="100%" height="10">
  <tr>
    <td></td>
  </tr>
</table>
<table cellpadding="2" cellspacing="1" border="0" align=center class="tableBorder">
  <tr> 
    <td class="tablerow">当前操作 &gt; 数据库恢复</td>
  </tr>
</table>
<table cellpadding="0" cellspacing="0" border="0" width="100%" height="10">
  <tr>
    <td></td>
  </tr>
</table>
<table cellpadding="2" cellspacing="1" class="tableborder">
<form action="?action=database_import" method="post" enctype="multipart/form-data" name="myform">
  <tr>
    <th colspan="2">数据库恢复</th>
  </tr>
    <tr> 
      <td width="200" class="tablerow"> 
        <input class="radio" type="radio" name="from" value="server" checked onclick="this.form.datafile_server.disabled=!this.checked;this.form.datafile.disabled=this.checked">
        从服务器(填写文件名或 URL):</td>
      <td  class="tablerow"><input type="text" size="40" name="datafile_server" value="./mdata/"></td>
    </tr>
    <tr> 
      <td  class="tablerow"> 
        <input class="radio" type="radio" name="from" value="local" onclick="this.form.datafile_server.disabled=this.checked;this.form.datafile.disabled=!this.checked">
        从本地文件:</td>
      <td  class="tablerow"><input type="file" size="29" name="datafile" disabled></td>
    </tr>
    <tr> 
      <td colspan="2" bgcolor="#E1E1E1"><input name="importsubmit" type="submit" value=" 提 交 "></td>
    </tr>
</form>
</table>
<table cellpadding="0" cellspacing="0" border="0" width="100%" height="10">
  <tr> 
    <td></td>
  </tr>
</table>
<table cellpadding="2" cellspacing="1" class="tableborder">
<form action="?action=database_import" method="post" name="myform1">
    <tr> 
      <th colspan="9" class="tablerow">数据备份记录</th>
    </tr>
    <tr> 
      <td width="50" class="tablerow"> 
        <input class="checkbox" type="checkbox" name="chkall" onclick="checkall(this.form)">
        删?</td>
      <td class="tablerow">文件名</td>
      <td class="tablerow">版本</td>
      <td class="tablerow">时间</td>
      <td class="tablerow">类型</td>
      <td class="tablerow">尺寸</td>
      <td class="tablerow">方式</td>
      <td class="tablerow">卷号</td>
      <td class="tablerow">操作</td>
    </tr>
    <?=$exportinfo?>
    <tr> 
      <td colspan="9" bgcolor="#E1E1E1"> 
        <input name="deletesubmit" type="submit" value=" 提 交 ">
      </td>
    </tr>
</form>
</table>
<? }elseif($action == 'database_optimize'){ ?>
<table cellpadding="0" cellspacing="0" border="0" width="100%" height="10">
  <tr>
    <td></td>
  </tr>
</table>
<table cellpadding="2" cellspacing="1" border="0" align=center class="tableBorder">
  <tr> 
    <td class="tablerow">当前操作 &gt; 数据表优化</td>
  </tr>
</table>
<table cellpadding="0" cellspacing="0" border="0" width="100%" height="10">
  <tr>
    <td></td>
  </tr>
</table>
<table cellpadding="2" cellspacing="1" class="tableborder">
<form name="optimize" method="post" action="?action=database_optimize">
<tr>
<th><input class="checkbox" type="checkbox" name="chkall" onclick="checkall(this.form)" checked>优化?</th><th>数据表</th><th>类型</th><th>记录数</th>
<th>数据</th><th>索引</th><th>碎片</th>
</tr>
<? if(is_array($tabs)) foreach($tabs as $tab){ ?>
<tr>
<td class="tablerow"><input class="checkbox" type="checkbox" name="optimizetables[]" value="<?=$tab[Name]?>" <?=$tab[checked]?>></td>
<td class="tablerow"><?=$tab[Name]?></td>
<td class="tablerow"><?=($db->version() > '4.1' ?  $tab[Engine] : $tab[Type])?></td>
<td class="tablerow"><?=$tab[Rows]?></td>
<td class="tablerow"><?=$tab[Data_length]?></td>
<td class="tablerow"><?=$tab[Index_length]?></td>
<td class="tablerow"><?=$tab[Data_free]?></td>
</tr>
<? } ?>
<? if(is_array($optabs)) foreach($optabs as $optab){ ?>
<tr>
<td class="tablerow"><?=$optab[optimized]?></td>
<td class="tablerow"><?=$optab[Name]?></td>
<td class="tablerow"><?=($db->version() > '4.1' ?  $optab[Engine] : $optab[Type])?></td>
<td class="tablerow"><?=$optab[Rows]?></td>
<td class="tablerow"><?=$optab[Data_length]?></td>
<td class="tablerow"><?=$optab[Index_length]?></td>
<td class="tablerow">0</td>
</tr>
<? } ?>
<tr><td colspan="7" class="tablerow">尺寸:<?=sizecount($totalsize)?></td></tr>
<tr><td colspan="7" bgcolor="#E1E1E1"><input class="button" type="submit" <? if($optabs){ echo 'disabled'; } ?> name="optimizesubmit" value=" 提 交 "></td></tr>
</form>
</table>
<? }elseif($action == 'database_runquery'){ ?>
<table cellpadding="0" cellspacing="0" border="0" width="100%" height="10">
  <tr>
    <td></td>
  </tr>
</table>
<table cellpadding="2" cellspacing="1" border="0" align=center class="tableBorder">
  <tr> 
    <td class="tablerow">当前操作 &gt; 数据库升级</td>
  </tr>
</table>
<table cellpadding="0" cellspacing="0" border="0" width="100%" height="10">
  <tr>
    <td></td>
  </tr>
</table>
<table cellpadding="2" cellspacing="1" class="tableborder">
<form name="myform" method="post" action="?action=database_runquery">
  <tr> 
      <th>NetMao 数据库升级 - 请将数据库升级语句粘贴在下面</th>
  </tr>
    <tr> 
      <td height="25" class="tablerow" > 
        <textarea cols="85" rows="10" name="queries"></textarea>
      </td>
    </tr>
    <tr> 
      <td bgcolor="#E1E1E1"> 
        <input name="sqlsubmit" type="submit" value=" 提 交 "></td>
    </tr>
</form>
</table>
<? }elseif($action == 'database_replace'){ ?>
<script type="text/javaScript" src="<?=ROOTDIR?>/inc/js/prototype.js"></script>
<script type="text/javascript">
function getfields(tablename){
    var url ="?action=database_getfields";
    var pars = "tablename="+tablename;
	var cAjax = new Ajax.Request(url, {method: 'get', parameters: pars, onComplete: setfield});
}

function setfield(Request){
	var text = Request.responseText;
    var fileds = text.split(",");
	enterValue(fileds, $('fromfield'));
}

function enterValue(cell,place){
	clearPreValue(place);
	var selectedval = cell[0];
	for(i=0; i<cell.length; i++){
	    isselected = addOption(place, cell[i], cell[i]);
		if(isselected){
			place.options[i].selected = true;
			selectedval = cell[i];
		}
	}
	return selectedval;
}
function addOption(objSelectNow,txt,val){
	var objOption = document.createElement("option");
	objOption.text = txt;
	objOption.value = val;
	objSelectNow.options.add(objOption);
	return true;
}

function clearPreValue(pc){
	while(pc.hasChildNodes())
	pc.removeChild(pc.childNodes[0]);
}
</script>
<table cellpadding="0" cellspacing="0" border="0" width="100%" height="10">
  <tr>
    <td></td>
  </tr>
</table>
<table cellpadding="2" cellspacing="1" border="0" align=center class="tableBorder">
  <tr> 
    <td class="tablerow">当前操作 &gt; 数据替换</td>
  </tr>
</table>
<table cellpadding="0" cellspacing="0" border="0" width="100%" height="10">
  <tr>
    <td></td>
  </tr>
</table>
<form name="myform" method="post" action="?action=database_replace">
  <table cellpadding="2" cellspacing="1" class="tableborder">
    <tr>
      <th colspan=2>数据替换</th>
  </tr>
    <tr> 
      <td width="100" class="tablerow">要替换的字段名</td>
      <td class="tablerow">
数据表<select name="fromtable" onchange="getfields(this.value);"><option value="" selected>请选择数据表</option><?=$tablopt?></select>
&nbsp;&nbsp; 字段名<select name="fromfield"></select>
</td>
  </tr>
    <tr> 
      <td class="tablerow">替换方式</td>
<td class="tablerow">
<input name='type' type='radio' onClick="t1.style.display='block';t2.style.display='block';t3.style.display='none';" value='1' checked  <? if($type==1) echo "checked";?>>
        字符串替换 
        <input name='type' type='radio' value='2' onClick="t1.style.display='none';t2.style.display='none';t3.style.display='block';" <? if($type==2) echo "checked";?>>在字段最前面追加
<input name='type' type='radio' value='3' onClick="t1.style.display='none';t2.style.display='none';t3.style.display='block';" <? if($type==3) echo "checked";?>>在字段最后面追加
</td>
</tr>
    <tr id='t1'> 
      <td class="tablerow">要替换的内容</td>
<td class="tablerow"><textarea name="search" cols="50" rows="3"></textarea></td>
</tr>
    <tr id='t2'> 
      <td class="tablerow">替换为</td>
<td class="tablerow"><textarea name="replace" cols="50" rows="3"></textarea></td>
</tr>
    <tr id='t3' style="display:none"> 
      <td class="tablerow">追加的字符串</td>
<td class="tablerow"><textarea name="addstr" cols="50" rows="3"></textarea></td>
</tr>
    <tr> 
      <td class="tablerow">替换条件</td>
<td class="tablerow"><textarea name="condition" cols="50" rows="3"></textarea></td>
</tr>
    <tr> 
      <td class="tablerow"> </td>
      <td class="tablerow"> 
        <input type="submit" name="rpsubmit" value=" 提 交 "></td>
</tr>
</table>
</form>
<? } ?>