\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 $cacheInstance;
// 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 ($cacheInstance->cache_file("extensions", true)) $cacheInstance->cache_destroy();
if ($cacheInstance->cache_file("mod_reg", true)) $cacheInstance->cache_destroy();
if ($cacheInstance->cache_file("config", true)) $cacheInstance->cache_destroy();
}
}
}
//
function EXT_IS_ACTIVE ($ext_name, $ignore_admin=false, $ignore_cache=false)
{
global $cacheArray, $_CONFIG;
// Extensions are all inactive during installation
if ((!isBooleanConstantAndTrue('mxchange_installed')) || (isBooleanConstantAndTrue('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."* ";
// Failed is the default
$ret = false;
if ((!empty($cacheArray['extensions']['ext_active'][$ext_name])) && (!$ignore_cache))
{
// Load from cache
$active = $cacheArray['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
$cacheArray['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)
)
);
}
// Get version from extensions
function GET_EXT_VERSION ($ext_name) {
global $cacheArray, $_CONFIG, $cacheInstance;
$ret = false;
// Extensions are all inactive during installation
if ((!isBooleanConstantAndTrue('mxchange_installed')) || (isBooleanConstantAndTrue('mxchange_installing'))) return "";
// Is the cache written?
if (!empty($cacheArray['extensions']['ext_version'][$ext_name])) {
// Load data from cache
$ret = $cacheArray['extensions']['ext_version'][$ext_name];
// Count cache hits
if (isset($_CONFIG['cache_hits'])) $_CONFIG['cache_hits']++; else $_CONFIG['cache_hits'] = 1;
} elseif (!is_object($cacheInstance)) {
// 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
$cacheArray['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 $cacheInstance, $_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 .= "v".$EXT_VER.": ".$UPDATE_NOTES."