* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2011 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 *
// Some security stuff...
if (!defined('__SECURITY')) {
- die();
+ exit();
} elseif (!isMember()) {
// User is not logged in
redirectToIndexMemberOnlyModule();
} // END - if
// Init the content array and points
-$content = array(); $points = false;
+$content = array(); $points = FALSE;
// Is the mode set (withdraw or payout)
if ((!isGetRequestElementSet('do')) || (getRequestElement('do') == 'choose')) {
setGetRequestElement('do', 'list');
// And load all rows!
- $result = SQL_QUERY_ESC("SELECT `id`,`wernis_account`,`wernis_amount`,`wernis_timestamp`,`wernis_type` FROM `{?_MYSQL_PREFIX?}_user_wernis` WHERE `userid`=%s ORDER BY `wernis_timestamp` DESC",
+ $result = sqlQueryEscaped("SELECT `id`, `wernis_account`, `wernis_amount`, `wernis_timestamp`, `wernis_type` FROM `{?_MYSQL_PREFIX?}_user_wernis` WHERE `userid`=%s ORDER BY `wernis_timestamp` DESC",
array(getMemberId()), __FILE__, __LINE__);
// Load all rows
$content['rows'] = '';
- while ($data = SQL_FETCHARRAY($result)) {
+ while ($data = sqlFetchArray($result)) {
// Prepare data for output
$rowContent = array(
'wernis_timestamp' => generateDateTime($data['wernis_timestamp'], 2),
);
// Load row template
- $content['rows'] .= loadTemplate('member_wernis_mode_list_row', true, $rowContent);
+ $content['rows'] .= loadTemplate('member_wernis_mode_list_row', TRUE, $rowContent);
} // END - while
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} else {
// Default links are not active!
$content['payout_link'] = '<span class="bad">{--MEMBER_WERNIS_PAYOUT_DISABLED--}</span>';
$points = getTotalPoints(getMemberId()) - getPointsRegister();
// Is there a percentage or fixed fee?
- $points = WERNIS_TAKE_FEE($points, 'payout');
+ $points = calculateWernisFee($points, 'payout');
// Is this enougth for a payout?
if ($points < getConfig('wernis_min_payout')) {
displayMessage('{--MEMBER_WERNIS_WITHDRAW_AMOUNT_SMALLER_MIN--}');
} else {
// All is fine here so do the withdraw
- $success = WERNIS_EXECUTE_WITHDRAW(postRequestElement('wernis_userid'), md5(postRequestElement('wds66_password')), postRequestElement('amount'));
- if ($success === true) {
+ $success = executeWernisWithdraw(postRequestElement('wernis_userid'), hashSha256(postRequestElement('wds66_password')), postRequestElement('amount'));
+ if ($success === TRUE) {
// Add it to this amount
initReferralSystem();
addPointsThroughReferralSystem('wernis_withdraw', getMemberId(), bigintval(postRequestElement('amount')));
// Update the user data as well..
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `wernis_userid`=%s WHERE `userid`=%s LIMIT 1",
+ sqlQueryEscaped('UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `wernis_userid`=%s WHERE `userid`=%s LIMIT 1',
array(bigintval(postRequestElement('wernis_userid')), getMemberId()), __FILE__, __LINE__);
// All done!
displayMessage('{--MEMBER_WERNIS_WITHDRAW_DONE--}');
return;
- } elseif ((GET_WERNIS_ERROR_CODE() == 'user_failed') || (GET_WERNIS_ERROR_CODE() == 'own_failed') || (GET_WERNIS_ERROR_CODE() == 'amount_failed')) {
+ } elseif ((getWernisErrorCode() == 'user_failed') || (getWernisErrorCode() == 'own_failed') || (getWernisErrorCode() == 'amount_failed')) {
// Wrong login data
- displayMessage(GET_WERNIS_ERROR_MESSAGE());
+ displayMessage(getWernisErrorMessage());
} else {
// Something went wrong
displayMessage('{--MEMBER_WERNIS_WITHDRAW_FAILED--}');
displayMessage(sprintf(getMessage('MEMBER_WERNIS_PAYOUT_POINTS_DEPLETED'), bigintval(postRequestElement('amount')), bigintval($points)));
} else {
// All is fine here so do the withdraw
- $success = WERNIS_EXECUTE_PAYOUT(postRequestElement('wernis_userid'), postRequestElement('amount'));
- if ($success === true) {
+ $success = executeWernisPayout(postRequestElement('wernis_userid'), postRequestElement('amount'));
+ if ($success === TRUE) {
// Sub points and ignore return status
subtractPoints('wernis_payout', getMemberId(), postRequestElement('amount'));
// Update WDS66 id
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `wernis_userid`=%s WHERE `userid`=%s LIMIT 1",
+ sqlQueryEscaped('UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `wernis_userid`=%s WHERE `userid`=%s LIMIT 1',
array(bigintval(postRequestElement('wernis_userid')), getMemberId()), __FILE__, __LINE__);
// All done!
displayMessage('{--MEMBER_WERNIS_PAYOUT_DONE--}');
return;
- } elseif ((GET_WERNIS_ERROR_CODE() == 'user_failed') || (GET_WERNIS_ERROR_CODE() == 'own_failed') || (GET_WERNIS_ERROR_CODE() == 'amount_failed') || (GET_WERNIS_ERROR_CODE() == 'api_amount_failed')) {
+ } elseif ((getWernisErrorCode() == 'user_failed') || (getWernisErrorCode() == 'own_failed') || (getWernisErrorCode() == 'amount_failed') || (getWernisErrorCode() == 'api_amount_failed')) {
// Wrong login data
- displayMessage(GET_WERNIS_ERROR_MESSAGE());
+ displayMessage(getWernisErrorMessage());
} else {
// Something went wrong
displayMessage('{--MEMBER_WERNIS_PAYOUT_FAILED--}');
break;
default: // Invalid mode!
- logDebugMessage(__FILE__, __LINE__, sprintf("Invalid mode %s detected.", getRequestElement('do')));
+ logDebugMessage(__FILE__, __LINE__, sprintf('Invalid mode %s detected.', getRequestElement('do')));
displayMessage('{%message,MEMBER_WERNIS_MODE_INVALID=' . getRequestElement('do') . '%}');
return;
} // END - switch
} // END - if
// Prepare mode for template name
-$mode = sprintf("member_wernis_mode_%s", getRequestElement('do'));
+$mode = sprintf('member_wernis_mode_%s', getRequestElement('do'));
// Load the template
-loadTemplate($mode, false, $content);
+loadTemplate($mode, FALSE, $content);
// [EOF]
?>