Refback extension in alpha phase finished, users can give refback to all refs in...

[mailer.git] / inc / functions.php

diff --git a/inc/functions.php b/inc/functions.php
index 3dcee7a5cce4ea43680c3ae67ac6ee7f27ff18a3..1c22981c1c5c3fc3b1ce41c0b1e57ba86ea88597 100644 (file)
--- a/inc/functions.php
+++ b/inc/functions.php
@@ -236,7 +236,7 @@ function LOAD_TEMPLATE($template, $return=false, $content=array()) {
 
                // Free result
                SQL_FREERESULT($result);
-       }
+       } // END - if
 
        // Generate date/time string
        $date_time = MAKE_DATETIME(time(), "1");
@@ -351,7 +351,7 @@ function LOAD_TEMPLATE($template, $return=false, $content=array()) {
 
 // Send mail out to an email address
 function SEND_EMAIL($TO, $SUBJECT, $MSG, $HTML = "N", $FROM = "") {
-       //* DEBUG: */ echo __FUNCTION__.":TO={$TO},SUBJECT={$SUBJECT}<br />\n";
+       //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):TO={$TO},SUBJECT={$SUBJECT}<br />\n";
 
        // Compile subject line (for POINTS constant etc.)
        $eval = "\$SUBJECT = html_entity_decode(\"".COMPILE_CODE(addslashes($SUBJECT))."\");";
@@ -366,7 +366,7 @@ function SEND_EMAIL($TO, $SUBJECT, $MSG, $HTML = "N", $FROM = "") {
                } else {
                        // Load email address
                        $result_email = SQL_QUERY_ESC("SELECT email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1", array(bigintval($TO)), __FILE__, __LINE__);
-                       //* DEBUG: */ echo __FUNCTION__.":numRows=".SQL_NUMROWS($result_email)."<br />\n";
+                       //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):numRows=".SQL_NUMROWS($result_email)."<br />\n";
 
                        // Does the user exist?
                        if (SQL_NUMROWS($result_email)) {
@@ -384,7 +384,7 @@ function SEND_EMAIL($TO, $SUBJECT, $MSG, $HTML = "N", $FROM = "") {
                // Is the webmaster!
                $TO = WEBMASTER;
        }
-       //* DEBUG: */ echo __FUNCTION__.":TO={$TO}<br />\n";
+       //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):TO={$TO}<br />\n";
 
        // Check for PHPMailer or debug-mode
        if (!CHECK_PHPMAILER_USAGE()) {
@@ -562,8 +562,8 @@ function TRANSLATE_COMMA ($dotted, $cut=true) {
                if (count($com) > 1) {
                        // Commata found, so only zeros?
                        if ($com[1] == str_repeat("0", strlen($com[1]))) {
-                               // Only zeros, so don't display them
-                               $maxComma = 0;
+                               // Only zeros, so display only one
+                               $maxComma = 1;
                        } // END - if
                } else {
                        // Don't display commatas even if there are none... ;-)
@@ -645,6 +645,11 @@ function TRANSLATE_STATUS($status) {
                $ret = ACCOUNT_LOCKED;
                break;
 
+       case "":
+       case null:
+               $ret = ACCOUNT_DELETED;
+               break;
+
        default:
                $ret = UNKNOWN_STATUS_1.$status.UNKNOWN_STATUS_2;
                break;
@@ -738,27 +743,27 @@ function LOAD_EMAIL_TEMPLATE($template, $content=array(), $UID="0") {
        } // END - if
 
        // Load user's data
-       //* DEBUG: */ echo __FUNCTION__.":UID={$UID},template={$template}<br />\n";
+       //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):UID={$UID},template={$template}<br />\n";
        if ($UID > 0) {
                if (EXT_IS_ACTIVE("nickname")) {
-                       //* DEBUG: */ echo __FUNCTION__.":NICKNAME!<br />\n";
+                       //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):NICKNAME!<br />\n";
                        // Load nickname
                        $result = SQL_QUERY_ESC("SELECT surname, family, gender, email, nickname FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1",
                                array(bigintval($UID)), __FILE__, __LINE__);
                } else {
-                       //* DEBUG: */ echo __FUNCTION__.":NO-NICK!<br />\n";
+                       //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):NO-NICK!<br />\n";
                        /// Load normal data
                        $result = SQL_QUERY_ESC("SELECT surname, family, gender, email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1",
                                array(bigintval($UID)), __FILE__, __LINE__);
                }
 
                // Is content an array?
-               //* DEBUG: */ echo __FUNCTION__.":content[]=".gettype($content)."<br />\n";
+               //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):content[]=".gettype($content)."<br />\n";
                if (is_array($content)) {
                        // Fetch and migrate data
-                       //* DEBUG: */ echo __FUNCTION__.":content()=".count($content)." - PRE<br />\n";
+                       //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):content()=".count($content)." - PRE<br />\n";
                        $content = array_merge($content, SQL_FETCHARRAY($result));
-                       //* DEBUG: */ echo __FUNCTION__.":content()=".count($content)." - AFTER<br />\n";
+                       //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):content()=".count($content)." - AFTER<br />\n";
                } // END - if
 
                // Free result
@@ -952,10 +957,10 @@ function COMPILE_CODE($code, $simple = false, $constants = true, $full = true) {
                                $test = substr($found, 0, strlen($match));
 
                                // Does this entry exist?
-                               //* DEBUG: */ echo __FUNCTION__.":found={$found},match={$match},set={$set}<br />\n";
+                               //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):found={$found},match={$match},set={$set}<br />\n";
                                if ($test == $match) {
                                        // Match found!
-                                       //* DEBUG: */ echo __FUNCTION__.":fuzzyFound!<br />\n";
+                                       //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):fuzzyFound!<br />\n";
                                        $fuzzyFound = true;
                                        break;
                                } // END - if
@@ -967,14 +972,14 @@ function COMPILE_CODE($code, $simple = false, $constants = true, $full = true) {
                        // Take all string elements
                        if ((is_string($matches[4][$key])) && (!isset($matchesFound[$match])) && (!isset($matchesFound[$key."_".$matches[4][$key]]))) {
                                // Replace it in the code
-                               //* DEBUG: */ echo __FUNCTION__.":key={$key},match={$match}<br />\n";
+                               //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):key={$key},match={$match}<br />\n";
                                $newMatch = str_replace("[".$matches[4][$key]."]", "['".$matches[4][$key]."']", $match);
                                $code = str_replace($match, "\".".$newMatch.".\"", $code);
                                $matchesFound[$key."_".$matches[4][$key]] = 1;
                                $matchesFound[$match] = 1;
                        } elseif (!isset($matchesFound[$match])) {
                                // Not yet replaced!
-                               //* DEBUG: */ echo __FUNCTION__.":match={$match}<br />\n";
+                               //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):match={$match}<br />\n";
                                $code = str_replace($match, "\".".$match.".\"", $code);
                                $matchesFound[$match] = 1;
                        }
@@ -1648,7 +1653,7 @@ function EXTRACT_HOST (&$script) {
        if (ereg("/", $host)) $host = substr($host, 0, strpos($host, "/"));
 
        // Generate relative URL
-       //* DEBUG */ print("SCRIPT=".$script."<br />\n");
+       //* DEBUG: */ print("SCRIPT=".$script."<br />\n");
        if (substr(strtolower($script), 0, 7) == "http://") {
                // But only if http:// is in front!
                $script = substr($script, (strlen($url) + 7));
@@ -1657,7 +1662,7 @@ function EXTRACT_HOST (&$script) {
                $script = substr($script, (strlen($url) + 8));
        }
 
-       //* DEBUG */ print("SCRIPT=".$script."<br />\n");
+       //* DEBUG: */ print("SCRIPT=".$script."<br />\n");
        if (substr($script, 0, 1) == "/") $script = substr($script, 1);
 
        // Return host name
@@ -1740,7 +1745,7 @@ function SEND_RAW_REQUEST ($host, $request) {
        } // END - if
 
        // Open connection
-       //* DEBUG */ die("SCRIPT=".$script."<br />\n");
+       //* DEBUG: */ die("SCRIPT=".$script."<br />\n");
        if ($useProxy) {
                $fp = @fsockopen(COMPILE_CODE($_CONFIG['proxy_host']), $_CONFIG['proxy_port'], $errno, $errdesc, 30);
        } else {
@@ -2245,11 +2250,11 @@ function isBooleanConstantAndTrue($constName) { // : Boolean
        // In cache?
        if (isset($constCache[$constName])) {
                // Use cache
-               //* DEBUG: */ echo __FUNCTION__.": ".$constName."-CACHE!<br />\n";
+               //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>): ".$constName."-CACHE!<br />\n";
                $res = $constCache[$constName];
        } else {
                // Check constant
-               //* DEBUG: */ echo __FUNCTION__.": ".$constName."-RESOLVE!<br />\n";
+               //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>): ".$constName."-RESOLVE!<br />\n";
                if (defined($constName)) $res = (constant($constName) === true);
 
                // Set cache
@@ -2263,7 +2268,7 @@ function isBooleanConstantAndTrue($constName) { // : Boolean
 
 // Check wether a session variable is set
 function isSessionVariableSet($var) {
-       //* DEBUG: */ echo __FUNCTION__.":var={$var}<br />\n";
+       //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):var={$var}<br />\n";
        return (isset($_SESSION[$var]));
 }
 // Returns wether the value of the session variable or NULL if not set
@@ -2326,7 +2331,7 @@ function DEBUG_LOG ($message, $force=false) {
        if ((isBooleanConstantAndTrue('DEBUG_MODE')) || ($force)) {
                // Log this message away
                $fp = fopen(PATH."inc/cache/debug.log", 'a') or mxchange_die("Cannot write logfile debug.log!");
-               fwrite($fp, date("d.m.Y|H:i:s", time())."|{$message}\n");
+               fwrite($fp, date("d.m.Y|H:i:s", time())."|".strip_tags($message)."\n");
                fclose($fp);
        } // END - if
 }
@@ -2344,7 +2349,7 @@ function GET_DIR_AS_ARRAY ($baseDir, $prefix) {
                $file = $baseDir.$baseFile;
 
                // Is this a valid reset file?
-               //* DEBUG: */ echo __FUNCTION__.":baseDir={$baseDir},prefix={$prefix},baseFile={$baseFile}<br />\n";
+               //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):baseDir={$baseDir},prefix={$prefix},baseFile={$baseFile}<br />\n";
                if ((FILE_READABLE($file)) && (substr($baseFile, 0, strlen($prefix)) == $prefix) && (substr($baseFile, -4, 4) == ".php")) {
                        // Remove both for extension name
                        $extName = substr($baseFile, strlen($prefix), -4);
@@ -2510,7 +2515,7 @@ function HANDLE_LOGIN_FAILTURES ($accessLevel) {
                // Ignore zero values
                if (get_session('mxchange_'.$accessLevel.'_failtures') > 0) {
                        // Non-guest has login failtures found, get both data and prepare it for template
-                       //* DEBUG: */ echo __FUNCTION__.":accessLevel={$accessLevel}<br />\n";
+                       //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):accessLevel={$accessLevel}<br />\n";
                        $content = array(
                                'login_failtures' => get_session('mxchange_'.$accessLevel.'_failtures'),
                                'last_failture'   => MAKE_DATETIME(get_session('mxchange_'.$accessLevel.'_last_fail'), "2")