X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-extensions.php;h=4b9f9a988be10db568e2998c1d647240e0b66d18;hb=8d0ed5ed9a9ca0e07b9582f2311b44bdcc5a95ea;hp=3d47fee1d9dde02ec61a4da5fb2bef42b603d7b7;hpb=a1ef1533f17e1ca5db81a9912632491e72626694;p=mailer.git diff --git a/inc/modules/admin/what-extensions.php b/inc/modules/admin/what-extensions.php index 3d47fee1d9..4b9f9a988b 100644 --- a/inc/modules/admin/what-extensions.php +++ b/inc/modules/admin/what-extensions.php @@ -1,7 +1,7 @@ 0) && (!IS_DEMO())) { + $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 ($_POST['sel'] as $id=>$active) { + foreach (postRequestParameter('sel') as $ext_id => $ext_active) { // Shall we keep the extension always active? - if ((isset($cacheArray['active_extensions'][GET_EXT_NAME($id)])) && ($cacheArray['active_extensions'][GET_EXT_NAME($id)] == "Y") && ($active == "N")) { + 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(getMaskedMessage('ADMIN_EXTENSION_ALWAYS_ACTIVE', getExtensionName($ext_id))); } else { - // De/activate extension - $ACT = "N"; $EXT_LOAD_MODE = "deactivate"; - if ($active == "N") { $ACT = "Y"; $EXT_LOAD_MODE = "activate"; } - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_active='".$ACT."' WHERE id=%s AND ext_active='%s' LIMIT 1", - array(bigintval($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 - EXTENSION_RUN_SQLS($id, $EXT_LOAD_MODE); + doExtensionSqls($ext_id, getExtensionMode()); } - } -} elseif (((isset($_POST['edit'])) || (isset($_POST['modify']))) && ($SEL > 0) && (!IS_DEMO())) { + } // 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 (isset($_POST['modify'])) { + if (isPostRequestParameterSet('modify')) { // Change entries - $cacheInstance_UPDATE = "0"; - foreach ($_POST['sel'] as $id=>$sel) { - // Secure ID - $id = bigintval($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 + setExtensionMode('modify'); + + // Get entry for 'active' + $active = postRequestParameter('active', $ext_id); + // Update extension's record - $active = $_POST['active'][$id]; - if (GET_EXT_VERSION("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 - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_has_css='%s', ext_active='%s' WHERE id=%s LIMIT 1", - array($_POST['css'][$id], $active, $id), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_extensions` SET `ext_has_css`='%s', `ext_active`='%s' WHERE `id`=%s LIMIT 1", + 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 - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_extensions SET ext_active='%s' WHERE id=%s LIMIT 1", - array($active, $id), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_extensions` SET `ext_active`='%s' WHERE `id`=%s LIMIT 1", + array($active, $ext_id), __FILE__, __LINE__); } // Run SQLs on activation / deactivation switch ($active) { - case 'Y': $EXT_LOAD_MODE = "activate"; break; - case 'N': $EXT_LOAD_MODE = "deactivate"; break; - } + case 'Y': setExtensionMode('activate'); break; + case 'N': setExtensionMode('deactivate'); break; + } // END - switch // Run embeded SQL commands - EXTENSION_RUN_SQLS($id, $EXT_LOAD_MODE); - } - } + doExtensionSqls($ext_id, getExtensionMode()); + } // END - if + } // END - foreach - // Extensions changed - OUTPUT_HTML("
"); - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_EXT_CHANGED); - OUTPUT_HTML("
"); + // 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 ($_POST['sel'] as $id=>$sel) { + $OUT = ''; + foreach (postRequestParameter('sel') as $ext_id => $sel) { // Edit this extension? - if (($sel == "Y") || ($sel == "N")) { + if (($sel == 'Y') || ($sel != 'Y')) { + // Default is no CSS for non-updated mailers + $css = 'N'; + // 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($id)), __FILE__, __LINE__); - list($name, $css, $active) = SQL_FETCHROW($result); + 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_name, ext_active FROM "._MYSQL_PREFIX."_extensions WHERE id=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - list($name, $active) = SQL_FETCHROW($result); + $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"; + $css = 'X'; } - // Output row - $CSS = "---"; - if (GET_EXT_VERSION("sql_patches") >= "0.0.6") $CSS = ADD_SELECTION("yn", $css, "css", $id); + // Prepare CSS column + $cssSelection = '---'; + 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' => $id, - 'name' => $name, - 'active' => ADD_SELECTION("yn", $active, "active", $id), - 'css' => $CSS, + 'id' => $ext_id, + 'name' => getExtensionName($ext_id), + 'active' => addSelectionBox('yn', $active, 'active', $ext_id), + 'css' => $cssSelection, ); // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_extensions_edit_row", true, $content); - $SW = 3 - $SW; - } + $OUT .= loadTemplate('admin_extensions_edit_row', true, $content); + } // END - if } // END - foreach - define('__EXTENSIONS_ROWS', $OUT); // Load template - LOAD_TEMPLATE("admin_extensions_edit"); - $do = "edit"; + loadTemplate('admin_extensions_edit', false, $OUT); + $do = 'edit'; } -} elseif ((isset($_POST['delete'])) && ($SEL > 0) && (!IS_DEMO())) { +} elseif ((isPostRequestParameterSet('delete')) && (ifPostContainsSelections()) && (!isDemoModeActive())) { // List extensions and when verbose is enabled SQL statements which will be executed - $SW = 2; $OUT = ""; - foreach ($_POST['sel'] as $id=>$sel) { + $OUT = ''; + foreach (postRequestParameter('sel') as $ext_id => $sel) { // Init variables - $VERBOSE_OUT = ""; $SQLs = array(); + $VERBOSE_OUT = ''; + initSqls(); // Secure id number - $id = bigintval($id); - - // Get extension name - $ext_name = GET_EXT_NAME($id); - $ext_ver = GET_EXT_VERSION($ext_name); + $ext_id = bigintval($ext_id); + + // Is the id valid? + if (isExtensionIdValid($ext_id)) { + // Get extension name + $ext_name = getExtensionName($ext_id); + + // Listing of SQLs enabled? + if (isVerboseSqlEnabled()) { + // Load SQL commands in remove mode + if (loadExtension($ext_name, 'remove', '0.0.0', true)) { + // Generate extra table with loaded SQL commands + $VERBOSE_OUT = addExtensionVerboseSqlTable(); + } // END - if + } // END - if - // Free the result - SQL_FREERESULT($result); - - if ($_CONFIG['verbose_sql']) { - // Load SQL commands in remove mode - $EXT_LOAD_MODE = "remove"; - $file = sprintf("%sinc/extensions/ext-%s.php", PATH, $ext_name); - include($file); + // Prepare data for the row template + $content = array( + 'id' => $ext_id, + 'ext_name' => $ext_name, + 'verbose' => $VERBOSE_OUT + ); - // Generate extra table with loaded SQL commands - $VERBOSE_OUT = EXTENSION_VERBOSE_TABLE($SQLs); - } // END - if + // Load row template and switch color + $OUT .= loadTemplate('admin_extensions_delete_row', true, $content); + } else { + // Prepare data for the row template + $content = array( + 'id' => $ext_id + ); - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'ext_name' => $ext_name, - 'ext_ver' => $ext_ver, - 'verbose' => $VERBOSE_OUT - ); - - // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_extensions_delete_row", true, $content); - $SW = 3 - $SW; + // Not valid! + $OUT .= loadTemplate('admin_extensions_delete_row_404', true, $content); + } } // END - foreach - define('__EXTENSIONS_ROWS', $OUT); // Load template - LOAD_TEMPLATE("admin_extensions_delete"); - $do = "delete"; -} elseif ((isset($_POST['remove'])) && ($SEL > 0) && (!IS_DEMO())) { + loadTemplate('admin_extensions_delete', false, $OUT); + $do = 'delete'; +} elseif ((isFormSent('remove')) && (ifPostContainsSelections()) && (!isDemoModeActive())) { // Remove extensions from DB (you have to delete all files manually!) - $cacheInstance_UPDATE = "0"; - foreach ($_POST['sel'] as $id=>$active) { - // Secure ID number - $id = bigintval($id); + $cache_update = '0'; + foreach (postRequestParameter('sel') as $ext_id => $active) { + // Secure id number + $ext_id = bigintval($ext_id); - // Is this extension selected? - if ($active == 1) { + // Is this extension selected and id valid? + if (($active == 1) && (isExtensionIdValid($ext_id))) { // Run embeded SQL commands - EXTENSION_RUN_SQLS($id, "remove"); + doExtensionSqls($ext_id, 'remove'); } // END - if } // END - foreach -} elseif (!empty($_GET['do']) && (!IS_DEMO())) { + + // 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(strip_tags($_GET['do'])); -} elseif (!empty($_GET['do'])) { + $do = SQL_ESCAPE(secureString(getRequestParameter('do'))); +} elseif (isGetRequestParameterSet('do')) { // Demo mode active! - $do = "demo"; + $do = 'demo'; +} elseif (isGetRequestParameterSet('registered')) { + // Extensions changed + displayMessage(getMaskedMessage('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(getMaskedMessage('ADMIN_EXTENSION_CHANGED', bigintval(getRequestParameter('changed')))); +} elseif (isGetRequestParameterSet('edited')) { + // Extensions changed + displayMessage(getMaskedMessage('ADMIN_EXTENSION_EDITED', bigintval(getRequestParameter('edited')))); +} elseif (isGetRequestParameterSet('removed')) { + // Extensions changed + displayMessage(getMaskedMessage('ADMIN_EXTENSIONS_REMOVED', bigintval(getRequestParameter('removed')))); } // Shall we display active/inactive extensions? -$where = ""; -if (!empty($_GET['active'])) { - $where = sprintf("WHERE ext_active = '%s'", SQL_ESCAPE(strip_tags($_GET['active']))); +$where = ''; +if (isGetRequestParameterSet('active')) { + $where = sprintf("WHERE `ext_active`='%s'", SQL_ESCAPE(secureString(getRequestParameter('active')))); } // END - if // 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, ext_name, ext_lang_file, ext_active, ext_has_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, ext_name, ext_lang_file, 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 - $SW = 2; $OUT = ""; - while (list($id, $name, $lang, $active, $css, $ver) = SQL_FETCHROW($result)) { - $CSS = "---"; - if (GET_EXT_VERSION("sql_patches") >= "0.0.6") $CSS = TRANSLATE_YESNO($css); + 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` +".$where." +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`, `ext_version` +FROM + `{?_MYSQL_PREFIX?}_extensions` +".$where." +ORDER BY + `ext_name` ASC", __FILE__, __LINE__); + } - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'name' => $name, - 'active' => TRANSLATE_YESNO($active), - 'act_val' => $active, - 'lang' => $lang, - 'css' => $CSS, - 'ver' => $ver, - ); + // Are there some entries? + if (!SQL_HASZERONUMS($result)) { + // Extensions are registered + $OUT = ''; + while ($content = SQL_FETCHARRAY($result)) { + // Prepare CSS selection output + $cssSelection = '---'; + if (isExtensionInstalledAndNewer('sql_patches', '0.0.6')) { + $cssSelection = translateYesNo($content['ext_css']); + } // END - if - // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_extensions_row", true, $content); - $SW = 3 - $SW; - } + // Prepare data for the row template + $content['ext_css'] = $cssSelection; - // Free memory - SQL_FREERESULT($result); + // Load row template and switch color + $OUT .= loadTemplate('admin_extensions_row', true, $content); + } // END - while - // Remember rows in constant for the template - define('__EXT_ROWS', $OUT); + // Free memory + SQL_FREERESULT($result); - // Load template - LOAD_TEMPLATE("admin_extensions"); - } else { - // No extensions are registered - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_NO_EXTENSION_REGISTERED.""); - } - // Link for checking for new or updated extensions - OUTPUT_HTML("