Changeset 7756 for trunk/xmlrpc/BxDolXMLRPCImages.php

Timestamp:

11/27/08 11:46:21 (3 years ago)

Author:

hihi

Message:

 

File:

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

trunk/xmlrpc/BxDolXMLRPCImages.php

@@ -20 +20 @@
                 'id' => new xmlrpcval($aRow['id']),
                 'title' => new xmlrpcval($aRow['title']),
+                'desc' => new xmlrpcval($aRow['desc']),
+                'icon' =>new xmlrpcval($aRow['icon']),
                 'image' =>new xmlrpcval($aRow['medium']),
             );
@@ -35 +37 @@
 
         if (!($r = db_res ("
-            SELECT `pc`.`ID`, `pc`.`Title`, `pc`.`Desc`, COUNT(`pf`.`medID`) AS `num`
+            SELECT `pc`.`ID`, `pc`.`Title`, `pc`.`Desc`, COUNT(`pf`.`medID`) AS `Num`
             FROM `sharePhotoCategories` AS `pc`
-            INNER JOIN `sharePhotoFiles` AS `pf` ON (`pf`.`CategoryId` = `pc`.`ID`)
-            WHERE `pf`.`medProfId` = '$iIdProfile'
+            LEFT JOIN `sharePhotoFiles` AS `pf` ON (`pf`.`CategoryId` = `pc`.`ID` AND `pf`.`medProfId` = '$iIdProfile')
             GROUP BY `pc`.`ID`
             ORDER BY `pc`.`Order`")))
@@ -46 +47 @@
         while ($a = mysql_fetch_array ($r))
         {
-            $a = array (
-                'Id' => new xmlrpcval($aRow['ID']),
-                'Title' => new xmlrpcval($aRow['Title']),
-                'Desc' =>new xmlrpcval($aRow['Desc']),
+            $aImage = array (
+                'Id' => new xmlrpcval($a['ID']),
+                'Title' => new xmlrpcval($a['Title']),
+                'Desc' =>new xmlrpcval($a['Desc']),
+                'Num' =>new xmlrpcval($a['Num']),
             );
-            $aImages[] = new xmlrpcval($a, 'struct');
+            $aImages[] = new xmlrpcval($aImage, 'struct');
         }
         return new xmlrpcval ($aImages, "array");