X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fnetwork_functions.php;h=89392f1e1c73828748d25da4b3d631d77c3c8357;hb=f298f71846512b05d8eed6c03771253e2c39655f;hp=ad261c9aa045e27ec573a809acdd1f944d11e36b;hpb=cf3765c38cf0a76f396aca291f71858936e92956;p=mailer.git

diff --git a/inc/libs/network_functions.php b/inc/libs/network_functions.php
index ad261c9aa0..89392f1e1c 100644
--- a/inc/libs/network_functions.php
+++ b/inc/libs/network_functions.php
@@ -81,7 +81,7 @@ function doAdminNetworkProcessForm () {
 	}
 
 	// Create function name
-	$functionName = sprintf("doAdminNetworkProcess%sForm", ucfirst(strtolower(getRequestParameter('do'))));
+	$functionName = sprintf("doAdminNetworkProcess%s", capitalizeUnderscoreString(getRequestParameter('do')));
 
 	// Is the function valid?
 	if (!function_exists($functionName)) {
@@ -141,6 +141,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
@@ -358,15 +374,15 @@ function generateAdminNetworkList () {
 	$content = '';
 
 	// Query for all networks
-	$result = SQL_QUERY("SELECT
+	$result = SQL_QUERY('SELECT
 	`network_id`, `network_short_name`, `network_title`
 FROM
 	`{?_MYSQL_PREFIX?}_network_data`
 ORDER BY
-	`network_short_name` ASC", __FUNCTION__, __LINE__);
+	`network_short_name` ASC', __FUNCTION__, __LINE__);
 
 	// Do we have entries?
-	if (SQL_NUMROWS($result) > 0) {
+	if (!SQL_HASZERONUMS($result)) {
 		// List all entries
 		$rows = array();
 		while ($row = SQL_FETCHARRAY($result)) {
@@ -410,7 +426,7 @@ ORDER BY
 		), __FUNCTION__, __LINE__);
 
 	// Do we have entries?
-	if (SQL_NUMROWS($result) > 0) {
+	if (!SQL_HASZERONUMS($result)) {
 		// List all entries
 		$rows = array();
 		while ($row = SQL_FETCHARRAY($result)) {
@@ -441,7 +457,7 @@ function generateAdminDistinctNetworkTypeList () {
 	$content = '';
 
 	// Query all types of this network
-	$result = SQL_QUERY("SELECT
+	$result = SQL_QUERY('SELECT
 	t.`network_type_id`, t.`network_type_handle`, d.`network_title`
 FROM
 	`{?_MYSQL_PREFIX?}_network_types` AS t
@@ -451,10 +467,10 @@ ON
 	t.`network_id`=d.`network_id`
 ORDER BY
 	d.`network_short_name` ASC,
-	t.`network_type_handle` ASC", __FUNCTION__, __LINE__);
+	t.`network_type_handle` ASC', __FUNCTION__, __LINE__);
 
 	// Do we have entries?
-	if (SQL_NUMROWS($result) > 0) {
+	if (!SQL_HASZERONUMS($result)) {
 		// List all entries
 		$rows = array();
 		while ($row = SQL_FETCHARRAY($result)) {
@@ -497,7 +513,9 @@ function generateNetworkTypeOptions ($id) {
 			sprintf(
 				"WHERE `network_id`=%s",
 				bigintval(getRequestParameter('network'))
-			)
+			),
+			'',
+			'translateNetworkTypeHandler'
 		);
 	} // END - if
 
@@ -555,26 +573,65 @@ function generateNetworkRequestKeyOptions ($key) {
 }
 
 // Generator (somewhat getter) for (return) array translation
-function generateNetworkArrayTranslationOptions ($default) {
+function generateNetworkTranslationOptions ($default = '') {
 	// Is it cached?
-	if (!isset($GLOBALS['network_array_translation'][$default])) {
+	if (!isset($GLOBALS['network_translation'][$default])) {
 		// Generate and cache it
-		$GLOBALS['network_array_translation'][$default] = generateOptionList(
+		$GLOBALS['network_translation'][$default] = generateOptionList(
 			'network_translations',
-			'network_translation',
-			'network_translation',
+			'network_translation_id',
+			'network_translation_name',
 			$default,
 			'',
-			sprintf("WHERE `network_type_id`=%s",
-				bigintval(getRequestParameter('network_type'))
-			),
-			$GLOBALS['network_array_translation_disabled'],
-			'ADMIN_NETWORK_ARRAY_TRANSLATION_'
+			'',
+			$GLOBALS['network_translation_disabled'],
+			'translateNetworkTranslationName'
 		);
 	} // END - if
 
 	// Return content
-	return $GLOBALS['network_array_translation'][$default];
+	return $GLOBALS['network_translation'][$default];
+}
+
+// Generates an option list of request types
+function generateNetworkRequestTypeOptions ($default = '') {
+	// Do we have cache?
+	if (!isset($GLOBALS['network_request_type'][$default])) {
+		// Generate the list
+		$GLOBALS['network_request_type'][$default] = generateOptionList(
+			'/ARRAY/',
+			array(
+				'GET',
+				'POST'
+			),
+			array(
+				'{--ADMIN_NETWORK_REQUEST_TYPE_GET--}',
+				'{--ADMIN_NETWORK_REQUEST_TYPE_POST--}'
+			),
+			$default
+		);
+	} // END - if
+
+	// Return cache
+	return $GLOBALS['network_request_type'][$default];
+}
+
+// Translates 'translate_name' for e.g. templates
+function translateNetworkTranslationName ($name) {
+	// Get the message id
+	return getMessage('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) . '');
+}
+
+// Translates request type
+function translateNetworkRequestType ($name) {
+	// Get the message id
+	return getMessage('ADMIN_NETWORK_REQUEST_TYPE_' . strtoupper($name) . '');
 }
 
 //------------------------------------------------------------------------------
@@ -582,7 +639,7 @@ function generateNetworkArrayTranslationOptions ($default) {
 //------------------------------------------------------------------------------
 
 // Callback function to add new network
-function doAdminNetworkProcessAddnetworkForm () {
+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
@@ -594,10 +651,10 @@ function doAdminNetworkProcessAddnetworkForm () {
 	unsetPostRequestParameter('ok');
 
 	// Add the whole request to database
-	SQL_QUERY("INSERT INTO
+	SQL_QUERY('INSERT INTO
 	`{?_MYSQL_PREFIX?}_network_data`
 (
-	`" . implode('`,`', array_keys(postRequestArray())) . "`
+	`' . implode('`,`', array_keys(postRequestArray())) . "`
 ) VALUES (
 	'" . implode("','", array_values(postRequestArray())) . "'
 )", __FUNCTION__, __LINE__);
@@ -616,9 +673,9 @@ function doAdminNetworkProcessAddnetworkForm () {
 }
 
 // Displays selected networks for editing
-function doAdminNetworkProcessHandlenetworkForm () {
+function doAdminNetworkProcessHandleNetwork () {
 	// Do we have selections?
-	if (countPostSelection() > 0) {
+	if (ifPostContainsSelections()) {
 		// Something has been selected, so start displaying one by one
 		$OUT = '';
 		foreach (postRequestParameter('sel') as $id => $sel) {
@@ -630,26 +687,9 @@ function doAdminNetworkProcessHandlenetworkForm () {
 				// Do we have found the network?
 				if (count($networkData) > 0) {
 					if (isFormSent('edit')) {
-						// Make selection box for network_request_type
-						$networkData['network_request_type'] = generateOptionList(
-							'/ARRAY/',
-							array(
-								'GET',
-								'POST'
-							),
-							array(
-								getMessage('ADMIN_NETWORK_REQUEST_TYPE_GET'),
-								getMessage('ADMIN_NETWORK_REQUEST_TYPE_POST')
-							),
-							$networkData['network_request_type']
-						);
-
 						// Add row template for editing
 						$OUT .= loadTemplate('admin_edit_networks_row', true, $networkData);
 					} elseif (isFormSent('del')) {
-						// Translate the request type
-						$networkData['network_request_type'] = '{--ADMIN_NETWORK_REQUEST_TYPE_' . $networkData['network_request_type'] . '--}';
-
 						// Add row template for deleting
 						$OUT .= loadTemplate('admin_del_networks_row', true, $networkData);
 					} else {
@@ -682,9 +722,9 @@ function doAdminNetworkProcessHandlenetworkForm () {
 }
 
 // Handle network type form
-function doAdminNetworkProcessHandlenetworktypeForm () {
+function doAdminNetworkProcessHandleNetworkType () {
 	// Do we have selections?
-	if (countPostSelection() > 0) {
+	if (ifPostContainsSelections()) {
 		// Load network data
 		$networkData = getNetworkDataById(getRequestParameter('network'));
 
@@ -714,17 +754,11 @@ function doAdminNetworkProcessHandlenetworktypeForm () {
 
 		// If we have no rows, we don't need to display the edit form
 		if (!empty($OUT)) {
-			// Prepare content for template
-			$content = array(
-				'rows'         => $OUT,
-				'network_data' => getNetworkDataById(getRequestParameter('network'))
-			);
-
 			// Output main template
 			if (isFormSent('edit')) {
-				loadTemplate('admin_edit_network_types', false, $content);
+				loadTemplate('admin_edit_network_types', false, $OUT);
 			} elseif (isFormSent('del')) {
-				loadTemplate('admin_del_network_types', false, $content);
+				loadTemplate('admin_del_network_types', false, $OUT);
 			} else {
 				// Problem!
 				debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
@@ -740,9 +774,9 @@ function doAdminNetworkProcessHandlenetworktypeForm () {
 }
 
 // Handle network request parameter form
-function doAdminNetworkProcessHandlerequestparamsForm () {
+function doAdminNetworkProcessHandleRequestParams () {
 	// Do we have selections?
-	if (countPostSelection() > 0) {
+	if (ifPostContainsSelections()) {
 		// Init cache array
 		$GLOBALS['network_params_disabled'] = array();
 
@@ -760,12 +794,6 @@ function doAdminNetworkProcessHandlerequestparamsForm () {
 				// Do we have found the network?
 				if (count($networkRequestData) > 0) {
 					if (isFormSent('edit')) {
-						// Add options list for network type
-						$networkRequestData['type_options'] = generateNetworkTypeOptions($networkRequestData['network_type_id']);
-
-						// Add options list for request key
-						$networkRequestData['key_options'] = generateNetworkRequestKeyOptions($networkRequestData['request_param_key']);
-
 						// Add row template for deleting
 						$OUT .= loadTemplate('admin_edit_network_params_row', true, $networkRequestData);
 					} elseif (isFormSent('del')) {
@@ -784,17 +812,11 @@ function doAdminNetworkProcessHandlerequestparamsForm () {
 
 		// If we have no rows, we don't need to display the edit form
 		if (!empty($OUT)) {
-			// Prepare content for template
-			$content = array(
-				'rows'         => $OUT,
-				'network_data' => getNetworkDataById(getRequestParameter('network'))
-			);
-
 			// Output main template
 			if (isFormSent('edit')) {
-				loadTemplate('admin_edit_network_params', false, $content);
+				loadTemplate('admin_edit_network_params', false, $OUT);
 			} elseif (isFormSent('del')) {
-				loadTemplate('admin_del_network_params', false, $content);
+				loadTemplate('admin_del_network_params', false, $OUT);
 			} else {
 				// Problem!
 				debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
@@ -810,9 +832,9 @@ function doAdminNetworkProcessHandlerequestparamsForm () {
 }
 
 // Changes given networks
-function doAdminNetworkProcessChangenetworkForm () {
+function doAdminNetworkProcessChangeNetwork () {
 	// Do we have selections?
-	if (countPostSelection() > 0) {
+	if (ifPostContainsSelections()) {
 		// By default nothing is updated
 		$updated = 0;
 
@@ -855,9 +877,9 @@ function doAdminNetworkProcessChangenetworkForm () {
 }
 
 // Removes given networks
-function doAdminNetworkProcessRemovenetworkForm () {
+function doAdminNetworkProcessRemoveNetwork () {
 	// Do we have selections?
-	if (countPostSelection() > 0) {
+	if (ifPostContainsSelections()) {
 		// By default nothing is removed
 		$removed = 0;
 
@@ -882,7 +904,7 @@ function doAdminNetworkProcessRemovenetworkForm () {
 }
 
 // Add a network type handler if not yet found
-function doAdminNetworkProcessAddnetworktypeForm () {
+function doAdminNetworkProcessAddNetworkType () {
 	// Is the network type handle already used with given network?
 	if (isNetworkTypeHandleValid(postRequestParameter('network_type_handle'), getRequestParameter('network'))) {
 		// Already added
@@ -905,10 +927,10 @@ function doAdminNetworkProcessAddnetworktypeForm () {
 	} // 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__);
@@ -924,9 +946,9 @@ function doAdminNetworkProcessAddnetworktypeForm () {
 }
 
 // Changes given network type handlers
-function doAdminNetworkProcessChangenetworktypeForm () {
+function doAdminNetworkProcessChangeNetworkType () {
 	// Do we have selections?
-	if (countPostSelection() > 0) {
+	if (ifPostContainsSelections()) {
 		// By default nothing is updated
 		$updated = 0;
 
@@ -975,9 +997,9 @@ function doAdminNetworkProcessChangenetworktypeForm () {
 }
 
 // Changes given network request parameters
-function doAdminNetworkProcessChangenetworkparamForm () {
+function doAdminNetworkProcessChangeNetworkParam () {
 	// Do we have selections?
-	if (countPostSelection() > 0) {
+	if (ifPostContainsSelections()) {
 		// By default nothing is updated
 		$updated = 0;
 
@@ -1026,9 +1048,9 @@ function doAdminNetworkProcessChangenetworkparamForm () {
 }
 
 // Removes given network type handlers
-function doAdminNetworkProcessRemovenetworktypeForm () {
+function doAdminNetworkProcessRemoveNetworkType () {
 	// Do we have selections?
-	if (countPostSelection() > 0) {
+	if (ifPostContainsSelections()) {
 		// By default nothing is removed
 		$removed = 0;
 
@@ -1053,9 +1075,9 @@ function doAdminNetworkProcessRemovenetworktypeForm () {
 }
 
 // Removes given network request parameters
-function doAdminNetworkProcessRemovenetworkparamForm () {
+function doAdminNetworkProcessRemoveNetworkParam () {
 	// Do we have selections?
-	if (countPostSelection() > 0) {
+	if (ifPostContainsSelections()) {
 		// By default nothing is removed
 		$removed = 0;
 
@@ -1080,7 +1102,7 @@ function doAdminNetworkProcessRemovenetworkparamForm () {
 }
 
 // Adds a request parameter to given network and type
-function doAdminNetworkProcessAddnetworkparamForm () {
+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
@@ -1103,10 +1125,10 @@ function doAdminNetworkProcessAddnetworkparamForm () {
 	} // END - if
 
 	// Add the whole request to database
-	SQL_QUERY("INSERT INTO
+	SQL_QUERY('INSERT INTO
 	`{?_MYSQL_PREFIX?}_network_request_params`
 (
-	`" . implode('`,`', array_keys(postRequestArray())) . "`
+	`' . implode('`,`', array_keys(postRequestArray())) . "`
 ) VALUES (
 	'" . implode("','", array_values(postRequestArray())) . "'
 )", __FUNCTION__, __LINE__);
@@ -1121,6 +1143,42 @@ function doAdminNetworkProcessAddnetworkparamForm () {
 	}
 }
 
+// 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, getMaskedMessage('ADMIN_NETWORK_API_TRANSLATION_ALREADY_ADDED', postRequestParameter('request_param_key')));
+
+		// ... so abort here
+		return false;
+	} // END - if
+
+	// Remove the 'ok' part
+	unsetPostRequestParameter('ok');
+
+	// Add id
+	setPostRequestParameter('network_id', bigintval(getRequestParameter('network')));
+
+	// 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_AFFECTEDROWS() == 1) {
+		// Successfully added
+		loadTemplate('admin_network_api_translation_added', false, postRequestArray());
+	} else {
+		// Not added
+		loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_API_TRANSLATION_NOT_ADDED', postRequestParameter('network_api_index')));
+	}
+}
+
 // Do expression code for this extension
 function doExpressionNetwork ($data) {
 	// Construct replacer
@@ -1140,7 +1198,6 @@ function doExpressionNetwork ($data) {
 	// Return it
 	return $code;
 }
-
 // [EOF]
 ?>