markzz/aurweb.git/web/template/stats/updates_table.php, branch 1.8.2

Always set ModifiedTS including new packages

2011-04-03T20:59:31Z

Set it equal to the SubmittedTS field, which will be our indication the package is new when we show the logo on the front page of the AUR. This results in the ability to remove the use of the unindexable GREATEST() function from the AUR code everywhere we had to use it before to handle the 0 timestamp case. Note that there is no race condition here in calling UNIX_TIMESTAMP() twice- it always returns the time at the beginning of statment execution: mysql> select unix_timestamp(), sleep(2), unix_timestamp(); +------------------+----------+------------------+ | unix_timestamp() | sleep(2) | unix_timestamp() | +------------------+----------+------------------+ | 1300851746 | 0 | 1300851746 | +------------------+----------+------------------+ 1 row in set (2.00 sec) Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Change rss2.php references to rss.php

2009-09-28T20:23:35Z

Signed-off-by: Loui Chang

xhtml validation fix.

2009-02-09T05:14:51Z

Validation fixes.

2009-01-24T06:31:04Z

Signed-off-by: Loui Chang

Replace RSS icon with feed icon.

2009-01-15T03:09:26Z

Signed-off-by: Loui Chang

Cache all front page stats in APC if available

2009-01-08T16:48:58Z

Use the APC cache to store all of the counts and the recently updated package list in a cache, which cuts down on the number of database queries needed. If the data isn't perfectly up to date we will survive. This version of the patch will also cache the relevant counts for individual logged-in users and is more careful about checking whether the value actually exists in the cache by using the status reference to apc_fetch(). Signed-off-by: Dan McGee Signed-off-by: Loui Chang

Move code out of index.php

2008-07-07T15:41:39Z

Move database queries to functions and html to templates. Signed-off-by: Loui Chang