public static function logUser($userId, $userFirstName, $userLastName, $userPicSrc)
{
$newStaticBdd = new BDD();
if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
$ip = $_SERVER['HTTP_CLIENT_IP'];
} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
$ip = $_SERVER['REMOTE_ADDR'];
}
$userId = $newStaticBdd->real_escape_string(htmlspecialchars($userId));
$userPicSrc = $newStaticBdd->real_escape_string(htmlspecialchars($userPicSrc));
$userLink = $newStaticBdd->real_escape_string(htmlspecialchars(preg_replace("/[\\s\\W]+/", '', strtolower($userFirstName)) . "." . preg_replace("/[\\s\\W]+/", '', strtolower($userLastName))));
$userFirstName = $newStaticBdd->real_escape_string(htmlspecialchars($userFirstName));
$userLastName = $newStaticBdd->real_escape_string(htmlspecialchars($userLastName));
$userInfos = $newStaticBdd->select("fb_id, userlink, fb_firstname, fb_lastname, fb_picture, time_update", "users", "WHERE fb_id LIKE '" . $userId . "'");
$getUserInfos = $newStaticBdd->fetch_array($userInfos);
$getUserId = $newStaticBdd->num_rows($userInfos);
setcookie("username", $userFirstName . ' ' . $userLastName, time() + 7200, "/");
$_SESSION['SID_ID'] = session_id();
if (self::setToken($userId)) {
if ($getUserId != 1) {
$regUser = $newStaticBdd->insert("users", "fb_id, userlink, fb_firstname, fb_lastname, fb_picture, user_ip, isLoggedFB", "'" . $userId . "', '" . $userLink . "', '" . $userFirstName . "', '" . $userLastName . "', '" . $userPicSrc . "', '" . $ip . "', 1");
$dataArray['result'] = true;
$dataArray['error'] = null;
$dataArray['reply'] = "User " . $userFirstName . " " . $userLastName . " registred !";
} else {
$regUser = $newStaticBdd->update("users", "fb_id = '" . $userId . "', userlink = '" . $userLink . "', fb_firstname = '" . $userFirstName . "', fb_lastname = '" . $userLastName . "', fb_picture = '" . $userPicSrc . "', user_ip = '" . $ip . "', isLoggedFB = 1", "WHERE fb_id LIKE '" . $userId . "'");
$dataArray['result'] = true;
$dataArray['error'] = null;
$dataArray['reply'] = "User " . $userFirstName . " " . $userLastName . " updated and logged !";
}
} else {
$dataArray['result'] = false;
$dataArray['error'] = "Token not set !";
$dataArray['reply'] = "User not logged !";
}
return $dataArray;
}
public static function getReleaseDate($releaseName)
{
$newStaticBdd = new BDD();
$dataArray = array();
if (!empty($releaseName)) {
$releaseName = $newStaticBdd->real_escape_string(htmlspecialchars($releaseName));
$releaseInfos = $newStaticBdd->select("*", "release_date", "WHERE name LIKE '" . $releaseName . "'");
$isReleaseExist = $newStaticBdd->num_rows($releaseInfos);
if ($isReleaseExist == 1) {
$getReleaseInfos = $newStaticBdd->fetch_array($releaseInfos);
if ($getReleaseInfos['activated'] == 1) {
$releaseDate = strtotime($getReleaseInfos['date']);
$timeRemaining = $releaseDate - time();
if ($timeRemaining > 0) {
$days = floor($timeRemaining / (60 * 60 * 24));
if ($days < 10) {
$days = '0' . $days;
}
$hours = round(($timeRemaining - $days * 60 * 60 * 24) / (60 * 60));
if ($hours < 10) {
$hours = '0' . $hours;
}
$timeRemainingResult = $days . ':' . $hours . date(':i:s', $timeRemaining);
$dataArray["result"] = true;
$dataArray['error'] = null;
$dataArray['reply'] = $timeRemainingResult;
} else {
$dataArray["result"] = false;
$dataArray['error'] = "Releasedate off";
$dataArray['reply'] = "OVER !";
}
} else {
$dataArray["result"] = false;
$dataArray['error'] = "This release is not activated !";
$dataArray['reply'] = null;
}
} else {
$dataArray["result"] = false;
$dataArray['error'] = "No release with name " . $releaseName . " found !";
$dataArray['reply'] = null;
}
} else {
$dataArray["result"] = false;
$dataArray['error'] = "releaseName is empty !";
$dataArray['reply'] = null;
}
return $dataArray;
}
