<?php
/************************************************************************
- * MXChange v0.2.1 Start: 04/12/2004 *
+ * Mailer v0.2.1-FINAL Start: 04/12/2004 *
* ================ Last change: 11/16/2004 *
* *
* -------------------------------------------------------------------- *
if ((!isGetRequestElementSet('mode')) || (getRequestElement('mode') == 'choose')) {
// Let the user choose what he wants to do
$content['refid'] = getConfig(('wernis_refid'));
- $content['wds66_id'] = 0;
-
- // Get WDS66 id
- $result = SQL_QUERY_ESC("SELECT wernis_userid FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1",
- array(getUserId()), __FILE__, __LINE__);
+ $content['wernis_userid'] = '0';
// Are there some entries?
- if (SQL_NUMROWS($result) == 1) {
- // Fetch ID
- list($content['wds66_id']) = SQL_FETCHROW($result);
+ if (fetchUserData(getMemberId())) {
+ // Fetch id
+ $content['wernis_userid'] = getUserData('wernis_userid');
} // END - if
- // Free result
- SQL_FREERESULT($result);
-
- // Is there an ID?
- if ((!empty($content['wds66_id'])) && (!isGetRequestElementSet('mode'))) {
+ // Is there an id?
+ if ((!empty($content['wernis_userid'])) && (!isGetRequestElementSet('mode'))) {
// Then use an other "mode"
setRequestGetElement('mode', '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",
- array(getUserId()), __FILE__, __LINE__);
+ $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",
+ array(getMemberId()), __FILE__, __LINE__);
// Load all rows
$content['rows'] = ''; $SW = 2;
while ($data = SQL_FETCHARRAY($result)) {
// Prepare data for output
$rowContent = array(
- 'stamp' => generateDateTime($data['wernis_timestamp'], '2'),
- 'points' => translateComma($data['wernis_amount']),
- 'acc' => bigintval($data['wernis_account']),
- 'status' => WERNIS_TRANSFER_STATUS($data['wernis_type']),
- 'raw_type' => strtolower($data['wernis_type']),
- 'sw' => $SW,
+ 'wernis_timestamp' => generateDateTime($data['wernis_timestamp'], 2),
+ 'points' => translateComma($data['wernis_amount']),
+ 'wernis_account' => bigintval($data['wernis_account']),
+ 'status' => WERNIS_TRANSFER_STATUS($data['wernis_type']),
+ 'raw_type' => strtolower($data['wernis_type']),
+ 'sw' => $SW,
);
// Load row template
}
} elseif ((getRequestElement('mode') == 'payout') && (getConfig('wernis_payout_active') == 'Y')) {
// Get total points and check if the user can request a payout
- $points = countSumTotalData(getUserId(), 'user_points', 'points') - countSumTotalData(getUserId(), 'user_data', 'used_points');
+ $points = countSumTotalData(getMemberId(), 'user_points', 'points') - countSumTotalData(getMemberId(), 'user_data', 'used_points');
// Remove the registration fee
$points = $points - getConfig('points_register');
// Is this enougth for a payout?
if ($points < getConfig('wernis_min_payout')) {
// No, then abort here
- loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_MIN_PAYOUT'), translateComma(getConfig('wernis_min_payout'))));
+ loadTemplate('admin_settings_saved', false, sprintf(
+ getMessage('WERNIS_MEMBER_MIN_PAYOUT'),
+ translateComma(getConfig('wernis_min_payout')),
+ translateComma($points)
+ ));
return;
} // END - if
// Add fees to array
WERNIS_ADD_FEES_TO_ARRAY($content);
- // Get WDS66 id
- $content['wds66_id'] = '';
- $result = SQL_QUERY_ESC("SELECT `wernis_userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1",
- array(getUserId()), __FILE__, __LINE__);
+ // Init WDS66 userid
+ $content['wernis_userid'] = '';
// Are there some entries?
- if (SQL_NUMROWS($result) == 1) {
- // Fetch ID
- list($content['wds66_id']) = SQL_FETCHROW($result);
+ if (fetchUserData(getMemberId())) {
+ // Fetch id
+ $content['wernis_userid'] = getUserData('wernis_userid');
} // END - if
-
- // Free result
- SQL_FREERESULT($result);
} elseif ((getRequestElement('mode') == 'withdraw') && (getConfig('wernis_withdraw_active') == 'Y')) {
// Get total points for just displaying them
- $points = countSumTotalData(getUserId(), 'user_points', 'points') - countSumTotalData(getUserId(), 'user_data', 'used_points');
+ $points = countSumTotalData(getMemberId(), 'user_points', 'points') - countSumTotalData(getMemberId(), 'user_data', 'used_points');
// Prepare data for the template
- $content['points'] = translateComma($points);
- $content['min_points'] = translateComma(getConfig('wernis_min_withdraw'));
- $content['wds66_id'] = '';
+ $content['points'] = translateComma($points);
+ $content['min_points'] = translateComma(getConfig('wernis_min_withdraw'));
+ $content['wernis_userid'] = '';
// Add fees to array
WERNIS_ADD_FEES_TO_ARRAY($content);
// Get WDS66 id
- $result = SQL_QUERY_ESC("SELECT `wernis_userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1",
- array(getUserId()), __FILE__, __LINE__);
-
- // Are there some entries?
- if (SQL_NUMROWS($result) == 1) {
- // Fetch ID
- list($content['wds66_id']) = SQL_FETCHROW($result);
+ if (fetchUserData(getMemberId())) {
+ // Fetch id
+ $content['wernis_userid'] = getUserData('wernis_userid');
} // END - if
-
- // Free result
- SQL_FREERESULT($result);
} else {
// Invalid mode!
loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_MODE_INVALID'), getRequestElement('mode')));
// Is the formular sent?
if ((isFormSent()) && (isGetRequestElementSet('mode'))) {
- // Is the user ID and password set?
- if (!isPostRequestElementSet(('wds66_id'))) {
- // Nothing entered in WDS66 user ID
+ // Is the user id and password set?
+ if (!isPostRequestElementSet(('wernis_userid'))) {
+ // Nothing entered in WDS66 user id
loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_EMPTY_USERNAME'));
} elseif (!isPostRequestElementSet(('wds66_password'))) {
// Nothing entered in WDS66 password
} elseif (!isPostRequestElementSet(('amount'))) {
// Nothing entered in amount
loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_EMPTY_AMOUNT'));
- } elseif (postRequestElement('wds66_id') != bigintval(postRequestElement('wds66_id'))) {
- // Only numbers in account ID!
+ } elseif (postRequestElement('wernis_userid') != bigintval(postRequestElement('wernis_userid'))) {
+ // Only numbers in account id!
loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_INVALID_USERNAME'));
} elseif (postRequestElement('amount') != bigintval(postRequestElement('amount'))) {
// Only numbers in amount!
} else {
// Check input data depending on the mode and execute the requested mode
switch (getRequestElement('mode')) {
- case "withdraw": // Widthdraws WDS66 -> This exchange
+ case 'withdraw': // Widthdraws WDS66 -> This exchange
if (postRequestElement('amount') < getConfig('wernis_min_withdraw')) {
// Not enougth entered!
- loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_AMOUNT_SMALLER_MIN'), getConfig(('wernis_min_withdraw'))));
+ loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_AMOUNT_SMALLER_MIN'), translateComma(getConfig('wernis_min_withdraw'))));
} else {
// All is fine here so do the withdraw
- $success = WERNIS_EXECUTE_WITHDRAW(postRequestElement('wds66_id'), md5(postRequestElement('wds66_password')), postRequestElement('amount'));
+ $success = WERNIS_EXECUTE_WITHDRAW(postRequestElement('wernis_userid'), md5(postRequestElement('wds66_password')), postRequestElement('amount'));
if ($success === true) {
// Add it to this amount
- addPointsDirectly('wernis_withdraw', getUserId(), bigintval(postRequestElement('amount')));
+ addPointsDirectly('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",
- array(bigintval(postRequestElement('wds66_id')), getUserId()), __FILE__, __LINE__);
+ array(bigintval(postRequestElement('wernis_userid')), getMemberId()), __FILE__, __LINE__);
// All done!
loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_WITHDRAW_DONE'));
return;
- } elseif ((GET_WERNIS_ERROR_CODE() == "user_failed") || (GET_WERNIS_ERROR_CODE() == "own_failed") || (GET_WERNIS_ERROR_CODE() == "amount_failed")) {
+ } elseif ((GET_WERNIS_ERROR_CODE() == 'user_failed') || (GET_WERNIS_ERROR_CODE() == 'own_failed') || (GET_WERNIS_ERROR_CODE() == 'amount_failed')) {
// Wrong login data
loadTemplate('admin_settings_saved', false, GET_WERNIS_ERROR_MESSAGE());
} else {
case 'payout': // Payout this exchange -> WDS66
if (postRequestElement('amount') < getConfig('wernis_min_payout')) {
// Not enougth entered!
- loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_AMOUNT_SMALLER_MIN'), getConfig(('wernis_min_payout'))));
+ loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_AMOUNT_SMALLER_MIN'), translateComma(getConfig('wernis_min_payout'))));
} elseif (postRequestElement('amount') > $points) {
// Not enougth points left!
loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_PAYOUT_POINTS_DEPLETED'), bigintval(postRequestElement('amount')), bigintval($points)));
} else {
// All is fine here so do the withdraw
- $success = WERNIS_EXECUTE_PAYOUT(postRequestElement('wds66_id'), postRequestElement('amount'));
+ $success = WERNIS_EXECUTE_PAYOUT(postRequestElement('wernis_userid'), postRequestElement('amount'));
if ($success === true) {
// Sub points
- subtractPoints('wernis_payout', getUserId(), postRequestElement('amount'));
+ 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",
- array(bigintval(postRequestElement('wds66_id')), getUserId()), __FILE__, __LINE__);
+ array(bigintval(postRequestElement('wernis_userid')), getMemberId()), __FILE__, __LINE__);
// All done!
loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_PAYOUT_DONE'));