From 6347aa7bd7d649273a92c66190507cc7b41a6278 Mon Sep 17 00:00:00 2001
From: timriker <timriker@c11ca15a-4712-0410-83d8-924469b57eb5>
Date: Tue, 26 Jul 2005 18:47:45 +0000
Subject: [PATCH] missed sqlite2 bits

git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk/blootbot@1234 c11ca15a-4712-0410-83d8-924469b57eb5
---
 src/IRC/Schedulers.pl    | 8 ++++----
 src/Modules/countdown.pl | 2 +-
 src/Process.pl           | 2 +-
 3 files changed, 6 insertions(+), 6 deletions(-)

diff --git a/src/IRC/Schedulers.pl b/src/IRC/Schedulers.pl
index aa0a450..d18a35d 100644
--- a/src/IRC/Schedulers.pl
+++ b/src/IRC/Schedulers.pl
@@ -262,10 +262,10 @@ sub seenFlushOld {
     my $max_time = &getChanConfDefault("seenMaxDays", 30, $chan) *60*60*24;
     my $delete   = 0;
 
-    if ($param{'DBType'} =~ /^(pgsql|mysql|sqlite)/i) {
+    if ($param{'DBType'} =~ /^(pgsql|mysql|sqlite(2)?)$/i) {
 	my $query;
 
-	if ($param{'DBType'} =~ /^mysql|sqlite$/i) {
+	if ($param{'DBType'} =~ /^(mysql|sqlite(2)?)$/i) {
 	    $query = "SELECT nick,time FROM seen GROUP BY nick HAVING ".
 			"UNIX_TIMESTAMP() - time > $max_time";
 	} else {	# pgsql.
@@ -550,12 +550,12 @@ sub seenFlush {
 
     my %stats;
     my $nick;
-    my $flushed 	= 0;
+    my $flushed = 0;
     $stats{'count_old'} = &countKeys("seen") || 0;
     $stats{'new'}	= 0;
     $stats{'old'}	= 0;
 
-    if ($param{'DBType'} =~ /^(mysql|pgsql|sqlite)$/i) {
+    if ($param{'DBType'} =~ /^(mysql|pgsql|sqlite(2)?)$/i) {
 	foreach $nick (keys %seencache) {
 	    my $retval = &sqlReplace("seen", {
 			nick	=> lc $seencache{$nick}{'nick'},
diff --git a/src/Modules/countdown.pl b/src/Modules/countdown.pl
index 04230c3..912a463 100644
--- a/src/Modules/countdown.pl
+++ b/src/Modules/countdown.pl
@@ -44,7 +44,7 @@ sub countdown {
 	### SQL SPECIFIC.
 	my ($to_days,$dayname,$monname);
 
-	if ($param{'DBType'} =~ /^mysql|sqlite$/i) {
+	if ($param{'DBType'} =~ /^(mysql|sqlite(2)?)$/i) {
 	    $to_days = (&sqlRawReturn("SELECT TO_DAYS(NOW()) - TO_DAYS('$sqldate')"))[0];
 	    $dayname = (&sqlRawReturn("SELECT DAYNAME('$sqldate')"))[0];
 	    $monname = (&sqlRawReturn("SELECT MONTHNAME('$sqldate')"))[0];
diff --git a/src/Process.pl b/src/Process.pl
index 914f481..36cffd4 100644
--- a/src/Process.pl
+++ b/src/Process.pl
@@ -349,7 +349,7 @@ sub process {
 	}
     }
 
-    if (&IsParam("factoids") and $param{'DBType'} =~ /^(mysql|sqlite|pgsql)/i) {
+    if (&IsParam("factoids") and $param{'DBType'} =~ /^(mysql|sqlite(2)?|pgsql)$/i) {
 	&FactoidStuff();
     } elsif ($param{'DBType'} =~ /^none$/i) {
 	return "NO FACTOIDS.";
-- 
2.39.2