function login_verify($dataInbound)
{
// Something something cookie, something something database
function return_failed($error)
{
echo '<script type="text/javascript"> window.alert("' . $error . '"); </script>';
echo '<script type="text/javascript"> window.location="/"; </script>';
die;
}
if (!function_exists('configure_active_database')) {
require '../api/settings.php';
require '../api/api.fnc.php';
$socket = ConnectToDatabase(configure_active_database()) or die("<strong>Error:</strong> couldn't find database! Try again in a few moments.");
} else {
$socket = ConnectToDatabase(configure_active_database()) or die("<strong>Error:</strong> couldn't find database! Try again in a few moments.");
}
$uvEmailAddress = $dataInbound['emailAddress'];
$uvFirstName = $dataInbound['firstName'];
$uvLoginStamp = $dataInbound['loginStamped'];
if (empty($uvLoginStamp)) {
// Well that was easy...
return_failed("No Stamp");
} else {
$return = array();
$emailAddress = $socket->real_escape_string(filter_var($uvEmailAddress, FILTER_VALIDATE_EMAIL));
$firstName = $socket->real_escape_string(filter_var($uvFirstName, FILTER_SANITIZE_FULL_SPECIAL_CHARS, FILTER_FLAG_NO_ENCODE_QUOTES));
$safeQuery = "SELECT * FROM `users` WHERE `emailaddress`='{$emailAddress}' AND `firstname`='{$firstName}';";
$result = MakeDatabaseQuery($safeQuery, $socket) or return_failed("Query Failed");
$isRows = $result->num_rows;
if ($isRows == 0) {
// Nothing came back in the query.
return_failed("No Rows");
} else {
// There was a result...
$returnKeys = MakeDatabaseFetch($result, $socket);
if ($returnKeys[emailaddress] == $emailAddress) {
if ($returnKeys[firstname] == $firstName) {
$return["email_address"] = $returnKeys['emailaddress'];
$return["first_name"] = $returnKeys['firstname'];
//$return["user_password"] = $returnKeys['password'];
}
}
}
}
return $return;
}
<?php
require "authentication_header.fnc.php";
require "api.fnc.php";
require "settings.php";
$db = configure_active_database();
$socket = ConnectToDatabase($db);
$query = MakeDatabaseQuery("SELECT * FROM `registrations`;", $socket);
$return = array();
foreach ($query as $key) {
$when = $key[when];
$where = $key[where];
$for = $key['for'];
$description = $key[description];
if ($key[priority] == 1) {
$priority = "Low";
}
if ($key[priority] == 2) {
$priority = "Medium";
}
if ($key[priority] == 3) {
$priority = "High";
}
if ($key[priority] == 4) {
$priority = "Urgent (LMA)";
}
$topush = array("id" => $key['id'], "when" => $when, "where" => $where, "for" => $for, "description" => $description, "priority" => $priority, "who" => $key['who']);
array_push($return, $topush);
}
echo json_encode($return, JSON_PRETTY_PRINT);
<?php
//error_reporting(0);
//error_reporting(E_ALL ^ E_NOTICE);
error_reporting(E_ALL);
require 'includes/functions.php';
if (!file_exists('config.php')) {
redirect('admin/install.php');
exit;
}
require 'config.php';
require 'includes/template.class.php';
ConnectToDatabase();
$tpl = new Template();
// Get config from database
$config = GetConfigItems();
$tpldir = 'templates/' . $config['template_dir'];
$tpl->set('s_template_dir', $tpldir);
$tpl->set('s_site_title', $config['site_title']);
// *****************************************************************************
// Set up the filename
$filename = "image.tpl";
if (isset($_GET['page'])) {
if (file_exists($tpldir . $_GET['page'] . ".tpl")) {
$filename = $_GET['page'] . ".tpl";
} else {
// Error finding page. Produce error page and stop processing.
$page_error = '404 Not Found';
$tpl->set('s_page_error', $page_error);
if (!headers_sent()) {
header("HTTP/1.1 404 Not Found");
<?php
// Teacher Registration for WruD
// © 2014 Department for Education and Child Development
// @Requries - uses the settings from the API for centralisation
require '../api/settings.php';
require '../api/api.fnc.php';
// @Headers
date_default_timezone_set("Australia/Adelaide");
// @Setters
$db = configure_active_database();
$socket = ConnectToDatabase($db) or die("<strong>Error:</strong> couldn't find database! Try again in a few moments.");
// @Getters
$cleanData = array();
$cleanData['emailaddress'] = $socket->real_escape_string(filter_var($_POST['emailaddress'], FILTER_VALIDATE_EMAIL));
$cleanData['password'] = $socket->real_escape_string(filter_var($_POST['password'], FILTER_SANITIZE_FULL_SPECIAL_CHARS, FILTER_FLAG_NO_ENCODE_QUOTES));
// @Inref Functions
function return_failed()
{
header('Location: /login.php?ssl=true&failed=true');
}
function fix_time($timeString)
{
try {
// COOKIE TIME FIXER!!!!!
$correctTimeStamp = date("l, d-M-Y H:i:s T", $timeString);
} catch (Exception $e) {
return_failed();
}
return $correctTimeStamp;
}
<?php
include "functions.php";
ConnectToDatabase(DBName());
function update($sem)
{
foreach (glob("./{$sem}/*.csv") as $filename) {
$dept = substr($filename, 0, -4);
if ($sem == "fall") {
$dept = substr($dept, 7);
} else {
if ($sem == "winter") {
$dept = substr($dept, 9);
}
}
echo $dept . "\n";
if (($handle = fopen($filename, "r")) !== FALSE) {
Query("DROP TABLE IF EXISTS {$dept}");
Query("CREATE TABLE IF NOT EXISTS {$dept} (NAME text, SECTION text, \n\t\t\t\tDAY text, START time, FINISH time, LOCATION text)");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$q = "INSERT INTO {$dept} VALUES (";
foreach ($data as $key => $value) {
$q .= "'{$value}',";
}
$q = substr($q, 0, -1);
$q .= ")";
Query($q);
}
fclose($handle);
}
}
