From c9c74e4f21efaed0aed017e2b21b25bfde9d98b4 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Rapha=C3=ABl=20Barrois?= Date: Fri, 7 May 2010 16:13:31 +0200 Subject: [PATCH] Fix bug in UFC_Registration with 0000-00-00 00:00:00 dates MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit SELECT COUNT(*) FROM accounts WHER registration_date IS NULL AND registration_date IS NOT NULL => 16 000 rows ! Signed-off-by: Raphaël Barrois --- classes/userfilter.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/classes/userfilter.php b/classes/userfilter.php index 9362b98..0e178d9 100644 --- a/classes/userfilter.php +++ b/classes/userfilter.php @@ -459,7 +459,7 @@ class UFC_Registered implements UserFilterCondition $date = 'a.uid IS NOT NULL AND a.state != \'pending\''; } if (!is_null($this->comparison)) { - $date .= ' AND a.registration_date ' . $this->comparison . ' ' . XDB::format('{?}', $this->date->format('Y-m-d')); + $date .= ' AND a.registration_date != \'0000-00-00 00:00:00\' AND a.registration_date ' . $this->comparison . ' ' . XDB::format('{?}', $this->date->format('Y-m-d')); } return $date; } -- 2.1.4