X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-wernis.php;h=1409dccf16000e7bb513c22d671634db36768a9f;hb=b8a6f8012aa3509d8e0f8fd078e044f20e80707a;hp=33ffa15f14a15f5753ceb695e21f56fd33a2f542;hpb=7e500b4e3a3c25881e5d7da8ff77d86344ae4cd7;p=mailer.git diff --git a/inc/modules/member/what-wernis.php b/inc/modules/member/what-wernis.php index 33ffa15f14..1409dccf16 100644 --- a/inc/modules/member/what-wernis.php +++ b/inc/modules/member/what-wernis.php @@ -1,7 +1,7 @@ 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 @@ -118,13 +111,13 @@ if ((!isGetRequestElementSet('mode')) || (getRequestElement('mode') == 'choose') // Is the payout mode active? if (getConfig('wernis_payout_active') == 'Y') { // Add link - $content['payout_link'] = "
{--MEMBER_WERNIS_MODE_PAYOUT--}
"; + $content['payout_link'] = "
{--MEMBER_WERNIS_MODE_PAYOUT--}
"; } // END - if // Is the withdraw mode active? if (getConfig('wernis_withdraw_active') == 'Y') { // Add link - $content['withdraw_link'] = "
{--MEMBER_WERNIS_MODE_WITHDRAW--}
"; + $content['withdraw_link'] = "
{--MEMBER_WERNIS_MODE_WITHDRAW--}
"; } // END - if // Mode chooser! ;-) @@ -132,7 +125,7 @@ if ((!isGetRequestElementSet('mode')) || (getRequestElement('mode') == 'choose') } } 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'); @@ -162,43 +155,31 @@ if ((!isGetRequestElementSet('mode')) || (getRequestElement('mode') == 'choose') // 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'))); @@ -207,9 +188,9 @@ if ((!isGetRequestElementSet('mode')) || (getRequestElement('mode') == 'choose') // 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 @@ -217,8 +198,8 @@ if ((isFormSent()) && (isGetRequestElementSet('mode'))) { } 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! @@ -232,14 +213,14 @@ if ((isFormSent()) && (isGetRequestElementSet('mode'))) { 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')); @@ -263,14 +244,14 @@ if ((isFormSent()) && (isGetRequestElementSet('mode'))) { 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'));