X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_country.php;h=1ed29df9ecde7a6a1be83207f0bc79dd58a6fcde;hb=508228c85fba8448d00865b1639cb8cd7a69e457;hp=4a54818168c290a170ae96803dc6e7248ceaa7e3;hpb=75ad748a68473ace540251427a74fb781b1145e9;p=mailer.git

diff --git a/inc/modules/admin/what-list_country.php b/inc/modules/admin/what-list_country.php
index 4a54818168..1ed29df9ec 100644
--- a/inc/modules/admin/what-list_country.php
+++ b/inc/modules/admin/what-list_country.php
@@ -10,7 +10,12 @@
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Country codes verwalten                          *
  * -------------------------------------------------------------------- *
- *                                                                      *
+ * $Revision:: 856                                                    $ *
+ * $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                           *
  * For more information visit: http://www.mxchange.org                  *
@@ -32,67 +37,60 @@
  ************************************************************************/
 
 // Some security stuff...
-if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!is_admin()))
-{
+if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
 	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
 	require($INC);
 }
 
 // Add description as navigation point
-ADD_DESCR("admin", basename(__FILE__));
+ADD_DESCR("admin", __FILE__);
 
 // Add new code?
-if ((isset($_POST['add'])) && (!empty($_POST['code'])) && (!empty($_POST['descr'])))
-{
+if ((REQUEST_ISSET_POST(('add'))) && (REQUEST_ISSET_POST(('code'))) && (REQUEST_ISSET_POST(('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(REQUEST_POST('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(REQUEST_POST('code'), 0, 2)),
+				REQUEST_POST('descr'),
+				REQUEST_POST('is_active')
+			), __FILE__, __LINE__);
+
+		// Country added
+		$MSG = ADMIN_COUNTRY_ADDED_1.strtoupper(REQUEST_POST('descr')).ADMIN_COUNTRY_ADDED_2;
+	} else {
 		// Free memory
 		SQL_FREERESULT($result);
 
 		// Does already exist
-		$MSG = ADMIN_COUNTRY_ALREADY_1.strtoupper($_POST['code']).ADMIN_COUNTRY_ALREADY_2;
+		$MSG = ADMIN_COUNTRY_ALREADY_1.strtoupper(REQUEST_POST('code')).ADMIN_COUNTRY_ALREADY_2;
 	}
 
 	// Display message
 	LOAD_TEMPLATE("admin_settings_saved", false, $MSG);
-	OUTPUT_HTML("<BR>");
-}
-// Change status?
- elseif ((isset($_POST['change'])) && (!empty($_POST['id'])))
-{
+} elseif ((REQUEST_ISSET_POST(('change'))) && (REQUEST_ISSET_POST(('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']))
-		{
+	ADMIN_CHANGE_ACTIVATION_STATUS(REQUEST_POST('id'), "countries", "is_active");
+
+	// Show next link
+	LOAD_TEMPLATE("admin_next_link", false, array(
+		'url'   => "modules.php?module=admin&amp;what=list_country",
+		'title' => getMessage('ADMIN_COUNTRY_ACTIVATION_NEXT_LINK')
+	));
+} elseif (((REQUEST_ISSET_POST('edit')) || (REQUEST_ISSET_POST(('delete')))) && (REQUEST_ISSET_POST(('id')))) {
+	if (count(REQUEST_POST('id')) > 0) {
+		if (REQUEST_ISSET_POST('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  = "<INPUT type=\"reset\" class=\"admin_reset\" value=\"".UNDO_SELECTIONS."\">&nbsp;*\n";
-		}
-		 else
-		{
+			$reset  = "<input type=\"reset\" class=\"admin_reset\" value=\"{!UNDO_SELECTIONS!}\" />&nbsp;*\n";
+		} else {
 			// Delete template
 			$row    = "admin_list_country_del_row";
 			$post   = "remove";
@@ -104,13 +102,11 @@ if ((isset($_POST['add'])) && (!empty($_POST['code'])) && (!empty($_POST['descr'
 
 		// Edit all selected country codes
 		$OUT = ""; $SW = 2;
-		foreach ($_POST['id'] as $id=>$status)
-		{
+		foreach (REQUEST_POST('id') as $id => $status) {
 			// Load data from DB
-			$result = SQL_QUERY_ESC("SELECT code, descr FROM "._MYSQL_PREFIX."_countries WHERE id=%d 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,16 +118,16 @@ 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'] = ADD_OPTION_LINES("/ARRAY/", array("Y","N"), array(YES, NO ), $status);
+				} else {
 					// Only display status when in delete-mode
 					$content['status'] = TRANSLATE_YESNO($status);
 				}
+
+				// Insert row template and switch color
 				$OUT .= LOAD_TEMPLATE($row, true, $content);
 				$SW = 3 - $SW;
 			}
@@ -146,61 +142,49 @@ if ((isset($_POST['add'])) && (!empty($_POST['code'])) && (!empty($_POST['descr'
 		// Load main template
 		LOAD_TEMPLATE("admin_list_country_form");
 	}
-}
- else
-{
+} else {
 	// Shall we modify / remove entries now?
-	$MSG = ""; $SQLs = array();
-	if ((isset($_POST['modify'])) && (!empty($_POST['id'])))
-	{
+	$MSG = ""; INIT_SQLS();
+	if ((REQUEST_ISSET_POST(('modify'))) && (REQUEST_ISSET_POST(('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 (REQUEST_POST('id') as $id => $sel) {
+			ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_countries` SET code='".REQUEST_POST('code', $id)."', descr='".REQUEST_POST('descr', $id)."', is_active='".REQUEST_POST('is_active', $id)."' WHERE id='".$id."' LIMIT 1");
 		}
 
 		// Create message
-		$MSG = ADMIN_COUNTRIES_MODIFIED;
-	}
-	 elseif ((isset($_POST['remove'])) && (!empty($_POST['id'])))
-	{
+		$MSG = getMessage('ADMIN_COUNTRIES_MODIFIED');
+	} elseif ((REQUEST_ISSET_POST(('remove'))) && (REQUEST_ISSET_POST(('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(REQUEST_POST('id')));
+		ADD_SQL("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_countries` WHERE id IN (".$IDs.") LIMIT ".count(REQUEST_POST('id'))."");
 
 		// Create message
-		$MSG = ADMIN_COUNTRIES_REMOVED;
+		$MSG = getMessage('ADMIN_COUNTRIES_REMOVED');
 	}
 
-	if ((!empty($MSG)) && (count($SQLs) > 0))
-	{
+	if ((!empty($MSG)) && (COUNT_SQLS() > 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("<BR>");
 	}
 
 	// 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))
-		{
+		while ($content = SQL_FETCHARRAY($result)) {
 			// Prepare array for the template
+			// @TODO Rewritings: name->descr,status->is_active in template
 			$content = array(
-				'id'     => $id,
-				'code'   => $code,
-				'name'   => $descr,
-				'active' => TRANSLATE_YESNO($active),
+				'id'     => $content['id'],
+				'code'   => $content['code'],
+				'name'   => $content['descr'],
+				'active' => TRANSLATE_YESNO($content['is_active']),
 				'sw'     => $SW,
-				'status' => $active,
+				'status' => $content['is_active'],
 			);
 
 			// Load row template and switch colors
@@ -210,9 +194,7 @@ if ((isset($_POST['add'])) && (!empty($_POST['code'])) && (!empty($_POST['descr'
 
 		// 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);
 	}