X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-wernis.php;h=8eec7984815a7ec1312332fe13a1b236b0111ba3;hp=68027d126ec4c217b4f45332d49d9eb99d55cfff;hb=9f6c30cc0e06098171d773d671292081ecee3d29;hpb=7bfee4bc71e5b7b741f3451b27ba0a09574dfca8

diff --git a/inc/modules/member/what-wernis.php b/inc/modules/member/what-wernis.php
index 68027d126e..8eec798481 100644
--- a/inc/modules/member/what-wernis.php
+++ b/inc/modules/member/what-wernis.php
@@ -66,23 +66,16 @@ $content = array(); $points = false;
 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) {
+	if (fetchUserData(getUserId())) {
 		// Fetch id
-		list($content['wds66_id']) = SQL_FETCHROW($result);
+		$content['wernis_userid'] = getUserData('wernis_userid');
 	} // END - if
 
-	// Free result
-	SQL_FREERESULT($result);
-
 	// Is there an id?
-	if ((!empty($content['wds66_id'])) && (!isGetRequestElementSet('mode'))) {
+	if ((!empty($content['wernis_userid'])) && (!isGetRequestElementSet('mode'))) {
 		// Then use an other "mode"
 		setRequestGetElement('mode', 'list');
 
@@ -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) {
+	if (fetchUserData(getUserId())) {
 		// Fetch id
-		list($content['wds66_id']) = SQL_FETCHROW($result);
+		$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');
 
 	// 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) {
+	if (fetchUserData(getUserId())) {
 		// Fetch id
-		list($content['wds66_id']) = SQL_FETCHROW($result);
+		$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')));
@@ -208,7 +189,7 @@ 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'))) {
+	if (!isPostRequestElementSet(('wernis_userid'))) {
 		// Nothing entered in WDS66 user id
 		loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_EMPTY_USERNAME'));
 	} elseif (!isPostRequestElementSet(('wds66_password'))) {
@@ -217,7 +198,7 @@ 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'))) {
+	} 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'))) {
@@ -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')));
 
 						// 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__);
 
 						// 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'));
 
 						// 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__);
 
 						// All done!
 						loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_PAYOUT_DONE'));