X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fbonus_functions.php;h=08a4d619b52a99753a5bff25a086db8e439ef7ac;hb=aa1fa67e62e0d175d5d801becaea4362a5b50e2a;hp=4c99ef6a3e51e920c5d6cd653d6701252fd6f78f;hpb=c2e17d983fcbc0c3bd1dd37908d87c678f0367df;p=mailer.git

diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php
index 4c99ef6a3e..08a4d619b5 100644
--- a/inc/libs/bonus_functions.php
+++ b/inc/libs/bonus_functions.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 11/10/2004 *
- * ===============                              Last change: 03/18/2005 *
+ * Mailer v0.2.1-FINAL                                Start: 11/10/2004 *
+ * ===================                          Last change: 03/18/2005 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : bonus_functions.php                              *
@@ -18,6 +18,7 @@
  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
+ * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -47,7 +48,7 @@ function addTurboBonus ($mid, $userid, $type) {
 	if (getConfig('bonus_active') != 'Y') return false;
 
 	// Init variables
-	$sql = ''; $bonus = 0; $mail = 0; $column = '';
+	$sql = ''; $bonus = '0'; $mail = '0'; $column = '';
 
 	// Select SQL command
 	switch ($type) {
@@ -93,7 +94,10 @@ function addTurboBonus ($mid, $userid, $type) {
 
 	// Add points to his account directly
 	SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `turbo_bonus`=`turbo_bonus`+%s WHERE `userid`=%s LIMIT 1",
-		array(bigintval($userid), $points), __FUNCTION__, __LINE__);
+		array(
+			bigintval($userid),
+			$points
+		), __FUNCTION__, __LINE__);
 
 	// Rember this whole data for displaying ranking list
 	SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_bonus_turbo` (`userid`, `mail_id`, `bonus_id`, `level`, `points`, `timemark`) VALUES (%s, %s, %s, %s, %s, UNIX_TIMESTAMP())",
@@ -121,7 +125,13 @@ function addBonusRanks ($data, $type, $userid) {
 
 	// Load current user's data
 	$result = SQL_QUERY_ESC("SELECT `level`, `points`, `timemark` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE `%s`=%s AND `userid`=%s LIMIT 1",
-		array($type, $data, $userid), __FUNCTION__, __LINE__);
+		array(
+			$type,
+			$data,
+			$userid
+		), __FUNCTION__, __LINE__);
+
+	// Entry found?
 	if (SQL_NUMROWS($result) == 1) {
 		// Load data
 		$GLOBALS['ranking_content'] = merge_array($GLOBALS['ranking_content'], SQL_FETCHARRAY($result));
@@ -139,8 +149,8 @@ function addBonusRanks ($data, $type, $userid) {
 	} // END - if
 
 	// Load rankings
-	$result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE %s=%s ORDER BY `level` ASC LIMIT %s",
-		array($type, $data, getConfig('bonus_lines')), __FUNCTION__, __LINE__);
+	$result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE %s=%s ORDER BY `level` ASC LIMIT {?bonus_lines?}",
+		array($type, $data), __FUNCTION__, __LINE__);
 	if (SQL_NUMROWS($result) > 0) {
 		// Start generating the ranking list
 		$max = SQL_NUMROWS($result);
@@ -192,9 +202,9 @@ LIMIT 1",
 
 			// Output row
 			$OUT .= "<tr>
-  <td class=\"bonus_rank_".$rows['rank']." bottom2 switch_sw".$rows['sw']."\">&nbsp;".$rows['rank'].".</td>
-  <td class=\"bonus_rank_".$rows['rank']." bottom2 switch_sw".$rows['sw']."\" align=\"center\">".$rows['userid']."</td>
-  <td class=\"bonus_rank_".$rows['rank']." bottom2 switch_sw".$rows['sw']."\" align=\"center\">".$rows['points']."</td>
+  <td class=\"bonus_rank_".$rows['rank']." bottom switch_sw".$rows['sw']."\">".$rows['rank'].".</td>
+  <td class=\"bonus_rank_".$rows['rank']." bottom switch_sw".$rows['sw']."\" align=\"center\">".$rows['userid']."</td>
+  <td class=\"bonus_rank_".$rows['rank']." bottom switch_sw".$rows['sw']."\" align=\"center\">".$rows['points']."</td>
 </tr>\n";
 
 			// Switch color
@@ -209,8 +219,8 @@ LIMIT 1",
 	} else {
 		// No entries found!
 		$OUT = "<tr>
-  <td colspan=\"3\" align=\"center\" height=\"30\" class=\"bottom2\">
-    <div class=\"guest_failed\">".sprintf(getMessage('BONUS_NO_RANKS'), $data)."</div>
+  <td colspan=\"3\" align=\"center\" height=\"30\" class=\"bottom\">
+    <div class=\"guest_failed\">".getMaskedMessage('BONUS_NO_RANKS', $data)."</div>
   </td>
 </tr>\n";
 	}
@@ -225,7 +235,7 @@ function handleBonusPoints ($mode) {
 	if (getConfig('bonus_active') != 'Y') return;
 
 	// Switch to jackpot-mode when no UID is supplied but userid-mode is selected
-	if ((getConfig('bonus_mode') == 'UID') && (getConfig('bonus_userid') == 0) && (isExtensionActive('jackpot'))) {
+	if ((getConfig('bonus_mode') == 'UID') && (getConfig('bonus_userid') == '0') && (isExtensionActive('jackpot'))) {
 		// Update database & config
 		updateConfiguration('bonus_mode', 'JACKPOT');
 	} // END - if
@@ -238,22 +248,21 @@ function handleBonusPoints ($mode) {
 		$points = $mode;
 	}
 
+	// Check his amount first
+	$total = countSumTotalData(getConfig('bonus_userid'), 'user_points', 'points') - countSumTotalData(getConfig('bonus_userid'), 'user_data', 'used_points');
+
 	// Subtract points from...
 	switch (getConfig('bonus_mode')) {
 		case 'JACKPOT': // ... jackpot
 			if ((isExtensionActive('jackpot')) && (subtractPointsFromJackpot($points) == -1) && (getConfig('bonus_userid') > 0)) {
-				// Check points amount first...
-				$total = countSumTotalData(getConfig('bonus_userid'), 'user_points', 'points') - countSumTotalData(getConfig('bonus_userid'), 'user_data', 'used_points');
 				if ($total >= $points) {
 					// Subtract points from userid's account
-					subtractPoints('bonus_payout_jackpot', getConfig('bonus_userid'), $points);
+					subtractPointsFromJackpot('bonus_payout_jackpot', getConfig('bonus_userid'), $points);
 				} // END - if
 			} // END - if
 			break;
 
 		case 'UID': // ... userid's account
-			// Check his amount first
-			$total = countSumTotalData(getConfig('bonus_userid'), 'user_points', 'points') - countSumTotalData(getConfig('bonus_userid'), 'user_data', 'used_points');
 			if ($total >= $points) {
 				// Subtract points from userid's account
 				subtractPoints('bonus_payout_userid', getConfig('bonus_userid'), $points);
@@ -262,7 +271,7 @@ function handleBonusPoints ($mode) {
 				$dummy = subtractPointsFromJackpot($points);
 			}
 			break;
-	}
+	} // END - switch
 }
 
 // Purges expired fast-click bonus entries
@@ -272,9 +281,52 @@ function purgeExpiredTurboBonus() {
 
 	if (SQL_AFFECTEDROWS() > 0) {
 		// Send out email to admin
-		sendAdminNotification(getMessage('AUTOPURGE_ADMIN_TURBO_SUBJECT'), 'admin_autopurge_turbo', SQL_AFFECTEDROWS(), '');
+		sendAdminNotification(getMessage('AUTOPURGE_ADMIN_TURBO_SUBJECT'), 'admin_autopurge_turbo', SQL_AFFECTEDROWS());
 	} // END - if
 }
 
-//
+///////////////////////////////////////////////////////////////////////////////
+//                              Only filter functions
+///////////////////////////////////////////////////////////////////////////////
+
+// Filter for adding login bonus to the user's account
+function FILTER_ADD_LOGIN_BONUS () {
+	// Is the user data valid?
+	if (!isMember()) {
+		// Do only run for logged in members
+		debug_report_bug('Please only run this filter for logged in users.');
+	} // END - if
+
+	// Bonus is not given by default ;-)
+	$bonus = false;
+	if ((isExtensionInstalledAndNewer('sql_patches', '0.2.8')) && (getConfig('bonus_active') == 'Y') && (getConfig('bonus_login_yn') == 'Y')) {
+		// Update last login if far enougth away
+		// @TODO This query isn't right, it will only update if the user was for a longer time away!
+		SQL_QUERY_ESC("UPDATE
+	`{?_MYSQL_PREFIX?}_user_data`
+SET
+	`last_login`=UNIX_TIMESTAMP()
+WHERE
+	`userid`=%s AND
+	`last_login` < (UNIX_TIMESTAMP() - {?login_timeout?})
+LIMIT 1",
+			array(
+				getMemberId()
+			), __FILE__, __LINE__
+		);
+
+		// Updated entry?
+		$bonus = (SQL_AFFECTEDROWS() == 1);
+	} // END - if
+
+	if (($bonus === true) && (getRequestParameter('mode') == 'bonus')) {
+		// Output message with added points
+		$GLOBALS['message'] .= '<div class="tiny">' . getMessage('BONUS_LOGIN_BONUS_ADDED') . '</div>';
+	} elseif (isExtensionActive('bonus')) {
+		// No login bonus added!
+		$GLOBALS['message'] .= '<div class="member_failed">{--BONUS_LOGIN_BONUS_NOT_ADDED--}</div>';
+	}
+}
+
+// [EOF]
 ?>