.
*/
include("./include/include.php");
if( $_SERVER['REQUEST_METHOD']=="GET" ) {
admin_header();
}else {
admin_header(true, true);
}
if( !in_array("export", $_SESSION['sess_functions']) ) {
echoln("You are not authorized to see this page.");
}else {
if( $_SERVER['REQUEST_METHOD']=="GET" ) {
echoln("Export
");
echoln("");
admin_footer();
}else {
// Export file
include("./include/g_body.php");
include("./include/g_country.php");
if( strlen($_POST['tablename'])<1 ) $_POST['tablename']="persons";
// Create the table
$data = "-- Export of applications at ".date("d.M.Y H:i:s T")."\n\n";
$data .= "DROP TABLE IF EXISTS `".$_POST['tablename']."`;\n";
$data .= "CREATE TABLE `".$_POST['tablename']."` (";
$data .= "`PersonID` int(11) NOT NULL auto_increment,";
$data .= "`FirstName` varchar(50) NOT NULL default '',";
$data .= "`LastName` varchar(50) NOT NULL default '',";
$data .= "`BodyCode` varchar(3) NOT NULL default '',";
$data .= "`BodyName` varchar(50) NOT NULL default '',";
$data .= "`Sex` enum('male','female') NOT NULL default 'male',";
$data .= "`Nationality` varchar(50) NOT NULL default '',";
$data .= "`Email` varchar(70) NOT NULL default '',";
$data .= "`JoinEventPre1` enum('yes','no') NOT NULL default 'no',";
$data .= "`JoinEventPre2` enum('yes','no') NOT NULL default 'no',";
$data .= "`JoinEventPre3` enum('yes','no') NOT NULL default 'no',";
$data .= "`JoinEventPost1` enum('yes','no') NOT NULL default 'no',";
$data .= "`JoinEventPost2` enum('yes','no') NOT NULL default 'no',";
$data .= "`JoinEventPost3` enum('yes','no') NOT NULL default 'no',";
$data .= "`DateArrival` datetime NOT NULL default '0000-00-00 00:00:00',";
$data .= "`DateDeparture` datetime NOT NULL default '0000-00-00 00:00:00',";
$data .= "`Meals` enum('normal','vegetarian','diet') NOT NULL default 'normal',";
$data .= "`Accepted` enum('yes','pending','confirmed','-','no','cancel','arrived') NOT NULL default '-',";
$data .= "`ParticipantType` enum('-','delegate','envoy','observer','visitor') NOT NULL default '-',";
$data .= "PRIMARY KEY (`PersonID`)";
$data .= ") ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;\n\n";
// Add the data
$query = "SELECT `PersonID`, `FirstName`, `LastName`, `BodyCode`, `Sex`, `Nationality`, `Email`, `JoinEventPre1`, `JoinEventPre2`, `JoinEventPre3`, `JoinEventPost1`, `JoinEventPost2`,
`JoinEventPost3`, `DateArrival`, `DateDeparture`, `Meals`, `Accepted`, `ParticipantType`
FROM `persons` ORDER BY `PersonID`";
if( @mysql_num_rows( $res=doquery($query) )>0 ) {
while( $row = mysql_fetch_array($res) ) {
$data .= "INSERT INTO `".$_POST['tablename']."` VALUES (";
$data .= addslashes($row['PersonID']).", ";
$data .= "'".addslashes($row['FirstName'])."', ";
$data .= "'".addslashes($row['LastName'])."', ";
$data .= "'".addslashes($row['BodyCode'])."', ";
$data .= "'".addslashes($Body[ $row['BodyCode'] ])."', ";
$data .= "'".addslashes($row['Sex'])."', ";
$data .= "'".addslashes($Country[ $row['Nationality'] ])."', ";
$data .= "'".addslashes($row['Email'])."', ";
$data .= "'".addslashes($row['JoinEventPre1'])."', ";
$data .= "'".addslashes($row['JoinEventPre2'])."', ";
$data .= "'".addslashes($row['JoinEventPre3'])."', ";
$data .= "'".addslashes($row['JoinEventPost1'])."', ";
$data .= "'".addslashes($row['JoinEventPost2'])."', ";
$data .= "'".addslashes($row['JoinEventPost3'])."', ";
$data .= "'".addslashes($row['DateArrival'])."', ";
$data .= "'".addslashes($row['DateDeparture'])."', ";
$data .= "'".addslashes($row['Meals'])."', ";
$data .= "'".addslashes($row['Accepted'])."', ";
$data .= "'".addslashes($row['ParticipantType'])."');\n";
}
}else {
$data .= "-- There is no data to export\n";
}
header("Last-Modified: " . gmdate("D, d M Y H:i ") . " GMT");
header('Pragma: no-cache');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header("Content-length: ".strlen($data));
header("Content-disposition: attachment; filename=\"".$_POST['tablename'].".sql\"");
header("Content-type: application/octet-stream");
header("Content-Transfer-Encoding: binary");
header('Pragma: public');
echo $data;
}
}
?>