Changeset 8701 for trunk/xmlrpc/BxDolXMLRPCMedia.php

Timestamp:

01/21/09 05:52:40 (3 years ago)

Author:

Alexander Trofimov

Message:

 

File:

• trunk/xmlrpc/BxDolXMLRPCMedia.php (modified) (2 diffs)

trunk/xmlrpc/BxDolXMLRPCMedia.php

@@ -45 +45 @@
                 $sTable = 'bx_shared_photo_files';
                 $sFieldId = 'medID';
+                $sFieldOwner = 'medProfId';
                 break;
             case 'video':
                 $sTable = 'RayVideoFiles';
                 $sFieldId = 'ID';
+                $sFieldOwner = 'Owner';
                 break;
             case 'music':
                 $sTable = 'RayMp3Files';
                 $sFieldId = 'ID';
+                $sFieldOwner = 'Owner';
                 break;          
             default:
@@ -61 +64 @@
             SELECT `c`.`Category`, COUNT(`f`.`$sFieldId`) AS `Num`
             FROM `Categories` AS `c`
-            LEFT JOIN `$sTable` AS `f` ON (`f`.`$sFieldId` = `c`.`ID`)
+            LEFT JOIN `$sTable` AS `f` ON (`f`.`$sFieldId` = `c`.`ID` AND `f`.`$sFieldOwner` = '$iIdProfile')
             WHERE `c`.`Type` = '$sType' AND (`c`.`Owner` = '0' OR `c`.`Owner` = '$iIdProfile')
             GROUP BY `c`.`Category`")))