X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_mods.php;h=5f6040be70e615f4bacaa818c18db0da209ade22;hp=b4cdc290059ac428cf71d17789ba449e7732dd9c;hb=0f3a135204757cc8750262871c8e62c42300acb4;hpb=f13b0c89b6dce2dc31ef3c58f0e2ad4821d7bee8 diff --git a/inc/modules/admin/what-config_mods.php b/inc/modules/admin/what-config_mods.php index b4cdc29005..5f6040be70 100644 --- a/inc/modules/admin/what-config_mods.php +++ b/inc/modules/admin/what-config_mods.php @@ -1,7 +1,7 @@ 0) - { + if (ifPostContainsSelections()) { // Output header - $OUT = ""; $SW = 2; + $OUT = ''; // Edit selected modules - foreach ($_POST['sel'] as $id => $sel) - { + foreach (postRequestParameter('sel') as $id => $sel) { // Load module data - $result = SQL_QUERY_ESC("SELECT module, title, locked, hidden, admin_only, mem_only FROM "._MYSQL_PREFIX."_mod_reg WHERE id=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - list($mod, $title, $locked, $hidden, $admin, $mem) = SQL_FETCHROW($result); + // @TODO This can be moved into mysql-function.php, see checkModulePermissions() function + $result = SQL_QUERY_ESC("SELECT `id`,`module`,`title`,`locked`,`hidden`,`admin_only`,`mem_only` FROM `{?_MYSQL_PREFIX?}_mod_reg` WHERE `id`=%s LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); + + // Load data + $content = SQL_FETCHARRAY($result); + + // Free result SQL_FREERESULT($result); // Prepare array for the template - $content = array( - 'sw' => $SW, - 'mod' => $mod, - 'id' => $id, - 'title' => $title, - 'locked' => ADD_SELECTION("yn", $locked, "locked", $id), - 'hidden' => ADD_SELECTION("yn", $hidden, "hidden", $id), - 'admin' => ADD_SELECTION("yn", $admin , "admin" , $id), - 'mem' => ADD_SELECTION("yn", $mem , "member", $id), - ); + $content['locked'] = addSelectionBox('yn', $content['locked'] , 'locked', $id); + $content['hidden'] = addSelectionBox('yn', $content['hidden'] , 'hidden', $id); + $content['admin_only'] = addSelectionBox('yn', $content['admin_only'], 'admin' , $id); + $content['mem_only'] = addSelectionBox('yn', $content['mem_only'] , 'member', $id); // Load row template - $OUT .= LOAD_TEMPLATE("admin_mods_edit_row", true, $content); - } - define('__MODS_ROWS', $OUT); + $OUT .= loadTemplate('admin_edit_mods_row', true, $content); + } // END - foreach // Load main template - LOAD_TEMPLATE("admin_mods_edit"); - } - else - { + loadTemplate('admin_edit_mods', false, $OUT); + } else { // Nothing selected - LOAD_TEMPLATE("admin_settings_saved", false, MODS_NOTHING_SELECTED); - OUTPUT_HTML("
"); + displayMessage('{--ADMIN_MODS_NOTHING_SELECTED--}'); // Remove maybe confusing data - unset($_POST['edit']); - unset($_POST['change']); + unsetPostRequestParameter('edit'); + unsetPostRequestParameter('do_edit'); } -} - elseif (isset($_POST['change'])) -{ +} elseif (isFormSent('do_edit')) { + // Init SQLs + initSqls(); + // Change modules - foreach ($_POST['sel'] as $id => $sel) - { - // Secure ID number + foreach (postRequestParameter('sel') as $id => $sel) { + // Secure id number $id = bigintval($id); // Update module - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_mod_reg SET title='%s', locked='%s', hidden='%s', admin_only='%s', mem_only='%s' WHERE id=%s LIMIT 1", - array($_POST['title'][$id], $_POST['locked'][$id], $_POST['hidden'][$id], $_POST['admin'][$id], $_POST['member'][$id], $id), __FILE__, __LINE__); + addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_mod_reg` SET `title`='%s', `locked`='%s', `hidden`='%s', `admin_only`='%s', `mem_only`='%s' WHERE `id`=%s LIMIT 1", + array( + postRequestParameter('title', $id), + postRequestParameter('locked', $id), + postRequestParameter('hidden', $id), + postRequestParameter('admin', $id), + postRequestParameter('member', $id), + $id + ), __FILE__, __LINE__, false)); } + // Run all sqls + runFilterChain('run_sqls'); + // Remove cache file if version matches - if (GET_EXT_VERSION("cache") >= "0.1.2") - { - if ($cacheInstance->cache_file("mod_reg")) $cacheInstance->cache_destroy(); - } + if (isExtensionInstalledAndNewer('cache', '0.1.2')) { + if ($GLOBALS['cache_instance']->loadCacheFile('modules')) $GLOBALS['cache_instance']->removeCacheFile(); + } // END - if // Entries updated - LOAD_TEMPLATE("admin_settings_saved", false, MODS_CHANGED); - OUTPUT_HTML("
"); + displayMessage('{--ADMIN_MODS_CHANGED--}'); } -if ($SEL == 0) -{ +if (!ifPostContainsSelections()) { // Load module data (We do not need to check if there's at least one...) - $result = SQL_QUERY("SELECT id, module, locked, hidden, admin_only, title, mem_only, clicks -FROM "._MYSQL_PREFIX."_mod_reg -ORDER BY module", __FILE__, __LINE__); - $OUT = ""; $SW = 2; - while (list($id, $mod, $locked, $hidden, $admin, $title, $mem) = SQL_FETCHROW($result)) - { + $result = SQL_QUERY('SELECT + `id`,`module`,`locked`,`hidden`,`admin_only`,`title`,`mem_only` +FROM + `{?_MYSQL_PREFIX?}_mod_reg` +ORDER BY + `module` ASC', __FILE__, __LINE__); + + $OUT = ''; + while ($content = SQL_FETCHARRAY($result)) { // Reset title to --- if it is NULL - if (empty($title)) $title = "---"; - if (($mod == "index") || ($mod == "login")) - { + if (($content['module'] == 'index') || ($content['module'] == 'login')) { // Add link to detail statistics - $mod = "".$mod.""; - } - - // Prepare array for the template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'mod' => $mod, - 'title' => $title, - 'locked' => TRANSLATE_YESNO($locked), - 'hidden' => TRANSLATE_YESNO($hidden), - 'admin' => TRANSLATE_YESNO($admin), - 'mem' => TRANSLATE_YESNO($mem), - ); + $content['module'] = '' . $content['module'] . ''; + } // END - if // Load row template - $OUT .= LOAD_TEMPLATE("admin_mods_list_row", true, $content); - - // Switch colors - $SW = 3 - $SW; - } + $OUT .= loadTemplate('admin_list_mods_row', true, $content); + } // END - while // Free memory SQL_FREERESULT($result); - define('__MODS_ROWS', $OUT); // Load main template - LOAD_TEMPLATE("admin_mods_list"); -} + loadTemplate('admin_list_mods', false, $OUT); +} // END - if -// +// [EOF] ?>