-<?php\r
-/************************************************************************\r
- * MXChange v0.2.1 Start: 03/18/2005 *\r
- * =============== Last change: 03/18/2005 *\r
- * *\r
- * -------------------------------------------------------------------- *\r
- * File : stats_bonus.php *\r
- * -------------------------------------------------------------------- *\r
- * Short description : Check for 100% clickrate order *\r
- * -------------------------------------------------------------------- *\r
- * Kurzbeschreibung : Nach Mailbestaetigungen mit 100% Klickrate s. *\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
-\r
-// Check for 100% klickrate mails\r
-$result_bonus = SQL_QUERY("SELECT id, userid, subject, timestamp_ordered, clicks, url\r
-FROM "._MYSQL_PREFIX."_user_stats\r
-WHERE max_rec=clicks AND clicks>0 AND bonus_stats='N'\r
-ORDER BY userid", __FILE__, __LINE__);\r
-\r
-if (SQL_NUMROWS($result_bonus) > 0)\r
-{\r
- // Remember stats bonus in constant\r
- define('__STATS_BONUS', TRANSLATE_COMMA($CONFIG['bonus_stats']));\r
-\r
- // We found some mail orders...\r
- while(list($id, $uid, $subj, $stamp, $clicks, $url) = SQL_FETCHROW($result_bonus))\r
- {\r
- // Add points\r
- $result_points = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET bonus_stats=bonus_stats+%s WHERE userid=%d LIMIT 1",\r
- array($CONFIG['bonus_stats'], bigintval($uid)), __FILE__, __LINE__);\r
-\r
- // Prepare array\r
- $content = array(\r
- 'subject' => $subj,\r
- 'timestamp' => MAKE_DATETIME($stamp, "2"),\r
- 'clicks' => $clicks,\r
- 'url' => $url\r
- );\r
-\r
- // Load email template and send email\r
- $msg = LOAD_EMAIL_TEMPLATE("member_stats_bonus", $content, bigintval($uid));\r
- SEND_EMAIL($uid, BONUS_MEMBER_STATS_SUBJECT, $msg);\r
-\r
- // Update database\r
- $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_stats SET bonus_stats='Y' WHERE id=%d LIMIT 1",\r
- array(bigintval($id)), __FILE__, __LINE__);\r
- }\r
-\r
- // Handle bonus points\r
- BONUS_POINTS_HANDLER($CONFIG['bonus_stats']);\r
-}\r
-\r
-// Free memory\r
-SQL_FREERESULT($result_bonus);\r
-\r
-//\r
-?>\r
+<?php
+/************************************************************************
+ * MXChange v0.2.1 Start: 03/18/2005 *
+ * =============== Last change: 03/18/2005 *
+ * *
+ * -------------------------------------------------------------------- *
+ * File : stats_bonus.php *
+ * -------------------------------------------------------------------- *
+ * Short description : Check for 100% clickrate order *
+ * -------------------------------------------------------------------- *
+ * Kurzbeschreibung : Nach Mailbestaetigungen mit 100% Klickrate s. *
+ * -------------------------------------------------------------------- *
+ * *
+ * -------------------------------------------------------------------- *
+ * 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);
+}
+
+// Check for 100% klickrate mails
+$result_bonus = SQL_QUERY("SELECT id, userid, subject, timestamp_ordered, clicks, url
+FROM "._MYSQL_PREFIX."_user_stats
+WHERE max_rec=clicks AND clicks>0 AND bonus_stats='N'
+ORDER BY userid", __FILE__, __LINE__);
+
+if (SQL_NUMROWS($result_bonus) > 0)
+{
+ // Remember stats bonus in constant
+ define('__STATS_BONUS', TRANSLATE_COMMA($CONFIG['bonus_stats']));
+
+ // We found some mail orders...
+ while(list($id, $uid, $subj, $stamp, $clicks, $url) = SQL_FETCHROW($result_bonus))
+ {
+ // Add points
+ $result_points = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET bonus_stats=bonus_stats+%s WHERE userid=%d LIMIT 1",
+ array($CONFIG['bonus_stats'], bigintval($uid)), __FILE__, __LINE__);
+
+ // Prepare array
+ $content = array(
+ 'subject' => $subj,
+ 'timestamp' => MAKE_DATETIME($stamp, "2"),
+ 'clicks' => $clicks,
+ 'url' => $url
+ );
+
+ // Load email template and send email
+ $msg = LOAD_EMAIL_TEMPLATE("member_stats_bonus", $content, bigintval($uid));
+ SEND_EMAIL($uid, BONUS_MEMBER_STATS_SUBJECT, $msg);
+
+ // Update database
+ $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_stats SET bonus_stats='Y' WHERE id=%d LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__);
+ }
+
+ // Handle bonus points
+ BONUS_POINTS_HANDLER($CONFIG['bonus_stats']);
+}
+
+// Free memory
+SQL_FREERESULT($result_bonus);
+
+//
+?>
projects / mailer.git / blobdiff