/**
* Output the database table...
*
* Ideally, you would have a view in your application where the tracking
* information would be output. The possibilites here are endless, however,
* I will just quickly output the data from the database.
*/
function outputHTML()
{
//Output the HTML table...
echo '<table class="u-full-width">';
echo '<caption><h2>SQLite Database Output</h2></caption>';
echo '<thead>';
echo '<th>Email</th>';
echo '<th>Subject</th>';
echo '<th>Opened</th>';
echo '</thead>';
echo '<tbody>';
$db = new PDO('sqlite:../data/_main.db');
$result = $db->query('SELECT email, subject, opened FROM email_log');
foreach ($result as $row) {
echo '<tr>';
echo '<td>' . $row['email'] . '</td>';
echo '<td>' . $row['subject'] . '</td>';
echo '<td>' . $row['opened'] . '</td>';
echo '</tr>';
}
echo '</tbody>';
echo '</table>';
//Reset the database
resetDatabase($db);
}
include_once 'htmlDefault.php';
include_once 'scoreFunctions.php';
$action = $_GET["action"];
if (!isset($action)) {
print $html_string;
exit;
}
define("ACTION_FAILED", -1);
define("UNKNOWN_ACTION", -2);
$connection = mysql_connect("localhost", "cookbook", "cookbook") or die(mysql_error());
mysql_select_db('cookbook_highscores');
switch ($action) {
case 'get':
getPlayer();
break;
case 'set':
setPlayer();
break;
case 'xml':
toXML();
break;
case 'html':
toHTML();
break;
case 'reset':
resetDatabase();
break;
default:
print UNKNOWN_ACTION;
}
mysql_close($connection);
if (isset($_POST['demoKey']) && $_POST['demoKey'] == $DEMOPUSHKEY) {
$target_dir = dirname(dirname(__FILE__)) . "/temp/";
$target_file = $target_dir . basename($_FILES["fileupload"]["name"]);
if (move_uploaded_file($_FILES["fileupload"]["tmp_name"], $target_file)) {
$branchName = $_POST['branch'];
$commitHash = $_POST['commitHash'];
echo "The file " . basename($_FILES["fileupload"]["name"]) . " has been uploaded.\r\n";
echo "Commit Hash: " . $commitHash;
$delPath = dirname(dirname(__FILE__)) . "/" . $branchName;
delTree($delPath);
$p = new ZipArchive();
$p->open($target_file);
$p->extractTo($target_dir);
//extract the code\
$p->close();
rename($target_dir . "/churchcrm", $delPath);
// move the repository from the temp folder to the root
$srcComposer = json_decode(file_get_contents($delPath . "/composer.json"));
$srcComposer->commitHash = $commitHash;
file_put_contents($delPath . "/composer.json", json_encode($srcComposer));
$version = $srcComposer->version;
copy(dirname(__FILE__) . "/configFiles/" . $branchName . "/Include/Config.php", $delPath . "/Include/Config.php");
//copy any config files necessary
resetDatabase('localhost', "gdawoud_church_crm_" . $branchName, $DBUSERNAME, $DBPASSWORD, $delPath . "/mysql/install/Install.sql", $version);
} else {
echo "Sorry, there was an error uploading your file.";
}
} else {
echo "Incorrect or missing build password";
}
exit;
// SET CONTENTS
if (isset($_POST['action'])) {
// Create Database
if ($_POST['action'] == 'createDatabase' && isset($_POST['document']) && ($document = $section->getDocumentById($_POST['document']))) {
$dbh = createDatabase($document->getId());
parseGEXF($document->getFile(), $dbh);
}
// Delete Database
if ($_POST['action'] == 'deleteDatabase' && isset($_POST['delete']) && $_POST['delete'] == "y" && isset($_POST['document']) && ($document = $section->getDocumentById($_POST['document']))) {
if (!deleteDatabase($document->getId())) {
echo "Deletion failed";
}
}
// Reset Database (formerly 'update')
if ($_POST['action'] == 'updateDatabase' && isset($_POST['document']) && ($document = $section->getDocumentById($_POST['document']))) {
$dbh = resetDatabase($document->getId());
parseGEXF($document->getFile(), $dbh);
}
// Change Attribute Viz Type
if ($_POST['action'] == 'changeViz' && isset($_POST['document']) && ($document = $section->getDocumentById($_POST['document']))) {
if (isset($_POST['attribute']) && isset($_POST['viz'])) {
try {
$dbh = new PDO("sqlite:../data/exploredbs/" . $document->getId());
$g = new gRaph($dbh);
if ($attribute = $g->getAttributeById($_POST['attribute'])) {
$attribute->setViz($_POST['viz']);
if (isset($_POST['rewritedattributename'])) {
$attribute->setRewrittenName($_POST['rewritedattributename']);
}
}
} catch (PDOException $e) {
