set_filenames([
'show' => './tpl/dump_select_tables.tpl',
]);
$button_name = 'dump_tbl';
//Info aus der Datenbank lesen
mod_mysqli_connect();
$res = mysqli_query($config['dbconnection'], 'SHOW TABLE STATUS FROM `'.$databases['db_actual'].'`');
$numrows = mysqli_num_rows($res);
$tbl_zeile = '';
for ($i = 0; $i < $numrows; ++$i) {
$row = mysqli_fetch_array($res, MYSQLI_ASSOC);
//v($row);
// Get nr of records -> need to do it this way because of incorrect returns when using InnoDBs
$sql_2 = 'SELECT count(*) as `count_records` FROM `'.$databases['db_actual'].'`.`'.$row['Name'].'`';
$res2 = mysqli_query($config['dbconnection'], $sql_2);
if (false === $res2) {
$read_error = mysqli_error($config['dbconnection']);
$row['Rows'] = ''.$lang['L_ERROR'].': '.$read_error.'';
} else {
$row2 = mysqli_fetch_array($res2);
$row['Rows'] = $row2['count_records'];
}
$klasse = ($i % 2) ? 1 : '';
$table_size = $row['Data_length'] + $row['Index_length'];
$table_type = $row['Engine'];
if ('VIEW' == substr($row['Comment'], 0, 4)) {
$table_type = 'View';
$table_size = '-';
}
$tpl->assign_block_vars('ROW', [
'CLASS' => 'dbrow'.$klasse,
'ID' => $i,
'NR' => $i + 1,
'TABLENAME' => $row['Name'],
'TABLETYPE' => $table_type,
'RECORDS' => 'View' == $table_type ? ''.$row['Rows'].'' : ''.$row['Rows'].'',
'SIZE' => is_int($table_size) ? byte_output($table_size) : $table_size,
'LAST_UPDATE' => $row['Update_time'],
]);
}
} else {
$tpl->set_filenames([
'show' => './tpl/restore_select_tables.tpl',
]);
//Restore - Header aus Backupfile lesen
$button_name = 'restore_tbl';
$gz = (substr($filename, -3)) == '.gz' ? 1 : 0;
if ($gz) {
$fp = gzopen($fpath.$filename, 'r');
$statusline = gzgets($fp, 40960);
$offset = gztell($fp);
} else {
$fp = fopen($fpath.$filename, 'r');
$statusline = fgets($fp, 5000);
$offset = ftell($fp);
}
//Header auslesen
$sline = ReadStatusline($statusline);
$anzahl_tabellen = $sline['tables'];
$anzahl_eintraege = $sline['records'];
$tbl_zeile = '';
$part = ('' == $sline['part']) ? 0 : substr($sline['part'], 3);
if (-1 == $anzahl_eintraege) {
// not a backup of MySQLDumper
$tpl->assign_block_vars('NO_MOD_BACKUP', []);
} else {
$tabledata = [];
$i = 0;
//Tabellenfinos lesen
gzseek($fp, $offset);
$eof = false;
while (!$eof) {
$line = $gz ? gzgets($fp, 40960) : fgets($fp, 40960);
if ('-- TABLE|' == substr($line, 0, 9)) {
$d = explode('|', $line);
$tabledata[$i]['name'] = $d[1];
$tabledata[$i]['records'] = $d[2];
$tabledata[$i]['size'] = $d[3];
$tabledata[$i]['update'] = $d[4];
$tabledata[$i]['engine'] = isset($d[5]) ? $d[5] : '';
++$i;
}
if ('-- EOF' == substr($line, 0, 6)) {
$eof = true;
}
if ('create' == substr(strtolower($line), 0, 6)) {
$eof = true;
}
}
for ($i = 0; $i < sizeof($tabledata); ++$i) {
$klasse = ($i % 2) ? 1 : '';
$tpl->assign_block_vars('ROW', [
'CLASS' => 'dbrow'.$klasse,
'ID' => $i,
'NR' => $i + 1,
'TABLENAME' => $tabledata[$i]['name'],
'RECORDS' => $tabledata[$i]['records'],
'SIZE' => byte_output($tabledata[$i]['size']),
'LAST_UPDATE' => $tabledata[$i]['update'],
'TABLETYPE' => $tabledata[$i]['engine'],
]);
}
}
if ($gz) {
gzclose($fp);
} else {
fclose($fp);
}
}
if (!isset($dk)) {
$dk = '';
}
$confirm_restore = $lang['L_FM_ALERTRESTORE1'].' `'.$databases['db_actual'].'` '.$lang['L_FM_ALERTRESTORE2'].' '.$filename.' '.$lang['L_FM_ALERTRESTORE3'];
$tpl->assign_vars([
'PAGETITLE' => $tblr.' -'.$lang['L_TABLESELECTION'],
'L_NAME' => $lang['L_NAME'],
'L_DATABASE' => $lang['L_DB'],
'DATABASE' => $databases['db_actual'],
'L_LAST_UPDATE' => $lang['L_LASTBUFROM'],
'SEL_DUMP_ENCODING' => $sel_dump_encoding,
'FILENAME' => $filename,
'DUMP_COMMENT' => $dk,
'BUTTON_NAME' => $button_name,
'L_START_BACKUP' => $lang['L_STARTDUMP'],
'L_START_RESTORE' => $lang['L_FM_RESTORE'],
'L_ROWS' => $lang['L_INFO_RECORDS'],
'L_SIZE' => $lang['L_INFO_SIZE'],
'L_TABLE_TYPE' => $lang['L_TABLE_TYPE'],
'L_SELECT_ALL' => $lang['L_SELECTALL'],
'L_DESELECT_ALL' => $lang['L_DESELECTALL'],
'L_RESTORE' => $lang['L_RESTORE'],
'L_NO_MOD_BACKUP' => $lang['L_NOT_SUPPORTED'],
'L_CONFIRM_RESTORE' => $confirm_restore,
]);
$tpl->pparse('show');
ob_end_flush();
exit();