www.gusucode.com > Destoon B2B仿淘宝电子商务网站 UTF8 v6.0源码程序 > destoon/admin/template/database.tpl.php
<?php defined('DT_ADMIN') or exit('Access Denied'); include tpl('header'); show_menu($menus); ?> <form method="post" action="?" id="dform"> <input type="hidden" name="file" value="<?php echo $file;?>"/> <input type="hidden" name="backup" value="1"/> <div class="tt">DESTOON系统表[共<?php echo $dtotalsize;?>M,<?php echo count($dtables);?>个表]</div> <table cellpadding="2" cellspacing="1" class="tb"> <tr> <th width="25"><input type="checkbox" onclick="checkall(this.form);"/></th> <th>表 名</th> <th width="120">表注释</th> <th width="300" colspan="2">大小(M)</th> <th width="100">记录数</th> <th width="120">操 作</th> </tr> <?php foreach($dtables as $k=>$v) {?> <tr align="center" onmouseover="this.className='on';" onmouseout="this.className='';"> <td> <input type="checkbox" name="tables[]" value="<?php echo $v['name'];?>" checked/> <input type="hidden" name="sizes[<?php echo $v['name'];?>]" value="<?php echo $v['tsize'];?>"/> </td> <td align="left"> <?php echo $v['name'];?></td> <td><a href="?file=<?php echo $file;?>&action=comment&table=<?php echo $v['name'];?>¬e=<?php echo urlencode($v['note']);?>" title="点击修改表注释"><?php echo $v['note'] ? $v['note'] : '--';?></a></td> <td width="200"><script type="text/javascript">perc(<?php echo $v['tsize'];?>,<?php echo $dtotalsize;?>,'150px');</script></td> <td width="100" title="数据:<?php echo $v['size'];?> 索引:<?php echo $v['index'];?> 碎片:<?php echo $v['chip'];?>"><?php echo $v['tsize'];?></td> <td><?php echo $v['rows'];?></td> <td><a href="?file=<?php echo $file;?>&action=repair&table=<?php echo $v['name'];?>">修复</a> | <a href="?file=<?php echo $file;?>&action=optimize&table=<?php echo $v['name'];?>">优化</a> | <a href="###" onclick="Dict('<?php echo $v['name'];?>','<?php echo urlencode($v['note']);?>');">字典</a></td> </tr> <?php }?> </table> <?php if($tables) {?> <div class="tt">其他系统表[共<?php echo $totalsize;?>M,<?php echo count($tables);?>个表]</div> <table cellpadding="2" cellspacing="1" class="tb"> <tr> <th width="25">-</th> <th>表 名</th> <th width="120">表注释</th> <th width="300" colspan="2">大小(M)</th> <th width="100">记录数</th> <th width="120">操 作</th> </tr> <?php foreach($tables as $k=>$v) {?> <tr align="center" onmouseover="this.className='on';" onmouseout="this.className='';"> <td> <input type="checkbox" name="tables[]" value="<?php echo $v['name'];?>"/> <input type="hidden" name="sizes[<?php echo $v['name'];?>]" value="<?php echo $v['tsize'];?>"/> </td> <td align="left"> <?php echo $v['name'];?></td> <td><a href="?file=<?php echo $file;?>&action=comment&table=<?php echo $v['name'];?>¬e=<?php echo urlencode($v['note']);?>" title="点击修改表注释"><?php echo $v['note'] ? $v['note'] : '--';?></a></td> <td width="200"><script type="text/javascript">perc(<?php echo $v['tsize'];?>,<?php echo $totalsize;?>,'150px');</script></td> <td width="100" title="数据:<?php echo $v['size'];?> 索引:<?php echo $v['index'];?> 碎片:<?php echo $v['chip'];?>"><?php echo $v['tsize'];?></td> <td><?php echo $v['rows'];?></td> <td><a href="?file=<?php echo $file;?>&action=repair&table=<?php echo $v['name'];?>">修复</a> | <a href="?file=<?php echo $file;?>&action=optimize&table=<?php echo $v['name'];?>">优化</a> | <a href="###" onclick="Dict('<?php echo $v['name'];?>','<?php echo urlencode($v['note']);?>');">字典</a></td> </tr> <?php }?> </table> <?php } ?> <div class="tt">备份选中表</div> <table cellpadding="2" cellspacing="1" class="tb"> <tr> <td width="120"> 分卷文件大小</td> <td> <span class="f_r"> <a href="javascript:" onclick="checkall(Dd('dform'), 1);" class="t">反选</a> <a href="javascript:" onclick="checkall(Dd('dform'), 2);" class="t">全选</a> <a href="javascript:" onclick="checkall(Dd('dform'), 3);" class="t">全不选</a> </span> <input type="text" name="sizelimit" value="2048" size="5"/> K</td> </tr> <tr> <td> 建表语句格式</td> <td> <input type="radio" name="sqlcompat" value="" checked="checked"/> 默认 <input type="radio" name="sqlcompat" value="MYSQL40"/> MySQL 3.23/4.0.x <input type="radio" name="sqlcompat" value="MYSQL41"/> MySQL 4.1.x/5.x </td> </tr> <tr> <td> 强制字符集</td> <td> <input type="radio" name="sqlcharset" value="" checked/> 默认 <input type="radio" name="sqlcharset" value="utf8"/> UTF-8 <input type="radio" name="sqlcharset" value="gbk"/> GBK <input type="radio" name="sqlcharset" value="latin1"/> LATIN1</td> </tr> </table> <div class="btns"> <input type="submit" name="submit" value="开始备份" class="btn"/> <input type="submit" value="重建注释" class="btn" onclick="if(confirm('确定要重建表注释吗?')){this.form.action='?file=<?php echo $file;?>&action=comments';}else{return false;}"/> <input type="submit" value="删除表" class="btn" onclick="if(confirm('警告!确定要删除中表吗?此操作将不可恢复\n\n为了系统安全,系统仅删除非Destoon系统表')){this.form.action='?file=<?php echo $file;?>&action=drop';}else{return false;}"/> </div> </form> <br/> <script type="text/javascript"> function Dict(t, n) { Dwidget('?file=tag&action=dict&table='+t+'¬e='+n, '数据字典'); } </script> <script type="text/javascript">Menuon(0);</script> <?php include tpl('footer');?>