2 /************************************************************************
3 * MXChange v0.2.1 Start: 12/12/2008 *
4 * =============== Last change: 12/12/2008 *
6 * -------------------------------------------------------------------- *
7 * File : pool-bonus.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Sends queued bonus mails from the pool *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Sendet freigegebene Bonus-Mails aus dem Pool *
12 * -------------------------------------------------------------------- *
14 * -------------------------------------------------------------------- *
15 * Copyright (c) 2003 - 2008 by Roland Haeder *
16 * For more information visit: http://www.mxchange.org *
18 * This program is free software; you can redistribute it and/or modify *
19 * it under the terms of the GNU General Public License as published by *
20 * the Free Software Foundation; either version 2 of the License, or *
21 * (at your option) any later version. *
23 * This program is distributed in the hope that it will be useful, *
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
26 * GNU General Public License for more details. *
28 * You should have received a copy of the GNU General Public License *
29 * along with this program; if not, write to the Free Software *
30 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
32 ************************************************************************/
34 // Some security stuff...
35 if (!defined('__SECURITY')) {
36 $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
40 // Don't run on daily reset
41 if (isResetModeEnabled()) {
44 } elseif (!EXT_IS_ACTIVE("bonus")) {
45 // Abort if extension bonus is not active
50 // Only send bonus mail when bonus extension is active and maximum send-mails is not reached
51 if ($GLOBALS['pool_cnt'] < getConfig('max_send')) {
52 // Do we need to send out bonus mails?
53 if (EXT_IS_ACTIVE("html_mail")) {
54 // 0 1 2 3 4 5 6 7 8 9 10 11
55 $result_bonus = SQL_QUERY("SELECT id, subject, text, receivers, points, time, data_type, timestamp, url, cat_id, target_send, html_msg FROM `{!_MYSQL_PREFIX!}_bonus` WHERE data_type='NEW' ORDER BY timestamp DESC", __FILE__, __LINE__);
57 // 0 1 2 3 4 5 6 7 8 9 10
58 $result_bonus = SQL_QUERY("SELECT id, subject, text, receivers, points, time, data_type, timestamp, url, cat_id, target_send FROM `{!_MYSQL_PREFIX!}_bonus` WHERE data_type='NEW' ORDER BY timestamp DESC", __FILE__, __LINE__);
61 if (SQL_NUMROWS($result_bonus) > 0) {
62 // Send these mails away...
64 while ($DATA = SQL_FETCHARRAY($result_bonus)) {
66 $DATA['url'] = COMPILE_CODE($DATA['url']);
68 // Message is active in queue
69 SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_bonus` SET data_type='QUEUE' WHERE id=%s LIMIT 1",
70 array(bigintval($DATA['id'])), __FILE__, __LINE__);
72 // "Explode" all receivers into an array
73 if (ereg(";", $DATA['receivers'])) {
74 // There's more than one receiver in the list...
75 $RECEIVERS = explode(";", $DATA['receivers']);
76 } elseif (!empty($DATA['points'])) {
78 $RECEIVERS = array($DATA['receivers']);
81 $RECEIVERS = array("0");
85 // Now, if we are good little boys and girls Santa left us some user-ids.
86 // We can now send mails to them...
87 foreach ($RECEIVERS as $key => $uid) {
89 //* DEBUG: */ echo "*L:".__LINE__."/".$uid."*<br />";
90 $result_user = SQL_QUERY_ESC("SELECT surname, family, email FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
91 array(bigintval($uid)), __FILE__, __LINE__);
93 // Is his data available?
94 if (SQL_NUMROWS($result_user) == 1) {
95 // The final receiver does exists so we can continue...
96 list($sname, $fname, $email) = SQL_FETCHROW($result_user);
97 //* DEBUG: */ echo "OK!/L:".__LINE__."<br />";
99 // Mark this user as "spammed" ;-) And place a line for him...
100 if (REMOVE_RECEIVER($dummy, $key, $uid, $DATA['id'], $DATA['id'], true) == "done") {
101 // Replace text variables
102 foreach ($GLOBALS['replacer'] as $key => $value) {
103 if (isset($DATA[$key])) $DATA['text'] = str_replace($value, $DATA[$key], $DATA['text']);
109 'url' => $DATA['url'],
110 'time' => CREATE_FANCY_TIME($DATA['time']),
111 'points' => TRANSLATE_COMMA($DATA['points']),
112 'category' => GET_CATEGORY($DATA['cat_id']),
113 'text' => $DATA['text']
117 $mailText = LOAD_EMAIL_TEMPLATE("bonus-mail", $content, $uid);
120 if (isset($DATA['html_msg'])) {
122 SEND_EMAIL($email, $DATA['subject'], $mailText, $DATA['html_msg']);
125 SEND_EMAIL($email, $DATA['subject'], $mailText);
128 // Count one up and remove entry from dummy array
129 $GLOBALS['pool_cnt']++; unset($dummy[$key]);
131 if (GET_EXT_VERSION("user") >= "0.1.4") {
132 // Update mails received for receiver
133 SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET emails_received=emails_received+1 WHERE userid=%s LIMIT 1",
134 array(bigintval($uid)), __FILE__, __LINE__);
137 // Do we have send maximum mails?
138 if (($GLOBALS['pool_cnt'] >= getConfig('max_send')) || (SELECTION_COUNT($dummy) == 0)) {
140 //* DEBUG: */ echo "*EXIT/L:".__LINE__."<br />";
147 SQL_FREERESULT($result_user);
150 // Update mediadata if version is 0.0.4 or higher
151 if (GET_EXT_VERSION("mediadata") >= "0.0.4") {
152 // Update entry (or add missing
153 $P = $GLOBALS['pool_cnt'];
154 if (!empty($cnt2) && empty($GLOBALS['pool_cnt'])) $P = $cnt2;
155 //* DEBUG: */ echo "+MEDIA/L:".__LINE__."/".$P."+<br />";
156 MEDIA_UPDATE_ENTRY(array("total_send", "bonus_send"), "add", $P);
159 // Close sending system
160 //* DEBUG: */ echo "-L:".__LINE__."/".SELECTION_COUNT($dummy)."-<br />";
161 if (SELECTION_COUNT($dummy) == 0) {
163 SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_bonus` SET data_type='SEND', target_send='0', receivers='' WHERE id=%s LIMIT 1",
164 array(bigintval($DATA['id'])), __FILE__, __LINE__);
165 //* DEBUG: */ echo "*L:".__LINE__."*<br />";
167 // Update mediadata if version is 0.0.4 or higher
168 if (GET_EXT_VERSION("mediadata") >= "0.0.4") {
169 // Update entry (or add missing)
170 //* DEBUG: */ echo "*MEDIA/L:".__LINE__."*<br />";
171 MEDIA_UPDATE_ENTRY(array("total_orders", "bonus_orders"), "add", 1);
173 } elseif ($GLOBALS['pool_cnt'] >= getConfig('max_send')) {
175 SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_bonus` SET data_type='NEW', target_send=%s, receivers='%s' WHERE id=%s LIMIT 1",
176 array(SELECTION_COUNT($dummy), implode(";", $dummy), bigintval($DATA['id'])), __FILE__, __LINE__);
177 //* DEBUG: */ echo "*L:".__LINE__."<pre>";
178 //* DEBUG: */ print_r($dummy);
179 //* DEBUG: */ echo "</pre>\n!!!<br />";
186 SQL_FREERESULT($result_bonus);