if ((!isGetRequestElementSet('mode')) || (getRequestElement('mode') == 'choose')) {
// Let the user choose what he wants to do
$content['refid'] = getConfig(('wernis_refid'));
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;
// Then use an other "mode"
setRequestGetElement('mode', 'list');
// Then use an other "mode"
setRequestGetElement('mode', 'list');
- // 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'] = '';
} 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');
// Prepare data for the template
} 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');
// 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'] = '';
- $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) {
+ if (fetchUserData(getUserId())) {
} else {
// Invalid mode!
loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_MODE_INVALID'), getRequestElement('mode')));
} else {
// Invalid mode!
loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_MODE_INVALID'), getRequestElement('mode')));
// Nothing entered in WDS66 user id
loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_EMPTY_USERNAME'));
} elseif (!isPostRequestElementSet(('wds66_password'))) {
// Nothing entered in WDS66 user id
loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_EMPTY_USERNAME'));
} elseif (!isPostRequestElementSet(('wds66_password'))) {
} elseif (!isPostRequestElementSet(('amount'))) {
// Nothing entered in amount
loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_EMPTY_AMOUNT'));
} elseif (!isPostRequestElementSet(('amount'))) {
// Nothing entered in amount
loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_EMPTY_AMOUNT'));
// Only numbers in account id!
loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_INVALID_USERNAME'));
} elseif (postRequestElement('amount') != bigintval(postRequestElement('amount'))) {
// Only numbers in account id!
loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_INVALID_USERNAME'));
} elseif (postRequestElement('amount') != bigintval(postRequestElement('amount'))) {
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
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')));
// Update the user data as well..
SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `wernis_userid`=%s WHERE `userid`=%s LIMIT 1",
if ($success === true) {
// Add it to this amount
addPointsDirectly('wernis_withdraw', getUserId(), 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')), getUserId()), __FILE__, __LINE__);
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
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
if ($success === true) {
// Sub points
subtractPoints('wernis_payout', getUserId(), postRequestElement('amount'));
// Update WDS66 id
SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `wernis_userid`=%s WHERE `userid`=%s LIMIT 1",
if ($success === true) {
// Sub points
subtractPoints('wernis_payout', getUserId(), 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')), getUserId()), __FILE__, __LINE__);