[vhffs-dev] [396] Fixes mailing list search function (typo).

[subversion@xxxxxxxxx]

Revision: 396
Author:   gradator
Date:     2007-01-13 00:14:37 +0000 (Sat, 13 Jan 2007)

Log Message:
-----------
Fixes mailing list search function (typo).

Modified Paths:
--------------
    branches/vhffs_4.1/vhffs-api/src/Vhffs/Services/Mailing.pm
    trunk/vhffs-api/src/Vhffs/Services/Mailing.pm


Modified: branches/vhffs_4.1/vhffs-api/src/Vhffs/Services/Mailing.pm
===================================================================
--- branches/vhffs_4.1/vhffs-api/src/Vhffs/Services/Mailing.pm	2007-01-11 19:58:22 UTC (rev 395)
+++ branches/vhffs_4.1/vhffs-api/src/Vhffs/Services/Mailing.pm	2007-01-13 00:14:37 UTC (rev 396)
@@ -633,7 +633,7 @@
 	$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 ml.owner_gid='".$group->get_gid."'" if( defined $group );
-    $query .= " AND ( ( local LIKE '%".$name."%' ) OR (domain LIKE '%".$name."'% ) )" if( defined $name );
+    $query .= " AND ( ( local_part LIKE '%".$name."%' ) OR (domain LIKE '%".$name."%' ) )" if( defined $name );
     $query .= " AND ( domain='".$domain."')" if( defined $domain );
 
     my $request = $vhffs->get_db_object->prepare( $query );

Modified: trunk/vhffs-api/src/Vhffs/Services/Mailing.pm
===================================================================
--- trunk/vhffs-api/src/Vhffs/Services/Mailing.pm	2007-01-11 19:58:22 UTC (rev 395)
+++ trunk/vhffs-api/src/Vhffs/Services/Mailing.pm	2007-01-13 00:14:37 UTC (rev 396)
@@ -634,7 +634,7 @@
 	$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 ml.owner_gid='".$group->get_gid."'" if( defined $group );
-    $query .= " AND ( ( local LIKE '%".$name."%' ) OR (domain LIKE '%".$name."'% ) )" if( defined $name );
+    $query .= " AND ( ( local_part LIKE '%".$name."%' ) OR (domain LIKE '%".$name."%' ) )" if( defined $name );
     $query .= " AND ( domain='".$domain."')" if( defined $domain );
 
     my $request = $vhffs->get_db_object->{'DB_READ'}->prepare( $query );