Changeset 8181 for trunk/xmlrpc/BxDolXMLRPCMedia.php

Timestamp:

12/22/08 10:17:31 (3 years ago)

Author:

hihi

Message:

 

File:

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

trunk/xmlrpc/BxDolXMLRPCMedia.php

@@ -3 +3 @@
 class BxDolXMLRPCMedia
 {
-    function getVideoInCategory($sUser, $sPwd, $sNick, $iCatId)
+    function getVideoInCategory($sUser, $sPwd, $sNick, $sCat)
     {
         $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
@@ -9 +9 @@
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));
 
-        $aMedia = array();
-        {
-            $a = array (
-                'id' => new xmlrpcval(1),
-                'title' => new xmlrpcval('title'),
-                'desc' => new xmlrpcval('desc'),
-                'icon' =>new xmlrpcval('http://www.boonex.us/ray/modules/movie/files/941_small.jpg'),
-                'file' =>new xmlrpcval('http://www.boonex.us/111.mp4'),
-                'cat' =>new xmlrpcval(1),
-            );
-            $aMedia[] = new xmlrpcval($a, 'struct');
-
-            $a = array (
-                'id' => new xmlrpcval(2),
-                'title' => new xmlrpcval('title22'),
-                'desc' => new xmlrpcval('desc22'),
-                'icon' =>new xmlrpcval('http://www.boonex.us/ray/modules/movie/files/475_small.jpg'),
-                'file' =>new xmlrpcval('http://www.boonex.us/222.mp4'),
-                'cat' =>new xmlrpcval(1),
-            );
-            $aMedia[] = new xmlrpcval($a, 'struct');
-        }
-
-        return new xmlrpcval ($aMedia, "array");
-
+        global $tmpl;
+        require_once(BX_DIRECTORY_PATH_ROOT . 'templates/tmpl_'.$tmpl.'/scripts/BxTemplSearchSharedVideo.php');
+        $oMedia = new BxTemplSearchSharedVideo();
+        return BxDolXMLRPCMedia::_getFilesInCategory ($oMedia, $iIdProfile, $sCat);
     }
 
-    function getAudioInCategory($sUser, $sPwd, $sNick, $iCatId)
+    function getAudioInCategory($sUser, $sPwd, $sNick, $sCat)
     {
         $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
@@ -42 +21 @@
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));
 
-        $aMedia = array();
-        {
-            $a = array (
-                'id' => new xmlrpcval(1),
-                'title' => new xmlrpcval('title'),
-                'desc' => new xmlrpcval('desc'),
-                'icon' =>new xmlrpcval('http://www.boonex.us/templates/tmpl_uni/images/music.png'),
-                'file' =>new xmlrpcval('http://hihi.s/1.mp3'),
-                'cat' =>new xmlrpcval(1),
-            );
-            $aMedia[] = new xmlrpcval($a, 'struct');
-        }
-
-        return new xmlrpcval ($aMedia, "array");
+        global $tmpl;
+        require_once(BX_DIRECTORY_PATH_ROOT . 'templates/tmpl_'.$tmpl.'/scripts/BxTemplSearchSharedMusic.php');
+        $oMedia = new BxTemplSearchSharedMusic();
+        return BxDolXMLRPCMedia::_getFilesInCategory ($oMedia, $iIdProfile, $sCat);
     }
 
     function getAudioCategories ($sUser, $sPwd, $sNick)
     {
-        return BxDolXMLRPCMedia::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")), "scruct"));
+
+        require_once(BX_DIRECTORY_PATH_CLASSES . 'BxDolSharedMusic.php');
+        $oMedia = new BxDolSharedMusic();         
+
+        return BxDolXMLRPCMedia::_getMediaCategories ($oMedia->sFileTable, $oMedia->aFileFields['medID'], $oMedia->sType, $iIdProfile);
     }
 
@@ -69 +45 @@
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));
 
-        $aRet = array();
-        {
-            $aMedia = array (
-                'Id' => new xmlrpcval(1),
-                'Title' => new xmlrpcval('Title'),
-                'Desc' =>new xmlrpcval('Desc'),
-                'Num' =>new xmlrpcval(1),
-            );
-            $aMedias[] = new xmlrpcval($aMedia, 'struct');
-        }
-        return new xmlrpcval ($aMedias, "array");
+        require_once(BX_DIRECTORY_PATH_CLASSES . 'BxDolSharedVideo.php');
+        $oMedia = new BxDolSharedVideo();         
+
+        return BxDolXMLRPCMedia::_getMediaCategories ($oMedia->sFileTable, $oMedia->aFileFields['medID'], $oMedia->sType, $iIdProfile);
     }
 
+    function _getMediaCategories ($sTable, $sFieldId, $sType, $iIdProfile)
+    {
+        if (!($r = db_res ("
+            SELECT `c`.`Category`, COUNT(`f`.`$sFieldId`) AS `Num`
+            FROM `Categories` AS `c`
+            LEFT JOIN `$sTable` AS `f` ON (`f`.`$sFieldId` = `c`.`ID`)
+            WHERE `c`.`Type` = '$sType' AND (`c`.`Owner` = '0' OR `c`.`Owner` = '$iIdProfile')
+            GROUP BY `c`.`Category`")))
+            return new xmlrpcval (array(), "array");        
+        $aRet = array();
+        while ($a = mysql_fetch_array ($r))
+        {
+            $aImage = array (
+                'Id' => new xmlrpcval($a['Category']),
+                'Title' => new xmlrpcval($a['Category']),
+                'Num' =>new xmlrpcval($a['Num']),
+            );
+            $aImages[] = new xmlrpcval($aImage, 'struct');
+        }
+        return new xmlrpcval ($aImages, "array");
+    }   
+
+    function _getFilesInCategory (&$oMedia, $iIdProfile, $sCat)
+    {      
+        $oMedia->aCurrent['restriction']['owner']['value'] = $iIdProfile;  
+        $oMedia->aCurrent['paginate']['perPage'] = 1000;
+        $oMedia->aCurrent['join']['category'] = array(
+            'type' => 'left',
+            'table' => 'Categories',
+            'mainField' => $oMedia->aPseud['id'],
+            'onField' => 'ID',
+            'joinFields' => array('Category')
+        );
+        $oMedia->aCurrent['restriction']['category'] = array(
+            'value' => $sCat,
+            'field' => 'Category',
+            'operator' => '=',
+            'table' => 'Categories' 
+        );         
+
+        $aFiles = array();
+        $a = $oMedia->getSearchData();
+        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($aRow['size']),
+                'icon' =>new xmlrpcval($oMedia->getImgUrl($aRow['id'], 'icon')),
+                'file' =>new xmlrpcval($oMedia->getImgUrl($aRow['id'], 'file')),
+                'cat' =>new xmlrpcval($sCat),
+            );
+            $aFiles[] = new xmlrpcval($a, 'struct');
+        }
+
+        return new xmlrpcval ($aFiles, "array");
+    }
 }