<?php
require_once './inc/func_main.php';
mysql_query("SET NAMES 'utf8'");
$xsoubor = "backup" . date("-d-m-Y") . ".sql";
$fsoubor = "files/backups/" . $xsoubor;
$sql_bck = "INSERT INTO " . DB_PREFIX . "backups VALUES('','" . Time() . "','" . $xsoubor . "')";
echo $sql_bck;
MySql_Query($sql_bck);
function zalohuj($db, $soubor = "")
{
global $dbusr;
function keys($prefix, $array)
{
if (empty($array)) {
$pocet = 0;
} else {
$pocet = count($array);
}
if (!isset($radky)) {
$radky = '';
}
if ($pocet == 0) {
return;
}
for ($i = 0; $i < $pocet; $i++) {
$radky .= "`" . $array[$i] . "`" . ($i != $pocet - 1 ? "," : "");
}
return ",\n" . $prefix . "(" . $radky . ")";
}
$sql = mysql_query("SHOW table status FROM " . $db);
function backupDB()
{
global $dbusr;
function zalohuj($db, $soubor = "")
{
global $dbusr;
function keys($prefix, $array)
{
if (empty($array)) {
$pocet = 0;
} else {
$pocet = count($array);
}
if (!isset($radky)) {
$radky = '';
}
if ($pocet == 0) {
return;
}
for ($i = 0; $i < $pocet; $i++) {
$radky .= "`" . $array[$i] . "`" . ($i != $pocet - 1 ? "," : "");
}
return ",\n" . $prefix . "(" . $radky . ")";
}
$sql = mysql_query("SHOW table status FROM " . $db);
while ($data = mysql_fetch_row($sql)) {
if (!isset($text)) {
$text = '';
}
$text .= (empty($text) ? "" : "\n\n") . "--\n-- Struktura tabulky " . $data[0] . "\n--\n\n\n";
$text .= "CREATE TABLE `" . $data[0] . "`(\n";
$sqll = mysql_query("SHOW columns FROM " . $data[0]);
$e = true;
while ($dataa = mysql_fetch_row($sqll)) {
if ($e) {
$e = false;
} else {
$text .= ",\n";
}
$null = $dataa[2] == "NO" ? "NOT NULL" : "NULL";
$default = !empty($dataa[4]) ? " DEFAULT '" . $dataa[4] . "'" : "";
if ($default == " DEFAULT 'CURRENT_TIMESTAMP'") {
$default = " DEFAULT CURRENT_TIMESTAMP";
}
if ($dataa[3] == "PRI") {
$PRI[] = $dataa[0];
}
if ($dataa[3] == "UNI") {
$UNI[] = $dataa[0];
}
if ($dataa[3] == "MUL") {
$MUL[] = $dataa[0];
}
$extra = !empty($dataa[5]) ? " " . $dataa[5] : "";
$text .= "`{$dataa['0']}` {$dataa['1']} {$null}{$default}{$extra}";
}
if (!isset($UNI)) {
$UNI = '';
}
if (!isset($PRI)) {
$PRI = '';
}
if (!isset($MUL)) {
$MUL = '';
}
$primary = keys("PRIMARY KEY", $PRI);
$unique = keys("UNIQUE KEY", $UNI);
$mul = keys("INDEX", $MUL);
$text .= $primary . $unique . $mul . "\n) ENGINE=" . $data[1] . " COLLATE=" . $data[14] . ";\n\n";
unset($PRI, $UNI, $MUL);
$text .= "--\n-- Data tabulky " . $data[0] . "\n--\n\n";
$query = mysql_query("SELECT * FROM " . $data[0] . "");
while ($fetch = mysql_fetch_row($query)) {
$pocet_sloupcu = count($fetch);
for ($i = 0; $i < $pocet_sloupcu; $i++) {
@($values .= "'" . mysql_escape_string($fetch[$i]) . "'" . ($i < $pocet_sloupcu - 1 ? "," : ""));
}
$text .= "\nINSERT INTO `" . $data[0] . "` VALUES(" . $values . ");";
unset($values);
}
}
if (!empty($soubor)) {
$fp = @fopen($soubor, "w+");
$fw = @fwrite($fp, $text);
@fclose($fp);
}
return $text;
}
$sql_check = "SELECT time FROM " . DB_PREFIX . "backups ORDER BY time DESC LIMIT 1";
$fetch_check = MySQL_Fetch_Assoc(MySql_Query($sql_check));
$last_backup = $fetch_check['time'];
if (round($last_backup, -5) < round(time(), -5)) {
mysql_query("SET NAMES 'utf8'");
$xsoubor = "backup" . time() . ".sql";
$fsoubor = "files/backups/" . $xsoubor;
$sql_bck = "INSERT INTO " . DB_PREFIX . "backups VALUES('','" . Time() . "','" . $xsoubor . "')";
MySql_Query($sql_bck);
zalohuj($dbusr, $fsoubor);
}
}