X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Flibs%2Fbonus_functions.php;h=72b6b2e24d47c57dcca4ddbd237100a2b3bb4f55;hb=039203d5428c9c6a3bed61fb3a9a16958c6fd44c;hp=68543dc05af460b7da3b2c0427de8766f5bc7ba1;hpb=dcab53bf379a6e7a0224b255dfab06512cb694dd;p=mailer.git

diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php
index 68543dc05a..72b6b2e24d 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                              *
@@ -47,7 +47,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 +93,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 +124,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));
@@ -132,15 +141,15 @@ function addBonusRanks ($data, $type, $userid) {
 		// Transfer data to template
 		$GLOBALS['ranking_content']['yr_level']  = $GLOBALS['ranking_content']['level'];
 		$GLOBALS['ranking_content']['yr_points'] = translateComma($GLOBALS['ranking_content']['points']);
-		$GLOBALS['ranking_content']['yr_tmark']  = generateDateTime($GLOBALS['ranking_content']['timemark'], '1');
+		$GLOBALS['ranking_content']['yr_tmark']  = generateDateTime($GLOBALS['ranking_content']['timemark'], 1);
 
 		// Load template
 		$GLOBALS['ranking_content']['own'] = loadTemplate('show_bonus_yr', true, $GLOBALS['ranking_content']);
 	} // 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 +201,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']."\">&nbsp;".$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 +218,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";
 	}
@@ -238,22 +247,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 +270,7 @@ function handleBonusPoints ($mode) {
 				$dummy = subtractPointsFromJackpot($points);
 			}
 			break;
-	}
+	} // END - switch
 }
 
 // Purges expired fast-click bonus entries
@@ -276,5 +284,48 @@ function purgeExpiredTurboBonus() {
 	} // 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) && (getRequestElement('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]
 ?>