if (isset($_POST['submitform']) && $all_ok == true) {
if (isset($_POST['r']) && $_POST['r'] >= -3 && $_POST['r'] <= 3 && $mark_as_rated == true) {
//mark_as_rated to avoid possbility to set rate to 0,1,2 then change to Comment log type and actually give score (what could take place before!)!
// oceniono skrzynkę
$is_scored_query = XDb::xMultiVariableQueryValue("SELECT count(*) FROM scores WHERE user_id= :1 AND cache_id= :2 ", -1, $usr['userid'], $cache_id);
if ($is_scored_query == 0 && $usr['userid'] != $record['user_id']) {
XDb::xSql("UPDATE caches SET score=(score*votes+" . XDb::xEscape(floatval($_POST['r'])) . ")/(votes+1), votes=votes+1\n WHERE cache_id= ?", $cache_id);
XDb::xSql("INSERT INTO scores (user_id, cache_id, score) VALUES( ? , ? , ? )", $usr['userid'], $cache_id, $_POST['r']);
}
} else {
// nie wybrano opcji oceny
}
$log_date = date('Y-m-d H:i:s', mktime($log_date_hour, $log_date_min, 0, $log_date_month, $log_date_day, $log_date_year));
$log_uuid = create_uuid();
$logDateTime = new DateTime($log_date);
if (!compareTime($logDateTime, "PT1H")) {
//if logging time is older then now-one_hour
$_SESSION["lastLogDateTime"] = $logDateTime;
//we store the time
$_SESSION["lastLogSendTime"] = new DateTime("now");
} else {
unset($_SESSION["lastLogSendTime"]);
//next time we log with "now" datetime
unset($_SESSION["lastLogDateTime"]);
}
//add logentry to db
if ($log_type < 0) {
// nie wybrano typu logu
} elseif (!($log_type == 3 && $log_text == "")) {
if ($log_type == 1) {
/* GeoKretyApi: call method logging selected Geokrets (by Łza) */
<?php
session_start();
$email = $_SESSION['user'];
$scheduleName = $_POST['name'];
$startTime = $_POST['startTime'];
$endTime = $_POST['endTime'];
if (compareTime($startTime, $endTime) !== "Invalid Time") {
require_once "config.php";
$db = loadDatabase();
$userId = getUserId($db, $email);
insertIntoSchedule($db, $userId, $scheduleName, $startTime, $endTime);
} else {
echo "Invalid Time";
}
function compareTime($startTime, $endTime)
{
$startTime = explode(':', $startTime);
$endTime = explode(':', $endTime);
if ($endTime[0] >= $startTime[0] || $endTime[0] >= $startTime[0] && $endTime[1] > $startTime[1]) {
return true;
} else {
return "Invalid Time";
}
}
function getUserId($db, $email)
{
$userIdQuery = "SELECT id FROM user WHERE email=?";
$userIdQuery = $db->prepare($userIdQuery);
$userIdQuery->execute(array($email));
return $userIdQuery->fetchColumn();
