X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-extensions.php;h=af439d78c36529520ced37b279243b29008437b2;hp=342fbf86b62ff03db47c2f291e637cfd721b1318;hb=cd7d344ea7007cfa20413acd3e03e50f0ab86d86;hpb=6f9ac1a702b48e3a2b87f1da0c056206c09bccc0 diff --git a/inc/modules/admin/what-extensions.php b/inc/modules/admin/what-extensions.php index 342fbf86b6..af439d78c3 100644 --- a/inc/modules/admin/what-extensions.php +++ b/inc/modules/admin/what-extensions.php @@ -14,12 +14,10 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2013 by Mailer Developer Team * + * For more information visit: http://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 * @@ -43,44 +41,59 @@ if ((!defined('__SECURITY')) || (!isAdmin())) { } // END - if // Add description as navigation point -addMenuDescription('admin', __FILE__); +addYouAreHereLink('admin', __FILE__); -// Normally we want the overview of all registered extensions +// By default generate overview of all installed extensions $do = 'overview'; -if (isGetRequestParameterSet('reg_ext')) { +if (isGetRequestElementSet('register_ext')) { // We are about to register a new extension - $do = 'register'; $taskId = bigintval(getRequestParameter('reg_ext')); + $do = 'setup'; + $taskId = determineExtensionTaskId(getRequestElement('register_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 (postRequestParameter('sel') as $taskId => $active) { + foreach (postRequestElement('sel') as $ext_id => $ext_active) { // Shall we keep the extension always active? - if ((isset($GLOBALS['cache_array']['always_active'][getExtensionName($taskId)])) && ($GLOBALS['cache_array']['always_active'][getExtensionName($taskId)] == '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! - loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_EXTENSION_ALWAYS_ACTIVE', getExtensionName($taskId))); + displayMessage('{%message,ADMIN_EXTENSION_ALWAYS_ACTIVE=' . $ext_id . '%}'); } else { - // De/activate extension - $ACT = 'N'; setExtensionMode('deactivate'); - if ($active != 'Y') { $ACT = 'Y'; setExtensionMode('activate'); } + // 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($ACT, bigintval($taskId), $active), __FILE__, __LINE__); + array( + $active, + bigintval($ext_id), + $ext_active + ), __FILE__, __LINE__); // Run embeded SQL commands - doExtensionSqls($taskId, getExtensionMode()); + doExtensionSqls($ext_id, getExtensionMode()); } } // 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())) { +} elseif (((isFormSent('edit')) || (isPostRequestElementSet('do_edit'))) && (ifPostContainsSelections()) && (!isDemoModeActive())) { // Change settings like CSS file load - if (isPostRequestParameterSet('modify')) { + if (isPostRequestElementSet('do_edit')) { // Change entries $cache_update = '0'; - foreach (postRequestParameter('sel') as $taskId => $sel) { + foreach (postRequestElement('sel') as $ext_id => $sel) { // Secure id - $taskId = bigintval($taskId); + $ext_id = bigintval($ext_id); // Change this extension? if ($sel == 1) { @@ -88,36 +101,36 @@ if (isGetRequestParameterSet('reg_ext')) { setExtensionMode('modify'); // Get entry for 'active' - $active = postRequestParameter('active', $taskId); + $active = postRequestElement('active', $ext_id); // Update extension's record 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(postRequestParameter('css', $taskId), $active, $taskId), __FILE__, __LINE__); + // Update also CSS column when extensions ext-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__); } 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, $taskId), __FILE__, __LINE__); + array($active, $ext_id), __FILE__, __LINE__); } // Run SQLs on activation / deactivation switch ($active) { case 'Y': setExtensionMode('activate'); break; case 'N': setExtensionMode('deactivate'); break; - } // END - if + } // END - switch // Run embeded SQL commands - doExtensionSqls($taskId, getExtensionMode()); - } - } + doExtensionSqls($ext_id, getExtensionMode()); + } // END - if + } // END - foreach // Redirect to prevent missing cache in js.php redirectToUrl('modules.php?module=admin&what=extensions&edited=' . countPostSelection()); } else { // Edit selected entries $OUT = ''; - foreach (postRequestParameter('sel') as $taskId => $sel) { + foreach (postRequestElement('sel') as $ext_id => $sel) { // Edit this extension? if (($sel == 'Y') || ($sel != 'Y')) { // Default is no CSS for non-updated mailers @@ -125,13 +138,13 @@ if (isGetRequestParameterSet('reg_ext')) { // Load required data 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($taskId)), __FILE__, __LINE__); + $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", - array(bigintval($taskId)), __FILE__, __LINE__); + $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'; @@ -140,45 +153,46 @@ if (isGetRequestParameterSet('reg_ext')) { // Prepare CSS column $cssSelection = '---'; if (isExtensionInstalledAndNewer('sql_patches', '0.0.6')) { - $cssSelection = addSelectionBox('yn', $css, 'css', $taskId); + $cssSelection = addSelectionBox('yn', $css, 'css', $ext_id); } // END - if // Prepare data for the row template $content = array( - 'id' => $taskId, - 'name' => getExtensionName($taskId), - 'active' => addSelectionBox('yn', $active, 'active', $taskId), + 'id' => $ext_id, + 'name' => getExtensionName($ext_id), + 'active' => addSelectionBox('yn', $active, 'active', $ext_id), 'css' => $cssSelection, ); // Load row template and switch color - $OUT .= loadTemplate('admin_extensions_edit_row', true, $content); + $OUT .= loadTemplate('admin_edit_extensions_row', TRUE, $content); } // END - if } // END - foreach // Load template - loadTemplate('admin_extensions_edit', false, $OUT); + loadTemplate('admin_edit_extensions', FALSE, $OUT); $do = 'edit'; } -} elseif ((isPostRequestParameterSet('delete')) && (ifPostContainsSelections()) && (!isDemoModeActive())) { +} elseif ((isPostRequestElementSet('delete')) && (ifPostContainsSelections()) && (!isDemoModeActive())) { // List extensions and when verbose is enabled SQL statements which will be executed $OUT = ''; - foreach (postRequestParameter('sel') as $taskId => $sel) { + foreach (postRequestElement('sel') as $ext_id => $sel) { // Init variables $VERBOSE_OUT = ''; initSqls(); // Secure id number - $taskId = bigintval($taskId); + $ext_id = bigintval($ext_id); // Is the id valid? - if (isExtensionIdValid($taskId)) { + if (isExtensionIdValid($ext_id)) { // Get extension name - $ext_name = getExtensionName($taskId); + $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 @@ -186,81 +200,80 @@ if (isGetRequestParameterSet('reg_ext')) { // Prepare data for the row template $content = array( - 'id' => $taskId, + 'id' => $ext_id, 'ext_name' => $ext_name, - 'ext_ver' => getExtensionVersion($ext_name), 'verbose' => $VERBOSE_OUT ); // Load row template and switch color - $OUT .= loadTemplate('admin_extensions_delete_row', true, $content); + $OUT .= loadTemplate('admin_delete_extensions_row', TRUE, $content); } else { // Prepare data for the row template $content = array( - 'id' => $taskId + 'id' => $ext_id ); // Not valid! - $OUT .= loadTemplate('admin_extensions_delete_row_404', true, $content); + $OUT .= loadTemplate('admin_delete_extensions_row_404', TRUE, $content); } } // END - foreach // Load template - loadTemplate('admin_extensions_delete', false, $OUT); + loadTemplate('admin_delete_extensions', FALSE, $OUT); $do = 'delete'; -} elseif ((isFormSent('remove')) && (ifPostContainsSelections()) && (!isDemoModeActive())) { +} elseif ((isFormSent('do_delete')) && (ifPostContainsSelections()) && (!isDemoModeActive())) { // Remove extensions from DB (you have to delete all files manually!) $cache_update = '0'; - foreach (postRequestParameter('sel') as $taskId => $active) { + foreach (postRequestElement('sel') as $ext_id => $active) { // Secure id number - $taskId = bigintval($taskId); + $ext_id = bigintval($ext_id); // Is this extension selected and id valid? - if (($active == 1) && (isExtensionIdValid($taskId))) { + if (($active == 1) && (isExtensionIdValid($ext_id))) { // Run embeded SQL commands - doExtensionSqls($taskId, 'remove'); + doExtensionSqls($ext_id, 'remove'); } // END - if } // END - foreach // Redirect to prevent missing cache in js.php redirectToUrl('modules.php?module=admin&what=extensions&removed=' . countPostSelection()); -} elseif ((isGetRequestParameterSet('do')) && (!isDemoModeActive())) { +} elseif ((isGetRequestElementSet('do')) && (!isDemoModeActive())) { // Other things to do - $do = SQL_ESCAPE(secureString(getRequestParameter('do'))); -} elseif (isGetRequestParameterSet('do')) { + $do = getRequestElement('do'); +} elseif (isGetRequestElementSet('do')) { // Demo mode active! $do = 'demo'; -} elseif (isGetRequestParameterSet('registered')) { +} elseif (isGetRequestElementSet('registered')) { // Extensions changed - loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_EXTENSION_REGISTERED', getExtensionName(getRequestParameter('registered')))); + displayMessage('{%message,ADMIN_EXTENSION_REGISTERED=' . getExtensionName(getRequestElement('registered')) . '%}'); // Show next link if (isExtensionActive('task')) { - loadTemplate('admin_next_link', false, array( + 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( + loadTemplate('admin_next_link', FALSE, array( 'url' => 'modules.php?module=admin', 'title' => '{--ADMIN_EXTENSION_REGISTER_NEXT_LINK--}' )); } -} elseif (isGetRequestParameterSet('changed')) { +} elseif (isGetRequestElementSet('changed')) { // Extensions changed - loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_EXTENSION_CHANGED', bigintval(getRequestParameter('changed')))); -} elseif (isGetRequestParameterSet('edited')) { + displayMessage('{%message,ADMIN_EXTENSION_CHANGED=' . bigintval(getRequestElement('changed')) . '%}'); +} elseif (isGetRequestElementSet('edited')) { // Extensions changed - loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_EXTENSION_EDITED', bigintval(getRequestParameter('edited')))); -} elseif (isGetRequestParameterSet('removed')) { + displayMessage('{%message,ADMIN_EXTENSION_EDITED=' . bigintval(getRequestElement('edited')) . '%}'); +} elseif (isGetRequestElementSet('removed')) { // Extensions changed - loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_EXTENSIONS_REMOVED', bigintval(getRequestParameter('removed')))); + displayMessage('{%message,ADMIN_EXTENSIONS_REMOVED=' . bigintval(getRequestElement('removed')) . '%}'); } // Shall we display active/inactive extensions? $where = ''; -if (isGetRequestParameterSet(('active'))) { - $where = sprintf("WHERE `ext_active`='%s'", SQL_ESCAPE(secureString(getRequestParameter('active')))); +if (isGetRequestElementSet('active')) { + $where = sprintf("WHERE `ext_active`='%s'", SQL_ESCAPE(getRequestElement('active'))); } // END - if // Case selection @@ -268,22 +281,29 @@ 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` + $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." +' . $where . ' ORDER BY - `ext_name` ASC", __FILE__, __LINE__); + `ext_name` ASC', __FILE__, __LINE__); } else { // Load extension data without CSS informations - $result = SQL_QUERY("SELECT - `id` AS ext_id, `ext_name`, `ext_active`, `ext_version` + $result = SQL_QUERY('SELECT + `id` AS `ext_id`, + `ext_name`, + `ext_active`, + `ext_version` FROM `{?_MYSQL_PREFIX?}_extensions` -".$where." +' . $where . ' ORDER BY - `ext_name` ASC", __FILE__, __LINE__); + `ext_name` ASC', __FILE__, __LINE__); } // Are there some entries? @@ -293,36 +313,34 @@ ORDER BY while ($content = SQL_FETCHARRAY($result)) { // Prepare CSS selection output $cssSelection = '---'; - if (isExtensionInstalledAndNewer('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['ext_css'] = $cssSelection; // Load row template and switch color - $OUT .= loadTemplate('admin_extensions_row', true, $content); + $OUT .= loadTemplate('admin_list_extensions_row', TRUE, $content); } // END - while // Free memory SQL_FREERESULT($result); // Load template - loadTemplate('admin_extensions', false, $OUT); + loadTemplate('admin_list_extensions', FALSE, $OUT); } else { // No extensions are registered - loadTemplate('admin_settings_saved', false, '{--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); - - // Free result - SQL_FREERESULT($result); + case 'setup': // Setup new extension + // Are there some tasks? + $numTasks = countSumTotalData(getCurrentAdminId(), 'task_system', 'id', 'assigned_admin', TRUE, "AND `task_type`='EXTENSION'"); // Is the id number valid and the task was found? - if (($taskId > 0) && ($task_found == 1)) { + if ((isValidId($taskId)) && ($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($taskId)), __FILE__, __LINE__); @@ -344,50 +362,50 @@ ORDER BY if (!isExtensionDeprecated()) { // ... so we can finally register and load it in registration mode if (registerExtension($ext_name, $taskId)) { + // Do we need to update cache file? + // @TODO Rewrite this to a filter + if (isExtensionActive('cache')) { + // Remove cache file (will be auto-created again!) + foreach (array('config', 'extension', 'filter', 'modules') as $cache) { + // Rebuild cache file + rebuildCache($cache); + } // END - foreach + } // END - if + // Errors? if (!ifFatalErrorsDetected()) { // Extension was found and successfully registered redirectToUrl('modules.php?module=admin&what=extensions&registered=' . getExtensionId($ext_name)); } else { // Errors detected! - loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_EXTENSION_NOT_REGISTERED', $ext_name)); + displayMessage('{%message,ADMIN_EXTENSION_NOT_REGISTERED=' . $ext_name . '%}'); } - - // Do we need to update cache file? - // @TODO Rewrite this to a filter - if (isExtensionActive('cache')) { - // 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 (isExtensionInstalled($ext_name)) { // Notify the admin that we have a problem here... - loadTemplate('admin_settings_saved', false, '{--ADMIN_EXTENSION_REGISTRATION_FAILED_ALREADY--}'); + displayMessage('{--ADMIN_EXTENSION_REGISTRATION_FAILED_ALREADY--}'); } else { // Notify the admin that we have a problem here... - loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_EXTENSION_REGISTRATION_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, '{--ADMIN_EXTENSION_REGISTRATION_FAILED_DEPRECATED--}'); + displayMessage('{--ADMIN_EXTENSION_REGISTRATION_FAILED_DEPRECATED--}'); } } else { // Extension was not found in task management - loadTemplate('admin_settings_saved', false, '{--ADMIN_EXTENSION_REGISTRATION_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, '{--ADMIN_EXTENSION_REGISTRATION_FAILED_ASSIGED--}'); + displayMessage('{--ADMIN_EXTENSION_REGISTRATION_FAILED_ASSIGED--}'); } else { // id is invalid - loadTemplate('admin_settings_saved', false, '{--ADMIN_EXTENSION_REGISTRATION_FAILED_INVALID--}'); + displayMessage('{--ADMIN_EXTENSION_REGISTRATION_FAILED_INVALID--}'); } break; case 'demo': - loadTemplate('admin_settings_saved', false, '{--SETTINGS_NOT_SAVED--}'); + displayMessage('{--SETTINGS_NOT_SAVED--}'); break; } // END - switch