From 28c7445bc5482a70d25823501921136bab139a86 Mon Sep 17 00:00:00 2001
From: djmcgrath <djmcgrath@c11ca15a-4712-0410-83d8-924469b57eb5>
Date: Tue, 15 Apr 2008 04:14:14 +0000
Subject: [PATCH 1/1] * Fixed a bug that caused seen stats flush to crash
 related to sqlite not having UNIX_TIMESTAMP

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

diff --git a/src/IRC/Schedulers.pl b/src/IRC/Schedulers.pl
index 7907ec4..e854d1e 100644
--- a/src/IRC/Schedulers.pl
+++ b/src/IRC/Schedulers.pl
@@ -254,9 +254,12 @@ sub seenFlushOld {
     if ($param{'DBType'} =~ /^(pgsql|mysql|sqlite(2)?)$/i) {
 	my $query;
 
-	if ($param{'DBType'} =~ /^(mysql|sqlite(2)?)$/i) {
+	if ($param{'DBType'} =~ /^mysql$/i) {
 	    $query = "SELECT nick,time FROM seen GROUP BY nick HAVING ".
 			"UNIX_TIMESTAMP() - time > $max_time";
+    } elsif ($param{'DBType'} =~ /^sqlite(2)?$/i) {
+        $query = "SELECT nick,time FROM seen GROUP BY nick HAVING ".
+            "strftime('%s','now','localtime') - time > $max_time";
 	} else {	# pgsql.
 	    $query = "SELECT nick,time FROM seen WHERE ".
 		"extract(epoch from timestamp 'now') - time > $max_time";
-- 
2.39.2