SF.net SVN: postfixadmin:[706] trunk/VIRTUAL_VACATION/vacation.pl

[<chr...@us...>]

Revision: 706
          http://postfixadmin.svn.sourceforge.net/postfixadmin/?rev=706&view=rev
Author:   christian_boltz
Date:     2009-08-18 20:52:37 +0000 (Tue, 18 Aug 2009)

Log Message:
-----------
vacation.pl:
- fix typo (?) in query: "goto like %" should most probably be "goto like ?" (placeholder)
  (if this was not a typo, the whole "AND ..." would be superfluous)

Modified Paths:
--------------
    trunk/VIRTUAL_VACATION/vacation.pl

Modified: trunk/VIRTUAL_VACATION/vacation.pl
===================================================================
--- trunk/VIRTUAL_VACATION/vacation.pl	2009-08-17 17:36:04 UTC (rev 705)
+++ trunk/VIRTUAL_VACATION/vacation.pl	2009-08-18 20:52:37 UTC (rev 706)
@@ -327,7 +327,7 @@
         $logger->debug("Found '\$email'\ has vacation active");
     } else {
         $logger->debug("Looking for alias records that \'$email\' resolves to with vacation turned on");
-        $query = qq{SELECT goto FROM alias WHERE address=? AND (goto LIKE ? OR goto LIKE % OR goto LIKE ?)};
+        $query = qq{SELECT goto FROM alias WHERE address=? AND (goto LIKE ? OR goto LIKE ? OR goto LIKE ?)};
         $stm = $dbh->prepare($query) or panic_prepare($query);
         $stm->execute($email,"$email,%","%,$email","%,$email,%") or panic_execute($query,"address='$email'");
         $rv = $stm->rows;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.