$sel) { // Load module data // @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['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 .= loadTemplate('admin_edit_mods_row', true, $content); } // END - foreach // Load main template loadTemplate('admin_edit_mods', false, $OUT); } else { // Nothing selected displayMessage('{--ADMIN_MODS_NOTHING_SELECTED--}'); // Remove maybe confusing data unsetPostRequestParameter('edit'); unsetPostRequestParameter('do_edit'); } } elseif (isFormSent('do_edit')) { // Init SQLs initSqls(); // Change modules foreach (postRequestParameter('sel') as $id => $sel) { // Secure id number $id = bigintval($id); // Update module 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 (isExtensionInstalledAndNewer('cache', '0.1.2')) { if ($GLOBALS['cache_instance']->loadCacheFile('modules')) $GLOBALS['cache_instance']->removeCacheFile(); } // END - if // Entries updated displayMessage('{--ADMIN_MODS_CHANGED--}'); } 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` 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 (($content['module'] == 'index') || ($content['module'] == 'login')) { // Add link to detail statistics $content['module'] = '' . $content['module'] . ''; } // END - if // Load row template $OUT .= loadTemplate('admin_list_mods_row', true, $content); } // END - while // Free memory SQL_FREERESULT($result); // Load main template loadTemplate('admin_list_mods', false, $OUT); } // END - if // [EOF] ?>