login != $admin1 && $data->login != $admin2) { exit; } if( $_SERVER['REQUEST_METHOD'] == 'POST' ) { //update layout if( mysql_query("UPDATE instellingen SET emailadmin='".mysql_escape_string($_POST['emailadmin'])."' WHERE id=1") ) { echo "Uw Backup Email Adres Is Gewijzigd."; } else { echo "Foutje: ". mysql_error(); } }//einde verwerking # $select = mysql_query("SELECT * FROM `instellingen`"); # $page = mysql_fetch_object($select); ?>
"; for($i=0;$i"; } if($cfg['dbs'] == 1) { if($cfg['bes'] == 1) { $querys[] = "-- \n"; $querys[] = "-- Create Database"; $querys[] = "CREATE DATABASE ".$cfg['db'].";\n"; $querys[] = "USE ".$cfg['db'].";\n"; $querys[] = "-- Rest \n\n"; } echo "-- \n"; echo "-- create Database"; echo "CREATE DATABASE ".$cfg['db'].";\n"; echo "USE ".$cfg['db'].";\n"; echo "-- rest \n\n"; } // verkrijg tables $get_tab = mysql_query("SHOW TABLES FROM ".$cfg['db']); // while tab while($x = mysql_fetch_array($get_tab)) { // structuur vars $s = "-- \n"; $s .= "-- Structuur van tabel: ".$x[0]."\n"; $s .= "-- \n\n"; $s .= "CREATE TABLE ".$x[0]." ( \n"; $k = ''; // keys // get tabelen $get_v = mysql_query("SHOW COLUMNS FROM ".$x[0]." FROM ".$cfg['db']); // EIGENWIJS DING while($iks = mysql_fetch_assoc($get_v)) { $temp = $iks['Field']; // zet in array voor de data if(!isset($velden[$x[0]][$temp])) { $velden[$x[0]][$temp] = $temp; } // table maken, stuctuur if($cfg['str'] == 1) { if(!isset($arr[$x[0]][$ike['Field']])) { // in array proppen $arr[$x[0]][$iks['Field']] = $iks['Field']; // null berekenen $null = (!empty($iks['Null']) && $iks['Null'] == "YES") ? "NULL" : "NOT NULL"; // bij de string proppen $s .= $iks['Field']." ".$iks['Type']." ".$null." ".$iks['Extra'].",\n"; // als key niet leeg is if(!empty($iks['Key'])) { $k .= $key[$iks['Key']]." (".$iks['Field']."),\n"; } } } } // structuur weergeven $var = $s.substr($k,0,-2)."\n);"; if($cfg['view'] <= 1 && $cfg['str'] == 1) { echo ' '.$var.''; } // structuur in bestand if($cfg['str'] == 1) { $querys[] = "\n"; $querys[] = $var; $querys[] = "\n"; } // data $data = mysql_query("SELECT * FROM ".$x[0]); // zet alla data in array's while($z = mysql_fetch_array($data)) { // velden en data $imkeys = ""; // keys str $imdata = ""; // data str foreach($velden[$x[0]] as $val) { // zet data in een str $imkeys .= $val.","; $imdata .= "'".$z[$val]."',"; } // query maken $q = "INSERT INTO ".$x[0]." (".substr($imkeys,0,-1).") VALUES (".substr($imdata,0,-1).");\n"; // weergeven if($cfg['view'] <= 1 && $cfg['data'] == 1) { echo $q.'
'; } // query in bestand if($cfg['data'] == 1) { $querys[] = $q; } // dellen unset($q); } // data } // grote while, tables // bestand afhandeling if($cfg['bes']==1) { $dat = ''; // openen $fp = fopen($cfg['db'].'.sql','w'); // geen bestand aanmaken if(!$fp) { $err[] = ''; } // inladen in var foreach($querys as $content) { $dat .= $content; } // schrijven $write = fwrite($fp,$dat); // als schrijven is mislukt if(!$write) { $err[] = ''; } // sluiten fclose($fp); } // error afhandeling if(count($err) == 0) { echo '
'; } else { if($cfg['view'] == 0 || $cfg['view'] == 2) { echo '
'; foreach($err as $val) { echo $val .'
'; } } } /* * Einde backupper */ ?>