function remove_allmessages_chatroom($id_chatroom) { $db =& parent::getConnection(); if (AMA_DB::isError($db)) { return $db; } $sql1 = "delete from messaggi where id_chatroom={$id_chatroom}"; $res = parent::executeCritical($sql1); if (AMA_DB::isError($res)) { return $res; } }
/** * remove permanently a message record from 'messaggi' table * or from 'destinatari_messaggi' * used in the rollback operations and in _clean_messages * * @access private * * @param $id - id of the message to remove * @param $rid - the recipient id * if the parameter is passed and not null, then * a row is removed from 'destinatari_messaggi' table * * @return an AMA_Error object if something goes wrong * **/ protected function _clean_message($id, $rid = 0) { // logger("entered Spool::_remove_message", 3); $db =& parent::getConnection(); if (AMA_DB::isError($db)) { return $db; } if ($rid == 0) { // remove a row from table messaggi $sql = "delete from messaggi where id_messaggio={$id}"; // logger("performing query: $sql", 4); /* $res = $db->query($sql); // if (AMA_DB::isError($res) || $db->affectedRows()==0) ?? if (AMA_DB::isError($res) || $db->numCols()==0) return new AMA_Error(AMA_ERR_REMOVE); */ $res = parent::executeCritical($sql); if (AMA_DB::isError($res)) { // $res is an AMA_Error object return $res; } // logger("query succeeded", 4); } else { // remove a row from table destinatari_messaggi $sql = "delete from destinatari_messaggi " . " where id_messaggio={$id} and id_utente={$rid}"; // logger("performing query: $sql", 4); /* $res = $db->query($sql); if (AMA_DB::isError($res) || $db->affectedRows()==0) return new AMA_Error(AMA_ERR_REMOVE); */ $res = parent::executeCritical($sql); if (AMA_DB::isError($res)) { // $res is an AMA_Error object return $res; } // logger("query succeeded", 4); } }