PHP moodle_database::release_session_lock示例

示例#1

文件： sessionlib.php 项目： neogic/moodle

 /**
  * Destroy session handler
  *
  * {@see http://php.net/manual/en/function.session-set-save-handler.php}
  *
  * @param string $sid
  * @return bool success
  */
 public function handler_destroy($sid)
 {
     session_kill($sid);
     if (isset($this->record->id) and $this->record->sid === $sid) {
         try {
             $this->database->release_session_lock($this->record->id);
         } catch (Exception $ex) {
             // ignore problems
         }
         $this->record = null;
     }
     $this->lasthash = null;
     return true;
 }

示例#2

文件： mysqli_native_moodle_database.php 项目： rushi963/moodle

 public function release_session_lock($rowid)
 {
     if (!$this->used_for_db_sessions) {
         return;
     }
     parent::release_session_lock($rowid);
     $fullname = $this->dbname . '-' . $this->prefix . '-session-' . $rowid;
     $sql = "SELECT RELEASE_LOCK('{$fullname}')";
     $this->query_start($sql, null, SQL_QUERY_AUX);
     $result = $this->mysqli->query($sql);
     $this->query_end($result);
     if ($result) {
         $result->close();
     }
 }

示例#3

文件： mssql_native_moodle_database.php 项目： grigory-catalyst/moodle

 public function release_session_lock($rowid)
 {
     if (!$this->session_lock_supported()) {
         return;
     }
     if (!$this->used_for_db_sessions) {
         return;
     }
     parent::release_session_lock($rowid);
     $fullname = $this->dbname . '-' . $this->prefix . '-session-' . $rowid;
     $sql = "sp_releaseapplock '{$fullname}', 'Session'";
     $this->query_start($sql, null, SQL_QUERY_AUX);
     $result = mssql_query($sql, $this->mssql);
     $this->query_end($result);
     $this->free_result($result);
 }

示例#4

文件： oci_native_moodle_database.php 项目： nmicha/moodle

 public function release_session_lock($rowid)
 {
     if (!$this->session_lock_supported()) {
         return;
     }
     parent::release_session_lock($rowid);
     $fullname = $this->dbname . '-' . $this->prefix . '-session-' . $rowid;
     $params = array('lockname' => $fullname);
     $sql = 'SELECT MOODLE_LOCKS.RELEASE_LOCK(:lockname) FROM DUAL';
     $this->query_start($sql, $params, SQL_QUERY_AUX);
     $stmt = $this->parse_query($sql);
     $this->bind_params($stmt, $params);
     $result = oci_execute($stmt, $this->commit_status);
     $this->query_end($result, $stmt);
     oci_free_statement($stmt);
 }

示例#5

文件： pgsql_native_moodle_database.php 项目： kevin-bruton/moodle

 public function release_session_lock($rowid)
 {
     if (!$this->session_lock_supported()) {
         return;
     }
     if (!$this->used_for_db_sessions) {
         return;
     }
     parent::release_session_lock($rowid);
     $sql = "SELECT pg_advisory_unlock({$rowid})";
     $this->query_start($sql, null, SQL_QUERY_AUX);
     $result = pg_query($this->pgsql, $sql);
     $this->query_end($result);
     if ($result) {
         pg_free_result($result);
     }
 }

示例#6

文件： pgsql_native_moodle_database.php 项目： janaece/globalclassroom4_clean

 public function release_session_lock($rowid)
 {
     if (!$this->session_lock_supported()) {
         return;
     }
     if (!$this->used_for_db_sessions) {
         return;
     }
     parent::release_session_lock($rowid);
     // OVERWRITE 2: replacement, changed from:
     //$sql = "SELECT pg_advisory_unlock($rowid)";
     // TO:
     global $CFG;
     $sql = "SELECT pg_advisory_unlock({$rowid}, {$CFG->current_app->getId()})";
     // END OVERWRITE 2
     $this->query_start($sql, null, SQL_QUERY_AUX);
     $result = pg_query($this->pgsql, $sql);
     $this->query_end($result);
     if ($result) {
         pg_free_result($result);
     }
 }

示例#7

文件： database.php 项目： evltuma/moodle

 /**
  * Destroy session handler.
  *
  * {@see http://php.net/manual/en/function.session-set-save-handler.php}
  *
  * @param string $sid
  * @return bool success
  */
 public function handler_destroy($sid)
 {
     if (!($session = $this->database->get_record('sessions', array('sid' => $sid), 'id, sid'))) {
         if ($sid == session_id()) {
             $this->recordid = null;
             $this->lasthash = null;
         }
         return true;
     }
     if ($this->recordid and $session->id == $this->recordid) {
         try {
             $this->database->release_session_lock($this->recordid);
         } catch (\Exception $ex) {
             // Ignore problems.
         }
         $this->recordid = null;
         $this->lasthash = null;
     }
     $this->database->delete_records('sessions', array('id' => $session->id));
     return true;
 }