// Checks wether the given network request parameter is already used (valid)
function isNetworkRequestElementValid ($key, $type, $networkId) {
// Query for it
- $result = SQL_QUERY_ESC("SELECT `network_param_id` FROM `{?_MYSQL_PREFIX?}_network_request_params` WHERE `network_id`=%s AND `network_type_id`=%s AND `request_param_key`='%s' LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `network_request_param_id` FROM `{?_MYSQL_PREFIX?}_network_request_params` WHERE `network_id`=%s AND `network_type_id`=%s AND `network_request_param_key`='%s' LIMIT 1",
array($networkId, $type, $key), __FUNCTION__, __LINE__);
// Does it exist?
// Query for the network data
$result = SQL_QUERY_ESC("SELECT
- `network_param_id`,
+ `network_request_param_id`,
`network_id`,
`network_type_id`,
- `request_param_key`,
- `request_param_value`,
- `request_param_default`
+ `network_request_param_key`,
+ `network_request_param_value`,
+ `network_request_param_default`
FROM
`{?_MYSQL_PREFIX?}_network_request_params`
WHERE
- `network_param_id`=%s
+ `network_request_param_id`=%s
LIMIT 1",
array(bigintval($networkId)), __FUNCTION__, __LINE__);
} // END - if
// Just call our inner method
- return adminSaveSettings($networkParamData, '_network_request_params', sprintf("`network_param_id`=%s", bigintval($networkId)), array(), false, false);
+ return adminSaveSettings($networkParamData, '_network_request_params', sprintf("`network_request_param_id`=%s", bigintval($networkId)), array(), false, false);
}
// Removes given network entry
// Query for all networks
$result = SQL_QUERY('SELECT
- `network_id`,`network_short_name`,`network_title`
+ `network_id`,
+ `network_short_name`,
+ `network_title`
FROM
`{?_MYSQL_PREFIX?}_network_data`
ORDER BY
} // END - while
// Generate the selection box
- $content = generateSelectionBoxFromArray($rows, 'network', 'network_id');
+ $content = generateSelectionBoxFromArray($rows, 'network_id', 'network_id', '', '', 'network');
} else {
// Nothing selected
$content = loadTemplate('admin_settings_unsaved', false, '{--ADMIN_ENTRIES_404--}');
'',
sprintf(
"WHERE `network_id`=%s",
- bigintval(getRequestElement('network'))
+ bigintval(getRequestElement('network_id'))
),
'',
'translateNetworkTypeHandler'
return $GLOBALS[__FUNCTION__][$networkId];
}
+// Checks wether the given network type handler is configured
+function isNetworkTypeHandlerConfigured ($networkId, $networkTypeId) {
+ // Do we have cache?
+ if (!isset($GLOBALS[__FUNCTION__][$networkId][$networkTypeId])) {
+ // Determine it
+ $GLOBALS[__FUNCTION__][$networkId][$networkTypeId] = (countSumTotalData(
+ bigintval($networkTypeId),
+ 'network_types_config',
+ 'network_data_id',
+ 'network_type_id',
+ true,
+ sprintf(' AND `network_id`=%s', bigintval($networkId))
+ ) == 1);
+ } // END - if
+
+ // Return cache
+ return $GLOBALS[__FUNCTION__][$networkId][$networkTypeId];
+}
+
//------------------------------------------------------------------------------
// Call-back functions
//------------------------------------------------------------------------------
unsetPostRequestElement('ok');
// Add the whole request to database
- SQL_QUERY('INSERT INTO
- `{?_MYSQL_PREFIX?}_network_data`
-(
- `' . implode('`,`', array_keys(postRequestArray())) . "`
-) VALUES (
- '" . implode("','", array_values(postRequestArray())) . "'
-)", __FUNCTION__, __LINE__);
+ SQL_QUERY(getInsertSqlFromArray(postRequestArray(), 'network_data'), __FUNCTION__, __LINE__);
// Add the id for output only
setPostRequestElement('network_id', SQL_INSERTID());
// Do we have selections?
if (ifPostContainsSelections()) {
// Load network data
- $networkData = getNetworkDataById(getRequestElement('network'));
+ $networkData = getNetworkDataById(getRequestElement('network_id'));
// Something has been selected, so start displaying one by one
$OUT = '';
$GLOBALS['network_params_disabled'] = array();
// Load network data
- $networkData = getNetworkDataById(getRequestElement('network'));
+ $networkData = getNetworkDataById(getRequestElement('network_id'));
// Something has been selected, so start displaying one by one
$OUT = '';
// Add a network type handler if not yet found
function doAdminNetworkProcessAddNetworkType () {
// Is the network type handle already used with given network?
- if (isNetworkTypeHandleValid(postRequestElement('network_type_handle'), getRequestElement('network'))) {
+ if (isNetworkTypeHandleValid(postRequestElement('network_type_handle'), getRequestElement('network_id'))) {
// Already added
loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_TYPES_HANDLE_ALREADY_ADDED=' . postRequestElement('network_type_handle') . '%}');
unsetPostRequestElement('ok');
// Add id
- setPostRequestElement('network_id', bigintval(getRequestElement('network')));
+ setPostRequestElement('network_id', bigintval(getRequestElement('network_id')));
// Is network_type_banner_url set?
if (postRequestElement('network_type_banner_url') == '') {
} // END - if
// Add the whole request to database
- SQL_QUERY('INSERT INTO
- `{?_MYSQL_PREFIX?}_network_types`
-(
- `' . implode('`,`', array_keys(postRequestArray())) . "`
-) VALUES (
- '" . implode("','", array_values(postRequestArray())) . "'
-)", __FUNCTION__, __LINE__);
+ SQL_QUERY(getInsertSqlFromArray(postRequestArray(), 'network_types'), __FUNCTION__, __LINE__);
// Output message
if (!SQL_HASZEROAFFECTED()) {
debug_report_bug(__FUNCTION__, __LINE__, 'No entry in key=' . $key . ', id=' . $networkId . ' found.');
} // END - if
- // Fix empty request_param_default to NULL
- if (($key == 'request_param_default') && (trim($entry[$networkId]) == '')) {
+ // Fix empty network_request_param_default to NULL
+ if (($key == 'network_request_param_default') && (trim($entry[$networkId]) == '')) {
// Set it to NULL
$entry[$networkId] = NULL;
} // END - if
// Update this entry?
if ($sel == 1) {
// Remove this entry
- $removed += doAdminRemoveNetworkEntry('request_params', 'network_param_id', $networkId);
+ $removed += doAdminRemoveNetworkEntry('request_params', 'network_request_param_id', $networkId);
} // END - if
} // END - foreach
// Adds a request parameter to given network and type
function doAdminNetworkProcessAddNetworkParam () {
// Is the request parameter already used with given network?
- if (isNetworkRequestElementValid(postRequestElement('request_param_key'), postRequestElement('network_type_id'), getRequestElement('network'))) {
+ if (isNetworkRequestElementValid(postRequestElement('network_request_param_key'), postRequestElement('network_type_id'), getRequestElement('network_id'))) {
// Already added
- loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_REQUEST_PARAMETER_ALREADY_ADDED=' . postRequestElement('request_param_key') . '%}');
+ loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_REQUEST_PARAMETER_ALREADY_ADDED=' . postRequestElement('network_request_param_key') . '%}');
// ... so abort here
return false;
unsetPostRequestElement('ok');
// Add id
- setPostRequestElement('network_id', bigintval(getRequestElement('network')));
+ setPostRequestElement('network_id', bigintval(getRequestElement('network_id')));
- // Is request_param_default set?
- if (postRequestElement('request_param_default') == '') {
+ // Is network_request_param_default set?
+ if (postRequestElement('network_request_param_default') == '') {
// Remove empty value to get a NULL for an optional entry
- unsetPostRequestElement('request_param_default');
+ unsetPostRequestElement('network_request_param_default');
} // END - if
// Add the whole request to database
- SQL_QUERY('INSERT INTO
- `{?_MYSQL_PREFIX?}_network_request_params`
-(
- `' . implode('`,`', array_keys(postRequestArray())) . "`
-) VALUES (
- '" . implode("','", array_values(postRequestArray())) . "'
-)", __FUNCTION__, __LINE__);
+ SQL_QUERY(getInsertSqlFromArray(postRequestArray(), 'network_request_params'), __FUNCTION__, __LINE__);
// Output message
if (!SQL_HASZEROAFFECTED()) {
loadTemplate('admin_network_request_param_added', false, postRequestArray());
} else {
// Not added
- loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_REQUEST_PARAMETER_NOT_ADDED=' . postRequestElement('request_param_key') . '%}');
+ loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_REQUEST_PARAMETER_NOT_ADDED=' . postRequestElement('network_request_param_key') . '%}');
}
}
// Adds a API response array entry
function doAdminNetworkProcessAddNetworkApiTranslation () {
// Is the request parameter already used with given network?
- if (isNetworkApiTranslationValid(postRequestElement('network_api_index'), postRequestElement('network_type_id'), getRequestElement('network'))) {
+ if (isNetworkApiTranslationValid(postRequestElement('network_api_index'), postRequestElement('network_type_id'), getRequestElement('network_id'))) {
// Already added
loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_API_TRANSLATION_ALREADY_ADDED=' . postRequestElement('network_api_index') . '%}');
unsetPostRequestElement('ok');
// Add id
- setPostRequestElement('network_id', bigintval(getRequestElement('network')));
+ setPostRequestElement('network_id', bigintval(getRequestElement('network_id')));
// Add sorting
setPostRequestElement('sort', (countSumTotalData(
) + 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__);
+ SQL_QUERY(getInsertSqlFromArray(postRequestArray(), 'network_api_translation'), __FUNCTION__, __LINE__);
// Output message
if (!SQL_HASZEROAFFECTED()) {
unsetPostRequestElement('ok');
// Add id
- setPostRequestElement('network_id', bigintval(getRequestElement('network')));
+ setPostRequestElement('network_id', bigintval(getRequestElement('network_id')));
+
+ // Is network_api_referral_button set?
+ if (postRequestElement('network_api_referral_button') == '') {
+ // Remove empty value to get a NULL for an optional entry
+ unsetPostRequestElement('network_api_referral_button');
+ } // END - if
// Is there already an entry?
- if (isNetworkApiConfigured(getRequestElement('network'))) {
+ if (isNetworkApiConfigured(getRequestElement('network_id'))) {
// Generate SQL query
$SQL = getUpdateSqlFromArray(postRequestArray(), 'network_api_config', 'network_id', postRequestElement('network_id'), array('network_id'));
} else {
// Insert new entry
- $SQL = 'INSERT INTO
- `{?_MYSQL_PREFIX?}_network_api_config`
-(
- `' . implode('`,`', array_keys(postRequestArray())) . "`
-) VALUES (
- '" . implode("','", array_values(postRequestArray())) . "'
-)";
+ $SQL = getInsertSqlFromArray(postRequestArray(), 'network_api_config');
}
// Run the query
}
}
+// Only adds network type configuration if not yet present
+function doAdminNetworkProcessAddNetworkTypesConfig () {
+ // Remove the 'ok' part
+ unsetPostRequestElement('ok');
+
+ // Add both ids
+ setPostRequestElement('network_id', bigintval(getRequestElement('network_id')));
+ setPostRequestElement('network_type_id', bigintval(getRequestElement('network_type_id')));
+
+ /*
+ * Some parameters are optional, at least one must be given so check a bunch
+ * of parameters.
+ */
+ foreach (array('network_min_waiting_time', 'network_min_remain_clicks', 'network_min_payment', 'network_allow_erotic') as $element) {
+ // Is this element empty?
+ if (postRequestElement($element) == '') {
+ // Then unset it to get a NULL for optional parameter
+ unsetPostRequestElement($element);
+ } // END - if
+ } // END - foreach
+
+ // Initialize variables
+ $content = array();
+ $id = 'network_max_reload_time_ye';
+ $skip = false;
+ $postData = postRequestArray();
+
+ // Convert "reload time selections"
+ convertSelectionsToEpocheTime($postData, $content, $id, $skip);
+
+ // Set the POST array back
+ setPostRequestArray($postData);
+
+ // Is there already an entry?
+ if (isNetworkTypeHandlerConfigured(getRequestElement('network_id'), getRequestElement('network_type_id'))) {
+ // This network type handler is already configured
+ displayMessage('{--ADMIN_NETWORK_TYPE_HANDLER_ALREADY_CONFIGURED--}');
+ return;
+ } // END - if
+
+ // Get SQL query for new entry
+ $SQL = getInsertSqlFromArray(postRequestArray(), 'network_types_config');
+
+ // Run the query
+ SQL_QUERY($SQL, __FUNCTION__, __LINE__);
+
+ // Output message
+ if (!SQL_HASZEROAFFECTED()) {
+ // Successfully added
+ displayMessage('{--ADMIN_CONFIG_NETWORK_TYPE_HANDLER_SAVED--}');
+ } else {
+ // Not added
+ loadTemplate('admin_settings_unsaved', false, '{--ADMIN_CONFIG_NETWORK_TYPE_HANDLER_NOT_SAVED--}');
+ }
+}
+
+// Only changes network type configuration if not yet present
+function doAdminNetworkProcessEditNetworkTypesConfig () {
+ // Remove the 'ok' part
+ unsetPostRequestElement('ok');
+
+ // Add both ids
+ setPostRequestElement('network_id', bigintval(getRequestElement('network_id')));
+ setPostRequestElement('network_type_id', bigintval(getRequestElement('network_type_id')));
+
+ /*
+ * Some parameters are optional, at least one must be given so check a bunch
+ * of parameters.
+ */
+ foreach (array('network_min_waiting_time', 'network_min_remain_clicks', 'network_min_payment', 'network_allow_erotic') as $element) {
+ // Is this element empty?
+ if (postRequestElement($element) == '') {
+ // Then unset it to get a NULL for optional parameter
+ unsetPostRequestElement($element);
+ } // END - if
+ } // END - foreach
+
+ // Initialize variables
+ $content = array();
+ $id = 'network_max_reload_time_ye';
+ $skip = false;
+ $postData = postRequestArray();
+
+ // Convert "reload time selections"
+ convertSelectionsToEpocheTime($postData, $content, $id, $skip);
+
+ // Set the POST array back
+ setPostRequestArray($postData);
+
+ // Is there already an entry?
+ if (!isNetworkTypeHandlerConfigured(getRequestElement('network_id'), getRequestElement('network_type_id'))) {
+ // This network type handler is not configured
+ displayMessage('{--ADMIN_NETWORK_TYPE_HANDLER_NOT_CONFIGURED--}');
+ return;
+ } // END - if
+
+ // Get SQL query for new entry
+ $SQL = getUpdateSqlFromArray(postRequestArray(), 'network_types_config', 'network_data_id', postRequestElement('network_data_id'), array('network_data_id'));
+
+ // Run the query
+ SQL_QUERY($SQL, __FUNCTION__, __LINE__);
+
+ // Output message
+ if (!SQL_HASZEROAFFECTED()) {
+ // Successfully added
+ displayMessage('{--ADMIN_CONFIG_NETWORK_TYPE_HANDLER_SAVED--}');
+ } else {
+ // Not added
+ loadTemplate('admin_settings_unsaved', false, '{--ADMIN_CONFIG_NETWORK_TYPE_HANDLER_NOT_CHANGED--}');
+ }
+}
+
// Do expression code for this extension
function doExpressionNetwork ($data) {
// Construct replacer
$data['extra_func']
);
- // Replace %network% with the current network id
- $replacer = str_replace('%network%', getCurrentNetworkId(), $replacer);
+ // Replace %network_id% with the current network id
+ $replacer = str_replace('%network_id%', getCurrentNetworkId(), $replacer);
// Replace the code
$code = replaceExpressionCode($data, $replacer);