[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();