X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=0.2.1%2Finc%2Fmonthly%2Fmonthly_bonus.php;h=1dec6c3bef6a4478ce355a66ba9f02d74d25f481;hb=4ac856c74ab07fc19ab64039904f2075c8f35b40;hp=df20475dc8aa75ec4b7ad1ad6010eb60ffd0099e;hpb=4696b799ced069ba2a264fa3b38fc033e3dc31dc;p=mailer.git

diff --git a/0.2.1/inc/monthly/monthly_bonus.php b/0.2.1/inc/monthly/monthly_bonus.php
index df20475dc8..1dec6c3bef 100644
--- a/0.2.1/inc/monthly/monthly_bonus.php
+++ b/0.2.1/inc/monthly/monthly_bonus.php
@@ -1,138 +1,138 @@
-<?php
-/************************************************************************
- * MXChange v0.2.1                                    Start: 11/14/2004 *
- * ===============                              Last change: 11/19/2004 *
- *                                                                      *
- * -------------------------------------------------------------------- *
- * File              : monthly_bonus.php                                *
- * -------------------------------------------------------------------- *
- * Short description : Monthly bonus from click-bonus                   *
- * -------------------------------------------------------------------- *
- * Kurzbeschreibung  : Monatlicher Bonus von Klick-Verguetung           *
- * -------------------------------------------------------------------- *
- *                                                                      *
- * -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2007 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 or no daily reset
-if (($CSS == 1) || (!defined('__DAILY_RESET'))) return;
-
-// Get current month (2 digits)
-$curr = date("m", time());
-
-if (($curr != $CONFIG['bonus_month']) && ($CONFIG['bonus_ranks'] > 0) && ($CSS != 1))
-{
-	// Extension "autopurge" is inactive or purging of inactive accounts is deactivated
-	$WHERE1 = "WHERE status='CONFIRMED'";
-	$WHERE2 = 0;
-	$WHERE3 = bigintval($CONFIG['bonus_ranks']);
-
-	// Shall I keep inactive members away from here? (mostly wanted in an "active-rallye" ...)
-	if (EXT_IS_ACTIVE("autopurge"))
-	{
-		// Use last online stamp only when autopurge for inactive members is activated
-		if ($CONFIG['ap_in_since'] > 0)
-		{
-			// Okay, include last online timestamp
-			$WHERE1 = "WHERE status='CONFIRMED' AND last_online >=";
-			$WHERE2 = bigintval(time() - $CONFIG['ap_in_since']);
-			$WHERE3 = bigintval($CONFIG['bonus_ranks']);
-		}
-	}
-
-	// Add more bonus points here
-	$ADD = " AND (0";
-	if ($CONFIG['bonus_click_yn'] == "Y") $ADD .= " + turbo_bonus";
-	if ($CONFIG['bonus_login_yn'] == "Y") $ADD .= " + login_bonus";
-	if ($CONFIG['bonus_order_yn'] == "Y") $ADD .= " + bonus_order";
-	if ($CONFIG['bonus_stats_yn'] == "Y") $ADD .= " + bonus_stats";
-	if ($CONFIG['bonus_ref_yn']   == "Y") $ADD .= " + bonus_ref";
-	$ADD .= ") > 0";
-
-	// SQL string to check for accounts
-	$result_main = SQL_QUERY_ESC("SELECT userid, email, (turbo_bonus + login_bonus + bonus_order + bonus_stats + bonus_ref) AS active_bonus
-FROM "._MYSQL_PREFIX."_user_data
-".$WHERE1." %s".$ADD."
-ORDER BY active_bonus DESC, userid LIMIT %s",
- array($WHERE2, $WHERE3), __FILE__, __LINE__);
-
-	if (SQL_NUMROWS($result_main) > 0)
-	{
-		// Load our winners...
-		$UIDs = "";
-		while(list($uid, $email, $points) = SQL_FETCHROW($result_main))
-		{
-			// Add userids in a row
-			$UIDs .= ",'".$uid."'";
-
-			// Add points to user's account directly
-			$result_data = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points
-SET points=points+%s WHERE ref_depth='0' AND userid=%d LIMIT 1",
- array($points, bigintval($uid)), __FILE__, __LINE__);
-
-			// Update mediadata as well
-			if (GET_EXT_VERSION("mediadata") >= "0.0.4")
-			{
-				// Update database
-				MEDIA_UPDATE_ENTRY(array("total_points"), "add", $points);
-			}
-
-			// Load email template and email it away
-			$msg = LOAD_EMAIL_TEMPLATE("member_bonus", $points, bigintval($uid));
-			SEND_EMAIL($email, BONUS_MONTHLY_ONLINE_BONUS, $msg);
-		}
-		// Remove first commata
-		$UIDs = substr($UIDs, 1);
-
-		// Get current month
-		$curr = date("m", time());
-		if (strlen($curr) == 1) $curr = "0".$curr;
-		if ($curr == "00") $curr = "12";
-
-		// Reset accounts
-		$result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_user_data
-SET turbo_bonus=0, login_bonus=0, bonus_order=0, bonus_stats=0, bonus_ref=0", __FILE__, __LINE__);
-
-	}
-
-	// Free memory
-	SQL_FREERESULT($result_main);
-
-	// Finally update database and config array
-	$CONFIG['bonus_month'] = $curr;
-	$result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_config SET last_bonus_month='%s' WHERE config='0' LIMIT 1",
-	 array($curr), __FILE__, __LINE__);
-
-	// Destroy cache
-}
-//
-?>
+<?php
+/************************************************************************
+ * MXChange v0.2.1                                    Start: 11/14/2004 *
+ * ===============                              Last change: 11/19/2004 *
+ *                                                                      *
+ * -------------------------------------------------------------------- *
+ * File              : monthly_bonus.php                                *
+ * -------------------------------------------------------------------- *
+ * Short description : Monthly bonus from click-bonus                   *
+ * -------------------------------------------------------------------- *
+ * Kurzbeschreibung  : Monatlicher Bonus von Klick-Verguetung           *
+ * -------------------------------------------------------------------- *
+ *                                                                      *
+ * -------------------------------------------------------------------- *
+ * 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 or no daily reset
+if (($CSS == 1) || (!defined('__DAILY_RESET'))) return;
+
+// Get current month (2 digits)
+$curr = date("m", time());
+
+if (($curr != $CONFIG['bonus_month']) && ($CONFIG['bonus_ranks'] > 0) && ($CSS != 1))
+{
+	// Extension "autopurge" is inactive or purging of inactive accounts is deactivated
+	$WHERE1 = "WHERE status='CONFIRMED'";
+	$WHERE2 = 0;
+	$WHERE3 = bigintval($CONFIG['bonus_ranks']);
+
+	// Shall I keep inactive members away from here? (mostly wanted in an "active-rallye" ...)
+	if (EXT_IS_ACTIVE("autopurge"))
+	{
+		// Use last online stamp only when autopurge for inactive members is activated
+		if ($CONFIG['ap_in_since'] > 0)
+		{
+			// Okay, include last online timestamp
+			$WHERE1 = "WHERE status='CONFIRMED' AND last_online >=";
+			$WHERE2 = bigintval(time() - $CONFIG['ap_in_since']);
+			$WHERE3 = bigintval($CONFIG['bonus_ranks']);
+		}
+	}
+
+	// Add more bonus points here
+	$ADD = " AND (0";
+	if ($CONFIG['bonus_click_yn'] == "Y") $ADD .= " + turbo_bonus";
+	if ($CONFIG['bonus_login_yn'] == "Y") $ADD .= " + login_bonus";
+	if ($CONFIG['bonus_order_yn'] == "Y") $ADD .= " + bonus_order";
+	if ($CONFIG['bonus_stats_yn'] == "Y") $ADD .= " + bonus_stats";
+	if ($CONFIG['bonus_ref_yn']   == "Y") $ADD .= " + bonus_ref";
+	$ADD .= ") > 0";
+
+	// SQL string to check for accounts
+	$result_main = SQL_QUERY_ESC("SELECT userid, email, (turbo_bonus + login_bonus + bonus_order + bonus_stats + bonus_ref) AS active_bonus
+FROM "._MYSQL_PREFIX."_user_data
+".$WHERE1." %s".$ADD."
+ORDER BY active_bonus DESC, userid LIMIT %s",
+ array($WHERE2, $WHERE3), __FILE__, __LINE__);
+
+	if (SQL_NUMROWS($result_main) > 0)
+	{
+		// Load our winners...
+		$UIDs = "";
+		while(list($uid, $email, $points) = SQL_FETCHROW($result_main))
+		{
+			// Add userids in a row
+			$UIDs .= ",'".$uid."'";
+
+			// Add points to user's account directly
+			$result_data = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points
+SET points=points+%s WHERE ref_depth='0' AND userid=%d LIMIT 1",
+ array($points, bigintval($uid)), __FILE__, __LINE__);
+
+			// Update mediadata as well
+			if (GET_EXT_VERSION("mediadata") >= "0.0.4")
+			{
+				// Update database
+				MEDIA_UPDATE_ENTRY(array("total_points"), "add", $points);
+			}
+
+			// Load email template and email it away
+			$msg = LOAD_EMAIL_TEMPLATE("member_bonus", $points, bigintval($uid));
+			SEND_EMAIL($email, BONUS_MONTHLY_ONLINE_BONUS, $msg);
+		}
+		// Remove first commata
+		$UIDs = substr($UIDs, 1);
+
+		// Get current month
+		$curr = date("m", time());
+		if (strlen($curr) == 1) $curr = "0".$curr;
+		if ($curr == "00") $curr = "12";
+
+		// Reset accounts
+		$result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_user_data
+SET turbo_bonus=0, login_bonus=0, bonus_order=0, bonus_stats=0, bonus_ref=0", __FILE__, __LINE__);
+
+	}
+
+	// Free memory
+	SQL_FREERESULT($result_main);
+
+	// Finally update database and config array
+	$CONFIG['bonus_month'] = $curr;
+	$result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_config SET last_bonus_month='%s' WHERE config='0' LIMIT 1",
+	 array($curr), __FILE__, __LINE__);
+
+	// Destroy cache
+}
+//
+?>