X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=0.2.1%2Finc%2Fmodules%2Fadmin%2Fwhat-admins_mails.php;h=1ed0fe9d81075c6d0fb546ec7f37f98a6bd8aced;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hp=54f166dd35886b389a48d759196732a159675177;hpb=157ee010917df5ca07e6d31b42f67417b2516d74;p=mailer.git
diff --git a/0.2.1/inc/modules/admin/what-admins_mails.php b/0.2.1/inc/modules/admin/what-admins_mails.php
index 54f166dd35..1ed0fe9d81 100644
--- a/0.2.1/inc/modules/admin/what-admins_mails.php
+++ b/0.2.1/inc/modules/admin/what-admins_mails.php
@@ -1,197 +1,197 @@
- 0)
- {
- // Add option for userlog
- $ADMINS = ADD_OPTION_LINES("admins", "id", "login", "", "email");
- $SW = 2; $ROWS = "";
- foreach ($_POST['sel'] as $template=>$sel)
- {
- // First of all load data from DB
- $result = SQL_QUERY_ESC("SELECT admin_id, id FROM "._MYSQL_PREFIX."_admins_mails WHERE mail_template='%s' ORDER BY id",
- array($template), __FILE__, __LINE__);
- $OUT = ""; $aid = "0"; $aid2 = "0";
- while (list($aid, $id) = SQL_FETCHROW($result))
- {
- $OUT .= "
\n";
- $aid2 = $aid; $id2 = $id;
- }
-
- // Free memory
- SQL_FREERESULT($result);
-
- $content = array(
- 'sw' => $SW,
- 'id' => $id,
- 'id2' => $id2,
- 'tpl' => $template,
- 'admins' => $ADMINS
- );
-
- if ($aid2 > 0)
- {
- // Add form for an additional admin
- $OUT .= LOAD_TEMPLATE("admin_admins_mails_edit_form", true, $content);
- }
- // Save full rendered content
- $content['content'] = $OUT;
-
- // Start outputing line
- $ROWS .= LOAD_TEMPLATE("admin_admins_mails_edit_row", true, $content);
- $SW = 3 - $SW;
- }
- define('__ADMINS_ROWS', $ROWS);
-
- // Edit checked entries
- LOAD_TEMPLATE("admin_admins_mails_edit");
- }
- else
- {
- // Nothing selected
- LOAD_TEMPLATE("admin_settings_saved", false, ADMINS_NO_MAIL_CHECKED);
- }
-}
- else
-{
- // Load all assigned mails
- $result = SQL_QUERY("SELECT DISTINCT m.id, m.admin_id, a.login, m.mail_template
-FROM "._MYSQL_PREFIX."_admins_mails AS m
-LEFT JOIN "._MYSQL_PREFIX."_admins AS a
-ON m.admin_id=a.id
-WHERE (m.admin_id=a.id OR m.admin_id < 1) AND m.mail_template != ''
-ORDER BY m.admin_id, m.mail_template", __FILE__, __LINE__);
-
- if (SQL_NUMROWS($result) > 0)
- {
- // Shall I change entries?
- if (isset($_POST['change']))
- {
- // Ok, update database
- foreach ($_POST['admin_id'] as $id=>$aid)
- {
- // Secure IDs
- $id = bigintval($id);
- $aid = bigintval($aid);
-
- // Update entry
- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_admins_mails SET admin_id=%d WHERE id=%d ORDER BY id LIMIT 1",
- array($aid, $id), __FILE__, __LINE__);
-
- if (($aid < 1) && (!empty($_POST['template'][$id])))
- {
- // Remove any other admin entries
- $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admins_mails WHERE mail_template='%s' AND id != '%s'",
- array($_POST['template'][$id], $id), __FILE__, __LINE__);
- }
- if ($_POST['admin_new'][$_POST['template'][$id]] > 0)
- {
- // Add new admin
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_admins_mails (admin_id, mail_template) VALUES ('%s', '%s')",
- array($aid, $_POST['template'][$id]), __FILE__, __LINE__);
- }
- }
-
- // Query again...
- $result = SQL_QUERY("SELECT DISTINCT m.id, m.admin_id, a.login, m.mail_template FROM "._MYSQL_PREFIX."_admins_mails AS m, "._MYSQL_PREFIX."_admins AS a WHERE m.admin_id=a.id OR m.admin_id < 1 ORDER BY m.admin_id", __FILE__, __LINE__);
- }
-
- // List found entries
- $SW = 2; $OUT = "";
- while(list($id, $aid, $admin, $templ) = SQL_FETCHROW($result))
- {
- if ($aid > 0)
- {
- // Admin assigned
- $admin_link = "".$admin."";
- }
- elseif ($aid == 0)
- {
- // All admins
- $admin_link = "".ADMINS_ALL_ADMINS."";
- }
- elseif (($aid == -1) && (EXT_IS_ACTIVE("usrlog")))
- {
- // To userlog
- $admin_link = "".ADMINS_TO_USERLOG."";
- }
- $content = array(
- 'sw' => $SW,
- 'tpl' => $templ,
- 'alnk' => $admin_link
- );
-
- // Load row template
- $OUT .= LOAD_TEMPLATE("admin_admins_mails_list_row", true, $content);
- $SW = 3 - $SW;
- }
-
- // Free result
- SQL_FREERESULT($result);
- define('__MAILS_ROWS', $OUT);
-
- // Load template
- LOAD_TEMPLATE("admin_admins_mails_list");
- }
- else
- {
- // No entries found
- LOAD_TEMPLATE("admin_settings_saved", false, ADMINS_MAILS_NO_ENTRIES);
- }
-}
-//
-?>
+ 0)
+ {
+ // Add option for userlog
+ $ADMINS = ADD_OPTION_LINES("admins", "id", "login", "", "email");
+ $SW = 2; $ROWS = "";
+ foreach ($_POST['sel'] as $template=>$sel)
+ {
+ // First of all load data from DB
+ $result = SQL_QUERY_ESC("SELECT admin_id, id FROM "._MYSQL_PREFIX."_admins_mails WHERE mail_template='%s' ORDER BY id",
+ array($template), __FILE__, __LINE__);
+ $OUT = ""; $aid = "0"; $aid2 = "0";
+ while (list($aid, $id) = SQL_FETCHROW($result))
+ {
+ $OUT .= "
\n";
+ $aid2 = $aid; $id2 = $id;
+ }
+
+ // Free memory
+ SQL_FREERESULT($result);
+
+ $content = array(
+ 'sw' => $SW,
+ 'id' => $id,
+ 'id2' => $id2,
+ 'tpl' => $template,
+ 'admins' => $ADMINS
+ );
+
+ if ($aid2 > 0)
+ {
+ // Add form for an additional admin
+ $OUT .= LOAD_TEMPLATE("admin_admins_mails_edit_form", true, $content);
+ }
+ // Save full rendered content
+ $content['content'] = $OUT;
+
+ // Start outputing line
+ $ROWS .= LOAD_TEMPLATE("admin_admins_mails_edit_row", true, $content);
+ $SW = 3 - $SW;
+ }
+ define('__ADMINS_ROWS', $ROWS);
+
+ // Edit checked entries
+ LOAD_TEMPLATE("admin_admins_mails_edit");
+ }
+ else
+ {
+ // Nothing selected
+ LOAD_TEMPLATE("admin_settings_saved", false, ADMINS_NO_MAIL_CHECKED);
+ }
+}
+ else
+{
+ // Load all assigned mails
+ $result = SQL_QUERY("SELECT DISTINCT m.id, m.admin_id, a.login, m.mail_template
+FROM "._MYSQL_PREFIX."_admins_mails AS m
+LEFT JOIN "._MYSQL_PREFIX."_admins AS a
+ON m.admin_id=a.id
+WHERE (m.admin_id=a.id OR m.admin_id < 1) AND m.mail_template != ''
+ORDER BY m.admin_id, m.mail_template", __FILE__, __LINE__);
+
+ if (SQL_NUMROWS($result) > 0)
+ {
+ // Shall I change entries?
+ if (isset($_POST['change']))
+ {
+ // Ok, update database
+ foreach ($_POST['admin_id'] as $id=>$aid)
+ {
+ // Secure IDs
+ $id = bigintval($id);
+ $aid = bigintval($aid);
+
+ // Update entry
+ $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_admins_mails SET admin_id=%d WHERE id=%d ORDER BY id LIMIT 1",
+ array($aid, $id), __FILE__, __LINE__);
+
+ if (($aid < 1) && (!empty($_POST['template'][$id])))
+ {
+ // Remove any other admin entries
+ $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admins_mails WHERE mail_template='%s' AND id != '%s'",
+ array($_POST['template'][$id], $id), __FILE__, __LINE__);
+ }
+ if ($_POST['admin_new'][$_POST['template'][$id]] > 0)
+ {
+ // Add new admin
+ $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_admins_mails (admin_id, mail_template) VALUES ('%s', '%s')",
+ array($aid, $_POST['template'][$id]), __FILE__, __LINE__);
+ }
+ }
+
+ // Query again...
+ $result = SQL_QUERY("SELECT DISTINCT m.id, m.admin_id, a.login, m.mail_template FROM "._MYSQL_PREFIX."_admins_mails AS m, "._MYSQL_PREFIX."_admins AS a WHERE m.admin_id=a.id OR m.admin_id < 1 ORDER BY m.admin_id", __FILE__, __LINE__);
+ }
+
+ // List found entries
+ $SW = 2; $OUT = "";
+ while(list($id, $aid, $admin, $templ) = SQL_FETCHROW($result))
+ {
+ if ($aid > 0)
+ {
+ // Admin assigned
+ $admin_link = "".$admin."";
+ }
+ elseif ($aid == 0)
+ {
+ // All admins
+ $admin_link = "".ADMINS_ALL_ADMINS."";
+ }
+ elseif (($aid == -1) && (EXT_IS_ACTIVE("usrlog")))
+ {
+ // To userlog
+ $admin_link = "".ADMINS_TO_USERLOG."";
+ }
+ $content = array(
+ 'sw' => $SW,
+ 'tpl' => $templ,
+ 'alnk' => $admin_link
+ );
+
+ // Load row template
+ $OUT .= LOAD_TEMPLATE("admin_admins_mails_list_row", true, $content);
+ $SW = 3 - $SW;
+ }
+
+ // Free result
+ SQL_FREERESULT($result);
+ define('__MAILS_ROWS', $OUT);
+
+ // Load template
+ LOAD_TEMPLATE("admin_admins_mails_list");
+ }
+ else
+ {
+ // No entries found
+ LOAD_TEMPLATE("admin_settings_saved", false, ADMINS_MAILS_NO_ENTRIES);
+ }
+}
+//
+?>