Changeset 9985 for trunk/templates/base/scripts/BxBaseMailBox.php

Timestamp:

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

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/templates/base/scripts/BxBaseMailBox.php (modified) (7 diffs)

trunk/templates/base/scripts/BxBaseMailBox.php

@@ -183 +183 @@
                     `Sender`, `Recipient`
                 FROM 
-                    `Messages` 
+                    `sys_messages` 
                 WHERE 
                     `ID` = {$this -> aMailBoxSettings['messageID']}
@@ -316 +316 @@
                     DATE_FORMAT(`Date`, '%d.%m.%Y %H:%i') AS `Date`
                 FROM 
-                    `Messages` 
+                    `sys_messages` 
                 WHERE 
                     `ID` = {$this -> aMailBoxSettings['messageID']} 
@@ -1262 +1262 @@
                                 `Subject` 
                             FROM 
-                                `Messages` 
+                                `sys_messages` 
                             WHERE 
                                 `ID` = {$iMessageID} 
@@ -1355 +1355 @@
                     COUNT(*) 
                 FROM 
-                    `Messages` 
+                    `sys_messages` 
                 WHERE 
                     `Sender` = {$iMemberId}
@@ -1369 +1369 @@
                     COUNT(*) 
                 FROM 
-                    `Messages` 
+                    `sys_messages` 
                 WHERE 
                     (
@@ -1390 +1390 @@
                 COUNT( DISTINCT if(`Recipient` = {$iMemberId}, `Sender`, `Recipient`) ) AS `Contacts` 
             FROM 
-                `Messages` 
+                `sys_messages` 
             WHERE
                 `Sender` = {$iMemberId} 
@@ -1409 +1409 @@
                         `ID`, `Sender`, `Subject`
                     FROM 
-                        `Messages` 
+                        `sys_messages` 
                     WHERE 
                         `Recipient`={$iMemberId}