diff options
| author | canyonknight <canyonknight@gmail.com> | 2012-05-25 17:45:53 -0400 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2012-07-06 11:27:06 +0200 |
| commit | 41986bbc783f007c79df1b508942809a742876d2 (patch) | |
| tree | f3f6c7847ebb6eba4099dba9023bd855f846566e /web/lib | |
| parent | c15441762c2f6ab4438eaf2854c0ee3146a98b30 (diff) | |
rss.php: Pull out DB code
* Move DB code in rss.php to new function in aur.inc.php
* Centralization of DB code important in a future transition to PDO interface
Signed-off-by: canyonknight <canyonknight@gmail.com>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'web/lib')
| -rw-r--r-- | web/lib/aur.inc.php | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/web/lib/aur.inc.php b/web/lib/aur.inc.php index 1a294a9..4e6baa2 100644 --- a/web/lib/aur.inc.php +++ b/web/lib/aur.inc.php @@ -533,3 +533,22 @@ function last_insert_id($dbh=NULL) { } return mysql_insert_id($dbh); } + +function latest_pkgs($numpkgs, $dbh=NULL) { + if(!$dbh) { + $dbh = db_connect(); + } + + $q = "SELECT * FROM Packages "; + $q.= "ORDER BY SubmittedTS DESC "; + $q.= "LIMIT " .intval($numpkgs); + $result = db_query($q, $dbh); + + if ($result) { + while ($row = mysql_fetch_assoc($result)) { + $packages[] = $row; + } + } + + return $packages; +} |