I think I fixed a couple of bugs which caused us to see "0" for

"submissions" and "sub/comments" in daily email. We'll see.
scc · Mar 12, 2002 · aca41c5 · aca41c5
1 parent 1d6a9ea
commit aca41c5
Showing 1 changed file with 3 additions and 2 deletions.
diff --git a/plugins/Stats/Stats.pm b/plugins/Stats/Stats.pm
@@ -93,15 +93,16 @@ sub countSubmissionsByDay {
 
 	my $used = $self->sqlCount(
 		'submissions', 
-		"date BETWEEN '$yesterday 00:00' AND '$yesterday 23:59:59'"
+		"time BETWEEN '$yesterday 00:00' AND '$yesterday 23:59:59'"
 	);
 }
 
 ########################################################
 sub countSubmissionsByCommentIPID {
 	my($self, $yesterday, $ipids) = @_;
 	return unless @$ipids;
-	my $in_list = join(",", @$ipids);
+	my $slashdb = getCurrentDB();
+	my $in_list = join(",", map { $slashdb->sqlQuote($_) } @$ipids);
 
 	my $used = $self->sqlCount(
 		'comments',