More improved SQL 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 9563cf746ecef399bd91d81f9f14fff3b4e5ba1c..e751a5a9d2bcef7c11e75094154b160c9a71d2a4 100644 (file)
--- a/inc/modules/member/what-refback.php
+++ b/inc/modules/member/what-refback.php
@@ -39,14 +39,14 @@ if (!defined('__SECURITY')) {
        // User is not logged in
        LOAD_URL("modules.php?module=index");
 } elseif ((!EXT_IS_ACTIVE("refback")) && (!IS_ADMIN())) {
        // User is not logged in
        LOAD_URL("modules.php?module=index");
 } elseif ((!EXT_IS_ACTIVE("refback")) && (!IS_ADMIN())) {

-       ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "refback");
+       addFatalMessage(EXTENSION_PROBLEM_EXT_INACTIVE, "refback");

        return;
 }
 
 // Is the refback system enabled?
 if (getConfig('refback_enabled') == "N") {
        // Output message
        return;
 }
 
 // Is the refback system enabled?
 if (getConfig('refback_enabled') == "N") {
        // Output message

-       LOAD_TEMPLATE("admin_settings_saved", false, MEMBER_REFBACK_DISABLED);
+       LOAD_TEMPLATE("admin_settings_saved", false, getMessage('MEMBER_REFBACK_DISABLED'));

        // Abort here
        return false;
 } // END - if
        // Abort here
        return false;
 } // END - if


@@ -69,21 +69,20 @@ if ((isset($_POST['edit'])) && (isset($_POST['id']))) {
                        // Check status
                        if (isset($status['ok'])) {
                                // No message found
                        // Check status
                        if (isset($status['ok'])) {
                                // No message found

-                               LOAD_TEMPLATE("admin_settings_saved", false, MEMBER_REFBACK_DONE);
+                               LOAD_TEMPLATE("admin_settings_saved", false, getMessage('MEMBER_REFBACK_DONE'));

                        } elseif (isset($status['message'])) {
                                // Something went wrong with error message
                        } elseif (isset($status['message'])) {
                                // Something went wrong with error message

-                               LOAD_TEMPLATE("admin_settings_saved", false, sprintf(MEMBER_REFBACK_ERROR_MESSAGE, $status['message']));
+                               LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('MEMBER_REFBACK_ERROR_MESSAGE'), $status['message']));

                        } else {
                                // No message found
                        } else {
                                // No message found

-                               LOAD_TEMPLATE("admin_settings_saved", false, MEMBER_REFBACK_ERROR_EMPTY_MESSAGE);
+                               LOAD_TEMPLATE("admin_settings_saved", false, getMessage('MEMBER_REFBACK_ERROR_EMPTY_MESSAGE'));

                        }
                } else {
                        // Percents out-of-bounds ;-)
                        }
                } else {
                        // Percents out-of-bounds ;-)

-                       LOAD_TEMPLATE("admin_settings_saved", false, sprintf(MEMBER_REFBACK_ERROR_OUT_OF_BOUNDS, getConfig('refback_min_perc'), getConfig('refback_max_perc')));
+                       LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('MEMBER_REFBACK_ERROR_OUT_OF_BOUNDS'), getConfig('refback_min_perc'), getConfig('refback_max_perc')));

                }
 
                // Insert line
                }
 
                // Insert line

-               OUTPUT_HTML("<br />");

        } else {
                // Read data from refback table
                $content = GET_USER_REF_ENTRY($_POST['id']);
        } else {
                // Read data from refback table
                $content = GET_USER_REF_ENTRY($_POST['id']);


@@ -100,7 +99,7 @@ if ((isset($_POST['edit'])) && (isset($_POST['id']))) {
 
 // Load all referal levels
 $result = SQL_QUERY_ESC("SELECT r.level, r.percents
 
 // Load all referal levels
 $result = SQL_QUERY_ESC("SELECT r.level, r.percents

-FROM "._MYSQL_PREFIX."_refdepths AS r
+FROM `{!_MYSQL_PREFIX!}_refdepths` AS r

 WHERE r.level > 0
 ORDER BY r.level ASC",
        array($GLOBALS['userid']), __FILE__, __LINE__);
 WHERE r.level > 0
 ORDER BY r.level ASC",
        array($GLOBALS['userid']), __FILE__, __LINE__);


@@ -153,7 +152,7 @@ if (SQL_NUMROWS($result) > 0) {
        LOAD_TEMPLATE("member_refback_list", false, $OUT);
 } else {
        // No entries
        LOAD_TEMPLATE("member_refback_list", false, $OUT);
 } else {
        // No entries

-       LOAD_TEMPLATE("admin_settings_saved", false, MEMBER_REFBACK_NO_ENTRIES);
+       LOAD_TEMPLATE("admin_settings_saved", false, getMessage('MEMBER_REFBACK_NO_ENTRIES'));

 }
 
 // Free result
 }
 
 // Free result