SF.net SVN: ledger-smb: [1905] trunk/LedgerSMB/Auth/DB.pm

[..hidden..]

Revision: 1905
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=1905&view=rev
Author:   einhverfr
Date:     2007-11-25 13:07:55 -0800 (Sun, 25 Nov 2007)

Log Message:
-----------
Removing login variable from session creation query

Modified Paths:
--------------
    trunk/LedgerSMB/Auth/DB.pm

Modified: trunk/LedgerSMB/Auth/DB.pm
===================================================================
--- trunk/LedgerSMB/Auth/DB.pm	2007-11-25 20:41:51 UTC (rev 1904)
+++ trunk/LedgerSMB/Auth/DB.pm	2007-11-25 21:07:55 UTC (rev 1905)
@@ -162,7 +162,7 @@
         "INSERT INTO session (session_id, users_id, token, transaction_id) 
                                         VALUES(?, (SELECT id
                                                      FROM users
-                                                    WHERE username = ?), ?, ?);"
+                                                    WHERE username = SESSION_USER), ?, ?);"
     );
 
 # this is assuming that the login is safe, which might be a bad assumption
@@ -194,7 +194,7 @@
     my ( $newSessionID, $newToken ) = $fetchSequence->fetchrow_array;
 
     #create a new session
-    $createNew->execute( $newSessionID, $login, $newToken, $newTransactionID )
+    $createNew->execute( $newSessionID, $newToken, $newTransactionID )
       || $lsmb->dberror( __FILE__ . ':' . __LINE__ . ": Create new session: \n".
 		$lsmb->{dbh}->errstr() );
 


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