Esempio n. 1
0
 public function UpdateTalkUser(ModuleTalk_EntityTalkUser $oTalkUser)
 {
     $sql = "UPDATE " . Config::Get('db.table.talk_user') . " \n\t\t\tSET \n\t\t\t\tdate_last = ?, \t\t\t\t\n\t\t\t\tcomment_id_last = ?d, \t\t\t\t\n\t\t\t\tcomment_count_new = ?d, \t\n\t\t\t\ttalk_user_active = ?d\t\t\t\n\t\t\tWHERE\n\t\t\t\ttalk_id = ?d\n\t\t\t\tAND\n\t\t\t\tuser_id = ?d\n\t\t";
     if ($this->oDb->query($sql, $oTalkUser->getDateLast(), $oTalkUser->getCommentIdLast(), $oTalkUser->getCommentCountNew(), $oTalkUser->getUserActive(), $oTalkUser->getTalkId(), $oTalkUser->getUserId())) {
         return true;
     }
     return false;
 }
Esempio n. 2
0
 /**
  * Обновляет связку разговор-юзер
  *
  * @param ModuleTalk_EntityTalkUser $oTalkUser    Объект связи пользователя с разговором
  *
  * @return bool
  */
 public function UpdateTalkUser(ModuleTalk_EntityTalkUser $oTalkUser)
 {
     $sql = "UPDATE ?_talk_user\n\t\t\tSET \n\t\t\t\tdate_last = ?,\n\t\t\t\tcomment_id_last = ?d,\n\t\t\t\tcomment_count_new = ?d,\n\t\t\t\ttalk_user_active = ?d\n\t\t\tWHERE\n\t\t\t\ttalk_id = ?d\n\t\t\t\tAND\n\t\t\t\tuser_id = ?d\n\t\t";
     $bResult = $this->oDb->query($sql, $oTalkUser->getDateLast(), $oTalkUser->getCommentIdLast(), $oTalkUser->getCommentCountNew(), $oTalkUser->getUserActive(), $oTalkUser->getTalkId(), $oTalkUser->getUserId());
     return $bResult !== false;
 }