[vhffs-dev] [1905] ported commit #1904 to 4.3 |
[ Thread Index |
Date Index
| More vhffs.org/vhffs-dev Archives
]
Revision: 1905
Author: gradator
Date: 2011-09-08 00:00:46 +0200 (Thu, 08 Sep 2011)
Log Message:
-----------
ported commit #1904 to 4.3
Modified Paths:
--------------
branches/vhffs-4.3/vhffs-api/src/Vhffs/Panel/User.pm
Modified: branches/vhffs-4.3/vhffs-api/src/Vhffs/Panel/User.pm
===================================================================
--- branches/vhffs-4.3/vhffs-api/src/Vhffs/Panel/User.pm 2011-09-07 20:23:54 UTC (rev 1904)
+++ branches/vhffs-4.3/vhffs-api/src/Vhffs/Panel/User.pm 2011-09-07 22:00:46 UTC (rev 1905)
@@ -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();