Changeset 7936 for trunk/xmlrpc

Timestamp:

12/09/08 10:52:37 (3 years ago)

Author:

hihi

Message:

 

Location:

trunk/xmlrpc

Files:

• BxDolXMLRPCFriends.php (modified) (5 diffs)
• BxDolXMLRPCImages.php (modified) (2 diffs)
• BxDolXMLRPCMedia.php (modified) (4 diffs)
• BxDolXMLRPCUser.php (modified) (2 diffs)
• BxDolXMLRPCUtil.php (modified) (2 diffs)
• index.php (modified) (1 diff)

trunk/xmlrpc/BxDolXMLRPCFriends.php

@@ -5 +5 @@
     function getFriends($sUser, $sPwd, $sNick)
     {
-        $iIdProfile = (int)db_value ("SELECT `ID` FROM `Profiles` WHERE `NickName` = '$sNick' LIMIT 1");
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
         if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));
@@ -40 +40 @@
     function declineFriendRequest($sUser, $sPwd, $sNick)
     {
-        $iIdProfile = (int)db_value ("SELECT `ID` FROM `Profiles` WHERE `NickName` = '$sNick' LIMIT 1");
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
         if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));
@@ -59 +59 @@
     function acceptFriendRequest($sUser, $sPwd, $sNick)
     {
-        $iIdProfile = (int)db_value ("SELECT `ID` FROM `Profiles` WHERE `NickName` = '$sNick' LIMIT 1");
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
         if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));            
@@ -78 +78 @@
     function removeFriend($sUser, $sPwd, $sNick)
     {
-        $iIdProfile = (int)db_value ("SELECT `ID` FROM `Profiles` WHERE `NickName` = '$sNick' LIMIT 1");
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
         if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));
@@ -97 +97 @@
     function addFriend($sUser, $sPwd, $sNick, $sLang)
     {
-        $iIdProfile = (int)db_value ("SELECT `ID` FROM `Profiles` WHERE `NickName` = '$sNick' LIMIT 1");
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
         if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));

trunk/xmlrpc/BxDolXMLRPCImages.php

@@ -10 +10 @@
     function getImagesInCategory($sUser, $sPwd, $sNick, $iCatId)
     {
-        $iIdProfile = (int)db_value ("SELECT `ID` FROM `Profiles` WHERE `NickName` = '$sNick' LIMIT 1");
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
         if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));
@@ -61 +61 @@
     function getImageCategories ($sUser, $sPwd, $sNick)
     {
-        $iIdProfile = (int)db_value ("SELECT `ID` FROM `Profiles` WHERE `NickName` = '$sNick' LIMIT 1");
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
         if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));

trunk/xmlrpc/BxDolXMLRPCMedia.php

@@ -5 +5 @@
     function getVideoInCategory($sUser, $sPwd, $sNick, $iCatId)
     {
-        $iIdProfile = (int)db_value ("SELECT `ID` FROM `Profiles` WHERE `NickName` = '$sNick' LIMIT 1");
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
         if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));
@@ -20 +20 @@
             );
             $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');
         }
 
@@ -28 +38 @@
     function getAudioInCategory($sUser, $sPwd, $sNick, $iCatId)
     {
-        $iIdProfile = (int)db_value ("SELECT `ID` FROM `Profiles` WHERE `NickName` = '$sNick' LIMIT 1");
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
         if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));
@@ -55 +65 @@
     function getVideoCategories ($sUser, $sPwd, $sNick)
     {
-        $iIdProfile = (int)db_value ("SELECT `ID` FROM `Profiles` WHERE `NickName` = '$sNick' LIMIT 1");
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
         if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));

trunk/xmlrpc/BxDolXMLRPCUser.php

@@ -25 +25 @@
     function getUserInfo($sUser, $sPwd, $sNick)
     {
-        $iIdProfile = (int)db_value ("SELECT `ID` FROM `Profiles` WHERE `NickName` = '$sNick' LIMIT 1");
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
         if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));
@@ -35 +35 @@
     function getUserInfoExtra($sUser, $sPwd, $sNick, $sLang)
     {
-        $iIdProfile = (int)db_value ("SELECT `ID` FROM `Profiles` WHERE `NickName` = '$sNick' LIMIT 1");
+        $iIdProfile = BxDolXMLRPCUtil::getIdByNickname ($sNick);
         if (!$iIdProfile || !($iId = BxDolXMLRPCUtil::checkLogin ($sUser, $sPwd)))
             return new xmlrpcresp(new xmlrpcval(array('error' => new xmlrpcval(1,"int")), "scruct"));

trunk/xmlrpc/BxDolXMLRPCUtil.php

@@ -11 +11 @@
         $aAll = array();
         $aContacts = array ();
+
+        // hot list
+        $r = db_res ("SELECT `p`.`ID`, `p`.`NickName` AS `Nick` FROM `Profiles` AS `p`
+            INNER JOIN `HotList` AS `h` ON (`h`.`Profile` = `p`.`ID`) 
+            WHERE `h`.`ID` = $iId");
+        while ($aRow = mysql_fetch_array ($r))
+            $aAll[$aRow['ID']] = $aRow;
 
         // mail contacts received
@@ -108 +115 @@
     }
 
+    function getIdByNickname ($sUser)
+    {
+        return (int)db_value("SELECT `ID` FROM `Profiles` WHERE `NickName` = '$sUser' LIMIT 1");
+    }
+
     function checkLogin ($sUser, $sPwd)
     {
         //sleep(1);
-        $iId = (int)db_value("SELECT `ID` FROM `Profiles` WHERE `NickName` = '$sUser'");
+        $iId = BxDolXMLRPCUtil::getIdByNickname ($sUser);
         $_COOKIE["memberID" ] = $iId;
         $_COOKIE["memberPassword"] = $sPwd;

trunk/xmlrpc/index.php

@@ -3 +3 @@
     require_once(BX_DIRECTORY_PATH_INC . 'admin.inc.php');
 
-    require_once(BX_DIRECTORY_PATH_ROOT . 'xmlrpc/BxDolXMLRPCUtil.php');
+    require_once(BX_DIRECTORY_PATH_ROOT . 'xmlrpc/BxDolXMLRPCUtil.php');    
     require_once(BX_DIRECTORY_PATH_ROOT . 'xmlrpc/BxDolXMLRPCUser.php');
     require_once(BX_DIRECTORY_PATH_ROOT . 'xmlrpc/BxDolXMLRPCMessages.php');