";
$rs=$conn->Execute($query);
if($rs ){
$body .= _SYSTEM_QUERY_AFF.': '.$conn->Affected_Rows().' - ';
$body .= _SYSTEM_QUERY_ROWS.': '.$rs->RecordCount().' - ';
$body .= _SYSTEM_QUERY_FIELDS.': '.$rs->FieldCount();
$body .= '
';
if ($rs && $rs->RecordCount()>0) {
$rows = $rs->GetArray();
$body.= '';
$body .= "\n";
$k_arr=$rows[0];
foreach($k_arr as $var=>$val)
{
if(ereg("[a-zA-Z]+",$var,$array))$body.='| '.$var." | \n";
}
$body .= "
\n";
foreach($rows as $row)
{
$body .="\n";
foreach($row as $var=>$val)
{
if(ereg("[a-zA-Z]+",$var,$array))$body .= '| '.$val." | \n";
}
$body .= "
\n";
}
$body .= '
';
}
$body .="
";
}else
{
$body .= "
".$conn->ErrorMsg();
}
return $body;
}
function database_page($query='')
{
global $conn,$sql_batch;
$query=dbdecode($query);
$gui=new admin_interface();
$gui->add("form","adminform");
$gui->add("com_header",_SYSTEM_QUERY);
$gui->add("tab_head");
$gui->add("tab_simple","",_SYSTEM_QUERY);
$gui->add("form_textarea","query",_SYSTEM_QUERY_FIELD,"$query","5");
$button_arr = array(array('name'=>_SYSTEM_QUERY_EXC, 'onclick'=>'javascript:document.adminform.submit()'),
array('name'=>_SYSTEM_QUERY_CLEAR, 'onclick'=>'javascript:document.adminform.query.value=\'\';') );
$gui->add("form_buttons","","",$button_arr);
$gui->add("tab_end");
if($query != '')
{
$query_arr = split_sql($query);
$body='';
for($i=0;$i<=(count($query_arr)-1);$i++)
{
if(trim($query_arr[$i]) != '')$body.=record_html($query_arr[$i],$i);
}
$gui->add("bar");
$gui->add("tab_head");
$gui->add("tab_simple","",_SYSTEM_QUERY_RESULT);
$gui->add("html","","","| $body |
");
$gui->add("tab_end");
}
$gui->add("tab_tail");
$gui->add("end_form");
$gui->generate();
}
function manage_db()
{
global $lm_absolute_path;
$gui=new admin_interface();
$gui->add("form","adminform");
$gui->add("com_header",_SYSTEM_BACKUP_HEAD);
$table_head = array ( array('title'=>'#' , 'val'=>'path' , 'len'=>'1%','align'=>'center') ,
array('title'=>'checkbox' , 'val'=>'path' , 'len'=>'1%','align'=>'center') ,
array('title'=>_CMN_NAME,'val'=>'id','len'=>'70%','info'=>_CMN_DOWNLOAD,'ilink'=>'data/backups/ivar1','ivar1'=>'id') ,
array('title'=>_CMN_CDATE,'val'=>'created','len'=>'15%','date'=>'1','align'=>'center'),
array('title'=>_CMN_SIZE,'val'=>'size','len'=>'15%','align'=>'center') ,
);
$backup_dir=$lm_absolute_path."data/backups/";
if(!is_dir($backup_dir))mkdir($backup_dir,0777);
$table_data=read_dir($backup_dir,"file",true);
$gui->add("data_table_arr","maintable",$table_head,$table_data);
$gui->add("end_form");
$gui->generate();
}
function info_page()
{
$gui=new admin_interface();
$gui->add("form","adminform");
$gui->add("bar");
$gui->add("com_header",_SYSTEM_SYSTEM_INFO);
$gui->add("tab_head");
$gui->add("tab_simple","",_SYSTEM_SYSTEM_INFO);
ob_start();
phpinfo(INFO_GENERAL | INFO_CONFIGURATION | INFO_MODULES);
$phpinfo = ob_get_contents();
ob_end_clean();
preg_match_all('#]*>(.*) #siU', $phpinfo, $output);
$output = preg_replace('#