function loadTables()
{
$filename = dirname(__FILE__) . "/../database_desc.txt";
if (!file_exists($filename)) {
echo "<!DOCTYPE html><body>\n\t\t\t<div style='display:inline-block; color:red; font-weight:bold;'>Error:</div>\n\t\t\tfile\n\t\t\t<div style='display:inline-block; font-family:monospace;'>{$filename}</div>\n\t\t\tdescribing the tables does not exist!<br />\n\t\t\tPlease retrieve this file and try again.\n\t\t\t</body>";
return;
}
$a_file_tables = unserialize(file_get_contents($filename));
$a_file_tables = $a_file_tables["Tables"];
$a_tables = getTables();
updateTables($a_tables, $a_file_tables);
echo "success";
}
try {
$stmt = $dbh->prepare($sql);
$stmt->bindParam(':timestp', $tmsp);
$stmt->bindParam(':interaction', $interaction);
$stmt->bindParam(':page', $page);
$stmt->bindParam(':set', $set);
$stmt->execute();
} catch (PDOException $e) {
echo 'SQL Query: ', $sql;
echo 'Error: ' . $e->getMessage();
}
}
if (isset($post_data["pages"])) {
makeTables($dbh, $post_data);
} else {
updateTables($dbh, $post_data);
}
}
}
//e-mail data if e-mail is set up
if (isset($smtphost, $smtpport, $euser, $epass, $toaddr, $subject, $message)) {
//variables of great social and political import
$pid = $post_data["pid"];
//check for directory and create if not exists
if (!file_exists("../participants")) {
mkdir("../participants", 0777, true);
}
//check for file and create with column headers if not exists
$filepath = "../participants/p" . $pid . "_interactions.csv";
if (!file_exists($filepath)) {
$cols = "timestp, interaction, page, set\n";
if ($errors) {
showForm($errors);
} else {
updateTables($version);
$user = new User($name);
$user->setName($fullname);
$user->setPassword($password);
$user->setAccess('admin');
$user->setEmail($email);
$user->save();
}
} else {
showForm('');
}
} else {
updateTables($version);
}
function showForm($errors)
{
$name = $_POST['name'];
$fullname = $_POST['fullname'];
$password = $_POST['password'];
$password2 = $_POST['password2'];
$email = $_POST['email'];
print "<!DOCTYPE>\n<html>\n <head>\n <title>Initialize Database</title>\n </head>\n <body>\n <h1>Initialize Database</h1>\n <p>This page is displayed because the database for the Vacation Blog\n has not yet been initialized. Please provide the information on this\n page to initialize the database.</p>\n";
if ($errors) {
print "<ul style='color: red'>{$errors}</ul>\n";
}
print "\n <form method='POST' action='CreateTables.php'>\n <p>\n <label for='name'>User Name:</label>\n <input type='text' name='name' id='name' value='{$name}' size='32' maxlength='32'/>\n </p>\n\n <p>\n <label for='fullname'>Full Name:</label>\n <input type='text' name='fullname' id='fullname' value='{$fullname}' size='32' maxlength='64'/>\n </p>\n\n <p>\n <label for='password'>Password:</label>\n <input type='password' name='password' id='password' value='{$password}' size='32' maxlength='32'/>\n </p>\n\n <p>\n <label for='password2'>Repeat Password:</label>\n <input type='password' name='password2' id='password2' value='{$password2}' size='32' maxlength='32'/>\n </p>\n\n <p>\n <label for='email'>Email:</label>\n <input type='text' name='email' id='email' value='{$email}' size='32' maxlength='64'/>\n </p>\n\n <p>\n <input type='submit' name='do' id='do' value='Initialize Database'/>\n <input type='submit' name='cancel' id='cancel' value='Cancel'/>\n </form>\n </body>\n</html>\n";
print "<!DOCTYPE html\n";
print "<html>\n";
