[aur-general] How are AUR statistics computed?

Karol Blazewicz karol.blazewicz at gmail.com
Wed Oct 22 18:06:49 UTC 2014


On Wed, Oct 22, 2014 at 7:15 PM, Doug Newgard <scimmia at archlinux.info> wrote:
> On Wed, 22 Oct 2014 19:01:15 +0200
> Karol Blazewicz <karol.blazewicz at gmail.com> wrote:
>
>> https://aur.archlinux.org/ says 'Packages added in the past 7 days -
>> 172', but I've got over 200 new AUR package notification through the
>> rss feed since Oct 18th. What exactly is being counted? Unique package
>> bases?
>
>
> From https://projects.archlinux.org/aur.git/tree/web/lib/stats.inc.php
>
>         $targstamp = intval(strtotime("-7 days"));
>
>         $q = "SELECT COUNT(*) FROM PackageBases WHERE ModifiedTS >=
> $targstamp AND ModifiedTS = SubmittedTS";
>         $add_count = db_cache_value($q, 'add_count');
>
> So yes, it's counting pkgbases.

OK, thanks.
Not sure if any fix (rephrasing) is needed, nobody seems to care ;P


More information about the aur-general mailing list