Changeset 11418 for trunk/xmlrpc/BxDolXMLRPCMedia.php

Timestamp:

07/15/09 05:07:42 (3 years ago)

Author:

Alexander Trofimov

Message:

XMLRPC media queries for albuns

File:

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

trunk/xmlrpc/BxDolXMLRPCMedia.php

@@ -3 +3 @@
 class BxDolXMLRPCMedia
 {
+    // ------------------ get files in category
+    
     function getVideoInCategory($sUser, $sPwd, $sNick, $sCat)
     {
@@ -20 +22 @@
         return BxDolXMLRPCMedia::_getFilesInCategory ('sounds', $iIdProfile, $sCat);
     }
-
-    function getAudioCategories ($sUser, $sPwd, $sNick)
-    {
-        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
-        if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
-            return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "struct"));
-
-        return BxDolXMLRPCMedia::_getMediaCategories ('music', $iIdProfile);
-    }
-
-    function getVideoCategories ($sUser, $sPwd, $sNick)
-    {
-        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
-        if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
-            return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "struct"));
-
-        return BxDolXMLRPCMedia::_getMediaCategories ('video', $iIdProfile);
-    }
-
-    function _getMediaCategories ($sType, $iIdProfile)
-    {
-        switch ($sType) {
-            case 'photo':
-                $sTable = 'bx_photos_files';
-                $sFieldId = 'ID';
-                $sFieldOwner = 'Owner';
-                $sType = 'bx_photos';
-                break;
-            case 'video':
-                $sTable = 'RayVideoFiles';
-                $sFieldId = 'ID';
-                $sFieldOwner = 'Owner';
-                $sType = 'bx_videos';
-                break;
-            case 'music':
-                $sTable = 'RayMp3Files';
-                $sFieldId = 'ID';
-                $sFieldOwner = 'Owner';
-                $sType = 'bx_sounds';
-                break;          
-            default:
-                return new xmlrpcval (array(), "array");
-        }
-
-        if (!($r = db_res ("
-            SELECT `c`.`Category`, COUNT(`f`.`$sFieldId`) AS `Num`
-            FROM `sys_categories` AS `c`
-            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`")))
-            return new xmlrpcval (array(), "array");
-        $aFiles = array ();
-        while ($a = mysql_fetch_array ($r))
-        {
-            $aFile = array (
-                'Id' => new xmlrpcval($a['Category']),
-                'Title' => new xmlrpcval($a['Category']),
-                'Num' =>new xmlrpcval($a['Num']),
-            );
-            $aFiles[] = new xmlrpcval($aFile, 'struct');
-        }
-        return new xmlrpcval ($aFiles, "array");
-    }   
 
     function _getFilesInCategory ($sModuleName, $iIdProfile, $sCat)
@@ -106 +45 @@
         return new xmlrpcval ($aFiles, "array");
     }
+
+    // ------------------ categories list
+
+    function getAudioCategories ($sUser, $sPwd, $sNick)
+    {
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
+        if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
+            return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "struct"));
+
+        return BxDolXMLRPCMedia::_getMediaCategories ('music', $iIdProfile);
+    }
+
+    function getVideoCategories ($sUser, $sPwd, $sNick)
+    {
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
+        if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
+            return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "struct"));
+
+        return BxDolXMLRPCMedia::_getMediaCategories ('video', $iIdProfile);
+    }
+
+    function _getMediaCategories ($sType, $iIdProfile)
+    {
+        switch ($sType) {
+            case 'photo':
+                $sTable = 'bx_photos_files';
+                $sFieldId = 'ID';
+                $sFieldOwner = 'Owner';
+                $sType = 'bx_photos';
+                break;
+            case 'video':
+                $sTable = 'RayVideoFiles';
+                $sFieldId = 'ID';
+                $sFieldOwner = 'Owner';
+                $sType = 'bx_videos';
+                break;
+            case 'music':
+                $sTable = 'RayMp3Files';
+                $sFieldId = 'ID';
+                $sFieldOwner = 'Owner';
+                $sType = 'bx_sounds';
+                break;          
+            default:
+                return new xmlrpcval (array(), "array");
+        }
+
+        if (!($r = db_res ("
+            SELECT `c`.`Category`, COUNT(`f`.`$sFieldId`) AS `Num`
+            FROM `sys_categories` AS `c`
+            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`")))
+            return new xmlrpcval (array(), "array");
+        $aFiles = array ();
+        while ($a = mysql_fetch_array ($r))
+        {
+            $aFile = array (
+                'Id' => new xmlrpcval($a['Category']),
+                'Title' => new xmlrpcval($a['Category']),
+                'Num' =>new xmlrpcval($a['Num']),
+            );
+            $aFiles[] = new xmlrpcval($aFile, 'struct');
+        }
+        return new xmlrpcval ($aFiles, "array");
+    }   
+
+    // ----------------- albums list
+
+    function getAudioAlbums ($sUser, $sPwd, $sNick)
+    {
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
+        if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
+            return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "struct"));
+
+        return BxDolXMLRPCMedia::_getMediaAlbums ('music', $iIdProfile);
+    }
+
+    function getVideoAlbums ($sUser, $sPwd, $sNick)
+    {
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
+        if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
+            return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "struct"));
+
+        return BxDolXMLRPCMedia::_getMediaAlbums ('video', $iIdProfile);
+    }
+
+    function _getMediaAlbums ($sType, $iIdProfile) 
+    {        
+        switch ($sType) {
+            case 'photo':
+                $sType = 'bx_photos';
+                break;
+            case 'video':
+                $sType = 'bx_videos';
+                break;
+            case 'music':
+                $sType = 'bx_sounds';
+                break;          
+            default:
+                return new xmlrpcval (array(), "array");
+        }
+        bx_import('BxDolAlbums');
+        $o = new BxDolAlbums ($sType, $iIdProfile);
+        $aList = $o->getAlbumList (array('owner' => $iIdProfile));
+        $aXmlRpc = array ();
+        while ($aList = mysql_fetch_array ($r))
+        {
+            $a = array (
+                'Id' => new xmlrpcval($a['ID']),
+                'Title' => new xmlrpcval($a['Caption']),
+                'Num' =>new xmlrpcval($a['ObjCount']),
+            );
+            $aXmlRpc[] = new xmlrpcval($aFile, 'struct');
+        }
+        return new xmlrpcval ($aXmlRpc, "array");
+    }    
+
+    // ----------------- file list in albums 
+
+    function getVideoInAlbum($sUser, $sPwd, $sNick, $iAlbumId)
+    {
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
+        if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
+            return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "struct"));
+
+        return BxDolXMLRPCMedia::_getFilesInAlbum ('videos', $iIdProfile, $iAlbumId);
+    }
+
+    function getAudioInAlbum($sUser, $sPwd, $sNick, $iAlbumId)
+    {
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
+        if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
+            return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "struct"));
+
+        return BxDolXMLRPCMedia::_getFilesInAlbum ('sounds', $iIdProfile, $iAlbumId);
+    }
+
+    function _getFilesInAlbum ($sModuleName, $iIdProfile, $iAlbumId)
+    {     
+        $a = BxDolService::call ($sModuleName, 'get_files_in_album', array($iAlbumId), 'Search');
+        if (!$a)
+            return new xmlrpcval (array(), "array");
+        foreach ($a as $k => $aRow)
+        {
+            $a = array (
+                'id' => new xmlrpcval($aRow['id']),
+                'title' => new xmlrpcval($aRow['title']),
+                'desc' => new xmlrpcval(BxDolService::call ($sModuleName, 'get_length', array($aRow['size']), 'Search')),
+                'icon' => new xmlrpcval($aRow['icon']),
+                'thumb' => new xmlrpcval($aRow['thumb']),
+                'file' => new xmlrpcval($aRow['file']),
+                'cat' => new xmlrpcval($sCat),
+                'rate' => new xmlrpcval($aRow['voting_rate']),
+                'rate_count' => new xmlrpcval((int)$aRow['voting_count']),
+            );
+            $aFiles[] = new xmlrpcval($a, 'struct');
+        }
+        return new xmlrpcval ($aFiles, "array");
+    }    
 }