Changeset 9969 for trunk/admin/manage_subscribers.php

Timestamp:

04/06/09 03:52:46 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/admin/manage_subscribers.php (modified) (5 diffs)

trunk/admin/manage_subscribers.php

@@ -158 +158 @@
 EOF;
 
-        $sCntSQL = "SELECT COUNT(*) FROM `NotifyEmails`";
+        $sCntSQL = "SELECT COUNT(*) FROM `sys_subscriptions`";
         ////////////////////////////
         $iTotalNum = db_value( $sCntSQL );
@@ -178 +178 @@
         ////////////////////////////
 
-        $sSQL = "SELECT * FROM `NotifyEmails` ORDER BY `EmailFlag` ASC, `ID` {$sqlLimit}";
+        $sSQL = "SELECT * FROM `sys_subscriptions` ORDER BY `EmailFlag` ASC, `ID` {$sqlLimit}";
         $vSubscribers = db_res( $sSQL );
 
@@ -255 +255 @@
         $sName = process_db_input($_REQUEST['name']);
         if ($iID>0) {
-            $sDeleteSQL = "UPDATE `NotifyEmails` SET `Email`='{$sName}' WHERE `ID`='{$iID}' LIMIT 1";
+            $sDeleteSQL = "UPDATE `sys_subscriptions` SET `Email`='{$sName}' WHERE `ID`='{$iID}' LIMIT 1";
             db_res($sDeleteSQL);
         }
@@ -263 +263 @@
         $iID = (int)$_REQUEST['id'];
         if ($iID>0) {
-            $sDeleteSQL = "DELETE FROM `NotifyEmails` WHERE `ID`='{$iID}' LIMIT 1";
+            $sDeleteSQL = "DELETE FROM `sys_subscriptions` WHERE `ID`='{$iID}' LIMIT 1";
             db_res($sDeleteSQL);
         }
@@ -274 +274 @@
         }
         $sInArr = implode(",", $aKeys);
-        $sDeleteSQL = "DELETE FROM `NotifyEmails` WHERE `ID` IN ({$sInArr})";
+        $sDeleteSQL = "DELETE FROM `sys_subscriptions` WHERE `ID` IN ({$sInArr})";
         db_res($sDeleteSQL);
     }