From 18f242c49574d42ff2c06c6b75f4fd6281b8980f Mon Sep 17 00:00:00 2001
From: "bugreport%peshkin.net" <>
Date: Thu, 25 Mar 2004 22:32:18 +0000
Subject: Bug 127862:Have sanitycheck.cgi use perl to evaluate email regexp
 r=vlad,a=justdave

---
 sanitycheck.cgi | 9 ++++-----
 1 file changed, 4 insertions(+), 5 deletions(-)

(limited to 'sanitycheck.cgi')

diff --git a/sanitycheck.cgi b/sanitycheck.cgi
index 1d9a994b5..8060c1c99 100755
--- a/sanitycheck.cgi
+++ b/sanitycheck.cgi
@@ -418,13 +418,12 @@ DoubleCrossCheck("milestones", "product_id", "value",
 Status("Checking profile logins");
 
 my $emailregexp = Param("emailregexp");
-$emailregexp =~ s/'/\\'/g;
-SendSQL("SELECT userid, login_name FROM profiles " .
-        "WHERE login_name NOT REGEXP '" . $emailregexp . "'");
-
+SendSQL("SELECT userid, login_name FROM profiles");
 
 while (my ($id,$email) = (FetchSQLData())) {
-    Alert "Bad profile email address, id=$id,  &lt;$email&gt;."
+    unless ($email =~ m/$emailregexp/) {
+        Alert "Bad profile email address, id=$id,  &lt;$email&gt;."
+    }
 }
 
 ###########################################################################
-- 
cgit v1.2.3-24-g4f1b