Changeset 9972 for trunk/periodic/notifies.php

Timestamp:

04/06/09 04:21:27 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/periodic/notifies.php (modified) (2 diffs)

trunk/periodic/notifies.php

@@ -69 +69 @@
                 `sys_subscriptions`.Name as Name,
                 `sys_subscriptions`.Email,
-                `sys_mass_messages`.Subj,
-                `sys_mass_messages`.HTML as Body
+                `sys_mail_mass_messages`.Subj,
+                `sys_mail_mass_messages`.HTML as Body
             FROM `sys_mail_queue`
-            INNER JOIN `sys_mass_messages` ON
-                (`sys_mass_messages`.ID =  `sys_mail_queue`.Msg)
+            INNER JOIN `sys_mail_mass_messages` ON
+                (`sys_mail_mass_messages`.ID =  `sys_mail_queue`.Msg)
             INNER JOIN `sys_subscriptions` ON
                 (`sys_subscriptions`.ID = `sys_mail_queue`.Email)
@@ -106 +106 @@
                 Profiles.NickName as Name,
                 Profiles.Email,
-                `sys_mass_messages`.Subj,
-                `sys_mass_messages`.HTML as Body
+                `sys_mail_mass_messages`.Subj,
+                `sys_mail_mass_messages`.HTML as Body
             FROM `sys_mail_queue`           
-            INNER JOIN `sys_mass_messages` ON
-                (`sys_mass_messages`.ID =  `sys_mail_queue`.Msg)
+            INNER JOIN `sys_mail_mass_messages` ON
+                (`sys_mail_mass_messages`.ID =  `sys_mail_queue`.Msg)
             INNER JOIN Profiles ON
                 (Profiles.ID = `sys_mail_queue`.Email)