function retrieve_calendar_data($client)
{
$t = filter_input(INPUT_GET, 't', FILTER_SANITIZE_STRING);
$e = filter_input(INPUT_GET, 'e', FILTER_SANITIZE_STRING);
$code = filter_input(INPUT_GET, 'code', FILTER_SANITIZE_URL);
if (isset($t) && isset($e)) {
$_SESSION['token_id'] = $t;
$_SESSION['event_id'] = $e;
sql_check_token();
$auth_url = $client->createAuthUrl();
header('Location: ' . filter_var($auth_url, FILTER_SANITIZE_URL));
} elseif (isset($code)) {
$client->authenticate($code);
//Authenticate client with code
if ($client->isAccessTokenExpired()) {
$auth_url = $client->createAuthUrl();
header('Location: ' . filter_var($auth_url, FILTER_SANITIZE_URL));
}
$_SESSION['access_token'] = $client->getAccessToken();
//Store access token in session
redirect_local(GOOGLE_CALENDAR_ACCESS_PATH);
} else {
redirect_local(ERROR_PATH . "/?e=missing_token");
}
}
session_start();
}
$homedir = "../../";
require_once $homedir . "config/mysqli_connect.php";
$ti = 1;
//these should get their values from a failed attempt at a POST request
$errors = [];
$warnings = [];
$notifications = [];
$scrubbed = array_map("spam_scrubber", $_POST);
if (!(isset($_SESSION['access_token']) && $_SESSION['access_token'])) {
redirect_local(OAUTH2_PATH . '?' . $_SESSION['token_id']);
}
if (!empty($_POST['checkboxvar'])) {
$_SESSION['user_calendar_summaries'] = filter_var_array(explode(",", $scrubbed['checkboxvar']), FILTER_SANITIZE_STRING);
redirect_local(GOOGLE_CALENDAR_ACCESS_PATH);
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<link rel="icon" type="image/png" href="<?php
echo $homedir;
?>
favicon.png" sizes="128x128">
<link rel="stylesheet" type="text/css" href="<?php
echo $homedir . "css/goog.css";
?>
">
break;
case "invalid_event":
$error_message = 'Event was invalid or has been removed.';
break;
case "invalid_email":
$error_message = 'Email found was invalid. This is due to an unknown error. Please try the link again.';
break;
case "missing_token":
$error_message = 'URL does not include access token.';
break;
case "missing_event":
$error_message = 'URL does not include event id.';
break;
case "sql_connection":
$error_message = 'SQL database connection error.';
break;
case "sql_insertion":
$error_message = 'SQL database insertion error, no lines changed.';
break;
case "sql_charset":
$error_message = 'SQL database error: Error loading character set utf8';
break;
default:
$error_message = 'Unknown error, please try again';
break;
}
session_destroy();
session_start();
$_SESSION['calendarsaved'] = array("messagetype" => "errors", "message" => $error_message);
redirect_local("../index.php");
function insert_mysql_info($events_array)
{
$serialized_events = (string) json_encode($events_array);
insert_event_data($serialized_events);
unset_session_variables();
$_SESSION['calendarsaved'] = array("messagetype" => "notifications", "message" => "Success! Your calendar data has been saved. Thank you for using MESA. You may now close the page.");
redirect_local("../index.php");
exit;
}
function connect_sql()
{
$dbc = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
if ($dbc->connect_errno) {
redirect_local(ERROR_PATH . "/?e=sql_connection");
}
if (!mysqli_set_charset($dbc, "utf8")) {
redirect_local(ERROR_PATH . "/?e=sql_charset");
}
return $dbc;
}
