{sub h}
	{if $method=='sql'}
<script language="javascript">
var sql_create_table=function(){
	var sql=$('#sql').val();
	if(sql!=''){
		if(sql.substr(sql.length-1,1)!=';')sql+=';';
		sql+='\n';
	}
	$('#sql').val(sql+'CREATE TABLE `{$config[db_table_pre]}table_name` (\n\t`id` int unsigned not null auto_increment,\n\t`column_name` column_type,\n\tPRIMARY KEY (`id`)\n) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
}
var post_sql=function(sql){
	if (sql != void(0))$('#sql').val(sql);
	$('#form1').submit();
}
var sql_show_tables=function(){
	$('#sql').val('show tables;');
	post_sql();
	
}
var sql_show_databases=function(){
	$('#sql').val('show databases;');
	post_sql();
}
var sql_create_user=function(){
	$('#sql').val('grant all privileges on db_name.{$config[db_table_pre]}table_name to \'username\'@\'localhost\' identified by \'password\'/*{lg creUser admin}*/;');
}
var sql_drop_user=function(){
	$('#sql').val('drop user \'username\'@\'localhost\'/*{lg delUser admin}*/;');
};
$.ajaxSetup({cache:false});
var sqlList = {echo string::json_encode($sqlList1)};
$(function(){
	$('#addSql').click(function(){
		var saveName = $('#saveName').val().replace(/^\s+|\s+$/g, '');
		var sql      = $('#sql').val().replace(/^\s+|\s+$/g, '');
		if (!saveName) {
			alert('{lg plsIptSaveName admin}');
			return;
		}
		if (!sql) {
			alert('{lg plsIptSaveSql admin}');
			return;
		}
		$.ajax({
			type:'post',
			url:'{$weburl2}ajax/sql.php?action=data&operation=save',
			data:'hash='+encodeURI('$sys_hash')+'&name='+encodeURI(saveName)+'&sql='+encodeURI(sql),
			dataType:'json',
			success:function(json){
				if (json.err) alert(json.err);
				else if (json.status) {
					$('#sqlList').append('<option value="'+json.id+'">'+saveName+'</option>');
					sqlList[json.id] = sql;
					alert('{lg addOk admin}');
				} else alert('{lg unknowErr admin}');
			},
			error:function(){
				alert('{lg addErrReTry admin}');
			}
		});
	});
	$('#sqlList').change(function(){
		if ($(this).val() != '') {
			var id = $(this).val();
			var sql = sqlList[id];
			post_sql(sql);
		}
	});
});
</script>
<form method="post" enctype="application/x-www-form-urlencoded" id="form1">
<input type="hidden" name="exesql" value="yes" />
<input type="hidden" name="hash" value="$sys_hash" />
	<table class="tb tb2 fixpadding">
		<tr class="hover">
			<td><textarea name="sql" cols="100" rows="10" id="sql">{eval echo htmlspecialchars($sql);}</textarea></td>
		</tr>
		<tr class="hover">
			<td><input type="submit" name="Submit2" value="{lg run admin}" class="btn" />
					<input type="button" value="{lg creTb admin}" onclick="sql_create_table()" class="btn" />
					<input type="button" value="{lg showAllTb admin}" onclick="sql_show_tables()" class="btn" />
					<input type="button" value="{lg showAllDB admin}" onclick="sql_show_databases()" class="btn" />
					<input type="button" value="{lg creUser admin}" onclick="sql_create_user()" class="btn" />
					<input type="button" value="{lg delUser admin}" onclick="sql_drop_user()" class="btn" />
			</td>
		</tr>
		<tr class="hover">
			<td>
				{lg sqlSaveAs admin}：<input type="text" id="saveName" class="txt" style="width:120px" maxlength="32" /><input type="button" value="{lg add admin}" class="btn" id="addSql" />&nbsp;
				{lg quickSql admin}：<select id="sqlList">
					<option value="">{lg needRunSql admin}</option>
					{loop $sqlList2 $k $v}
					<option value="$k">$v</option>
					{/loop}
				</select>
			</td>
		</tr>
		<tr class="hover">
			<td><div style="width: 620px;border: 1px solid #CCCCCC;overflow-y: scroll;height: 200px;white-space: pre;">$show_result</div></td>
		</tr>
	</table>
</form>
{elseif $method=='import'}
{if !$complate}
<table width="100%" class="tb tb2 fixpadding">
	<tr class="header">
		<th>{lg filename admin}</th>
		<th>{lg filesize admin}</th>
		<th>{lg lstEditTime admin}</th>
		<th></th>
	</tr>
	{loop $sql_file_list $v}
	<tr class="hover">
		<td><a href="$base_url&download={url $v[name]}" title="{lg download admin}">$v[name]</a></td>
		<td>$v[file_size]Byte</td>
		<td>$v[filemtime]</td>
		<td><!--[<a href="$nowurl&import={url $v[name]}&encoding=gbk">{lg import admin}GBK</a>]-->[<a href="$nowurl&import={url $v[name]}&encoding=utf-8">{lg import admin}<!--UTF-8--></a>][<a href="$nowurl&del={url $v[name]}">{lg del admin}</a>]</td>
	</tr>
	{/loop}
	<tr>
		<td colspan="4"><input type="button" value="{lg localUpImport admin}" class="btn" onclick="location.href='$base_url&method=import2'" /></td>
	</tr>
</table>
{else}
<div>{lg importOk admin}：$import</div>
{/if}
{elseif $method == 'import2'}
	{adminForm
		upload
		preg
		{lg backupFile admin}|file  |code,<input type="file" name="file" id="file" RegStr="/\.(sql)$/i" Message="{lg backupFileTip admin}" class="txt" style="width:240px" />
	}
{elseif $method=='export'}
{if !$complate}
<style type="text/css">
.tables{width:600px;clear:both}
.tables li{width:200px;float:left;height:25px;line-height:25px;}
</style>
<form method="post" enctype="application/x-www-form-urlencoded">
<table class="tb tb2 fixpadding">
	<tr class="hover">
		<td align="right">{lg backupName admin}：</td>
		<td align="left">./<input type="text" name="save_name" value="{echo date('Y-m-d H_i_s', $timestamp)}" class="txt" style="width:200px" />.sql</td>
	</tr>
	<tr class="hover">
		<td valign="top" align="right">{lg needBkTb admin}：</td>
		<td align="left"><input type="checkbox" id="back_all" checked onclick="check_all(this,'backup_tables[]')" class="checkbox" /><label for="bach_all">{lg all admin}</label>
			<ul class="tables">
				{loop $tables $v}
				<li><input type="checkbox" value="$v" name="backup_tables[]" id="$v" checked class="checkbox" /><label for="$v">$v</label></li>
				{/loop}
			</ul>
		</td>
	</tr>
	<tr>
		<td></td>
		<td align="left"><input type="submit" value="{lg submit admin}" class="btn" /></td>
	</tr>
</table>
</form>
{else}
<div>{lg backupOk admin}：./data/sql/backup/$complate.sql</div>
{/if}
{/if}
{sub f}