SQL: use standard LIMIT/OFFSET syntax

Increases compatibility with standard SQL dialect.

Thanks-to: elij <elij.mx@gmail.com>
Signed-off-by: Dan McGee <dan@archlinux.org>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>

2 files changed, 2 insertions, 2 deletions

diff --git a/web/html/rss.php b/web/html/rss.php
index cb0bf40..0547815 100644
--- a/web/html/rss.php
+++ b/web/html/rss.php
@@ -32,7 +32,7 @@ $rss->image = $image;
 $dbh = db_connect();
 $q = "SELECT * FROM Packages ";
 $q.= "ORDER BY SubmittedTS DESC ";
-$q.= "LIMIT 0 , 20";
+$q.= "LIMIT 20";
 $result = db_query($q, $dbh);
 
 while ($row = mysql_fetch_assoc($result)) {
diff --git a/web/html/tu.php b/web/html/tu.php
index 941e6ed..dc1c5e3 100644
--- a/web/html/tu.php
+++ b/web/html/tu.php
@@ -119,7 +119,7 @@ if ($atype == "Trusted User" OR $atype == "Developer") {
 		}
 
 		$order = ($by == 'asc') ? 'ASC' : 'DESC';
-		$lim = ($limit > 0) ? " LIMIT $off, $limit" : "";
+		$lim = ($limit > 0) ? " LIMIT $limit OFFSET $off" : "";
 		$by_next = ($by == 'desc') ? 'asc' : 'desc';
 
 		$q = "SELECT * FROM TU_VoteInfo WHERE End > " . time() . " ORDER BY Submitted " . $order;