Feature request: Additional rss feed(s) about freshports HOT 7 CLOSED

see also #41

from freshports.

FYI, I found https://www.freshports.org/backend/newsfeeds.php which already has an RSS feed for ne ports. However, it is not being refreshed. See #58

from freshports.

On my laptop, I have a working RSS feed for new ports, which works on both head and any branch.

from freshports.

An issue with a broken ports feed: If you list all broken ports, how do you sort the list? Ideally, it would be against latest commit. I can think of no other way.

from freshports.

Please have a look at https://dev.freshports.org/backend/newsfeeds.php and see if this does what you need.

If this stuff is OK, I will then add vulnerable ports

from freshports.

https://dev.freshports.org/backend/news.php?flavor=new works exactly as I hoped it would, this is absolutely perfect!

Using this to keep track of vulnerable ports is also a really neat idea that I hadn't even thought of.

from freshports.

This gives us the count of vulnerable ports, so it's easily modified to get the list of those ports:

CREATE OR REPLACE FUNCTION Stats_PortCountVulnerable() returns int8 AS $$
        DECLARE
                PortCount       int8;

        BEGIN
                SELECT count(*)
                  INTO PortCount
                  FROM ports            P
                  JOIN ports_vulnerable PV ON PV.current    > 0            AND PV.port_id = P.id
                  JOIN element_pathname EP ON EP.element_id = P.element_id AND EP.pathname like '/ports/head/%'
                  JOIN element          E  ON P.element_id  = E.id         AND E.status = 'A';

                return PortCount;
        END
$$ LANGUAGE 'plpgsql';

from freshports.