public static function deleteMessageById($id)
{
$inTransaction = DB::getInstance()->inTransaction();
if (!$inTransaction) {
DB::getInstance()->beginTransaction();
}
$statement = DB::getInstance()->prepare("DELETE FROM `message` WHERE id=:id");
$statement->bindValue(':id', $id, DB::PARAM_INT);
$result = $statement->execute();
if (!$inTransaction) {
DB::getInstance()->commit();
}
return $result;
}