Fixed a lot typos, thanks to profi-concept

[mailer.git] / inc / modules / admin / what-list_refs.php

diff --git a/inc/modules/admin/what-list_refs.php b/inc/modules/admin/what-list_refs.php
index 3ba95d8168b72487d30f3ac25700c6435d14fe75..6803a04aecbc5cd3f4a4eabb21d763b55e44b593 100644 (file)
--- a/inc/modules/admin/what-list_refs.php
+++ b/inc/modules/admin/what-list_refs.php
@@ -51,7 +51,7 @@ if (!empty($_GET['u_id'])) {
        $uid = bigintval($_GET['u_id']);
 
        // Check if the user already exists
-       $result_user = SQL_QUERY_ESC("SELECT userid FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s LIMIT 1",
+       $result_user = SQL_QUERY_ESC("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
                array($uid), __FILE__, __LINE__);
 
        // User found?
@@ -60,14 +60,14 @@ if (!empty($_GET['u_id'])) {
                if (EXT_IS_ACTIVE("refback")) {
                        // Load all referal levels
                        $result_levels = SQL_QUERY("SELECT level, percents
-FROM "._MYSQL_PREFIX."_refdepths
+FROM `{!_MYSQL_PREFIX!}_refdepths`
 WHERE level > 0
 ORDER BY level ASC", __FILE__, __LINE__);
                } else {
                        // Loads surname, family's name and the email address
-                       $result     = SQL_QUERY_ESC("SELECT COUNT(*) FROM `"._MYSQL_PREFIX."_user_data` WHERE refid=%s",
+                       $result     = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s",
                                array($uid), __FILE__, __LINE__);
-                       $result_lck = SQL_QUERY_ESC("SELECT COUNT(*) FROM `"._MYSQL_PREFIX."_user_data` WHERE refid=%s AND status != 'CONFIRMED' ORDER BY userid",
+                       $result_lck = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s AND status != 'CONFIRMED' ORDER BY userid",
                                array($uid), __FILE__, __LINE__);
                        $menge      = SQL_RESULT($result    , 0, 0);
                        $menge_lck  = SQL_RESULT($result_lck, 0, 0);
@@ -77,11 +77,11 @@ ORDER BY level ASC", __FILE__, __LINE__);
                        SQL_FREERESULT($result_lck);
 
                        // Query for refs
-                       $result_levels = SQL_QUERY_ESC("SELECT userid, gender, surname, family, email, status, joined FROM `"._MYSQL_PREFIX."_user_data` WHERE refid=%s ORDER BY userid ASC",
+                       $result_levels = SQL_QUERY_ESC("SELECT userid, gender, surname, family, email, status, joined FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s ORDER BY userid ASC",
                                array($uid), __FILE__, __LINE__);
 
                        // Output info message
-                       OUTPUT_HTML(ADMIN_TOTAL_REFS_1."".ADMIN_USER_PROFILE_LINK($_GET['u_id'])."".ADMIN_TOTAL_REFS_2.$menge.ADMIN_TOTAL_REFS_3.$menge_lck.ADMIN_TOTAL_REFS_4."<BR><BR>");
+                       LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), ADMIN_USER_PROFILE_LINK($_GET['u_id']), $menge, $menge_lck));
                }
 
                // Are there some levels (VERY BAD IF NONE!)
@@ -95,16 +95,16 @@ ORDER BY level ASC", __FILE__, __LINE__);
                                // Is the refback still active? ;-)
                                if (EXT_IS_ACTIVE("refback")) {
                                        // Load all refs of this user
-                                       $result_refs = SQL_QUERY_ESC("SELECT refid FROM "._MYSQL_PREFIX."_user_refs WHERE userid=%s AND level='%s' ORDER BY refid ASC",
+                                       $result_refs = SQL_QUERY_ESC("SELECT refid FROM `{!_MYSQL_PREFIX!}_user_refs` WHERE userid=%s AND level='%s' ORDER BY refid ASC",
                                                array($uid, $levels['level']), __FILE__, __LINE__);
                                        //* DEBUG: */ echo $uid."/".$levels['level']."/".SQL_NUMROWS($result_refs)."<br />\n";
 
                                        // Do we have levels?
                                        if (SQL_NUMROWS($result_refs) > 0) {
                                                // Loads surname, family's name and the email address
-                                               $result     = SQL_QUERY_ESC("SELECT COUNT(*) FROM `"._MYSQL_PREFIX."_user_data` WHERE refid=%s",
+                                               $result     = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s",
                                                        array($uid), __FILE__, __LINE__);
-                                               $result_lck = SQL_QUERY_ESC("SELECT COUNT(*) FROM `"._MYSQL_PREFIX."_user_data` WHERE refid=%s AND status != 'CONFIRMED' ORDER BY userid",
+                                               $result_lck = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s AND status != 'CONFIRMED' ORDER BY userid",
                                                        array($uid), __FILE__, __LINE__);
                                                $menge      = SQL_RESULT($result    , 0, 0);
                                                $menge_lck  = SQL_RESULT($result_lck, 0, 0);
@@ -114,13 +114,13 @@ ORDER BY level ASC", __FILE__, __LINE__);
                                                SQL_FREERESULT($result_lck);
 
                                                // Output info message
-                                               $levels['info'] = ADMIN_TOTAL_REFS_1."".ADMIN_USER_PROFILE_LINK($uid)."".ADMIN_TOTAL_REFS_2.$menge.ADMIN_TOTAL_REFS_3.$menge_lck.ADMIN_TOTAL_REFS_4;
+                                               $levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), ADMIN_USER_PROFILE_LINK($uid), $menge, $menge_lck);
 
                                                // Load all refs
                                                $OUT_REFS = ""; $SW = 2;
                                                while (list($refid) = SQL_FETCHROW($result_refs)) {
                                                        // Query for data
-                                                       $result_user = SQL_QUERY_ESC("SELECT userid, gender, surname, family, email, status, joined FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s LIMIT 1",
+                                                       $result_user = SQL_QUERY_ESC("SELECT userid, gender, surname, family, email, status, joined FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
                                                                array($refid), __FILE__, __LINE__);
 
                                                        // Is the data there?
@@ -129,7 +129,7 @@ ORDER BY level ASC", __FILE__, __LINE__);
                                                                $data = SQL_FETCHARRAY($result_user);
 
                                                                // Check for referals
-                                                               $result_cnt = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `"._MYSQL_PREFIX."_user_data` WHERE refid=%s",
+                                                               $result_cnt = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s",
                                                                        array($refid), __FILE__, __LINE__);
 
                                                                // Load refs
@@ -146,7 +146,7 @@ ORDER BY level ASC", __FILE__, __LINE__);
                                                                        'refs_link'  => "0",
                                                                        'surname'    => $data['surname'],
                                                                        'family'     => $data['family'],
-                                                                       'email'      => "[<A href=\"".CREATE_EMAIL_LINK($data['email'], "user_data")."\">".$data['email']."</A>]",
+                                                                       'email'      => "[<a href=\"".CREATE_EMAIL_LINK($data['email'], "user_data")."\">".$data['email']."</a>]",
                                                                        'status'     => TRANSLATE_STATUS($data['status']),
                                                                        'registered' => MAKE_DATETIME($data['joined'], "3"),
                                                                );
@@ -172,7 +172,7 @@ ORDER BY level ASC", __FILE__, __LINE__);
                                                } // END - while
                                        } else {
                                                // Output info message
-                                               $levels['info'] = ADMIN_TOTAL_REFS_1."".ADMIN_USER_PROFILE_LINK($uid)."".ADMIN_TOTAL_REFS_2."0".ADMIN_TOTAL_REFS_3."0".ADMIN_TOTAL_REFS_4;
+                                               $levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), ADMIN_USER_PROFILE_LINK($uid), "0", "0");
 
                                                // No refs found
                                                $levels['rows'] = LOAD_TEMPLATE("admin_list_refs_norefs", true, array('uid' => $uid));
@@ -185,7 +185,7 @@ ORDER BY level ASC", __FILE__, __LINE__);
                                        $OUT .= LOAD_TEMPLATE("admin_list_refs_level", true, $levels);
                                } else {
                                        // Check for referals
-                                       $result_refs = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `"._MYSQL_PREFIX."_user_data` WHERE refid=%s",
+                                       $result_refs = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s",
                                         array(bigintval($levels['userid'])), __FILE__, __LINE__);
                                        $refs_cnt = SQL_RESULT($result_refs, 0, 0);
                                        SQL_FREERESULT($result_refs);
@@ -198,7 +198,7 @@ ORDER BY level ASC", __FILE__, __LINE__);
                                                'refs_link'  => "0",
                                                'surname'    => $levels['surname'],
                                                'family'     => $levels['family'],
-                                               'email'      => "[<A href=\"".CREATE_EMAIL_LINK($levels['email'], "user_data")."\">".$levels['email']."</A>]",
+                                               'email'      => "[<a href=\"".CREATE_EMAIL_LINK($levels['email'], "user_data")."\">".$levels['email']."</a>]",
                                                'status'     => TRANSLATE_STATUS($levels['status']),
                                                'registered' => MAKE_DATETIME($levels['joined'], "3"),
                                        );
@@ -228,17 +228,17 @@ ORDER BY level ASC", __FILE__, __LINE__);
                        }
                } elseif (EXT_IS_ACTIVE("refback")) {
                        // No levels found, very bad!
-                       LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_NO_REF_LEVELS);
+                       LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_NO_REF_LEVELS'));
                } else {
                        // No refs made so far
-                       LOAD_TEMPLATE("admin_settings_saved", false, USER_REF_404);
+                       LOAD_TEMPLATE("admin_settings_saved", false, getMessage('USER_REF_404'));
                }
 
                // Free result
                SQL_FREERESULT($result_levels);
        } else {
                // User not found
-               LOAD_TEMPLATE("admin_settings_saved", false, sprintf(ADMIN_MEMBER_404, $_GET['u_id']));
+               LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('ADMIN_MEMBER_404'), $_GET['u_id']));
        }
 
        // Free memory