X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-extensions.php;h=5e129636a35d532524ab9beaf5bc2527737fdfb6;hp=c6cecbd8e5018277abf7d9b751f73b1224e982ba;hb=330dbb3e2b34450cd1665497506455e195a0a166;hpb=2abf1ab70c824b92934910d9f5da3c37fe089c47 diff --git a/inc/modules/admin/what-extensions.php b/inc/modules/admin/what-extensions.php index c6cecbd8e5..5e129636a3 100644 --- a/inc/modules/admin/what-extensions.php +++ b/inc/modules/admin/what-extensions.php @@ -1,7 +1,7 @@ 0) && (!isDemoModeActive())) { + $do = 'register'; + $taskId = determineExtensionTaskId(getRequestParameter('reg_ext')); + + // The id comes from task management and it is - of course - *not* the extension's name! +} elseif ((isFormSent('change')) && (ifPostContainsSelections()) && (!isDemoModeActive())) { // De-/activate extensions - foreach (postRequestElement('sel') as $ext_id => $active) { + foreach (postRequestParameter('sel') as $ext_id => $ext_active) { // Shall we keep the extension always active? - if ((isset($GLOBALS['cache_array']['active_extensions'][getExtensionName($ext_id)])) && ($GLOBALS['cache_array']['active_extensions'][getExtensionName($ext_id)] == 'Y') && ($active != 'Y')) { + if ((isset($GLOBALS['cache_array']['always_active'][getExtensionName($ext_id)])) && ($GLOBALS['cache_array']['always_active'][getExtensionName($ext_id)] == 'Y') && ($ext_active == 'Y')) { // Keep this extension active! + displayMessage('{%message,ADMIN_EXTENSION_ALWAYS_ACTIVE=' . $ext_id . '%}'); } else { - // De/activate extension - $ACT = 'N'; getExtensionMode('deactivate'); - if ($active != 'Y') { $ACT = 'Y'; setExtensionMode('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__); + // Deactivation is default + $active = 'N'; + setExtensionMode('deactivate'); + + // Is the extension deactivated? + if ($ext_active != 'Y') { + // Then we can activate it + $active = 'Y'; + setExtensionMode('activate'); + } // END - if + + // Update database + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_extensions` SET `ext_active`='%s' WHERE `id`=%s AND `ext_active`='%s' LIMIT 1", + array($active, bigintval($ext_id), $ext_active), __FILE__, __LINE__); // Run embeded SQL commands doExtensionSqls($ext_id, getExtensionMode()); } - } -} elseif (((isPostRequestElementSet('edit')) || (isPostRequestElementSet(('modify')))) && ($SEL > 0) && (!isDemoModeActive())) { + } // END - foreach + + // Redirect to prevent missing cache in js.php + redirectToUrl('modules.php?module=admin&what=extensions&changed=' . countPostSelection()); +} elseif (((isFormSent('edit')) || (isPostRequestParameterSet('modify'))) && (ifPostContainsSelections()) && (!isDemoModeActive())) { // Change settings like CSS file load - if (isPostRequestElementSet(('modify'))) { + if (isPostRequestParameterSet('modify')) { // Change entries - $cache_update = 0; - foreach (postRequestElement('sel') as $ext_id => $sel) { - // Secure ID + $cache_update = '0'; + foreach (postRequestParameter('sel') as $ext_id => $sel) { + // Secure id $ext_id = bigintval($ext_id); // Change this extension? if ($sel == 1) { // Load mode is modify - getExtensionMode('modify'); + setExtensionMode('modify'); // Get entry for 'active' - $active = postRequestElement('active', $ext_id); + $active = postRequestParameter('active', $ext_id); // Update extension's record - if (getExtensionVersion('sql_patches') >= '0.0.6') { + if (isExtensionInstalledAndNewer('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(postRequestElement('css', $ext_id), $active, $ext_id), __FILE__, __LINE__); + array(postRequestParameter('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", @@ -105,47 +112,48 @@ if (isGetRequestElementSet('reg_ext')) { // Run SQLs on activation / deactivation switch ($active) { - case 'Y': getExtensionMode('activate'); break; - case 'N': getExtensionMode('deactivate'); break; - } // END - if + case 'Y': setExtensionMode('activate'); break; + case 'N': setExtensionMode('deactivate'); break; + } // END - switch // Run embeded SQL commands doExtensionSqls($ext_id, getExtensionMode()); - } - } + } // END - if + } // END - foreach - // Extensions changed - loadTemplate('admin_settings_saved', false, getMessage('ADMIN_EXT_CHANGED')); + // Redirect to prevent missing cache in js.php + redirectToUrl('modules.php?module=admin&what=extensions&edited=' . countPostSelection()); } else { // Edit selected entries - $SW = 2; $OUT = ''; - foreach (postRequestElement('sel') as $ext_id => $sel) { + $OUT = ''; + foreach (postRequestParameter('sel') as $ext_id => $sel) { // Edit this extension? if (($sel == 'Y') || ($sel != 'Y')) { // Default is no CSS for non-updated mailers $css = 'N'; // Load required data - if (getExtensionVersion('sql_patches') >= '0.0.6') { - $result = SQL_QUERY_ESC("SELECT ext_has_css, ext_active FROM `{?_MYSQL_PREFIX?}_extensions` WHERE `id`=%s LIMIT 1", + if (isExtensionInstalledAndNewer('sql_patches', '0.0.6')) { + $result = SQL_QUERY_ESC("SELECT `ext_has_css`, `ext_active` FROM `{?_MYSQL_PREFIX?}_extensions` WHERE `id`=%s LIMIT 1", array(bigintval($ext_id)), __FILE__, __LINE__); list($css, $active) = SQL_FETCHROW($result); SQL_FREERESULT($result); } else { - $result = SQL_QUERY_ESC("SELECT ext_active FROM `{?_MYSQL_PREFIX?}_extensions` WHERE `id`=%s LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `ext_active` FROM `{?_MYSQL_PREFIX?}_extensions` WHERE `id`=%s LIMIT 1", array(bigintval($ext_id)), __FILE__, __LINE__); list($active) = SQL_FETCHROW($result); SQL_FREERESULT($result); $css = 'X'; } - // Output row + // Prepare CSS column $cssSelection = '---'; - if (getExtensionVersion('sql_patches') >= '0.0.6') $cssSelection = addSelectionBox('yn', $css, 'css', $ext_id); + if (isExtensionInstalledAndNewer('sql_patches', '0.0.6')) { + $cssSelection = addSelectionBox('yn', $css, 'css', $ext_id); + } // END - if // Prepare data for the row template $content = array( - 'sw' => $SW, 'id' => $ext_id, 'name' => getExtensionName($ext_id), 'active' => addSelectionBox('yn', $active, 'active', $ext_id), @@ -154,18 +162,17 @@ if (isGetRequestElementSet('reg_ext')) { // Load row template and switch color $OUT .= loadTemplate('admin_extensions_edit_row', true, $content); - $SW = 3 - $SW; - } + } // END - if } // END - foreach // Load template loadTemplate('admin_extensions_edit', false, $OUT); $do = 'edit'; } -} elseif ((isPostRequestElementSet('delete')) && ($SEL > 0) && (!isDemoModeActive())) { +} elseif ((isPostRequestParameterSet('delete')) && (ifPostContainsSelections()) && (!isDemoModeActive())) { // List extensions and when verbose is enabled SQL statements which will be executed - $OUT = ''; $SW = 2; - foreach (postRequestElement('sel') as $ext_id => $sel) { + $OUT = ''; + foreach (postRequestParameter('sel') as $ext_id => $sel) { // Init variables $VERBOSE_OUT = ''; initSqls(); @@ -178,9 +185,10 @@ if (isGetRequestElementSet('reg_ext')) { // Get extension name $ext_name = getExtensionName($ext_id); - if (getConfig('verbose_sql') == 'Y') { + // Listing of SQLs enabled? + if (isVerboseSqlEnabled()) { // Load SQL commands in remove mode - if (loadExtension($ext_name, 'remove', '', true)) { + if (loadExtension($ext_name, 'remove', '0.0.0', true)) { // Generate extra table with loaded SQL commands $VERBOSE_OUT = addExtensionVerboseSqlTable(); } // END - if @@ -188,10 +196,8 @@ if (isGetRequestElementSet('reg_ext')) { // Prepare data for the row template $content = array( - 'sw' => $SW, 'id' => $ext_id, 'ext_name' => $ext_name, - 'ext_ver' => getExtensionVersion($ext_name), 'verbose' => $VERBOSE_OUT ); @@ -200,24 +206,22 @@ if (isGetRequestElementSet('reg_ext')) { } else { // Prepare data for the row template $content = array( - 'sw' => $SW, 'id' => $ext_id ); // Not valid! $OUT .= loadTemplate('admin_extensions_delete_row_404', true, $content); } - $SW = 3 - $SW; } // END - foreach // Load template loadTemplate('admin_extensions_delete', false, $OUT); $do = 'delete'; -} elseif ((isPostRequestElementSet('remove')) && ($SEL > 0) && (!isDemoModeActive())) { +} elseif ((isFormSent('do_delete')) && (ifPostContainsSelections()) && (!isDemoModeActive())) { // Remove extensions from DB (you have to delete all files manually!) - $cache_update = 0; - foreach (postRequestElement('sel') as $ext_id => $active) { - // Secure ID number + $cache_update = '0'; + foreach (postRequestParameter('sel') as $ext_id => $active) { + // Secure id number $ext_id = bigintval($ext_id); // Is this extension selected and id valid? @@ -227,20 +231,45 @@ if (isGetRequestElementSet('reg_ext')) { } // END - if } // END - foreach - // Extensions removed - loadTemplate('admin_settings_saved', false, sprintf(getMessage('ADMIN_EXTENSIONS_REMOVED'), $SEL)); -} elseif ((isGetRequestElementSet('do')) && (!isDemoModeActive())) { + // Redirect to prevent missing cache in js.php + redirectToUrl('modules.php?module=admin&what=extensions&removed=' . countPostSelection()); +} elseif ((isGetRequestParameterSet('do')) && (!isDemoModeActive())) { // Other things to do - $do = SQL_ESCAPE(secureString(getRequestElement('do'))); -} elseif (isGetRequestElementSet('do')) { + $do = SQL_ESCAPE(secureString(getRequestParameter('do'))); +} elseif (isGetRequestParameterSet('do')) { // Demo mode active! $do = 'demo'; +} elseif (isGetRequestParameterSet('registered')) { + // Extensions changed + displayMessage('{%message,ADMIN_EXTENSION_REGISTERED=' . getExtensionName(getRequestParameter('registered')) . '%}'); + + // Show next link + if (isExtensionActive('task')) { + loadTemplate('admin_next_link', false, array( + 'url' => 'modules.php?module=admin&what=list_task', + 'title' => '{--ADMIN_EXTENSION_REGISTER_NEXT_LINK--}' + )); + } else { + loadTemplate('admin_next_link', false, array( + 'url' => 'modules.php?module=admin', + 'title' => '{--ADMIN_EXTENSION_REGISTER_NEXT_LINK--}' + )); + } +} elseif (isGetRequestParameterSet('changed')) { + // Extensions changed + displayMessage('{%message,ADMIN_EXTENSION_CHANGED=' . bigintval(getRequestParameter('changed')) . '%}'); +} elseif (isGetRequestParameterSet('edited')) { + // Extensions changed + displayMessage('{%message,ADMIN_EXTENSION_EDITED=' . bigintval(getRequestParameter('edited')) . '%}'); +} elseif (isGetRequestParameterSet('removed')) { + // Extensions changed + displayMessage('{%message,ADMIN_EXTENSIONS_REMOVED=' . bigintval(getRequestParameter('removed')) . '%}'); } // Shall we display active/inactive extensions? $where = ''; -if (isGetRequestElementSet(('active'))) { - $where = sprintf("WHERE `ext_active`='%s'", SQL_ESCAPE(secureString(getRequestElement('active')))); +if (isGetRequestParameterSet('active')) { + $where = sprintf("WHERE `ext_active`='%s'", SQL_ESCAPE(secureString(getRequestParameter('active')))); } // END - if // Case selection @@ -248,42 +277,48 @@ switch ($do) { case 'overview': // List all registered extensions if (isExtensionInstalledAndNewer('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` + $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` ASC", __FILE__, __LINE__); +ORDER BY + `ext_name` ASC", __FILE__, __LINE__); } 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` + $result = SQL_QUERY("SELECT + `id` AS `ext_id`, + `ext_name`, + `ext_active`, + `ext_version` +FROM + `{?_MYSQL_PREFIX?}_extensions` ".$where." -ORDER BY `ext_name` ASC", __FILE__, __LINE__); +ORDER BY + `ext_name` ASC", __FILE__, __LINE__); } // Are there some entries? - if (SQL_NUMROWS($result) > 0) { + if (!SQL_HASZERONUMS($result)) { // Extensions are registered - $OUT = ''; $SW = 2; + $OUT = ''; while ($content = SQL_FETCHARRAY($result)) { // Prepare CSS selection output $cssSelection = '---'; - if (getExtensionVersion('sql_patches') >= '0.0.6') $cssSelection = translateYesNo($content['ext_css']); + if (isExtensionInstalledAndNewer('sql_patches', '0.0.6')) { + $cssSelection = '{%pipe,translateYesNo=' . $content['ext_css'] . '%}'; + } // END - if // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $content['ext_id'], - 'name' => $content['ext_name'], - 'active' => translateYesNo($content['ext_active']), - 'act_val' => $content['ext_active'], - 'css' => $cssSelection, - 'ver' => $content['ext_version'], - ); + $content['ext_css'] = $cssSelection; // Load row template and switch color $OUT .= loadTemplate('admin_extensions_row', true, $content); - $SW = 3 - $SW; - } + } // END - while // Free memory SQL_FREERESULT($result); @@ -292,31 +327,29 @@ ORDER BY `ext_name` ASC", __FILE__, __LINE__); loadTemplate('admin_extensions', false, $OUT); } else { // No extensions are registered - loadTemplate('admin_settings_saved', false, getMessage('ADMIN_NO_EXTENSION_REGISTERED')); + displayMessage('{--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", - array(getCurrentAdminId()), __FILE__, __LINE__); - $task_found = SQL_NUMROWS($result); + // Do we have some tasks? + $numTasks = countSumTotalData(getCurrentAdminId(), 'task_system', 'id', 'assigned_admin', true, "AND `task_type`='EXTENSION'"); - // Free result - SQL_FREERESULT($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) + // Is the id number valid and the task was found? + if (($taskId > 0) && ($numTasks > 0)) { + // 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); + array(bigintval($taskId)), __FILE__, __LINE__); + list($subject) = SQL_FETCHROW($result); + + // Free result SQL_FREERESULT($result); // Disable cache update by default - $cache_update = 0; - if (!empty($subj)) { + $cache_update = '0'; + if (!empty($subject)) { // Extract extension's name from subject... - $ext_name = trim(substr($subj, 1, strpos($subj, ':') - 1)); + $ext_name = trim(substr($subject, 1, strpos($subject, ':') - 1)); // Test the extension for deprecation loadExtension($ext_name, 'test'); @@ -324,27 +357,14 @@ ORDER BY `ext_name` ASC", __FILE__, __LINE__); // Is the extension deprecated? if (!isExtensionDeprecated()) { // ... so we can finally register and load it in registration mode - if (registerExtension($ext_name, $ext_id)) { + if (registerExtension($ext_name, $taskId)) { // Errors? - if (getTotalFatalErrors() == 0) { + if (!ifFatalErrorsDetected()) { // Extension was found and successfully registered - loadTemplate('admin_settings_saved', false, sprintf(getMessage('ADMIN_EXTENSION_REGISTERED'), $ext_name)); - - // Show next link - if (isExtensionActive('task')) { - loadTemplate('admin_next_link', false, array( - 'url' => 'modules.php?module=admin&what=list_task', - 'title' => getMessage('ADMIN_EXT_REGISTER_NEXT_LINK') - )); - } else { - loadTemplate('admin_next_link', false, array( - 'url' => 'modules.php?module=admin', - 'title' => getMessage('ADMIN_EXT_REGISTER_NEXT_LINK') - )); - } + redirectToUrl('modules.php?module=admin&what=extensions&registered=' . getExtensionId($ext_name)); } else { // Errors detected! - loadTemplate('admin_settings_saved', false, sprintf(getMessage('ADMIN_EXTENSION_NOT_REGISTERED'), $ext_name)); + displayMessage('{%message,ADMIN_EXTENSION_NOT_REGISTERED=' . $ext_name . '%}'); } // Do we need to update cache file? @@ -353,36 +373,37 @@ ORDER BY `ext_name` ASC", __FILE__, __LINE__); // Remove cache file (will be auto-created again!) if ($GLOBALS['cache_instance']->loadCacheFile('config')) $GLOBALS['cache_instance']->removeCacheFile(); if ($GLOBALS['cache_instance']->loadCacheFile('extension')) $GLOBALS['cache_instance']->removeCacheFile(); + if ($GLOBALS['cache_instance']->loadCacheFile('filter')) $GLOBALS['cache_instance']->removeCacheFile(); if ($GLOBALS['cache_instance']->loadCacheFile('modules')) $GLOBALS['cache_instance']->removeCacheFile(); } // END - if - } elseif (getExtensionVersion($ext_name) != '') { + } elseif (isExtensionInstalled($ext_name)) { // Notify the admin that we have a problem here... - loadTemplate('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_ALREADY')); + displayMessage('{--ADMIN_EXTENSION_REGISTRATION_FAILED_ALREADY--}'); } else { // Notify the admin that we have a problem here... - loadTemplate('admin_settings_saved', false, sprintf(getMessage('ADMIN_REG_FAILED_404'), $ext_name)); + displayMessage('{%message,ADMIN_EXTENSION_REGISTRATION_FAILED_404=' . $ext_name . '%}'); } } else { // Motify the admin that we have a problem here... - loadTemplate('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_DEPRECATED')); + displayMessage('{--ADMIN_EXTENSION_REGISTRATION_FAILED_DEPRECATED--}'); } } else { // Extension was not found in task management - loadTemplate('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_ID_404')); + displayMessage('{--ADMIN_EXTENSION_REGISTRATION_FAILED_ID_404--}'); } - } elseif ($task_found == '0') { + } elseif ($numTasks == '0') { // No longer assigned or old task - loadTemplate('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_ASSIGED')); + displayMessage('{--ADMIN_EXTENSION_REGISTRATION_FAILED_ASSIGED--}'); } else { - // ID is invalid - loadTemplate('admin_settings_saved', false, getMessage('ADMIN_REG_FAILED_INVALID')); + // id is invalid + displayMessage('{--ADMIN_EXTENSION_REGISTRATION_FAILED_INVALID--}'); } break; case 'demo': - loadTemplate('admin_settings_saved', false, getMessage('SETTINGS_NOT_SAVED')); + displayMessage('{--SETTINGS_NOT_SAVED--}'); break; -} +} // END - switch // [EOF] ?>