[vhffs-dev] [1221] Better if quotacheck uses an order by...

[subversion@xxxxxxxxxxxxx]

Revision: 1221
Author:   beuss
Date:     2008-06-06 13:00:00 +0200 (Fri, 06 Jun 2008)

Log Message:
-----------
Better if quotacheck uses an order by...

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


Modified: trunk/vhffs-api/src/Vhffs/Group.pm
===================================================================
--- trunk/vhffs-api/src/Vhffs/Group.pm	2008-06-06 10:49:56 UTC (rev 1220)
+++ trunk/vhffs-api/src/Vhffs/Group.pm	2008-06-06 11:00:00 UTC (rev 1221)
@@ -524,7 +524,7 @@
 	$limit = 10 if(! defined $limit );
         my $db = $vhffs->get_db_object;
         my @result;
-        my $query = 'SELECT groupname FROM vhffs_groups g LEFT JOIN vhffs_users u ON g.groupname = u.username WHERE g.quota_used >= 0.9 * g.quota AND u.uid IS NULL LIMIT ?';
+        my $query = 'SELECT groupname FROM vhffs_groups g LEFT JOIN vhffs_users u ON g.groupname = u.username WHERE g.quota_used >= 0.9 * g.quota AND u.uid IS NULL ORDER BY g.quota_used LIMIT ?';
 
         my $request = $db->prepare( $query );
         my $rows = $request->execute($limit);