/** * Восстановить ранее удаленное сообщение * @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); } } }