function getSystemSettings($guid, $connection2)
{
//System settings from gibbonSetting
try {
$data = array();
$sql = "SELECT * FROM gibbonSetting WHERE scope='System'";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
$_SESSION[$guid]["systemSettingsSet"] = FALSE;
}
while ($row = $result->fetch()) {
$name = $row["name"];
$_SESSION[$guid][$name] = $row["value"];
}
//Language settings from gibboni18n
try {
$data = array();
$sql = "SELECT * FROM gibboni18n WHERE systemDefault='Y'";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
$_SESSION[$guid]["systemSettingsSet"] = FALSE;
}
if ($result->rowCount() == 1) {
$row = $result->fetch();
setLanguageSession($guid, $row);
}
$_SESSION[$guid]["systemSettingsSet"] = TRUE;
}
function getSystemSettings($guid, $connection2)
{
//System settings from gibbonSetting
try {
$data = array();
$sql = "SELECT * FROM gibbonSetting WHERE scope='System'";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
$_SESSION[$guid]["systemSettingsSet"] = FALSE;
}
while ($row = $result->fetch()) {
$name = $row["name"];
$_SESSION[$guid][$name] = $row["value"];
}
//Get names and emails for administrator, dba, admissions
//System Administrator
try {
$data = array("gibbonPersonID" => $_SESSION[$guid]["organisationAdministrator"]);
$sql = "SELECT surname, preferredName, email FROM gibbonPerson WHERE gibbonPersonID=:gibbonPersonID";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
}
if ($result->rowCount() == 1) {
$row = $result->fetch();
$_SESSION[$guid]["organisationAdministratorName"] = formatName("", $row["preferredName"], $row["surname"], "Staff", FALSE, TRUE);
$_SESSION[$guid]["organisationAdministratorEmail"] = $row["email"];
}
//DBA
try {
$data = array("gibbonPersonID" => $_SESSION[$guid]["organisationDBA"]);
$sql = "SELECT surname, preferredName, email FROM gibbonPerson WHERE gibbonPersonID=:gibbonPersonID";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
}
if ($result->rowCount() == 1) {
$row = $result->fetch();
$_SESSION[$guid]["organisationDBAName"] = formatName("", $row["preferredName"], $row["surname"], "Staff", FALSE, TRUE);
$_SESSION[$guid]["organisationDBAEmail"] = $row["email"];
}
//Admissions
try {
$data = array("gibbonPersonID" => $_SESSION[$guid]["organisationAdmissions"]);
$sql = "SELECT surname, preferredName, email FROM gibbonPerson WHERE gibbonPersonID=:gibbonPersonID";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
}
if ($result->rowCount() == 1) {
$row = $result->fetch();
$_SESSION[$guid]["organisationAdmissionsName"] = formatName("", $row["preferredName"], $row["surname"], "Staff", FALSE, TRUE);
$_SESSION[$guid]["organisationAdmissionsEmail"] = $row["email"];
}
//Language settings from gibboni18n
try {
$data = array();
$sql = "SELECT * FROM gibboni18n WHERE systemDefault='Y'";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
$_SESSION[$guid]["systemSettingsSet"] = FALSE;
}
if ($result->rowCount() == 1) {
$row = $result->fetch();
setLanguageSession($guid, $row);
}
$_SESSION[$guid]["systemSettingsSet"] = TRUE;
}
$_SESSION[$guid]["gibboni18nIDPersonal"] = $row["gibboni18nIDPersonal"];
$_SESSION[$guid]["googleAPIRefreshToken"] = $row["googleAPIRefreshToken"];
$_SESSION[$guid]['receiveNotificationEmails'] = $row["receiveNotificationEmails"];
$_SESSION[$guid]['gibbonHouseID'] = $row["gibbonHouseID"];
//If user has personal language set, load it to session variable.
if (!is_null($_SESSION[$guid]["gibboni18nIDPersonal"])) {
try {
$dataLanguage = array("gibboni18nID" => $_SESSION[$guid]["gibboni18nIDPersonal"]);
$sqlLanguage = "SELECT * FROM gibboni18n WHERE active='Y' AND gibboni18nID=:gibboni18nID";
$resultLanguage = $connection2->prepare($sqlLanguage);
$resultLanguage->execute($dataLanguage);
} catch (PDOException $e) {
}
if ($resultLanguage->rowCount() == 1) {
$rowLanguage = $resultLanguage->fetch();
setLanguageSession($guid, $rowLanguage);
}
}
try {
$data = array("lastIPAddress" => $_SERVER["REMOTE_ADDR"], "lastTimestamp" => date("Y-m-d H:i:s"), "failCount" => 0, "username" => $username);
$sql = "UPDATE gibbonPerson SET lastIPAddress=:lastIPAddress, lastTimestamp=:lastTimestamp, failCount=:failCount WHERE username=:username";
$result = $connection2->prepare($sql);
$result->execute($data);
} catch (PDOException $e) {
}
//Set Goolge API refresh token where appropriate, and update user
if ($refreshToken != "") {
$_SESSION[$guid]["googleAPIRefreshToken"] = $refreshToken;
try {
$data = array("googleAPIRefreshToken" => $_SESSION[$guid]["googleAPIRefreshToken"], "username" => $username);
$sql = "UPDATE gibbonPerson SET googleAPIRefreshToken=:googleAPIRefreshToken WHERE username=:username";
