Cannot open file ($backup)"; include ("../templates/header.tpl"); include ("../templates/admin_menu.tpl"); include ("../templates/delete.tpl"); include ("../templates/footer.tpl"); } else { fwrite ($fh, $header); $tables = array('admin','alias','domain','domain_admins','log','mailbox','vacation'); for ($i = 0 ; $i < sizeof ($tables) ; ++$i) { $result = db_query ("SHOW CREATE TABLE $tables[$i]"); if ($result['rows'] > 0) { while ($row = mysql_fetch_array ($result['result'])) { fwrite ($fh, "$row[1]\n\n"); } } } for ($i = 0 ; $i < sizeof ($tables) ; ++$i) { $result = db_query ("SELECT * FROM $tables[$i]"); if ($result['rows'] > 0) { while ($row = mysql_fetch_assoc ($result['result'])) { foreach ($row as $key=>$val) { $fields[] = $key; $values[] = $val; } fwrite ($fh, "INSERT INTO ". $tables[$i] . " (". implode (',',$fields) . ") VALUES ('" . implode ('\',\'',$values) . "')\n"); $fields = ""; $values = ""; } } } } header ("Content-Type: application/octet-stream"); header ("Content-Disposition: attachment; filename=\"$filename\""); header ("Content-Transfer-Encoding: binary"); header ("Content-Length: " . filesize("$backup")); header ("Content-Description: Postfix Admin"); $download_backup = fopen ("$backup", "r"); fpassthru ($download_backup); } ?>