Changeset 15627 for tags

Timestamp:

10/18/11 00:45:13 (7 months ago)

Author:

Alexander Trofimov

Message:

Ticket #2680

File:

• tags/7.0/xmlrpc/BxDolXMLRPCSearch.php (modified) (3 diffs)

tags/7.0/xmlrpc/BxDolXMLRPCSearch.php

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