$SEL = SELECTION_COUNT($_POST['sel']);
if ($SEL > 0)
{
- // Add option for userlog
+ // Add option for events
$cacheArray['admins'] = ADD_OPTION_LINES("admins", "id", "login", "", "email");
$SW = 2; $rowNameS = "";
- foreach ($_POST['sel'] as $template => $sel)
- {
+ 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",
+ $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";
+ while (list($aid, $id) = SQL_FETCHROW($result)) {
+ // @TODO Can this be rewritten???
+ $OUT .= "<select name=\"admin_id[".$id."]\" size=\"1\" class=\"admin_select\">
+<option value=\"0\"";
+ if ($aid == "0") $OUT .= " selected=\"selected\"";
+ $OUT .=">{--ADMINS_ALL_ADMINS--}</option>\n";
+ if (EXT_IS_ACTIVE("events")) {
+ $OUT .= "<option value=\"-1\"";
+ if ($aid == "-1") $OUT .= " selected=\"selected\"";
+ $OUT .= ">{--ADMINS_TO_USER_EVENTS--}</option>\n";
}
$OUT .= ADD_OPTION_LINES("admins", "id", "login", $aid, "email");
- $OUT .= "</SELECT><br />\n";
+ $OUT .= "</select><br />\n";
$aid2 = $aid; $id2 = $id;
}
{
// 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
+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__);
$aid = bigintval($aid);
// Update entry
- SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_admins_mails SET admin_id=%s WHERE id=%s ORDER BY id LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_admins_mails` SET admin_id=%s WHERE id=%s ORDER BY `id` LIMIT 1",
array($aid, $id), __FILE__, __LINE__);
if (($aid < 1) && (!empty($_POST['template'][$id])))
{
// Remove any other admin entries
- SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admins_mails WHERE mail_template='%s' AND id != '%s'",
+ 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
- SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_admins_mails (admin_id, mail_template) VALUES ('%s','%s')",
+ 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__);
+ $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>";
- }
+ while ($data = SQL_FETCHARRAY($result)) {
+ // Prepare content
$content = array(
'sw' => $SW,
- 'id' => $id,
- 'tpl' => $templ,
- 'alnk' => $admin_link
+ 'id' => $data['id'],
+ 'tpl' => $data['mail_template'],
+ 'alnk' => GENERATE_AID_LINK($data['admin_id'])
);
// Load row template
// Load template
LOAD_TEMPLATE("admin_admins_mails_list");
- }
- else
- {
+ } else {
// No entries found
LOAD_TEMPLATE("admin_settings_saved", false, ADMINS_MAILS_NO_ENTRIES);
}
}
+
//
?>