-<?php\r
-/************************************************************************\r
- * MXChange v0.2.1 Start: 11/22/2005 *\r
- * =============== Last change: 11/22/2005 *\r
- * *\r
- * -------------------------------------------------------------------- *\r
- * File : bonus_mails.php *\r
- * -------------------------------------------------------------------- *\r
- * Short description : Sends out reminder mails *\r
- * -------------------------------------------------------------------- *\r
- * Kurzbeschreibung : Versendet Erinnerungsmails *\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']))\r
-{\r
- $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";\r
- require($INC);\r
-}\r
- elseif ((!EXT_IS_ACTIVE("bonus")) && (!IS_ADMIN()))\r
-{\r
- ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "bonus");\r
- return;\r
-}\r
-\r
-// Do not execute when script is in CSS mode\r
-if ($CSS == 1) return;\r
-\r
-// Create timemark from saved month\r
-$mark = mktime(0, 0, 0, $CONFIG['bonus_month'], date("d", time()), date("Y", time()));\r
-$SQL = ""; $MODE = "";\r
-\r
-// Shall I sent activation or deactivation mail?\r
-$SQL = "SELECT userid, email FROM "._MYSQL_PREFIX."_user_data WHERE (bonus_ral_notify ";\r
-switch ($CONFIG['bonus_active'])\r
-{\r
-case "Y": // Active rallye is activated\r
- if ($CONFIG['bonus_en_notify'] == "Y")\r
- {\r
- // Okay, let's check for member accounts\r
- $SQL .= "= 0 OR (bonus_ral_notify > 0 AND bonus_ral_en_notify < bonus_ral_di_notify)";\r
- $MODE = "en";\r
- }\r
- else\r
- {\r
- // Do not notify!\r
- $SQL = "";\r
- }\r
- break;\r
-\r
-case "N": // Active rallye is deactivated\r
- if ($CONFIG['bonus_di_notify'] == "Y")\r
- {\r
- // Okay, let's check for member accounts\r
- $SQL .= " > 0 AND bonus_ral_di_notify < bonus_ral_en_notify";\r
- $MODE = "di";\r
- }\r
- else\r
- {\r
- // Do not notify!\r
- $SQL = "";\r
- }\r
- break;\r
-}\r
-\r
-if (!empty($SQL))\r
-{\r
- // The SQL command needs to be finisched here (only confirmed accounts!)\r
- $SQL .= ") AND status='CONFIRMED' ORDER BY last_online ASC";\r
-\r
- // Normal notification mails or bonus mails?\r
- $MAIL_MODE = (($CONFIG['bonus_notify_points'] > 0) && ($MODE == "en") && (EXT_IS_ACTIVE("bonus")));\r
-\r
- // Generate subject line\r
- $eval = "\$SUBJECT = BONUS_RALLYE_".strtoupper($MODE)."_NOTIFY;";\r
- eval($eval);\r
-\r
- // Load message body for bonus mails\r
- $MSG = LOAD_EMAIL_TEMPLATE("bonus_en_notify_body", "", "{PER}uid{PER}");\r
- $RECEIVER = ""; $UIDs = array();\r
-\r
- // Check for accounts to be notified\r
- $result_main = SQL_QUERY($SQL, __FILE__, __LINE__);\r
- if (SQL_NUMROWS($result_main) > 0)\r
- {\r
- // Okay lets notify all users!\r
- while(list($uid, $email) = SQL_FETCHROW($result_main))\r
- {\r
- // Update account\r
- $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data\r
-SET bonus_ral_notify='%s', bonus_ral_%s_notify='%s' WHERE userid=%d LIMIT 1",\r
- array(time(), $MODE, time(), $uid), __FILE__, __LINE__);\r
-\r
- // Load email template and send it to the user!\r
- if ($MAIL_MODE)\r
- {\r
- // Add userid to queue\r
- $UIDs[] = $uid;\r
- }\r
- else\r
- {\r
- // Send normal notification mail to the members\r
- $MSG = LOAD_EMAIL_TEMPLATE("bonus_".$MODE."_notify", "", $uid);\r
- SEND_EMAIL($email, $SUBJECT, $MSG);\r
- }\r
- }\r
-\r
- // Shall I send out bonus mails?\r
- if ($MAIL_MODE)\r
- {\r
- // Okay, make array to string\r
- $RECEIVER = implode(";", $UIDs);\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, is_notify)\r
-VALUES ('%s', '%s', '%s', '%s', '%s', 'NEW', UNIX_TIMESTAMP(), '%s', '%s', '%s', '%s', 'Y')",\r
- array(\r
- $SUBJECT,\r
- $MSG,\r
- $RECEIVER,\r
- $CONFIG['bonus_notify_points'],\r
- $CONFIG['bonus_notify_wait'],\r
- URL."/modules.php?module=index&what=login",\r
- 0,\r
- SELECTION_COUNT(explode(";", $RECEIVER)),\r
- SQL_NUMROWS($result_main),\r
-), __FILE__, __LINE__);\r
- }\r
- }\r
-\r
- // Free memory\r
- SQL_FREERESULT($result_main);\r
-}\r
-//\r
-?>\r
+<?php
+/************************************************************************
+ * MXChange v0.2.1 Start: 11/22/2005 *
+ * =============== Last change: 11/22/2005 *
+ * *
+ * -------------------------------------------------------------------- *
+ * File : bonus_mails.php *
+ * -------------------------------------------------------------------- *
+ * Short description : Sends out reminder mails *
+ * -------------------------------------------------------------------- *
+ * Kurzbeschreibung : Versendet Erinnerungsmails *
+ * -------------------------------------------------------------------- *
+ * *
+ * -------------------------------------------------------------------- *
+ * 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']))
+{
+ $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+ require($INC);
+}
+ elseif ((!EXT_IS_ACTIVE("bonus")) && (!IS_ADMIN()))
+{
+ ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "bonus");
+ return;
+}
+
+// Do not execute when script is in CSS mode
+if ($CSS == 1) return;
+
+// Create timemark from saved month
+$mark = mktime(0, 0, 0, $CONFIG['bonus_month'], date("d", time()), date("Y", time()));
+$SQL = ""; $MODE = "";
+
+// Shall I sent activation or deactivation mail?
+$SQL = "SELECT userid, email FROM "._MYSQL_PREFIX."_user_data WHERE (bonus_ral_notify ";
+switch ($CONFIG['bonus_active'])
+{
+case "Y": // Active rallye is activated
+ if ($CONFIG['bonus_en_notify'] == "Y")
+ {
+ // Okay, let's check for member accounts
+ $SQL .= "= 0 OR (bonus_ral_notify > 0 AND bonus_ral_en_notify < bonus_ral_di_notify)";
+ $MODE = "en";
+ }
+ else
+ {
+ // Do not notify!
+ $SQL = "";
+ }
+ break;
+
+case "N": // Active rallye is deactivated
+ if ($CONFIG['bonus_di_notify'] == "Y")
+ {
+ // Okay, let's check for member accounts
+ $SQL .= " > 0 AND bonus_ral_di_notify < bonus_ral_en_notify";
+ $MODE = "di";
+ }
+ else
+ {
+ // Do not notify!
+ $SQL = "";
+ }
+ break;
+}
+
+if (!empty($SQL))
+{
+ // The SQL command needs to be finisched here (only confirmed accounts!)
+ $SQL .= ") AND status='CONFIRMED' ORDER BY last_online ASC";
+
+ // Normal notification mails or bonus mails?
+ $MAIL_MODE = (($CONFIG['bonus_notify_points'] > 0) && ($MODE == "en") && (EXT_IS_ACTIVE("bonus")));
+
+ // Generate subject line
+ $eval = "\$SUBJECT = BONUS_RALLYE_".strtoupper($MODE)."_NOTIFY;";
+ eval($eval);
+
+ // Load message body for bonus mails
+ $MSG = LOAD_EMAIL_TEMPLATE("bonus_en_notify_body", "", "{PER}uid{PER}");
+ $RECEIVER = ""; $UIDs = array();
+
+ // Check for accounts to be notified
+ $result_main = SQL_QUERY($SQL, __FILE__, __LINE__);
+ if (SQL_NUMROWS($result_main) > 0)
+ {
+ // Okay lets notify all users!
+ while(list($uid, $email) = SQL_FETCHROW($result_main))
+ {
+ // Update account
+ $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data
+SET bonus_ral_notify='%s', bonus_ral_%s_notify='%s' WHERE userid=%d LIMIT 1",
+ array(time(), $MODE, time(), $uid), __FILE__, __LINE__);
+
+ // Load email template and send it to the user!
+ if ($MAIL_MODE)
+ {
+ // Add userid to queue
+ $UIDs[] = $uid;
+ }
+ else
+ {
+ // Send normal notification mail to the members
+ $MSG = LOAD_EMAIL_TEMPLATE("bonus_".$MODE."_notify", "", $uid);
+ SEND_EMAIL($email, $SUBJECT, $MSG);
+ }
+ }
+
+ // Shall I send out bonus mails?
+ if ($MAIL_MODE)
+ {
+ // Okay, make array to string
+ $RECEIVER = implode(";", $UIDs);
+ $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_bonus
+(subject, text, receivers, points, time, data_type, timestamp, url, cat_id, target_send, mails_sent, is_notify)
+VALUES ('%s', '%s', '%s', '%s', '%s', 'NEW', UNIX_TIMESTAMP(), '%s', '%s', '%s', '%s', 'Y')",
+ array(
+ $SUBJECT,
+ $MSG,
+ $RECEIVER,
+ $CONFIG['bonus_notify_points'],
+ $CONFIG['bonus_notify_wait'],
+ URL."/modules.php?module=index&what=login",
+ 0,
+ SELECTION_COUNT(explode(";", $RECEIVER)),
+ SQL_NUMROWS($result_main),
+), __FILE__, __LINE__);
+ }
+ }
+
+ // Free memory
+ SQL_FREERESULT($result_main);
+}
+//
+?>
projects / mailer.git / blobdiff