* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team *
* For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
addYouAreHereLink('admin', __FILE__);
// By default we should display list/add new forms
-$GLOBALS['network_display'] = true;
+$GLOBALS['network_display'] = TRUE;
// Handle form here
doNetworkHandleForm();
// Display forms?
-if ($GLOBALS['network_display'] === false) {
+if ($GLOBALS['network_display'] === FALSE) {
// Abort here
return;
} // END - if
-// Do we have a network selected?
+// Is there a network selected?
if (isGetRequestElementSet('network_id')) {
// Set current network id
setCurrentNetworkId(getRequestElement('network_id'));
// Is a network type handler selected?
if (isGetRequestElementSet('network_type_id')) {
// Load data for given network
- $result = SQL_QUERY_ESC('SELECT
- `network_id`,
- `network_type_id`,
- `network_type_handle`,
+ $result = sqlQueryEscaped('SELECT
+ `t`.`network_id`,
+ `t`.`network_type_id`,
+ `t`.`network_type_handler`,
+ `t`.`network_type_reload_time_unit`,
+ `d`.`network_active`,
NULL AS `network_data_id`,
NULL AS `network_max_reload_time`,
- NULL AS `network_reload_time_unit`,
NULL AS `network_min_waiting_time`,
+ NULL AS `network_max_waiting_time`,
+ NULL AS `network_min_remain_budget`,
NULL AS `network_min_remain_clicks`,
NULL AS `network_min_payment`,
- NULL AS `network_allow_erotic`
+ NULL AS `network_allow_erotic`,
+ NULL AS `network_media_size`,
+ NULL AS `network_media_output`
FROM
- `{?_MYSQL_PREFIX?}_network_types`
+ `{?_MYSQL_PREFIX?}_network_types` AS `t`
+INNER JOIN
+ `{?_MYSQL_PREFIX?}_network_data` AS `d`
+ON
+ d.network_id=t.network_id
WHERE
- `network_id`=%s AND
- `network_type_id`=%s
+ `t`.`network_id`=%s AND
+ `t`.`network_type_id`=%s
LIMIT 1',
array(
bigintval(getRequestElement('network_id')),
bigintval(getRequestElement('network_type_id'))
), __FUNCTION__, __LINE__);
- // Do we have a record?
- if (SQL_NUMROWS($result) == 1) {
+ // Is there a record?
+ if (sqlNumRows($result) == 1) {
// Load it
- $content = SQL_FETCHARRAY($result);
+ $content = sqlFetchArray($result);
+
+ // Is the network active?
+ if (($content['network_active'] == 'N') && (!isAdminsExpertWarningEnabled()) && (!isDebugModeEnabled())) {
+ // Not active
+ displayMessage('{--ADMIN_NETWORK_NOT_ACTIVE--}');
+ return;
+ } // END - if
// Check for network type configuration
- $result_config = SQL_QUERY_ESC('SELECT
+ $result_config = sqlQueryEscaped('SELECT
`network_data_id`,
`network_max_reload_time`,
- `network_reload_time_unit`,
- `network_min_waiting_time`
+ `network_min_waiting_time`,
+ `network_max_waiting_time`,
+ `network_min_remain_budget`,
`network_min_remain_clicks`,
`network_min_payment`,
- `network_allow_erotic`
+ `network_allow_erotic`,
+ `network_media_size`,
+ `network_media_output`
FROM
- `{?_MYSQL_PREFIX?}_network_types_config`
+ `{?_MYSQL_PREFIX?}_network_handler_config`
WHERE
`network_id`=%s AND
`network_type_id`=%s
$templateName = 'admin_add_config_network_type_form';
// Do we also have configuration?
- if (SQL_NUMROWS($result_config) == 1) {
+ if (sqlNumRows($result_config) == 1) {
// Load as well and merge it
- $content = merge_array($content, SQL_FETCHARRAY($result_config));
+ $content = merge_array($content, sqlFetchArray($result_config));
// Use template for editing
$templateName = 'admin_edit_config_network_type_form';
} // END - if
// Free result
- SQL_FREERESULT($result_config);
+ sqlFreeResult($result_config);
// "Translate" some values
$content['network_max_reload_time'] = createTimeSelections($content['network_max_reload_time'], 'network_max_reload_time', 'WDhms');
- $content['network_reload_time_unit'] = generateTimeUnitSelectionBox($content['network_reload_time_unit'], 'network_reload_time_unit', array('W', 'D', 'h', 'm', 's'));
// Load template
- loadTemplate($templateName, false, $content);
+ loadTemplate($templateName, FALSE, $content);
// Abort here
return;
} else {
// No entry found
- displayMessage('{%message,ADMIN_ADD_CONFIG_NETWORK_TYPE_404', bigintval(getRequestElement('network_id')) . '/' . bigintval(getRequestElement('network_type_id')));
+ displayMessage('{%message,ADMIN_ADD_CONFIG_NETWORK_HANDLER_TYPE_404=' . bigintval(getRequestElement('network_id')) . '/' . bigintval(getRequestElement('network_type_id')) . '%}');
} // END - if
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} // END - if
// Get all type handlers
- $result = SQL_QUERY_ESC('SELECT
+ $result = sqlQueryEscaped('SELECT
`network_id`,
`network_type_id`,
- `network_type_handle`
+ `network_type_handler`,
+ `network_type_reload_time_unit`
FROM
`{?_MYSQL_PREFIX?}_network_types`
WHERE
`network_id`=%s
ORDER BY
- `network_type_handle` ASC',
+ `network_type_handler` ASC',
array(
bigintval(getRequestElement('network_id'))
), __FUNCTION__, __LINE__);
- // Do we have entries left?
- if (!SQL_HASZERONUMS($result)) {
+ // Are there entries left?
+ if (!ifSqlHasZeroNums($result)) {
// Init row output
$OUT = '';
// List all entries
- while ($content = SQL_FETCHARRAY($result)) {
+ while ($content = sqlFetchArray($result)) {
// Check if config entry is there
- $result_config = SQL_QUERY_ESC('SELECT
+ $result_config = sqlQueryEscaped('SELECT
`network_data_id`,
`network_max_reload_time`,
- `network_reload_time_unit`,
`network_min_waiting_time`,
+ `network_max_waiting_time`,
+ `network_min_remain_budget`,
`network_min_remain_clicks`,
`network_min_payment`,
- `network_allow_erotic`
+ `network_allow_erotic`,
+ `network_media_size`,
+ `network_media_output`
FROM
- `{?_MYSQL_PREFIX?}_network_types_config`
+ `{?_MYSQL_PREFIX?}_network_handler_config`
WHERE
`network_id`=%s AND
`network_type_id`=%s
bigintval($content['network_type_id'])
), __FUNCTION__, __LINE__);
- // Do we have an entry?
- if (SQL_NUMROWS($result_config) == 1) {
+ // Is there an entry?
+ if (sqlNumRows($result_config) == 1) {
// Load this data as well
- $contentConfig = merge_array($content, SQL_FETCHARRAY($result_config));
+ $content = merge_array($content, sqlFetchArray($result_config));
// Add it with extra template
- $content['network_type_config_content'] = loadTemplate('admin_show_config_network_type', true, $contentConfig);
+ $content['network_type_config_content'] = loadTemplate('admin_show_config_network_type', TRUE, $content);
} else {
// No configuration found, so display form
- $content['network_type_config_content'] = loadTemplate('admin_add_config_network_type', true, $content);
+ $content['network_type_config_content'] = loadTemplate('admin_add_config_network_type', TRUE, $content);
}
// Free result
- SQL_FREERESULT($result_config);
+ sqlFreeResult($result_config);
// Load row template
- $OUT .= loadTemplate('admin_config_network_types_row', true, $content);
+ $OUT .= loadTemplate('admin_config_network_types_row', TRUE, $content);
} // END - while
// Prepare array for main template
);
// Load main template
- loadTemplate('admin_config_network_types', false, $content);
+ loadTemplate('admin_config_network_types', FALSE, $content);
} else {
// No entries found
- displayMessage('{%message,ADMIN_CONFIG_NETWORK_TYPES_404=' . bigintval(getRequestElement('network_id')) . '%}');
+ displayMessage('{%message,ADMIN_CONFIG_NETWORK_HANDLER_TYPES_404=' . bigintval(getRequestElement('network_id')) . '%}');
}
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} else {
// Generate network list for this script
- outputHtml(generateAdminNetworkList());
+ $OUT = generateAdminNetworkList(FALSE, TRUE, FALSE);
+
+ // Is it not empty?
+ if (!empty($OUT)) {
+ // Output it
+ outputHtml($OUT);
+ } else {
+ // Nothing configured yet
+ displayMessage('{--ADMIN_NETWORK_QUERY_API_404--}');
+ }
}
// [EOF]