-<?php\r
-/************************************************************************\r
- * MXChange v0.2.1 Start: 09/28/2003 *\r
- * =============== Last change: 08/05/2004 *\r
- * *\r
- * -------------------------------------------------------------------- *\r
- * File : what-send_bonus.php *\r
- * -------------------------------------------------------------------- *\r
- * Short description : Send out bonus mails to all members *\r
- * -------------------------------------------------------------------- *\r
- * Kurzbeschreibung : An alle Mitglieder Bonus-Mails verschicken *\r
- * -------------------------------------------------------------------- *\r
- * *\r
- * -------------------------------------------------------------------- *\r
- * Copyright (c) 2003 - 2007 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
-$WHERE = " WHERE visible='Y'";\r
-if (is_admin()) $WHERE = "";\r
-$EXT_HTML = EXT_IS_ACTIVE("html_mail");\r
-if (empty($_GET['mode'])) $_GET['mode'] = "select";\r
-\r
-OPEN_TABLE("100%", "admin_content admin_content_align", "");\r
-if (isset($_POST['ok']))\r
-{\r
- // Check if category and number of receivers is okay\r
- $CAT_TABS = "%s"; $CAT_WHERE = ""; $cat = "";\r
- if ($_POST['cat'] > 0)\r
- {\r
- // Select category\r
- $CAT_TABS = "LEFT JOIN "._MYSQL_PREFIX."_user_cats AS c ON d.userid=c.userid";\r
- $cat = bigintval($_POST['cat']);\r
- $CAT_WHERE = " AND c.cat_id=%d";\r
- }\r
- if (GET_EXT_VERSION("holiday") >= "0.1.3")\r
- {\r
- // Add something for the holiday extension\r
- $CAT_WHERE .= " AND d.holiday_active='N'";\r
- }\r
-\r
- if (($EXT_HTML) && ($_GET['mode'] == "html"))\r
- {\r
- // Only include HTML receivers\r
- $result = SQL_QUERY_ESC("SELECT d.userid FROM "._MYSQL_PREFIX."_user_data AS d ".$CAT_TABS." WHERE d.status='CONFIRMED' AND d.html='Y'".$CAT_WHERE." ORDER BY d.%s %s LIMIT %s",\r
- array($cat, $CONFIG['order_select'], $CONFIG['order_mode'], bigintval($_POST['receiver'])), __FILE__, __LINE__);\r
- }\r
- else\r
- {\r
- // Include all\r
- $result = SQL_QUERY_ESC("SELECT d.userid FROM "._MYSQL_PREFIX."_user_data AS d ".$CAT_TABS." WHERE d.status='CONFIRMED'".$CAT_WHERE." ORDER BY d.%s %s LIMIT %s",\r
- array($cat, $CONFIG['order_select'], $CONFIG['order_mode'], bigintval($_POST['receiver'])), __FILE__, __LINE__);\r
- }\r
- if ((SQL_NUMROWS($result) == $_POST['receiver']) && ($_POST['receiver'] > 0))\r
- {\r
- $RECEIVER = "";\r
- while (list($REC) = SQL_FETCHROW($result))\r
- {\r
- // Add receiver when not empty\r
- if (!empty($REC)) $RECEIVER .= ";".$REC;\r
- }\r
-\r
- // Free memory\r
- SQL_FREERESULT($result);\r
- $RECEIVER = substr($RECEIVER, 1);\r
-\r
- // Gettings points is oka, so we can add $USED later from\r
- if ($EXT_HTML)\r
- {\r
- $HTML = "N";\r
- if ($_GET['mode'] == "html") $HTML = "Y";\r
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_bonus\r
-(subject, text, receivers, points, time, data_type, timestamp, url, cat_id, target_send, mails_sent, html_msg)\r
-VALUES ('%s', '%s', '%s', '%s', '%s', 'NEW', UNIX_TIMESTAMP(), '%s', '%s', '%s', '%s', '%s')",\r
- array(\r
- $_POST['subject'],\r
- addslashes($_POST['text']),\r
- $RECEIVER,\r
- $_POST['points'],\r
- $_POST['seconds'],\r
- $_POST['url'],\r
- $cat,\r
- SELECTION_COUNT(explode(";", $RECEIVER)),\r
- bigintval($_POST['receiver']),\r
- $HTML\r
-), __FILE__, __LINE__);\r
- }\r
- else\r
- {\r
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_bonus\r
-(subject, text, receivers, points, time, data_type, timestamp, url, cat_id, target_send, mails_sent)\r
-VALUES ('%s', '%s', '%s', '%s', '%s', 'NEW', UNIX_TIMESTAMP(), '%s', '%s', '%s', '%s')",\r
- array(\r
- $_POST['subject'],\r
- addslashes($_POST['text']),\r
- $RECEIVER,\r
- $_POST['points'],\r
- $_POST['seconds'],\r
- $_POST['url'],\r
- $cat,\r
- SELECTION_COUNT(explode(";", $RECEIVER)),\r
- bigintval($_POST['receiver']),\r
-), __FILE__, __LINE__);\r
- }\r
-\r
- // Mail inserted into bonus pool\r
- LOAD_TEMPLATE ("admin_settings_saved", false, ADMIN_BONUS_SEND);\r
- }\r
- else\r
- {\r
- // More entered than can be reached!\r
- LOAD_TEMPLATE ("admin_settings_saved", false, ADMIN_MORE_SELECTED);\r
- }\r
- if (!empty($URL))\r
- {\r
- // Redirect to requested URL\r
- LOAD_URL($URL);\r
- }\r
-}\r
- else\r
-{\r
- $result = SQL_QUERY("SELECT id, cat FROM "._MYSQL_PREFIX."_cats".$WHERE." ORDER BY sort", __FILE__, __LINE__);\r
- if (SQL_NUMROWS($result) > 0)\r
- {\r
- $MORE = "";\r
- if ($_GET['mode'] == "html") $MORE = " AND html='Y'";\r
- if (GET_EXT_VERSION("holiday") >= "0.1.3")\r
- {\r
- // Add something for the holiday extension\r
- $MORE .= " AND holiday_active='N'";\r
- }\r
-\r
- $result_all = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED' AND receive_mails > 0".$MORE, __FILE__, __LINE__);\r
- define('__ALL_VALUE', SQL_NUMROWS($result_all));\r
- // Initialize array...\r
- $CATS = array(\r
- 'id' => array(),\r
- 'name' => array(),\r
- 'uids' => array()\r
- );\r
- // ... and begin loading stuff\r
- while (list($id, $cat) = SQL_FETCHROW($result))\r
- {\r
- $CATS['id'][] = $id;\r
- $CATS['name'][] = $cat;\r
- $result_uids = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_cats WHERE cat_id=%d",\r
- array(bigintval($id)), __FILE__, __LINE__);\r
- $uid_cnt = "0";\r
- while (list($ucat) = SQL_FETCHROW($result_uids))\r
- {\r
- $result_ver = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data\r
-WHERE userid=%d AND status='CONFIRMED' AND receive_mails > 0".$MORE." LIMIT 1",\r
- array(bigintval($ucat)), __FILE__, __LINE__);\r
- $uid_cnt += SQL_NUMROWS($result_ver);\r
-\r
- // Free memory\r
- SQL_FREERESULT($result_ver);\r
- }\r
-\r
- // Free memory\r
- SQL_FREERESULT($result_uids);\r
- $CATS['uids'][] = $uid_cnt;\r
- }\r
-\r
- // Free memory\r
- SQL_FREERESULT($result);\r
-\r
- if (!empty($MSG))\r
- {\r
- // We got system message so we drop it out to the user\r
- LOAD_TEMPLATE("admin_settings_saved", false, $MSG);\r
- }\r
- if ($EXT_HTML)\r
- {\r
- // If HTML extension is active\r
- define('__HTML_SELECT', LOAD_TEMPLATE("admin_send_bonus_html", true));\r
- }\r
- else\r
- {\r
- // And if not\r
- define('__HTML_SELECT', "");\r
- }\r
-\r
- // Generate options\r
- $OUT = "";\r
- foreach ($CATS['id'] as $key=>$value)\r
- {\r
- if (strlen($CATS['name'][$key]) > 20) $CATS['name'][$key] = substr($CATS['name'][$key], 0, 17)."...";\r
- $OUT .= " <OPTION value=\"".$value."\">".$CATS['name'][$key]." (".$CATS['uids'][$key]." ".USER_IN_CAT.")</OPTION>\n";\r
- }\r
- define('__OPTION_LINES', $OUT);\r
-\r
- // Store send mode\r
- define('__MODE', $_GET['mode']);\r
-\r
- // Select template\r
- switch($_GET['mode'])\r
- {\r
- case "html": // HTML mails\r
- case "normal": // Normal mails\r
- $template = "admin_send_bonus_form";\r
- break;\r
-\r
- case "select": // Selection\r
- $template = "admin_send_bonus_select";\r
- break;\r
- }\r
-\r
- // Load template\r
- LOAD_TEMPLATE($template);\r
- }\r
- else\r
- {\r
- // No cateogries are defined yet\r
- OUTPUT_HTML ("<STRONG><SPAN class=\"member_failed\">".MEMBER_NO_CATS."</SPAN></STRONG>");\r
- }\r
-}\r
-CLOSE_TABLE();\r
-//\r
-?>\r
+<?php
+/************************************************************************
+ * MXChange v0.2.1 Start: 09/28/2003 *
+ * =============== Last change: 08/05/2004 *
+ * *
+ * -------------------------------------------------------------------- *
+ * File : what-send_bonus.php *
+ * -------------------------------------------------------------------- *
+ * Short description : Send out bonus mails to all members *
+ * -------------------------------------------------------------------- *
+ * Kurzbeschreibung : An alle Mitglieder Bonus-Mails verschicken *
+ * -------------------------------------------------------------------- *
+ * *
+ * -------------------------------------------------------------------- *
+ * 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);
+} elseif (!EXT_IS_ACTIVE("order")) {
+ ADD_FATAL(sprintf(EXTENSION_PROBLEM_NOT_INSTALLED, "order"));
+ return;
+}
+
+// Add description as navigation point
+ADD_DESCR("admin", basename(__FILE__));
+
+$WHERE = " WHERE visible='Y'";
+if (is_admin()) $WHERE = "";
+$EXT_HTML = EXT_IS_ACTIVE("html_mail");
+if (empty($_GET['mode'])) $_GET['mode'] = "select";
+
+if (isset($_POST['ok']))
+{
+ // Check if category and number of receivers is okay
+ $CAT_TABS = "%s"; $CAT_WHERE = ""; $cat = "";
+ if ($_POST['cat'] > 0)
+ {
+ // Select category
+ $CAT_TABS = "LEFT JOIN "._MYSQL_PREFIX."_user_cats AS c ON d.userid=c.userid";
+ $cat = bigintval($_POST['cat']);
+ $CAT_WHERE = " AND c.cat_id=%d";
+ }
+ if (GET_EXT_VERSION("holiday") >= "0.1.3")
+ {
+ // Add something for the holiday extension
+ $CAT_WHERE .= " AND d.holiday_active='N'";
+ }
+
+ if (($EXT_HTML) && ($_GET['mode'] == "html"))
+ {
+ // Only include HTML receivers
+ $result = SQL_QUERY_ESC("SELECT d.userid FROM "._MYSQL_PREFIX."_user_data AS d ".$CAT_TABS." WHERE d.status='CONFIRMED' AND d.html='Y'".$CAT_WHERE." ORDER BY d.%s %s LIMIT %s",
+ array($cat, $CONFIG['order_select'], $CONFIG['order_mode'], bigintval($_POST['receiver'])), __FILE__, __LINE__);
+ }
+ else
+ {
+ // Include all
+ $result = SQL_QUERY_ESC("SELECT d.userid FROM "._MYSQL_PREFIX."_user_data AS d ".$CAT_TABS." WHERE d.status='CONFIRMED'".$CAT_WHERE." ORDER BY d.%s %s LIMIT %s",
+ array($cat, $CONFIG['order_select'], $CONFIG['order_mode'], bigintval($_POST['receiver'])), __FILE__, __LINE__);
+ }
+ if ((SQL_NUMROWS($result) == $_POST['receiver']) && ($_POST['receiver'] > 0))
+ {
+ $RECEIVER = "";
+ while (list($REC) = SQL_FETCHROW($result))
+ {
+ // Add receiver when not empty
+ if (!empty($REC)) $RECEIVER .= ";".$REC;
+ }
+
+ // Free memory
+ SQL_FREERESULT($result);
+ $RECEIVER = substr($RECEIVER, 1);
+
+ // Gettings points is oka, so we can add $USED later from
+ if ($EXT_HTML)
+ {
+ $HTML = "N";
+ if ($_GET['mode'] == "html") $HTML = "Y";
+ $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_bonus
+(subject, text, receivers, points, time, data_type, timestamp, url, cat_id, target_send, mails_sent, html_msg)
+VALUES ('%s', '%s', '%s', '%s', '%s', 'NEW', UNIX_TIMESTAMP(), '%s', '%s', '%s', '%s', '%s')",
+ array(
+ $_POST['subject'],
+ addslashes($_POST['text']),
+ $RECEIVER,
+ $_POST['points'],
+ $_POST['seconds'],
+ $_POST['url'],
+ $cat,
+ SELECTION_COUNT(explode(";", $RECEIVER)),
+ bigintval($_POST['receiver']),
+ $HTML
+), __FILE__, __LINE__);
+ }
+ else
+ {
+ $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_bonus
+(subject, text, receivers, points, time, data_type, timestamp, url, cat_id, target_send, mails_sent)
+VALUES ('%s', '%s', '%s', '%s', '%s', 'NEW', UNIX_TIMESTAMP(), '%s', '%s', '%s', '%s')",
+ array(
+ $_POST['subject'],
+ addslashes($_POST['text']),
+ $RECEIVER,
+ $_POST['points'],
+ $_POST['seconds'],
+ $_POST['url'],
+ $cat,
+ SELECTION_COUNT(explode(";", $RECEIVER)),
+ bigintval($_POST['receiver']),
+), __FILE__, __LINE__);
+ }
+
+ // Mail inserted into bonus pool
+ LOAD_TEMPLATE ("admin_settings_saved", false, ADMIN_BONUS_SEND);
+ }
+ else
+ {
+ // More entered than can be reached!
+ LOAD_TEMPLATE ("admin_settings_saved", false, ADMIN_MORE_SELECTED);
+ }
+ if (!empty($URL))
+ {
+ // Redirect to requested URL
+ LOAD_URL($URL);
+ }
+} else {
+ $result = SQL_QUERY("SELECT id, cat FROM "._MYSQL_PREFIX."_cats".$WHERE." ORDER BY sort", __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) > 0)
+ {
+ $MORE = "";
+ if ($_GET['mode'] == "html") $MORE = " AND html='Y'";
+ if (GET_EXT_VERSION("holiday") >= "0.1.3")
+ {
+ // Add something for the holiday extension
+ $MORE .= " AND holiday_active='N'";
+ }
+
+ $result_all = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED' AND receive_mails > 0".$MORE, __FILE__, __LINE__);
+ define('__ALL_VALUE', SQL_NUMROWS($result_all));
+ // Initialize array...
+ $CATS = array(
+ 'id' => array(),
+ 'name' => array(),
+ 'uids' => array()
+ );
+ // ... and begin loading stuff
+ while (list($id, $cat) = SQL_FETCHROW($result))
+ {
+ $CATS['id'][] = $id;
+ $CATS['name'][] = $cat;
+ $result_uids = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_cats WHERE cat_id=%d",
+ array(bigintval($id)), __FILE__, __LINE__);
+ $uid_cnt = "0";
+ while (list($ucat) = SQL_FETCHROW($result_uids))
+ {
+ $result_ver = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data
+WHERE userid=%d AND status='CONFIRMED' AND receive_mails > 0".$MORE." LIMIT 1",
+ array(bigintval($ucat)), __FILE__, __LINE__);
+ $uid_cnt += SQL_NUMROWS($result_ver);
+
+ // Free memory
+ SQL_FREERESULT($result_ver);
+ }
+
+ // Free memory
+ SQL_FREERESULT($result_uids);
+ $CATS['uids'][] = $uid_cnt;
+ }
+
+ // Free memory
+ SQL_FREERESULT($result);
+
+ if (!empty($MSG))
+ {
+ // We got system message so we drop it out to the user
+ LOAD_TEMPLATE("admin_settings_saved", false, $MSG);
+ }
+ if ($EXT_HTML)
+ {
+ // If HTML extension is active
+ define('__HTML_SELECT', LOAD_TEMPLATE("admin_send_bonus_html", true));
+ }
+ else
+ {
+ // And if not
+ define('__HTML_SELECT', "");
+ }
+
+ // Generate options
+ $OUT = "";
+ foreach ($CATS['id'] as $key=>$value)
+ {
+ if (strlen($CATS['name'][$key]) > 20) $CATS['name'][$key] = substr($CATS['name'][$key], 0, 17)."...";
+ $OUT .= " <OPTION value=\"".$value."\">".$CATS['name'][$key]." (".$CATS['uids'][$key]." ".USER_IN_CAT.")</OPTION>\n";
+ }
+ define('__OPTION_LINES', $OUT);
+
+ // Store send mode
+ define('__MODE', $_GET['mode']);
+
+ // Select template
+ switch($_GET['mode'])
+ {
+ case "html": // HTML mails
+ case "normal": // Normal mails
+ $template = "admin_send_bonus_form";
+ break;
+
+ case "select": // Selection
+ $template = "admin_send_bonus_select";
+ break;
+ }
+
+ // Load template
+ LOAD_TEMPLATE($template);
+ }
+ else
+ {
+ // No cateogries are defined yet
+ OUTPUT_HTML ("<STRONG><SPAN class=\"member_failed\">".MEMBER_NO_CATS."</SPAN></STRONG>");
+ }
+}
+
+//
+?>