SF.net SVN: postfixadmin: [97] trunk/users/login.php

[<Gin...@us...>]

Revision: 97
          http://postfixadmin.svn.sourceforge.net/postfixadmin/?rev=97&view=rev
Author:   GingerDog
Date:     2007-09-25 13:06:28 -0700 (Tue, 25 Sep 2007)

Log Message:
-----------
users/login.php: sql refactoring

Modified Paths:
--------------
    trunk/users/login.php

Modified: trunk/users/login.php
===================================================================
--- trunk/users/login.php	2007-09-25 19:54:03 UTC (rev 96)
+++ trunk/users/login.php	2007-09-25 20:06:28 UTC (rev 97)
@@ -35,22 +35,17 @@
    $fUsername = escape_string ($_POST['fUsername']);
    $fPassword = escape_string ($_POST['fPassword']);
 
-   $query = "SELECT password FROM $table_mailbox WHERE username='$fUsername' AND active='1'";
-   if ('pgsql'==$CONF['database_type'])
-   {
-      $query = "SELECT password FROM $table_mailbox WHERE username='$fUsername' AND active=true";
-   }
+   $active = db_get_boolean(True);
+   $query = "SELECT password FROM $table_mailbox WHERE username='$fUsername' AND active=$active";
+
    $result = db_query ($query);
    if ($result['rows'] == 1)
    {
       $row = db_array ($result['result']);
       $password = pacrypt ($fPassword, $row['password']);
 
-      $query = "SELECT * FROM $table_mailbox WHERE username='$fUsername' AND password='$password' AND active='1'";
-      if ('pgsql'==$CONF['database_type'])
-      {
-         $query = "SELECT * FROM $table_mailbox WHERE username='$fUsername' AND password='$password' AND active=true";
-      }
+      $query = "SELECT * FROM $table_mailbox WHERE username='$fUsername' AND password='$password' AND active=$active";
+
       $result = db_query ($query);
       if ($result['rows'] != 1)
       {


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