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>

1 files changed, 2 insertions, 6 deletions

diff --git a/web/html/rss.php b/web/html/rss.php
index c7de4c6..6f057bf 100644
--- a/web/html/rss.php
+++ b/web/html/rss.php
@@ -37,13 +37,9 @@ $image->description = "AUR Newest Packages Feed";
 $rss->image = $image;
 
 #Get the latest packages and add items for them
-$dbh = db_connect();
-$q = "SELECT * FROM Packages ";
-$q.= "ORDER BY SubmittedTS DESC ";
-$q.= "LIMIT 20";
-$result = db_query($q, $dbh);
+$packages = latest_pkgs(20);
 
-while ($row = mysql_fetch_assoc($result)) {
+while (list($indx, $row) = each($packages)) {
 	$item = new FeedItem();
 	$item->title = $row["Name"];
 	$item->link = "{$protocol}://{$host}/packages.php?ID={$row["ID"]}";