$ACT = 'N'; $EXT_LOAD_MODE = 'deactivate';
if ($active == 'N') { $ACT = 'Y'; $EXT_LOAD_MODE = 'activate'; }
SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_extensions` SET `ext_active`='".$ACT."' WHERE `id`=%s AND `ext_active`='%s' LIMIT 1",
- array(bigintval($ext_id), $active), __FILE__, __LINE__);
+ array(bigintval($ext_id), $active), __FILE__, __LINE__);
// Run embeded SQL commands
EXTENSION_RUN_SQLS($ext_id, $EXT_LOAD_MODE);
if (GET_EXT_VERSION('sql_patches') >= '0.0.6') {
// Update also CSS column when extensions sql_patches is newer or exact v0.0.6
SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_extensions` SET ext_has_css='%s', `ext_active`='%s' WHERE `id`=%s LIMIT 1",
- array(REQUEST_POST('css', $ext_id), $active, $ext_id), __FILE__, __LINE__);
+ array(REQUEST_POST('css', $ext_id), $active, $ext_id), __FILE__, __LINE__);
} else {
// When extension is older than v0.0.6 there is no column for the CSS information
SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_extensions` SET `ext_active`='%s' WHERE `id`=%s LIMIT 1",
- array($active, $ext_id), __FILE__, __LINE__);
+ array($active, $ext_id), __FILE__, __LINE__);
}
// Run SQLs on activation / deactivation
// Load required data
if (GET_EXT_VERSION('sql_patches') >= '0.0.6') {
$result = SQL_QUERY_ESC("SELECT ext_name, ext_has_css, ext_active FROM `{!_MYSQL_PREFIX!}_extensions` WHERE `id`=%s LIMIT 1",
- array(bigintval($ext_id)), __FILE__, __LINE__);
+ array(bigintval($ext_id)), __FILE__, __LINE__);
list($name, $css, $active) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
} else {
$result = SQL_QUERY_ESC("SELECT ext_name, ext_active FROM `{!_MYSQL_PREFIX!}_extensions` WHERE `id`=%s LIMIT 1",
- array(bigintval($ext_id)), __FILE__, __LINE__);
+ array(bigintval($ext_id)), __FILE__, __LINE__);
list($name, $active) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
$css = "X";
// Case selection
switch ($do) {
-case "overview": // List all registered extensions
- if (GET_EXT_VERSION('sql_patches') >= '0.0.6') {
- // Load extension data with CSS informations
- $result = SQL_QUERY("SELECT id AS ext_id, ext_name, ext_active, ext_has_css AS ext_css, ext_version
+ case "overview": // List all registered extensions
+ if (GET_EXT_VERSION('sql_patches') >= '0.0.6') {
+ // Load extension data with CSS informations
+ $result = SQL_QUERY("SELECT id AS ext_id, ext_name, ext_active, ext_has_css AS ext_css, ext_version
FROM `{!_MYSQL_PREFIX!}_extensions`
".$where."
ORDER BY ext_name", __FILE__, __LINE__);
- } else {
- // Load extension data without CSS informations
- $result = SQL_QUERY("SELECT id AS ext_id, ext_name, ext_active, id, ext_version
+ } else {
+ // Load extension data without CSS informations
+ $result = SQL_QUERY("SELECT id AS ext_id, ext_name, ext_active, id, ext_version
FROM `{!_MYSQL_PREFIX!}_extensions`
".$where."
ORDER BY ext_name", __FILE__, __LINE__);
- }
+ }
- // Are there some entries?
- if (SQL_NUMROWS($result) > 0) {
- // Extensions are registered
- $OUT = ''; $SW = 2;
- while ($content = SQL_FETCHARRAY($result)) {
- // Prepare CSS selection output
- $cssSelection = '---';
- if (GET_EXT_VERSION('sql_patches') >= '0.0.6') $cssSelection = translateYesNo($content['ext_css']);
-
- // Prepare data for the row template
- $content = array(
+ // Are there some entries?
+ if (SQL_NUMROWS($result) > 0) {
+ // Extensions are registered
+ $OUT = ''; $SW = 2;
+ while ($content = SQL_FETCHARRAY($result)) {
+ // Prepare CSS selection output
+ $cssSelection = '---';
+ if (GET_EXT_VERSION('sql_patches') >= '0.0.6') $cssSelection = translateYesNo($content['ext_css']);
+
+ // Prepare data for the row template
+ $content = array(
'sw' => $SW,
'id' => $content['ext_id'],
'name' => $content['ext_name'],
'act_val' => $content['ext_active'],
'css' => $cssSelection,
'ver' => $content['ext_version'],
- );
+ );
- // Load row template and switch color
- $OUT .= LOAD_TEMPLATE("admin_extensions_row", true, $content);
- $SW = 3 - $SW;
- }
+ // Load row template and switch color
+ $OUT .= LOAD_TEMPLATE("admin_extensions_row", true, $content);
+ $SW = 3 - $SW;
+ }
- // Free memory
- SQL_FREERESULT($result);
+ // Free memory
+ SQL_FREERESULT($result);
- // Remember rows in constant for the template
- define('__EXT_ROWS', $OUT);
+ // Remember rows in constant for the template
+ define('__EXT_ROWS', $OUT);
- // Load template
- LOAD_TEMPLATE("admin_extensions");
- } else {
- // No extensions are registered
- LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_NO_EXTENSION_REGISTERED'));
- }
- break;
+ // Load template
+ LOAD_TEMPLATE("admin_extensions");
+ } else {
+ // No extensions are registered
+ LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_NO_EXTENSION_REGISTERED'));
+ }
+ break;
-case 'register': // Register new extension
- $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_task_system` WHERE `assigned_admin`=%s AND `task_type`='EXTENSION' LIMIT 1",
+ case 'register': // Register new extension
+ $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_task_system` WHERE `assigned_admin`=%s AND `task_type`='EXTENSION' LIMIT 1",
array(getCurrentAdminId()), __FILE__, __LINE__);
- $task_found = SQL_NUMROWS($result);
-
- // Free result
- SQL_FREERESULT($result);
+ $task_found = SQL_NUMROWS($result);
- // Is the ID number valid and the task was found?
- if (($ext_id > 0) && ($task_found == 1)) {
- // ID is valid so begin with registration, we first want to it's real name from task management (subject column)
- $result = SQL_QUERY_ESC("SELECT subject FROM `{!_MYSQL_PREFIX!}_task_system` WHERE `id`=%s LIMIT 1",
- array(bigintval($ext_id)), __FILE__, __LINE__);
- list($subj) = SQL_FETCHROW($result);
+ // Free result
SQL_FREERESULT($result);
- // Disable cache update by default
- $cache_update = 0;
- if (!empty($subj)) {
- // Extract extension's name from subject...
- $ext_name = trim(substr($subj, 1, strpos($subj, ':') - 1));
-
- // Test the extension for deprecation
- LOAD_EXTENSION($ext_name, 'test');
-
- // Is the extension deprecated?
- if (EXT_GET_DEPRECATED() == 'N') {
- // ... so we can finally register and load it in registration mode
- if (REGISTER_EXTENSION($ext_name, $ext_id)) {
- // Extension was found and successfully registered
- LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_EXTENSION_REGISTERED'));
-
- // Show next link
- if (EXT_IS_ACTIVE('task')) {
- LOAD_TEMPLATE('admin_next_link', false, array(
+ // Is the ID number valid and the task was found?
+ if (($ext_id > 0) && ($task_found == 1)) {
+ // ID is valid so begin with registration, we first want to it's real name from task management (subject column)
+ $result = SQL_QUERY_ESC("SELECT subject FROM `{!_MYSQL_PREFIX!}_task_system` WHERE `id`=%s LIMIT 1",
+ array(bigintval($ext_id)), __FILE__, __LINE__);
+ list($subj) = SQL_FETCHROW($result);
+ SQL_FREERESULT($result);
+
+ // Disable cache update by default
+ $cache_update = 0;
+ if (!empty($subj)) {
+ // Extract extension's name from subject...
+ $ext_name = trim(substr($subj, 1, strpos($subj, ':') - 1));
+
+ // Test the extension for deprecation
+ LOAD_EXTENSION($ext_name, 'test');
+
+ // Is the extension deprecated?
+ if (EXT_GET_DEPRECATED() == 'N') {
+ // ... so we can finally register and load it in registration mode
+ if (REGISTER_EXTENSION($ext_name, $ext_id)) {
+ // Extension was found and successfully registered
+ LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_EXTENSION_REGISTERED'));
+
+ // Show next link
+ if (EXT_IS_ACTIVE('task')) {
+ LOAD_TEMPLATE('admin_next_link', false, array(
'url' => 'modules.php?module=admin&what=list_task',
'title' => getMessage('ADMIN_EXT_REGISTER_NEXT_LINK')
- ));
- } else {
- LOAD_TEMPLATE('admin_next_link', false, array(
+ ));
+ } else {
+ LOAD_TEMPLATE('admin_next_link', false, array(
'url' => 'modules.php?module=admin',
'title' => getMessage('ADMIN_EXT_REGISTER_NEXT_LINK')
- ));
+ ));
+ }
+
+ // Do we need to update cache file?
+ // @TODO Rewrite this to a filter
+ if ((EXT_IS_ACTIVE('cache')) && ($GLOBALS['cache_mode'] != 'no')) {
+ // Remove cache file (will be auto-created again!)
+ if ($GLOBALS['cache_instance']->loadCacheFile('config')) $GLOBALS['cache_instance']->destroyCacheFile();
+ if ($GLOBALS['cache_instance']->loadCacheFile('extensions', true)) $GLOBALS['cache_instance']->destroyCacheFile();
+ if ($GLOBALS['cache_instance']->loadCacheFile('modreg')) $GLOBALS['cache_instance']->destroyCacheFile();
+ } // END - if
+ } elseif (GET_EXT_VERSION($ext_name) != '') {
+ // Notify the admin that we have a problem here...
+ LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_ALREADY'));
+ } else {
+ // Notify the admin that we have a problem here...
+ LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_REG_FAILED_404'), $ext_name));
}
-
- // Do we need to update cache file?
- // @TODO Rewrite this to a filter
- if ((EXT_IS_ACTIVE('cache')) && ($GLOBALS['cache_mode'] != 'no')) {
- // Remove cache file (will be auto-created again!)
- if ($GLOBALS['cache_instance']->loadCacheFile('config')) $GLOBALS['cache_instance']->destroyCacheFile();
- if ($GLOBALS['cache_instance']->loadCacheFile('extensions', true)) $GLOBALS['cache_instance']->destroyCacheFile();
- if ($GLOBALS['cache_instance']->loadCacheFile('modreg')) $GLOBALS['cache_instance']->destroyCacheFile();
- } // END - if
- } elseif (GET_EXT_VERSION($ext_name) != '') {
- // Notify the admin that we have a problem here...
- LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_ALREADY'));
} else {
- // Notify the admin that we have a problem here...
- LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_REG_FAILED_404'), $ext_name));
+ // Motify the admin that we have a problem here...
+ LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_DEPRECATED'));
}
} else {
- // Motify the admin that we have a problem here...
- LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_DEPRECATED'));
+ // Extension was not found in task management
+ LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_ID_404'));
}
+ } elseif ($task_found == '0') {
+ // No longer assigned or old task
+ LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_ASSIGED'));
} else {
- // Extension was not found in task management
- LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_ID_404'));
+ // ID is invalid
+ LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_INVALID'));
}
- } elseif ($task_found == '0') {
- // No longer assigned or old task
- LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_ASSIGED'));
- } else {
- // ID is invalid
- LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_INVALID'));
- }
- break;
+ break;
-case 'demo':
- LOAD_TEMPLATE('admin_settings_saved', false, getMessage('SETTINGS_NOT_SAVED'));
- break;
+ case 'demo':
+ LOAD_TEMPLATE('admin_settings_saved', false, getMessage('SETTINGS_NOT_SAVED'));
+ break;
}
//
?>
projects / mailer.git / blobdiff