From d3c90f34807b4c447c729b8066589cba3392f4d4 Mon Sep 17 00:00:00 2001
From: timriker <timriker@c11ca15a-4712-0410-83d8-924469b57eb5>
Date: Tue, 6 Jul 2004 22:24:56 +0000
Subject: [PATCH] older mysql lacks OFFSET support

git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk/blootbot@986 c11ca15a-4712-0410-83d8-924469b57eb5
---
 src/dbi.pl | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/src/dbi.pl b/src/dbi.pl
index 138c5cc..f4c89d3 100644
--- a/src/dbi.pl
+++ b/src/dbi.pl
@@ -516,7 +516,10 @@ sub randKey {
     my ($table, $select) = @_;
     my $rand	= int(rand(&countKeys($table)));
     my $query	= "SELECT $select FROM $table LIMIT 1 OFFSET $rand";
-
+    if ($param{DBType} =~ /^mysql$/i) {
+	# WARN: only newer MySQL supports "LIMIT limit OFFSET offset"
+	$query = "SELECT $select FROM $table LIMIT $rand,1";
+    }
     my $sth	= $dbh->prepare($query);
     &SQLDebug($query);
     &WARN("randKey($query)") unless $sth->execute;
-- 
2.39.2