[vhffs-dev] [1704] Retrieve UID with user info when searching

[ Thread Index | Date Index | More vhffs.org/vhffs-dev Archives ]


Revision: 1704
Author:   beuss
Date:     2011-05-12 22:10:30 +0200 (Thu, 12 May 2011)
Log Message:
-----------
Retrieve UID with user info when searching

Modified Paths:
--------------
    trunk/vhffs-api/src/Vhffs/Panel/User.pm

Modified: trunk/vhffs-api/src/Vhffs/Panel/User.pm
===================================================================
--- trunk/vhffs-api/src/Vhffs/Panel/User.pm	2011-05-12 20:10:22 UTC (rev 1703)
+++ trunk/vhffs-api/src/Vhffs/Panel/User.pm	2011-05-12 20:10:30 UTC (rev 1704)
@@ -110,10 +110,10 @@
     my $users = [];
 
     if( defined $name ) {
-		$sql = 'SELECT u.username, u.firstname, u.lastname , o.state FROM vhffs_users u INNER JOIN vhffs_object o ON o.object_id = u.object_id WHERE u.username LIKE ? OR u.firstname ILIKE ? OR u.lastname ILIKE ?';
+        $sql = 'SELECT u.uid, u.username, u.firstname, u.lastname , o.state FROM vhffs_users u INNER JOIN vhffs_object o ON o.object_id = u.object_id WHERE u.username LIKE ? OR u.firstname ILIKE ? OR u.lastname ILIKE ?';
         push(@params, '%'.lc($name).'%', '%'.$name.'%', '%'.$name.'%');
 	} else {
-        $sql = 'SELECT u.username, u.firstname, u.lastname , o.state FROM vhffs_users u INNER JOIN vhffs_object o ON o.object_id = u.object_id';
+        $sql = 'SELECT u.uid, u.username, u.firstname, u.lastname , o.state FROM vhffs_users u INNER JOIN vhffs_object o ON o.object_id = u.object_id';
 	}
 
 	my $dbh = $main->get_db_object();


Mail converted by MHonArc 2.6.19+ http://listengine.tuxfamily.org/