X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fnetwork_functions.php;h=db096e9b0d7645e59dd872252f387c01316b9898;hb=ed3a88c0334600c7d7246480008c79716aa3f80b;hp=7d0a942560423d5fc4b4a3fd295b5caf4b88654b;hpb=77183894e9b5683166bc00a1735e8897c57ef699;p=mailer.git

diff --git a/inc/libs/network_functions.php b/inc/libs/network_functions.php
index 7d0a942560..db096e9b0d 100644
--- a/inc/libs/network_functions.php
+++ b/inc/libs/network_functions.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 *
@@ -55,7 +53,7 @@ function getCurrentNetworkId () {
 // Handle a (maybe) sent form here
 function doNetworkHandleForm () {
 	// Was the form sent?
-	if ((isFormSent()) || (isFormSent('edit')) || (isFormSent('del')) || (isFormSent('change')) || (isFormSent('remove'))) {
+	if ((isFormSent()) || (isFormSent('edit')) || (isFormSent('delete')) || (isFormSent('do_edit')) || (isFormSent('do_delete'))) {
 		// Do we have a 'do'?
 		if (isGetRequestParameterSet('do')) {
 			// Process the request
@@ -70,7 +68,7 @@ function doNetworkHandleForm () {
 // Processes an admin form
 function doAdminNetworkProcessForm () {
 	// Form really sent?
-	if ((!isFormSent()) && (!isFormSent('edit')) && (!isFormSent('del')) && (!isFormSent('change')) && (!isFormSent('remove'))) {
+	if ((!isFormSent()) && (!isFormSent('edit')) && (!isFormSent('delete')) && (!isFormSent('do_edit')) && (!isFormSent('do_delete'))) {
 		// Abort here
 		loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_FORM_NOT_SENT--}');
 		return;
@@ -141,6 +139,22 @@ function isNetworkRequestParameterValid ($key, $type, $networkId) {
 	return $isValid;
 }
 
+// Checks wether the given network API array translation
+function isNetworkApiTranslationValid ($key, $type, $networkId) {
+	// Query for it
+	$result = SQL_QUERY_ESC("SELECT `network_api_id` FROM `{?_MYSQL_PREFIX?}_network_api_translation` WHERE `network_id`=%s AND `network_type_id`=%s AND `network_api_index`='%s' LIMIT 1",
+		array($networkId, $type, $key), __FUNCTION__, __LINE__);
+
+	// Does it exist?
+	$isValid = (SQL_NUMROWS($result) == 1);
+
+	// Free result
+	SQL_FREERESULT($result);
+
+	// Return result
+	return $isValid;
+}
+
 // "Getter" for a network's data by provided id number
 function getNetworkDataById ($id, $column = '') {
 	// Ids lower one are not accepted
@@ -486,9 +500,9 @@ function generateNetworkTypeOptions ($id) {
 	if (is_array($id)) $id = '';
 
 	// Is this cached?
-	if (!isset($GLOBALS['network_type_options'][$id])) {
+	if (!isset($GLOBALS[__FUNCTION__][$id])) {
 		// Generate output and cache it
-		$GLOBALS['network_type_options'][$id] = generateOptionList(
+		$GLOBALS[__FUNCTION__][$id] = generateOptionList(
 			'network_types',
 			'network_type_id',
 			'network_type_handle',
@@ -504,15 +518,65 @@ function generateNetworkTypeOptions ($id) {
 	} // END - if
 
 	// Return content
-	return $GLOBALS['network_type_options'][$id];
+	return $GLOBALS[__FUNCTION__][$id];
 }
 
-// Generator (somewhat getter) for request key options
-function generateNetworkRequestKeyOptions ($key) {
+// Generates an options list of all available (hard-coded) handlers
+function generateNetworkTypesAvailableOptions () {
 	// Is it cached?
-	if (!isset($GLOBALS['network_request_param_key'][$key])) {
+	if (!isset($GLOBALS[__FUNCTION__])) {
+		// Generate list
+		$GLOBALS[__FUNCTION__] = generateOptionList(
+			'/ARRAY/',
+			array(
+				'banner',
+				'banner_click',
+				'banner_view',
+				'button',
+				'button_click',
+				'button_view',
+				'surfbar',
+				'surfbar_click',
+				'surfbar_view',
+				'forcedbanner',
+				'forcedtextlink',
+				'textlink',
+				'textlink_click',
+				'textlink_view',
+				'skybanner',
+				'skybanner_click',
+				'skybanner_view',
+				'layer',
+				'layer_click',
+				'layer_view',
+				'popup',
+				'popdown',
+				'textmail',
+				'htmlmail',
+				'lead',
+				'sale',
+				'payperactive',
+				'pagepeel',
+				'traffic'
+			),
+			array(),
+			'',
+			'', '',
+			$GLOBALS['network_types_disabled'],
+			'translateNetworkTypeHandler'
+		);
+	} // END - if
+
+	// Return content
+	return $GLOBALS[__FUNCTION__];
+}
+
+// Generates an options list (somewhat getter) ofr request keys
+function generateNetworkRequestKeyOptions () {
+	// Is it cached?
+	if (!isset($GLOBALS[__FUNCTION__])) {
 		// Generate and cache it
-		$GLOBALS['network_request_param_key'][$key] = generateOptionList(
+		$GLOBALS[__FUNCTION__] = generateOptionList(
 			'/ARRAY/',
 			array(
 				'id',
@@ -528,40 +592,27 @@ function generateNetworkRequestKeyOptions ($key) {
 				'reward',
 				'size',
 				'erotic',
-				'extra'
-			),
-			array(
-				'{--ADMIN_NETWORK_REQUEST_PARAMETER_ID--}',
-				'{--ADMIN_NETWORK_REQUEST_PARAMETER_SID--}',
-				'{--ADMIN_NETWORK_REQUEST_PARAMETER_HASH--}',
-				'{--ADMIN_NETWORK_REQUEST_PARAMETER_PASSWORD--}',
-				'{--ADMIN_NETWORK_REQUEST_PARAMETER_RELOAD--}',
-				'{--ADMIN_NETWORK_REQUEST_PARAMETER_MAXIMUM_STAY--}',
-				'{--ADMIN_NETWORK_REQUEST_PARAMETER_MINIMUM_STAY--}',
-				'{--ADMIN_NETWORK_REQUEST_PARAMETER_CURRENCY--}',
-				'{--ADMIN_NETWORK_REQUEST_PARAMETER_TYPE--}',
-				'{--ADMIN_NETWORK_REQUEST_PARAMETER_REMAIN--}',
-				'{--ADMIN_NETWORK_REQUEST_PARAMETER_REWARD--}',
-				'{--ADMIN_NETWORK_REQUEST_PARAMETER_SIZE--}',
-				'{--ADMIN_NETWORK_REQUEST_PARAMETER_EROTIC--}',
-				'{--ADMIN_NETWORK_REQUEST_PARAMETER_EXTRA--}'
+				'extra',
+				'country'
 			),
-			$key,
+			array(),
+			'',
 			'', '',
-			$GLOBALS['network_params_disabled']
+			$GLOBALS['network_params_disabled'],
+			'translateNetworkRequestParameter'
 		);
 	} // END - if
 
 	// Return content
-	return $GLOBALS['network_request_param_key'][$key];
+	return $GLOBALS[__FUNCTION__];
 }
 
 // Generator (somewhat getter) for (return) array translation
 function generateNetworkTranslationOptions ($default = '') {
 	// Is it cached?
-	if (!isset($GLOBALS['network_translation'][$default])) {
+	if (!isset($GLOBALS[__FUNCTION__][$default])) {
 		// Generate and cache it
-		$GLOBALS['network_translation'][$default] = generateOptionList(
+		$GLOBALS[__FUNCTION__][$default] = generateOptionList(
 			'network_translations',
 			'network_translation_id',
 			'network_translation_name',
@@ -574,15 +625,15 @@ function generateNetworkTranslationOptions ($default = '') {
 	} // END - if
 
 	// Return content
-	return $GLOBALS['network_translation'][$default];
+	return $GLOBALS[__FUNCTION__][$default];
 }
 
 // Generates an option list of request types
 function generateNetworkRequestTypeOptions ($default = '') {
 	// Do we have cache?
-	if (!isset($GLOBALS['network_request_type'][$default])) {
+	if (!isset($GLOBALS[__FUNCTION__][$default])) {
 		// Generate the list
-		$GLOBALS['network_request_type'][$default] = generateOptionList(
+		$GLOBALS[__FUNCTION__][$default] = generateOptionList(
 			'/ARRAY/',
 			array(
 				'GET',
@@ -597,25 +648,88 @@ function generateNetworkRequestTypeOptions ($default = '') {
 	} // END - if
 
 	// Return cache
-	return $GLOBALS['network_request_type'][$default];
+	return $GLOBALS[__FUNCTION__][$default];
+}
+
+// Generates an option list of network_active
+function generateNetworkActiveOptions ($default = '') {
+	// Do we have cache?
+	if (!isset($GLOBALS[__FUNCTION__][$default])) {
+		// Generate the list
+		$GLOBALS[__FUNCTION__][$default] = generateYesNoOptionList($default);
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__][$default];
 }
 
 // Translates 'translate_name' for e.g. templates
 function translateNetworkTranslationName ($name) {
 	// Get the message id
-	return getMessage('ADMIN_NETWORK_TRANSLATE_' . strtoupper($name) . '_NAME');
+	return '{--ADMIN_NETWORK_TRANSLATE_' . strtoupper($name) . '_NAME--}';
 }
 
 // Translates the network type handler (e.g. banner, paidmail) for templates
 function translateNetworkTypeHandler ($type) {
 	// Get the message id
-	return getMessage('ADMIN_NETWORK_TYPES_' . strtoupper($type) . '');
+	return '{--ADMIN_NETWORK_TYPES_' . strtoupper($type) . '--}';
 }
 
 // Translates request type
-function translateNetworkRequestType ($name) {
+function translateNetworkRequestType ($type) {
+	// Get the message id
+	return '{--ADMIN_NETWORK_REQUEST_TYPE_' . strtoupper($type) . '--}';
+}
+
+// Translates request parameter
+function translateNetworkRequestParameter ($param) {
 	// Get the message id
-	return getMessage('ADMIN_NETWORK_REQUEST_TYPE_' . strtoupper($name) . '');
+	return '{--ADMIN_NETWORK_REQUEST_PARAMETER_' . strtoupper($param) . '--}';
+}
+
+// Translates API index
+function translateNetworkApiIndex ($index) {
+	// Do we have cache?
+	if (!isset($GLOBALS['network_api_index'])) {
+		// Get an array of all API array indexes
+		$GLOBALS['network_api_index'] = array();
+
+		// Get all entries
+		$result = SQL_QUERY('SELECT
+	`network_api_id`, `network_api_index`, `network_translation_name`
+FROM
+	`{?_MYSQL_PREFIX?}_network_api_translation`
+INNER JOIN
+	`{?_MYSQL_PREFIX?}_network_translations`
+ON
+	`network_api_index`=`network_translation_id`
+ORDER BY
+	`sort` ASC', __FUNCTION__, __LINE__);
+
+		// Do we have entries?
+		if (!SQL_HASZERONUMS($result)) {
+			// Get all entries
+			while ($row = SQL_FETCHARRAY($result)) {
+				// Add it to our global array
+				$GLOBALS['network_api_index'][$row['network_api_index']] = $row;
+			} // END - while
+		} // END - if
+
+		// Free result
+		SQL_FREERESULT($result);
+	} // END - if
+
+	// Default name is unknown
+	$name = 'unknown';
+
+	// Is the entry there?
+	if (isset($GLOBALS['network_api_index'][$index])) {
+		// Then get the name
+		$name = $GLOBALS['network_api_index'][$index]['network_translation_name'];
+	} // END - if
+
+	// Return translation
+	return translateNetworkTranslationName($name);
 }
 
 //------------------------------------------------------------------------------
@@ -627,7 +741,7 @@ function doAdminNetworkProcessAddNetwork () {
 	// We can say here, the form is sent, so check if the network is already added
 	if (isNetworkNameValid(postRequestParameter('network_short_name'))) {
 		// Already there
-		loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_ALREADY_ADDED', postRequestParameter('network_short_name')));
+		loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_ALREADY_ADDED=' . postRequestParameter('network_short_name') . '%}');
 		return false;
 	} // END - if
 
@@ -638,7 +752,7 @@ function doAdminNetworkProcessAddNetwork () {
 	SQL_QUERY('INSERT INTO
 	`{?_MYSQL_PREFIX?}_network_data`
 (
-	`' . implode('`,`', array_keys(postRequestArray())) . "`
+	`' . implode('`, `', array_keys(postRequestArray())) . "`
 ) VALUES (
 	'" . implode("','", array_values(postRequestArray())) . "'
 )", __FUNCTION__, __LINE__);
@@ -647,12 +761,12 @@ function doAdminNetworkProcessAddNetwork () {
 	setPostRequestParameter('network_id', SQL_INSERTID());
 
 	// Output message
-	if (SQL_AFFECTEDROWS() == 1) {
+	if (!SQL_HASZEROAFFECTED()) {
 		// Successfully added
 		loadTemplate('admin_network_added', false, postRequestArray());
 	} else {
 		// Not added
-		loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_DATA_NOT_ADDED', postRequestParameter('network_short_name')));
+		loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_DATA_NOT_ADDED=' . postRequestParameter('network_short_name') . '%}');
 	}
 }
 
@@ -673,9 +787,9 @@ function doAdminNetworkProcessHandleNetwork () {
 					if (isFormSent('edit')) {
 						// Add row template for editing
 						$OUT .= loadTemplate('admin_edit_networks_row', true, $networkData);
-					} elseif (isFormSent('del')) {
+					} elseif (isFormSent('delete')) {
 						// Add row template for deleting
-						$OUT .= loadTemplate('admin_del_networks_row', true, $networkData);
+						$OUT .= loadTemplate('admin_delete_networks_row', true, $networkData);
 					} else {
 						// Problem!
 						debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
@@ -689,8 +803,8 @@ function doAdminNetworkProcessHandleNetwork () {
 			// Output main template
 			if (isFormSent('edit')) {
 				loadTemplate('admin_edit_networks', false, $OUT);
-			} elseif (isFormSent('del')) {
-				loadTemplate('admin_del_networks', false, $OUT);
+			} elseif (isFormSent('delete')) {
+				loadTemplate('admin_delete_networks', false, $OUT);
 			} else {
 				// Problem!
 				debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
@@ -725,9 +839,9 @@ function doAdminNetworkProcessHandleNetworkType () {
 					if (isFormSent('edit')) {
 						// Add row template for deleting
 						$OUT .= loadTemplate('admin_edit_network_types_row', true, $networkTypeData);
-					} elseif (isFormSent('del')) {
+					} elseif (isFormSent('delete')) {
 						// Add row template for deleting
-						$OUT .= loadTemplate('admin_del_network_types_row', true, $networkTypeData);
+						$OUT .= loadTemplate('admin_delete_network_types_row', true, $networkTypeData);
 					} else {
 						// Problem!
 						debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
@@ -741,8 +855,8 @@ function doAdminNetworkProcessHandleNetworkType () {
 			// Output main template
 			if (isFormSent('edit')) {
 				loadTemplate('admin_edit_network_types', false, $OUT);
-			} elseif (isFormSent('del')) {
-				loadTemplate('admin_del_network_types', false, $OUT);
+			} elseif (isFormSent('delete')) {
+				loadTemplate('admin_delete_network_types', false, $OUT);
 			} else {
 				// Problem!
 				debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
@@ -780,12 +894,12 @@ function doAdminNetworkProcessHandleRequestParams () {
 					if (isFormSent('edit')) {
 						// Add row template for deleting
 						$OUT .= loadTemplate('admin_edit_network_params_row', true, $networkRequestData);
-					} elseif (isFormSent('del')) {
+					} elseif (isFormSent('delete')) {
 						// Get type data
 						$networkRequestData['network_type_data'] = getNetworkTypeDataById($networkRequestData['network_type_id']);
 
 						// Add row template for deleting
-						$OUT .= loadTemplate('admin_del_network_params_row', true, $networkRequestData);
+						$OUT .= loadTemplate('admin_delete_network_params_row', true, $networkRequestData);
 					} else {
 						// Problem!
 						debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
@@ -799,8 +913,8 @@ function doAdminNetworkProcessHandleRequestParams () {
 			// Output main template
 			if (isFormSent('edit')) {
 				loadTemplate('admin_edit_network_params', false, $OUT);
-			} elseif (isFormSent('del')) {
-				loadTemplate('admin_del_network_params', false, $OUT);
+			} elseif (isFormSent('delete')) {
+				loadTemplate('admin_delete_network_params', false, $OUT);
 			} else {
 				// Problem!
 				debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
@@ -852,7 +966,7 @@ function doAdminNetworkProcessChangeNetwork () {
 		// Do we have updates?
 		if ($updated > 0) {
 			// Updates done
-			loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_UPDATED', $updated));
+			displayMessage('{%message,ADMIN_NETWORK_UPDATED=' . $updated . '%}');
 		} else {
 			// Nothing changed
 			loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_NOTHING_CHANGED--}');
@@ -879,7 +993,7 @@ function doAdminNetworkProcessRemoveNetwork () {
 		// Do we have removes?
 		if ($removed > 0) {
 			// Removals done
-			loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_REMOVED', $removed));
+			displayMessage('{%message,ADMIN_NETWORK_REMOVED=' . $removed . '%}');
 		} else {
 			// Nothing removed
 			loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_NOTHING_REMOVED--}');
@@ -892,7 +1006,7 @@ function doAdminNetworkProcessAddNetworkType () {
 	// Is the network type handle already used with given network?
 	if (isNetworkTypeHandleValid(postRequestParameter('network_type_handle'), getRequestParameter('network'))) {
 		// Already added
-		loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_TYPES_HANDLE_ALREADY_ADDED', postRequestParameter('network_type_handle')));
+		loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_TYPES_HANDLE_ALREADY_ADDED=' . postRequestParameter('network_type_handle') . '%}');
 
 		// ... so abort here
 		return false;
@@ -911,21 +1025,21 @@ function doAdminNetworkProcessAddNetworkType () {
 	} // END - if
 
 	// Add the whole request to database
-	SQL_QUERY("INSERT INTO
+	SQL_QUERY('INSERT INTO
 	`{?_MYSQL_PREFIX?}_network_types`
 (
-	`" . implode('`,`', array_keys(postRequestArray())) . "`
+	`' . implode('`, `', array_keys(postRequestArray())) . "`
 ) VALUES (
 	'" . implode("','", array_values(postRequestArray())) . "'
 )", __FUNCTION__, __LINE__);
 
 	// Output message
-	if (SQL_AFFECTEDROWS() == 1) {
+	if (!SQL_HASZEROAFFECTED()) {
 		// Successfully added
 		loadTemplate('admin_network_type_added', false, postRequestArray());
 	} else {
 		// Not added
-		loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_TYPES_NOT_ADDED', postRequestParameter('network_type_handle')));
+		loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_TYPES_NOT_ADDED=' . postRequestParameter('network_type_handle') . '%}');
 	}
 }
 
@@ -972,7 +1086,7 @@ function doAdminNetworkProcessChangeNetworkType () {
 		// Do we have updates?
 		if ($updated > 0) {
 			// Updates done
-			loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_TYPES_UPDATED', $updated));
+			displayMessage('{%message,ADMIN_NETWORK_TYPES_UPDATED=' . $updated . '%}');
 		} else {
 			// Nothing changed
 			loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_CHANGED--}');
@@ -1023,7 +1137,7 @@ function doAdminNetworkProcessChangeNetworkParam () {
 		// Do we have updates?
 		if ($updated > 0) {
 			// Updates done
-			loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_REQUEST_PARAMETER_UPDATED', $updated));
+			displayMessage('{%message,ADMIN_NETWORK_REQUEST_PARAMETER_UPDATED=' . $updated . '%}');
 		} else {
 			// Nothing changed
 			loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_CHANGED--}');
@@ -1050,7 +1164,7 @@ function doAdminNetworkProcessRemoveNetworkType () {
 		// Do we have removes?
 		if ($removed > 0) {
 			// Removals done
-			loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_TYPES_REMOVED', $removed));
+			displayMessage('{%message,ADMIN_NETWORK_TYPES_REMOVED=' . $removed . '%}');
 		} else {
 			// Nothing removed
 			loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_REMOVED--}');
@@ -1077,7 +1191,7 @@ function doAdminNetworkProcessRemoveNetworkParam () {
 		// Do we have removes?
 		if ($removed > 0) {
 			// Removals done
-			loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_REQUEST_PARAMETER_REMOVED', $removed));
+			displayMessage('{%message,ADMIN_NETWORK_REQUEST_PARAMETER_REMOVED=' . $removed . '%}');
 		} else {
 			// Nothing removed
 			loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_REMOVED--}');
@@ -1090,7 +1204,7 @@ function doAdminNetworkProcessAddNetworkParam () {
 	// Is the request parameter already used with given network?
 	if (isNetworkRequestParameterValid(postRequestParameter('request_param_key'), postRequestParameter('network_type_id'), getRequestParameter('network'))) {
 		// Already added
-		loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_REQUEST_PARAMETER_ALREADY_ADDED', postRequestParameter('request_param_key')));
+		loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_REQUEST_PARAMETER_ALREADY_ADDED=' . postRequestParameter('request_param_key') . '%}');
 
 		// ... so abort here
 		return false;
@@ -1112,18 +1226,64 @@ function doAdminNetworkProcessAddNetworkParam () {
 	SQL_QUERY('INSERT INTO
 	`{?_MYSQL_PREFIX?}_network_request_params`
 (
-	`' . implode('`,`', array_keys(postRequestArray())) . "`
+	`' . implode('`, `', array_keys(postRequestArray())) . "`
 ) VALUES (
 	'" . implode("','", array_values(postRequestArray())) . "'
 )", __FUNCTION__, __LINE__);
 
 	// Output message
-	if (SQL_AFFECTEDROWS() == 1) {
+	if (!SQL_HASZEROAFFECTED()) {
 		// Successfully added
 		loadTemplate('admin_network_request_param_added', false, postRequestArray());
 	} else {
 		// Not added
-		loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_REQUEST_PARAMETER_NOT_ADDED', postRequestParameter('request_param_key')));
+		loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_REQUEST_PARAMETER_NOT_ADDED=' . postRequestParameter('request_param_key') . '%}');
+	}
+}
+
+// Adds a API response array entry
+function doAdminNetworkProcessAddNetworkApiTranslation () {
+	// Is the request parameter already used with given network?
+	if (isNetworkApiTranslationValid(postRequestParameter('network_api_index'), postRequestParameter('network_type_id'), getRequestParameter('network'))) {
+		// Already added
+		loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_API_TRANSLATION_ALREADY_ADDED=' . postRequestParameter('network_api_index') . '%}');
+
+		// ... so abort here
+		return false;
+	} // END - if
+
+	// Remove the 'ok' part
+	unsetPostRequestParameter('ok');
+
+	// Add id
+	setPostRequestParameter('network_id', bigintval(getRequestParameter('network')));
+
+	// Add sorting
+	setPostRequestParameter('sort', (countSumTotalData(
+		postRequestParameter('network_id'),
+		'network_api_translation',
+		'network_api_id',
+		'network_id',
+		true,
+		sprintf(" AND `network_type_id`=%s", bigintval(postRequestParameter('network_type_id')))
+	) + 1));
+
+	// Add the whole request to database
+	SQL_QUERY('INSERT INTO
+	`{?_MYSQL_PREFIX?}_network_api_translation`
+(
+	`' . implode('`, `', array_keys(postRequestArray())) . "`
+) VALUES (
+	'" . implode("','", array_values(postRequestArray())) . "'
+)", __FUNCTION__, __LINE__);
+
+	// Output message
+	if (!SQL_HASZEROAFFECTED()) {
+		// Successfully added
+		loadTemplate('admin_network_api_translation_added', false, postRequestArray());
+	} else {
+		// Not added
+		loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_API_TRANSLATION_NOT_ADDED=' . postRequestParameter('network_api_index') . '%}');
 	}
 }
 
@@ -1146,6 +1306,6 @@ function doExpressionNetwork ($data) {
 	// Return it
 	return $code;
 }
+
 // [EOF]
 ?>
-