X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fbonus_functions.php;h=f18d919011e194f616dc511ccceb1084e3135d9f;hp=22c6f07d4ae698ae87e8994ff88d3ed86891ab1c;hb=e5dffd4249c97200cbad02f3f4eaf5c373fdb89a;hpb=2df9f7a53f8b1dd5164f87824a324ccb3b6634cb

diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php
index 22c6f07d4a..f18d919011 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 - 2013 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;
+		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:
@@ -70,16 +73,16 @@ function addTurboBonus ($mid, $userid, $type) {
 	// Is a column name set?
 	if (empty($column)) {
 		// No, then abort here
-		return false;
+		return FALSE;
 	} // 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,28 +140,28 @@ 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);
 
 		// Load template
-		$GLOBALS['ranking_content']['own'] = loadTemplate('show_bonus_yr', true, $GLOBALS['ranking_content']);
+		$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 {?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 (!ifSqlHasZeroNums($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,22 +177,22 @@ 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;
 
 			// Load row template
-			$OUT .= loadTemplate('member_bonus_turbo_row', true, $rows);
+			$OUT .= loadTemplate('member_bonus_turbo_row', TRUE, $rows);
 		} // END - for
 
-		if ($self === false) {
+		if ($self === FALSE) {
 			// If current user was not found set constant
 			$GLOBALS['ranking_content']['rankings'] = '{--MEMBER_BONUS_RANK_YOU_ARE_404--}';
 		} // END - if
@@ -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>';
@@ -212,17 +218,17 @@ function handleBonusPoints ($mode, $userid) {
 	} // END - if
 
 	// Default is not working
-	$return = false;
+	$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
 }
 
@@ -285,7 +291,7 @@ function isBonusRallyeActive () {
 	// Is there cache?
 	if (!isset($GLOBALS['bonus_rallye_active'])) {
 		// Just determine it
-		$GLOBALS['bonus_rallye_active'] = (getConfig('bonus_active') == 'Y');
+		$GLOBALS['bonus_rallye_active'] = (getBonusActive() == 'Y');
 	} // END - if
 
 	// Return cache
@@ -297,7 +303,7 @@ function isBonusNewMemberNotifyEnabled () {
 	// Is there cache?
 	if (!isset($GLOBALS['bonus_new_member_notify_active'])) {
 		// Just determine it
-		$GLOBALS['bonus_new_member_notify_active'] = (getConfig('bonus_new_member_notify') == 'Y');
+		$GLOBALS['bonus_new_member_notify_active'] = (getBonusNewMemberNotify() == 'Y');
 	} // END - if
 
 	// Return cache
@@ -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__] = (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__] = 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__] = (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__] = (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__] = (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__] = (getIncludeBonusStats() == 'Y');
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__];
+}
+
 // [EOF]
 ?>