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);
}
}
