From a7cec3a4152ab42e16d6b530f25f960909c72eca Mon Sep 17 00:00:00 2001
From: Michael Andreen <harv@ruin.nu>
Date: Tue, 12 Dec 2006 12:09:01 +0000
Subject: [PATCH] offset as bind value instead

---
 top100.pl | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/top100.pl b/top100.pl
index 27219e0..9611a17 100644
--- a/top100.pl
+++ b/top100.pl
@@ -52,8 +52,8 @@ if (isHC()){
 }
 my $query = $DBH->prepare(qq{SELECT id,coords(x,y,z), ruler, planet,race,
 	size, score, value, xp, sizerank, scorerank, valuerank, xprank
-	$extra_columns FROM current_planet_stats ORDER BY $order LIMIT 100 OFFSET $offset});
-$query->execute;
+	$extra_columns FROM current_planet_stats ORDER BY $order LIMIT 100 OFFSET ?});
+$query->execute($offset);
 my @planets;
 while (my ($id,$coords,$ruler,$planet,$race,$size,$score,$value,$xp,$sizerank,$scorerank,$valuerank,$xprank
 		,$planet_status,$hit_us,$alliance,$relationship,$nick) = $query->fetchrow){
-- 
2.39.2