[vhffs-dev] [634] Fixed bug #200.

[subversion@xxxxxxxxx]

Revision: 634
Author:   beuss
Date:     2007-05-30 06:58:44 +0000 (Wed, 30 May 2007)

Log Message:
-----------
Fixed bug #200.

Modified Paths:
--------------
    branches/vhffs-4.0/vhffs-api/src/Vhffs/Services/Mailing.pm


Modified: branches/vhffs-4.0/vhffs-api/src/Vhffs/Services/Mailing.pm
===================================================================
--- branches/vhffs-4.0/vhffs-api/src/Vhffs/Services/Mailing.pm	2007-05-30 06:48:11 UTC (rev 633)
+++ branches/vhffs-4.0/vhffs-api/src/Vhffs/Services/Mailing.pm	2007-05-30 06:58:44 UTC (rev 634)
@@ -632,10 +632,11 @@
     return undef if( ! defined $vhffs );
 
 	$query = "SELECT * FROM vhffs_ml ml, vhffs_object o WHERE o.object_id=ml.object_id";
-	$query .= " AND o.state='".$state."'" if( defined $state );
+	$query .= " AND o.state='$state'" if( defined $state );
 	$query .= " AND ml.owner_gid='".$group->get_gid."'" if( defined $group );
     $query .= " AND ( ( local_part LIKE '%".$name."%' ) OR (domain LIKE '%".$name."%' ) )" if( defined $name );
-    $query .= " AND ( domain='".$domain."')" if( defined $domain );
+    $query .= " AND ( domain='$domain')" if( defined $domain );
+    $query .= ' ORDER BY domain'
 
     my $request = $vhffs->get_db_object->{'DB_READ'}->prepare( $query );
     my $rows = $request->execute() or return -3;