Changeset 15393 for trunk/xmlrpc/BxDolXMLRPCSearch.php

Timestamp:

07/27/11 23:09:41 (10 months ago)

Author:

Alexander Trofimov

Message:

Ticket #2523

File:

• trunk/xmlrpc/BxDolXMLRPCSearch.php (modified) (3 diffs)

trunk/xmlrpc/BxDolXMLRPCSearch.php

@@ -34 +34 @@
         $r = db_res ("
             SELECT * FROM `Profiles`
-            WHERE 1 $sWhere
+            WHERE (`Profiles`.`Couple` = 0 OR `Profiles`.`Couple` > `Profiles`.`ID`) $sWhere
             ORDER BY `DateLastNav` DESC
             LIMIT $iStart, $iPP");
@@ -79 +79 @@
             SELECT * " . $sDistance  . " FROM `Profiles`
             $sJoin
-            WHERE 1 $sWhere
+            WHERE (`Profiles`.`Couple` = 0 OR `Profiles`.`Couple` > `Profiles`.`ID`) $sWhere
             ORDER BY `distance` ASC
             LIMIT $iStart, $iPP");
@@ -120 +120 @@
         $r = db_res ("
             SELECT * " . ( $sMatch ? ", $sMatch" : '') . " FROM `Profiles`
-            WHERE 1 $sWhere
+            WHERE (`Profiles`.`Couple` = 0 OR `Profiles`.`Couple` > `Profiles`.`ID`) $sWhere
             ORDER BY `DateLastNav` DESC
             LIMIT $iStart, $iPP");