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); } }