X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_country.php;h=93a5d73c87e94246efdec0fb8733bd25c16826d1;hp=5f1dbc33345557636f595829187e179d4f129806;hb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;hpb=c3b4eaf29946349ff058691db2dcb615a5379bb2 diff --git a/inc/modules/admin/what-list_country.php b/inc/modules/admin/what-list_country.php index 5f1dbc3334..93a5d73c87 100644 --- a/inc/modules/admin/what-list_country.php +++ b/inc/modules/admin/what-list_country.php @@ -16,8 +16,8 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2015 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 * @@ -44,54 +44,56 @@ if ((!defined('__SECURITY')) || (!isAdmin())) { addYouAreHereLink('admin', __FILE__); // Add new code? -if ((isFormSent('add')) && (isPostRequestParameterSet('code')) && (isPostRequestParameterSet('descr'))) { +if ((isFormSent('add')) && (isPostRequestElementSet('code')) && (isPostRequestElementSet('descr'))) { // Check if country code does already exist - $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_countries` WHERE code='%s' LIMIT 1", - array(strtoupper(postRequestParameter('code'))), __FILE__, __LINE__); - if (SQL_HASZERONUMS($result)) { + $result = sqlQueryEscaped("SELECT `id` FROM `{?_MYSQL_PREFIX?}_countries` WHERE `code`='%s' LIMIT 1", + array(strtoupper(postRequestElement('code'))), __FILE__, __LINE__); + if (ifSqlHasZeroNumRows($result)) { // Save entry - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_countries` (code, descr, is_active) VALUES ('%s','%s','%s')", + sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('%s','%s','%s')", array( - strtoupper(substr(postRequestParameter('code'), 0, 2)), - postRequestParameter('descr'), - postRequestParameter('is_active') + strtoupper(substr(postRequestElement('code'), 0, 2)), + postRequestElement('descr'), + postRequestElement('is_active') ), __FILE__, __LINE__); // Country added - $message = getMaskedMessage('ADMIN_COUNTRY_ADDED', strtoupper(postRequestParameter('descr'))); + $message = '{%message,ADMIN_COUNTRY_ADDED=' . strtoupper(postRequestElement('descr')) . '%}'; } else { // Free memory - SQL_FREERESULT($result); + sqlFreeResult($result); // Does already exist - $message = getMaskedMessage('ADMIN_COUNTRY_ALREADY', strtoupper(postRequestParameter('code'))); + $message = '{%message,ADMIN_COUNTRY_ALREADY=' . strtoupper(postRequestElement('code')) . '%}'; } // Display message - loadTemplate('admin_settings_saved', false, $message); -} elseif ((isFormSent('change')) && (isPostRequestParameterSet('id'))) { + displayMessage($message); +} elseif ((isFormSent('do_edit')) && (isPostRequestElementSet('id'))) { // Change all status - adminChangeActivationStatus(postRequestParameter('id'), 'countries', 'is_active'); + adminChangeActivationStatus(postRequestElement('id'), 'countries', 'is_active'); // Show next link - loadTemplate('admin_next_link', false, array( + loadTemplate('admin_next_link', FALSE, array( 'url' => 'modules.php?module=admin&what=list_country', 'title' => '{--ADMIN_COUNTRY_ACTIVATION_NEXT_LINK--}' )); -} elseif (((isFormSent('edit')) || (isPostRequestParameterSet('delete'))) && (isPostRequestParameterSet('id'))) { - if (count(postRequestParameter('id')) > 0) { +} elseif (((isFormSent('edit')) || (isPostRequestElementSet('delete'))) && (isPostRequestElementSet('id'))) { + // Are there entries? + if (ifPostContainsSelections('id')) { + // Is the proper form sent? if (isFormSent('edit')) { // Edit template - $row = 'admin_list_country_edit_row'; - $post = 'modify'; + $row = 'admin_edit_country_row'; + $do = 'do_edit'; $class = 'form_submit'; $submit = '{--ADMIN_COUNTRY_EDIT_NOW--}'; $title = '{--ADMIN_COUNTRY_EDIT_TITLE--}'; $reset = ' '; } else { // Delete template - $row = 'admin_list_country_del_row'; - $post = 'remove'; + $row = 'admin_delete_country_row'; + $do = 'do_delete'; $class = 'form_delete'; $submit = '{--ADMIN_COUNTRY_DELETE_NOW--}'; $title = '{--ADMIN_COUNTRY_DELETE_TITLE--}'; @@ -100,34 +102,29 @@ if ((isFormSent('add')) && (isPostRequestParameterSet('code')) && (isPostRequest // Edit all selected country codes $OUT = ''; - foreach (postRequestParameter('id') as $id => $isActive) { + foreach (postRequestElement('id') as $id => $isActive) { // Load data from DB - $result = SQL_QUERY_ESC("SELECT `id`, `code`, `descr` FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id`=%s LIMIT 1", + $result = sqlQueryEscaped("SELECT `id`, `code`, `descr` FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) { + if (sqlNumRows($result) == 1) { // Load data - $content = SQL_FETCHARRAY($result); + $content = sqlFetchArray($result); - if ($post == 'modify') { - // Generate default selection in edit-mode - $content['is_active'] = generateOptionList('/ARRAY/', array('Y', 'N'), array('{--YES--}', '{--NO--}'), $isActive); - } else { - // Only display status when in delete-mode - $content['is_active'] = translateYesNo($isActive); - } + // Add $isActive + $content['is_active'] = $isActive; // Insert row template and switch color - $OUT .= loadTemplate($row, true, $content); + $OUT .= loadTemplate($row, TRUE, $content); } // END - if // Free result - SQL_FREERESULT($result); + sqlFreeResult($result); } // END - foreach // Prepare content for template $content = array( 'rows' => $OUT, - 'mode' => $post, + 'do' => $do, 'class' => $class, 'title' => $title, 'submit' => $submit, @@ -135,64 +132,71 @@ if ((isFormSent('add')) && (isPostRequestParameterSet('code')) && (isPostRequest ); // Load main template - loadTemplate('admin_list_country_form', false, $content); - } + loadTemplate('admin_list_country_form', FALSE, $content); + } // END - if } else { // Shall we modify / remove entries now? - $message = ''; initSqls(); - if ((isPostRequestParameterSet('modify')) && (isPostRequestParameterSet('id'))) { + $message = ''; + initSqls(); + if ((isPostRequestElementSet('do_edit')) && (isPostRequestElementSet('id'))) { // Modify - foreach (postRequestParameter('id') as $id => $sel) { - addSql("UPDATE `{?_MYSQL_PREFIX?}_countries` SET `code`='" . postRequestParameter('code', $id) . "', `descr`='" . postRequestParameter('descr', $id) . "', `is_active`='" . postRequestParameter('is_active', $id) . "' WHERE `id`=" . bigintval($id) . " LIMIT 1"); + foreach (postRequestElement('id') as $id => $sel) { + addSql("UPDATE + `{?_MYSQL_PREFIX?}_countries` +SET + `code`='" . postRequestElement('code', $id) . "', + `descr`='" . postRequestElement('descr', $id) . "', + `is_active`='" . postRequestElement('is_active', $id) . "' +WHERE + `id`=" . bigintval($id) . " +LIMIT 1"); } // END - foreach // Create message $message = '{--ADMIN_COUNTRIES_MODIFIED--}'; - } elseif ((isFormSent('remove')) && (isPostRequestParameterSet('id'))) { + } elseif ((isFormSent('do_delete')) && (isPostRequestElementSet('id'))) { // Remove - $IDs = implode(',', array_keys(postRequestParameter('id'))); - addSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id` IN (".$IDs.") LIMIT ".count(postRequestParameter('id')).""); + $IDs = implode(',', array_keys(postRequestElement('id'))); + addSql('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id` IN (' . $IDs . ') LIMIT ' . countPostSelection('id') . ''); // Create message $message = '{--ADMIN_COUNTRIES_REMOVED--}'; } + // Are a message and some SQLs set? if ((!empty($message)) && (countSqls() > 0)) { // Run SQL commands runFilterChain('run_sqls'); // Display message - loadTemplate('admin_settings_saved', false, $message); + displayMessage($message); } // END - if // Load currenty setup country codes to list - $result = SQL_QUERY('SELECT `id`, `code`, `descr`, `is_active` FROM `{?_MYSQL_PREFIX?}_countries` ORDER BY `code` ASC', - __FILE__, __LINE__); + $result = sqlQuery('SELECT `id`, `code`, `descr`, `is_active` FROM `{?_MYSQL_PREFIX?}_countries` ORDER BY `code` ASC', + __FILE__, __LINE__); - // Do we have entries? - if (!SQL_HASZERONUMS($result)) { + // Are there entries? + if (!ifSqlHasZeroNumRows($result)) { // List all countries $OUT = ''; - while ($content = SQL_FETCHARRAY($result)) { + while ($content = sqlFetchArray($result)) { // Load row template and switch colors - $OUT .= loadTemplate('admin_list_country_row', true, $content); + $OUT .= loadTemplate('admin_list_country_row', TRUE, $content); } // END - while // Free memory - SQL_FREERESULT($result); + sqlFreeResult($result); } else { // No code setup so far (not possible by this software! 'DE' for 'Deutschland' is default - $OUT = loadTemplate('admin_list_country_no_row', true); + $OUT = loadTemplate('admin_list_country_no_row', TRUE); } // Add list to constant for the template $content['rows'] = $OUT; - // Include add template - $content['add_form'] = loadTemplate('admin_add_country', true); - // Load main template - loadTemplate('admin_list_country', false, $content); + loadTemplate('admin_list_country', FALSE, $content); } // [EOF]