/**
* Восстановить ранее удаленное сообщение
* @param $message_id идентификатор сообщения
**/
public static function RestoreMessage($message_id)
{
global $DB;
$sql = "UPDATE commune_messages SET deleted_id = NULL, deleted_time = NULL WHERE id = ? RETURNING theme_id";
if ($res = $DB->query($sql, $message_id)) {
if (pg_affected_rows($res)) {
list($theme_id) = pg_fetch_row($res);
$commId = commune::getCommuneIdByMsgID($message_id);
$sql = "SELECT re_pos_commune_themes(?i, (SELECT pos FROM commune_themes WHERE id = ?i), NULL)";
$DB->query($sql, $commId, $theme_id);
}
}
}
