X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=src%2FModules%2FCountdown.pl;h=a5e9edffcaa9873a01566039814290f5912d62aa;hb=f7cae48a17d6decd0a9bd997188271daa0a885b1;hp=abd1099934347b72358c2af06be6022fa058c4ca;hpb=c7f705958b79e5a22564aa9525817a029adaeeca;p=infobot.git

diff --git a/src/Modules/Countdown.pl b/src/Modules/Countdown.pl
index abd1099..a5e9edf 100644
--- a/src/Modules/Countdown.pl
+++ b/src/Modules/Countdown.pl
@@ -44,26 +44,19 @@ sub Countdown {
 	### SQL SPECIFIC.
 	my ($to_days,$dayname,$monname);
 
-	if ($param{'DBType'} =~ /^mysql$/i) {
-	    $to_days = (&dbRawReturn("SELECT TO_DAYS(NOW()) - TO_DAYS('$sqldate')"))[0];
-	    $dayname = (&dbRawReturn("SELECT DAYNAME('$sqldate')"))[0];
-	    $monname = (&dbRawReturn("SELECT MONTHNAME('$sqldate')"))[0];
+	if ($param{'DBType'} =~ /^mysql|sqlite$/i) {
+	    $to_days = (&sqlRawReturn("SELECT TO_DAYS(NOW()) - TO_DAYS('$sqldate')"))[0];
+	    $dayname = (&sqlRawReturn("SELECT DAYNAME('$sqldate')"))[0];
+	    $monname = (&sqlRawReturn("SELECT MONTHNAME('$sqldate')"))[0];
 
 	} elsif ($param{'DBType'} =~ /^pgsql$/i) {
-	    $to_days = (&dbRawReturn("SELECT date_trunc('day', 
+	    $to_days = (&sqlRawReturn("SELECT date_trunc('day',
 				'now'::timestamp - '$sqldate')"))[0];
-	    $dayname = qw(Sun Mon Tue Wed Thu Fri Sat)[(&dbRawReturn("SELECT extract(dow from timestamp '$sqldate')"))[0]];
-	    $monname = qw(BAD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec)[(&dbRawReturn("SELECT extract(month from timestamp '$sqldate')"))[0]];
-
-	} elsif ($param{'DBType'} =~ /^dbm$/i) {
-	    &DEBUG("Countdown: FIXME!!!");
-#	    $to_days = 
-#	    $dayname = 
-#	    $monname = 
-	    return 1;
+	    $dayname = qw(Sun Mon Tue Wed Thu Fri Sat)[(&sqlRawReturn("SELECT extract(dow from timestamp '$sqldate')"))[0]];
+	    $monname = qw(BAD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec)[(&sqlRawReturn("SELECT extract(month from timestamp '$sqldate')"))[0]];
 
 	} else {
-	    &ERROR("Countdown: invalid DBType?");
+	    &ERROR("Countdown: invalid DBType " . $param{'DBType'} . ".");
 	    return 1;
 	}