mkdir("_local/dump");
}
@closedir($ax);
$dumpfile = fopen("_local/dump/" . $dumpdbname, "w");
if ($dumpfile == false) {
die("cannot open file {$dumpdbname}");
}
$xx = "#::Dbscript {$verchar} :: {$verwritefile} :: http://dj.chg.su/dbscript/ Mysql Dump File \n\r";
fwrite($dumpfile, $xx);
}
if ($GENALT) {
$insertone = "INSERT INTO {$sourcetable} " . $field . " VALUES ";
}
for ($c = 0; $myrow = dbs_fetch_row($result, $dbtype); $c++) {
if (!$GENALT) {
$insertone = gencmdlog($sourcetable, $myrow, $mycols, "");
//echo "faak - $insertone=gencmdlog ($sourcetable,$myrow,$mycols,); ";
if (!$noprintsave) {
echo $insertone . "<br>";
}
// в другие части этой копии скрипта внедрить сохранение в файл (!!!) CFG OPT FUTURE TODO:
if ($noprintsave) {
fwrite($dumpfile, $insertone);
}
}
if ($GENALT) {
$insertone .= gennohdlog($sourcetable, $myrow, $mycols, $field) . ",";
//echo "faak - $insertone=gennohdlog ($sourcetable,$myrow,$mycols,); ";
}
// потом улучшить чтобы не делала излишний код
}
@($connect = dbs_connect($prdbdata[$tbl][6], $sd[14], $sd[17], $dbtype));
@dbs_selectdb($prdbdata[$tbl][9], $connect, $dbtype);
$data = readdescripters();
// получение данных заголовка массив mycol кол-во mycols
if ($data == -1) {
exit;
}
$cmd = "SELECT * FROM `" . $prdbdata[$tbl][9] . "`.`" . $prdbdata[$tbl][5] . "` WHERE " . $mycol[$md2column] . "= '" . $vID . "'";
echo $cmd;
//if (($virtualid>0)AND ($vID2!=="")) { $cmd=$cmd." AND ".$mycol[$virtualid]."= '".$vID2."'";};
$result = dbs_query($cmd, $connect, $dbtype);
for ($c = 0; $myrow = dbs_fetch_row($result, $dbtype); $c++) {
if (!$test) {
$test = $myrow[0];
}
$undodata .= gencmdlog("`" . $prdbdata[$tbl][9] . "`.`" . $prdbdata[$tbl][5] . "`", $myrow, $mycols) . " ";
}
// тут надо бы undo
$a = $test;
$cmd = "DELETE FROM `" . $prdbdata[$tbl][9] . "`.`" . $prdbdata[$tbl][5] . "` WHERE " . $mycol[$md2column] . "='" . $vID . "'";
//if (($virtualid>0)AND ($vID2!=="")) { $cmd=$cmd." AND ".$mycol[$virtualid]."= '".$vID2."'";};
dbs_query($cmd, $connect, $dbtype);
if (!$pr[8]) {
echo "DEBUG Получен код {$a}<br>";
}
if ($a == true) {
echo $vID . cmsg("WF_DELOK") . "!<br>";
} else {
$errt = cmsg("WF_DELFAIL");
$ermsg = cmsg("WF_NOQUE") . "<br>";
}
