/** * Mark a message as read * * @param XoopsPrivateMessage $pm XoopsPrivateMessage object * * @return bool **/ public function setRead(XoopsPrivateMessage $pm) { $qb = $this->db2->createXoopsQueryBuilder()->update($this->table, 'pm')->set('pm.read_msg', ':readmsg')->where('pm.msg_id = :msgid')->setParameter(':readmsg', 1, \PDO::PARAM_INT)->setParameter(':msgid', (int) $pm->getVar('msg_id'), \PDO::PARAM_INT); $result = $qb->execute(); if (!$result) { return false; } return true; }
public function test_setRead() { $instance = new $this->myclass($this->conn); $msg = new XoopsPrivateMessage(); $msg->setDirty(true); $msg->setNew(true); $msg->setVar('subject', 'PRIVMESSAGE_DUMMY_FOR_TESTS', true); $value = $instance->insert($msg); $this->assertTrue(intval($value) > 0); $value = $instance->setRead($msg); $this->assertSame(true, $value); }