X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fsponsor_functions.php;h=fac07ce8cad9b34676fd8cfd024998f98b6b109c;hp=faca46db8506fa7d15fb4a6c0c0963c6aff83642;hb=c3b4eaf29946349ff058691db2dcb615a5379bb2;hpb=4130013da63b89ebbd25b0c2720be9a0059b37da diff --git a/inc/libs/sponsor_functions.php b/inc/libs/sponsor_functions.php index faca46db85..fac07ce8ca 100644 --- a/inc/libs/sponsor_functions.php +++ b/inc/libs/sponsor_functions.php @@ -14,11 +14,9 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -66,8 +64,7 @@ function handleSponsorRequest ($postData, $update=false, $messageArray=array(), foreach ($postData as $k => $v) { if (!(array_search($k, $SKIPPED) > -1)) { // Check only posted input entries not the submit button - switch ($k) - { + switch ($k) { case 'email': $ALREADY = false; if (!isEmailValid($v)) { @@ -111,14 +108,14 @@ function handleSponsorRequest ($postData, $update=false, $messageArray=array(), // Test if there is are time selections convertSelectionsToTimestamp($postData, $DATA, $k, $skip); break; - } + } // END - switch if ((!empty($k)) && ($skip == false)) { // Add data $DATA['keys'][] = $k; $DATA['values'][] = $v; - } - } - } + } // END - if + } // END - if + } // END - foreach // Save sponsor? if ($SAVE === true) { @@ -134,7 +131,7 @@ function handleSponsorRequest ($postData, $update=false, $messageArray=array(), $sql = "UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET "; foreach ($DATA['keys'] as $k => $v) { $sql .= $v."='%s', "; - } + } // END - foreach // Remove last ", " from SQL string $sql = substr($sql, 0, -2)." WHERE `id`=%s LIMIT 1"; @@ -145,7 +142,6 @@ function handleSponsorRequest ($postData, $update=false, $messageArray=array(), $ret = 'updated'; } elseif (($ALREADY === false) || (($postData['force'] == 1) && (isAdmin()))) { // Add new sponsor, first add more data - $DATA['keys'][] = 'sponsor_created'; $DATA['values'][] = time(); $DATA['keys'][] = 'status'; if (($update === true) && (isAdmin()) && (getWhat() == 'add_sponsor')) { // Only allowed for admin @@ -160,6 +156,7 @@ function handleSponsorRequest ($postData, $update=false, $messageArray=array(), // Generate hash code $DATA['keys'][] = 'hash'; + // @TODO Rewrite this to API function $DATA['values'][] = md5(session_id().':'.$postData['email'].':'.detectRemoteAddr().':'.detectUserAgent().':'.time()); $DATA['keys'][] = 'remote_addr'; $DATA['values'][] = detectRemoteAddr(); @@ -219,7 +216,7 @@ function handleSponsorRequest ($postData, $update=false, $messageArray=array(), return $ret; } -// +// Translate the account status function sponsorTranslateUserStatus ($status) { // Construct constant name $constantName = sprintf("ACCOUNT_STATUS_%s", $status); @@ -230,9 +227,9 @@ function sponsorTranslateUserStatus ($status) { $ret = getMessage($constantName); } else { // Not found! - /* DEBUG: */ debug_report_bug(__FUNCTION__, __LINE__, sprintf("Unknown status %s detected.", $status)); + //* DEBUG: */ debug_report_bug(__FUNCTION__, __LINE__, sprintf("Unknown status %s detected.", $status)); logDebugMessage(__FUNCTION__, __LINE__, sprintf("Unknown status %s detected.", $status)); - $ret = getMaskedMessage('ACCOUNT_STATUS_UNKNOWN_STATUS', $status); + $ret = getMaskedMessage('ACCOUNT_STATUS_UNKNOWN', $status); } // Return status @@ -362,7 +359,7 @@ function updateSponsorLogin () { SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET - `last_online`=UNIX_TIMESTAMP() + `last_online`=NOW() WHERE `id`=%s AND `password`='%s' @@ -373,7 +370,7 @@ LIMIT 1", ), __FUNCTION__, __LINE__); // This update went fine? - $login = (SQL_AFFECTEDROWS() == 1); + $login = (!SQL_HASZEROAFFECTED()); } // END - if // Return status @@ -386,8 +383,8 @@ function saveSponsorData ($postData, $content) { // Unsecure data which we don't want $UNSAFE = array('password', 'id', 'remote_addr', 'sponsor_created', 'last_online', 'status', 'ref_count', - 'points_amount', 'points_used', 'refid', 'hash', 'last_pay', 'last_curr', 'pass_old', - 'ok', 'pass1', 'pass2'); + 'points_amount', 'points_used', 'refid', 'hash', 'last_payment', 'last_currency', + 'pass_old', 'ok', 'pass1', 'pass2'); // Set default message ("not saved") $message = '{--SPONSOR_ACCOUNT_DATA_NOT_SAVED--}'; @@ -430,14 +427,17 @@ function saveSponsorData ($postData, $content) { $sql .= " `status`='EMAIL', `hash`='%s',"; // Generate hash code - $HASH = md5(session_id().':'.$postData['email'].':'.detectRemoteAddr().':'.detectUserAgent().':'.time()); + // @TODO Rewrite this to API function + $HASH = md5(session_id() . ':' . $postData['email'] . ':' . detectRemoteAddr() . ':' . detectUserAgent() . ':' . time()); $DATA[] = $HASH; } // END - if } // END - if - // Remove last commata $sql = substr($sql, 0, -1); + // Add last_change + $sql .= ', `last_change`=NOW()'; + // Add SQL tail data $sql .= " WHERE `id`=%s AND `password`='%s' LIMIT 1"; $DATA[] = bigintval(getSession('sponsor_id')); @@ -473,7 +473,7 @@ function saveSponsorData ($postData, $content) { } // END - switch // Has an entry updated? - if (SQL_AFFECTEDROWS() == 1) { + if (!SQL_HASZEROAFFECTED()) { // Template and subject are set? if (!empty($templ) && !empty($subj)) { // Run SQL command and check for success @@ -566,7 +566,7 @@ function doProcessSponsorFormRequest ($messageArray = array()) { case 'added': // Sponsor successfully added with account status = UNCONFIRMED! // Check for his id number $result = SQL_QUERY_ESC("SELECT `id`, `hash` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `email`='%s' LIMIT 1", - array(postRequestParameter('email')), __FILE__, __LINE__); + array(postRequestParameter('email')), __FUNCTION__, __LINE__); if (SQL_NUMROWS($result) == 1) { // id found so let's load it for the confirmation email list($id, $hash) = SQL_FETCHROW($result); @@ -599,7 +599,7 @@ function doProcessSponsorFormRequest ($messageArray = array()) { break; default: - logDebugMessage(__FILE__, __LINE__, sprintf("Unknown status %s detected.", $status)); + logDebugMessage(__FUNCTION__, __LINE__, sprintf("Unknown status %s detected.", $status)); if (!isAdmin()) { // Message for testing admin $message = getMaskedMessage('ADMIN_SPONSOR_UNKNOWN_STATUS', $status); @@ -608,7 +608,7 @@ function doProcessSponsorFormRequest ($messageArray = array()) { $message = getMaskedMessage('SPONSOR_UNKNOWN_STATUS', $status); } break; - } + } // END - switch // Return message return $message; @@ -696,10 +696,10 @@ function fetchSponsorData ($sponsor_id, $column = 'id') { if (isset($GLOBALS['sponsor_data'][getCurrentSponsorId()]['last_failure'])) { // Backup the raw one and zero it $GLOBALS['sponsor_data'][getCurrentSponsorId()]['last_failure_raw'] = $GLOBALS['sponsor_data'][getCurrentSponsorId()]['last_failure']; - $GLOBALS['sponsor_data'][getCurrentSponsorId()]['last_failure'] = '0'; + $GLOBALS['sponsor_data'][getCurrentSponsorId()]['last_failure'] = null; // Is it not zero? - if ($GLOBALS['sponsor_data'][getCurrentSponsorId()]['last_failure_raw'] != '0000-00-00 00:00:00') { + if (!is_null($GLOBALS['sponsor_data'][getCurrentSponsorId()]['last_failure_raw'])) { // Seperate data/time $array = explode(' ', $GLOBALS['sponsor_data'][getCurrentSponsorId()]['last_failure_raw']); @@ -803,13 +803,13 @@ function isCurrentSponsorIdSet () { // Is given sponsor_id valid? function isValidSponsorId ($sponsor_id) { // Do we have cache? - if (!isset($GLOBALS['is_valid_sponsor_id'][$sponsor_id])) { + if (!isset($GLOBALS[__FUNCTION__][$sponsor_id])) { // Check it out - $GLOBALS['is_valid_sponsor_id'][$sponsor_id] = ((!is_null($sponsor_id)) && (!empty($sponsor_id)) && ($sponsor_id > 0)); + $GLOBALS[__FUNCTION__][$sponsor_id] = ((!is_null($sponsor_id)) && (!empty($sponsor_id)) && ($sponsor_id > 0)); } // END - if // Return cache - return $GLOBALS['is_valid_sponsor_id'][$sponsor_id]; + return $GLOBALS[__FUNCTION__][$sponsor_id]; } // Getter for sponsor data @@ -835,7 +835,38 @@ function determineSponsorCountry ($sponsor_id) { // Destroy sponsor session function destroySponsorSession () { // Remove all user data from session - return ((setSession('sponsor_id', '')) && (setSession('sponsor_pass', ''))); + return ( + (setSession('sponsor_id', '')) && + (setSession('sponsor_pass', '')) && + ( + ((isExtensionActive('theme')) && (setTheme(''))) || + (!isExtensionActive('theme')) + ) + ); +} + +// Getter for sponsor_min_points +function getSponsorMinPoints () { + // Do we have cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('sponsor_min_points'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for sponsor_ref_points +function getSponsorRefPoints () { + // Do we have cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('sponsor_ref_points'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; } // [EOF]