Location: PHPKode > projects > as_admintool > asadmintool/as_admintool_backup.php
<?
/**
* @package as_admintool
* @desc as_admintool_backup.php - "backup SQL data" plugin for as_admintool.php
* @version 1.000.000
* @author Alexander Selifonov <as-hide@address.com>
* @copyright Alexander Selifonov 2007
* @link http://as-works.narod.ru/en/php/
* modified 03.03.2007 (dd.mm.yyyy)
*/

require_once('as_dbutils.php'); // DB access wrapper class

define('ASADM_BACKUP','backup'); // ID type for this module
define('ASADM_BACKUP_TPR',6); // Tables Per Row in backup form
define('ASADM_BACKUP_GZIP',1); // Pack backup file to gzip

# $as_admt_bckpfolder - default folder for backup files, with ending '/'
if(!isset($as_admt_bckpfolder)) $as_admt_bckpfolder = 'backup/';

# $as_admt_bcktemplate - prefix for backup filenames, date parts allowed: YYYY,MM,DD,HH,MI
$as_admt_bcktemplate = 'backup-YYYY-MM-DD-HHMI'; 

# mandatory string - registering plugin
CAsAdminTool::RegisterPlugin(ASADM_BACKUP,'AsAdm_Backup_Form','AsAdm_Backup_Exec');

// interface localization strings
if(empty($as_iface['startbackup'])) $as_iface['startbackup'] ='Start backup';
if(empty($as_iface['backupresult'])) $as_iface['backupresult'] ='Backup result';
if(empty($as_iface['alltables'])) $as_iface['alltables'] ='All tables';

# AsAdm_Backup_Form - function for drawing "backing up" client interface page
# first par $pginfo is array: [0] - pageid, [1] - parent layer width, [2] - parent layer height
function AsAdm_Backup_Form($pginfo='',$usrparam='', $usrparam2='', $usrparam3=false) {
  global $as_dbengine, $as_iface, $as_cssclass;
  $pageid=isset($pginfo[0])? $pginfo[0]: 0;
  $lwidth = isset($pginfo[1])? $pginfo[1]: 800;
  $lheight = isset($pginfo[2])? $pginfo[2]: 600;

  $self = $_SERVER['PHP_SELF'];
  static $bckp_js_drawn = false;
  if(!$bckp_js_drawn) { #<3> draw only once !!!
    $bckp_js_drawn = true;
     ?>
<script language='javascript'>

var ajax_backupbusy = false;
function AsAdm_Runbackup(pageid) {
  if (ajax_backupbusy) return;
  fm = document.getElementById('asadt_backup_'+pageid);
  var xmlreq = NewXMLHttpRequest();
  if(!xmlreq) return false;
  ajax_backupbusy = true;
  xmlreq.onreadystatechange= function() { //<3>
    if (xmlreq.readyState == 4) { //<3A>
//      alert(xmlreq.responseText); //debug
      var spl = xmlreq.responseText.split("{|}");
      delete xmlreq;
      ajax_backupbusy = false;
      if(spl.length < 2) {
        document.getElementById('backupresult_'+pageid).innerHTML ='wrong response from server: '+spl[0];
      }
      else {
        document.getElementById('backupresult_'+pageid).innerHTML = spl[1];
      } //<4>
    } //<3A>
  } //<3>

  xmlreq.open('POST','<?=$self?>',true);
  xmlreq.setRequestHeader("Content-Type", postcont);
  params = 'adm_action_type=backup&pageid=' + pageid + '&'+ComputeParamString('asadt_backup_'+pageid);
  xmlreq.send(params);
  document.getElementById('backupresult_'+pageid).innerHTML = '<?=$as_iface['msg_waiting']?>';
  return false;
}  

</script>
<?  } #<3> 

  $bckpfolder = false;
  $tblistfile = '';
  $tables = array();
  $dbname = is_string($usrparam3) ? $usrparam3:'';
  if(is_string($usrparam2)) $bckpfolder = $usrparam2;
  if(is_array($usrparam)) {
     $tables = isset($usrparam['tablelist']) ? $usrparam['tablelist'] : $usrparam;
  }
  else $tblistfile=$usrparam;
  
  if($tblistfile!=='' && is_file($tblistfile)) { # read tables list from file
    $tlst = file($tblistfile);
    for($kkk=0; $kkk<count($tlst); $kkk++) { $tstk = trim($tlst[$kkk]); if(strlen($tstk)) $tables[] = $tstk; }
    unset($tlst);
  }
  elseif($usrparam==='') { # '' - all tables in DB
    if(!empty($dbname)) $as_dbengine->select_db($dbname);
    $tables = $as_dbengine->GetTableList();
  }

?>
<table id='asadt_tbl_<?=$pageid?>'>
<tr><form name='asadt_backup_<?=$pageid?>'>
<?
  if( $bckpfolder !==false ) echo "<input type='hidden' name='backupfolder' value='$bckpfolder'>"; 
  if(!empty($dbname)) echo "<input type=hidden name='_dbname_' value='$dbname'>";
  $r_width = $lwidth - 20;
  $r_height = $lheight-245;
?>
<tr><td colspan=4>
<div id='bckp_checkbox_<?=$pageid?>' class='<?=$as_cssclass['resultarea']?>' style='overflow:auto; height:160px; width:<?=$r_width?>px;'>
<table border=0 cellspacing=0 cellpadding=0><tr><td colspan=4>
<input type='checkbox' name='_all_tables_' value='1'> <?=$as_iface['alltables']?></td></tr>
 <?
  for($kkp=1; $kkp<count($tables); $kkp++) { 
    if($kkp>ASADM_BACKUP_TPR && ($kkp % (ASADM_BACKUP_TPR) ==1)) echo "</tr><tr>"; // 4 parameter per line 
    echo "<td nowrap><input type='checkbox' name='tb_{$tables[$kkp]}' value='1'> {$tables[$kkp]}</td>\n";
  }
?>   
</table></div>
</tr></table>
<br><div align=center>
<table width='98%'>
<tr><td><button class='button' name='runsql' onClick='AsAdm_Runbackup(<?=$pageid?>)'><?=$as_iface['startbackup']?></button> 
</td></tr></form>
<tr><td><?=$as_iface['backupresult']?></td></tr>
<tr><td><div id='backupresult_<?=$pageid?>' class='<?=$as_cssclass['resultarea']?>' style='overflow:auto; height:<?=$r_height?>px; width:<?=$r_width?>px;'>&nbsp;</div></td></tr>
</tr>
</table>
</div>
<?
}

// # AsAdm_Backup_Exec - function that executes backup and returns result string
function AsAdm_Backup_Exec($parms) {
  global $as_dbengine, $as_iface, $as_admt_bckpfolder,$as_admt_bcktemplate;
  $pageid = isset($parms['pageid'])? $parms['pageid'] : '1';
  $ret = "$pageid{|}";
  $b_alltables = empty($parms['_all_tables_'])? false:true;
  $bklist = array();
  $savefolder = $as_admt_bckpfolder;
  if(isset($parms['backupfolder'])) $savefolder = $parms['backupfolder'];

  $dbname = isset($parms['_dbname_']) ? $parms['_dbname_']: '';
  if(strlen($dbname)) $as_dbengine->select_db($dbname);

  $s_from = array('YYYY','YY','MM','DD','HH','MI','SS');
  $s_to = array(date('Y'), date('y'),date('m'),date('d'),date('H'),date('i'),date('s'));
  $savename = $savefolder . str_replace($s_from, $s_to,$as_admt_bcktemplate).'.xml';
  foreach($parms as $key=>$val) {
    $tbname = (substr($key,0,3)==='tb_')? substr($key,3) : '';
    if($tbname !='' && (!empty($val) || $b_alltables)) $bklist[] = $tbname;
  }

  // $bklist has all tablenames to backup, let's start...
  $as_dbengine->SaveDDLMode(true); // include Create table operators
  $as_dbengine->SetVerbose(true);
  $as_dbengine->CreateContents(true); // create table list in the beginning of backup file
  ob_start(); //  intercept all html output!
  $result = $as_dbengine->BckpBackupTables($bklist,$savename,ASADM_BACKUP_GZIP);
  $ret = "$pageid{|}".ob_get_contents()."<br>Backup to {$as_dbengine->outputfile}, saved tables: <b>$result</b><br>";
  ob_end_clean();
  return $ret;
}

?>
Return current item: as_admintool