require_once "time.php";
require_once "getters.php";
$db = loadDatabase();
$email = $_SESSION['user'];
$eventName = $_POST['eventName'];
$description = $_POST['description'];
$scheduleName = $_POST['scheduleName'];
$eventStartTime = $_POST['eventStartTime'];
$eventEndTime = $_POST['eventEndTime'];
$userId = getUserId($db, $scheduleName, $email);
$scheduleId = getScheduleId($db, $scheduleName, $userId);
$startTime = getStartTime($db, $scheduleName, $scheduleId);
$endTime = getEndTime($db, $scheduleName, $scheduleId);
$placeEvent = schedule($db, $scheduleId, $eventStartTime, $eventStartTime, $startTime, $endTime);
if ($placeEvent) {
addToDatabase($db, $eventName, $description, $eventStartTime, $eventEndTime, $scheduleId);
}
function schedule($db, $scheduleId, $eventStartTime, $eventEndTime, $startTime, $endTime)
{
$query = "SELECT startTime, endTime FROM scheduleEvent se JOIN event e WHERE scheduleId=:id AND eventId = e.id";
$query = $db->prepare($query);
$query->execute(array(':id' => $scheduleId));
$prevScheduledEnd;
$isFull = false;
foreach ($query->fetchAll() as $event) {
if (isset($prevScheduledEnd) && greaterThanOrEqualToTime($eventStartTime, $prevScheduledEnd) && greaterThanOrEqualToTime($event['startTime'], $eventEndTime)) {
return true;
}
$prevScheduledEnd = $event['endTime'];
$isFull = true;
}
session_start();
require_once "config.php";
require_once "time.php";
require_once "getters.php";
$db = loadDatabase();
$email = $_SESSION['user'];
$eventName = $_POST['eventName'];
$description = $_POST['description'];
$scheduleName = $_POST['scheduleName'];
$timeToSchedule = $_POST['time'];
$userId = getUserId($db, $scheduleName, $email);
$scheduleId = getScheduleId($db, $scheduleName, $userId);
$startTime = getStartTime($db, $scheduleName, $scheduleId);
$endTime = getEndTime($db, $scheduleName, $scheduleId);
$whenToPlaceEvent = schedule($db, $scheduleId, $timeToSchedule, $startTime, $endTime);
addToDatabase($db, $eventName, $description, $whenToPlaceEvent, $scheduleId);
function schedule($db, $scheduleId, $timeToSchedule, $startTime, $endTime)
{
$query = "SELECT startTime, endTime FROM scheduleEvent se JOIN event e WHERE scheduleId=:id AND eventId = e.id" . " ORDER BY startTime";
$query = $db->prepare($query);
$query->execute(array(':id' => $scheduleId));
$eventEndTime = addTime($startTime, $timeToSchedule);
$eventStartTime = $startTime;
foreach ($query->fetchAll() as $event) {
if (greaterThanOrEqualToTime($event['startTime'], $eventEndTime)) {
break;
} else {
$eventStartTime = $event['endTime'];
$eventEndTime = addTime($event['endTime'], $timeToSchedule);
}
}
if (!checkOsuLogin($score[1], $_POST["pass"])) {
displayError('pass');
}
if (isUserBanned($playerID)) {
displayError('ban');
}
//set failed or not
//pass: 2
//quit: 1
//fail: 0
$completed = 2;
if (isset($_POST['x'])) {
//user didnt finish map
$completed = $_POST['x'];
}
addToDatabase($score, $playerID, $completed);
//store replay file
storeReplay();
echo 'ok';
function decryptText($input)
{
global $IV, $key;
$aes = new AES($input, $key, 256);
$aes->setIV(base64_decode($IV));
$aes->setMode(AES::M_CBC);
return $aes->decrypt();
}
function displayError($message)
{
die('error: ' . $message);
}
echo "Return Code: " . $_FILES["resource"]["error"] . "<br />";
} else {
//rename the file/image using random nmber
$location = '../uploads/resources/';
move_uploaded_file($rtmp_name, $location . $rname);
set_time_limit(500000);
$rand = randomString(10);
if (renameResources($location, $rname, $extension, $rand)) {
$new_name = $rand . "." . $extension;
}
}
} else {
echo "<p class='error' id='errormsg1'>Invalid file</p>";
}
}
addToDatabase($new_name, $rsize, $rtype, $resourceName, $rtype_usr, $rdesc, $extension, $rprio);
header('location:../htm/upload_rep.html');
//echo $resourceName. " ". $new_name;
function addToDatabase($rname, $rsize, $rtype, $rname_usr, $rtype_usr, $rdesc, $extension, $rprio)
{
$auth = new Authenticate();
$con = new Connection();
$link = $con->getConnection();
$query = "INSERT INTO `resources`(`ID`, `name`,`rNameUsr`,`rsize`, `rtype`, `format`, `doc_by`,`user_r_type`,`rDescription`,`rprio`, `when`, `approved`) VALUES (NULL,?,?,?,?,?,?,?,?,?,?,?)";
//$query = "INSERT INTO `categories`(`cat_id`,`cat_name`,`cat_description`,`cat_by`) VALUES (NULL,?,?,?)";
$stmt = $link->prepare($query);
$stmt->execute(array($rname, $rname_usr, $rsize, $rtype, $extension, $auth->getFullName($_SESSION['user_id']), $rtype_usr, $rdesc, $rprio, date("Y-m-d H:i:m", time()), 0));
$stmt = null;
return TRUE;
}
function renameResources($location, $name, $extension, $rand)
<?php
error_reporting(E_ALL);
ob_start();
session_start();
ini_set('display_errors', 'On');
$mysqli = new mysqli("oniddb.cws.oregonstate.edu", "hahnl-db", "3C15z4js2nneWpks", "hahnl-db");
if (!$mysqli || $mysqli->connect_errno) {
echo "Error connecting to MySQLi Session:(" . $mysqli->connect_errno . "): " . $mysqli->connect_error;
}
#main.php functions:
if (isset($_POST["add"])) {
addToDatabase();
}
if (isset($_POST["favorite"])) {
favoriteRecipe();
}
if (isset($_POST["unfav"])) {
unfavoriteRecipe();
}
if (isset($_POST["remove"])) {
removeRecipe();
}
#mealtypes.php functions:
if (isset($_POST["addMealType"])) {
addMealType();
}
if (isset($_POST["editMealType"])) {
editMealType();
}
if (isset($_POST["removeMealType"])) {
