X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-theme_edit.php;h=cc0f464db5607be39bd5d367f967cc8428c1dbbe;hp=79663f43dd6c2beb38f25e0057c9a0cfbfa5e6f0;hb=30ae22f62ae87c53a56baf0d134569ba91011111;hpb=9afd6ec5878544a7982c50ed9c0dd7de37606d5b diff --git a/inc/modules/admin/what-theme_edit.php b/inc/modules/admin/what-theme_edit.php index 79663f43dd..cc0f464db5 100644 --- a/inc/modules/admin/what-theme_edit.php +++ b/inc/modules/admin/what-theme_edit.php @@ -1,7 +1,7 @@ 0) { +if (ifPostContainsSelections()) { $OUT = ''; - foreach (postRequestElement('sel') as $id => $sel) { + foreach (postRequestParameter('sel') as $id => $sel) { $sql = ''; // Shall I de-/activate or delete themes? - if (isPostRequestElementSet(('status'))) { + if (isPostRequestParameterSet(('status'))) { // Change status - if (postRequestElement('active', $id) == 'Y') { - $sql = "UPDATE `{?_MYSQL_PREFIX?}_themes` SET theme_active='N' WHERE `id`='".$id."' LIMIT 1"; + if (postRequestParameter('active', $id) == 'Y') { + $sql = "UPDATE `{?_MYSQL_PREFIX?}_themes` SET `theme_active`='N' WHERE `id`=%s LIMIT 1"; } else { - $sql = "UPDATE `{?_MYSQL_PREFIX?}_themes` SET theme_active='Y' WHERE `id`='".$id."' LIMIT 1"; + $sql = "UPDATE `{?_MYSQL_PREFIX?}_themes` SET `theme_active`='Y' WHERE `id`=%s LIMIT 1"; } - $OUT = getMessage('ADMIN_THEMES_UPDATED'); - } elseif (isPostRequestElementSet('del')) { + $OUT = '{--ADMIN_THEMES_UPDATED--}'; + } elseif (isFormSent('del')) { // Delete themes - $sql = "DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_themes` WHERE `id`='".$id."' LIMIT 1"; - $OUT = getMessage('ADMIN_THEMES_DELETED'); + $sql = "DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_themes` WHERE `id`=%s LIMIT 1"; + $OUT = '{--ADMIN_THEMES_DELETED--}'; } // Run SQL command? if (!empty($sql)) { // Run it - $result = SQL_QUERY($sql, __FILE__, __LINE__); + $result = SQL_QUERY_ESC($sql, array(bigintval($id)), __FILE__, __LINE__); // Rebuild cache - rebuildCacheFile('themes', 'them'); + rebuildCache('themes', 'them'); } // END - if - } + } // END - foreach // Output generated? - if (empty($OUT)) $OUT = getMessage('ADMIN_THEME_NO_OUTPUT'); -} elseif (isGetRequestElementSet('default_theme')) { + if (empty($OUT)) $OUT = '{--ADMIN_THEME_NO_OUTPUT--}'; +} elseif (isGetRequestParameterSet('default_theme')) { // Escape string from input - $postData['default_theme'] = getRequestElement('default_theme'); + $postData['default_theme'] = getRequestParameter('default_theme'); // Set session setTheme($postData['default_theme']); @@ -97,13 +96,24 @@ if ($SEL > 0) { adminSaveSettings($postData); } +// Init rows +$OUT = ''; + // Switch to testing mode $GLOBALS['theme_mode'] = 'test'; -// Generate output lines for the template -$OUT = ''; $SW = 2; -$result = SQL_QUERY("SELECT `id`, `theme_path`, `theme_active`, `theme_ver`, `theme_name` FROM `{?_MYSQL_PREFIX?}_themes` ORDER BY theme_path", __FILE__, __LINE__); -if (SQL_NUMROWS($result) > 0) { +$result = SQL_QUERY("SELECT + `id`, + `theme_path`, + `theme_active`, + `theme_ver`, + `theme_name` +FROM + `{?_MYSQL_PREFIX?}_themes` +ORDER BY + `theme_path` ASC", __FILE__, __LINE__); + +if (!SQL_HASZERONUMS($result)) { while ($content = SQL_FETCHARRAY($result)) { // Construct IFN $inc = sprintf("theme/%s/theme.php", $content['theme_path']); @@ -113,36 +123,32 @@ if (SQL_NUMROWS($result) > 0) { // Is the loaded theme name != current theme name? $LINK = $content['theme_path']; - if ($content['theme_path'] != getCurrentTheme()) $LINK = "".$content['theme_path'].""; + if ($content['theme_path'] != getCurrentTheme()) $LINK = '' . $content['theme_path'] . ''; // Prepare data for the row template $content = array( - 'sw' => $SW, - 'id' => $content['id'], - 'active' => $content['theme_active'], - 'link' => $LINK, - 'name' => $content['theme_name'], - 'is_act' => translateYesNo($content['theme_active']), - 'email' => "".$GLOBALS['theme_data']['author']."", - 'url_link' => generateDerefererUrl($GLOBALS['theme_data']['url']), - 'url_title' => $GLOBALS['theme_data']['url'], - 'ver' => $content['theme_ver'], + 'id' => $content['id'], + 'link' => $LINK, + 'theme_name' => $content['theme_name'], + 'theme_active' => $content['theme_active'], + 'email' => ' - - ".loadTemplate('admin_settings_saved', true, getMessage('ADMIN_NO_THEMES_FOUND'))." + $OUT .= ' + + ' . loadTemplate('admin_settings_saved', true, '{--ADMIN_NO_THEMES_FOUND--}') . ' -\n"; +'; } // Load template