Changeset 9985 for trunk/xmlrpc

Timestamp:

04/06/09 23:30:15 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

Location:

trunk/xmlrpc

Files:

• BxDolXMLRPCMedia.php (modified) (1 diff)
• BxDolXMLRPCMessages.php (modified) (3 diffs)
• BxDolXMLRPCProfileView.php (modified) (1 diff)
• BxDolXMLRPCUtil.php (modified) (2 diffs)

trunk/xmlrpc/BxDolXMLRPCMedia.php

@@ -66 +66 @@
         if (!($r = db_res ("
             SELECT `c`.`Category`, COUNT(`f`.`$sFieldId`) AS `Num`
-            FROM `Categories` AS `c`
+            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')

trunk/xmlrpc/BxDolXMLRPCMessages.php

@@ -59 +59 @@
                 `m`.`ID`, `m`.`Date`, `m`.`Sender`, `m`.`Recipient`, `m`.`Subject`, `m`.`Text`, `m`.`New`, 
                 `p`.`NickName` AS `Nick` 
-            FROM `Messages` AS `m`
+            FROM `sys_messages` AS `m`
             LEFT JOIN `Profiles` AS `p` ON ($sJoinOn)
             WHERE `m`.`ID` = '$iMsgId'");
@@ -77 +77 @@
             );
             if ($isInbox && $aRow['New'])
-                db_res("UPDATE `Messages` SET `New` = 0 WHERE `ID` = '$iMsgId'");
+                db_res("UPDATE `sys_messages` SET `New` = 0 WHERE `ID` = '$iMsgId'");
         }
         else
@@ -98 +98 @@
                 `m`.`ID`, `m`.`Date`, `m`.`Sender`, `m`.`Recipient`, `m`.`Subject`, `m`.`New`, 
                 `p`.`NickName` AS `Nick` 
-            FROM `Messages` AS `m`
+            FROM `sys_messages` AS `m`
             LEFT JOIN `Profiles` AS `p` ON ($sJoinOn)
             WHERE $sWhere 

trunk/xmlrpc/BxDolXMLRPCProfileView.php

@@ -13 +13 @@
     {
         $aRet = array();
-        $r = db_res ("SELECT `pc`.`Caption`, `pc`.`Content` FROM `ProfileFields` AS `pf` INNER JOIN `sys_page_compose` AS `pc` ON (`pc`.`Func` = 'PFBlock' AND `pc`.`Content` = `pf`.`ID`) WHERE `pf`.`Type` = 'block' AND `pc`.`Column` != 0 ORDER BY `pc`.`Column`, `pc`.`Order`");
+        $r = db_res ("SELECT `pc`.`Caption`, `pc`.`Content` FROM `sys_profile_fields` AS `pf` INNER JOIN `sys_page_compose` AS `pc` ON (`pc`.`Func` = 'PFBlock' AND `pc`.`Content` = `pf`.`ID`) WHERE `pf`.`Type` = 'block' AND `pc`.`Column` != 0 ORDER BY `pc`.`Column`, `pc`.`Order`");
         while ($a = mysql_fetch_array($r))
         {

trunk/xmlrpc/BxDolXMLRPCUtil.php

@@ -21 +21 @@
         // mail contacts received
         $r = db_res ("SELECT `p`.`ID`, `p`.`NickName` AS `Nick` FROM `Profiles` AS `p`
-            INNER JOIN `Messages` AS `m` ON (`m`.`Sender` = `p`.`ID`) 
+            INNER JOIN `sys_messages` AS `m` ON (`m`.`Sender` = `p`.`ID`) 
             WHERE `p`.`ID` != $iId AND `m`.`Recipient` = $iId");
         while ($aRow = mysql_fetch_array ($r))
@@ -28 +28 @@
         // mail contacts sent
         $r = db_res ("SELECT `p`.`ID`, `p`.`NickName` AS `Nick` FROM `Profiles` AS `p`
-            INNER JOIN `Messages` AS `m` ON (`m`.`Recipient` = `p`.`ID`)
+            INNER JOIN `sys_messages` AS `m` ON (`m`.`Recipient` = `p`.`ID`)
             WHERE `p`.`ID` != $iId AND `m`.`Sender` = $iId");
         while ($aRow = mysql_fetch_array ($r))