2 /************************************************************************
\r
3 * MXChange v0.2.1 Start: 09/28/2003 *
\r
4 * =============== Last change: 08/05/2004 *
\r
6 * -------------------------------------------------------------------- *
\r
7 * File : what-send_bonus.php *
\r
8 * -------------------------------------------------------------------- *
\r
9 * Short description : Send out bonus mails to all members *
\r
10 * -------------------------------------------------------------------- *
\r
11 * Kurzbeschreibung : An alle Mitglieder Bonus-Mails verschicken *
\r
12 * -------------------------------------------------------------------- *
\r
14 * -------------------------------------------------------------------- *
\r
15 * Copyright (c) 2003 - 2008 by Roland Haeder *
\r
16 * For more information visit: http://www.mxchange.org *
\r
18 * This program is free software; you can redistribute it and/or modify *
\r
19 * it under the terms of the GNU General Public License as published by *
\r
20 * the Free Software Foundation; either version 2 of the License, or *
\r
21 * (at your option) any later version. *
\r
23 * This program is distributed in the hope that it will be useful, *
\r
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
\r
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
\r
26 * GNU General Public License for more details. *
\r
28 * You should have received a copy of the GNU General Public License *
\r
29 * along with this program; if not, write to the Free Software *
\r
30 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
\r
31 * MA 02110-1301 USA *
\r
32 ************************************************************************/
\r
34 // Some security stuff...
\r
35 if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN()))
\r
37 $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";
\r
40 // Add description as navigation point
\r
41 ADD_DESCR("admin", basename(__FILE__));
\r
43 $WHERE = " WHERE visible='Y'";
\r
44 if (is_admin()) $WHERE = "";
\r
45 $EXT_HTML = EXT_IS_ACTIVE("html_mail");
\r
46 if (empty($_GET['mode'])) $_GET['mode'] = "select";
\r
48 OPEN_TABLE("100%", "admin_content admin_content_align", "");
\r
49 if (isset($_POST['ok']))
\r
51 // Check if category and number of receivers is okay
\r
52 $CAT_TABS = "%s"; $CAT_WHERE = ""; $cat = "";
\r
53 if ($_POST['cat'] > 0)
\r
56 $CAT_TABS = "LEFT JOIN "._MYSQL_PREFIX."_user_cats AS c ON d.userid=c.userid";
\r
57 $cat = bigintval($_POST['cat']);
\r
58 $CAT_WHERE = " AND c.cat_id=%d";
\r
60 if (GET_EXT_VERSION("holiday") >= "0.1.3")
\r
62 // Add something for the holiday extension
\r
63 $CAT_WHERE .= " AND d.holiday_active='N'";
\r
66 if (($EXT_HTML) && ($_GET['mode'] == "html"))
\r
68 // Only include HTML receivers
\r
69 $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
70 array($cat, $CONFIG['order_select'], $CONFIG['order_mode'], bigintval($_POST['receiver'])), __FILE__, __LINE__);
\r
75 $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
76 array($cat, $CONFIG['order_select'], $CONFIG['order_mode'], bigintval($_POST['receiver'])), __FILE__, __LINE__);
\r
78 if ((SQL_NUMROWS($result) == $_POST['receiver']) && ($_POST['receiver'] > 0))
\r
81 while (list($REC) = SQL_FETCHROW($result))
\r
83 // Add receiver when not empty
\r
84 if (!empty($REC)) $RECEIVER .= ";".$REC;
\r
88 SQL_FREERESULT($result);
\r
89 $RECEIVER = substr($RECEIVER, 1);
\r
91 // Gettings points is oka, so we can add $USED later from
\r
95 if ($_GET['mode'] == "html") $HTML = "Y";
\r
96 $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_bonus
\r
97 (subject, text, receivers, points, time, data_type, timestamp, url, cat_id, target_send, mails_sent, html_msg)
\r
98 VALUES ('%s', '%s', '%s', '%s', '%s', 'NEW', UNIX_TIMESTAMP(), '%s', '%s', '%s', '%s', '%s')",
\r
101 addslashes($_POST['text']),
\r
107 SELECTION_COUNT(explode(";", $RECEIVER)),
\r
108 bigintval($_POST['receiver']),
\r
110 ), __FILE__, __LINE__);
\r
114 $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_bonus
\r
115 (subject, text, receivers, points, time, data_type, timestamp, url, cat_id, target_send, mails_sent)
\r
116 VALUES ('%s', '%s', '%s', '%s', '%s', 'NEW', UNIX_TIMESTAMP(), '%s', '%s', '%s', '%s')",
\r
119 addslashes($_POST['text']),
\r
125 SELECTION_COUNT(explode(";", $RECEIVER)),
\r
126 bigintval($_POST['receiver']),
\r
127 ), __FILE__, __LINE__);
\r
130 // Mail inserted into bonus pool
\r
131 LOAD_TEMPLATE ("admin_settings_saved", false, ADMIN_BONUS_SEND);
\r
135 // More entered than can be reached!
\r
136 LOAD_TEMPLATE ("admin_settings_saved", false, ADMIN_MORE_SELECTED);
\r
140 // Redirect to requested URL
\r
146 $result = SQL_QUERY("SELECT id, cat FROM "._MYSQL_PREFIX."_cats".$WHERE." ORDER BY sort", __FILE__, __LINE__);
\r
147 if (SQL_NUMROWS($result) > 0)
\r
150 if ($_GET['mode'] == "html") $MORE = " AND html='Y'";
\r
151 if (GET_EXT_VERSION("holiday") >= "0.1.3")
\r
153 // Add something for the holiday extension
\r
154 $MORE .= " AND holiday_active='N'";
\r
157 $result_all = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED' AND receive_mails > 0".$MORE, __FILE__, __LINE__);
\r
158 define('__ALL_VALUE', SQL_NUMROWS($result_all));
\r
159 // Initialize array...
\r
165 // ... and begin loading stuff
\r
166 while (list($id, $cat) = SQL_FETCHROW($result))
\r
168 $CATS['id'][] = $id;
\r
169 $CATS['name'][] = $cat;
\r
170 $result_uids = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_cats WHERE cat_id=%d",
\r
171 array(bigintval($id)), __FILE__, __LINE__);
\r
173 while (list($ucat) = SQL_FETCHROW($result_uids))
\r
175 $result_ver = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data
\r
176 WHERE userid=%d AND status='CONFIRMED' AND receive_mails > 0".$MORE." LIMIT 1",
\r
177 array(bigintval($ucat)), __FILE__, __LINE__);
\r
178 $uid_cnt += SQL_NUMROWS($result_ver);
\r
181 SQL_FREERESULT($result_ver);
\r
185 SQL_FREERESULT($result_uids);
\r
186 $CATS['uids'][] = $uid_cnt;
\r
190 SQL_FREERESULT($result);
\r
194 // We got system message so we drop it out to the user
\r
195 LOAD_TEMPLATE("admin_settings_saved", false, $MSG);
\r
199 // If HTML extension is active
\r
200 define('__HTML_SELECT', LOAD_TEMPLATE("admin_send_bonus_html", true));
\r
205 define('__HTML_SELECT', "");
\r
208 // Generate options
\r
210 foreach ($CATS['id'] as $key=>$value)
\r
212 if (strlen($CATS['name'][$key]) > 20) $CATS['name'][$key] = substr($CATS['name'][$key], 0, 17)."...";
\r
213 $OUT .= " <OPTION value=\"".$value."\">".$CATS['name'][$key]." (".$CATS['uids'][$key]." ".USER_IN_CAT.")</OPTION>\n";
\r
215 define('__OPTION_LINES', $OUT);
\r
218 define('__MODE', $_GET['mode']);
\r
221 switch($_GET['mode'])
\r
223 case "html": // HTML mails
\r
224 case "normal": // Normal mails
\r
225 $template = "admin_send_bonus_form";
\r
228 case "select": // Selection
\r
229 $template = "admin_send_bonus_select";
\r
234 LOAD_TEMPLATE($template);
\r
238 // No cateogries are defined yet
\r
239 OUTPUT_HTML ("<STRONG><SPAN class=\"member_failed\">".MEMBER_NO_CATS."</SPAN></STRONG>");
\r