public function trackSession() { global $isv_db, $sessFound; $sess_id = session_id(); if (!isLoggedIn()) { //check if the session is in our db and add if not found checkUserSession($sess_id); if ($sessFound > 0) { //we update last activity $stmt = $isv_db->prepare("UPDATE sessions SET last_activity=UTC_TIMESTAMP() where sess_id=?"); $stmt->bind_param('s', $sess_id); $stmt->execute(); $stmt->close(); } else { //add session $stmt = $isv_db->prepare("INSERT INTO sessions (sess_id,last_activity) VALUES (?,UTC_TIMESTAMP())"); $stmt->bind_param('s', $sess_id); $stmt->execute(); $stmt->close(); } } else { $stmt = $isv_db->prepare("UPDATE users SET last_activity=UTC_TIMESTAMP() where id=?"); $stmt->bind_param('s', $_SESSION['isv_user_id']); $stmt->execute(); $stmt->close(); checkUserSession($sess_id); if ($sessFound > 0) { //we update last activity $stmt = $isv_db->prepare("UPDATE sessions SET user_id=?,last_activity=UTC_TIMESTAMP() where sess_id=?"); $stmt->bind_param('is', $_SESSION['isv_user_id'], $sess_id); $stmt->execute(); $stmt->close(); } else { //add session $stmt = $isv_db->prepare("INSERT INTO sessions (sess_id,user_id,last_activity) VALUES (?,?,UTC_TIMESTAMP())"); $stmt->bind_param('si', $sess_id, $_SESSION['isv_user_id']); $stmt->execute(); $stmt->close(); } } }
$datesarray = getDatesSession($idsession); for ($f = 0; $f < $nbrdates; $f++) { $rowd = mysqli_fetch_array($datesarray); //debug($row); $datessession = $datessession . getDatefr($rowd["date_session"]) . " <br>"; $iddate = $rowd["id_datesession"]; //donner la derniere id } $placesoccupee = countPlaceSession($idsession, 0); $enattente = countPlaceSession($idsession, 2); $placesrestantes = $nbplace - $placesoccupee; //tester la présence de tarifs ateliers $testTarifAtelier = TestTarifs(); if ($b == 2) { //verification d'inscription if (FALSE != checkUserSession($idsession, $iduser)) { $datesarray2 = getDatesSession($idsession); //boucler pour insérer le nombre de dates par sessions for ($f = 0; $f < $nbrdates; $f++) { $row2 = mysqli_fetch_array($datesarray2); addUserSession($idsession, $iduser, $idstatut, $row2["id_datesession"]); } echo geterror(25); header("Location:index.php?a=30&b=1&idsession=" . $idsession); } else { echo geterror(21); header("Location:index.php?a=30&b=1&idsession=" . $idsession); } } if ($b == 3) { if (FALSE != delUserSession($idsession, $iduser)) {
$espaces = getAllepn(); // si b =2 inscription a un atelier if ($b == 2) { if (FALSE != addUserAtelier($idatelier, 0, $_SESSION["iduser"])) { echo "<div class=\"row\"><div class=\"col-md-6\"> <div class=\"alert alert-info alert-dismissable\"> \n\t\t\t\t<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">×</button>\n <h4><i class=\"icon fa fa-info\"></i>Inscription validée</h4></div></div></div>"; } } // si b=3 desinscription a un atelier if ($b == 3) { delUserAtelier($idatelier, $_SESSION["iduser"]); echo "<div class=\"row\"><div class=\"col-md-6\"> <div class=\"alert alert-info alert-dismissable\"> \n\t\t\t\t<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">×</button>\n\t\t\t\t <h4><i class=\"icon fa fa-info\"></i>Désinscription effectuée</h4></div></div></div>"; } //si b==6 inscription a une session if ($b == 6) { //verification d'inscription if (FALSE != checkUserSession($idsession, $_SESSION["iduser"])) { $nbrdates = $_GET["nbd"]; $datesarray2 = getDatesSession($idsession); //boucler pour insérer le nombre de dates par sessions for ($f = 0; $f < $nbrdates; $f++) { $row2 = mysqli_fetch_array($datesarray2); addUserSession($idsession, $_SESSION["iduser"], 0, $row2["id_datesession"]); } echo geterror(25); } else { echo geterror(21); } } // si b=7 desinscription a une session if ($b == 7) { delUserSession($idsession, $_SESSION["iduser"]);