New function fetchUserData() introduced to API, total rewrite (not all)
[mailer.git] / inc / modules / member / what-wernis.php
index 68027d1..8eec798 100644 (file)
@@ -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'));