X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=src%2FIRC%2FSchedulers.pl;h=d18a35dfdc1eebe1b3a736e60b63b236e2de09a3;hb=6347aa7bd7d649273a92c66190507cc7b41a6278;hp=aa0a450ad59a6233eb51709f14a4061422e47d65;hpb=42f98ea1568081553deb41bf7e4c6a51d320f3c2;p=infobot.git 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'},