Ejemplo n.º 1
0
 /**
  * Создание пользовательской сессии
  *
  * @param ModuleUser_EntitySession $oSession
  *
  * @return bool
  */
 public function CreateSession(ModuleUser_EntitySession $oSession)
 {
     $sql = "SELECT session_key FROM ?_session WHERE session_key=? LIMIT 1";
     if ($this->oDb->select($sql, $oSession->getKey())) {
         $sql = "UPDATE ?_session\n                    SET\n                        user_id = ?d:user_id ,\n                        session_ip_create = ?:ip_create ,\n                        session_ip_last = ?:ip_last ,\n                        session_date_create = ?:date_create ,\n                        session_date_last = ?:date_last ,\n                        session_agent_hash = ?:agent_hash\n                    WHERE\n                        session_key = ?:key\n            ";
     } else {
         $sql = "INSERT INTO ?_session\n                    (\n                        session_key,\n                        user_id,\n                        session_ip_create,\n                        session_ip_last,\n                        session_date_create,\n                        session_date_last,\n                        session_agent_hash\n                    )\n                    VALUES (\n                        ?:key ,\n                        ?d:user_id ,\n                        ?:ip_create ,\n                        ?:ip_last ,\n                        ?:date_create ,\n                        ?:date_last ,\n                        ?:agent_hash\n                    )\n            ";
     }
     $bResult = $this->oDb->sqlQuery($sql, array(':key' => $oSession->getKey(), ':user_id' => $oSession->getUserId(), ':ip_create' => $oSession->getIpCreate(), ':ip_last' => $oSession->getIpLast(), ':date_create' => $oSession->getDateCreate(), ':date_last' => $oSession->getDateLast(), ':agent_hash' => $oSession->getUserAgentHash()));
     return $bResult !== false;
 }