X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fbonus_functions.php;h=b37f45c61cbd173e657aa5d7e231da8dcc1d5b0e;hp=3b3ad6a5fb1a2245225428cebc86499e8c601e84;hb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;hpb=596c8ab32594401ca84abfbfe35513ddfff31bec

diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php
index 3b3ad6a5fb..b37f45c61c 100644
--- a/inc/libs/bonus_functions.php
+++ b/inc/libs/bonus_functions.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2015 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -41,25 +41,28 @@ if (!defined('__SECURITY')) {
 } // END - if
 
 // This function must be run *BEFORE* a link is removed from table 'mailer_user_links' !
-function addTurboBonus ($mid, $userid, $type) {
+function addTurboBonus ($id, $userid, $type) {
 	// Shall we add bonus points?
 	if (!isBonusRallyeActive()) {
 		return FALSE;
 	} // END - if
 
 	// Init variables
-	$sql = ''; $bonus = '0'; $mail = '0'; $column = '';
+	$sql     = '';
+	$bonusId = 'NULL';
+	$mailId  = 'NULL';
+	$column  = '';
 
 	// Select SQL command
 	switch ($type) {
 		case 'bonusid':
 			$column = 'bonus_id';
-			$bonus = $mid;
+			$bonusId = $id;
 			break;
 
 		case 'mailid' :
 			$column = 'mail_id';
-			$mail = $mid;
+			$mailId = $id;
 			break;
 
 		default:
@@ -74,12 +77,12 @@ function addTurboBonus ($mid, $userid, $type) {
 	} // END - if
 
 	// Check for entry
-	$rank = countSumTotalData($mid, 'bonus_turbo', 'id', $column, TRUE) + 1;
+	$rank = countSumTotalData($id, 'bonus_turbo', 'id', $column, TRUE) + 1;
 
 	// Which rank?
 	if ($rank == 1) {
 		// First rank!
-		$points = getConfig('turbo_bonus');
+		$points = getTurboBonus();
 	} else {
 		// Anything else so let's explode all entered rank points
 		$test = explode(';', getTurboRates());
@@ -93,22 +96,23 @@ 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",
+	sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `turbo_bonus`=`turbo_bonus`+%s WHERE `userid`=%s LIMIT 1",
 		array(
 			$points,
 			bigintval($userid)
 		), __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())",
+	sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_bonus_turbo` (`userid`, `mail_id`, `bonus_id`, `level`, `points`, `timemark`) VALUES (%s, %s, %s, %s, %s, UNIX_TIMESTAMP())",
 		array(
 			bigintval($userid),
-			bigintval($mail),
-			bigintval($bonus),
+			$mailId,
+			$bonusId,
 			$rank,
 			$points
 		), __FUNCTION__, __LINE__);
 
+	// @TODO Rewrite this to a filter
 	if ((isExtensionInstalledAndNewer('bonus', '0.3.5')) && (getBonusMode() != 'ADD') && ($points > 0)) {
 		handleBonusPoints($points, $userid);
 	} // END - if
@@ -117,7 +121,9 @@ function addTurboBonus ($mid, $userid, $type) {
 //
 function addBonusRanks ($data, $type, $userid) {
 	// Init variables
-	$self = FALSE; $OUT = ''; $GLOBALS['ranking_content'] = array();
+	$self = FALSE;
+	$OUT = '';
+	$GLOBALS['ranking_content'] = array();
 
 	// Clear rankings by default
 	$GLOBALS['ranking_content']['rankings'] = '';
@@ -126,7 +132,7 @@ function addBonusRanks ($data, $type, $userid) {
 	$ranks = count(explode(';', getTurboRates())) + 1;
 
 	// 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",
+	$result = sqlQueryEscaped("SELECT `level`, `points`, `timemark` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE `%s`=%s AND `userid`=%s LIMIT 1",
 		array(
 			$type,
 			$data,
@@ -134,12 +140,12 @@ function addBonusRanks ($data, $type, $userid) {
 		), __FUNCTION__, __LINE__);
 
 	// Entry found?
-	if (SQL_NUMROWS($result) == 1) {
+	if (sqlNumRows($result) == 1) {
 		// Load data
-		$GLOBALS['ranking_content'] = merge_array($GLOBALS['ranking_content'], SQL_FETCHARRAY($result));
+		$GLOBALS['ranking_content'] = merge_array($GLOBALS['ranking_content'], sqlFetchArray($result));
 
 		// Remember all values for later use
-		$self  = TRUE;
+		$self = TRUE;
 
 		// Transfer data to template
 		$GLOBALS['ranking_content']['timemark'] = generateDateTime($GLOBALS['ranking_content']['timemark'], 1);
@@ -149,13 +155,13 @@ 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 {?bonus_lines?}",
+	$result = sqlQueryEscaped("SELECT `id` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE `%s`=%s ORDER BY `level` ASC LIMIT {?bonus_lines?}",
 		array($type, $data), __FUNCTION__, __LINE__);
-	if (!SQL_HASZERONUMS($result)) {
+	if (!ifSqlHasZeroNumRows($result)) {
 		// Output all ranks (levels)
-		for ($rank = 1; $rank <= SQL_NUMROWS($result); $rank++) {
+		for ($rank = 1; $rank <= sqlNumRows($result); $rank++) {
 			// Load data
-			$result_users = SQL_QUERY_ESC("SELECT
+			$result_users = sqlQueryEscaped("SELECT
 	`userid`,
 	`points`
 FROM
@@ -171,13 +177,13 @@ LIMIT 1",
 			$rows['points'] = '---';
 
 			// Are you one of them?
-			if (SQL_NUMROWS($result_users) == 1) {
+			if (sqlNumRows($result_users) == 1) {
 				// Load data
-				$rows = merge_array($rows, SQL_FETCHARRAY($result_users));
+				$rows = merge_array($rows, sqlFetchArray($result_users));
 			} // END - if
 
 			// Free result
-			SQL_FREERESULT($result_users);
+			sqlFreeResult($result_users);
 
 			// Add more
 			$rows['rank'] = $rank;
@@ -194,7 +200,7 @@ LIMIT 1",
 		// No entries found
 		// @TODO Move this HTML to a template
 		$OUT = '<tr>
-  <td colspan="3" align="center" height="30" class="bottom">
+  <td colspan="3" align="center" class="bottom">
     <div class="bad">{%message,MEMBER_BONUS_NO_RANKS=' . $data . '%}</div>
   </td>
 </tr>';
@@ -215,14 +221,14 @@ function handleBonusPoints ($mode, $userid) {
 	$return = FALSE;
 
 	// Switch to jackpot-mode when no UID is supplied but userid-mode is selected
-	if ((getBonusMode() == 'UID') && ($userid == '0') && (isExtensionActive('jackpot'))) {
+	if ((getBonusMode() == 'UID') && (!isValidId($userid)) && (isExtensionActive('jackpot'))) {
 		// Update database & config
 		updateConfiguration('bonus_mode', 'JACKPOT');
 	} // END - if
 
 	if ($mode == 'login_bonus') {
 		// Login bonus detected
-		$points = getConfig('login_bonus');
+		$points = getLoginBonus();
 	} else {
 		// Direct points supplied
 		$points = $mode;
@@ -238,7 +244,7 @@ function handleBonusPoints ($mode, $userid) {
 			break;
 
 		case 'JACKPOT': // ... jackpot
-			if ((isExtensionActive('jackpot')) && (subtractPointsFromJackpot($points) === FALSE) && (isValidUserId($userid))) {
+			if ((isExtensionActive('jackpot')) && (subtractPointsFromJackpot($points) === FALSE) && (isValidId($userid))) {
 				if ($total >= $points) {
 					// Subtract points from userid's account
 					$return = subtractPointsFromJackpot('bonus_payout_jackpot', $userid, $points);
@@ -266,13 +272,13 @@ function handleBonusPoints ($mode, $userid) {
 }
 
 // Purges expired fast-click bonus entries
-function purgeExpiredTurboBonus() {
+function purgeExpiredTurboBonus () {
 	// Remove entries
-	$result = SQL_QUERY('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE (UNIX_TIMESTAMP() - `timemark`) >= {?bonus_timeout?}', __FUNCTION__, __LINE__);
+	$result = sqlQuery('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE (UNIX_TIMESTAMP() - `timemark`) >= {?bonus_timeout?}', __FUNCTION__, __LINE__);
 
-	if (!SQL_HASZEROAFFECTED()) {
+	if (!ifSqlHasZeroAffectedRows()) {
 		// Send out email to admin
-		sendAdminNotification('{--ADMIN_AUTOPURGE_TURBO_SUBJECT--}', 'admin_autopurge_turbo', SQL_AFFECTEDROWS());
+		sendAdminNotification('{--ADMIN_AUTOPURGE_TURBO_SUBJECT--}', 'admin_purge_turbo', sqlAffectedRows());
 	} // END - if
 }
 
@@ -283,25 +289,25 @@ function purgeExpiredTurboBonus() {
 // Determines whether the "bonus rallye" is active
 function isBonusRallyeActive () {
 	// Is there cache?
-	if (!isset($GLOBALS['bonus_rallye_active'])) {
+	if (!isset($GLOBALS[__FUNCTION__])) {
 		// Just determine it
-		$GLOBALS['bonus_rallye_active'] = (getConfig('bonus_active') == 'Y');
+		$GLOBALS[__FUNCTION__] = ((isExtensionInstalledAndNewer('bonus', '0.4.4')) && (isConfigEntrySet('bonus_active')) && (getBonusActive() == 'Y'));
 	} // END - if
 
 	// Return cache
-	return $GLOBALS['bonus_rallye_active'];
+	return $GLOBALS[__FUNCTION__];
 }
 
 // Determines whether the "bonus new_member_notify" is active
 function isBonusNewMemberNotifyEnabled () {
 	// Is there cache?
-	if (!isset($GLOBALS['bonus_new_member_notify_active'])) {
+	if (!isset($GLOBALS[__FUNCTION__])) {
 		// Just determine it
-		$GLOBALS['bonus_new_member_notify_active'] = (getConfig('bonus_new_member_notify') == 'Y');
+		$GLOBALS[__FUNCTION__] = ((isExtensionInstalledAndNewer('bonus', '0.7.7')) && (isConfigEntrySet('bonus_new_member_notify')) && (getBonusNewMemberNotify() == 'Y'));
 	} // END - if
 
 	// Return cache
-	return $GLOBALS['bonus_new_member_notify_active'];
+	return $GLOBALS[__FUNCTION__];
 }
 
 // Getter for bonus_timeout
@@ -364,6 +370,30 @@ function getLoginTimeout () {
 	return $GLOBALS[__FUNCTION__];
 }
 
+// Getter for login_bonus
+function getLoginBonus () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('login_bonus');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for turbo_bonus
+function getTurboBonus () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('turbo_bonus');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
 // Getter for bonus_ref
 function getBonusRef () {
 	// Is there cache?
@@ -376,5 +406,257 @@ function getBonusRef () {
 	return $GLOBALS[__FUNCTION__];
 }
 
+// Getter for bonus_userid
+function getBonusUserid () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('bonus_userid');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for bonus_active
+function getBonusActive () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('bonus_active');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for bonus_notify_points
+function getBonusNotifyPoints () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('bonus_notify_points');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for bonus_new_member_notify
+function getBonusNewMemberNotify () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('bonus_new_member_notify');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for bonus_stats
+function getBonusStats () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('bonus_stats');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for bonus_order
+function getBonusOrder () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('bonus_order');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for bonus_lines
+function getBonusLines () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('bonus_lines');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for bonus_include_own
+function getBonusIncludeOwn () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('bonus_include_own');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Checks whether bonus_include_own is set to 'Y'
+function isBonusIncludeOwnEnabled () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = (getBonusIncludeOwn() == 'Y');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for bonus_disable_notify
+function getBonusDisableNotify () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('bonus_disable_notify');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for bonus_enable_notify
+function getBonusEnableNotify () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('bonus_enable_notify');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for include_bonus_click
+function getIncludeBonusClick () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('include_bonus_click');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Checks whether include_bonus_click is set to 'Y'
+function isIncludeBonusClickEnabled () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = ((isConfigEntrySet('include_bonus_click')) && (getIncludeBonusClick() == 'Y'));
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for include_bonus_login
+function getIncludeBonusLogin () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = ((isConfigEntrySet('include_bonus_login')) && getConfig('include_bonus_login'));
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Checks whether include_bonus_login is set to 'Y'
+function isIncludeBonusLoginEnabled () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = ((isConfigEntrySet('include_bonus_login')) && (getIncludeBonusLogin() == 'Y'));
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for include_bonus_order
+function getIncludeBonusOrder () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('include_bonus_order');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Checks whether include_bonus_order is set to 'Y'
+function isIncludeBonusOrderEnabled () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = ((isConfigEntrySet('include_bonus_order')) && (getIncludeBonusOrder() == 'Y'));
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for include_bonus_Ref
+function getIncludeBonusRef () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('include_bonus_ref');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Checks whether include_bonus_ref is set to 'Y'
+function isIncludeBonusRefEnabled () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = ((isConfigEntrySet('include_bonus_ref')) && (getIncludeBonusRef() == 'Y'));
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Getter for include_bonus_stats
+function getIncludeBonusStats () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = getConfig('include_bonus_stats');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Checks whether include_bonus_stats is set to 'Y'
+function isIncludeBonusStatsEnabled () {
+	// Is there cache?
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Determine it
+		$GLOBALS[__FUNCTION__] = ((isConfigEntrySet('include_bonus_stats')) && (getIncludeBonusStats() == 'Y'));
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
 // [EOF]
 ?>