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; }