-<?php\r
-/************************************************************************\r
- * MXChange v0.2.1 Start: 03/25/2004 *\r
- * =============== Last change: 09/29/2004 *\r
- * *\r
- * -------------------------------------------------------------------- *\r
- * File : extensions.php *\r
- * -------------------------------------------------------------------- *\r
- * Short description : Extension management *\r
- * -------------------------------------------------------------------- *\r
- * Kurzbeschreibung : Erweiterungen-Management *\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
-function EXTENSION_REGISTER($ext_name, $id, $dry_run=false)\r
-{\r
- global $NOTES, $CONFIG, $INC_POOL;\r
- // We want to register an extension and registration status is by default "failed" (= false)\r
- $EXT_LOAD_MODE = "register"; $ret = false; $SQLs = array();\r
- $INC_POOL = array();\r
-\r
- // This shall never do a non-admin user!\r
- if (!IS_ADMIN()) return false;\r
-\r
- // Is this extension already installed?\r
- if (EXT_IS_ACTIVE($ext_name)) return false;\r
-\r
- // Generate file name\r
- $file = sprintf(PATH."inc/extensions/ext-%s.php", $ext_name);\r
-\r
- // Does this extension exists?\r
- if (file_exists($file) && is_readable($file))\r
- {\r
- // Extension was found so we can load it in registration mode\r
- require($file);\r
-\r
- // And run possible updates\r
- $EXT_LOAD_MODE = "update"; $EXT_UPDATE_DEPENDS = "";\r
- foreach ($EXT_VER_HISTORY as $EXT_VER)\r
- {\r
- require($file);\r
- if (((GET_EXT_VERSION("sql_patches") != "") && ($CONFIG['verbose_sql'] == "Y")) || (!EXT_IS_ACTIVE("sql_patches")))\r
- {\r
- if (!empty($UPDATE_NOTES))\r
- {\r
- // Update notes found\r
- $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR>".$UPDATE_NOTES."<BR><BR>\n";\r
- $UPDATE_NOTES = "";\r
- }\r
- elseif (($EXT_VER == "0.0") || ($EXT_VER == "0.0.0"))\r
- {\r
- // Initial release\r
- $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR>".INITIAL_RELEASE."<BR><BR>\n";\r
- }\r
- else\r
- {\r
- $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR><I>".NO_UPDATE_NOTES."</I><BR><BR>\n";\r
- }\r
- }\r
- }\r
-\r
- // Does this extension depends on an outstanding update of another update?\r
- if (!empty($EXT_UPDATE_DEPENDS))\r
- {\r
- // Backup SQL commands and clear current\r
- $SQLs2 = $SQLs; $SQLs = array(); $test = false;\r
-\r
- // Backup language as well\r
- $LANG_BCK = $EXT_LANG_PREFIX;\r
-\r
- // Load required extension also in update mode\r
- $file = sprintf(PATH."inc/extensions/ext-%s.php", $EXT_UPDATE_DEPENDS);\r
-\r
- // Check for required file\r
- if (file_exists($file) && is_readable($file))\r
- {\r
- // File exists so let's load it\r
- $VER_BACKUP = $EXT_VERSION;\r
- require($file);\r
- $EXT_VERSION = $VER_BACKUP;\r
-\r
- // If versions mismatch update extension first\r
- $ext_ver = GET_EXT_VERSION($EXT_UPDATE_DEPENDS);\r
- if (empty($ext_ver))\r
- {\r
- // Extension not registered so far so first load task's ID...\r
- $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE task_type='EXTENSION' AND subject LIKE '[%s:]%%' LIMIT 1",\r
- array($EXT_UPDATE_DEPENDS), __FILE__, __LINE__);\r
- if (SQL_NUMROWS($result) == 1)\r
- {\r
- // Task found so load task's ID and register extension...\r
- list($task) = SQL_FETCHROW($result);\r
- SQL_FREERESULT($result);\r
- $test = EXTENSION_REGISTER($EXT_UPDATE_DEPENDS, $task, $dry_run);\r
- }\r
- }\r
- elseif ($ext_ver != $EXT_VERSION)\r
- {\r
- // Ok, update this extension now\r
- EXTENSION_UPDATE(basename($file), $EXT_UPDATE_DEPENDS, $ext_ver, $dry_run);\r
- $test = true;\r
- }\r
- else\r
- {\r
- // Nothing to register / update before...\r
- $test = true;\r
- }\r
- }\r
- else\r
- {\r
- // Required file for update does not exists!\r
- $test = true;\r
- // But this is fine for the first time...\r
- }\r
-\r
- // Finally restore previous SQLs\r
- $SQLs = $SQLs2; unset($SQLs2);\r
- $EXT_LANG_PREFIX = $LANG_BCK;\r
- }\r
- else\r
- {\r
- // Does not depend on an other extension\r
- $test = true;\r
- }\r
-\r
- // Does everthing before wents ok?\r
- if ($test)\r
- {\r
- // "Dry-run-mode" activated?\r
- if (!$dry_run)\r
- {\r
- // Are there any SQL commands to run?\r
- if (count($SQLs) > 0)\r
- {\r
- foreach ($SQLs as $sql)\r
- {\r
- $sql = trim($sql);\r
- // Run SQL command\r
- if (!empty($sql))\r
- {\r
- // Run SQLs without compiling them...\r
- $result = SQL_QUERY($sql, __FILE__, __LINE__, false);\r
- }\r
- }\r
- }\r
-\r
- // Check for added include files\r
- if (count($INC_POOL > 0))\r
- {\r
- // Loads every include file\r
- foreach ($INC_POOL as $inc)\r
- {\r
- require_once($inc);\r
- }\r
- }\r
-\r
- // Register extension\r
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_extensions (ext_name, ext_lang_file, ext_active, ext_version) VALUES ('%s', '%s', 'N', '%s')",\r
- array($ext_name, $EXT_LANG_PREFIX, $EXT_VERSION), __FILE__, __LINE__);\r
-\r
- // Update task management\r
- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_task_system SET status='SOLVED' WHERE id=%d LIMIT 1",\r
- array(bigintval($id)), __FILE__, __LINE__);\r
-\r
- // In normal mode return a true on success\r
- $ret = true; unset($SQLs);\r
- }\r
- else\r
- {\r
- // Rewrite SQL command to keep { and } inside\r
- foreach ($SQLs as $key=>$sql)\r
- {\r
- $sql = str_replace('{', "{", str_replace('}', "}", $sql));\r
- $SQLs[$key] = $sql;\r
- }\r
-\r
- // In "dry-run" mode return array with all SQL commands\r
- $ret = $SQLs;\r
-\r
- // Remove all SQL commands\r
- unset($SQLs);\r
- }\r
- }\r
- else\r
- {\r
- // No, an error occurs while registering extension :-(\r
- $ret = false;\r
- }\r
- }\r
- elseif (($id > 0) && (!empty($ext_name)))\r
- {\r
- // Remove task from system when id and extension's name is valid\r
- $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_task_system WHERE id=%d AND status='NEW' LIMIT 1",\r
- array(bigintval($id)), __FILE__, __LINE__);\r
- }\r
- // Return status code\r
- return $ret;\r
-}\r
-//\r
-function EXTENSION_RUN_SQLS($id, $EXT_LOAD_MODE)\r
-{\r
- global $CACHE;\r
- // This shall never do a non-admin user!\r
- if (!IS_ADMIN()) return false;\r
-\r
- // Get extension's name\r
- $result = SQL_QUERY_ESC("SELECT ext_name FROM "._MYSQL_PREFIX."_extensions WHERE id=%d LIMIT 1",\r
- array(bigintval($id)), __FILE__, __LINE__);\r
- list($ext_name) = SQL_FETCHROW($result);\r
- SQL_FREERESULT($result);\r
- if (empty($ext_name)) return false;\r
-\r
- // Load extension in detected mode\r
- $file = sprintf(PATH."inc/extensions/ext-%s.php", $ext_name); $SQLs = array();\r
- if (file_exists($file) && is_readable($file)) require($file);\r
- if ((is_array($SQLs) && (sizeof($SQLs) > 0)))\r
- {\r
- // Run SQL commands...\r
- foreach ($SQLs as $sql)\r
- {\r
- $sql = trim($sql);\r
- if (!empty($sql))\r
- {\r
- // Run SQL command\r
- $result = SQL_QUERY($sql, __FILE__, __LINE__, false);\r
- }\r
- }\r
-\r
- // Remove cache file(s) if extension is active\r
- if (EXT_IS_ACTIVE("cache"))\r
- {\r
- // Remove cache filer\r
- if ($CACHE->cache_file("extensions", true)) $CACHE->cache_destroy();\r
- if ($CACHE->cache_file("mod_reg", true)) $CACHE->cache_destroy();\r
- if ($CACHE->cache_file("config", true)) $CACHE->cache_destroy();\r
- }\r
- }\r
-}\r
-//\r
-function EXT_IS_ACTIVE ($ext_name, $ignore_admin=false, $ignore_cache=false)\r
-{\r
- global $EXTENSIONS, $CONFIG;\r
-\r
- // Extensions are all inactive during installation\r
- if ((!mxchange_installed) || (mxchange_installing) || (empty($ext_name))) return false;\r
-\r
- // Extension's file name will also be checked\r
- $FILE = PATH."inc/extensions/ext-".$ext_name.".php";\r
- if ((!file_exists($FILE)) && (!is_readable($FILE))) return false;\r
- //* DEBUG: */ echo "*".$ext_name."*<BR>";\r
-\r
- // Failed is the default\r
- $ret = false;\r
- if ((!empty($EXTENSIONS['ext_active'][$ext_name])) && (!$ignore_cache))\r
- {\r
- // Load from cache\r
- $active = $EXTENSIONS['ext_active'][$ext_name];\r
-\r
- // Count cache hits\r
- if (isset($CONFIG['cache_hits'])) $CONFIG['cache_hits']++;\r
- }\r
- else\r
- {\r
- // Load from database\r
- $result = SQL_QUERY_ESC("SELECT ext_active FROM "._MYSQL_PREFIX."_extensions WHERE ext_name='%s' LIMIT 1",\r
- array($ext_name), __FILE__, __LINE__);\r
- if (SQL_NUMROWS($result) == 0)\r
- {\r
- // Extension was not found!\r
- return false;\r
- }\r
- list($active) = SQL_FETCHROW($result);\r
- SQL_FREERESULT($result);\r
-\r
- // Write cache array\r
- $EXTENSIONS['ext_active'][$ext_name] = $active;\r
- }\r
-\r
- // Is this extension activated? (For admins we always have active extensions...)\r
- $inc = sprintf(PATH."inc/extensions/ext-%s.php", $ext_name);\r
- // Shorter way\r
- return (\r
- (\r
- ($active == "Y") || (\r
- (IS_ADMIN()) &&\r
- (!$ignore_admin) &&\r
- (!empty($active))\r
- )\r
- ) && (\r
- file_exists($inc)\r
- ) && (\r
- is_readable($inc)\r
- )\r
- );\r
-}\r
-//\r
-function GET_EXT_VERSION ($ext_name)\r
-{\r
- global $EXTENSIONS, $CONFIG;\r
- // Extensions are all inactive during installation\r
- if ((!mxchange_installed) || (mxchange_installing)) return "";\r
-\r
- // Is the cache written?\r
- if (!empty($EXTENSIONS['ext_version'][$ext_name]))\r
- {\r
- // Load data from cache\r
- $ret = $EXTENSIONS['ext_version'][$ext_name];\r
-\r
- // Count cache hits\r
- if (isset($CONFIG['cache_hits'])) $CONFIG['cache_hits']++;\r
- }\r
- else\r
- {\r
- // Load from database\r
- $result = SQL_QUERY_ESC("SELECT ext_version FROM "._MYSQL_PREFIX."_extensions WHERE ext_name='%s' LIMIT 1",\r
- array($ext_name), __FILE__, __LINE__);\r
- list($ret) = SQL_FETCHROW($result);\r
- SQL_FREERESULT($result);\r
-\r
- // Set cache\r
- $EXTENSIONS['ext_version'][$ext_name] = $ret;\r
- }\r
- return $ret;\r
-}\r
-//\r
-function EXTENSION_UPDATE($file, $ext, $EXT_VER, $dry_run=false)\r
-{\r
- // This shall never do a non-admin user!\r
- global $CACHE, $CONFIG, $NOTES; $SQLs = array();\r
- if ((!IS_ADMIN()) || (empty($ext))) return false;\r
-\r
- // Load extension in update mode\r
- $EXT_LOAD_MODE = "update"; $EXT_UPDATE_DEPENDS = ""; $NOTES = "";\r
- include(PATH."inc/extensions/".$file);\r
- if (!empty($EXT_UPDATE_DEPENDS))\r
- {\r
- // Update another extension first!\r
- $test = EXTENSION_UPDATE(("ext-".$EXT_UPDATE_DEPENDS.".php"), $EXT_UPDATE_DEPENDS, GET_EXT_VERSION($EXT_UPDATE_DEPENDS), $dry_run);\r
- }\r
-\r
- // Check if version is updated\r
- if ((($EXT_VERSION != $EXT_VER) || ($dry_run)) && (is_array($EXT_VER_HISTORY)))\r
- {\r
- // Search for starting point\r
- $start = array_search($EXT_VER, $EXT_VER_HISTORY);\r
- $NOTES = "";\r
-\r
- // And load SQL queries in order of version history\r
- for ($idx = ($start + 1); $idx < sizeof($EXT_VER_HISTORY); $idx++)\r
- {\r
- // Remove old SQLs array to prevent possible bugs\r
- if (!$dry_run) { unset($SQLs); $SQLs = array(); }\r
-\r
- // Set version\r
- $EXT_VER = $EXT_VER_HISTORY[$idx];\r
-\r
- // Include again...\r
- include(PATH."inc/extensions/".$file);\r
-\r
- // Add notes\r
- if ($CONFIG['verbose_sql'] == "Y")\r
- {\r
- $EXT_VER = $EXT_VER_HISTORY[$idx];\r
- if (!empty($UPDATE_NOTES))\r
- {\r
- // Update notes found\r
- $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR>".$UPDATE_NOTES."<BR><BR>\n";\r
- $UPDATE_NOTES = "";\r
- }\r
- elseif ($EXT_VER == "0.0")\r
- {\r
- // Initial release\r
- $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR>".INITIAL_RELEASE."<BR><BR>\n";\r
- }\r
- else\r
- {\r
- $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR><I>".NO_UPDATE_NOTES."</I><BR><BR>\n";\r
- }\r
- }\r
-\r
- // Run SQLs\r
- if ((is_array($SQLs)) && (!$dry_run))\r
- {\r
- // Run SQL commands\r
- foreach ($SQLs as $sql)\r
- {\r
- $sql = trim($sql);\r
- if (!empty($sql))\r
- {\r
- // Run SQL command...\r
- $result = SQL_QUERY($sql, __FILE__, __LINE__, false);\r
- }\r
- }\r
- } elseif (GET_EXT_VERSION("sql_patches") == "") {\r
- // Remove SQLs if extension is not installed\r
- $SQLs = array();\r
- }\r
- }\r
-\r
- if (!$dry_run)\r
- {\r
- // In normal mode insert task and update extension's version...\r
- $ext_subj = "[UPDATE-".$ext."-".$EXT_VERSION.":] ".ADMIN_UPDATE_EXT_SUBJ;\r
-\r
- // Create task\r
- $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE subject='%s' LIMIT 1",\r
- array($ext_subj), __FILE__, __LINE__);\r
- if (SQL_NUMROWS($result) == 0)\r
- {\r
- // Task not created so it's a brand-new extension which we need to register and create a task for!\r
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_task_system (assigned_admin, userid, status, task_type, subject, text, task_created) VALUES ('%s', '0', 'NEW', 'EXTENSION_UPDATE', '%s', '%s', UNIX_TIMESTAMP())",\r
- array(GET_ADMIN_ID(SQL_ESCAPE($_COOKIE['admin_login'])), $ext_subj, addslashes($NOTES)), __FILE__, __LINE__);\r
- }\r
-\r
- // Free memory\r
- SQL_FREERESULT($result);\r
-\r
- // Update extension's version\r
- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_version='%s' WHERE ext_name='%s' LIMIT 1",\r
- array($EXT_VERSION, $ext), __FILE__, __LINE__);\r
-\r
- // Update cache\r
- if (EXT_IS_ACTIVE("cache"))\r
- {\r
- if ($CACHE->cache_file("extensions", true) == true) $CACHE->cache_destroy();\r
- if ($CACHE->cache_file("config", true) == true) $CACHE->cache_destroy();\r
- if ($CACHE->cache_file("mod_reg", true) == true) $CACHE->cache_destroy();\r
- }\r
-\r
- // Remove array\r
- unset($SQLs);\r
- }\r
- else\r
- {\r
- // In "dry-run" mode return array with SQL commands\r
- return $SQLs;\r
- }\r
- }\r
-}\r
-//\r
-function EXTENSION_VERBOSE_TABLE($SQLs, $title=ADMIN_SQLS_EXECUTED_ON_REMOVAL, $dashed="", $switch=false, $WIDTH="480")\r
-{\r
- global $CONFIG;\r
-\r
- $S = false; $SW = 2; $i = 1;\r
- $OUT = "";\r
- if ((is_array($SQLs)) && (GET_EXT_VERSION("sql_patches")) && ($CONFIG['verbose_sql'] == "Y"))\r
- {\r
- $OUT = "<DIV align=\"center\">\r
-<TABLE border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"".$WIDTH."\" align=\"center\"".$dashed.">\r
-<TR>\r
- <TD colspan=\"2\" align=\"center\" class=\"admin_title bottom2\" height=\"24\">\r
- <STRONG>".$title.":</STRONG>\r
- </TD>\r
-</TR>\n";\r
- foreach ($SQLs as $idx=>$sql)\r
- {\r
- $sql = trim($sql);\r
- if (!empty($sql))\r
- {\r
- $S = true;\r
- $OUT .= "<TR>\r
- <TD class=\"switch_sw".(3 - $SW)." bottom2\" style=\"padding-left: 2px\" width=\"30\">".$i.".</TD>\r
- <TD class=\"switch_sw".(3 - $SW)." bottom2\" style=\"padding-left: 5px; padding-right: 5px\">\r
- ".$sql."\r
- </TD>\r
-</TR>\n";\r
- if ($switch) $SW = 3 - $SW;\r
- $i++;\r
- }\r
- }\r
- }\r
-\r
- if ((!$S) && (GET_EXT_VERSION("sql_patches")) && ($CONFIG['verbose_sql'] == "Y"))\r
- {\r
- // No addional SQL commands to run\r
- $OUT .= "<TR>\r
- <TD colspan=\"2\" align=\"center\" class=\"switch_sw2 bottom2\" height=\"24\">\r
- <FONT class=\"admin_note\">".ADMIN_NO_ADDIONAL_SQLS."</FONT>\r
- </TD>\r
-</TR>\n";\r
- }\r
-\r
- if (!empty($OUT)) {\r
- // Add missing close-table tag\r
- $OUT .= "</TABLE>\r
-</DIV>\n";\r
- }\r
- return $OUT;\r
-}\r
-//\r
-function GET_EXT_NAME($id)\r
-{\r
- $ret = "";\r
- global $EXTENSIONS, $CONFIG;\r
- if (!empty($EXTENSIONS['ext_id'][$id]))\r
- {\r
- // Load from cache\r
- $ret = $EXTENSIONS['ext_id'][$id];\r
-\r
- // Count cache hits\r
- $CONFIG['cache_hits']++;\r
- }\r
- else\r
- {\r
- // Load from database\r
- $result = SQL_QUERY_ESC("SELECT ext_name FROM "._MYSQL_PREFIX."_extensions WHERE id=%d LIMIT 1",\r
- array(bigintval($id)), __FILE__, __LINE__);\r
- list($ret) = SQL_FETCHROW($result);\r
- SQL_FREERESULT($result);\r
- }\r
- return $ret;\r
-}\r
-//\r
-function GET_EXT_ID($name)\r
-{\r
- $ret = "0";\r
- global $EXTENSIONS, $CONFIG;\r
- if ((isset($EXTENSIONS['ext_id'])) && (is_array($EXTENSIONS['ext_id'])))\r
- {\r
- // Load from cache\r
- $ret = array_search($name, $EXTENSIONS['ext_id']);\r
-\r
- // Count cache hits\r
- $CONFIG['cache_hits']++;\r
- }\r
- else\r
- {\r
- // Load from database\r
- $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_extensions WHERE ext_name='%s' LIMIT 1",\r
- array($name), __FILE__, __LINE__);\r
- list($ret) = SQL_FETCHROW($result);\r
- SQL_FREERESULT($result);\r
- }\r
- return $ret;\r
-}\r
-//\r
-?>\r
+<?php
+/************************************************************************
+ * MXChange v0.2.1 Start: 03/25/2004 *
+ * =============== Last change: 09/29/2004 *
+ * *
+ * -------------------------------------------------------------------- *
+ * File : extensions.php *
+ * -------------------------------------------------------------------- *
+ * Short description : Extension management *
+ * -------------------------------------------------------------------- *
+ * Kurzbeschreibung : Erweiterungen-Management *
+ * -------------------------------------------------------------------- *
+ * *
+ * -------------------------------------------------------------------- *
+ * 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);
+}
+//
+function EXTENSION_REGISTER($ext_name, $id, $dry_run=false)
+{
+ global $NOTES, $CONFIG, $INC_POOL;
+ // We want to register an extension and registration status is by default "failed" (= false)
+ $EXT_LOAD_MODE = "register"; $ret = false; $SQLs = array();
+ $INC_POOL = array();
+
+ // This shall never do a non-admin user!
+ if (!IS_ADMIN()) return false;
+
+ // Is this extension already installed?
+ if (EXT_IS_ACTIVE($ext_name)) return false;
+
+ // Generate file name
+ $file = sprintf(PATH."inc/extensions/ext-%s.php", $ext_name);
+
+ // Does this extension exists?
+ if (file_exists($file) && is_readable($file))
+ {
+ // Extension was found so we can load it in registration mode
+ require($file);
+
+ // And run possible updates
+ $EXT_LOAD_MODE = "update"; $EXT_UPDATE_DEPENDS = "";
+ foreach ($EXT_VER_HISTORY as $EXT_VER)
+ {
+ require($file);
+ if (((GET_EXT_VERSION("sql_patches") != "") && ($CONFIG['verbose_sql'] == "Y")) || (!EXT_IS_ACTIVE("sql_patches")))
+ {
+ if (!empty($UPDATE_NOTES))
+ {
+ // Update notes found
+ $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR>".$UPDATE_NOTES."<BR><BR>\n";
+ $UPDATE_NOTES = "";
+ }
+ elseif (($EXT_VER == "0.0") || ($EXT_VER == "0.0.0"))
+ {
+ // Initial release
+ $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR>".INITIAL_RELEASE."<BR><BR>\n";
+ }
+ else
+ {
+ $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR><I>".NO_UPDATE_NOTES."</I><BR><BR>\n";
+ }
+ }
+ }
+
+ // Does this extension depends on an outstanding update of another update?
+ if (!empty($EXT_UPDATE_DEPENDS))
+ {
+ // Backup SQL commands and clear current
+ $SQLs2 = $SQLs; $SQLs = array(); $test = false;
+
+ // Backup language as well
+ $LANG_BCK = $EXT_LANG_PREFIX;
+
+ // Load required extension also in update mode
+ $file = sprintf(PATH."inc/extensions/ext-%s.php", $EXT_UPDATE_DEPENDS);
+
+ // Check for required file
+ if (file_exists($file) && is_readable($file))
+ {
+ // File exists so let's load it
+ $VER_BACKUP = $EXT_VERSION;
+ require($file);
+ $EXT_VERSION = $VER_BACKUP;
+
+ // If versions mismatch update extension first
+ $ext_ver = GET_EXT_VERSION($EXT_UPDATE_DEPENDS);
+ if (empty($ext_ver))
+ {
+ // Extension not registered so far so first load task's ID...
+ $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE task_type='EXTENSION' AND subject LIKE '[%s:]%%' LIMIT 1",
+ array($EXT_UPDATE_DEPENDS), __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) == 1)
+ {
+ // Task found so load task's ID and register extension...
+ list($task) = SQL_FETCHROW($result);
+ SQL_FREERESULT($result);
+ $test = EXTENSION_REGISTER($EXT_UPDATE_DEPENDS, $task, $dry_run);
+ }
+ }
+ elseif ($ext_ver != $EXT_VERSION)
+ {
+ // Ok, update this extension now
+ EXTENSION_UPDATE(basename($file), $EXT_UPDATE_DEPENDS, $ext_ver, $dry_run);
+ $test = true;
+ }
+ else
+ {
+ // Nothing to register / update before...
+ $test = true;
+ }
+ }
+ else
+ {
+ // Required file for update does not exists!
+ $test = true;
+ // But this is fine for the first time...
+ }
+
+ // Finally restore previous SQLs
+ $SQLs = $SQLs2; unset($SQLs2);
+ $EXT_LANG_PREFIX = $LANG_BCK;
+ }
+ else
+ {
+ // Does not depend on an other extension
+ $test = true;
+ }
+
+ // Does everthing before wents ok?
+ if ($test)
+ {
+ // "Dry-run-mode" activated?
+ if (!$dry_run)
+ {
+ // Are there any SQL commands to run?
+ if (count($SQLs) > 0)
+ {
+ foreach ($SQLs as $sql)
+ {
+ $sql = trim($sql);
+ // Run SQL command
+ if (!empty($sql))
+ {
+ // Run SQLs without compiling them...
+ $result = SQL_QUERY($sql, __FILE__, __LINE__, false);
+ }
+ }
+ }
+
+ // Check for added include files
+ if (count($INC_POOL > 0))
+ {
+ // Loads every include file
+ foreach ($INC_POOL as $inc)
+ {
+ require_once($inc);
+ }
+ }
+
+ // Register extension
+ $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_extensions (ext_name, ext_lang_file, ext_active, ext_version) VALUES ('%s', '%s', 'N', '%s')",
+ array($ext_name, $EXT_LANG_PREFIX, $EXT_VERSION), __FILE__, __LINE__);
+
+ // Update task management
+ $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_task_system SET status='SOLVED' WHERE id=%d LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__);
+
+ // In normal mode return a true on success
+ $ret = true; unset($SQLs);
+ }
+ else
+ {
+ // Rewrite SQL command to keep { and } inside
+ foreach ($SQLs as $key=>$sql)
+ {
+ $sql = str_replace('{', "{", str_replace('}', "}", $sql));
+ $SQLs[$key] = $sql;
+ }
+
+ // In "dry-run" mode return array with all SQL commands
+ $ret = $SQLs;
+
+ // Remove all SQL commands
+ unset($SQLs);
+ }
+ }
+ else
+ {
+ // No, an error occurs while registering extension :-(
+ $ret = false;
+ }
+ }
+ elseif (($id > 0) && (!empty($ext_name)))
+ {
+ // Remove task from system when id and extension's name is valid
+ $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_task_system WHERE id=%d AND status='NEW' LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__);
+ }
+ // Return status code
+ return $ret;
+}
+//
+function EXTENSION_RUN_SQLS($id, $EXT_LOAD_MODE)
+{
+ global $CACHE;
+ // This shall never do a non-admin user!
+ if (!IS_ADMIN()) return false;
+
+ // Get extension's name
+ $result = SQL_QUERY_ESC("SELECT ext_name FROM "._MYSQL_PREFIX."_extensions WHERE id=%d LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__);
+ list($ext_name) = SQL_FETCHROW($result);
+ SQL_FREERESULT($result);
+ if (empty($ext_name)) return false;
+
+ // Load extension in detected mode
+ $file = sprintf(PATH."inc/extensions/ext-%s.php", $ext_name); $SQLs = array();
+ if (file_exists($file) && is_readable($file)) require($file);
+ if ((is_array($SQLs) && (sizeof($SQLs) > 0)))
+ {
+ // Run SQL commands...
+ foreach ($SQLs as $sql) {
+ // Trim spaces away which we don't need
+ $sql = trim($sql);
+
+ // Is there still an SQL query?
+ if (!empty($sql)) {
+ // Run SQL command
+ $result = SQL_QUERY($sql, __FILE__, __LINE__, false);
+ }
+ }
+
+ // Remove cache file(s) if extension is active
+ if (EXT_IS_ACTIVE("cache")) {
+ // Remove cache filer
+ if ($CACHE->cache_file("extensions", true)) $CACHE->cache_destroy();
+ if ($CACHE->cache_file("mod_reg", true)) $CACHE->cache_destroy();
+ if ($CACHE->cache_file("config", true)) $CACHE->cache_destroy();
+ }
+ }
+}
+//
+function EXT_IS_ACTIVE ($ext_name, $ignore_admin=false, $ignore_cache=false)
+{
+ global $EXTENSIONS, $CONFIG;
+
+ // Extensions are all inactive during installation
+ if ((!mxchange_installed) || (mxchange_installing) || (empty($ext_name))) return false;
+
+ // Extension's file name will also be checked
+ $FILE = PATH."inc/extensions/ext-".$ext_name.".php";
+ if ((!file_exists($FILE)) && (!is_readable($FILE))) return false;
+ //* DEBUG: */ echo "*".$ext_name."*<BR>";
+
+ // Failed is the default
+ $ret = false;
+ if ((!empty($EXTENSIONS['ext_active'][$ext_name])) && (!$ignore_cache))
+ {
+ // Load from cache
+ $active = $EXTENSIONS['ext_active'][$ext_name];
+
+ // Count cache hits
+ if (isset($CONFIG['cache_hits'])) $CONFIG['cache_hits']++;
+ }
+ else
+ {
+ // Load from database
+ $result = SQL_QUERY_ESC("SELECT ext_active FROM "._MYSQL_PREFIX."_extensions WHERE ext_name='%s' LIMIT 1",
+ array($ext_name), __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) == 0)
+ {
+ // Extension was not found!
+ return false;
+ }
+ list($active) = SQL_FETCHROW($result);
+ SQL_FREERESULT($result);
+
+ // Write cache array
+ $EXTENSIONS['ext_active'][$ext_name] = $active;
+ }
+
+ // Is this extension activated? (For admins we always have active extensions...)
+ $inc = sprintf(PATH."inc/extensions/ext-%s.php", $ext_name);
+ // Shorter way
+ return (
+ (
+ ($active == "Y") || (
+ (IS_ADMIN()) &&
+ (!$ignore_admin) &&
+ (!empty($active))
+ )
+ ) && (
+ file_exists($inc)
+ ) && (
+ is_readable($inc)
+ )
+ );
+}
+//
+function GET_EXT_VERSION ($ext_name)
+{
+ global $EXTENSIONS, $CONFIG;
+ // Extensions are all inactive during installation
+ if ((!mxchange_installed) || (mxchange_installing)) return "";
+
+ // Is the cache written?
+ if (!empty($EXTENSIONS['ext_version'][$ext_name]))
+ {
+ // Load data from cache
+ $ret = $EXTENSIONS['ext_version'][$ext_name];
+
+ // Count cache hits
+ if (isset($CONFIG['cache_hits'])) $CONFIG['cache_hits']++;
+ }
+ else
+ {
+ // Load from database
+ $result = SQL_QUERY_ESC("SELECT ext_version FROM "._MYSQL_PREFIX."_extensions WHERE ext_name='%s' LIMIT 1",
+ array($ext_name), __FILE__, __LINE__);
+ list($ret) = SQL_FETCHROW($result);
+ SQL_FREERESULT($result);
+
+ // Set cache
+ $EXTENSIONS['ext_version'][$ext_name] = $ret;
+ }
+ return $ret;
+}
+//
+function EXTENSION_UPDATE($file, $ext, $EXT_VER, $dry_run=false)
+{
+ // This shall never do a non-admin user!
+ global $CACHE, $CONFIG, $NOTES; $SQLs = array();
+ if ((!IS_ADMIN()) || (empty($ext))) return false;
+
+ // Load extension in update mode
+ $EXT_LOAD_MODE = "update"; $EXT_UPDATE_DEPENDS = ""; $NOTES = "";
+ include(PATH."inc/extensions/".$file);
+ if (!empty($EXT_UPDATE_DEPENDS))
+ {
+ // Update another extension first!
+ $test = EXTENSION_UPDATE(("ext-".$EXT_UPDATE_DEPENDS.".php"), $EXT_UPDATE_DEPENDS, GET_EXT_VERSION($EXT_UPDATE_DEPENDS), $dry_run);
+ }
+
+ // Check if version is updated
+ if ((($EXT_VERSION != $EXT_VER) || ($dry_run)) && (is_array($EXT_VER_HISTORY)))
+ {
+ // Search for starting point
+ $start = array_search($EXT_VER, $EXT_VER_HISTORY);
+ $NOTES = "";
+
+ // And load SQL queries in order of version history
+ for ($idx = ($start + 1); $idx < sizeof($EXT_VER_HISTORY); $idx++)
+ {
+ // Remove old SQLs array to prevent possible bugs
+ if (!$dry_run) { unset($SQLs); $SQLs = array(); }
+
+ // Set version
+ $EXT_VER = $EXT_VER_HISTORY[$idx];
+
+ // Include again...
+ include(PATH."inc/extensions/".$file);
+
+ // Add notes
+ if ($CONFIG['verbose_sql'] == "Y")
+ {
+ $EXT_VER = $EXT_VER_HISTORY[$idx];
+ if (!empty($UPDATE_NOTES))
+ {
+ // Update notes found
+ $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR>".$UPDATE_NOTES."<BR><BR>\n";
+ $UPDATE_NOTES = "";
+ }
+ elseif ($EXT_VER == "0.0")
+ {
+ // Initial release
+ $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR>".INITIAL_RELEASE."<BR><BR>\n";
+ }
+ else
+ {
+ $NOTES .= "<STRONG>v".$EXT_VER.":</STRONG><BR><I>".NO_UPDATE_NOTES."</I><BR><BR>\n";
+ }
+ }
+
+ // Run SQLs
+ if ((is_array($SQLs)) && (!$dry_run))
+ {
+ // Run SQL commands
+ foreach ($SQLs as $sql)
+ {
+ $sql = trim($sql);
+ if (!empty($sql))
+ {
+ // Run SQL command...
+ $result = SQL_QUERY($sql, __FILE__, __LINE__, false);
+ }
+ }
+ } elseif (GET_EXT_VERSION("sql_patches") == "") {
+ // Remove SQLs if extension is not installed
+ $SQLs = array();
+ }
+ }
+
+ if (!$dry_run)
+ {
+ // In normal mode insert task and update extension's version...
+ $ext_subj = "[UPDATE-".$ext."-".$EXT_VERSION.":] ".ADMIN_UPDATE_EXT_SUBJ;
+
+ // Create task
+ $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE subject='%s' LIMIT 1",
+ array($ext_subj), __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) == 0)
+ {
+ // Task not created so it's a brand-new extension which we need to register and create a task for!
+ $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_task_system (assigned_admin, userid, status, task_type, subject, text, task_created) VALUES ('%s', '0', 'NEW', 'EXTENSION_UPDATE', '%s', '%s', UNIX_TIMESTAMP())",
+ array(GET_ADMIN_ID(SQL_ESCAPE($_COOKIE['admin_login'])), $ext_subj, addslashes($NOTES)), __FILE__, __LINE__);
+ }
+
+ // Free memory
+ SQL_FREERESULT($result);
+
+ // Update extension's version
+ $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_version='%s' WHERE ext_name='%s' LIMIT 1",
+ array($EXT_VERSION, $ext), __FILE__, __LINE__);
+
+ // Update cache
+ if (EXT_IS_ACTIVE("cache"))
+ {
+ if ($CACHE->cache_file("extensions", true) == true) $CACHE->cache_destroy();
+ if ($CACHE->cache_file("config", true) == true) $CACHE->cache_destroy();
+ if ($CACHE->cache_file("mod_reg", true) == true) $CACHE->cache_destroy();
+ }
+
+ // Remove array
+ unset($SQLs);
+ }
+ else
+ {
+ // In "dry-run" mode return array with SQL commands
+ return $SQLs;
+ }
+ }
+}
+//
+function EXTENSION_VERBOSE_TABLE($SQLs, $title=ADMIN_SQLS_EXECUTED_ON_REMOVAL, $dashed="", $switch=false, $WIDTH="480")
+{
+ global $CONFIG;
+
+ $S = false; $SW = 2; $i = 1;
+ $OUT = "";
+ if ((is_array($SQLs)) && (GET_EXT_VERSION("sql_patches")) && ($CONFIG['verbose_sql'] == "Y"))
+ {
+ $OUT = "<DIV align=\"center\">
+<TABLE border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"".$WIDTH."\" align=\"center\"".$dashed.">
+<TR>
+ <TD colspan=\"2\" align=\"center\" class=\"admin_title bottom2\" height=\"24\">
+ <STRONG>".$title.":</STRONG>
+ </TD>
+</TR>\n";
+ foreach ($SQLs as $idx=>$sql)
+ {
+ $sql = trim($sql);
+ if (!empty($sql))
+ {
+ $S = true;
+ $OUT .= "<TR>
+ <TD class=\"switch_sw".(3 - $SW)." bottom2\" style=\"padding-left: 2px\" width=\"30\">".$i.".</TD>
+ <TD class=\"switch_sw".(3 - $SW)." bottom2\" style=\"padding-left: 5px; padding-right: 5px\">
+ ".$sql."
+ </TD>
+</TR>\n";
+ if ($switch) $SW = 3 - $SW;
+ $i++;
+ }
+ }
+ }
+
+ if ((!$S) && (GET_EXT_VERSION("sql_patches")) && ($CONFIG['verbose_sql'] == "Y"))
+ {
+ // No addional SQL commands to run
+ $OUT .= "<TR>
+ <TD colspan=\"2\" align=\"center\" class=\"switch_sw2 bottom2\" height=\"24\">
+ <FONT class=\"admin_note\">".ADMIN_NO_ADDIONAL_SQLS."</FONT>
+ </TD>
+</TR>\n";
+ }
+
+ if (!empty($OUT)) {
+ // Add missing close-table tag
+ $OUT .= "</TABLE>
+</DIV>\n";
+ }
+ return $OUT;
+}
+//
+function GET_EXT_NAME($id)
+{
+ $ret = "";
+ global $EXTENSIONS, $CONFIG;
+ if (!empty($EXTENSIONS['ext_id'][$id]))
+ {
+ // Load from cache
+ $ret = $EXTENSIONS['ext_id'][$id];
+
+ // Count cache hits
+ $CONFIG['cache_hits']++;
+ }
+ else
+ {
+ // Load from database
+ $result = SQL_QUERY_ESC("SELECT ext_name FROM "._MYSQL_PREFIX."_extensions WHERE id=%d LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__);
+ list($ret) = SQL_FETCHROW($result);
+ SQL_FREERESULT($result);
+ }
+ return $ret;
+}
+//
+function GET_EXT_ID($name)
+{
+ $ret = "0";
+ global $EXTENSIONS, $CONFIG;
+ if ((isset($EXTENSIONS['ext_id'])) && (is_array($EXTENSIONS['ext_id'])))
+ {
+ // Load from cache
+ $ret = array_search($name, $EXTENSIONS['ext_id']);
+
+ // Count cache hits
+ $CONFIG['cache_hits']++;
+ }
+ else
+ {
+ // Load from database
+ $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_extensions WHERE ext_name='%s' LIMIT 1",
+ array($name), __FILE__, __LINE__);
+ list($ret) = SQL_FETCHROW($result);
+ SQL_FREERESULT($result);
+ }
+ return $ret;
+}
+//
+?>