/**
* Создание пользовательской сессии
*
* @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;
}
/**
* Создание пользовательской сессии
*
* @param ModuleUser_EntitySession $oSession
* @return bool
*/
public function CreateSession(ModuleUser_EntitySession $oSession)
{
$sql = "REPLACE INTO " . Config::Get('db.table.session') . "\n SET\n session_key = ? ,\n user_id = ? ,\n session_ip_create = ? ,\n session_ip_last = ? ,\n session_date_create = ? ,\n session_date_last = ?\n ";
return $this->oDb->query($sql, $oSession->getKey(), $oSession->getUserId(), $oSession->getIpCreate(), $oSession->getIpLast(), $oSession->getDateCreate(), $oSession->getDateLast());
}
