Some fixes:

[mailer.git] / inc / modules / member / what-wernis.php

diff --git a/inc/modules/member/what-wernis.php b/inc/modules/member/what-wernis.php
index 2086288fef4fe2da3e5118865ddf3acf0bd5ba4c..b5d5e31cfdd861dd8b5788196d7130e0ba4cb566 100644 (file)
--- a/inc/modules/member/what-wernis.php
+++ b/inc/modules/member/what-wernis.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -59,7 +59,7 @@ if ((getWernisApiId() == '') || (getWernisApiMd5() == '')) {
 } // END - if
 
 // Init the content array and points
-$content = array(); $points = false;
+$content = array(); $points = FALSE;
 
 // Is the mode set (withdraw or payout)
 if ((!isGetRequestElementSet('do')) || (getRequestElement('do') == 'choose')) {
@@ -72,12 +72,12 @@ if ((!isGetRequestElementSet('do')) || (getRequestElement('do') == 'choose')) {
                setGetRequestElement('do', '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",
+               $result = sqlQueryEscaped("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'] = '';
-               while ($data = SQL_FETCHARRAY($result)) {
+               while ($data = sqlFetchArray($result)) {
                        // Prepare data for output
                        $rowContent = array(
                                'wernis_timestamp' => generateDateTime($data['wernis_timestamp'], 2),
@@ -87,11 +87,11 @@ if ((!isGetRequestElementSet('do')) || (getRequestElement('do') == 'choose')) {
                        );
 
                        // Load row template
-                       $content['rows'] .= loadTemplate('member_wernis_mode_list_row', true, $rowContent);
+                       $content['rows'] .= loadTemplate('member_wernis_mode_list_row', TRUE, $rowContent);
                } // END - while
 
                // Free result
-               SQL_FREERESULT($result);
+               sqlFreeResult($result);
        } else {
                // Default links are not active!
                $content['payout_link']   = '<span class="bad">{--MEMBER_WERNIS_PAYOUT_DISABLED--}</span>';
@@ -172,14 +172,14 @@ if ((isFormSent()) && (isGetRequestElementSet('do'))) {
                                        displayMessage('{--MEMBER_WERNIS_WITHDRAW_AMOUNT_SMALLER_MIN--}');
                                } else {
                                        // All is fine here so do the withdraw
-                                       $success = WERNIS_EXECUTE_WITHDRAW(postRequestElement('wernis_userid'), md5(postRequestElement('wds66_password')), postRequestElement('amount'));
-                                       if ($success === true) {
+                                       $success = WERNIS_EXECUTE_WITHDRAW(postRequestElement('wernis_userid'), hashSha256(postRequestElement('wds66_password')), postRequestElement('amount'));
+                                       if ($success === TRUE) {
                                                // Add it to this amount
                                                initReferralSystem();
                                                addPointsThroughReferralSystem('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",
+                                               sqlQueryEscaped('UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `wernis_userid`=%s WHERE `userid`=%s LIMIT 1',
                                                        array(bigintval(postRequestElement('wernis_userid')), getMemberId()), __FILE__, __LINE__);
 
                                                // All done!
@@ -205,12 +205,12 @@ if ((isFormSent()) && (isGetRequestElementSet('do'))) {
                                } else {
                                        // All is fine here so do the withdraw
                                        $success = WERNIS_EXECUTE_PAYOUT(postRequestElement('wernis_userid'), postRequestElement('amount'));
-                                       if ($success === true) {
+                                       if ($success === TRUE) {
                                                // Sub points and ignore return status
                                                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",
+                                               sqlQueryEscaped('UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `wernis_userid`=%s WHERE `userid`=%s LIMIT 1',
                                                        array(bigintval(postRequestElement('wernis_userid')), getMemberId()), __FILE__, __LINE__);
 
                                                // All done!
@@ -227,7 +227,7 @@ if ((isFormSent()) && (isGetRequestElementSet('do'))) {
                                break;
 
                        default: // Invalid mode!
-                               logDebugMessage(__FILE__, __LINE__, sprintf("Invalid mode %s detected.", getRequestElement('do')));
+                               logDebugMessage(__FILE__, __LINE__, sprintf('Invalid mode %s detected.', getRequestElement('do')));
                                displayMessage('{%message,MEMBER_WERNIS_MODE_INVALID=' . getRequestElement('do') . '%}');
                                return;
                } // END - switch
@@ -235,10 +235,10 @@ if ((isFormSent()) && (isGetRequestElementSet('do'))) {
 } // END - if
 
 // Prepare mode for template name
-$mode = sprintf("member_wernis_mode_%s", getRequestElement('do'));
+$mode = sprintf('member_wernis_mode_%s', getRequestElement('do'));
 
 // Load the template
-loadTemplate($mode, false, $content);
+loadTemplate($mode, FALSE, $content);
 
 // [EOF]
 ?>