}
// 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)) {
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
$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)) {
), __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)) {
$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
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)) {
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',
sprintf(
"WHERE `network_id`=%s",
bigintval(getRequestParameter('network'))
- )
+ ),
+ '',
+ 'translateNetworkTypeHandler'
+ );
+ } // END - if
+
+ // Return content
+ return $GLOBALS[__FUNCTION__][$id];
+}
+
+// Generates an options list of all available (hard-coded) handlers
+function generateNetworkTypesAvailableOptions () {
+ // Is it cached?
+ 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['network_type_options'][$id];
+ return $GLOBALS[__FUNCTION__];
}
-// Generator (somewhat getter) for request key options
-function generateNetworkRequestKeyOptions ($key) {
+// Generates an options list (somewhat getter) ofr request keys
+function generateNetworkRequestKeyOptions () {
// Is it cached?
- if (!isset($GLOBALS['network_request_param_key'][$key])) {
+ if (!isset($GLOBALS[__FUNCTION__])) {
// Generate and cache it
- $GLOBALS['network_request_param_key'][$key] = generateOptionList(
+ $GLOBALS[__FUNCTION__] = generateOptionList(
'/ARRAY/',
array(
'id',
'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 generateNetworkArrayTranslationOptions ($default) {
+function generateNetworkTranslationOptions ($default = '') {
// Is it cached?
- if (!isset($GLOBALS['network_array_translation'][$default])) {
+ if (!isset($GLOBALS[__FUNCTION__][$default])) {
// Generate and cache it
- $GLOBALS['network_array_translation'][$default] = generateOptionList(
+ $GLOBALS[__FUNCTION__][$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[__FUNCTION__][$default];
+}
+
+// Generates an option list of request types
+function generateNetworkRequestTypeOptions ($default = '') {
+ // Do we have cache?
+ if (!isset($GLOBALS[__FUNCTION__][$default])) {
+ // Generate the list
+ $GLOBALS[__FUNCTION__][$default] = generateOptionList(
+ '/ARRAY/',
+ array(
+ 'GET',
+ 'POST'
+ ),
+ array(
+ '{--ADMIN_NETWORK_REQUEST_TYPE_GET--}',
+ '{--ADMIN_NETWORK_REQUEST_TYPE_POST--}'
+ ),
+ $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');
+}
+
+// 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 ($type) {
+ // Get the message id
+ return getMessage('ADMIN_NETWORK_REQUEST_TYPE_' . strtoupper($type) . '');
+}
+
+// Translates request parameter
+function translateNetworkRequestParameter ($param) {
+ // Get the message id
+ return getMessage('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_NUMROWS($result) > 0) {
+ // 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);
}
//------------------------------------------------------------------------------
//------------------------------------------------------------------------------
// 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
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__);
}
// 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) {
// 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(
- '{--ADMIN_NETWORK_REQUEST_TYPE_GET--}',
- '{--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 {
}
// Handle network type form
-function doAdminNetworkProcessHandlenetworktypeForm () {
+function doAdminNetworkProcessHandleNetworkType () {
// Do we have selections?
- if (countPostSelection() > 0) {
+ if (ifPostContainsSelections()) {
// Load network data
$networkData = getNetworkDataById(getRequestParameter('network'));
// 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.');
}
// 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();
// 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')) {
// 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.');
}
// Changes given networks
-function doAdminNetworkProcessChangenetworkForm () {
+function doAdminNetworkProcessChangeNetwork () {
// Do we have selections?
- if (countPostSelection() > 0) {
+ if (ifPostContainsSelections()) {
// By default nothing is updated
$updated = 0;
}
// Removes given networks
-function doAdminNetworkProcessRemovenetworkForm () {
+function doAdminNetworkProcessRemoveNetwork () {
// Do we have selections?
- if (countPostSelection() > 0) {
+ if (ifPostContainsSelections()) {
// By default nothing is removed
$removed = 0;
}
// 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
} // 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__);
}
// 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;
}
// 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;
}
// 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;
}
// 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;
}
// 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
} // 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__);
}
}
+// 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('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_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
// [EOF]
?>
-
projects / mailer.git / blobdiff