Renamed ifSqlHasZeroNums() to ifSqlHasZeroNumRows() and improved some queries.

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

diff --git a/inc/modules/member/what-refback.php b/inc/modules/member/what-refback.php
index ee7e6326a657a57a8a28d4049ee9c2cf706428a3..e9d69e6e384f1931637c4027d9329cffb7a81401 100644 (file)
--- a/inc/modules/member/what-refback.php
+++ b/inc/modules/member/what-refback.php
@@ -16,8 +16,8 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
- * For more information visit: http://www.mxchange.org                  *
+ * Copyright (c) 2009 - 2015 by Mailer Developer Team                   *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
@@ -37,7 +37,7 @@
 
 // Some security stuff...
 if (!defined('__SECURITY')) {
-       die();
+       exit();
 } elseif (!isMember()) {
        // User is not logged in
        redirectToIndexMemberOnlyModule();
@@ -46,7 +46,7 @@ if (!defined('__SECURITY')) {
        displayMessage('{--MEMBER_REFBACK_DISABLED--}');
 
        // Abort here
-       return false;
+       return FALSE;
 } // END - if
 
 // Add description as navigation point
@@ -58,16 +58,16 @@ if ((!isExtensionActive('refback')) && (!isAdmin())) {
 } // END - if
 
 // Was the form submitted?
-if ((isFormSent('edit')) && (isPostRequestParameterSet('id'))) {
+if ((isFormSent('edit')) && (isPostRequestElementSet('id'))) {
        // Okay, has the user entered some values?
-       if (isPostRequestParameterSet('refback_percents')) {
+       if (isPostRequestElementSet('refback_percents')) {
                // Revert german commta for testing
-               $percents = convertCommaToDot(postRequestParameter('refback_percents'));
+               $percents = convertCommaToDot(postRequestElement('refback_percents'));
 
                // Validate percents
                if ((($percents >= getConfig('refback_min_perc')) || (round($percents) == 0)) && ($percents <= getConfig('refback_max_perc'))) {
                        // Change ref-back for this direct id
-                       $status = updateMemberRefbackPercents(postRequestParameter('id'), postRequestParameter('refback_percents'));
+                       $status = updateMemberRefbackPercents(postRequestElement('id'), postRequestElement('refback_percents'), postRequestElement('refback_notice'));
 
                        // Check status
                        if (isset($status['ok'])) {
@@ -88,29 +88,29 @@ if ((isFormSent('edit')) && (isPostRequestParameterSet('id'))) {
                // Insert line
        } else {
                // Read data from refback table
-               $content = getArrayFromUserRefbackData(postRequestParameter('id'));
+               $content = getArrayFromUserRefbackData(postRequestElement('id'));
 
                // Load form for editing
-               loadTemplate('member_edit_refback', false, $content);
+               loadTemplate('member_edit_refback', FALSE, $content);
        }
 } // END - if
 
-// Load all referal levels
-$result = SQL_QUERY('SELECT
-       r.`level`,
-       r.`percents`
+// Load all referral levels
+$result = sqlQuery('SELECT
+       `r`.`level`,
+       `r`.`percents`
 FROM
-       `{?_MYSQL_PREFIX?}_refdepths` AS r
+       `{?_MYSQL_PREFIX?}_refdepths` AS `r`
 WHERE
-       r.level > 0
+       `r`.`level` > 0
 ORDER BY
-       r.level ASC', __FILE__, __LINE__);
+       `r`.`level` ASC', __FILE__, __LINE__);
 
 // Are there some entries? (Shall be!)
-if (!SQL_HASZERONUMS($result)) {
+if (!ifSqlHasZeroNumRows($result)) {
        // List all levels
        $OUT = '';
-       while ($content = SQL_FETCHARRAY($result)) {
+       while ($content = sqlFetchArray($result)) {
                // Init variables
                $rows = '';
                $content['counter'] = 0;
@@ -118,20 +118,19 @@ if (!SQL_HASZERONUMS($result)) {
                // Check for users ref in this level
                foreach (getArrayFromRefbackUserRefs(getMemberId(), $content['level']) as $refRow) {
                        // Not-deleted account is default
-                       $deleted = false;
+                       $deleted = FALSE;
                        if (is_null($refRow['status'])) {
-                               $deleted = true;
+                               $deleted = TRUE;
                        } // END - if
 
                        // Add/"translate" more content
-                       $refRow['click_rate']  = translateComma($refRow['click_rate'], true, 1);
-                       $refRow['joined']      = generateDateTime($refRow['joined'], '3');
+                       $refRow['joined'] = generateDateTime($refRow['joined'], '3');
 
                        // Load row template
-                       if ($deleted === true) {
-                               $rows .= loadTemplate('member_list_refback_deleted_row', true, $refRow);
+                       if ($deleted === TRUE) {
+                               $rows .= loadTemplate('member_list_refback_deleted_row', TRUE, $refRow);
                        } else {
-                               $rows .= loadTemplate('member_list_refback_row', true, $refRow);
+                               $rows .= loadTemplate('member_list_refback_row', TRUE, $refRow);
                        }
 
                        // Count this ref and switch color
@@ -142,18 +141,18 @@ if (!SQL_HASZERONUMS($result)) {
                $content['rows'] = $rows;
 
                // Load level template
-               $OUT .= loadTemplate('member_list_refback_level', true, $content);
+               $OUT .= loadTemplate('member_list_refback_level', TRUE, $content);
        } // END - while
 
        // Load main template
-       loadTemplate('member_list_refback', false, $OUT);
+       loadTemplate('member_list_refback', FALSE, $OUT);
 } else {
        // No entries
        displayMessage('{--MEMBER_REFBACK_NO_ENTRIES--}');
 }
 
 // Free result
-SQL_FREERESULT($result);
+sqlFreeResult($result);
 
 // [EOF]
 ?>