logical fix
[mailer.git] / 0.2.1 / inc / functions.php
index 6bc73d52d580545f67a7a42af3ae2634fdbff03a..0afc09f1c17dbbdd167cb74f596c884bd5558b86 100644 (file)
-<?php\r
-/************************************************************************\r
- * MXChange v0.2.1                                    Start: 08/25/2003 *\r
- * ===============                              Last change: 11/29/2005 *\r
- *                                                                      *\r
- * -------------------------------------------------------------------- *\r
- * File              : functions.php                                    *\r
- * -------------------------------------------------------------------- *\r
- * Short description : Many non-MySQL functions (also file access)      *\r
- * -------------------------------------------------------------------- *\r
- * Kurzbeschreibung  : Viele Nicht-MySQL-Funktionen (auch Dateizugriff) *\r
- * -------------------------------------------------------------------- *\r
- *                                                                      *\r
- * -------------------------------------------------------------------- *\r
- * Copyright (c) 2003 - 2008 by Roland Haeder                           *\r
- * For more information visit: http://www.mxchange.org                  *\r
- *                                                                      *\r
- * This program is free software; you can redistribute it and/or modify *\r
- * it under the terms of the GNU General Public License as published by *\r
- * the Free Software Foundation; either version 2 of the License, or    *\r
- * (at your option) any later version.                                  *\r
- *                                                                      *\r
- * This program is distributed in the hope that it will be useful,      *\r
- * but WITHOUT ANY WARRANTY; without even the implied warranty of       *\r
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *\r
- * GNU General Public License for more details.                         *\r
- *                                                                      *\r
- * You should have received a copy of the GNU General Public License    *\r
- * along with this program; if not, write to the Free Software          *\r
- * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *\r
- * MA  02110-1301  USA                                                  *\r
- ************************************************************************/\r
-\r
-// Some security stuff...\r
-if (ereg(basename(__FILE__), $_SERVER['PHP_SELF']))\r
-{\r
-       $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";\r
-       require($INC);\r
-}\r
-\r
-// Check if our config file is writeable or not\r
-function is_INCWritable($inc)\r
-{\r
-       $fp = @fopen(PATH."inc/".$inc.".php", 'a');\r
-       if ($inc == "dummy")\r
-       {\r
-               // Remove dummy file\r
-               @fclose($fp);\r
-               return @unlink(PATH."inc/dummy.php");\r
-       }\r
-        else\r
-       {\r
-               // Close all other files\r
-               return @fclose($fp);\r
-       }\r
-}\r
-\r
-// Check if we can write to an sql file\r
-function is_SQLWriteable($sql)\r
-{\r
-       $fp = @fopen(PATH.$sql.".sql", 'a');\r
-       return @fclose($fp);\r
-}\r
-
-// Open a table (you may want to add some header stuff here)\r
-function OPEN_TABLE($PERCENT = "", $CLASS = "", $ALIGN="left", $VALIGN="", $td_only=false)\r
-{\r
-       global $table_cnt;\r
-       // Count tables so we can generate CSS classes for every table... :-)\r
-       if (empty($CLASS))\r
-       {\r
-               // Class is empty so count one up and create a class\r
-               $table_cnt++; $CLASS = "class".$table_cnt;\r
-       }\r
-       $OUT = "<TABLE border=\"0\" cellspacing=\"0\" cellpadding=\"0\"";\r
-       // Shall I add the classes to TABLE and TD or only to TD?\r
-       if (!$td_only) $OUT .= " class=\"".$CLASS."\"";\r
-\r
-       // Width is given\r
-       if (!empty($PERCENT)) $OUT .= " width=\"".$PERCENT."\"";\r
-\r
-       // Horizonal align\r
-       if (!empty($ALIGN)) $OUT .=" align=\"".$ALIGN."\"";\r
-\r
-       // Vertical align is given\r
-       if (!empty($VALIGN))  $OUT .= " valign=\"".$VALIGN."\"";\r
-       $OUT .= ">\r
-<TR>\r
-  <TD";\r
-       if (!empty($ALIGN)) $OUT .=" align=\"".$ALIGN."\"";\r
-       $OUT .= " class=\"".$CLASS."\">";\r
-       OUTPUT_HTML ($OUT);\r
-}\r
-// Close a table (you may want to add some footer stuff here)\r
-function CLOSE_TABLE($ADD="")\r
-{\r
-       OUTPUT_HTML ("  </TD>\r
-</TR>");\r
-       if (!empty($ADD)) OUTPUT_HTML ($ADD);\r
-       OUTPUT_HTML ("</TABLE>");\r
-}\r
-
-// Output HTML code directly or "render" it. You addionally switch the new-line character off\r
-function OUTPUT_HTML ($HTML, $NEW_LINE = true) {\r
-       // Some global variables\r
-       global $OUTPUT, $FOOTER, $CSS;\r
-\r
-       // Do we have HTML-Code here?\r
-       if (!empty($HTML)) {\r
-               // Yes, so we handle it as you have configured\r
-               switch (OUTPUT_MODE)\r
-               {\r
-               case "render":\r
-                       // That's why you don't need any \n at the end of your HTML code... :-)\r
-                       if (_OB_CACHING == "on")\r
-                       {\r
-                               // Output into PHP's internal buffer\r
-                               echo stripslashes($HTML);\r
-\r
-                               // That's why you don't need any \n at the end of your HTML code... :-)\r
-                               if ($NEW_LINE) echo "\n";\r
-                       }\r
-                        else\r
-                       {\r
-                               // Render mode for old or lame servers...\r
-                               $OUTPUT .= $HTML;\r
-\r
-                               // That's why you don't need any \n at the end of your HTML code... :-)\r
-                               if ($NEW_LINE) $OUTPUT .= "\n";\r
-                       }\r
-                       break;\r
-\r
-               case "direct":\r
-                       // If we are switching from render to direct output rendered code\r
-                       if ((!empty($OUTPUT)) && (_OB_CACHING != "on")) { echo $OUTPUT; $OUTPUT = ""; }\r
-\r
-                       // The same as above... ^\r
-                       echo stripslashes($HTML);\r
-                       if ($NEW_LINE) echo "\n";\r
-                       break;\r
-\r
-               default:\r
-                       // Huh, something goes wrong or maybe you have edited config.php ???\r
-                       die ("<STRONG>".FATAL_ERROR.":</STRONG> ".LANG_NO_RENDER_DIRECT);\r
-                       break;\r
-               }\r
-       } elseif ((_OB_CACHING == "on") && ($FOOTER == 1)) {\r
-               // Output cached HTML code\r
-               $OUTPUT = ob_get_contents();\r
-\r
-               // Clear output buffer for later output\r
-               ob_end_clean();\r
-\r
-               if ((EXT_IS_ACTIVE("rewrite", true)) && (function_exists('REWRITE_LINKS')) && ($CSS != "1") && ($CSS != "-1")) {\r
-                       $OUTPUT = REWRITE_LINKS($OUTPUT);\r
-               }\r
-\r
-               // Compile and run finished rendered HTML code\r
-               while (strpos($OUTPUT, "{!") > 0) {\r
-                       $eval = "\$OUTPUT = \"" . COMPILE_CODE(addslashes($OUTPUT)) . "\";";\r
-                       @eval($eval);\r
-               }\r
-\r
-               // Output code here, DO NOT REMOVE! ;-)\r
-               echo stripslashes($OUTPUT);\r
-               flush();\r
-       } elseif ((OUTPUT_MODE == "render") && (!empty($OUTPUT))) {\r
-               // Rewrite links when rewrite extension is active\r
-               if ((EXT_IS_ACTIVE("rewrite", true)) && (function_exists('REWRITE_LINKS')) && ($CSS != "1") && ($CSS != "-1")) {\r
-                       $OUTPUT = REWRITE_LINKS($OUTPUT);\r
-               }\r
-\r
-               // Compile and run finished rendered HTML code\r
-               while (strpos($OUTPUT, "{!") > 0) {\r
-                       $eval = "\$OUTPUT = \"" . COMPILE_CODE(addslashes($OUTPUT)) . "\";";\r
-                       @eval($eval);\r
-               }\r
-\r
-               // Output code here, DO NOT REMOVE! ;-)\r
-               echo stripslashes($OUTPUT);\r
-               flush();\r
-       }\r
-}\r
-
-// Add a fatal error message to the queue array\r
-function ADD_FATAL ($message, $extra="")\r
-{\r
-       global $FATAL;\r
-       if (empty($extra)) {\r
-               // Regular text message to add to $FATAL\r
-               $FATAL[] = $message;\r
-       } else {\r
-               // $message is text with a mask plus extras to insert into the text\r
-               $FATAL[] = sprintf($message, $extra);\r
-       }\r
-}\r
-
-// Load a template file and return it's content (only it's name; do not use ' or ")\r
-function LOAD_TEMPLATE($template, $return=false, $content="")\r
-{\r
-       // Add more variables which you want to use in your template files\r
-       global $DATA, $username;\r
-       $ACTION = SQL_ESCAPE($GLOBALS['action']);\r
-       $WHAT = SQL_ESCAPE($GLOBALS['what']);\r
-       $ret = "";\r
-       if (empty($GLOBALS['refid'])) $GLOBALS['refid'] = 0;\r
-       $REFID = $GLOBALS['refid'];\r
-\r
-       if ($template == "member_support_form")\r
-       {\r
-               // Support request of a member\r
-               $result = SQL_QUERY_ESC("SELECT sex, surname, family FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1",\r
-                array($GLOBALS['userid']), __FILE__, __LINE__);\r
-               list($sex, $surname, $family) = SQL_FETCHROW($result);\r
-               SQL_FREERESULT($result);\r
-               $salut = TRANSLATE_SEX($sex);\r
-       }\r
-\r
-       // Generate date/time string\r
-       $date_time = MAKE_DATETIME(time(), "1");\r
-\r
-       // Base directory\r
-       $BASE = PATH."templates/".GET_LANGUAGE()."/html/";\r
-       $MODE = "";\r
-\r
-       // Check for admin/guest/member templates\r
-       if (strpos($template, "admin_") > -1)\r
-       {\r
-               // Admin template found\r
-               $MODE = "admin/";\r
-       }\r
-        elseif (strpos($template, "guest_") > -1)\r
-       {\r
-               // Guest template found\r
-               $MODE = "guest/";\r
-       }\r
-        elseif (strpos($template, "member_") > -1)\r
-       {\r
-               // Member template found\r
-               $MODE = "member/";\r
-       }\r
-        elseif (strpos($template, "install_") > -1)\r
-       {\r
-               // Installation template found\r
-               $MODE = "install/";\r
-       }\r
-        elseif (strpos($template, "ext_") > -1)\r
-       {\r
-               // Extension template found\r
-               $MODE = "ext/";\r
-       }\r
-        elseif (strpos($template, "la_") > -1)\r
-       {\r
-               // "Logical-area" template found\r
-               $MODE = "la/";\r
-       }\r
-        else\r
-       {\r
-               // Test for extension\r
-               $test = substr($template, 0, strpos($template, "_"));\r
-               if (EXT_IS_ACTIVE($test))\r
-               {\r
-                       // Set extra path to extension's name\r
-                       $MODE = $test."/";\r
-               }\r
-       }\r
-\r
-       ////////////////////////\r
-       // Generate file name //\r
-       ////////////////////////\r
-       $file = $BASE.$MODE.$template.".tpl";\r
-\r
-       if ((!empty($GLOBALS['what'])) && ((strpos($template, "_header") > 0) || (strpos($template, "_footer") > 0)) && (($MODE == "guest/") || ($MODE == "member/") || ($MODE == "admin/")))\r
-       {\r
-               // Select what depended header/footer template file for admin/guest/member area\r
-               $file2 = sprintf("%s%s%s_%s.tpl",\r
-                       $BASE,\r
-                       $MODE,\r
-                       $template,\r
-                       SQL_ESCAPE($GLOBALS['what'])\r
-               );\r
-\r
-               // Probe for it...\r
-               if (file_exists($file2)) $file = $file2;\r
-\r
-               // Remove variable from memory\r
-               unset($file2);\r
-       }\r
-\r
-       // Does the special template exists?\r
-       if (!file_exists($file))\r
-       {\r
-               // Reset to default template\r
-               $file = $BASE.$template.".tpl";\r
-       }\r
-\r
-       // Now does the final template exists?\r
-       if (file_exists($file))\r
-       {\r
-               // The local file does exists so we load it. :)\r
-               $tmpl_file = implode("", file($file));\r
-\r
-               // Replace ' to our own chars to preventing them being quoted\r
-               while (strpos($tmpl_file, "\'") !== false) { $tmpl_file = str_replace("\'", "{QUOT}", $tmpl_file); }\r
-\r
-               // Do we have to compile the code?\r
-               if ((strpos($tmpl_file, "\$") !== false) || (strpos($tmpl_file, '{--') !== false) || (strpos($tmpl_file, '--}') > 0))\r
-               {\r
-                       // Okay, compile it!\r
-                       $tmpl_file = "\$ret=\"".COMPILE_CODE(addslashes($tmpl_file))."\";";\r
-                       eval($tmpl_file);\r
-               }\r
-                else\r
-               {\r
-                       // Simply return loaded code\r
-                       $ret = $tmpl_file;\r
-               }\r
-\r
-               // Add surrounding HTML comments to help finding bugs faster\r
-               $ret = "<!-- Template ".$template." - Start -->\n".$ret."<!-- Template ".$template." - End -->\n";\r
-       }\r
-        elseif ((IS_ADMIN()) || ((mxchange_installing) && (!mxchange_installed)))\r
-       {\r
-               // Only admins shall see this warning or when installation mode is active\r
-               $ret = "<BR><SPAN class=\"guest_failed\">".TEMPLATE_404."</SPAN><BR>\r
-(".basename($file).")<BR>\r
-<BR>\r
-".TEMPLATE_CONTENT."\r
-<PRE>".print_r($content, true)."</PRE>\r
-".TEMPLATE_DATA."\r
-<PRE>".print_r($DATA, true)."</PRE>\r
-<BR><BR>";\r
-       }\r
-       if (!empty($ret))\r
-       {\r
-               // Not empty so let's put it out! ;)\r
-               if ($return)\r
-               {\r
-                       // Return the HTML code\r
-                       return $ret;\r
-               }\r
-                else\r
-               {\r
-                       // Output direct\r
-                       OUTPUT_HTML ($ret);\r
-               }\r
-       }\r
-        elseif (DEBUG_MODE)\r
-       {\r
-               // Warning, empty output!\r
-               return "E:".$template."<BR>\n";\r
-       }\r
-}\r
-
-// Send mail out to an email address\r
-function SEND_EMAIL($TO, $SUBJECT, $MSG, $HTML="N", $FROM="")\r
-{\r
-       // Compile subject line (for POINTS constant etc.)\r
-       $eval = "\$SUBJECT = \"".COMPILE_CODE(addslashes($SUBJECT))."\";";\r
-       eval($eval);\r
-       $SUBJECT = html_entity_decode($SUBJECT);\r
-\r
-       // Set from header\r
-       if (!eregi("@", $TO))\r
-       {\r
-               // Value detected, load email from database\r
-               if (EXT_IS_ACTIVE("msg"))\r
-               {\r
-                       ADD_MESSAGE_TO_BOX($TO, $SUBJECT, $MSG, $HTML);\r
-                       return;\r
-               }\r
-                else\r
-               {\r
-                       $result_email = SQL_QUERY_ESC("SELECT email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1", array(bigintval($TO)), __FILE__, __LINE__);\r
-                       list($TO) = SQL_FETCHROW($result_email);\r
-                       SQL_FREERESULT($result_email);\r
-               }\r
-       }\r
-\r
-       // Not in PHPMailer-Mode\r
-       if (!CHECK_PHPMAILER_USAGE()) {\r
-               if (empty($FROM)) {\r
-                       // Load email header template\r
-                       if (!DEBUG_MODE) $FROM = LOAD_EMAIL_TEMPLATE("header");\r
-               } else {\r
-                       if (!DEBUG_MODE) $FROM .= LOAD_EMAIL_TEMPLATE("header");\r
-               }\r
-       }\r
-\r
-       // Fix HTML parameter (default is no!)\r
-       if (empty($HTML)) $HTML = "N";\r
-       if (DEBUG_MODE)\r
-       {\r
-               // In debug mode we want to display the mail instead of sending it away so we can debug this part\r
-               echo "<PRE>\r
-  ".$TO."\r
-  ".$SUBJECT."\r
-  ".$MSG."\r
-</PRE>\n";\r
-       }\r
-        elseif (($HTML == "Y") && (EXT_IS_ACTIVE("html_mail", true)))\r
-       {\r
-               // Send mail as HTML away\r
-               SEND_HTML_EMAIL($TO, $SUBJECT, $MSG, $FROM);\r
-       }\r
-        elseif (!empty($TO))\r
-       {\r
-               // Compile email\r
-               $TO = COMPILE_CODE($TO);\r
-\r
-               // Send Mail away\r
-               SEND_RAW_EMAIL(stripslashes($TO), COMPILE_CODE($SUBJECT), stripslashes($MSG), $FROM);\r
-       }\r
-        elseif ($HTML == "N")\r
-       {\r
-               // Problem found!\r
-               SEND_RAW_EMAIL(WEBMASTER, COMPILE_CODE($SUBJECT), stripslashes($MSG), $FROM);\r
-       }\r
-}\r
-// Check if legacy or PHPMailer command\r
-// @private\r
-function CHECK_PHPMAILER_USAGE() {\r
-       return (((defined('SMTP_HOSTNAME')) && (defined('SMTP_USER')) && (defined('SMTP_PASSWORD'))) || ((SMTP_HOSTNAME != "") && (SMTP_USER != "")));\r
-}\r
+<?php
+/************************************************************************
+ * MXChange v0.2.1                                    Start: 08/25/2003 *
+ * ===============                              Last change: 11/29/2005 *
+ *                                                                      *
+ * -------------------------------------------------------------------- *
+ * File              : functions.php                                    *
+ * -------------------------------------------------------------------- *
+ * Short description : Many non-MySQL functions (also file access)      *
+ * -------------------------------------------------------------------- *
+ * Kurzbeschreibung  : Viele Nicht-MySQL-Funktionen (auch Dateizugriff) *
+ * -------------------------------------------------------------------- *
+ *                                                                      *
+ * -------------------------------------------------------------------- *
+ * Copyright (c) 2003 - 2008 by Roland Haeder                           *
+ * For more information visit: http://www.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 *
+ * the Free Software Foundation; either version 2 of the License, or    *
+ * (at your option) any later version.                                  *
+ *                                                                      *
+ * This program is distributed in the hope that it will be useful,      *
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
+ * GNU General Public License for more details.                         *
+ *                                                                      *
+ * You should have received a copy of the GNU General Public License    *
+ * along with this program; if not, write to the Free Software          *
+ * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
+ * MA  02110-1301  USA                                                  *
+ ************************************************************************/
+
+// Some security stuff...
+if (ereg(basename(__FILE__), $_SERVER['PHP_SELF']))
+{
+       $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+       require($INC);
+}
+
+// Check if our config file is writeable or not
+function is_INCWritable($inc)
+{
+       $fp = @fopen(PATH."inc/".$inc.".php", 'a');
+       if ($inc == "dummy")
+       {
+               // Remove dummy file
+               @fclose($fp);
+               return @unlink(PATH."inc/dummy.php");
+       }
+        else
+       {
+               // Close all other files
+               return @fclose($fp);
+       }
+}
+
+// Check if we can write to an sql file
+function is_SQLWriteable($sql)
+{
+       $fp = @fopen(PATH.$sql.".sql", 'a');
+       return @fclose($fp);
+}
+
+// Open a table (you may want to add some header stuff here)
+function OPEN_TABLE($PERCENT = "", $CLASS = "", $ALIGN="left", $VALIGN="", $td_only=false)
+{
+       global $table_cnt;
+       // Count tables so we can generate CSS classes for every table... :-)
+       if (empty($CLASS))
+       {
+               // Class is empty so count one up and create a class
+               $table_cnt++; $CLASS = "class".$table_cnt;
+       }
+       $OUT = "<TABLE border=\"0\" cellspacing=\"0\" cellpadding=\"0\"";
+       // Shall I add the classes to TABLE and TD or only to TD?
+       if (!$td_only) $OUT .= " class=\"".$CLASS."\"";
+
+       // Width is given
+       if (!empty($PERCENT)) $OUT .= " width=\"".$PERCENT."\"";
+
+       // Horizonal align
+       if (!empty($ALIGN)) $OUT .=" align=\"".$ALIGN."\"";
+
+       // Vertical align is given
+       if (!empty($VALIGN))  $OUT .= " valign=\"".$VALIGN."\"";
+       $OUT .= ">
+<TR>
+  <TD";
+       if (!empty($ALIGN)) $OUT .=" align=\"".$ALIGN."\"";
+       $OUT .= " class=\"".$CLASS."\">";
+       OUTPUT_HTML ($OUT);
+}
+// Close a table (you may want to add some footer stuff here)
+function CLOSE_TABLE($ADD="")
+{
+       OUTPUT_HTML ("  </TD>
+</TR>");
+       if (!empty($ADD)) OUTPUT_HTML ($ADD);
+       OUTPUT_HTML ("</TABLE>");
+}
+
+// Output HTML code directly or "render" it. You addionally switch the new-line character off
+function OUTPUT_HTML ($HTML, $NEW_LINE = true) {
+       // Some global variables
+       global $OUTPUT, $FOOTER, $CSS;
+
+       // Do we have HTML-Code here?
+       if (!empty($HTML)) {
+               // Yes, so we handle it as you have configured
+               switch (OUTPUT_MODE)
+               {
+               case "render":
+                       // That's why you don't need any \n at the end of your HTML code... :-)
+                       if (_OB_CACHING == "on")
+                       {
+                               // Output into PHP's internal buffer
+                               echo stripslashes($HTML);
+
+                               // That's why you don't need any \n at the end of your HTML code... :-)
+                               if ($NEW_LINE) echo "\n";
+                       }
+                        else
+                       {
+                               // Render mode for old or lame servers...
+                               $OUTPUT .= $HTML;
+
+                               // That's why you don't need any \n at the end of your HTML code... :-)
+                               if ($NEW_LINE) $OUTPUT .= "\n";
+                       }
+                       break;
+
+               case "direct":
+                       // If we are switching from render to direct output rendered code
+                       if ((!empty($OUTPUT)) && (_OB_CACHING != "on")) { echo $OUTPUT; $OUTPUT = ""; }
+
+                       // The same as above... ^
+                       echo stripslashes($HTML);
+                       if ($NEW_LINE) echo "\n";
+                       break;
+
+               default:
+                       // Huh, something goes wrong or maybe you have edited config.php ???
+                       die ("<STRONG>".FATAL_ERROR.":</STRONG> ".LANG_NO_RENDER_DIRECT);
+                       break;
+               }
+       } elseif ((_OB_CACHING == "on") && ($FOOTER == 1)) {
+               // Output cached HTML code
+               $OUTPUT = ob_get_contents();
+
+               // Clear output buffer for later output
+               ob_end_clean();
+
+               if ((EXT_IS_ACTIVE("rewrite", true)) && (function_exists('REWRITE_LINKS')) && ($CSS != "1") && ($CSS != "-1")) {
+                       $OUTPUT = REWRITE_LINKS($OUTPUT);
+               }
+
+               // Compile and run finished rendered HTML code
+               while (strpos($OUTPUT, "{!") > 0) {
+                       $eval = "\$OUTPUT = \"" . COMPILE_CODE(addslashes($OUTPUT)) . "\";";
+                       @eval($eval);
+               }
+
+               // Output code here, DO NOT REMOVE! ;-)
+               echo stripslashes($OUTPUT);
+               flush();
+       } elseif ((OUTPUT_MODE == "render") && (!empty($OUTPUT))) {
+               // Rewrite links when rewrite extension is active
+               if ((EXT_IS_ACTIVE("rewrite", true)) && (function_exists('REWRITE_LINKS')) && ($CSS != "1") && ($CSS != "-1")) {
+                       $OUTPUT = REWRITE_LINKS($OUTPUT);
+               }
+
+               // Compile and run finished rendered HTML code
+               while (strpos($OUTPUT, "{!") > 0) {
+                       $eval = "\$OUTPUT = \"" . COMPILE_CODE(addslashes($OUTPUT)) . "\";";
+                       @eval($eval);
+               }
+
+               // Output code here, DO NOT REMOVE! ;-)
+               echo stripslashes($OUTPUT);
+               flush();
+       }
+}
+
+// Add a fatal error message to the queue array
+function ADD_FATAL ($message, $extra="")
+{
+       global $FATAL;
+       if (empty($extra)) {
+               // Regular text message to add to $FATAL
+               $FATAL[] = $message;
+       } else {
+               // $message is text with a mask plus extras to insert into the text
+               $FATAL[] = sprintf($message, $extra);
+       }
+}
+
+// Load a template file and return it's content (only it's name; do not use ' or ")
+function LOAD_TEMPLATE($template, $return=false, $content="")
+{
+       // Add more variables which you want to use in your template files
+       global $DATA, $username;
+       $ACTION = SQL_ESCAPE($GLOBALS['action']);
+       $WHAT = SQL_ESCAPE($GLOBALS['what']);
+       $ret = "";
+       if (empty($GLOBALS['refid'])) $GLOBALS['refid'] = 0;
+       $REFID = $GLOBALS['refid'];
+
+       if ($template == "member_support_form")
+       {
+               // Support request of a member
+               $result = SQL_QUERY_ESC("SELECT sex, surname, family FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1",
+                array($GLOBALS['userid']), __FILE__, __LINE__);
+               list($sex, $surname, $family) = SQL_FETCHROW($result);
+               SQL_FREERESULT($result);
+               $salut = TRANSLATE_SEX($sex);
+       }
+
+       // Generate date/time string
+       $date_time = MAKE_DATETIME(time(), "1");
+
+       // Base directory
+       $BASE = PATH."templates/".GET_LANGUAGE()."/html/";
+       $MODE = "";
+
+       // Check for admin/guest/member templates
+       if (strpos($template, "admin_") > -1)
+       {
+               // Admin template found
+               $MODE = "admin/";
+       }
+        elseif (strpos($template, "guest_") > -1)
+       {
+               // Guest template found
+               $MODE = "guest/";
+       }
+        elseif (strpos($template, "member_") > -1)
+       {
+               // Member template found
+               $MODE = "member/";
+       }
+        elseif (strpos($template, "install_") > -1)
+       {
+               // Installation template found
+               $MODE = "install/";
+       }
+        elseif (strpos($template, "ext_") > -1)
+       {
+               // Extension template found
+               $MODE = "ext/";
+       }
+        elseif (strpos($template, "la_") > -1)
+       {
+               // "Logical-area" template found
+               $MODE = "la/";
+       }
+        else
+       {
+               // Test for extension
+               $test = substr($template, 0, strpos($template, "_"));
+               if (EXT_IS_ACTIVE($test))
+               {
+                       // Set extra path to extension's name
+                       $MODE = $test."/";
+               }
+       }
+
+       ////////////////////////
+       // Generate file name //
+       ////////////////////////
+       $file = $BASE.$MODE.$template.".tpl";
+
+       if ((!empty($GLOBALS['what'])) && ((strpos($template, "_header") > 0) || (strpos($template, "_footer") > 0)) && (($MODE == "guest/") || ($MODE == "member/") || ($MODE == "admin/")))
+       {
+               // Select what depended header/footer template file for admin/guest/member area
+               $file2 = sprintf("%s%s%s_%s.tpl",
+                       $BASE,
+                       $MODE,
+                       $template,
+                       SQL_ESCAPE($GLOBALS['what'])
+               );
+
+               // Probe for it...
+               if (file_exists($file2)) $file = $file2;
+
+               // Remove variable from memory
+               unset($file2);
+       }
+
+       // Does the special template exists?
+       if (!file_exists($file))
+       {
+               // Reset to default template
+               $file = $BASE.$template.".tpl";
+       }
+
+       // Now does the final template exists?
+       if (file_exists($file))
+       {
+               // The local file does exists so we load it. :)
+               $tmpl_file = implode("", file($file));
+
+               // Replace ' to our own chars to preventing them being quoted
+               while (strpos($tmpl_file, "\'") !== false) { $tmpl_file = str_replace("\'", "{QUOT}", $tmpl_file); }
+
+               // Do we have to compile the code?
+               if ((strpos($tmpl_file, "\$") !== false) || (strpos($tmpl_file, '{--') !== false) || (strpos($tmpl_file, '--}') > 0))
+               {
+                       // Okay, compile it!
+                       $tmpl_file = "\$ret=\"".COMPILE_CODE(addslashes($tmpl_file))."\";";
+                       eval($tmpl_file);
+               }
+                else
+               {
+                       // Simply return loaded code
+                       $ret = $tmpl_file;
+               }
+
+               // Add surrounding HTML comments to help finding bugs faster
+               $ret = "<!-- Template ".$template." - Start -->\n".$ret."<!-- Template ".$template." - End -->\n";
+       }
+        elseif ((IS_ADMIN()) || ((mxchange_installing) && (!mxchange_installed)))
+       {
+               // Only admins shall see this warning or when installation mode is active
+               $ret = "<BR><SPAN class=\"guest_failed\">".TEMPLATE_404."</SPAN><BR>
+(".basename($file).")<BR>
+<BR>
+".TEMPLATE_CONTENT."
+<PRE>".print_r($content, true)."</PRE>
+".TEMPLATE_DATA."
+<PRE>".print_r($DATA, true)."</PRE>
+<BR><BR>";
+       }
+       if (!empty($ret))
+       {
+               // Not empty so let's put it out! ;)
+               if ($return)
+               {
+                       // Return the HTML code
+                       return $ret;
+               }
+                else
+               {
+                       // Output direct
+                       OUTPUT_HTML ($ret);
+               }
+       }
+        elseif (DEBUG_MODE)
+       {
+               // Warning, empty output!
+               return "E:".$template."<BR>\n";
+       }
+}
+
+// Send mail out to an email address
+function SEND_EMAIL($TO, $SUBJECT, $MSG, $HTML="N", $FROM="")
+{
+       // Compile subject line (for POINTS constant etc.)
+       $eval = "\$SUBJECT = \"".COMPILE_CODE(addslashes($SUBJECT))."\";";
+       eval($eval);
+       $SUBJECT = html_entity_decode($SUBJECT);
+
+       // Set from header
+       if (!eregi("@", $TO))
+       {
+               // Value detected, load email from database
+               if (EXT_IS_ACTIVE("msg"))
+               {
+                       ADD_MESSAGE_TO_BOX($TO, $SUBJECT, $MSG, $HTML);
+                       return;
+               }
+                else
+               {
+                       $result_email = SQL_QUERY_ESC("SELECT email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1", array(bigintval($TO)), __FILE__, __LINE__);
+                       list($TO) = SQL_FETCHROW($result_email);
+                       SQL_FREERESULT($result_email);
+               }
+       }
+
+       // Not in PHPMailer-Mode
+       if (!CHECK_PHPMAILER_USAGE()) {
+               if (empty($FROM)) {
+                       // Load email header template
+                       $FROM = LOAD_EMAIL_TEMPLATE("header");
+               } else {
+                       // Append header
+                       $FROM .= LOAD_EMAIL_TEMPLATE("header");
+               }
+       } elseif (DEBUG_MODE) {
+               if (empty($FROM)) {
+                       // Load email header template
+                       $FROM = LOAD_EMAIL_TEMPLATE("header");
+               } else {
+                       // Append header
+                       $FROM .= LOAD_EMAIL_TEMPLATE("header");
+               }
+       }
+
+       // Fix HTML parameter (default is no!)
+       if (empty($HTML)) $HTML = "N";
+       if (DEBUG_MODE)
+       {
+               // In debug mode we want to display the mail instead of sending it away so we can debug this part
+               echo "<PRE>
+".htmlentities(trim($FROM))."
+To      : ".$TO."
+Subject : ".$SUBJECT."
+Message : ".$MSG."
+</PRE>\n";
+       }
+        elseif (($HTML == "Y") && (EXT_IS_ACTIVE("html_mail", true)))
+       {
+               // Send mail as HTML away
+               SEND_HTML_EMAIL($TO, $SUBJECT, $MSG, $FROM);
+       }
+        elseif (!empty($TO))
+       {
+               // Compile email
+               $TO = COMPILE_CODE($TO);
+
+               // Send Mail away
+               SEND_RAW_EMAIL(stripslashes($TO), COMPILE_CODE($SUBJECT), stripslashes($MSG), $FROM);
+       }
+        elseif ($HTML == "N")
+       {
+               // Problem found!
+               SEND_RAW_EMAIL(WEBMASTER, COMPILE_CODE($SUBJECT), stripslashes($MSG), $FROM);
+       }
+}
+// Check if legacy or PHPMailer command
+// @private
+function CHECK_PHPMAILER_USAGE() {
+       return ((defined('SMTP_HOSTNAME')) && (defined('SMTP_USER')) && (defined('SMTP_PASSWORD')) && (SMTP_HOSTNAME != "") && (SMTP_USER != ""));
+}
 
 /*
  * Send out a raw email with PHPMailer class or legacy mail() command
- */\r
-function SEND_RAW_EMAIL ($to, $subject, $msg, $from) {\r
-       // Shall we use PHPMailer class or legacy mode?\r
-       if (CHECK_PHPMAILER_USAGE()) {\r
-               // Use PHPMailer class with SMTP enabled\r
-               require_once(PATH."inc/phpmailer/class.phpmailer.php");\r
-               require_once(PATH."inc/phpmailer/class.smtp.php");\r
-\r
-               // get new instance\r
-               $mail = new PHPMailer();\r
-\r
-               $mail->IsSMTP();\r
-               $mail->SMTPAuth   = true;\r
-               $mail->Host       = SMTP_HOSTNAME;\r
-               $mail->Port       = 25;\r
-               $mail->Username   = SMTP_USER;\r
-               $mail->Password   = SMTP_PASSWORD;\r
-               $mail->From       = $from;\r
-               $mail->FromName   = MAIN_TITLE;\r
-               $mail->Subject    = $subject;\r
-               if ((EXT_IS_ACTIVE("html_mail")) && (strip_tags($msg) != $msg)) {\r
-                       $mail->Body       = $msg;\r
-                       $mail->AltBody    = "Your mail program required HTML support to read this mail!";\r
-                       $mail->WordWrap   = 70;\r
-                       $mail->IsHTML(true);\r
-               } else {\r
-                       $mail->Body       = $msg;\r
-               }\r
-               $mail->AddAddress($to, "");\r
-               $mail->AddReplyTo(WEBMASTER,MAIN_TITLE);\r
-               $mail->AddCustomHeader("Errors-To:".WEBMASTER);\r
-               $mail->AddCustomHeader("X-Loop:".WEBMASTER);\r
-               $mail->Send();\r
-       } else {\r
-               // Use legacy mail() command\r
-               @mail($to, $subject, $msg, $from);\r
-       }\r
-}\r
-//\r
+ */
+function SEND_RAW_EMAIL ($to, $subject, $msg, $from) {
+       // Shall we use PHPMailer class or legacy mode?
+       if (CHECK_PHPMAILER_USAGE()) {
+               // Use PHPMailer class with SMTP enabled
+               require_once(PATH."inc/phpmailer/class.phpmailer.php");
+               require_once(PATH."inc/phpmailer/class.smtp.php");
+
+               // get new instance
+               $mail = new PHPMailer();
+               $mail->PluginDir  = PATH."inc/phpmailer/";
+
+               $mail->IsSMTP();
+               $mail->SMTPAuth   = true;
+               $mail->Host       = SMTP_HOSTNAME;
+               $mail->Port       = 25;
+               $mail->Username   = SMTP_USER;
+               $mail->Password   = SMTP_PASSWORD;
+               $mail->From       = $from;
+               $mail->FromName   = MAIN_TITLE;
+               $mail->Subject    = $subject;
+               if ((EXT_IS_ACTIVE("html_mail")) && (strip_tags($msg) != $msg)) {
+                       $mail->Body       = $msg;
+                       $mail->AltBody    = "Your mail program required HTML support to read this mail!";
+                       $mail->WordWrap   = 70;
+                       $mail->IsHTML(true);
+               } else {
+                       $mail->Body       = $msg;
+               }
+               $mail->AddAddress($to, "");
+               $mail->AddReplyTo(WEBMASTER,MAIN_TITLE);
+               $mail->AddCustomHeader("Errors-To:".WEBMASTER);
+               $mail->AddCustomHeader("X-Loop:".WEBMASTER);
+               $mail->Send();
+       } else {
+               // Use legacy mail() command
+               @mail($to, $subject, $msg, $from);
+       }
+}
+//
 
 // Generate a password in a specified length or use default password length
-function GEN_PASS($LEN = 0) {\r
-       global $CONFIG;\r
-       if ($LEN == 0) $LEN = $CONFIG['pass_len'];\r
-
-       // Initialize array with all allowed chars\r
-       $ABC = explode(",", "a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,0,1,2,3,4,5,6,7,8,9,-,+,_,/");\r
-
-       // Initialize randomizer\r
-       mt_srand((double) microtime() * 1000000);\r
-\r
-       // Start creating password\r
-       $PASS = "";\r
-       for ($i = 0; $i < $LEN; $i++) {\r
-               $PASS .= $ABC[mt_rand(0, sizeof($ABC) -1)];\r
-       }\r
-\r
-       // When the size is below 40 we can also add additional security by scrambling it\r
-       if (strlen($PASS) <= 40) {\r
-               // Also scramble the password\r
-               $PASS = scrambleString($PASS);\r
-       }
-
-       // Return the password\r
-       return $PASS;\r
-}\r
-//\r
-function MAKE_DATETIME($time, $mode="0")\r
-{\r
-       if ($time == 0) {\r
-               // Never happend\r
-               return NEVER_HAPPENED;\r
-       } else {\r
-               // Filter out numbers\r
-               $time = bigintval($time);\r
-       }\r
-\r
-       switch (GET_LANGUAGE())\r
-       {\r
-       case "de": // German date / time format\r
-               switch ($mode)\r
-               {\r
-                       case "0": $ret = date("d.m.Y \u\m H:i \U\h\\r", $time); break;\r
-                       case "1": $ret = strtolower(date("d.m.Y - H:i", $time)); break;\r
-                       case "2": $ret = date("d.m.Y|H:i", $time); break;\r
-                       case "3": $ret = date("d.m.Y", $time); break;\r
-               }\r
-               break;\r
-\r
-       default:        // Default is the US date / time format!\r
-               switch ($mode)\r
-               {\r
-                       case "0": $ret = date("r", $time); break;\r
-                       case "1": $ret = date("Y-m-d - g:i A", $time); break;\r
-                       case "2": $ret = date("y-m-d|H:i", $time); break;\r
-                       case "3": $ret = date("y-m-d", $time); break;\r
-               }\r
-       }\r
-       return $ret;\r
-}\r
-//\r
-function TRANSLATE_COMMA($dotted, $cut=true)\r
-{\r
-       global $CONFIG;\r
-       // Default is 3 you can change this in admin area "Misc -> Misc Options"\r
-       if (empty($CONFIG['max_comma'])) $CONFIG['max_comma'] = "3";\r
-       if (!ereg("\.", $dotted)) $dotted .= ".".str_repeat("0", $CONFIG['max_comma']);\r
-       if ($cut)\r
-       {\r
-               // Remove trailing zeros\r
-               $dot = str_replace(".", "x", $dotted);\r
-               while(substr($dot, -1, 1) == "0")\r
-               {\r
-                       $dot = substr($dot, 0, -1);\r
-               }\r
-               if (substr($dot, -1, 1) == "x")\r
-               {\r
-                       // Last char is the 'x'\r
-                       $dotted = substr($dot, 0, -1);\r
-               }\r
-                else\r
-               {\r
-                       // Last char is a number\r
-                       $dotted = str_replace("x", ".", $dot);\r
-               }\r
-       }\r
-       switch (GET_LANGUAGE())\r
-       {\r
-       case "de":\r
-               $pos = strpos($dotted, ".");\r
-               if ($pos > 0)\r
-               {\r
-                       if ($cut)\r
-                       {\r
-                               // Cut x numbers behind comma\r
-                               $dotted = str_replace(".", ",", substr($dotted, 0, ($pos + $CONFIG['max_comma'] + 1)));\r
-                       }\r
-                        else\r
-                       {\r
-                               // Replace comma with dot\r
-                               $dotted = str_replace(".", ",", $dotted);\r
-                       }\r
-               }\r
-                elseif (!$cut)\r
-               {\r
-                       if (empty($pos))\r
-                       {\r
-                               $dotted = "0,".str_repeat("0", $CONFIG['max_comma']);\r
-                       }\r
-                        else\r
-                       {\r
-                               $dotted .= ",".str_repeat("0", $CONFIG['max_comma']);\r
-                       }\r
-               }\r
-               break;\r
-\r
-       default:\r
-               if (!$cut)\r
-               {\r
-                       if ($pos > 0)\r
-                       {\r
-                               $dotted = substr($dotted, 0, ($pos + $CONFIG['max_comma'] + 1));\r
-                       }\r
-                        else\r
-                       {\r
-                               $dotted .= ".".str_repeat("0", $CONFIG['max_comma']);\r
-                       }\r
-               }\r
-               break;\r
-       }\r
-       return $dotted;\r
-}\r
-//\r
-function DEREFERER($URL)\r
-{\r
-       $URL = URL."/modules.php?module=loader&amp;url=".urlencode(base64_encode(COMPILE_CODE($URL)));\r
-       return $URL;\r
-}\r
-//\r
-function TRANSLATE_SEX($sex)\r
-{\r
-       switch ($sex)\r
-       {\r
-               case "M": $ret = SEX_M; break;\r
-               case "F": $ret = SEX_F; break;\r
-               case "C": $ret = SEX_C; break;\r
-               default : $ret = $sex; break;\r
-       }\r
-       return $ret;\r
-}\r
-//\r
-function GET_POOL_TYPE($PT)\r
-{\r
-       switch ($PT)\r
-       {\r
-               case "TEMP"   : $ret = POOL_TEMP;    break;\r
-               case "SEND"   : $ret = POOL_SEND;    break;\r
-               case "NEW"    : $ret = POOL_NEW;     break;\r
-               case "ADMIN"  : $ret = POOL_ADMIN;   break;\r
-               case "ACTIVE" : $ret = POOL_ACTIVE;  break;\r
-               case "DELETED": $ret = POOL_DELETED; break;\r
-               default       : $ret = POOL_UNKNOWN." (".$PT.")"; break;\r
-       }\r
-       return $ret;\r
-}\r
-//\r
-function FRAMETESTER($URL)\r
-{\r
-       global $_SERVER;\r
-       $URL = URL."/modules.php?module=frametester&amp;url=".urlencode(base64_encode(COMPILE_CODE($URL)));\r
-       return $URL;\r
-}\r
-//\r
-function SELECTION_COUNT($array)\r
-{\r
-       $ret = "0";\r
-       if (is_array($array))\r
-       {\r
-               foreach ($array as $key=>$sel)\r
-               {\r
-                       if (!empty($sel)) $ret++;\r
-               }\r
-       }\r
-       return $ret;\r
-}\r
-//\r
-function IMG_CODE ($code, $TYPE, $DATA, $uid)\r
-{\r
-       return "<IMG border=\"0\" alt=\"Code\" src=\"".URL."/mailid_top.php?uid=".$uid."&amp;".$TYPE."=".$DATA."&amp;mode=img&amp;code=".$code."\">";\r
-}\r
-//\r
-function TRANSLATE_STATUS($status)\r
-{\r
-       switch ($status)\r
-       {\r
-       case "UNCONFIRMED":\r
-               $ret = ACCOUNT_UNCONFIRMED;\r
-               break;\r
-\r
-       case "CONFIRMED":\r
-               $ret = ACCOUNT_CONFIRMED;\r
-               break;\r
-\r
-       case "LOCKED":\r
-               $ret = ACCOUNT_LOCKED;\r
-               break;\r
-\r
-       default:\r
-               $ret = UNKNOWN_STATUS_1.$status.UNKNOWN_STATUS_2;\r
-               break;\r
-       }\r
-       return $ret;\r
-}\r
-//\r
-function GET_LANGUAGE()\r
-{\r
-       global $_COOKIE, $_GET;\r
-\r
-       if (!empty($_GET['mx_lang']))\r
-       {\r
-               // Accept only first 2 chars\r
-               $lang = substr($_GET['mx_lang'], 0, 2);\r
-       }\r
-        else\r
-       {\r
-               // Do nothing\r
-               $lang = "";\r
-       }\r
-\r
-       // Set default return value to default language from config\r
-       $ret = DEFAULT_LANG;\r
-\r
-       // Check GET variable and cookie\r
-       if (!empty($lang))\r
-       {\r
-               // Check if main language file does exist\r
-               if (file_exists(PATH."inc/language/".$lang.".php"))\r
-               {\r
-                       // Okay found, so let's update cookies\r
-                       SET_LANGUAGE($lang);\r
-               }\r
-       }\r
-        elseif (!empty($_COOKIE['mx_lang']))\r
-       {\r
-               // Return stored value from cookie\r
-               $ret = $_COOKIE['mx_lang'];\r
-       }\r
-       return $ret;\r
-}\r
-//\r
-function SET_LANGUAGE($lang)\r
-{\r
-       global $CONFIG;\r
-\r
-       // Accept only first 2 chars!\r
-       $lang = substr(SQL_ESCAPE(strip_tags($lang)), 0, 2);\r
-\r
-       // Set cookie\r
-       @setcookie("mx_lang", $lang, (time() + $CONFIG['online_timeout']), COOKIE_PATH);\r
-\r
-       // Set array\r
-       $_COOKIE['mx_lang'] = $lang;\r
-}\r
-//\r
-function LOAD_EMAIL_TEMPLATE($template, $content="", $UID="0")\r
-{\r
-       global $DATA, $CONFIG, $REPLACER;\r
-\r
-       // Keept for backward-compatiblity (please replace these variables against our new {--CONST--} syntax!)\r
-       $MAIN_TITLE = MAIN_TITLE; $URL = URL; $WEBMASTER = WEBMASTER;\r
-       $surname = ""; $family = ""; $nick = ""; $sex = "N";\r
-\r
-       // Prepare IP number and User Agent\r
-       $REMOTE_ADDR = getenv('REMOTE_ADDR');\r
-       $HTTP_USER_AGENT  = getenv('HTTP_USER_AGENT');\r
-\r
-       $ADMIN = MAIN_TITLE;\r
-       if (!empty($_COOKIE['admin_login']))\r
-       {\r
-               // Load Admin data\r
-               $result = SQL_QUERY_ESC("SELECT email FROM "._MYSQL_PREFIX."_admins WHERE login='%s' LIMIT 1",\r
-                       array(SQL_ESCAPE($_COOKIE['admin_login'])), __FILE__, __LINE__);\r
-               list($ADMIN) = SQL_FETCHROW($result);\r
-               SQL_FREERESULT($result);\r
-       }\r
-\r
-       // Expiration in a nice output format\r
-       if ($CONFIG['auto_purge'] == 0)\r
-       {\r
-               // Will never expire!\r
-               $EXPIRATION = MAIL_WILL_NEVER_EXPIRE;\r
-       }\r
-        elseif (function_exists('CREATE_FANCY_TIME'))\r
-       {\r
-               // Create nice date string\r
-               $EXPIRATION = CREATE_FANCY_TIME($CONFIG['auto_purge']);\r
-       }\r
-        else\r
-       {\r
-               // Display days only\r
-               $EXPIRATION = round($CONFIG['auto_purge']/60/60/24)." "._DAYS;\r
-       }\r
-       switch ($template)\r
-       {\r
-       case "bonus-mail": // Load data for the bonus mail\r
-               $BONUSID    = $DATA[0];\r
-               $content    = $DATA[2];\r
-               $POINTS     = TRANSLATE_COMMA($DATA[4]);\r
-               $TIME       = $DATA[5];\r
-               $TARGET_URL = $DATA[8];\r
-               $CATEGORY   = GET_CATEGORY($DATA[9]);\r
-               $DATA[10]   = $UID;\r
-\r
-               // Replace variables\r
-               foreach ($REPLACER as $key=>$value)\r
-               {\r
-                       if (isset($DATA[$key])) $content = str_replace($value, $DATA[$key], $content);\r
-               }\r
-               break;\r
-\r
-       case "order-admin":\r
-       case "order-member":\r
-               $BLOCKS     = $CONFIG['max_send'];\r
-               $SUBJECT    = $DATA[0];\r
-               $content    = $DATA[1];\r
-               $PAYMENT    = GET_PAYMENT($DATA[3]);\r
-               $TARGET_URL = $DATA[5];\r
-               $CATEGORY   = GET_CATEGORY($DATA[6]);\r
-               break;\r
-\r
-       case "order-reject":\r
-       case "order-deleted":\r
-       case "order-accept":\r
-               $TARGET_URL = $DATA[0];\r
-               $URL        = $DATA[0];\r
-               $SUBJECT    = $DATA[1];\r
-               break;\r
-\r
-       case "new-pass":\r
-               $PASS       = $DATA[0];\r
-               $REMOTE     = $DATA[1];\r
-               break;\r
-\r
-       case "confirm-member":\r
-               $POINTS     = $CONFIG['points_register'];\r
-               break;\r
-\r
-       case "confirm-referral":\r
-               $PERCENT    = $DATA[0];\r
-               $LEVEL      = $DATA[1];\r
-               $POINTS     = $DATA[2];\r
-               $REFID      = $DATA[3];\r
-               break;\r
-\r
-       case "normal-mail":\r
-               $SEND_UID   = $DATA[1];\r
-               $CATEGORY   = GET_CATEGORY($DATA[9]);\r
-               $TIME       = GET_PAY_POINTS($DATA[5], "time");\r
-               $TARGET_URL = $DATA[7];\r
-               $POINTS     = TRANSLATE_COMMA(GET_PAY_POINTS($DATA[5], "payment"));\r
-               // Warning! This ID has changed from 10 to 11!\r
-               $MAILID     = $DATA[11];\r
-\r
-               // Replace variables\r
-               foreach ($REPLACER as $key=>$value)\r
-               {\r
-                       if (isset($DATA[$key])) $content = str_replace($value, $DATA[$key], $content);\r
-               }\r
-               break;\r
-\r
-       case "done-member":\r
-       case "done-admin":\r
-               $SEND_UID   = $DATA[1];\r
-               $CATEGORY   = GET_CATEGORY($DATA[9]);\r
-               $TARGET_URL = $DATA[7];\r
-               break;\r
-\r
-       case "back-admin":\r
-       case "back-member":\r
-               $POINTS     = TRANSLATE_COMMA($DATA[10]);\r
-               break;\r
-\r
-       case "add-points":\r
-               $POINTS = $_POST['points'];\r
-               break;\r
-\r
-       case "guest_request_confirm":\r
-               $HASH       = $DATA[2];\r
-               break;\r
-       }\r
-\r
-       // Load user's data\r
-       if ($UID > 0)\r
-       {\r
-               if (EXT_IS_ACTIVE("nickname"))\r
-               {\r
-                       // Load nickname\r
-                       $result = SQL_QUERY_ESC("SELECT surname, family, sex, email, nickname FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1",\r
-                        array(bigintval($UID)), __FILE__, __LINE__);\r
-                       list($surname, $family, $sex, $email, $nick) = SQL_FETCHROW($result);\r
-                       SQL_FREERESULT($result);\r
-               }\r
-                else\r
-               {\r
-                       // Load normal data\r
-                       $result = SQL_QUERY_ESC("SELECT surname, family, sex, email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1",\r
-                        array(bigintval($UID)), __FILE__, __LINE__);\r
-                       list($surname, $family, $sex, $email) = SQL_FETCHROW($result);\r
-                       SQL_FREERESULT($result);\r
-                       $nick = "---";\r
-               }\r
-       }\r
-        else\r
-       {\r
-               // Neutral sex and email address is default\r
-               $sex = "N";\r
-               $email = WEBMASTER;\r
-       }\r
-\r
-       // Translate M to male or F to female\r
-       $salut = TRANSLATE_SEX($sex);\r
-\r
-       // Store email for some functions in global data array\r
-       $DATA['email'] = $email;\r
-\r
-       // Base directory\r
-       $BASE = PATH."templates/".GET_LANGUAGE()."/emails/";\r
-\r
-       // Check for admin/guest/member templates\r
-       if (strpos($template, "admin_") > -1)\r
-       {\r
-               // Admin template found\r
-               $file = $BASE."admin/".$template.".tpl";\r
-       }\r
-        elseif (strpos($template, "guest_") > -1)\r
-       {\r
-               // Guest template found\r
-               $file = $BASE."guest/".$template.".tpl";\r
-       }\r
-        elseif (strpos($template, "member_") > -1)\r
-       {\r
-               // Member template found\r
-               $file = $BASE."member/".$template.".tpl";\r
-       }\r
-        else\r
-       {\r
-               // Test for extension\r
-               $test = substr($template, 0, strpos($template, "_"));\r
-               if (EXT_IS_ACTIVE($test))\r
-               {\r
-                       // Set extra path to extension's name\r
-                       $file = $BASE.$test."/".$template.".tpl";\r
-               }\r
-                else\r
-               {\r
-                       // No special filename\r
-                       $file = $BASE.$template.".tpl";\r
-               }\r
-       }\r
-\r
-       // Does the special template exists?\r
-       if (!@file_exists($file))\r
-       {\r
-               // Reset to default template\r
-               $file = $BASE.$template.".tpl";\r
-       }\r
-\r
-       // Now does the final template exists?\r
-       if (@file_exists($file))\r
-       {\r
-               // The local file does exists so we load it. :)\r
-               $tmpl_file = @implode("", @file($file));\r
-               $tmpl_file = addslashes($tmpl_file);\r
-\r
-               // Compile code\r
-               $tmpl_file = COMPILE_CODE($tmpl_file);\r
-\r
-               // Run code\r
-               $tmpl_file = "\$content=\"".$tmpl_file."\";";\r
-               eval($tmpl_file);\r
-\r
-               // Replace HTML confirm chars\r
-               $content = html_entity_decode($content);\r
-       }\r
-        elseif (!empty($template))\r
-       {\r
-               // Template file not found!\r
-               $content = TEMPLATE_404.": ".$template;\r
-       }\r
-        else\r
-       {\r
-               // No template name supplied!\r
-               $content = NO_TEMPLATE_SUPPLIED;\r
-       }\r
-       return COMPILE_CODE($content);\r
-}\r
-//\r
-function MAKE_TIME($H, $M, $S, $stamp)\r
-{\r
-       // Extract day, month and year from given timestamp\r
-       $DAY   = date("d", $stamp);\r
-       $MONTH = date("m", $stamp);\r
-       $YEAR  = date("Y", $stamp);\r
-\r
-       // Create timestamp for wished time which depends on extracted date\r
-       return mktime($H, $M, $S, $MONTH, $DAY, $YEAR);\r
-}\r
-//\r
-function LOAD_URL($URL) {\r
-       // Add some data to URL if cookies are not accepted\r
-       if ((!defined('__COOKIES')) || (!__COOKIES)) $URL = ADD_URL_DATA($URL);\r
-\r
-       // Probe for bot from search engine\r
-       if ((eregi("spider", getenv('HTTP_USER_AGENT'))) || (eregi("bot", getenv('HTTP_USER_AGENT'))) || (eregi("spider", getenv('HTTP_USER_AGENT')))) {\r
-               // Search engine bot detected so let's rewrite many chars for the link\r
-               $URL = htmlentities(strip_tags($URL), ENT_QUOTES);\r
-\r
-               // Output new location link as anchor\r
-               OUTPUT_HTML ("<A href=\"".$URL."\">".$URL."</A>\n");\r
-       } elseif (!headers_sent()) {\r
-               // Load URL when headers are not sent\r
-               @header ("Location: ".str_replace("&amp;", "&", $URL));\r
-       } else {\r
-               // Output error message\r
-               include(PATH."inc/header.php");\r
-               OUTPUT_HTML (LOAD_URL_ERROR_1.$URL.LOAD_URL_ERROR_2);\r
-               include(PATH."inc/footer.php");\r
-       }\r
-       exit();\r
-}\r
-//\r
-function COMPILE_CODE($code, $simple = false, $constants = true, $full = true) {\r
-       global $SEC_CHARS, $URL_CHARS;\r
-       $ARRAY = $SEC_CHARS;\r
-\r
-       // Select smaller set of chars to replace when we e.g. want to compile URLs\r
-       if (!$full) $ARRAY = $URL_CHARS;\r
-\r
-       // Compile constants\r
-       if ($constants) {\r
-               // BEFORE 0.2.1 : Language and data constants\r
-               // WITH 0.2.1+  : Only language constants\r
-               $code = str_replace("{--", '".', str_replace("--}", '."', $code));\r
-\r
-               // BEFORE 0.2.1 : Not used\r
-               // WITH 0.2.1+  : Data constants\r
-               $code = str_replace("{!", '".', str_replace("!}", '."', $code));\r
-       }\r
-\r
-       // Compile QUOT and other non-HTML codes\r
-       foreach ($ARRAY['to'] as $k => $to) {\r
-               // Do the reversed thing as in inc/libs/security_functions.php\r
-               $code = str_replace($to, $ARRAY['from'][$k], $code);\r
-       }\r
-\r
-       // But shall I keep simple quotes for later use?\r
-       if ($simple) $code = str_replace("\'", "{QUOT}", $code);\r
-\r
-       // Find $content[bla][blub] entries\r
-       @preg_match_all('/\$(content|DATA)((\[([a-zA-Z0-9-_]+)\])*)/', $code, $matches);\r
-\r
-       // Are some matches found?\r
-       if ((count($matches) > 0) && (count($matches[0]) > 0)) {\r
-               // Replace all matches\r
-               $matchesFound = array();\r
-               foreach ($matches[0] as $key=>$match) {\r
-                       // Avoid replacing matches multiple times\r
-                       if (!isset($matchesFound[$match])) {\r
-                               // Not yet replaced!\r
-                               $code = str_replace($match, "\".".$match.".\"", $code);\r
-                               $matchesFound[$match] = 1;\r
-                       }\r
-\r
-                       // Take all string elements\r
-                       if (("".bigintval($matches[4][$key])."" != $matches[4][$key]) && (!isset($matchesFound[$key."_".$matches[4][$key]]))) {\r
-                               // Replace it in the code\r
-                               $code = str_replace("[".$matches[4][$key]."]", "['".$matches[4][$key]."']", $code);\r
-                               $matchesFound[$key."_".$matches[4][$key]] = 1;\r
-                       }\r
-               }\r
-       }\r
-\r
-       // Return compiled code\r
-       return $code;\r
-}\r
-//\r
-/************************************************************************\r
- *                                                                      *\r
- * Gaenderter Sortier-Algorythmus, $array wird nach dem Array (!)       *\r
- * $a_sort sortiert:                                                    *\r
- *                                                                      *\r
- * $array - Das 3-dimensionale Array, das paralell sortiert werden soll *\r
- * $a_sort - Array, das die Sortiereihenfolge der ersten Elementeben    *\r
- * $primary_key - Prim.rschl.ssel aus $a_sort, nach dem sortiert wird   *\r
- * $order - Sortiereihenfolge: -1 = A-Z, 0 = keine, 1 = Z-A             *\r
- * $nums - true = Als Zahlen sortieren, false = Als Zeichen sortieren   *\r
- *                                                                      *\r
- * $a_sort muss Elemente enthalten, deren Wert Schluessel von $array    *\r
- * sind... Klingt kompliziert, suchen Sie mal mein Beispiel, dann sehen *\r
- * Sie, dass es doch nicht so schwer ist! :-)                           *\r
- *                                                                      *\r
- ************************************************************************/\r
-function array_pk_sort(&$array, $a_sort, $primary_key = 0, $order = -1, $nums = false)\r
-{\r
-       $dummy = $array;\r
-       while ($primary_key < count($a_sort))\r
-       {\r
-               foreach ($dummy[$a_sort[$primary_key]] as $key=>$value)\r
-               {\r
-                       foreach ($dummy[$a_sort[$primary_key]] as $key2=>$value2)\r
-                       {\r
-                               $match = false;\r
-                               if (!$nums)\r
-                               {\r
-                                       // Sort byte-by-byte (also numbers will be interpreted as chars! E.g.: "9" > "10")\r
-                                       if (($key != $key2) && (strcmp(strtolower($dummy[$a_sort[$primary_key]][$key]), strtolower($dummy[$a_sort[$primary_key]][$key2])) == $order)) $match = true;\r
-                               }\r
-                                elseif ($key != $key2)\r
-                               {\r
-                                       // Sort numbers (E.g.: 9 < 10)\r
-                                       if (($dummy[$a_sort[$primary_key]][$key] < $dummy[$a_sort[$primary_key]][$key2]) && ($order == -1)) $match = true;\r
-                                       if (($dummy[$a_sort[$primary_key]][$key] > $dummy[$a_sort[$primary_key]][$key2]) && ($order == 1))  $match = true;\r
-                               }\r
-                               if ($match)\r
-                               {\r
-                                       // We have found two different values, so let's sort whole array\r
-                                       foreach ($dummy as $sort_key=>$sort_val)\r
-                                       {\r
-                                               $t                       = $dummy[$sort_key][$key];\r
-                                               $dummy[$sort_key][$key]  = $dummy[$sort_key][$key2];\r
-                                               $dummy[$sort_key][$key2] = $t;\r
-                                               unset($t);\r
-                                       }\r
-                               }\r
-                       }\r
-               }\r
-\r
-               // Count one up\r
-               $primary_key++;\r
-       }\r
-\r
-       // Write back sorted array\r
-       $array = $dummy;\r
-}\r
-//\r
-function ADD_SELECTION($TYPE, $DEFAULT, $PREFIX="", $id="0")\r
-{\r
-       global $MONTH_DESCR; $OUT = "";\r
-       if ($TYPE == "yn")\r
-       {\r
-               // This is a yes/no selection only!\r
-               if ($id > 0) $PREFIX .= "[".$id."]";\r
-               $OUT .= "    <SELECT name=\"".$PREFIX."\" class=\"register_select\" size=\"1\">\n";\r
-       }\r
-        else\r
-       {\r
-               // Begin with regular selection box here\r
-               if (!empty($PREFIX)) $PREFIX .= "_";\r
-               $TYPE2 = $TYPE;\r
-               if ($id > 0) $TYPE2 .= "[".$id."]";\r
-               $OUT .= "    <SELECT name=\"".strtolower($PREFIX.$TYPE2)."\" class=\"register_select\" size=\"1\">\n";\r
-       }\r
-       switch ($TYPE)\r
-       {\r
-       case "day": // Day\r
-               for ($idx = 1; $idx < 32; $idx++)\r
-               {\r
-                       $OUT .= "      <OPTION value=\"".$idx."\"";\r
-                       if ($DEFAULT == $idx) $OUT .= " selected=\"selected\"";\r
-                       $OUT .= ">".$idx."</OPTION>\n";\r
-               }\r
-               break;\r
-\r
-       case "month": // Month\r
-               foreach ($MONTH_DESCR as $month=>$descr)\r
-               {\r
-                       $OUT .= "      <OPTION value=\"".$month."\"";\r
-                       if ($DEFAULT == $month) $OUT .= " selected=\"selected\"";\r
-                       $OUT .= ">".$descr."</OPTION>\n";\r
-               }\r
-               break;\r
-\r
-       case "year": // Year\r
-               // Get current year\r
-               $YEAR = date("Y", time());\r
-\r
-               // Check if the default value is larger than minimum and bigger than actual year\r
-               if (($DEFAULT > 1930) && ($DEFAULT >= $YEAR))\r
-               {\r
-                       for ($idx = $YEAR; $idx < ($YEAR + 11); $idx++)\r
-                       {\r
-                               $OUT .= "      <OPTION value=\"".$idx."\"";\r
-                               if ($DEFAULT == $idx) $OUT .= " selected=\"selected\"";\r
-                               $OUT .= ">".$idx."</OPTION>\n";\r
-                       }\r
-               }\r
-                elseif ($DEFAULT == -1)\r
-               {\r
-                       // Current year minus 1\r
-                       for ($idx = 2003; $idx <= ($YEAR + 1); $idx++)\r
-                       {\r
-                               $OUT .= "      <OPTION value=\"".$idx."\">".$idx."</OPTION>\n";\r
-                       }\r
-               }\r
-                else\r
-               {\r
-                       // Get current year and subtract 16 (for erotic content)\r
-                       $OUT .= "      <OPTION value=\"1929\">&lt;1930</OPTION>\n";\r
-                       $YEAR = date("Y", time()) - 16;\r
-                       for ($idx = 1930; $idx <= $YEAR; $idx++)\r
-                       {\r
-                               $OUT .= "      <OPTION value=\"".$idx."\"";\r
-                               if ($DEFAULT == $idx) $OUT .= " selected=\"selected\"";\r
-                               $OUT .= ">".$idx."</OPTION>\n";\r
-                       }\r
-               }\r
-               break;\r
-\r
-       case "sec":\r
-       case "min":\r
-               for ($idx = 0; $idx < 60; $idx+=5)\r
-               {\r
-                       if (strlen($idx) == 1) $idx = "0".$idx;\r
-                       $OUT .= "      <OPTION value=\"".$idx."\"";\r
-                       if ($DEFAULT == $idx) $OUT .= " selected=\"selected\"";\r
-                       $OUT .= ">".$idx."</OPTION>\n";\r
-               }\r
-               break;\r
-\r
-       case "hour":\r
-               for ($idx = 0; $idx < 24; $idx++)\r
-               {\r
-                       if (strlen($idx) == 1) $idx = "0".$idx;\r
-                       $OUT .= "      <OPTION value=\"".$idx."\"";\r
-                       if ($DEFAULT == $idx) $OUT .= " selected=\"selected\"";\r
-                       $OUT .= ">".$idx."</OPTION>\n";\r
-               }\r
-               break;\r
-\r
-       case "yn":\r
-               $OUT .= "      <OPTION value=\"Y\"";\r
-               if ($DEFAULT == "Y") $OUT .= " selected=\"selected\"";\r
-               $OUT .= ">".YES."</OPTION>\r
-      <OPTION value=\"N\"";\r
-               if ($DEFAULT == "N") $OUT .= " selected=\"selected\"";\r
-               $OUT .= ">".NO."</OPTION>\n";\r
-               break;\r
-       }\r
-       $OUT .= "    </SELECT>\n";\r
-       return $OUT;\r
-}\r
-//\r
-function TRANSLATE_YESNO($yn)\r
-{\r
-       switch ($yn)\r
-       {\r
-               case "Y": $yn = YES; break;\r
-               case "N": $yn = NO; break;\r
-               default : $yn = "??? (".$yn.")"; break;\r
-       }\r
-       return $yn;\r
-}\r
-//\r
-// Deprecated : $length\r
-// Optional   : $DATA\r
-//\r
-function GEN_RANDOM_CODE($length, $code, $uid, $DATA="")\r
-{\r
-       global $CONFIG;\r
-\r
-       // Build server string\r
-       $server = $_SERVER['PHP_SELF'].":".getenv('HTTP_USER_AGENT').":".getenv('SERVER_SOFTWARE').":".getenv('REMOTE_ADDR').":".":".filemtime(PATH."inc/databases.php");\r
-\r
-       // Build key string\r
-       $keys   = SITE_KEY.":".DATE_KEY.":".$CONFIG['secret_key'].":".$CONFIG['file_hash'].":".date("d-m-Y (l-F-T)", $CONFIG['patch_ctime']).":".$CONFIG['master_salt'];\r
-\r
-       // Build string from misc data\r
-       $data   = $code.":".$uid.":".$DATA;\r
-\r
-       // Add more additional data\r
-       if (isset($_COOKIE['u_hash']))         $data .= ":".$_COOKIE['u_hash'];\r
-       if (isset($GLOBALS['userid']))         $data .= ":".$GLOBALS['userid'];\r
-       if (isset($_COOKIE['lifetime']))       $data .= ":".$_COOKIE['lifetime'];\r
-       if (isset($_COOKIE['mxchange_theme'])) $data .= ":".$_COOKIE['mxchange_theme'];\r
-       if (isset($_COOKIE['mx_lang']))        $data .= ":".$_COOKIE['mx_lang'];\r
-       if (isset($GLOBALS['refid']))          $data .= ":".$GLOBALS['refid'];\r
-\r
-       // Calculate number for generating the code\r
-       $a = $code + _ADD - 1;\r
-\r
-       // Generate hash with master salt from modula of number with the prime number and other data\r
-       $saltedHash = generateHash(($a % _PRIME).":".$server.":".$keys.":".$data.":".date("d-m-Y (l-F-T)", time()).":".$a, $CONFIG['master_salt']);\r
-\r
-       // Create number from hash\r
-       $rcode = hexdec(substr($saltedHash, strlen($CONFIG['master_salt']), 9)) / abs(_MAX - $a + sqrt(_ADD)) / pi();\r
-\r
-       // At least 10 numbers shall be secure enought!\r
-       $len = $CONFIG['code_length'];\r
-       if ($len == 0) $len = 10;\r
-\r
-       // Cut off requested counts of number\r
-       $return = substr(str_replace('.', '', $rcode), 0, $len);\r
-\r
-       // Done building code\r
-       return $return;\r
-}\r
-// Does only allow numbers\r
-function bigintval($num)\r
-{\r
-       $ret = (int) preg_replace("/[^0123456789]/", "", $num);\r
-       return $ret;\r
-}\r
-// Insert the code in $img_code into jpeg or PNG image\r
-function GENERATE_IMAGE($img_code, $header=true)\r
-{\r
-       global $CONFIG;\r
-       if ((strlen($img_code) > 6) || (empty($img_code)) || ($CONFIG['code_length'] == 0))\r
-       {\r
-               // Stop execution of function here because of over-sized code length\r
-               return;\r
-       }\r
-        elseif (!$header)\r
-       {\r
-               // Return in an HTML code code\r
-               return "<IMG src=\"".URL."/img.php?code=".$img_code."\">\n";\r
-       }\r
-\r
-       switch ($CONFIG['img_type'])\r
-       {\r
-       case "jpg":\r
-               // Loads JPEG image\r
-               $img = PATH."/theme/".GET_CURR_THEME()."/images/code_bg.jpg";\r
-               if ((file_exists($img)) && (is_readable($img)))\r
-               {\r
-                       // Okay, load image and hide all errors\r
-                       $image = @imagecreatefromjpeg($img);\r
-               }\r
-                else\r
-               {\r
-                       // Exit function here\r
-                       return;\r
-               }\r
-               break;\r
-\r
-       case "png":\r
-               // Loads PNG image\r
-               $img = PATH."/theme/".GET_CURR_THEME()."/images/code_bg.png";\r
-               if ((file_exists($img)) && (is_readable($img)))\r
-               {\r
-                       // Okay, load image and hide all errors\r
-                       $image = @imagecreatefrompng($img);\r
-               }\r
-                else\r
-               {\r
-                       // Exit function here\r
-                       return;\r
-               }\r
-               break;\r
-       }\r
-\r
-       // Generate text color (red/green/blue; 0 = dark, 255 = bright)\r
-       $text_color = imagecolorallocate($image, 0, 0, 0);\r
-\r
-       // Insert code into image\r
-       imagestring($image, 5, 14, 2, $img_code, $text_color);\r
-\r
-       // Return to browser\r
-       header ("Content-Type: image/".$CONFIG['img_type']);\r
-\r
-       // Output image with matching image factory\r
-       switch ($CONFIG['img_type'])\r
-       {\r
-               case "jpg": imagejpeg($image); break;\r
-               case "png": imagepng($image);  break;\r
-       }\r
-\r
-       // Remove image from memory\r
-       imagedestroy($image);\r
-}\r
-function CREATE_TIME_SELECTIONS($timestamp, $prefix="", $display="", $align="center", $return_array=false)\r
-{\r
-       // Calculate 15-seconds timestamp (15-seconds-steps shall be fine ;) )\r
-       $timestamp = round($timestamp / 15) * 15;\r
-       // Do we have a leap year?\r
-       $SWITCH = 0;\r
-       $TEST = date("Y", time()) / 4;\r
-       $M1 = date("m", time());\r
-       $M2 = date("m", (time() + $timestamp));\r
-       // If so and if current time is before 02/29 and estimated time is after 02/29 then add 86400 seconds (one day)\r
-       if ((floor($TEST) == $TEST) && ($M1 == "02") && ($M2 > "02"))  $SWITCH = ONE_DAY;\r
-       // First of all years...\r
-       $Y = abs(floor($timestamp / (31536000 + $SWITCH)));\r
-       // Next months...\r
-       $M = abs(floor($timestamp / 2628000 - $Y * 12));\r
-       // Next weeks\r
-       $W = abs(floor($timestamp / 604800 - $Y * ((365 + $SWITCH / ONE_DAY) / 7) - ($M / 12 * (365 + $SWITCH / ONE_DAY) / 7)));\r
-       // Next days...\r
-       $D = abs(floor($timestamp / 86400 - $Y * (365 + $SWITCH / ONE_DAY) - ($M / 12 * (365 + $SWITCH / ONE_DAY)) - $W * 7));\r
-       // Next hours...\r
-       $h = abs(floor($timestamp / 3600 - $Y * (365 + $SWITCH / ONE_DAY) * 24 - ($M / 12 * (365 + $SWITCH / ONE_DAY) * 24) - $W * 7 * 24 - $D * 24));\r
-       // Next minutes..\r
-       $m = abs(floor($timestamp / 60 - $Y * (365 + $SWITCH / ONE_DAY) * 24 * 60 - ($M / 12 * (365 + $SWITCH / ONE_DAY) * 24 * 60) - $W * 7 * 24 * 60 - $D * 24 * 60 - $h * 60));\r
-       // And at last seconds...\r
-       $s = abs(floor($timestamp - $Y * (365 + $SWITCH / ONE_DAY) * 24 * 3600 - ($M / 12 * (365 + $SWITCH / ONE_DAY) * 24 * 3600) - $W * 7 * 24 * 3600 - $D * 24 * 3600 - $h * 3600 - $m * 60));\r
-       //\r
-       // Now we convert them in seconds...\r
-       //\r
-       if ($return_array)\r
-       {\r
-               // Just put all data in an array for later use\r
-               $OUT = array(\r
-                       'YEARS'   => $Y,\r
-                       'MONTHS'  => $M,\r
-                       'WEEKS'   => $W,\r
-                       'DAYS'    => $D,\r
-                       'HOURS'   => $h,\r
-                       'MINUTES' => $m,\r
-                       'SECONDS' => $s\r
-               );\r
-       }\r
-        else\r
-       {\r
-               // Generate table\r
-               $OUT  = "<DIV align=\"".$align."\">\n";\r
-               $OUT .= "<TABLE border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"admin_table dashed\">\n";\r
-               $OUT .= "<TR>\n";\r
-               if (ereg("Y", $display) || (empty($display)))\r
-               {\r
-                       $OUT .= "  <TD align=\"center\" class=\"admin_title bottom\"><STRONG class=\"tiny\">"._YEARS."</STRONG></TD>\n";\r
-               }\r
-               if (ereg("M", $display) || (empty($display)))\r
-               {\r
-                       $OUT .= "  <TD align=\"center\" class=\"admin_title bottom\"><STRONG class=\"tiny\">"._MONTHS."</STRONG></TD>\n";\r
-               }\r
-               if (ereg("W", $display) || (empty($display)))\r
-               {\r
-                       $OUT .= "  <TD align=\"center\" class=\"admin_title bottom\"><STRONG class=\"tiny\">"._WEEKS."</STRONG></TD>\n";\r
-               }\r
-               if (ereg("D", $display) || (empty($display)))\r
-               {\r
-                       $OUT .= "  <TD align=\"center\" class=\"admin_title bottom\"><STRONG class=\"tiny\">"._DAYS."</STRONG></TD>\n";\r
-               }\r
-               if (ereg("h", $display) || (empty($display)))\r
-               {\r
-                       $OUT .= "  <TD align=\"center\" class=\"admin_title bottom\"><STRONG class=\"tiny\">"._HOURS."</STRONG></TD>\n";\r
-               }\r
-               if (ereg("m", $display) || (empty($display)))\r
-               {\r
-                       $OUT .= "  <TD align=\"center\" class=\"admin_title bottom\"><STRONG class=\"tiny\">"._MINUTES."</STRONG></TD>\n";\r
-               }\r
-               if (ereg("s", $display) || (empty($display)))\r
-               {\r
-                       $OUT .= "  <TD align=\"center\" class=\"admin_title bottom\"><STRONG class=\"tiny\">".SECS."</STRONG></TD>\n";\r
-               }\r
-               $OUT .= "</TR>\n";\r
-               $OUT .= "<TR>\n";\r
-               if (ereg("Y", $display) || (empty($display)))\r
-               {\r
-                       // Generate year selection\r
-                       $OUT .= "  <TD align=\"center\"><SELECT class=\"mini_select\" name=\"".$prefix."_ye\" size=\"1\">\n";\r
-                       for ($idx = 0; $idx <= 10; $idx++)\r
-                       {\r
-                               $OUT .= "    <OPTION class=\"mini_select\" value=\"".$idx."\"";\r
-                               if ($idx == $Y) $OUT .= " selected default";\r
-                               $OUT .= ">".$idx."</OPTION>\n";\r
-                       }\r
-                       $OUT .= "  </SELECT></TD>\n";\r
-               }\r
-                else\r
-               {\r
-                       $OUT .= "<INPUT type=\"hidden\" name=\"".$prefix."_ye\" value=\"0\">\n";\r
-               }\r
-               if (ereg("M", $display) || (empty($display)))\r
-               {\r
-                       // Generate month selection\r
-                       $OUT .= "  <TD align=\"center\"><SELECT class=\"mini_select\" name=\"".$prefix."_mo\" size=\"1\">\n";\r
-                       for ($idx = 0; $idx <= 11; $idx++)\r
-                       {\r
-                                       $OUT .= "  <OPTION class=\"mini_select\" value=\"".$idx."\"";\r
-                               if ($idx == $M) $OUT .= " selected default";\r
-                               $OUT .= ">".$idx."</OPTION>\n";\r
-                       }\r
-                       $OUT .= "  </SELECT></TD>\n";\r
-               }\r
-                else\r
-               {\r
-                       $OUT .= "<INPUT type=\"hidden\" name=\"".$prefix."_mo\" value=\"0\">\n";\r
-               }\r
-               if (ereg("W", $display) || (empty($display)))\r
-               {\r
-                       // Generate week selection\r
-                       $OUT .= "  <TD align=\"center\"><SELECT class=\"mini_select\" name=\"".$prefix."_we\" size=\"1\">\n";\r
-                       for ($idx = 0; $idx <= 4; $idx++)\r
-                       {\r
-                               $OUT .= "  <OPTION class=\"mini_select\" value=\"".$idx."\"";\r
-                               if ($idx == $W) $OUT .= " selected default";\r
-                               $OUT .= ">".$idx."</OPTION>\n";\r
-                       }\r
-                       $OUT .= "  </SELECT></TD>\n";\r
-               }\r
-                else\r
-               {\r
-                       $OUT .= "<INPUT type=\"hidden\" name=\"".$prefix."_we\" value=\"0\">\n";\r
-               }\r
-               if (ereg("D", $display) || (empty($display)))\r
-               {\r
-                       // Generate day selection\r
-                       $OUT .= "  <TD align=\"center\"><SELECT class=\"mini_select\" name=\"".$prefix."_da\" size=\"1\">\n";\r
-                       for ($idx = 0; $idx <= 31; $idx++)\r
-                       {\r
-                               $OUT .= "  <OPTION class=\"mini_select\" value=\"".$idx."\"";\r
-                               if ($idx == $D) $OUT .= " selected default";\r
-                               $OUT .= ">".$idx."</OPTION>\n";\r
-                       }\r
-                       $OUT .= "  </SELECT></TD>\n";\r
-               }\r
-                else\r
-               {\r
-                       $OUT .= "<INPUT type=\"hidden\" name=\"".$prefix."_da\" value=\"0\">\n";\r
-               }\r
-               if (ereg("h", $display) || (empty($display)))\r
-               {\r
-                       // Generate hour selection\r
-                       $OUT .= "  <TD align=\"center\"><SELECT class=\"mini_select\" name=\"".$prefix."_ho\" size=\"1\">\n";\r
-                       for ($idx = 0; $idx <= 23; $idx++)\r
-                       {\r
-                               $OUT .= "  <OPTION class=\"mini_select\" value=\"".$idx."\"";\r
-                               if ($idx == $h) $OUT .= " selected default";\r
-                               $OUT .= ">".$idx."</OPTION>\n";\r
-                       }\r
-                       $OUT .= "  </SELECT></TD>\n";\r
-               }\r
-                else\r
-               {\r
-                       $OUT .= "<INPUT type=\"hidden\" name=\"".$prefix."_ho\" value=\"0\">\n";\r
-               }\r
-               if (ereg("m", $display) || (empty($display)))\r
-               {\r
-                       // Generate minute selection\r
-                       $OUT .= "  <TD align=\"center\"><SELECT class=\"mini_select\" name=\"".$prefix."_mi\" size=\"1\">\n";\r
-                       for ($idx = 0; $idx <= 59; $idx++)\r
-                       {\r
-                               $OUT .= "  <OPTION class=\"mini_select\" value=\"".$idx."\"";\r
-                               if ($idx == $m) $OUT .= " selected default";\r
-                               $OUT .= ">".$idx."</OPTION>\n";\r
-                       }\r
-                       $OUT .= "  </SELECT></TD>\n";\r
-               }\r
-                else\r
-               {\r
-                       $OUT .= "<INPUT type=\"hidden\" name=\"".$prefix."_mi\" value=\"0\">\n";\r
-               }\r
-               if (ereg("s", $display) || (empty($display)))\r
-               {\r
-                       // Generate second selection\r
-                       $OUT .= "  <TD align=\"center\"><SELECT class=\"mini_select\" name=\"".$prefix."_se\" size=\"1\">\n";\r
-                       for ($idx = 0; $idx <= 45; $idx+=15)\r
-                       {\r
-                               $OUT .= "  <OPTION class=\"mini_select\" value=\"".$idx."\"";\r
-                               if ($idx == $s) $OUT .= " selected default";\r
-                               $OUT .= ">".$idx."</OPTION>\n";\r
-                       }\r
-                       $OUT .= "  </SELECT></TD>\n";\r
-               }\r
-                else\r
-               {\r
-                       $OUT .= "<INPUT type=\"hidden\" name=\"".$prefix."_se\" value=\"0\">\n";\r
-               }\r
-               $OUT .= "</TR>\n";\r
-               $OUT .= "</TABLE>\n";\r
-               $OUT .= "</DIV>\n";\r
-               // Return generated HTML code\r
-       }\r
-       return $OUT;\r
-}\r
-//\r
-function CREATE_TIMESTAMP_FROM_SELECTIONS($prefix, $POST) {\r
-       $ret = "0";\r
-       // Do we have a leap year?\r
-       $SWITCH = 0;\r
-       $TEST = date("Y", time()) / 4;\r
-       $M1   = date("m", time());\r
-       // If so and if current time is before 02/29 and estimated time is after 02/29 then add 86400 seconds (one day)\r
-       if ((floor($TEST) == $TEST) && ($M1 == "02") && ($POST[$prefix."_mo"] > "02"))  $SWITCH = ONE_DAY;\r
-       // First add years...\r
-       $ret += $POST[$prefix."_ye"] * (31536000 + $SWITCH);\r
-       // Next months...\r
-       $ret += $POST[$prefix."_mo"] * 2628000;\r
-       // Next weeks\r
-       $ret += $POST[$prefix."_we"] * 604800;\r
-       // Next days...\r
-       $ret += $POST[$prefix."_da"] * 86400;\r
-       // Next hours...\r
-       $ret += $POST[$prefix."_ho"] * 3600;\r
-       // Next minutes..\r
-       $ret += $POST[$prefix."_mi"] * 60;\r
-       // And at last seconds...\r
-       $ret += $POST[$prefix."_se"];\r
-       // Return calculated value\r
-       return $ret;\r
-}\r
-// Sends out mail to all administrators\r
-function SEND_ADMIN_EMAILS_PRO($subj, $template, $content="", $UID="0") {\r
-       // Trim template name\r
-       $template = trim($template);\r
-\r
-       // Load email template\r
-       $msg = LOAD_EMAIL_TEMPLATE($template, $content, $UID);\r
-\r
-       if (GET_EXT_VERSION("admins") < "0.4.0") {\r
-               // Older version detected!\r
-               return SEND_ADMIN_EMAILS($subj, $msg);\r
-       }\r
-\r
-       // Check which admin shall receive this mail\r
-       $result = SQL_QUERY_ESC("SELECT DISTINCT admin_id FROM "._MYSQL_PREFIX."_admins_mails WHERE mail_template='%s' ORDER BY admin_id",\r
-        array($template), __FILE__, __LINE__);\r
-       if (SQL_NUMROWS($result) == 0) {\r
-               // Create new entry (to all admins)\r
-               $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_admins_mails (admin_id, mail_template) VALUES (0, '%s')",\r
-                array($template), __FILE__, __LINE__);\r
-       } else {\r
-               // Load admin IDs...\r
-               $aids = array();\r
-               while(list($aid) = SQL_FETCHROW($result)) {\r
-                       $aids[] = $aid;\r
-               }\r
-\r
-               // Free memory\r
-               SQL_FREERESULT($result);\r
-\r
-               // "implode" IDs and query string\r
-               $aid = implode(",", $aids);\r
-               if ($aid == "-1") {\r
-                       // Add line to userlog\r
-                       USERLOG_ADD_LINE($subj, $msg, $UID);\r
-                       return;\r
-               } elseif ($aid == "0") {\r
-                       // Select all email adresses\r
-                       $result = SQL_QUERY("SELECT email FROM "._MYSQL_PREFIX."_admins ORDER BY id", __FILE__, __LINE__);\r
-               } else {\r
-                       // If Admin-ID is not "to-all" select\r
-                       $result = SQL_QUERY_ESC("SELECT email FROM "._MYSQL_PREFIX."_admins WHERE id IN (%s) ORDER BY id", array($aid), __FILE__, __LINE__);\r
-               }\r
-       }\r
-\r
-       // Load email addresses and send away\r
-       while (list($email) = SQL_FETCHROW($result)) {\r
-               SEND_EMAIL($email, $subj, $msg);\r
-       }\r
-\r
-       // Free memory\r
-       SQL_FREERESULT($result);\r
-}\r
-//\r
-function CREATE_FANCY_TIME($stamp) {\r
-       // Get data array with years/months/weeks/days/...\r
-       $data = CREATE_TIME_SELECTIONS($stamp, "", "", "", true);\r
-       $ret = "";\r
-       foreach($data as $k=>$v) {\r
-               if ($v > 0) {\r
-                       // Value is greater than 0 "eval" data to return string\r
-                       $eval = "\$ret .= \", \".\$v.\" \"._".strtoupper($k).";";\r
-                       eval($eval);\r
-                       break;\r
-               }\r
-       }\r
-\r
-       // Remove first "comma,null" string\r
-       $ret = substr($ret, 2);\r
-       return $ret;\r
-}\r
-//\r
-function ADD_EMAIL_NAV($PAGES, $offset, $show_form, $colspan, $return=false) {\r
-       $SEP = ""; $TOP = "";\r
-       if (!$show_form) {\r
-               $TOP = " top2";\r
-               $SEP = "<TR><TD colspan=\"".$colspan."\" class=\"seperator\">&nbsp;</TD></TR>";\r
-       }\r
-\r
-       $NAV = "";\r
-       for ($page = 1; $page <= $PAGES; $page++) {\r
-               // Is the page currently selected or shall we generate a link to it?\r
-               if (($page == $_GET['page']) || ((empty($_GET['page'])) && ($page == "1"))) {\r
-                       // Is currently selected, so only highlight it\r
-                       $NAV .= "<STRONG>-";\r
-               } else {\r
-                       // Open anchor tag and add base URL\r
-                       $NAV .= "<A href=\"".URL."/modules.php?module=admin&amp;what=".$GLOBALS['what']."&amp;page=".$page."&amp;offset=".$offset;\r
-\r
-                       // Add userid when we shall show all mails from a single member\r
-                       if ((isset($_GET['u_id'])) && (bigintval($_GET['u_id']) > 0)) $NAV .= "&amp;u_id=".bigintval($_GET['u_id']);\r
-\r
-                       // Close open anchor tag\r
-                       $NAV .= "\">";\r
-               }\r
-               $NAV .= $page;\r
-               if (($page == $_GET['page']) || ((empty($_GET['page'])) && ($page == "1"))) {\r
-                       // Is currently selected, so only highlight it\r
-                       $NAV .= "-</STRONG>";\r
-               } else {\r
-                       // Close anchor tag\r
-                       $NAV .= "</A>";\r
-               }\r
-\r
-               // Add seperator if we have not yet reached total pages\r
-               if ($page < $PAGES) $NAV .= "&nbsp;|&nbsp;";\r
-       }\r
-\r
-       // Define constants only once\r
-       if (!defined('__NAV_OUTPUT')) {\r
-               define('__NAV_OUTPUT' , $NAV);\r
-               define('__NAV_COLSPAN', $colspan);\r
-               define('__NAV_TOP'    , $TOP);\r
-               define('__NAV_SEP'    , $SEP);\r
-       }\r
-\r
-       // Load navigation template\r
-       $OUT = LOAD_TEMPLATE("admin_email_nav_row", true);\r
-\r
-       if ($return) {\r
-               // Return generated HTML-Code\r
-               return $OUT;\r
-       } else {\r
-               // Output HTML-Code\r
-               OUTPUT_HTML($OUT);\r
-       }\r
-}\r
-\r
-//\r
-function MXCHANGE_OPEN($script) {\r
-       // Extract host name\r
-       $host = str_replace("http://", "", SERVER_URL);\r
-       if (ereg("/", $host)) $host = substr($host, 0, strpos($host, "/"));\r
-\r
-       // Generate relative URL\r
-       $script = substr(SERVER_URL, (strpos(SERVER_URL, $host) + strlen($host)))."/".basename($script);\r
-       if (substr($script, 0, 1) == "/") $script = substr($script, 1);\r
-\r
-       // Open connection\r
-       $fp = @fsockopen($host, 80, $errno, $errdesc, 30);\r
-       if (!$fp)\r
-       {\r
-               // Failed!\r
-               return array("", "", "");\r
-       }\r
-\r
-       // Generate request header\r
-       $request  = "GET /".trim($script)." HTTP/1.0\r\n";\r
-       $request .= "Host: ".$host."\r\n";\r
-       $request .= "Referer: ".URL."/admin.php\r\n";\r
-       $request .= "User-Agent: ".TITLE."/".FULL_VERSION."\r\n\r\n";\r
-\r
-       // Initialize array\r
-       $response = array();\r
-\r
-       // Write request\r
-       fputs($fp, $request);\r
-\r
-       // Read response\r
-       while(!feof($fp)) {\r
-               $response[] = fgets($fp, 1024);\r
-       }\r
-\r
-       // Close socket\r
-       fclose($fp);\r
-\r
-       // Was the request successfull?\r
-       if ((!ereg("200 OK", $response[0])) && (empty($response[0]))) {\r
-               // Not found / access forbidden\r
-               $response = array("", "", "");\r
-       }\r
-\r
-       // Return response\r
-       return $response;\r
-}\r
-// Taken from www.php.net eregi() user comments\r
-function VALIDATE_EMAIL($email) {\r
-       // Compile email\r
-       $email = COMPILE_CODE($email);\r
-\r
-       // Check first part of email address\r
-       $first = "[-a-z0-9!#$%&\'*+/=?^_<{|}~]+(\.[-a-zA-Z0-9!#$%&\'*+/=?^_<{|}~]+)*";\r
-\r
-       //  Check domain\r
-       $domain = "[a-z0-9-]+(\.[a-z0-9-]{2,5})+";\r
-\r
-       // Generate pattern\r
-       $regex = "^".$first."@".$domain."$";\r
-\r
-       // Return check result\r
-       return eregi($regex, $email);\r
-}\r
-// Function taken from user comments on www.php.net / function eregi()\r
-function VALIDATE_URL ($URL, $compile=true) {\r
-       // Trim URL a little\r
-       $URL = trim(urldecode($URL));\r
-       //* DEBUG: */ echo $URL."<BR>";\r
-\r
-       // Compile some chars out...\r
-       if ($compile) $URL = COMPILE_CODE($URL, false, false, false);\r
-       //* DEBUG: */ echo $URL."<BR>";\r
-\r
-       // Check for the extension filter\r
-       if (EXT_IS_ACTIVE("filter")) {\r
-               // Use the extension's filter set\r
-               return FILTER_VALIDATE_URL($URL, false);\r
-       }\r
-\r
-       // If not installed, perform a simple test. Just make it sure there is always a http:// or\r
-       // https:// in front of the URLs\r
-       return (((substr($URL, 0, 7) == "http://") || (substr($URL, 0, 8) == "https://")) && (strlen($URL) >= 12));\r
-}\r
-//\r
-function MEMBER_ACTION_LINKS($uid, $status="") {\r
-       // Define all main targets\r
-       $TARGETS = array("del_user", "edit_user", "lock_user", "add_points", "sub_points");\r
-\r
-       // Begin of navigation links\r
-       $eval = "\$OUT = \"[&nbsp;";\r
-\r
-       foreach ($TARGETS as $tar) {\r
-               $eval .= "<SPAN class=\\\"admin_user_link\\\"><A href=\\\"".URL."/modules.php?module=admin&amp;what=".$tar."&amp;u_id=".$uid."\\\" title=\\\"\".ADMIN_LINK_";\r
-               //* DEBUG: */ echo "*".$tar."/".$status."*<br />\n";\r
-               if (($tar == "lock_user") && ($status == "LOCKED")) {\r
-                       // Locked accounts shall be unlocked\r
-                       $eval .= "UNLOCK_USER";\r
-               } else {\r
-                       // All other status is fine\r
-                       $eval .= strtoupper($tar);\r
-               }\r
-               $eval .= "_TITLE.\"\\\">\".ADMIN_";\r
-               if (($tar == "lock_user") && ($status == "LOCKED")) {\r
-                       // Locked accounts shall be unlocked\r
-                       $eval .= "UNLOCK_USER";\r
-               } else {\r
-                       // All other status is fine\r
-                       $eval .= strtoupper($tar);\r
-               }\r
-               $eval .= ".\"</A></SPAN>&nbsp;|&nbsp;";\r
-       }\r
-\r
-       // Finish navigation link\r
-       $eval = substr($eval, 0, -7) . "]\";";\r
-       eval($eval);\r
-\r
-       // Return string\r
-       return $OUT;\r
-}\r
-// Function for backward-compatiblity\r
-function ADD_CATEGORY_TABLE ($MODE, $return=false) {\r
-       // Load it from the register extension\r
-       return REGISTER_ADD_CATEGORY_TABLE ($MODE, $return);\r
-}\r
-// Generate an email link\r
-function CREATE_EMAIL_LINK($email, $table="admins") {\r
-       // Default email link (INSECURE! Spammer can read this by harvester programs)\r
-       $EMAIL = "mailto:".$email;\r
-\r
-       // Check for several extensions\r
-       if ((EXT_IS_ACTIVE("admins")) && ($table == "admins")) {\r
-               // Create email link for contacting admin in guest area\r
-               $EMAIL = ADMINS_CREATE_EMAIL_LINK($email);\r
-       } elseif ((GET_EXT_VERSION("user") >= "0.3.3") && ($table == "user_data")) {\r
-               // Create email link for contacting a member within admin area (or later in other areas, too?)\r
-               $EMAIL = USER_CREATE_EMAIL_LINK($email);\r
-       } elseif ((EXT_IS_ACTIVE("sponsor")) && ($table == "sponsor_data")) {\r
-               // Create email link to contact sponsor within admin area (or like the link above?)\r
-               $EMAIL = SPONSOR_CREATE_EMAIL_LINK($email);\r
-       }\r
-\r
-       // Shall I close the link when there is no admin?\r
-       if ((!IS_ADMIN()) && ($EMAIL == $email)) $EMAIL = "#"; // Closed!\r
-\r
-       // Return email link\r
-       return $EMAIL;\r
-}\r
-// Generate a hash for extra-security for all passwords\r
-function generateHash($plainText, $salt = "") {\r
-       global $CONFIG, $_SERVER;\r
-\r
-       // Is the required extension "sql_patches" there?\r
-       if ((GET_EXT_VERSION("sql_patches") < "0.3.6") || (GET_EXT_VERSION("sql_patches") == "")) {\r
-               // Extension sql_patches is missing/outdated so we return the plain text\r
-               return $plainText;\r
-       }\r
-\r
-       // When the salt is empty build a new one, else use the first x configured characters as the salt\r
-       if ($salt == "") {\r
-               // Build server string\r
-               $server = $_SERVER['PHP_SELF'].":".getenv('HTTP_USER_AGENT').":".getenv('SERVER_SOFTWARE').":".getenv('REMOTE_ADDR').":".":".filemtime(PATH."inc/databases.php");\r
-\r
-               // Build key string\r
-               $keys   = SITE_KEY.":".DATE_KEY.":".$CONFIG['secret_key'].":".$CONFIG['file_hash'].":".date("d-m-Y (l-F-T)", $CONFIG['patch_ctime']).":".$CONFIG['master_salt'];\r
-\r
-               // Additional data\r
-               $data = $plainText.":".uniqid(rand(), true).":".time();\r
-\r
-               // Calculate number for generating the code\r
-               $a = time() + _ADD - 1;\r
-\r
-               // Generate SHA1 sum from modula of number and the prime number\r
-               $sha1 = sha1(($a % _PRIME).$server.":".$keys.":".$data.":".date("d-m-Y (l-F-T)", time()).":".$a);\r
-               //* DEBUG: */ echo "SHA1=".$sha1." (".strlen($sha1).")<br>";\r
-               $sha1 = scrambleString($sha1);\r
-               //* DEBUG: */ echo "Scrambled=".$sha1." (".strlen($sha1).")<br>";\r
-               //* DEBUG: */ $sha1b = descrambleString($sha1);\r
-               //* DEBUG: */ echo "Descrambled=".$sha1b." (".strlen($sha1b).")<br>";\r
-\r
-               // Generate the password salt string\r
-               $salt = substr($sha1, 0, $CONFIG['salt_length']);\r
-               //* DEBUG: */ echo $salt." (".strlen($salt).")<BR>";\r
-       }\r
-        else\r
-       {\r
-               $salt = substr($salt, 0, $CONFIG['salt_length']);\r
-       }\r
-\r
-       // Return hash\r
-       return $salt . sha1($salt . $plainText);\r
-}\r
-//\r
-function scrambleString($str) {\r
-       global $CONFIG;\r
-\r
-       // Init\r
-       $scrambled = "";\r
-\r
-       // Final check, in case of failture it will return unscrambled string\r
-       if (strlen($str) > 40) {\r
-               // The string is to long\r
-               return $str;\r
-       } elseif (strlen($str) == 40) {\r
-               // From database\r
-               $scrambleNums = explode(":", $CONFIG['pass_scramble']);\r
-       } else {\r
-               // Generate new numbers\r
-               $scrambleNums = explode(":", genScrambleString(strlen($str)));\r
-       }\r
-\r
-       // Scramble string here\r
-       //* DEBUG: */ echo "***Original=".$str."***<BR>";\r
-       for ($idx = 0; $idx < strlen($str); $idx++) {\r
-               // Get char on scrambled position\r
-               $char = substr($str, $scrambleNums[$idx], 1);\r
-\r
-               // Add it to final output string\r
-               $scrambled .= $char;\r
-       }\r
-\r
-       // Return scrambled string\r
-       //* DEBUG: */ echo "***Scrambled=".$scrambled."***<BR>";\r
-       return $scrambled;\r
-}\r
-//\r
-function descrambleString($str)\r
-{\r
-       global $CONFIG;\r
-       // Scramble only 40 chars long strings\r
-       if (strlen($str) != 40) return $str;\r
-\r
-       // Load numbers from config\r
-       $scrambleNums = explode(":", $CONFIG['pass_scramble']);\r
-\r
-       // Validate numbers\r
-       if (count($scrambleNums) != 40) return $str;\r
-\r
-       // Begin descrambling\r
-       $orig = str_repeat(" ", 40);\r
-       //* DEBUG: */ echo "+++Scrambled=".$str."+++<BR>";\r
-       for ($idx = 0; $idx < 40; $idx++)\r
-       {\r
-               $char = substr($str, $idx, 1);\r
-               $orig = substr_replace($orig, $char, $scrambleNums[$idx], 1);\r
-       }\r
-\r
-       // Return scrambled string\r
-       //* DEBUG: */ echo "+++Original=".$orig."+++<BR>";\r
-       return $orig;\r
-}\r
-//\r
-function genScrambleString($len) {\r
-       // Prepare randomizer and array for the numbers\r
-       mt_srand((double) microtime() * 1000000);\r
-       $scrambleNumbers = array();\r
-\r
-       // First we need to setup randomized numbers from 0 to 31\r
-       for ($idx = 0; $idx < $len; $idx++) {\r
-               // Generate number\r
-               $rand = mt_rand(0, ($len -1));\r
-\r
-               // Check for it by creating more numbers\r
-               while (array_key_exists($rand, $scrambleNumbers)) {\r
-                       $rand = mt_rand(0, ($len -1));\r
-               }\r
-\r
-               // Add number\r
-               $scrambleNumbers[$rand] = $rand;\r
-       }\r
-\r
-       // So let's create the string for storing it in database\r
-       $scrambleString = implode(":", $scrambleNumbers);\r
-       return $scrambleString;\r
-}\r
-// Append data like session ID referral ID to the given URL which would\r
-// normally be stored in cookies\r
-function ADD_URL_DATA($URL)\r
-{\r
-       global $_GET, $CONFIG;\r
-       $ADD = "";\r
-       if ((!defined('__COOKIES')) || ((!__COOKIES))) {\r
-               // Cookies are not accepted\r
-               if ((!empty($_GET['refid'])) && (strpos($URL, "refid=") == 0)) {\r
-                       // Cookie found in URL\r
-                       $ADD .= "&refid=".bigintval($_GET['refid']);\r
-               } elseif ((GET_EXT_VERSION("sql_patches") != "") && ($CONFIG['def_refid'] > 0)) {\r
-                       // Not found! So let's set default here\r
-                       $ADD .= "&refid=".$CONFIG['def_refid'];\r
-               }\r
-\r
-               // Add session ID\r
-               if ((!empty($_GET['PHPSESSID'])) && (strpos($URL, "PHPSESSID=") == 0)) {\r
-                       // Add session from URL\r
-                       $ADD .= "&PHPSESSID=".SQL_ESCAPE(strip_tags($_GET['PHPSESSID']));\r
-               } else {\r
-                       // Add current session\r
-                       $ADD .= "&PHPSESSID=".session_id();\r
-               }\r
-       }\r
-\r
-       // Add all together and return it\r
-       return $URL.$ADD;\r
-}\r
-//\r
-function generatePassString($passHash) {\r
-       global $CONFIG;\r
-       $ret = "*FAILED*";\r
-\r
-       // Is a secret key and master salt already initialized?\r
-       if ((!empty($CONFIG['secret_key'])) && (!empty($CONFIG['master_salt']))) {\r
-               // Only calculate when the secret key is generated\r
-               $newHash = ""; $start = 9;\r
-               for ($idx = 0; $idx < 10; $idx++) {\r
-                       $part1 = hexdec(substr($passHash, $start, 4));\r
-                       $part2 = hexdec(substr($CONFIG['secret_key'], $start, 4));\r
-                       $mod = dechex($idx);\r
-                       if ($part1 > $part2) {\r
-                               $mod = dechex(sqrt(($part1 - $part2) * _PRIME / pi()));\r
-                       } elseif ($part2 > $part1) {\r
-                               $mod = dechex(sqrt(($part2 - $part1) * _PRIME / pi()));\r
-                       }\r
-                       $mod = substr(round($mod), 0, 4);\r
-                       $mod = str_repeat('0', 4-strlen($mod)).$mod;\r
-                       //* DEBUG: */ echo "*".$start."=".$mod."*<br>";\r
-                       $start += 4;\r
-                       $newHash .= $mod;\r
-               }\r
-               //* DEBUG: */ die($passHash."<br>".$newHash." (".strlen($newHash).")");\r
-               $ret = generateHash($newHash, $CONFIG['master_salt']);\r
-       }\r
-\r
-       // Return result\r
-       return $ret;\r
-}\r
-// Fix "deleted" cookies\r
-function FIX_DELETED_COOKIES ($cookies) {\r
-       // Is this an array with entries?\r
-       if ((is_array($cookies)) && (count($cookies) > 0)) {\r
-               // Then check all cookies if they are marked as deleted!\r
-               foreach ($cookies as $cookieName) {\r
-                       // Is the cookie set to "deleted"?\r
-                       if ((isset($_COOKIE[$cookieName])) && ($_COOKIE[$cookieName] == "deleted")) {\r
-                               unset($_COOKIE[$cookieName]);\r
-                       }\r
-               }\r
-       }\r
-}\r
-// Output error messages in a fasioned way and die...\r
-function mxchange_die ($msg) {\r
-       global $FOOTER;\r
-\r
-       // Load the message template\r
-       LOAD_TEMPLATE("admin_settings_saved", false, $msg);\r
-\r
-       // Load footer\r
-       include(PATH."inc/footer.php");\r
-\r
-       // Exit explicitly\r
-       exit;\r
-}\r
-//\r
-//////////////////////////////////////////////\r
-//                                          //\r
-// AUTOMATICALLY RE-GNERATED FUNCTIONS ONLY //\r
-//                                          //\r
-//////////////////////////////////////////////\r
-//\r
-if (!function_exists('html_entity_decode'))\r
-{\r
-       // Taken from documentation on www.php.net\r
-       function html_entity_decode($string)\r
-       {\r
-               $trans_tbl = get_html_translation_table(HTML_ENTITIES);\r
-               $trans_tbl = array_flip($trans_tbl);\r
-               return strtr($string, $trans_tbl);\r
-       }\r
-}\r
-//\r
-?>\r
+function GEN_PASS($LEN = 0) {
+       global $CONFIG;
+       if ($LEN == 0) $LEN = $CONFIG['pass_len'];
+
+       // Initialize array with all allowed chars
+       $ABC = explode(",", "a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,0,1,2,3,4,5,6,7,8,9,-,+,_,/");
+
+       // Initialize randomizer
+       mt_srand((double) microtime() * 1000000);
+
+       // Start creating password
+       $PASS = "";
+       for ($i = 0; $i < $LEN; $i++) {
+               $PASS .= $ABC[mt_rand(0, sizeof($ABC) -1)];
+       }
+
+       // When the size is below 40 we can also add additional security by scrambling it
+       if (strlen($PASS) <= 40) {
+               // Also scramble the password
+               $PASS = scrambleString($PASS);
+       }
+
+       // Return the password
+       return $PASS;
+}
+//
+function MAKE_DATETIME($time, $mode="0")
+{
+       if ($time == 0) {
+               // Never happend
+               return NEVER_HAPPENED;
+       } else {
+               // Filter out numbers
+               $time = bigintval($time);
+       }
+
+       switch (GET_LANGUAGE())
+       {
+       case "de": // German date / time format
+               switch ($mode)
+               {
+                       case "0": $ret = date("d.m.Y \u\m H:i \U\h\\r", $time); break;
+                       case "1": $ret = strtolower(date("d.m.Y - H:i", $time)); break;
+                       case "2": $ret = date("d.m.Y|H:i", $time); break;
+                       case "3": $ret = date("d.m.Y", $time); break;
+               }
+               break;
+
+       default:        // Default is the US date / time format!
+               switch ($mode)
+               {
+                       case "0": $ret = date("r", $time); break;
+                       case "1": $ret = date("Y-m-d - g:i A", $time); break;
+                       case "2": $ret = date("y-m-d|H:i", $time); break;
+                       case "3": $ret = date("y-m-d", $time); break;
+               }
+       }
+       return $ret;
+}
+//
+function TRANSLATE_COMMA($dotted, $cut=true)
+{
+       global $CONFIG;
+       // Default is 3 you can change this in admin area "Misc -> Misc Options"
+       if (empty($CONFIG['max_comma'])) $CONFIG['max_comma'] = "3";
+       if (!ereg("\.", $dotted)) $dotted .= ".".str_repeat("0", $CONFIG['max_comma']);
+       if ($cut)
+       {
+               // Remove trailing zeros
+               $dot = str_replace(".", "x", $dotted);
+               while(substr($dot, -1, 1) == "0")
+               {
+                       $dot = substr($dot, 0, -1);
+               }
+               if (substr($dot, -1, 1) == "x")
+               {
+                       // Last char is the 'x'
+                       $dotted = substr($dot, 0, -1);
+               }
+                else
+               {
+                       // Last char is a number
+                       $dotted = str_replace("x", ".", $dot);
+               }
+       }
+       switch (GET_LANGUAGE())
+       {
+       case "de":
+               $pos = strpos($dotted, ".");
+               if ($pos > 0)
+               {
+                       if ($cut)
+                       {
+                               // Cut x numbers behind comma
+                               $dotted = str_replace(".", ",", substr($dotted, 0, ($pos + $CONFIG['max_comma'] + 1)));
+                       }
+                        else
+                       {
+                               // Replace comma with dot
+                               $dotted = str_replace(".", ",", $dotted);
+                       }
+               }
+                elseif (!$cut)
+               {
+                       if (empty($pos))
+                       {
+                               $dotted = "0,".str_repeat("0", $CONFIG['max_comma']);
+                       }
+                        else
+                       {
+                               $dotted .= ",".str_repeat("0", $CONFIG['max_comma']);
+                       }
+               }
+               break;
+
+       default:
+               if (!$cut)
+               {
+                       if ($pos > 0)
+                       {
+                               $dotted = substr($dotted, 0, ($pos + $CONFIG['max_comma'] + 1));
+                       }
+                        else
+                       {
+                               $dotted .= ".".str_repeat("0", $CONFIG['max_comma']);
+                       }
+               }
+               break;
+       }
+       return $dotted;
+}
+//
+function DEREFERER($URL)
+{
+       $URL = URL."/modules.php?module=loader&amp;url=".urlencode(base64_encode(COMPILE_CODE($URL)));
+       return $URL;
+}
+//
+function TRANSLATE_SEX($sex)
+{
+       switch ($sex)
+       {
+               case "M": $ret = SEX_M; break;
+               case "F": $ret = SEX_F; break;
+               case "C": $ret = SEX_C; break;
+               default : $ret = $sex; break;
+       }
+       return $ret;
+}
+//
+function GET_POOL_TYPE($PT)
+{
+       switch ($PT)
+       {
+               case "TEMP"   : $ret = POOL_TEMP;    break;
+               case "SEND"   : $ret = POOL_SEND;    break;
+               case "NEW"    : $ret = POOL_NEW;     break;
+               case "ADMIN"  : $ret = POOL_ADMIN;   break;
+               case "ACTIVE" : $ret = POOL_ACTIVE;  break;
+               case "DELETED": $ret = POOL_DELETED; break;
+               default       : $ret = POOL_UNKNOWN." (".$PT.")"; break;
+       }
+       return $ret;
+}
+//
+function FRAMETESTER($URL)
+{
+       global $_SERVER;
+       $URL = URL."/modules.php?module=frametester&amp;url=".urlencode(base64_encode(COMPILE_CODE($URL)));
+       return $URL;
+}
+//
+function SELECTION_COUNT($array)
+{
+       $ret = "0";
+       if (is_array($array))
+       {
+               foreach ($array as $key=>$sel)
+               {
+                       if (!empty($sel)) $ret++;
+               }
+       }
+       return $ret;
+}
+//
+function IMG_CODE ($code, $TYPE, $DATA, $uid)
+{
+       return "<IMG border=\"0\" alt=\"Code\" src=\"".URL."/mailid_top.php?uid=".$uid."&amp;".$TYPE."=".$DATA."&amp;mode=img&amp;code=".$code."\">";
+}
+//
+function TRANSLATE_STATUS($status)
+{
+       switch ($status)
+       {
+       case "UNCONFIRMED":
+               $ret = ACCOUNT_UNCONFIRMED;
+               break;
+
+       case "CONFIRMED":
+               $ret = ACCOUNT_CONFIRMED;
+               break;
+
+       case "LOCKED":
+               $ret = ACCOUNT_LOCKED;
+               break;
+
+       default:
+               $ret = UNKNOWN_STATUS_1.$status.UNKNOWN_STATUS_2;
+               break;
+       }
+       return $ret;
+}
+//
+function GET_LANGUAGE()
+{
+       global $_COOKIE, $_GET;
+
+       if (!empty($_GET['mx_lang']))
+       {
+               // Accept only first 2 chars
+               $lang = substr($_GET['mx_lang'], 0, 2);
+       }
+        else
+       {
+               // Do nothing
+               $lang = "";
+       }
+
+       // Set default return value to default language from config
+       $ret = DEFAULT_LANG;
+
+       // Check GET variable and cookie
+       if (!empty($lang))
+       {
+               // Check if main language file does exist
+               if (file_exists(PATH."inc/language/".$lang.".php"))
+               {
+                       // Okay found, so let's update cookies
+                       SET_LANGUAGE($lang);
+               }
+       }
+        elseif (!empty($_COOKIE['mx_lang']))
+       {
+               // Return stored value from cookie
+               $ret = $_COOKIE['mx_lang'];
+       }
+       return $ret;
+}
+//
+function SET_LANGUAGE($lang)
+{
+       global $CONFIG;
+
+       // Accept only first 2 chars!
+       $lang = substr(SQL_ESCAPE(strip_tags($lang)), 0, 2);
+
+       // Set cookie
+       @setcookie("mx_lang", $lang, (time() + $CONFIG['online_timeout']), COOKIE_PATH);
+
+       // Set array
+       $_COOKIE['mx_lang'] = $lang;
+}
+//
+function LOAD_EMAIL_TEMPLATE($template, $content="", $UID="0")
+{
+       global $DATA, $CONFIG, $REPLACER;
+
+       // Keept for backward-compatiblity (please replace these variables against our new {--CONST--} syntax!)
+       $MAIN_TITLE = MAIN_TITLE; $URL = URL; $WEBMASTER = WEBMASTER;
+       $surname = ""; $family = ""; $nick = ""; $sex = "N";
+
+       // Prepare IP number and User Agent
+       $REMOTE_ADDR = getenv('REMOTE_ADDR');
+       $HTTP_USER_AGENT  = getenv('HTTP_USER_AGENT');
+
+       $ADMIN = MAIN_TITLE;
+       if (!empty($_COOKIE['admin_login']))
+       {
+               // Load Admin data
+               $result = SQL_QUERY_ESC("SELECT email FROM "._MYSQL_PREFIX."_admins WHERE login='%s' LIMIT 1",
+                       array(SQL_ESCAPE($_COOKIE['admin_login'])), __FILE__, __LINE__);
+               list($ADMIN) = SQL_FETCHROW($result);
+               SQL_FREERESULT($result);
+       }
+
+       // Expiration in a nice output format
+       if ($CONFIG['auto_purge'] == 0)
+       {
+               // Will never expire!
+               $EXPIRATION = MAIL_WILL_NEVER_EXPIRE;
+       }
+        elseif (function_exists('CREATE_FANCY_TIME'))
+       {
+               // Create nice date string
+               $EXPIRATION = CREATE_FANCY_TIME($CONFIG['auto_purge']);
+       }
+        else
+       {
+               // Display days only
+               $EXPIRATION = round($CONFIG['auto_purge']/60/60/24)." "._DAYS;
+       }
+       switch ($template)
+       {
+       case "bonus-mail": // Load data for the bonus mail
+               $BONUSID    = $DATA[0];
+               $content    = $DATA[2];
+               $POINTS     = TRANSLATE_COMMA($DATA[4]);
+               $TIME       = $DATA[5];
+               $TARGET_URL = $DATA[8];
+               $CATEGORY   = GET_CATEGORY($DATA[9]);
+               $DATA[10]   = $UID;
+
+               // Replace variables
+               foreach ($REPLACER as $key=>$value)
+               {
+                       if (isset($DATA[$key])) $content = str_replace($value, $DATA[$key], $content);
+               }
+               break;
+
+       case "order-admin":
+       case "order-member":
+               $BLOCKS     = $CONFIG['max_send'];
+               $SUBJECT    = $DATA[0];
+               $content    = $DATA[1];
+               $PAYMENT    = GET_PAYMENT($DATA[3]);
+               $TARGET_URL = $DATA[5];
+               $CATEGORY   = GET_CATEGORY($DATA[6]);
+               break;
+
+       case "order-reject":
+       case "order-deleted":
+       case "order-accept":
+               $TARGET_URL = $DATA[0];
+               $URL        = $DATA[0];
+               $SUBJECT    = $DATA[1];
+               break;
+
+       case "new-pass":
+               $PASS       = $DATA[0];
+               $REMOTE     = $DATA[1];
+               break;
+
+       case "confirm-member":
+               $POINTS     = $CONFIG['points_register'];
+               break;
+
+       case "confirm-referral":
+               $PERCENT    = $DATA[0];
+               $LEVEL      = $DATA[1];
+               $POINTS     = $DATA[2];
+               $REFID      = $DATA[3];
+               break;
+
+       case "normal-mail":
+               $SEND_UID   = $DATA[1];
+               $CATEGORY   = GET_CATEGORY($DATA[9]);
+               $TIME       = GET_PAY_POINTS($DATA[5], "time");
+               $TARGET_URL = $DATA[7];
+               $POINTS     = TRANSLATE_COMMA(GET_PAY_POINTS($DATA[5], "payment"));
+               // Warning! This ID has changed from 10 to 11!
+               $MAILID     = $DATA[11];
+
+               // Replace variables
+               foreach ($REPLACER as $key=>$value)
+               {
+                       if (isset($DATA[$key])) $content = str_replace($value, $DATA[$key], $content);
+               }
+               break;
+
+       case "done-member":
+       case "done-admin":
+               $SEND_UID   = $DATA[1];
+               $CATEGORY   = GET_CATEGORY($DATA[9]);
+               $TARGET_URL = $DATA[7];
+               break;
+
+       case "back-admin":
+       case "back-member":
+               $POINTS     = TRANSLATE_COMMA($DATA[10]);
+               break;
+
+       case "add-points":
+               $POINTS = $_POST['points'];
+               break;
+
+       case "guest_request_confirm":
+               $HASH       = $DATA[2];
+               break;
+       }
+
+       // Load user's data
+       if ($UID > 0)
+       {
+               if (EXT_IS_ACTIVE("nickname"))
+               {
+                       // Load nickname
+                       $result = SQL_QUERY_ESC("SELECT surname, family, sex, email, nickname FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1",
+                        array(bigintval($UID)), __FILE__, __LINE__);
+                       list($surname, $family, $sex, $email, $nick) = SQL_FETCHROW($result);
+                       SQL_FREERESULT($result);
+               }
+                else
+               {
+                       // Load normal data
+                       $result = SQL_QUERY_ESC("SELECT surname, family, sex, email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1",
+                        array(bigintval($UID)), __FILE__, __LINE__);
+                       list($surname, $family, $sex, $email) = SQL_FETCHROW($result);
+                       SQL_FREERESULT($result);
+                       $nick = "---";
+               }
+       }
+        else
+       {
+               // Neutral sex and email address is default
+               $sex = "N";
+               $email = WEBMASTER;
+       }
+
+       // Translate M to male or F to female
+       $salut = TRANSLATE_SEX($sex);
+
+       // Store email for some functions in global data array
+       $DATA['email'] = $email;
+
+       // Base directory
+       $BASE = PATH."templates/".GET_LANGUAGE()."/emails/";
+
+       // Check for admin/guest/member templates
+       if (strpos($template, "admin_") > -1)
+       {
+               // Admin template found
+               $file = $BASE."admin/".$template.".tpl";
+       }
+        elseif (strpos($template, "guest_") > -1)
+       {
+               // Guest template found
+               $file = $BASE."guest/".$template.".tpl";
+       }
+        elseif (strpos($template, "member_") > -1)
+       {
+               // Member template found
+               $file = $BASE."member/".$template.".tpl";
+       }
+        else
+       {
+               // Test for extension
+               $test = substr($template, 0, strpos($template, "_"));
+               if (EXT_IS_ACTIVE($test))
+               {
+                       // Set extra path to extension's name
+                       $file = $BASE.$test."/".$template.".tpl";
+               }
+                else
+               {
+                       // No special filename
+                       $file = $BASE.$template.".tpl";
+               }
+       }
+
+       // Does the special template exists?
+       if (!@file_exists($file))
+       {
+               // Reset to default template
+               $file = $BASE.$template.".tpl";
+       }
+
+       // Now does the final template exists?
+       if ((@file_exists($file)) && (is_readable($file)))
+       {
+               // The local file does exists so we load it. :)
+               $tmpl_file = @implode("", @file($file));
+               $tmpl_file = addslashes($tmpl_file);
+
+               // Compile code
+               $tmpl_file = COMPILE_CODE($tmpl_file);
+
+               // Run code
+               $tmpl_file = "\$content=\"".$tmpl_file."\";";
+               eval($tmpl_file);
+
+               // Replace HTML confirm chars
+               $content = html_entity_decode($content);
+       }
+        elseif (!empty($template))
+       {
+               // Template file not found!
+               $content = TEMPLATE_404.": ".$template."<BR>
+".TEMPLATE_CONTENT."
+<PRE>".print_r($content, true)."</PRE>
+".TEMPLATE_DATA."
+<PRE>".print_r($DATA, true)."</PRE>
+<BR><BR>";
+
+               // Debug mode not active? Then remove the HTML tags
+               if (!DEBUG_MODE) $content = strip_tags($content);
+       }
+        else
+       {
+               // No template name supplied!
+               $content = NO_TEMPLATE_SUPPLIED;
+       }
+       return COMPILE_CODE($content);
+}
+//
+function MAKE_TIME($H, $M, $S, $stamp)
+{
+       // Extract day, month and year from given timestamp
+       $DAY   = date("d", $stamp);
+       $MONTH = date("m", $stamp);
+       $YEAR  = date("Y", $stamp);
+
+       // Create timestamp for wished time which depends on extracted date
+       return mktime($H, $M, $S, $MONTH, $DAY, $YEAR);
+}
+//
+function LOAD_URL($URL, $addUrlData=true) {
+       // Compile out URI codes
+       $URL = COMPILE_CODE($URL);
+
+       // Add some data to URL if cookies are not accepted
+       if (((!defined('__COOKIES')) || (!__COOKIES)) && ($addUrlData)) $URL = ADD_URL_DATA($URL);
+
+       // Probe for bot from search engine
+       if ((eregi("spider", getenv('HTTP_USER_AGENT'))) || (eregi("bot", getenv('HTTP_USER_AGENT'))) || (eregi("spider", getenv('HTTP_USER_AGENT')))) {
+               // Search engine bot detected so let's rewrite many chars for the link
+               $URL = htmlentities(strip_tags($URL), ENT_QUOTES);
+
+               // Output new location link as anchor
+               OUTPUT_HTML ("<A href=\"".$URL."\">".$URL."</A>\n");
+       } elseif (!headers_sent()) {
+               // Load URL when headers are not sent
+               @header ("Location: ".str_replace("&amp;", "&", $URL));
+       } else {
+               // Output error message
+               include(PATH."inc/header.php");
+               OUTPUT_HTML (LOAD_URL_ERROR_1.$URL.LOAD_URL_ERROR_2);
+               include(PATH."inc/footer.php");
+       }
+       exit();
+}
+//
+function COMPILE_CODE($code, $simple = false, $constants = true, $full = true) {
+       global $SEC_CHARS, $URL_CHARS;
+       $ARRAY = $SEC_CHARS;
+
+       // Select smaller set of chars to replace when we e.g. want to compile URLs
+       if (!$full) $ARRAY = $URL_CHARS;
+
+       // Compile constants
+       if ($constants) {
+               // BEFORE 0.2.1 : Language and data constants
+               // WITH 0.2.1+  : Only language constants
+               $code = str_replace("{--", '".', str_replace("--}", '."', $code));
+
+               // BEFORE 0.2.1 : Not used
+               // WITH 0.2.1+  : Data constants
+               $code = str_replace("{!", '".', str_replace("!}", '."', $code));
+       }
+
+       // Compile QUOT and other non-HTML codes
+       foreach ($ARRAY['to'] as $k => $to) {
+               // Do the reversed thing as in inc/libs/security_functions.php
+               $code = str_replace($to, $ARRAY['from'][$k], $code);
+       }
+
+       // But shall I keep simple quotes for later use?
+       if ($simple) $code = str_replace("\'", "{QUOT}", $code);
+
+       // Find $content[bla][blub] entries
+       @preg_match_all('/\$(content|DATA)((\[([a-zA-Z0-9-_]+)\])*)/', $code, $matches);
+
+       // Are some matches found?
+       if ((count($matches) > 0) && (count($matches[0]) > 0)) {
+               // Replace all matches
+               $matchesFound = array();
+               foreach ($matches[0] as $key=>$match) {
+                       // Avoid replacing matches multiple times
+                       if (!isset($matchesFound[$match])) {
+                               // Not yet replaced!
+                               $code = str_replace($match, "\".".$match.".\"", $code);
+                               $matchesFound[$match] = 1;
+                       }
+
+                       // Take all string elements
+                       if (("".bigintval($matches[4][$key])."" != $matches[4][$key]) && (!isset($matchesFound[$key."_".$matches[4][$key]]))) {
+                               // Replace it in the code
+                               $code = str_replace("[".$matches[4][$key]."]", "['".$matches[4][$key]."']", $code);
+                               $matchesFound[$key."_".$matches[4][$key]] = 1;
+                       }
+               }
+       }
+
+       // Return compiled code
+       return $code;
+}
+//
+/************************************************************************
+ *                                                                      *
+ * Gaenderter Sortier-Algorythmus, $array wird nach dem Array (!)       *
+ * $a_sort sortiert:                                                    *
+ *                                                                      *
+ * $array - Das 3-dimensionale Array, das paralell sortiert werden soll *
+ * $a_sort - Array, das die Sortiereihenfolge der ersten Elementeben    *
+ * $primary_key - Prim.rschl.ssel aus $a_sort, nach dem sortiert wird   *
+ * $order - Sortiereihenfolge: -1 = A-Z, 0 = keine, 1 = Z-A             *
+ * $nums - true = Als Zahlen sortieren, false = Als Zeichen sortieren   *
+ *                                                                      *
+ * $a_sort muss Elemente enthalten, deren Wert Schluessel von $array    *
+ * sind... Klingt kompliziert, suchen Sie mal mein Beispiel, dann sehen *
+ * Sie, dass es doch nicht so schwer ist! :-)                           *
+ *                                                                      *
+ ************************************************************************/
+function array_pk_sort(&$array, $a_sort, $primary_key = 0, $order = -1, $nums = false)
+{
+       $dummy = $array;
+       while ($primary_key < count($a_sort))
+       {
+               foreach ($dummy[$a_sort[$primary_key]] as $key=>$value)
+               {
+                       foreach ($dummy[$a_sort[$primary_key]] as $key2=>$value2)
+                       {
+                               $match = false;
+                               if (!$nums)
+                               {
+                                       // Sort byte-by-byte (also numbers will be interpreted as chars! E.g.: "9" > "10")
+                                       if (($key != $key2) && (strcmp(strtolower($dummy[$a_sort[$primary_key]][$key]), strtolower($dummy[$a_sort[$primary_key]][$key2])) == $order)) $match = true;
+                               }
+                                elseif ($key != $key2)
+                               {
+                                       // Sort numbers (E.g.: 9 < 10)
+                                       if (($dummy[$a_sort[$primary_key]][$key] < $dummy[$a_sort[$primary_key]][$key2]) && ($order == -1)) $match = true;
+                                       if (($dummy[$a_sort[$primary_key]][$key] > $dummy[$a_sort[$primary_key]][$key2]) && ($order == 1))  $match = true;
+                               }
+                               if ($match)
+                               {
+                                       // We have found two different values, so let's sort whole array
+                                       foreach ($dummy as $sort_key=>$sort_val)
+                                       {
+                                               $t                       = $dummy[$sort_key][$key];
+                                               $dummy[$sort_key][$key]  = $dummy[$sort_key][$key2];
+                                               $dummy[$sort_key][$key2] = $t;
+                                               unset($t);
+                                       }
+                               }
+                       }
+               }
+
+               // Count one up
+               $primary_key++;
+       }
+
+       // Write back sorted array
+       $array = $dummy;
+}
+//
+function ADD_SELECTION($TYPE, $DEFAULT, $PREFIX="", $id="0")
+{
+       global $MONTH_DESCR; $OUT = "";
+       if ($TYPE == "yn")
+       {
+               // This is a yes/no selection only!
+               if ($id > 0) $PREFIX .= "[".$id."]";
+               $OUT .= "    <SELECT name=\"".$PREFIX."\" class=\"register_select\" size=\"1\">\n";
+       }
+        else
+       {
+               // Begin with regular selection box here
+               if (!empty($PREFIX)) $PREFIX .= "_";
+               $TYPE2 = $TYPE;
+               if ($id > 0) $TYPE2 .= "[".$id."]";
+               $OUT .= "    <SELECT name=\"".strtolower($PREFIX.$TYPE2)."\" class=\"register_select\" size=\"1\">\n";
+       }
+       switch ($TYPE)
+       {
+       case "day": // Day
+               for ($idx = 1; $idx < 32; $idx++)
+               {
+                       $OUT .= "      <OPTION value=\"".$idx."\"";
+                       if ($DEFAULT == $idx) $OUT .= " selected=\"selected\"";
+                       $OUT .= ">".$idx."</OPTION>\n";
+               }
+               break;
+
+       case "month": // Month
+               foreach ($MONTH_DESCR as $month=>$descr)
+               {
+                       $OUT .= "      <OPTION value=\"".$month."\"";
+                       if ($DEFAULT == $month) $OUT .= " selected=\"selected\"";
+                       $OUT .= ">".$descr."</OPTION>\n";
+               }
+               break;
+
+       case "year": // Year
+               // Get current year
+               $YEAR = date("Y", time());
+
+               // Check if the default value is larger than minimum and bigger than actual year
+               if (($DEFAULT > 1930) && ($DEFAULT >= $YEAR))
+               {
+                       for ($idx = $YEAR; $idx < ($YEAR + 11); $idx++)
+                       {
+                               $OUT .= "      <OPTION value=\"".$idx."\"";
+                               if ($DEFAULT == $idx) $OUT .= " selected=\"selected\"";
+                               $OUT .= ">".$idx."</OPTION>\n";
+                       }
+               }
+                elseif ($DEFAULT == -1)
+               {
+                       // Current year minus 1
+                       for ($idx = 2003; $idx <= ($YEAR + 1); $idx++)
+                       {
+                               $OUT .= "      <OPTION value=\"".$idx."\">".$idx."</OPTION>\n";
+                       }
+               }
+                else
+               {
+                       // Get current year and subtract 16 (for erotic content)
+                       $OUT .= "      <OPTION value=\"1929\">&lt;1930</OPTION>\n";
+                       $YEAR = date("Y", time()) - 16;
+                       for ($idx = 1930; $idx <= $YEAR; $idx++)
+                       {
+                               $OUT .= "      <OPTION value=\"".$idx."\"";
+                               if ($DEFAULT == $idx) $OUT .= " selected=\"selected\"";
+                               $OUT .= ">".$idx."</OPTION>\n";
+                       }
+               }
+               break;
+
+       case "sec":
+       case "min":
+               for ($idx = 0; $idx < 60; $idx+=5)
+               {
+                       if (strlen($idx) == 1) $idx = "0".$idx;
+                       $OUT .= "      <OPTION value=\"".$idx."\"";
+                       if ($DEFAULT == $idx) $OUT .= " selected=\"selected\"";
+                       $OUT .= ">".$idx."</OPTION>\n";
+               }
+               break;
+
+       case "hour":
+               for ($idx = 0; $idx < 24; $idx++)
+               {
+                       if (strlen($idx) == 1) $idx = "0".$idx;
+                       $OUT .= "      <OPTION value=\"".$idx."\"";
+                       if ($DEFAULT == $idx) $OUT .= " selected=\"selected\"";
+                       $OUT .= ">".$idx."</OPTION>\n";
+               }
+               break;
+
+       case "yn":
+               $OUT .= "      <OPTION value=\"Y\"";
+               if ($DEFAULT == "Y") $OUT .= " selected=\"selected\"";
+               $OUT .= ">".YES."</OPTION>
+      <OPTION value=\"N\"";
+               if ($DEFAULT == "N") $OUT .= " selected=\"selected\"";
+               $OUT .= ">".NO."</OPTION>\n";
+               break;
+       }
+       $OUT .= "    </SELECT>\n";
+       return $OUT;
+}
+//
+function TRANSLATE_YESNO($yn)
+{
+       switch ($yn)
+       {
+               case "Y": $yn = YES; break;
+               case "N": $yn = NO; break;
+               default : $yn = "??? (".$yn.")"; break;
+       }
+       return $yn;
+}
+//
+// Deprecated : $length
+// Optional   : $DATA
+//
+function GEN_RANDOM_CODE($length, $code, $uid, $DATA="")
+{
+       global $CONFIG;
+
+       // Build server string
+       $server = $_SERVER['PHP_SELF'].":".getenv('HTTP_USER_AGENT').":".getenv('SERVER_SOFTWARE').":".getenv('REMOTE_ADDR').":".":".filemtime(PATH."inc/databases.php");
+
+       // Build key string
+       $keys   = SITE_KEY.":".DATE_KEY.":".$CONFIG['secret_key'].":".$CONFIG['file_hash'].":".date("d-m-Y (l-F-T)", $CONFIG['patch_ctime']).":".$CONFIG['master_salt'];
+
+       // Build string from misc data
+       $data   = $code.":".$uid.":".$DATA;
+
+       // Add more additional data
+       if (isset($_COOKIE['u_hash']))         $data .= ":".$_COOKIE['u_hash'];
+       if (isset($GLOBALS['userid']))         $data .= ":".$GLOBALS['userid'];
+       if (isset($_COOKIE['lifetime']))       $data .= ":".$_COOKIE['lifetime'];
+       if (isset($_COOKIE['mxchange_theme'])) $data .= ":".$_COOKIE['mxchange_theme'];
+       if (isset($_COOKIE['mx_lang']))        $data .= ":".$_COOKIE['mx_lang'];
+       if (isset($GLOBALS['refid']))          $data .= ":".$GLOBALS['refid'];
+
+       // Calculate number for generating the code
+       $a = $code + _ADD - 1;
+
+       // Generate hash with master salt from modula of number with the prime number and other data
+       $saltedHash = generateHash(($a % _PRIME).":".$server.":".$keys.":".$data.":".date("d-m-Y (l-F-T)", time()).":".$a, $CONFIG['master_salt']);
+
+       // Create number from hash
+       $rcode = hexdec(substr($saltedHash, strlen($CONFIG['master_salt']), 9)) / abs(_MAX - $a + sqrt(_ADD)) / pi();
+
+       // At least 10 numbers shall be secure enought!
+       $len = $CONFIG['code_length'];
+       if ($len == 0) $len = 10;
+
+       // Cut off requested counts of number
+       $return = substr(str_replace('.', '', $rcode), 0, $len);
+
+       // Done building code
+       return $return;
+}
+// Does only allow numbers
+function bigintval($num)
+{
+       $ret = (int) preg_replace("/[^0123456789]/", "", $num);
+       return $ret;
+}
+// Insert the code in $img_code into jpeg or PNG image
+function GENERATE_IMAGE($img_code, $header=true)
+{
+       global $CONFIG;
+       if ((strlen($img_code) > 6) || (empty($img_code)) || ($CONFIG['code_length'] == 0))
+       {
+               // Stop execution of function here because of over-sized code length
+               return;
+       }
+        elseif (!$header)
+       {
+               // Return in an HTML code code
+               return "<IMG src=\"".URL."/img.php?code=".$img_code."\">\n";
+       }
+
+       switch ($CONFIG['img_type'])
+       {
+       case "jpg":
+               // Loads JPEG image
+               $img = PATH."/theme/".GET_CURR_THEME()."/images/code_bg.jpg";
+               if ((file_exists($img)) && (is_readable($img)))
+               {
+                       // Okay, load image and hide all errors
+                       $image = @imagecreatefromjpeg($img);
+               }
+                else
+               {
+                       // Exit function here
+                       return;
+               }
+               break;
+
+       case "png":
+               // Loads PNG image
+               $img = PATH."/theme/".GET_CURR_THEME()."/images/code_bg.png";
+               if ((file_exists($img)) && (is_readable($img)))
+               {
+                       // Okay, load image and hide all errors
+                       $image = @imagecreatefrompng($img);
+               }
+                else
+               {
+                       // Exit function here
+                       return;
+               }
+               break;
+       }
+
+       // Generate text color (red/green/blue; 0 = dark, 255 = bright)
+       $text_color = imagecolorallocate($image, 0, 0, 0);
+
+       // Insert code into image
+       imagestring($image, 5, 14, 2, $img_code, $text_color);
+
+       // Return to browser
+       header ("Content-Type: image/".$CONFIG['img_type']);
+
+       // Output image with matching image factory
+       switch ($CONFIG['img_type'])
+       {
+               case "jpg": imagejpeg($image); break;
+               case "png": imagepng($image);  break;
+       }
+
+       // Remove image from memory
+       imagedestroy($image);
+}
+function CREATE_TIME_SELECTIONS($timestamp, $prefix="", $display="", $align="center", $return_array=false)
+{
+       // Calculate 15-seconds timestamp (15-seconds-steps shall be fine ;) )
+       $timestamp = round($timestamp / 15) * 15;
+       // Do we have a leap year?
+       $SWITCH = 0;
+       $TEST = date("Y", time()) / 4;
+       $M1 = date("m", time());
+       $M2 = date("m", (time() + $timestamp));
+       // If so and if current time is before 02/29 and estimated time is after 02/29 then add 86400 seconds (one day)
+       if ((floor($TEST) == $TEST) && ($M1 == "02") && ($M2 > "02"))  $SWITCH = ONE_DAY;
+       // First of all years...
+       $Y = abs(floor($timestamp / (31536000 + $SWITCH)));
+       // Next months...
+       $M = abs(floor($timestamp / 2628000 - $Y * 12));
+       // Next weeks
+       $W = abs(floor($timestamp / 604800 - $Y * ((365 + $SWITCH / ONE_DAY) / 7) - ($M / 12 * (365 + $SWITCH / ONE_DAY) / 7)));
+       // Next days...
+       $D = abs(floor($timestamp / 86400 - $Y * (365 + $SWITCH / ONE_DAY) - ($M / 12 * (365 + $SWITCH / ONE_DAY)) - $W * 7));
+       // Next hours...
+       $h = abs(floor($timestamp / 3600 - $Y * (365 + $SWITCH / ONE_DAY) * 24 - ($M / 12 * (365 + $SWITCH / ONE_DAY) * 24) - $W * 7 * 24 - $D * 24));
+       // Next minutes..
+       $m = abs(floor($timestamp / 60 - $Y * (365 + $SWITCH / ONE_DAY) * 24 * 60 - ($M / 12 * (365 + $SWITCH / ONE_DAY) * 24 * 60) - $W * 7 * 24 * 60 - $D * 24 * 60 - $h * 60));
+       // And at last seconds...
+       $s = abs(floor($timestamp - $Y * (365 + $SWITCH / ONE_DAY) * 24 * 3600 - ($M / 12 * (365 + $SWITCH / ONE_DAY) * 24 * 3600) - $W * 7 * 24 * 3600 - $D * 24 * 3600 - $h * 3600 - $m * 60));
+       //
+       // Now we convert them in seconds...
+       //
+       if ($return_array)
+       {
+               // Just put all data in an array for later use
+               $OUT = array(
+                       'YEARS'   => $Y,
+                       'MONTHS'  => $M,
+                       'WEEKS'   => $W,
+                       'DAYS'    => $D,
+                       'HOURS'   => $h,
+                       'MINUTES' => $m,
+                       'SECONDS' => $s
+               );
+       }
+        else
+       {
+               // Generate table
+               $OUT  = "<DIV align=\"".$align."\">\n";
+               $OUT .= "<TABLE border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"admin_table dashed\">\n";
+               $OUT .= "<TR>\n";
+               if (ereg("Y", $display) || (empty($display)))
+               {
+                       $OUT .= "  <TD align=\"center\" class=\"admin_title bottom\"><STRONG class=\"tiny\">"._YEARS."</STRONG></TD>\n";
+               }
+               if (ereg("M", $display) || (empty($display)))
+               {
+                       $OUT .= "  <TD align=\"center\" class=\"admin_title bottom\"><STRONG class=\"tiny\">"._MONTHS."</STRONG></TD>\n";
+               }
+               if (ereg("W", $display) || (empty($display)))
+               {
+                       $OUT .= "  <TD align=\"center\" class=\"admin_title bottom\"><STRONG class=\"tiny\">"._WEEKS."</STRONG></TD>\n";
+               }
+               if (ereg("D", $display) || (empty($display)))
+               {
+                       $OUT .= "  <TD align=\"center\" class=\"admin_title bottom\"><STRONG class=\"tiny\">"._DAYS."</STRONG></TD>\n";
+               }
+               if (ereg("h", $display) || (empty($display)))
+               {
+                       $OUT .= "  <TD align=\"center\" class=\"admin_title bottom\"><STRONG class=\"tiny\">"._HOURS."</STRONG></TD>\n";
+               }
+               if (ereg("m", $display) || (empty($display)))
+               {
+                       $OUT .= "  <TD align=\"center\" class=\"admin_title bottom\"><STRONG class=\"tiny\">"._MINUTES."</STRONG></TD>\n";
+               }
+               if (ereg("s", $display) || (empty($display)))
+               {
+                       $OUT .= "  <TD align=\"center\" class=\"admin_title bottom\"><STRONG class=\"tiny\">".SECS."</STRONG></TD>\n";
+               }
+               $OUT .= "</TR>\n";
+               $OUT .= "<TR>\n";
+               if (ereg("Y", $display) || (empty($display)))
+               {
+                       // Generate year selection
+                       $OUT .= "  <TD align=\"center\"><SELECT class=\"mini_select\" name=\"".$prefix."_ye\" size=\"1\">\n";
+                       for ($idx = 0; $idx <= 10; $idx++)
+                       {
+                               $OUT .= "    <OPTION class=\"mini_select\" value=\"".$idx."\"";
+                               if ($idx == $Y) $OUT .= " selected default";
+                               $OUT .= ">".$idx."</OPTION>\n";
+                       }
+                       $OUT .= "  </SELECT></TD>\n";
+               }
+                else
+               {
+                       $OUT .= "<INPUT type=\"hidden\" name=\"".$prefix."_ye\" value=\"0\">\n";
+               }
+               if (ereg("M", $display) || (empty($display)))
+               {
+                       // Generate month selection
+                       $OUT .= "  <TD align=\"center\"><SELECT class=\"mini_select\" name=\"".$prefix."_mo\" size=\"1\">\n";
+                       for ($idx = 0; $idx <= 11; $idx++)
+                       {
+                                       $OUT .= "  <OPTION class=\"mini_select\" value=\"".$idx."\"";
+                               if ($idx == $M) $OUT .= " selected default";
+                               $OUT .= ">".$idx."</OPTION>\n";
+                       }
+                       $OUT .= "  </SELECT></TD>\n";
+               }
+                else
+               {
+                       $OUT .= "<INPUT type=\"hidden\" name=\"".$prefix."_mo\" value=\"0\">\n";
+               }
+               if (ereg("W", $display) || (empty($display)))
+               {
+                       // Generate week selection
+                       $OUT .= "  <TD align=\"center\"><SELECT class=\"mini_select\" name=\"".$prefix."_we\" size=\"1\">\n";
+                       for ($idx = 0; $idx <= 4; $idx++)
+                       {
+                               $OUT .= "  <OPTION class=\"mini_select\" value=\"".$idx."\"";
+                               if ($idx == $W) $OUT .= " selected default";
+                               $OUT .= ">".$idx."</OPTION>\n";
+                       }
+                       $OUT .= "  </SELECT></TD>\n";
+               }
+                else
+               {
+                       $OUT .= "<INPUT type=\"hidden\" name=\"".$prefix."_we\" value=\"0\">\n";
+               }
+               if (ereg("D", $display) || (empty($display)))
+               {
+                       // Generate day selection
+                       $OUT .= "  <TD align=\"center\"><SELECT class=\"mini_select\" name=\"".$prefix."_da\" size=\"1\">\n";
+                       for ($idx = 0; $idx <= 31; $idx++)
+                       {
+                               $OUT .= "  <OPTION class=\"mini_select\" value=\"".$idx."\"";
+                               if ($idx == $D) $OUT .= " selected default";
+                               $OUT .= ">".$idx."</OPTION>\n";
+                       }
+                       $OUT .= "  </SELECT></TD>\n";
+               }
+                else
+               {
+                       $OUT .= "<INPUT type=\"hidden\" name=\"".$prefix."_da\" value=\"0\">\n";
+               }
+               if (ereg("h", $display) || (empty($display)))
+               {
+                       // Generate hour selection
+                       $OUT .= "  <TD align=\"center\"><SELECT class=\"mini_select\" name=\"".$prefix."_ho\" size=\"1\">\n";
+                       for ($idx = 0; $idx <= 23; $idx++)
+                       {
+                               $OUT .= "  <OPTION class=\"mini_select\" value=\"".$idx."\"";
+                               if ($idx == $h) $OUT .= " selected default";
+                               $OUT .= ">".$idx."</OPTION>\n";
+                       }
+                       $OUT .= "  </SELECT></TD>\n";
+               }
+                else
+               {
+                       $OUT .= "<INPUT type=\"hidden\" name=\"".$prefix."_ho\" value=\"0\">\n";
+               }
+               if (ereg("m", $display) || (empty($display)))
+               {
+                       // Generate minute selection
+                       $OUT .= "  <TD align=\"center\"><SELECT class=\"mini_select\" name=\"".$prefix."_mi\" size=\"1\">\n";
+                       for ($idx = 0; $idx <= 59; $idx++)
+                       {
+                               $OUT .= "  <OPTION class=\"mini_select\" value=\"".$idx."\"";
+                               if ($idx == $m) $OUT .= " selected default";
+                               $OUT .= ">".$idx."</OPTION>\n";
+                       }
+                       $OUT .= "  </SELECT></TD>\n";
+               }
+                else
+               {
+                       $OUT .= "<INPUT type=\"hidden\" name=\"".$prefix."_mi\" value=\"0\">\n";
+               }
+               if (ereg("s", $display) || (empty($display)))
+               {
+                       // Generate second selection
+                       $OUT .= "  <TD align=\"center\"><SELECT class=\"mini_select\" name=\"".$prefix."_se\" size=\"1\">\n";
+                       for ($idx = 0; $idx <= 45; $idx+=15)
+                       {
+                               $OUT .= "  <OPTION class=\"mini_select\" value=\"".$idx."\"";
+                               if ($idx == $s) $OUT .= " selected default";
+                               $OUT .= ">".$idx."</OPTION>\n";
+                       }
+                       $OUT .= "  </SELECT></TD>\n";
+               }
+                else
+               {
+                       $OUT .= "<INPUT type=\"hidden\" name=\"".$prefix."_se\" value=\"0\">\n";
+               }
+               $OUT .= "</TR>\n";
+               $OUT .= "</TABLE>\n";
+               $OUT .= "</DIV>\n";
+               // Return generated HTML code
+       }
+       return $OUT;
+}
+//
+function CREATE_TIMESTAMP_FROM_SELECTIONS($prefix, $POST) {
+       $ret = "0";
+       // Do we have a leap year?
+       $SWITCH = 0;
+       $TEST = date("Y", time()) / 4;
+       $M1   = date("m", time());
+       // If so and if current time is before 02/29 and estimated time is after 02/29 then add 86400 seconds (one day)
+       if ((floor($TEST) == $TEST) && ($M1 == "02") && ($POST[$prefix."_mo"] > "02"))  $SWITCH = ONE_DAY;
+       // First add years...
+       $ret += $POST[$prefix."_ye"] * (31536000 + $SWITCH);
+       // Next months...
+       $ret += $POST[$prefix."_mo"] * 2628000;
+       // Next weeks
+       $ret += $POST[$prefix."_we"] * 604800;
+       // Next days...
+       $ret += $POST[$prefix."_da"] * 86400;
+       // Next hours...
+       $ret += $POST[$prefix."_ho"] * 3600;
+       // Next minutes..
+       $ret += $POST[$prefix."_mi"] * 60;
+       // And at last seconds...
+       $ret += $POST[$prefix."_se"];
+       // Return calculated value
+       return $ret;
+}
+// Sends out mail to all administrators
+function SEND_ADMIN_EMAILS_PRO($subj, $template, $content="", $UID="0") {
+       // Trim template name
+       $template = trim($template);
+
+       // Load email template
+       $msg = LOAD_EMAIL_TEMPLATE($template, $content, $UID);
+
+       if (GET_EXT_VERSION("admins") < "0.4.0") {
+               // Older version detected!
+               return SEND_ADMIN_EMAILS($subj, $msg);
+       }
+
+       // Check which admin shall receive this mail
+       $result = SQL_QUERY_ESC("SELECT DISTINCT admin_id FROM "._MYSQL_PREFIX."_admins_mails WHERE mail_template='%s' ORDER BY admin_id",
+        array($template), __FILE__, __LINE__);
+       if (SQL_NUMROWS($result) == 0) {
+               // Create new entry (to all admins)
+               $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_admins_mails (admin_id, mail_template) VALUES (0, '%s')",
+                array($template), __FILE__, __LINE__);
+       } else {
+               // Load admin IDs...
+               $aids = array();
+               while(list($aid) = SQL_FETCHROW($result)) {
+                       $aids[] = $aid;
+               }
+
+               // Free memory
+               SQL_FREERESULT($result);
+
+               // "implode" IDs and query string
+               $aid = implode(",", $aids);
+               if ($aid == "-1") {
+                       // Add line to userlog
+                       USERLOG_ADD_LINE($subj, $msg, $UID);
+                       return;
+               } elseif ($aid == "0") {
+                       // Select all email adresses
+                       $result = SQL_QUERY("SELECT email FROM "._MYSQL_PREFIX."_admins ORDER BY id", __FILE__, __LINE__);
+               } else {
+                       // If Admin-ID is not "to-all" select
+                       $result = SQL_QUERY_ESC("SELECT email FROM "._MYSQL_PREFIX."_admins WHERE id IN (%s) ORDER BY id", array($aid), __FILE__, __LINE__);
+               }
+       }
+
+       // Load email addresses and send away
+       while (list($email) = SQL_FETCHROW($result)) {
+               SEND_EMAIL($email, $subj, $msg);
+       }
+
+       // Free memory
+       SQL_FREERESULT($result);
+}
+//
+function CREATE_FANCY_TIME($stamp) {
+       // Get data array with years/months/weeks/days/...
+       $data = CREATE_TIME_SELECTIONS($stamp, "", "", "", true);
+       $ret = "";
+       foreach($data as $k=>$v) {
+               if ($v > 0) {
+                       // Value is greater than 0 "eval" data to return string
+                       $eval = "\$ret .= \", \".\$v.\" \"._".strtoupper($k).";";
+                       eval($eval);
+                       break;
+               }
+       }
+
+       // Remove first "comma,null" string
+       $ret = substr($ret, 2);
+       return $ret;
+}
+//
+function ADD_EMAIL_NAV($PAGES, $offset, $show_form, $colspan, $return=false) {
+       $SEP = ""; $TOP = "";
+       if (!$show_form) {
+               $TOP = " top2";
+               $SEP = "<TR><TD colspan=\"".$colspan."\" class=\"seperator\">&nbsp;</TD></TR>";
+       }
+
+       $NAV = "";
+       for ($page = 1; $page <= $PAGES; $page++) {
+               // Is the page currently selected or shall we generate a link to it?
+               if (($page == $_GET['page']) || ((empty($_GET['page'])) && ($page == "1"))) {
+                       // Is currently selected, so only highlight it
+                       $NAV .= "<STRONG>-";
+               } else {
+                       // Open anchor tag and add base URL
+                       $NAV .= "<A href=\"".URL."/modules.php?module=admin&amp;what=".$GLOBALS['what']."&amp;page=".$page."&amp;offset=".$offset;
+
+                       // Add userid when we shall show all mails from a single member
+                       if ((isset($_GET['u_id'])) && (bigintval($_GET['u_id']) > 0)) $NAV .= "&amp;u_id=".bigintval($_GET['u_id']);
+
+                       // Close open anchor tag
+                       $NAV .= "\">";
+               }
+               $NAV .= $page;
+               if (($page == $_GET['page']) || ((empty($_GET['page'])) && ($page == "1"))) {
+                       // Is currently selected, so only highlight it
+                       $NAV .= "-</STRONG>";
+               } else {
+                       // Close anchor tag
+                       $NAV .= "</A>";
+               }
+
+               // Add seperator if we have not yet reached total pages
+               if ($page < $PAGES) $NAV .= "&nbsp;|&nbsp;";
+       }
+
+       // Define constants only once
+       if (!defined('__NAV_OUTPUT')) {
+               define('__NAV_OUTPUT' , $NAV);
+               define('__NAV_COLSPAN', $colspan);
+               define('__NAV_TOP'    , $TOP);
+               define('__NAV_SEP'    , $SEP);
+       }
+
+       // Load navigation template
+       $OUT = LOAD_TEMPLATE("admin_email_nav_row", true);
+
+       if ($return) {
+               // Return generated HTML-Code
+               return $OUT;
+       } else {
+               // Output HTML-Code
+               OUTPUT_HTML($OUT);
+       }
+}
+
+//
+function MXCHANGE_OPEN($script) {
+       // Extract host name
+       $host = str_replace("http://", "", SERVER_URL);
+       if (ereg("/", $host)) $host = substr($host, 0, strpos($host, "/"));
+
+       // Generate relative URL
+       $script = substr(SERVER_URL, (strpos(SERVER_URL, $host) + strlen($host)))."/".basename($script);
+       if (substr($script, 0, 1) == "/") $script = substr($script, 1);
+
+       // Open connection
+       $fp = @fsockopen($host, 80, $errno, $errdesc, 30);
+       if (!$fp)
+       {
+               // Failed!
+               return array("", "", "");
+       }
+
+       // Generate request header
+       $request  = "GET /".trim($script)." HTTP/1.0\r\n";
+       $request .= "Host: ".$host."\r\n";
+       $request .= "Referer: ".URL."/admin.php\r\n";
+       $request .= "User-Agent: ".TITLE."/".FULL_VERSION."\r\n\r\n";
+
+       // Initialize array
+       $response = array();
+
+       // Write request
+       fputs($fp, $request);
+
+       // Read response
+       while(!feof($fp)) {
+               $response[] = fgets($fp, 1024);
+       }
+
+       // Close socket
+       fclose($fp);
+
+       // Was the request successfull?
+       if ((!ereg("200 OK", $response[0])) && (empty($response[0]))) {
+               // Not found / access forbidden
+               $response = array("", "", "");
+       }
+
+       // Return response
+       return $response;
+}
+// Taken from www.php.net eregi() user comments
+function VALIDATE_EMAIL($email) {
+       // Compile email
+       $email = COMPILE_CODE($email);
+
+       // Check first part of email address
+       $first = "[-a-z0-9!#$%&\'*+/=?^_<{|}~]+(\.[-a-zA-Z0-9!#$%&\'*+/=?^_<{|}~]+)*";
+
+       //  Check domain
+       $domain = "[a-z0-9-]+(\.[a-z0-9-]{2,5})+";
+
+       // Generate pattern
+       $regex = "^".$first."@".$domain."$";
+
+       // Return check result
+       return eregi($regex, $email);
+}
+// Function taken from user comments on www.php.net / function eregi()
+function VALIDATE_URL ($URL, $compile=true) {
+       // Trim URL a little
+       $URL = trim(urldecode($URL));
+       //* DEBUG: */ echo $URL."<BR>";
+
+       // Compile some chars out...
+       if ($compile) $URL = COMPILE_CODE($URL, false, false, false);
+       //* DEBUG: */ echo $URL."<BR>";
+
+       // Check for the extension filter
+       if (EXT_IS_ACTIVE("filter")) {
+               // Use the extension's filter set
+               return FILTER_VALIDATE_URL($URL, false);
+       }
+
+       // If not installed, perform a simple test. Just make it sure there is always a http:// or
+       // https:// in front of the URLs
+       return (((substr($URL, 0, 7) == "http://") || (substr($URL, 0, 8) == "https://")) && (strlen($URL) >= 12));
+}
+//
+function MEMBER_ACTION_LINKS($uid, $status="") {
+       // Define all main targets
+       $TARGETS = array("del_user", "edit_user", "lock_user", "add_points", "sub_points");
+
+       // Begin of navigation links
+       $eval = "\$OUT = \"[&nbsp;";
+
+       foreach ($TARGETS as $tar) {
+               $eval .= "<SPAN class=\\\"admin_user_link\\\"><A href=\\\"".URL."/modules.php?module=admin&amp;what=".$tar."&amp;u_id=".$uid."\\\" title=\\\"\".ADMIN_LINK_";
+               //* DEBUG: */ echo "*".$tar."/".$status."*<br />\n";
+               if (($tar == "lock_user") && ($status == "LOCKED")) {
+                       // Locked accounts shall be unlocked
+                       $eval .= "UNLOCK_USER";
+               } else {
+                       // All other status is fine
+                       $eval .= strtoupper($tar);
+               }
+               $eval .= "_TITLE.\"\\\">\".ADMIN_";
+               if (($tar == "lock_user") && ($status == "LOCKED")) {
+                       // Locked accounts shall be unlocked
+                       $eval .= "UNLOCK_USER";
+               } else {
+                       // All other status is fine
+                       $eval .= strtoupper($tar);
+               }
+               $eval .= ".\"</A></SPAN>&nbsp;|&nbsp;";
+       }
+
+       // Finish navigation link
+       $eval = substr($eval, 0, -7) . "]\";";
+       eval($eval);
+
+       // Return string
+       return $OUT;
+}
+// Function for backward-compatiblity
+function ADD_CATEGORY_TABLE ($MODE, $return=false) {
+       // Load it from the register extension
+       return REGISTER_ADD_CATEGORY_TABLE ($MODE, $return);
+}
+// Generate an email link
+function CREATE_EMAIL_LINK($email, $table="admins") {
+       // Default email link (INSECURE! Spammer can read this by harvester programs)
+       $EMAIL = "mailto:".$email;
+
+       // Check for several extensions
+       if ((EXT_IS_ACTIVE("admins")) && ($table == "admins")) {
+               // Create email link for contacting admin in guest area
+               $EMAIL = ADMINS_CREATE_EMAIL_LINK($email);
+       } elseif ((GET_EXT_VERSION("user") >= "0.3.3") && ($table == "user_data")) {
+               // Create email link for contacting a member within admin area (or later in other areas, too?)
+               $EMAIL = USER_CREATE_EMAIL_LINK($email);
+       } elseif ((EXT_IS_ACTIVE("sponsor")) && ($table == "sponsor_data")) {
+               // Create email link to contact sponsor within admin area (or like the link above?)
+               $EMAIL = SPONSOR_CREATE_EMAIL_LINK($email);
+       }
+
+       // Shall I close the link when there is no admin?
+       if ((!IS_ADMIN()) && ($EMAIL == $email)) $EMAIL = "#"; // Closed!
+
+       // Return email link
+       return $EMAIL;
+}
+// Generate a hash for extra-security for all passwords
+function generateHash($plainText, $salt = "") {
+       global $CONFIG, $_SERVER;
+
+       // Is the required extension "sql_patches" there?
+       if ((GET_EXT_VERSION("sql_patches") < "0.3.6") || (GET_EXT_VERSION("sql_patches") == "")) {
+               // Extension sql_patches is missing/outdated so we return the plain text
+               return $plainText;
+       }
+
+       // When the salt is empty build a new one, else use the first x configured characters as the salt
+       if ($salt == "") {
+               // Build server string
+               $server = $_SERVER['PHP_SELF'].":".getenv('HTTP_USER_AGENT').":".getenv('SERVER_SOFTWARE').":".getenv('REMOTE_ADDR').":".":".filemtime(PATH."inc/databases.php");
+
+               // Build key string
+               $keys   = SITE_KEY.":".DATE_KEY.":".$CONFIG['secret_key'].":".$CONFIG['file_hash'].":".date("d-m-Y (l-F-T)", $CONFIG['patch_ctime']).":".$CONFIG['master_salt'];
+
+               // Additional data
+               $data = $plainText.":".uniqid(rand(), true).":".time();
+
+               // Calculate number for generating the code
+               $a = time() + _ADD - 1;
+
+               // Generate SHA1 sum from modula of number and the prime number
+               $sha1 = sha1(($a % _PRIME).$server.":".$keys.":".$data.":".date("d-m-Y (l-F-T)", time()).":".$a);
+               //* DEBUG: */ echo "SHA1=".$sha1." (".strlen($sha1).")<br>";
+               $sha1 = scrambleString($sha1);
+               //* DEBUG: */ echo "Scrambled=".$sha1." (".strlen($sha1).")<br>";
+               //* DEBUG: */ $sha1b = descrambleString($sha1);
+               //* DEBUG: */ echo "Descrambled=".$sha1b." (".strlen($sha1b).")<br>";
+
+               // Generate the password salt string
+               $salt = substr($sha1, 0, $CONFIG['salt_length']);
+               //* DEBUG: */ echo $salt." (".strlen($salt).")<BR>";
+       }
+        else
+       {
+               $salt = substr($salt, 0, $CONFIG['salt_length']);
+       }
+
+       // Return hash
+       return $salt . sha1($salt . $plainText);
+}
+//
+function scrambleString($str) {
+       global $CONFIG;
+
+       // Init
+       $scrambled = "";
+
+       // Final check, in case of failture it will return unscrambled string
+       if (strlen($str) > 40) {
+               // The string is to long
+               return $str;
+       } elseif (strlen($str) == 40) {
+               // From database
+               $scrambleNums = explode(":", $CONFIG['pass_scramble']);
+       } else {
+               // Generate new numbers
+               $scrambleNums = explode(":", genScrambleString(strlen($str)));
+       }
+
+       // Scramble string here
+       //* DEBUG: */ echo "***Original=".$str."***<BR>";
+       for ($idx = 0; $idx < strlen($str); $idx++) {
+               // Get char on scrambled position
+               $char = substr($str, $scrambleNums[$idx], 1);
+
+               // Add it to final output string
+               $scrambled .= $char;
+       }
+
+       // Return scrambled string
+       //* DEBUG: */ echo "***Scrambled=".$scrambled."***<BR>";
+       return $scrambled;
+}
+//
+function descrambleString($str)
+{
+       global $CONFIG;
+       // Scramble only 40 chars long strings
+       if (strlen($str) != 40) return $str;
+
+       // Load numbers from config
+       $scrambleNums = explode(":", $CONFIG['pass_scramble']);
+
+       // Validate numbers
+       if (count($scrambleNums) != 40) return $str;
+
+       // Begin descrambling
+       $orig = str_repeat(" ", 40);
+       //* DEBUG: */ echo "+++Scrambled=".$str."+++<BR>";
+       for ($idx = 0; $idx < 40; $idx++)
+       {
+               $char = substr($str, $idx, 1);
+               $orig = substr_replace($orig, $char, $scrambleNums[$idx], 1);
+       }
+
+       // Return scrambled string
+       //* DEBUG: */ echo "+++Original=".$orig."+++<BR>";
+       return $orig;
+}
+//
+function genScrambleString($len) {
+       // Prepare randomizer and array for the numbers
+       mt_srand((double) microtime() * 1000000);
+       $scrambleNumbers = array();
+
+       // First we need to setup randomized numbers from 0 to 31
+       for ($idx = 0; $idx < $len; $idx++) {
+               // Generate number
+               $rand = mt_rand(0, ($len -1));
+
+               // Check for it by creating more numbers
+               while (array_key_exists($rand, $scrambleNumbers)) {
+                       $rand = mt_rand(0, ($len -1));
+               }
+
+               // Add number
+               $scrambleNumbers[$rand] = $rand;
+       }
+
+       // So let's create the string for storing it in database
+       $scrambleString = implode(":", $scrambleNumbers);
+       return $scrambleString;
+}
+// Append data like session ID referral ID to the given URL which would
+// normally be stored in cookies
+function ADD_URL_DATA($URL)
+{
+       global $_GET, $CONFIG;
+       $ADD = "";
+
+       // Determine URL binder
+       $BIND = "?";
+       if (strpos($URL, "?") !== false) $BIND = "&";
+
+       if ((!defined('__COOKIES')) || ((!__COOKIES))) {
+               // Cookies are not accepted
+               if ((!empty($_GET['refid'])) && (strpos($URL, "refid=") == 0)) {
+                       // Cookie found in URL
+                       $ADD .= $BIND."refid=".bigintval($_GET['refid']);
+               } elseif ((GET_EXT_VERSION("sql_patches") != "") && ($CONFIG['def_refid'] > 0)) {
+                       // Not found! So let's set default here
+                       $ADD .= $BIND."refid=".$CONFIG['def_refid'];
+               }
+
+               // Add session ID
+               if ((!empty($_GET['PHPSESSID'])) && (strpos($URL, "PHPSESSID=") == 0)) {
+                       // Add session from URL
+                       $ADD .= $BIND."PHPSESSID=".SQL_ESCAPE(strip_tags($_GET['PHPSESSID']));
+               } else {
+                       // Add current session
+                       $ADD .= $BIND."PHPSESSID=".session_id();
+               }
+       }
+
+       // Add all together and return it
+       return $URL.$ADD;
+}
+//
+function generatePassString($passHash) {
+       global $CONFIG;
+       $ret = "*FAILED*";
+
+       // Is a secret key and master salt already initialized?
+       if ((!empty($CONFIG['secret_key'])) && (!empty($CONFIG['master_salt']))) {
+               // Only calculate when the secret key is generated
+               $newHash = ""; $start = 9;
+               for ($idx = 0; $idx < 10; $idx++) {
+                       $part1 = hexdec(substr($passHash, $start, 4));
+                       $part2 = hexdec(substr($CONFIG['secret_key'], $start, 4));
+                       $mod = dechex($idx);
+                       if ($part1 > $part2) {
+                               $mod = dechex(sqrt(($part1 - $part2) * _PRIME / pi()));
+                       } elseif ($part2 > $part1) {
+                               $mod = dechex(sqrt(($part2 - $part1) * _PRIME / pi()));
+                       }
+                       $mod = substr(round($mod), 0, 4);
+                       $mod = str_repeat('0', 4-strlen($mod)).$mod;
+                       //* DEBUG: */ echo "*".$start."=".$mod."*<br>";
+                       $start += 4;
+                       $newHash .= $mod;
+               }
+               //* DEBUG: */ die($passHash."<br>".$newHash." (".strlen($newHash).")");
+               $ret = generateHash($newHash, $CONFIG['master_salt']);
+       }
+
+       // Return result
+       return $ret;
+}
+// Fix "deleted" cookies
+function FIX_DELETED_COOKIES ($cookies) {
+       // Is this an array with entries?
+       if ((is_array($cookies)) && (count($cookies) > 0)) {
+               // Then check all cookies if they are marked as deleted!
+               foreach ($cookies as $cookieName) {
+                       // Is the cookie set to "deleted"?
+                       if ((isset($_COOKIE[$cookieName])) && ($_COOKIE[$cookieName] == "deleted")) {
+                               unset($_COOKIE[$cookieName]);
+                       }
+               }
+       }
+}
+// Output error messages in a fasioned way and die...
+function mxchange_die ($msg) {
+       global $FOOTER;
+
+       // Load the message template
+       LOAD_TEMPLATE("admin_settings_saved", false, $msg);
+
+       // Load footer
+       include(PATH."inc/footer.php");
+
+       // Exit explicitly
+       exit;
+}
+//
+//////////////////////////////////////////////
+//                                          //
+// AUTOMATICALLY RE-GNERATED FUNCTIONS ONLY //
+//                                          //
+//////////////////////////////////////////////
+//
+if (!function_exists('html_entity_decode'))
+{
+       // Taken from documentation on www.php.net
+       function html_entity_decode($string)
+       {
+               $trans_tbl = get_html_translation_table(HTML_ENTITIES);
+               $trans_tbl = array_flip($trans_tbl);
+               return strtr($string, $trans_tbl);
+       }
+}
+//
+?>