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"])) {