X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fadmin%2Fwhat-list_country.php;h=05397487ce4e89ebc0816498585e9a02d7349ae6;hb=330dbb3e2b34450cd1665497506455e195a0a166;hp=1525b03830f3bf709bc5788144f1e25aee63d437;hpb=2e04164985cae54359663633a8796567d71082a7;p=mailer.git diff --git a/inc/modules/admin/what-list_country.php b/inc/modules/admin/what-list_country.php index 1525b03830..05397487ce 100644 --- a/inc/modules/admin/what-list_country.php +++ b/inc/modules/admin/what-list_country.php @@ -14,11 +14,9 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -40,38 +38,38 @@ // Some security stuff... if ((!defined('__SECURITY')) || (!isAdmin())) { die(); -} +} // END - if // Add description as navigation point -addMenuDescription('admin', __FILE__); +addYouAreHereLink('admin', __FILE__); // Add new code? if ((isFormSent('add')) && (isPostRequestParameterSet('code')) && (isPostRequestParameterSet('descr'))) { // Check if country code does already exist - $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_countries` WHERE code='%s' LIMIT 1", + $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)) { // Save entry - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_countries` (code, descr, is_active) VALUES ('%s','%s','%s')", + SQL_QUERY_ESC("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(postRequestParameter('code'), 0, 2)), + postRequestParameter('descr'), + postRequestParameter('is_active') ), __FILE__, __LINE__); // Country added - $message = getMaskedMessage('ADMIN_COUNTRY_ADDED', strtoupper(postRequestParameter('descr'))); + $message = '{%message,ADMIN_COUNTRY_ADDED=' . strtoupper(postRequestParameter('descr')) . '%}'; } else { // Free memory SQL_FREERESULT($result); // Does already exist - $message = getMaskedMessage('ADMIN_COUNTRY_ALREADY', strtoupper(postRequestParameter('code'))); + $message = '{%message,ADMIN_COUNTRY_ALREADY=' . strtoupper(postRequestParameter('code')) . '%}'; } // Display message - loadTemplate('admin_settings_saved', false, $message); -} elseif ((isFormSent('change')) && (isPostRequestParameterSet('id'))) { + displayMessage($message); +} elseif ((isFormSent('do_edit')) && (isPostRequestParameterSet('id'))) { // Change all status adminChangeActivationStatus(postRequestParameter('id'), 'countries', 'is_active'); @@ -86,15 +84,15 @@ if ((isFormSent('add')) && (isPostRequestParameterSet('code')) && (isPostRequest // Edit template $row = 'admin_list_country_edit_row'; $post = 'modify'; - $class = 'admin_submit'; + $class = 'form_submit'; $submit = '{--ADMIN_COUNTRY_EDIT_NOW--}'; $title = '{--ADMIN_COUNTRY_EDIT_TITLE--}'; - $reset = ' '; + $reset = ' '; } else { // Delete template $row = 'admin_list_country_del_row'; $post = 'remove'; - $class = 'admin_delete'; + $class = 'form_delete'; $submit = '{--ADMIN_COUNTRY_DELETE_NOW--}'; $title = '{--ADMIN_COUNTRY_DELETE_TITLE--}'; $reset = ''; @@ -102,7 +100,7 @@ if ((isFormSent('add')) && (isPostRequestParameterSet('code')) && (isPostRequest // Edit all selected country codes $OUT = ''; - foreach (postRequestParameter('id') as $id => $status) { + foreach (postRequestParameter('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", array(bigintval($id)), __FILE__, __LINE__); @@ -112,10 +110,10 @@ if ((isFormSent('add')) && (isPostRequestParameterSet('code')) && (isPostRequest if ($post == 'modify') { // Generate default selection in edit-mode - $content['status'] = generateOptionList('/ARRAY/', array('Y', 'N'), array('{--YES--}', '{--NO--}'), $status); + $content['is_active'] = generateOptionList('/ARRAY/', array('Y', 'N'), array('{--YES--}', '{--NO--}'), $isActive); } else { // Only display status when in delete-mode - $content['status'] = translateYesNo($status); + $content['is_active'] = '{%pipe,translateYesNo=' . $isActive . '%}'; } // Insert row template and switch color @@ -138,19 +136,20 @@ if ((isFormSent('add')) && (isPostRequestParameterSet('code')) && (isPostRequest // Load main template loadTemplate('admin_list_country_form', false, $content); - } + } // END - if } else { // Shall we modify / remove entries now? - $message = ''; initSqls(); + $message = ''; + initSqls(); if ((isPostRequestParameterSet('modify')) && (isPostRequestParameterSet('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"); - } + } // END - foreach // Create message $message = '{--ADMIN_COUNTRIES_MODIFIED--}'; - } elseif ((isFormSent('remove')) && (isPostRequestParameterSet('id'))) { + } elseif ((isFormSent('do_delete')) && (isPostRequestParameterSet('id'))) { // Remove $IDs = implode(',', array_keys(postRequestParameter('id'))); addSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id` IN (".$IDs.") LIMIT ".count(postRequestParameter('id')).""); @@ -164,19 +163,18 @@ if ((isFormSent('add')) && (isPostRequestParameterSet('code')) && (isPostRequest 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', + $result = SQL_QUERY('SELECT `id`, `code`, `descr`, `is_active` FROM `{?_MYSQL_PREFIX?}_countries` ORDER BY `code` ASC', __FILE__, __LINE__); + + // Do we have entries? if (!SQL_HASZERONUMS($result)) { // List all countries $OUT = ''; while ($content = SQL_FETCHARRAY($result)) { - // Prepare array for the template - $content['active'] = translateYesNo($content['is_active']); - // Load row template and switch colors $OUT .= loadTemplate('admin_list_country_row', true, $content); } // END - while