X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions.php;h=68f89a1954b3e8689e59ace083a41de4d71f5117;hp=c6721cc0100bb50e4e4f16f94f0bbed1d8ed967d;hb=6c763653e88b9d10627e651ca59c7201d4b7d62b;hpb=07a07340291a560c3da7715d4d51c9b2f0d2adf2 diff --git a/inc/extensions.php b/inc/extensions.php index c6721cc010..68f89a1954 100644 --- a/inc/extensions.php +++ b/inc/extensions.php @@ -37,13 +37,76 @@ if (!defined('__SECURITY')) { require($INC); } +// Load the extension and maybe found language and function files. +function LOAD_EXTENSION ($ext_name, $EXT_LOAD_MODE = "") { + global $EXT_LOADED, $_CONFIG, $CSS, $cacheMode; + + // Is the extension already loaded? + //* DEBUG: */ echo "Loading extension {$ext_name}.
\n"; + if (isset($EXT_LOADED[$ext_name])) { + // Debug message + DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Extension %s already loaded.", $ext_name)); + return false; + } + + // Construct FQFN for extension file + $extInclude = sprintf("%sinc/extensions/ext-%s.php", PATH, $ext_name); + + // Is the extension file NOT there? + if (!FILE_READABLE($extInclude)) { + // Debug message + DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Extension %s not found.", $ext_name)); + + // Abort here + return false; + } // END - if + + // Construct FQFN for language file + $langInclude = sprintf("%sinc/language/%s_%s.php", PATH, $ext_name, GET_LANGUAGE()); + + // Is this include there? + if (FILE_READABLE($langInclude)) { + // Then load it + //* DEBUG: */ echo "--- Language loaded.
\n"; + require($langInclude); + } // END - if + + // Construct FQFN for functions file + $funcsInclude = sprintf("%sinc/libs/%s_functions.php", PATH, $ext_name); + + // Is this include there? + if (FILE_READABLE($funcsInclude)) { + // Then load it + //* DEBUG: */ echo "--- Functions loaded.
\n"; + require($funcsInclude); + } // END - if + + // Extensions are not deprecated by default + $EXT_DEPRECATED = "N"; + + // Include the extension file + //* DEBUG: */ echo "Extension loaded.
\n"; + require($extInclude); + + // Is this extension deprecated? + if ($EXT_DEPRECATED == "Y") { + // Deactivate the extension + DEACTIVATE_EXTENSION($ext_name); + + // Abort here + return false; + } // END - if + + // Mark it as loaded + $EXT_LOADED[$ext_name] = true; + + // All fine! + return true; +} + // -function EXTENSION_REGISTER ($ext_name, $id, $dry_run=false) -{ +function EXTENSION_REGISTER ($ext_name, $id, $dry_run=false) { global $NOTES, $_CONFIG, $INC_POOL, $cacheInstance; - // 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; @@ -51,20 +114,31 @@ function EXTENSION_REGISTER ($ext_name, $id, $dry_run=false) // Is this extension already installed? if (EXT_IS_ACTIVE($ext_name)) return false; + // 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(); + + // By default the language prefix is the extension's name + // @TODO: Do we really need this one anymore? Can't we just take $ext_name and done? + // By default we have no failtures + $EXT_REPORTS_FAILURE = false; + // Generate file name $file = sprintf("%sinc/extensions/ext-%s.php", PATH, $ext_name); // Does this extension exists? - if (FILE_READABLE($file)) - { + if (FILE_READABLE($file)) { // Extension was found so we can load it in registration mode + $EXT_ALWAYS_ACTIVE = "N"; require($file); // And run possible updates $EXT_LOAD_MODE = "update"; $EXT_UPDATE_DEPENDS = ""; - foreach ($EXT_VER_HISTORY as $EXT_VER) - { + foreach ($EXT_VER_HISTORY as $EXT_VER) { + // Load extension in update mode require($file); + + // Do we have an update? if (((GET_EXT_VERSION("sql_patches") != "") && ($_CONFIG['verbose_sql'] == "Y")) || (!EXT_IS_ACTIVE("sql_patches"))) { if (!empty($UPDATE_NOTES)) { // Update notes found @@ -77,60 +151,70 @@ function EXTENSION_REGISTER ($ext_name, $id, $dry_run=false) // No update notes found! $NOTES .= "v".$EXT_VER.":
".NO_UPDATE_NOTES."

\n"; } - } - } + } // END - if + } // END - foreach // Does this extension depends on an outstanding update of another update? - if (!empty($EXT_UPDATE_DEPENDS)) - { + 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; $EXT_ALWAYS_ACTIVE = "N"; + $SQLs2 = $SQLs; + $SQLs = array(); + $test = false; // Load required extension also in update mode $file = sprintf("%sinc/extensions/ext-%s.php", PATH, $EXT_UPDATE_DEPENDS); // Check for required file - if (FILE_READABLE($file)) - { - // File exists so let's load it + if (FILE_READABLE($file)) { + // Bacup version number $VER_BACKUP = $EXT_VERSION; + + // Save the Parrent $EXT_ALWAYS_ACTIVE for later! + $EXT_ALWAYS_ACTIVE_PARRENT = $EXT_ALWAYS_ACTIVE; + + // Set EXT_ALWAYS_ACTIVE for update + $EXT_ALWAYS_ACTIVE = "N"; + + // File exists so let's load it 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 version set? If empty the extension is not registered + 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) - { + + // Entry found? + if (SQL_NUMROWS($result) == 1) { // Task found so load task's ID and register extension... list($task) = SQL_FETCHROW($result); - SQL_FREERESULT($result); + + // Try to register the extension $test = EXTENSION_REGISTER($EXT_UPDATE_DEPENDS, $task, $dry_run); - } - } - elseif ($ext_ver != $EXT_VERSION) - { + } // END - if + + // Free result + SQL_FREERESULT($result); + } elseif ($ext_ver != $EXT_VERSION) { // Ok, update this extension now EXTENSION_UPDATE(basename($file), $EXT_UPDATE_DEPENDS, $ext_ver, $dry_run); // All okay! $test = true; - } - else - { + } else { // Nothing to register / update before... $test = true; } - } - else - { + + // Restore version number + $EXT_VERSION = $VER_BACKUP; + + // Restore $EXT_ALWAYS_ACTIVE with the value from parrent + $EXT_ALWAYS_ACTIVE = $EXT_ALWAYS_ACTIVE_PARRENT; + } else { // Required file for update does not exists! $test = true; // But this is fine for the first time... @@ -138,10 +222,7 @@ function EXTENSION_REGISTER ($ext_name, $id, $dry_run=false) // Finally restore previous SQLs $SQLs = $SQLs2; unset($SQLs2); - $EXT_LANG_PREFIX = $LANG_BCK; - } - else - { + } else { // Does not depend on an other extension $test = true; } @@ -149,6 +230,9 @@ function EXTENSION_REGISTER ($ext_name, $id, $dry_run=false) // Switch back to register mode $EXT_LOAD_MODE = "register"; + // Remains true if extension registration reports no failtures + $test = ($test && !$EXT_REPORTS_FAILURE); + // Does everthing before wents ok? if ($test) { // "Dry-run-mode" activated? @@ -175,9 +259,9 @@ function EXTENSION_REGISTER ($ext_name, $id, $dry_run=false) if ((EXT_IS_ACTIVE("cache")) || (GET_EXT_VERSION("cache") != "")) { //* DEBUG: */ echo __LINE__.": DESTROY!
\n"; // Remove cache files - 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(); + if ($cacheInstance->loadCacheFile("extensions", true)) $cacheInstance->destroyCacheFile(); + if ($cacheInstance->loadCacheFile("mod_reg")) $cacheInstance->destroyCacheFile(); + if ($cacheInstance->loadCacheFile("config")) $cacheInstance->destroyCacheFile(); } // END - if // Check for added include files @@ -186,11 +270,14 @@ function EXTENSION_REGISTER ($ext_name, $id, $dry_run=false) foreach ($INC_POOL as $inc) { require_once($inc); } // END - foreach + + // Remove array + unset($INC_POOL); } // END - if // Register extension - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_extensions (ext_name, ext_lang_file, ext_active, ext_version) VALUES ('%s', '%s', '%s', '%s')", - array($ext_name, $EXT_LANG_PREFIX, $EXT_ALWAYS_ACTIVE, $EXT_VERSION), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_extensions (ext_name, ext_active, ext_version) VALUES ('%s','%s','%s')", + array($ext_name, $EXT_ALWAYS_ACTIVE, $EXT_VERSION), __FILE__, __LINE__); // Update task management ADMIN_SOLVE_TASK($id); @@ -239,9 +326,12 @@ function EXTENSION_REGISTER ($ext_name, $id, $dry_run=false) } // function EXTENSION_RUN_SQLS($id, $EXT_LOAD_MODE) { - global $cacheInstance; + global $cacheInstance, $_CONFIG; $SQLs = array(); + // Extensions are never active by default + $EXT_ALWAYS_ACTIVE = "N"; + // By default no SQL has been executed $sqlRan = false; @@ -253,14 +343,14 @@ function EXTENSION_RUN_SQLS($id, $EXT_LOAD_MODE) { if (empty($ext_name)) return false; // Load extension in detected mode - //* DEBUG: */ echo __FUNCTION__.":ext_name[{$id}]={$ext_name}
\n"; + //* DEBUG: */ print __FUNCTION__."(".__LINE__."):ext_name[{$id}]={$ext_name}
\n"; $file = sprintf("%sinc/extensions/ext-%s.php", PATH, $ext_name); if (FILE_READABLE($file)) { // Load the include require($file); - } + } // END - if - //* DEBUG: */ echo __FUNCTION__.":SQLs::count=".count($SQLs)."
\n"; + //* DEBUG: */ print __FUNCTION__."(".__LINE__."):SQLs::count=".count($SQLs)."
\n"; if ((is_array($SQLs) && (sizeof($SQLs) > 0))) { // Run SQL commands... foreach ($SQLs as $sql) { @@ -270,7 +360,7 @@ function EXTENSION_RUN_SQLS($id, $EXT_LOAD_MODE) { // Is there still an SQL query? if (!empty($sql)) { // Do we have an "ALTER TABLE" command? - //* DEBUG: */ echo __FUNCTION__.":SQL={$SQL}
\n"; + //* DEBUG: */ print __FUNCTION__."(".__LINE__."):SQL={$SQL}
\n"; if (substr(strtolower($sql), 0, 11) == "alter table") { // Analyse the alteration command SQL_ALTER_TABLE($sql, __FILE__, __LINE__); @@ -291,19 +381,7 @@ function EXTENSION_RUN_SQLS($id, $EXT_LOAD_MODE) { array($id), __FILE__, __LINE__); } // END - if - //* DEBUG: */ echo __FUNCTION__.":mode={$EXT_LOAD_MODE}
\n"; - - // Remove cache file(s) if extension is active - if (((EXT_IS_ACTIVE("cache")) || (GET_EXT_VERSION("cache") != "")) && (((SQL_AFFECTEDROWS() == 1) && ($EXT_LOAD_MODE == "remove")) || ($sqlRan === true))) { - //* DEBUG: */ echo __LINE__.": DESTROY!
\n"; - // Remove cache files - 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(); - - // @TODO This causes the whole (!) menu cache being purged - CACHE_PURGE_ADMIN_MENU(); - } // END - if + //* DEBUG: */ print __FUNCTION__."(".__LINE__."):mode={$EXT_LOAD_MODE}
\n"; // Is this the sql_patches? //* DEBUG: */ echo __LINE__.": {$id}/{$ext_name}/{$EXT_LOAD_MODE}
\n"; @@ -313,6 +391,18 @@ function EXTENSION_RUN_SQLS($id, $EXT_LOAD_MODE) { LOAD_URL("modules.php?module=admin&logout=1&".$EXT_LOAD_MODE."=sql_patches"); } // END - if } // END - if + + // Remove cache file(s) if extension is active + if (((EXT_IS_ACTIVE("cache")) || (GET_EXT_VERSION("cache") != "")) && (((SQL_AFFECTEDROWS() == 1)) || ($sqlRan === true) || ($EXT_LOAD_MODE == "activate") || ($EXT_LOAD_MODE == "deactivate"))) { + //* DEBUG: */ echo __LINE__.": DESTROY!
\n"; + // Remove cache files + if ($cacheInstance->loadCacheFile("extensions", true)) $cacheInstance->destroyCacheFile(); + if ($cacheInstance->loadCacheFile("mod_reg")) $cacheInstance->destroyCacheFile(); + if ($cacheInstance->loadCacheFile("config")) $cacheInstance->destroyCacheFile(); + + // @TODO This causes the whole (!) menu cache being purged + CACHE_PURGE_ADMIN_MENU(); + } // END - if } // Check if given extension is active function EXT_IS_ACTIVE ($ext_name) { @@ -341,11 +431,16 @@ function EXT_IS_ACTIVE ($ext_name) { // Extension was not found! return false; } + + // Load entry list($active) = SQL_FETCHROW($result); - //* DEBUG: */ echo $ext_name."[DB]: {$active}
\n"; + + // Free result SQL_FREERESULT($result); + // Write cache array + //* DEBUG: */ echo $ext_name."[DB]: {$active}
\n"; $cacheArray['extensions']['ext_active'][$ext_name] = $active; } else { // Extension not active! @@ -353,11 +448,8 @@ function EXT_IS_ACTIVE ($ext_name) { $cacheArray['extensions']['ext_active'][$ext_name] = "N"; } - // Create FQFN for extension file - $inc = sprintf("%sinc/extensions/ext-%s.php", PATH, $ext_name); - // Debug message - //DEBUG_LOG(__FUNCTION__.": ext_name={$ext_name},active={$active}"); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, " ext_name={$ext_name},active={$active}"); // Is this extension activated? (For admins we always have active extensions...) return ($active == "Y"); @@ -369,12 +461,12 @@ function GET_EXT_VERSION ($ext_name) { // Extensions are all inactive during installation if ((!isBooleanConstantAndTrue('mxchange_installed')) || (isBooleanConstantAndTrue('mxchange_installing'))) return ""; - //* DEBUG: */ echo __FUNCTION__.": ext_name={$ext_name}
\n"; + //* DEBUG: */ print __FUNCTION__."(".__LINE__."): ext_name={$ext_name}
\n"; // Is the cache written? if (!empty($cacheArray['extensions']['ext_version'][$ext_name])) { // Load data from cache - //* DEBUG: */ echo __FUNCTION__.": CACHE!
\n"; + //* DEBUG: */ print __FUNCTION__."(".__LINE__."): CACHE!
\n"; $ret = $cacheArray['extensions']['ext_version'][$ext_name]; // Count cache hits @@ -391,35 +483,39 @@ function GET_EXT_VERSION ($ext_name) { } // Return result - //* DEBUG: */ echo __FUNCTION__.": ret={$ret}
\n"; + //* DEBUG: */ print __FUNCTION__."(".__LINE__."): ret={$ret}
\n"; return $ret; } // -function EXTENSION_UPDATE($file, $ext, $EXT_VER, $dry_run=false) -{ +function EXTENSION_UPDATE($file, $ext, $EXT_VER, $dry_run=false) { // This shall never do a non-admin user! - global $cacheInstance, $_CONFIG, $NOTES; $SQLs = array(); + global $cacheInstance, $_CONFIG, $NOTES; + + // Init arrays + $SQLs = array(); $INC_POOL = array(); + + // Only admins are allowed to update extensions 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)) - { + + // Load extension file + include(sprintf("%sinc/extensions/%s", PATH, $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))) - { + 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++) - { + 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(); } @@ -430,29 +526,30 @@ function EXTENSION_UPDATE($file, $ext, $EXT_VER, $dry_run=false) include(PATH."inc/extensions/".$file); // Add notes - if ($_CONFIG['verbose_sql'] == "Y") - { + if ($_CONFIG['verbose_sql'] == "Y") { $EXT_VER = $EXT_VER_HISTORY[$idx]; - if (!empty($UPDATE_NOTES)) - { + if (!empty($UPDATE_NOTES)) { // Update notes found $NOTES .= "v".$EXT_VER.":
".$UPDATE_NOTES."

\n"; $UPDATE_NOTES = ""; - } - elseif ($EXT_VER == "0.0") - { + } elseif ($EXT_VER == "0.0") { // Initial release $NOTES .= "v".$EXT_VER.":
".INITIAL_RELEASE."

\n"; - } - else - { + } else { $NOTES .= "v".$EXT_VER.":
".NO_UPDATE_NOTES."

\n"; } - } + } // END - if + + // In real-mode execute any existing includes + if ((!$dry_run) && (count($INC_POOL) > 0)) { + // Include all files + foreach ($INC_POOL as $fqfn) { + require_once($fqfn); + } // END - foreach + } // END - if // Run SQLs - if ((is_array($SQLs)) && (!$dry_run)) - { + if ((is_array($SQLs)) && (!$dry_run)) { // Run SQL commands foreach ($SQLs as $sql) { @@ -473,10 +570,9 @@ function EXTENSION_UPDATE($file, $ext, $EXT_VER, $dry_run=false) // Remove SQLs if extension is not installed $SQLs = array(); } - } + } // END - for - if (!$dry_run) - { + if (!$dry_run) { // In normal mode insert task and update extension's version... $ext_subj = "[UPDATE-".$ext."-".$EXT_VERSION.":] ".ADMIN_UPDATE_EXT_SUBJ; @@ -489,9 +585,9 @@ function EXTENSION_UPDATE($file, $ext, $EXT_VER, $dry_run=false) // Update cache if (EXT_IS_ACTIVE("cache")) { - if ($cacheInstance->cache_file("extensions", true) == true) $cacheInstance->cache_destroy(); - if ($cacheInstance->cache_file("config", true) == true) $cacheInstance->cache_destroy(); - if ($cacheInstance->cache_file("mod_reg", true) == true) $cacheInstance->cache_destroy(); + if ($cacheInstance->loadCacheFile("extensions", true)) $cacheInstance->destroyCacheFile(); + if ($cacheInstance->loadCacheFile("config")) $cacheInstance->destroyCacheFile(); + if ($cacheInstance->loadCacheFile("mod_reg")) $cacheInstance->destroyCacheFile(); } // END - if // Remove array @@ -502,7 +598,8 @@ function EXTENSION_UPDATE($file, $ext, $EXT_VER, $dry_run=false) } } } -// + +// Output verbose SQL table for extension function EXTENSION_VERBOSE_TABLE($SQLs, $title = ADMIN_SQLS_EXECUTED_ON_REMOVAL, $dashed = "", $switch = false, $WIDTH = "480") { global $_CONFIG; @@ -550,6 +647,7 @@ function EXTENSION_VERBOSE_TABLE($SQLs, $title = ADMIN_SQLS_EXECUTED_ON_REMOVAL, // Return output return $OUT; } + // Get extension name from id function GET_EXT_NAME ($id) { $ret = ""; @@ -559,7 +657,7 @@ function GET_EXT_NAME ($id) { $ret = $cacheArray['extensions']['ext_name'][$id]; // Count cache hits - $_CONFIG['cache_hits']++; + if (isset($_CONFIG['cache_hits'])) { $_CONFIG['cache_hits']++; } else { $_CONFIG['cache_hits'] = 1; } } elseif (!EXT_IS_ACTIVE("cache")) { // Load from database $result = SQL_QUERY_ESC("SELECT ext_name FROM "._MYSQL_PREFIX."_extensions WHERE id=%s LIMIT 1", @@ -569,6 +667,7 @@ function GET_EXT_NAME ($id) { } return $ret; } + // Get extension id from name function GET_EXT_ID($name) { $ret = 0; @@ -578,11 +677,11 @@ function GET_EXT_ID($name) { $ret = $cacheArray['extensions']['ext_id'][$name]; // Count cache hits - $_CONFIG['cache_hits']++; + if (isset($_CONFIG['cache_hits'])) { $_CONFIG['cache_hits']++; } else { $_CONFIG['cache_hits'] = 1; } } elseif (!EXT_IS_ACTIVE("cache")) { // Load from database $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_extensions WHERE ext_name='%s' LIMIT 1", - array($name), __FILE__, __LINE__); + array($name), __FILE__, __LINE__); list($ret) = SQL_FETCHROW($result); SQL_FREERESULT($result); } @@ -590,8 +689,9 @@ function GET_EXT_ID($name) { // Return value return $ret; } + // Activate given extension -function ACTIVATE_EXTENSION($ext_name) { +function ACTIVATE_EXTENSION ($ext_name) { // Activate the extension $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_active='Y' WHERE ext_name='%s' LIMIT 1", array($ext_name), __FILE__, __LINE__); @@ -602,6 +702,26 @@ function ACTIVATE_EXTENSION($ext_name) { EXTENSION_RUN_SQLS(GET_EXT_ID($ext_name), "activate"); } // END - if } + +// Deactivate given extension +function DEACTIVATE_EXTENSION($ext_name) { + // Activate the extension + $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_active='N' WHERE ext_name='%s' LIMIT 1", + array($ext_name), __FILE__, __LINE__); + + // Extension has been activated? + if (SQL_AFFECTEDROWS() == 1) { + // Then run all queries + EXTENSION_RUN_SQLS(GET_EXT_ID($ext_name), "deactivate"); + + // Create new task + CREATE_EXTENSION_DEACTIVATION_TASK($ext_name); + + // Notify the admin + SEND_ADMIN_NOTIFICATION(ADMIN_SUBJECT_EXTENSION_DEACTIVATED, "admin_ext_deactivated", array('ext_name' => $ext_name)); + } // END - if +} + // Checks wether the extension is older than given function EXT_VERSION_IS_OLDER ($ext_name, $ext_ver) { // Get current extension version @@ -614,5 +734,81 @@ function EXT_VERSION_IS_OLDER ($ext_name, $ext_ver) { // Now compare both and return the result return ($currVersion < $ext_ver); } + +// Creates a new task for updated extension +function CREATE_EXTENSION_UPDATE_TASK ($admin_id, $subject, $notes) { + // Check if task is not there + $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE subject='%s' LIMIT 1", + array($subject), __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($admin_id, $subject, $notes), __FILE__, __LINE__); + } // END - if + + // Free memory + SQL_FREERESULT($result); +} + +// Creates a new task for newly installed extension +function CREATE_NEW_EXTENSION_TASK ($admin_id, $subject, $ext) { + // Not installed and do we have created a task for the admin? + $result = SQL_QUERY_ESC("SELECT `id` FROM `"._MYSQL_PREFIX."_task_system` WHERE `subject` LIKE '%s%%' LIMIT 1", + array($subject), __FILE__, __LINE__); + if ((SQL_NUMROWS($result) == 0) && (GET_EXT_VERSION($ext) == "")) { + // Template file + $tpl = sprintf("%stemplates/%s/html/ext/ext_%s.tpl", + PATH, + GET_LANGUAGE(), + $ext + ); + + // Load text for task + if (FILE_READABLE($tpl)) { + // Load extension's own text template (HTML!) + $msg = LOAD_TEMPLATE("ext_".$ext, true); + } else { + // Load default message + $msg = LOAD_TEMPLATE("admin_new_ext", "", 0); + } + + // Task not created so it's a brand-new extension which we need to register and create a task for! + $result_insert = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_task_system (assigned_admin, userid, status, task_type, subject, text, task_created) +VALUES (%s,0,'NEW','EXTENSION','%s','%s',UNIX_TIMESTAMP())", + array( + $admin_id, + $subject, + addslashes($msg), + ), __FILE__, __LINE__, true, false + ); + } // END - if + + // Free memory + SQL_FREERESULT($result); +} + +// Creates a task for automatically deactivated (deprecated) extension +function CREATE_EXTENSION_DEACTIVATION_TASK ($ext) { + // Create subject line + $subject = sprintf("[%s:] %s", $ext, TASK_SUBJ_EXTENSION_DEACTIVATED); + + // Not installed and do we have created a task for the admin? + $result = SQL_QUERY_ESC("SELECT `id` FROM `"._MYSQL_PREFIX."_task_system` WHERE `subject` = '%s' LIMIT 1", + array($subject), __FILE__, __LINE__); + if ((SQL_NUMROWS($result) == 0) && (GET_EXT_VERSION($ext) != "")) { + // Task not created so add it + $result_insert = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_task_system (assigned_admin, userid, status, task_type, subject, text, task_created) +VALUES (0,0,'NEW','EXTENSION_DEACTIVATION','%s','%s',UNIX_TIMESTAMP())", + array( + $subject, + addslashes(LOAD_TEMPLATE("task_ext_deactivated", true, $ext)), + ), __FILE__, __LINE__, true, false + ); + } // END - if + + // Free memory + SQL_FREERESULT($result); +} + // ?>