X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_country.php;h=86ba650fe5b4d8b8f3f50d44057df9448d4f968d;hp=f0c8457997e07000bdc9a28984c7df3e8decec84;hb=c2e17d983fcbc0c3bd1dd37908d87c678f0367df;hpb=80e2def8ef2125fd4d7d1312ee3993ab613f0846 diff --git a/inc/modules/admin/what-list_country.php b/inc/modules/admin/what-list_country.php index f0c8457997..86ba650fe5 100644 --- a/inc/modules/admin/what-list_country.php +++ b/inc/modules/admin/what-list_country.php @@ -10,9 +10,14 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Country codes verwalten * * -------------------------------------------------------------------- * - * * + * $Revision:: $ * + * $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 - 2008 by Roland Haeder * + * Copyright (c) 2003 - 2009 by Roland Haeder * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -32,85 +37,75 @@ ************************************************************************/ // Some security stuff... -if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!is_admin())) -{ - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; - require($INC); +if ((!defined('__SECURITY')) || (!isAdmin())) { + die(); } // Add description as navigation point -ADD_DESCR("admin", basename(__FILE__)); +addMenuDescription('admin', __FILE__); // Add new code? -if ((isset($_POST['add'])) && (!empty($_POST['code'])) && (!empty($_POST['descr']))) -{ +if ((isPostRequestElementSet('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($_POST['code'])), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 0) - { + $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_countries` WHERE code='%s' LIMIT 1", + array(strtoupper(postRequestElement('code'))), __FILE__, __LINE__); + if (SQL_NUMROWS($result) == 0) { // Save entry - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_countries (code, descr, is_active) - VALUES('%s', '%s', '%s')", - array(strtoupper(substr($_POST['code'], 0, 2)), $_POST['descr'], $_POST['is_active']), __FILE__, __LINE__); - - // Country added - $MSG = ADMIN_COUNTRY_ADDED_1.strtoupper($_POST['descr']).ADMIN_COUNTRY_ADDED_2; - } - else - { + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_countries` (code, descr, is_active) VALUES ('%s','%s','%s')", + array( + strtoupper(substr(postRequestElement('code'), 0, 2)), + postRequestElement('descr'), + postRequestElement('is_active') + ), __FILE__, __LINE__); + + // Country added + $message = sprintf(getMessage('ADMIN_COUNTRY_ADDED'), strtoupper(postRequestElement('descr'))); + } else { // Free memory SQL_FREERESULT($result); // Does already exist - $MSG = ADMIN_COUNTRY_ALREADY_1.strtoupper($_POST['code']).ADMIN_COUNTRY_ALREADY_2; + $message = sprintf(getMessage('ADMIN_COUNTRY_ALREADY'), strtoupper(postRequestElement('code'))); } // Display message - LOAD_TEMPLATE("admin_settings_saved", false, $MSG); - OUTPUT_HTML("
"); -} -// Change status? - elseif ((isset($_POST['change'])) && (!empty($_POST['id']))) -{ + loadTemplate('admin_settings_saved', false, $message); +} elseif ((isPostRequestElementSet('change')) && (isPostRequestElementSet('id'))) { // Change all status - ADMIN_CHANGE_ACTIVATION_STATUS($_POST['id'], "countries", "is_active"); -} -// Edit / delete entries? - elseif (((isset($_POST['edit'])) || (isset($_POST['delete']))) && (!empty($_POST['id']))) -{ - if (count($_POST['id']) > 0) - { - if (isset($_POST['edit'])) - { + adminChangeActivationStatus(postRequestElement('id'), 'countries', 'is_active'); + + // Show next link + loadTemplate('admin_next_link', false, array( + 'url' => 'modules.php?module=admin&what=list_country', + 'title' => getMessage('ADMIN_COUNTRY_ACTIVATION_NEXT_LINK') + )); +} elseif (((isPostRequestElementSet('edit')) || (isPostRequestElementSet('delete'))) && (isPostRequestElementSet('id'))) { + if (count(postRequestElement('id')) > 0) { + if (isPostRequestElementSet('edit')) { // Edit template - $row = "admin_list_country_edit_row"; - $post = "modify"; - $class = "admin_submit"; - $submit = ADMIN_COUNTRY_EDIT_NOW; - $title = ADMIN_COUNTRY_EDIT_TITLE; - $reset = " *\n"; - } - else - { + $row = 'admin_list_country_edit_row'; + $post = 'modify'; + $class = 'admin_submit'; + $submit = getMessage('ADMIN_COUNTRY_EDIT_NOW'); + $title = getMessage('ADMIN_COUNTRY_EDIT_TITLE'); + $reset = ' *'; + } else { // Delete template - $row = "admin_list_country_del_row"; - $post = "remove"; - $class = "admin_delete"; - $submit = ADMIN_COUNTRY_DELETE_NOW; - $title = ADMIN_COUNTRY_DELETE_TITLE; - $reset = ""; + $row = 'admin_list_country_del_row'; + $post = 'remove'; + $class = 'admin_delete'; + $submit = getMessage('ADMIN_COUNTRY_DELETE_NOW'); + $title = getMessage('ADMIN_COUNTRY_DELETE_TITLE'); + $reset = ''; } // Edit all selected country codes - $OUT = ""; $SW = 2; - foreach ($_POST['id'] as $id => $status) - { + $OUT = ''; $SW = 2; + foreach (postRequestElement('id') as $id => $status) { // Load data from DB - $result = SQL_QUERY_ESC("SELECT code, descr FROM "._MYSQL_PREFIX."_countries WHERE id=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { + $result = SQL_QUERY_ESC("SELECT code, descr FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id`=%s LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); + if (SQL_NUMROWS($result) == 1) { // Load data list($code, $descr) = SQL_FETCHROW($result); SQL_FREERESULT($result); @@ -122,110 +117,94 @@ if ((isset($_POST['add'])) && (!empty($_POST['code'])) && (!empty($_POST['descr' 'descr' => $descr, 'sw' => $SW, ); - if ($post == "modify") - { + + if ($post == 'modify') { // Generate default selection in edit-mode - $content['status'] = ADD_OPTION_LINES("/ARRAY/", array('Y', 'N'), array(YES, NO ), $status); - } - else - { + $content['status'] = generateOptionList('/ARRAY/', array('Y', 'N'), array(getMessage('YES'), getMessage('NO')), $status); + } else { // Only display status when in delete-mode - $content['status'] = TRANSLATE_YESNO($status); + $content['status'] = translateYesNo($status); } - $OUT .= LOAD_TEMPLATE($row, true, $content); + + // Insert row template and switch color + $OUT .= loadTemplate($row, true, $content); $SW = 3 - $SW; } } - define('__COUNTRY_ROWS' , $OUT); - define('__COUNTRY_MODE' , $post); - define('__COUNTRY_CLASS' , $class); - define('__COUNTRY_SUBMIT', $submit); - define('__COUNTRY_TITLE' , $title); - define('__COUNTRY_RESET' , $reset); + + // Prepare content for template + $content = array( + 'rows' => $OUT, + 'mode' => $post, + 'class' => $class, + 'title' => $title, + 'submit' => $submit, + 'reset' => $reset, + ); // Load main template - LOAD_TEMPLATE("admin_list_country_form"); + loadTemplate('admin_list_country_form', false, $content); } -} - else -{ +} else { // Shall we modify / remove entries now? - $MSG = ""; $SQLs = array(); - if ((isset($_POST['modify'])) && (!empty($_POST['id']))) - { + $message = ''; initSqls(); + if ((isPostRequestElementSet(('modify'))) && (isPostRequestElementSet('id'))) { // Modify - foreach ($_POST['id'] as $id => $sel) - { - $SQLs[] = "UPDATE "._MYSQL_PREFIX."_countries SET code='".$_POST['code'][$id]."', descr='".$_POST['descr'][$id]."', is_active='".$_POST['is_active'][$id]."' WHERE id='".$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`='".$id."' LIMIT 1"); } // Create message - $MSG = ADMIN_COUNTRIES_MODIFIED; - } - elseif ((isset($_POST['remove'])) && (!empty($_POST['id']))) - { + $message = getMessage('ADMIN_COUNTRIES_MODIFIED'); + } elseif ((isPostRequestElementSet('remove')) && (isPostRequestElementSet('id'))) { // Remove - $IDs = implode(", ", bigintval($_POST['id'])); - $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_countries WHERE id IN (".$IDs.") LIMIT ".count($_POST['id']).""; + $IDs = implode(',', array_keys(postRequestElement('id'))); + addSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id` IN (".$IDs.") LIMIT ".count(postRequestElement('id')).""); // Create message - $MSG = ADMIN_COUNTRIES_REMOVED; + $message = getMessage('ADMIN_COUNTRIES_REMOVED'); } - if ((!empty($MSG)) && (count($SQLs) > 0)) - { + if ((!empty($message)) && (countSqls() > 0)) { // Run SQL commands - foreach ($SQLs as $sql) - { - $result = SQL_QUERY($sql, __FILE__, __LINE__); - } + runFilterChain('run_sqls'); // Display message - LOAD_TEMPLATE("admin_settings_saved", false, $MSG); - OUTPUT_HTML("
"); + loadTemplate('admin_settings_saved', false, $message); } // Load currenty setup country codes to list - $result = SQL_QUERY("SELECT id, code, descr, is_active FROM "._MYSQL_PREFIX."_countries ORDER BY code", __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) - { + $result = SQL_QUERY('SELECT id, code, descr, is_active FROM `{?_MYSQL_PREFIX?}_countries` ORDER BY code', + __FILE__, __LINE__); + if (SQL_NUMROWS($result) > 0) { // List all countries - $OUT = ""; $SW = 2; - while(list($id, $code, $descr, $active) = SQL_FETCHROW($result)) - { + $OUT = ''; $SW = 2; + while ($content = SQL_FETCHARRAY($result)) { // Prepare array for the template - $content = array( - 'id' => $id, - 'code' => $code, - 'name' => $descr, - 'active' => TRANSLATE_YESNO($active), - 'sw' => $SW, - 'status' => $active, - ); + $content['active'] = translateYesNo($content['is_active']); + $content['sw'] = $SW; // Load row template and switch colors - $OUT .= LOAD_TEMPLATE("admin_list_country_row", true, $content); + $OUT .= loadTemplate('admin_list_country_row', true, $content); $SW = 3 - $SW; } // Free memory SQL_FREERESULT($result); - } - else - { + } else { // No code setup so far (not possible by this software! 'DE' for 'Deutschland' is default - $OUT = LOAD_TEMPLATE("admin_list_country_no_row", true); + $OUT = loadTemplate('admin_list_country_no_row', true); } // Add list to constant for the template - define('__COUNTRY_ROWS', $OUT); + $content['rows'] = $OUT; // Include add template - define('__ADD_COUNTRY_FORM', LOAD_TEMPLATE("admin_add_country", true)); + $content['add_form'] = loadTemplate('admin_add_country', true); // Load main template - LOAD_TEMPLATE("admin_list_country"); + loadTemplate('admin_list_country', false, $content); } -// +// [EOF] ?>