-<?php\r
-/************************************************************************\r
- * MXChange v0.2.1 Start: 08/14/2004 *\r
- * ================ Last change: 10/22/2004 *\r
- * *\r
- * -------------------------------------------------------------------- *\r
- * File : what-admins_mails.php *\r
- * -------------------------------------------------------------------- *\r
- * Short description : Control which admin shall receive which mail *\r
- * -------------------------------------------------------------------- *\r
- * Kurzbeschreibung : Stellen Sie ein, welcher Admin welche Mail erh. *\r
- * -------------------------------------------------------------------- *\r
- * *\r
- * -------------------------------------------------------------------- *\r
- * Copyright (c) 2003 - 2008 by Roland Haeder *\r
- * For more information visit: http://www.mxchange.org *\r
- * *\r
- * This program is free software; you can redistribute it and/or modify *\r
- * it under the terms of the GNU General Public License as published by *\r
- * the Free Software Foundation; either version 2 of the License, or *\r
- * (at your option) any later version. *\r
- * *\r
- * This program is distributed in the hope that it will be useful, *\r
- * but WITHOUT ANY WARRANTY; without even the implied warranty of *\r
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *\r
- * GNU General Public License for more details. *\r
- * *\r
- * You should have received a copy of the GNU General Public License *\r
- * along with this program; if not, write to the Free Software *\r
- * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *\r
- * MA 02110-1301 USA *\r
- ************************************************************************/\r
-\r
-// Some security stuff...\r
-if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN()))\r
-{\r
- $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";\r
- require($INC);\r
-}\r
-// Add description as navigation point\r
-ADD_DESCR("admin", basename(__FILE__));\r
-\r
-if (isset($_POST['edit']))\r
-{\r
- // Check if entires are checked\r
- $SEL = SELECTION_COUNT($_POST['sel']);\r
- if ($SEL > 0)\r
- {\r
- // Add option for userlog\r
- $ADMINS = ADD_OPTION_LINES("admins", "id", "login", "", "email");\r
- $SW = 2; $ROWS = "";\r
- foreach ($_POST['sel'] as $template=>$sel)\r
- {\r
- // First of all load data from DB\r
- $result = SQL_QUERY_ESC("SELECT admin_id, id FROM "._MYSQL_PREFIX."_admins_mails WHERE mail_template='%s' ORDER BY id",\r
- array($template), __FILE__, __LINE__);\r
- $OUT = ""; $aid = "0"; $aid2 = "0";\r
- while (list($aid, $id) = SQL_FETCHROW($result))\r
- {\r
- $OUT .= "<SELECT name=\"admin_id[".$id."]\" size=\"1\" class=\"admin_select\">\r
-<OPTION value=\"0\"";\r
- if ($aid == "0") $OUT .= " selected default";\r
- $OUT .=">".ADMINS_ALL_ADMINS."</OPTION>\n";\r
- if (EXT_IS_ACTIVE("userlog"))\r
- {\r
- $OUT .= "<OPTION value=\"-1\"";\r
- if ($aid == "-1") $OUT .= " selected default";\r
- $OUT .= ">".ADMINS_TO_USERLOG."</OPTION>\n";\r
- }\r
- $OUT .= ADD_OPTION_LINES("admins", "id", "login", $aid, "email");\r
- $OUT .= "</SELECT><BR>\n";\r
- $aid2 = $aid; $id2 = $id;\r
- }\r
-\r
- // Free memory\r
- SQL_FREERESULT($result);\r
-\r
- $content = array(\r
- 'sw' => $SW,\r
- 'id' => $id,\r
- 'id2' => $id2,\r
- 'tpl' => $template,\r
- 'admins' => $ADMINS\r
- );\r
-\r
- if ($aid2 > 0)\r
- {\r
- // Add form for an additional admin\r
- $OUT .= LOAD_TEMPLATE("admin_admins_mails_edit_form", true, $content);\r
- }\r
- // Save full rendered content\r
- $content['content'] = $OUT;\r
-\r
- // Start outputing line\r
- $ROWS .= LOAD_TEMPLATE("admin_admins_mails_edit_row", true, $content);\r
- $SW = 3 - $SW;\r
- }\r
- define('__ADMINS_ROWS', $ROWS);\r
-\r
- // Edit checked entries\r
- LOAD_TEMPLATE("admin_admins_mails_edit");\r
- }\r
- else\r
- {\r
- // Nothing selected\r
- LOAD_TEMPLATE("admin_settings_saved", false, ADMINS_NO_MAIL_CHECKED);\r
- }\r
-}\r
- else\r
-{\r
- // Load all assigned mails\r
- $result = SQL_QUERY("SELECT DISTINCT m.id, m.admin_id, a.login, m.mail_template\r
-FROM "._MYSQL_PREFIX."_admins_mails AS m\r
-LEFT JOIN "._MYSQL_PREFIX."_admins AS a\r
-ON m.admin_id=a.id\r
-WHERE (m.admin_id=a.id OR m.admin_id < 1) AND m.mail_template != ''\r
-ORDER BY m.admin_id, m.mail_template", __FILE__, __LINE__);\r
-\r
- if (SQL_NUMROWS($result) > 0)\r
- {\r
- // Shall I change entries?\r
- if (isset($_POST['change']))\r
- {\r
- // Ok, update database\r
- foreach ($_POST['admin_id'] as $id=>$aid)\r
- {\r
- // Secure IDs\r
- $id = bigintval($id);\r
- $aid = bigintval($aid);\r
-\r
- // Update entry\r
- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_admins_mails SET admin_id=%d WHERE id=%d ORDER BY id LIMIT 1",\r
- array($aid, $id), __FILE__, __LINE__);\r
-\r
- if (($aid < 1) && (!empty($_POST['template'][$id])))\r
- {\r
- // Remove any other admin entries\r
- $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admins_mails WHERE mail_template='%s' AND id != '%s'",\r
- array($_POST['template'][$id], $id), __FILE__, __LINE__);\r
- }\r
- if ($_POST['admin_new'][$_POST['template'][$id]] > 0)\r
- {\r
- // Add new admin\r
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_admins_mails (admin_id, mail_template) VALUES ('%s', '%s')",\r
- array($aid, $_POST['template'][$id]), __FILE__, __LINE__);\r
- }\r
- }\r
-\r
- // Query again...\r
- $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__);\r
- }\r
-\r
- // List found entries\r
- $SW = 2; $OUT = "";\r
- while(list($id, $aid, $admin, $templ) = SQL_FETCHROW($result))\r
- {\r
- if ($aid > 0)\r
- {\r
- // Admin assigned\r
- $admin_link = "<A href=\"".URL."/modules.php?module=admin&what=admins_contct&admin=".$aid."\">".$admin."</A>";\r
- }\r
- elseif ($aid == 0)\r
- {\r
- // All admins\r
- $admin_link = "<I>".ADMINS_ALL_ADMINS."</I>";\r
- }\r
- elseif (($aid == -1) && (EXT_IS_ACTIVE("usrlog")))\r
- {\r
- // To userlog\r
- $admin_link = "<I>".ADMINS_TO_USERLOG."</I>";\r
- }\r
- $content = array(\r
- 'sw' => $SW,\r
- 'tpl' => $templ,\r
- 'alnk' => $admin_link\r
- );\r
-\r
- // Load row template\r
- $OUT .= LOAD_TEMPLATE("admin_admins_mails_list_row", true, $content);\r
- $SW = 3 - $SW;\r
- }\r
-\r
- // Free result\r
- SQL_FREERESULT($result);\r
- define('__MAILS_ROWS', $OUT);\r
-\r
- // Load template\r
- LOAD_TEMPLATE("admin_admins_mails_list");\r
- }\r
- else\r
- {\r
- // No entries found\r
- LOAD_TEMPLATE("admin_settings_saved", false, ADMINS_MAILS_NO_ENTRIES);\r
- }\r
-}\r
-//\r
-?>\r
+<?php
+/************************************************************************
+ * MXChange v0.2.1 Start: 08/14/2004 *
+ * ================ Last change: 10/22/2004 *
+ * *
+ * -------------------------------------------------------------------- *
+ * File : what-admins_mails.php *
+ * -------------------------------------------------------------------- *
+ * Short description : Control which admin shall receive which mail *
+ * -------------------------------------------------------------------- *
+ * Kurzbeschreibung : Stellen Sie ein, welcher Admin welche Mail erh. *
+ * -------------------------------------------------------------------- *
+ * *
+ * -------------------------------------------------------------------- *
+ * Copyright (c) 2003 - 2008 by Roland Haeder *
+ * For more information visit: http://www.mxchange.org *
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ * This program is distributed in the hope that it will be useful, *
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of *
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
+ * GNU General Public License for more details. *
+ * *
+ * You should have received a copy of the GNU General Public License *
+ * along with this program; if not, write to the Free Software *
+ * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
+ * MA 02110-1301 USA *
+ ************************************************************************/
+
+// Some security stuff...
+if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN()))
+{
+ $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+ require($INC);
+}
+// Add description as navigation point
+ADD_DESCR("admin", basename(__FILE__));
+
+if (isset($_POST['edit']))
+{
+ // Check if entires are checked
+ $SEL = SELECTION_COUNT($_POST['sel']);
+ if ($SEL > 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 .= "<SELECT name=\"admin_id[".$id."]\" size=\"1\" class=\"admin_select\">
+<OPTION value=\"0\"";
+ if ($aid == "0") $OUT .= " selected default";
+ $OUT .=">".ADMINS_ALL_ADMINS."</OPTION>\n";
+ if (EXT_IS_ACTIVE("userlog"))
+ {
+ $OUT .= "<OPTION value=\"-1\"";
+ if ($aid == "-1") $OUT .= " selected default";
+ $OUT .= ">".ADMINS_TO_USERLOG."</OPTION>\n";
+ }
+ $OUT .= ADD_OPTION_LINES("admins", "id", "login", $aid, "email");
+ $OUT .= "</SELECT><BR>\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 = "<A href=\"".URL."/modules.php?module=admin&what=admins_contct&admin=".$aid."\">".$admin."</A>";
+ }
+ elseif ($aid == 0)
+ {
+ // All admins
+ $admin_link = "<I>".ADMINS_ALL_ADMINS."</I>";
+ }
+ elseif (($aid == -1) && (EXT_IS_ACTIVE("usrlog")))
+ {
+ // To userlog
+ $admin_link = "<I>".ADMINS_TO_USERLOG."</I>";
+ }
+ $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);
+ }
+}
+//
+?>