Changeset 9972 for trunk/admin/notifies.php

Timestamp:

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

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/admin/notifies.php (modified) (7 diffs)

trunk/admin/notifies.php

@@ -39 +39 @@
 
     // Select count of emails in queue per one message
-    $query = "SELECT `sys_mass_messages`.ID, `sys_mass_messages`.Subj, COUNT(`sys_mail_queue`.Email) AS `count_per_msg` FROM `sys_mass_messages` INNER JOIN `sys_mail_queue` ON (`sys_mail_queue`.Msg = `sys_mass_messages`.ID) GROUP BY `sys_mass_messages`.ID";
+    $query = "SELECT `sys_mail_mass_messages`.ID, `sys_mail_mass_messages`.Subj, COUNT(`sys_mail_queue`.Email) AS `count_per_msg` FROM `sys_mail_mass_messages` INNER JOIN `sys_mail_queue` ON (`sys_mail_queue`.Msg = `sys_mail_mass_messages`.ID) GROUP BY `sys_mail_mass_messages`.ID";
     $res = db_res($query);
     if ( !mysql_num_rows($res) )
@@ -116 +116 @@
     $ret = "";
 
-    $query = "SELECT `ID` FROM `sys_mass_messages` WHERE `ID` = $msg_id";
+    $query = "SELECT `ID` FROM `sys_mail_mass_messages` WHERE `ID` = $msg_id";
     $arr_arr = db_arr( $query );
     if ( !$arr_arr )
@@ -247 +247 @@
 function AddMessage()
 {
-    $query = "INSERT INTO `sys_mass_messages` SET `Subj` = '". process_db_input($_POST['subj']) ."', `Text` = '". process_db_input(html2txt($_POST['body_html'])) ."',`HTML` = '". process_db_input($_POST['body_html']) ."'";
+    $query = "INSERT INTO `sys_mail_mass_messages` SET `Subj` = '". process_db_input($_POST['subj']) ."', `Text` = '". process_db_input(html2txt($_POST['body_html'])) ."',`HTML` = '". process_db_input($_POST['body_html']) ."'";
 
     $res = db_res( $query );
@@ -258 +258 @@
 function UpdateMessage()
 {
-    $query = "UPDATE `sys_mass_messages` SET `Subj` = '". process_db_input($_POST['subj']) ."', `Text` = '". process_db_input(html2txt($_POST['body_html'])) ."', `HTML` = '". process_db_input($_POST['body_html']) ."' WHERE ID = '". (int)$_POST['msgs_id'] ."'";
+    $query = "UPDATE `sys_mail_mass_messages` SET `Subj` = '". process_db_input($_POST['subj']) ."', `Text` = '". process_db_input(html2txt($_POST['body_html'])) ."', `HTML` = '". process_db_input($_POST['body_html']) ."' WHERE ID = '". (int)$_POST['msgs_id'] ."'";
 
     $res = db_res( $query );
@@ -293 +293 @@
 function DeleteMessage()
 {
-    $query = "DELETE FROM `sys_mass_messages` WHERE `ID` = ". (int)$_POST['msgs_id'];
+    $query = "DELETE FROM `sys_mail_mass_messages` WHERE `ID` = ". (int)$_POST['msgs_id'];
     if ( !($res = db_res( $query )) )
         return $res;
@@ -384 +384 @@
 <?
 
-$res_msgs = db_res("SELECT `ID`, `Subj`, `Text`, `HTML`, (`ID` = ". (int)$_POST['msgs_id'] ." OR `Subj` = '". process_db_input($_POST['subj']) ."' ) AS `Selected` FROM `sys_mass_messages`");
+$res_msgs = db_res("SELECT `ID`, `Subj`, `Text`, `HTML`, (`ID` = ". (int)$_POST['msgs_id'] ." OR `Subj` = '". process_db_input($_POST['subj']) ."' ) AS `Selected` FROM `sys_mail_mass_messages`");
 while ( $arr_msgs = mysql_fetch_array($res_msgs) )
 {
@@ -413 +413 @@
 elseif ( $_POST['msgs_id'] )
 {
-    $arr = db_arr( "SELECT * FROM `sys_mass_messages` WHERE `ID` = ". (int)$_POST['msgs_id'] );
+    $arr = db_arr( "SELECT * FROM `sys_mail_mass_messages` WHERE `ID` = ". (int)$_POST['msgs_id'] );
     $body_html = $arr['HTML'];
     $body_text = $arr['Text'];