Changeset 12465 for trunk/xmlrpc/BxDolXMLRPCSearch.php

Timestamp:

08/28/09 05:41:07 (3 years ago)

Author:

Alexander Trofimov

Message:

 

File:

• trunk/xmlrpc/BxDolXMLRPCSearch.php (modified) (1 diff)

trunk/xmlrpc/BxDolXMLRPCSearch.php

@@ -33 +33 @@
             WHERE 1 $sWhere
             ORDER BY `DateLastNav` DESC
+            LIMIT $iStart, $iPP");
+
+        while ($aRow = mysql_fetch_array ($r))
+            $aProfiles[] = new xmlrpcval(BxDolXMLRPCUtil::fillProfileArray($aRow, 'thumb'), 'struct');
+
+        return new xmlrpcval ($aProfiles, "array");
+    }
+
+    function getSearchResultsNearMe($sUser, $sPwd, $sLang, $sLat, $sLng, $isOnlineOnly, $isWithPhotosOnly, $iStart, $iPP)
+    {
+        if (!($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
+            return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "struct"));
+
+        BxDolXMLRPCUtil::setLanguage ($sLang); 
+
+        $sWhere = '';
+        $sJoin = '';
+        $sLocation = '';
+        if ($sLat && $sLng)
+        {
+            $sDistance = ", (POW($sLat-`loc`.`lat`, 2)+POW($sLng-`loc`.`lng`, 2)) AS `distance`";
+            $sJoin .= " INNER JOIN `bx_map_profiles` AS `loc` ON  (`loc`.`id` = `ID` AND `loc`.`failed` = 0) ";
+        }
+        if ($isWithPhotosOnly)
+            $sWhere .= " AND `Avatar` ";
+        if ($isOnlineOnly) 
+        {
+            $iOnlineTime = getParam( 'member_online_time' );
+            $sWhere .= " AND `DateLastNav` >= DATE_SUB(NOW(), INTERVAL $iOnlineTime MINUTE)";
+        }
+        $iStart = (int)$iStart;
+        if (!$iStart || $iStart < 0)
+            $iStart = 0;
+        $iPP = (int)$iPP;
+        if (!$iPP || $iPP < 1)
+            $iPP = 1;
+
+        $r = db_res ("
+            SELECT * " . $sDistance  . " FROM `Profiles`
+            $sJoin
+            WHERE 1 $sWhere
+            ORDER BY `distance` ASC
             LIMIT $iStart, $iPP");