debug_report_bug(__FUNCTION__, __LINE__, 'Invalid do ' . getRequestElement('do') . ', function ' . $functionName .' does not exist.', false);
} // END - if
+ // Init global arrays
+ $GLOBALS['network_types_disabled'] = array();
+
// Call-back the method handling our request
call_user_func($functionName);
}
$GLOBALS['network_data'][$networkId] = array();
// Query for the network data
- $result = SQL_QUERY_ESC('SELECT
+ $result = SQL_QUERY_ESC("SELECT
`network_id`,
`network_short_name`,
`network_title`,
`{?_MYSQL_PREFIX?}_network_data`
WHERE
`network_id`=%s
-LIMIT 1',
+LIMIT 1",
array(bigintval($networkId)), __FUNCTION__, __LINE__);
// Do we have an entry?
$GLOBALS['network_data'][$networkId] = array();
// Query for the network data
- $result = SQL_QUERY_ESC('SELECT
+ $result = SQL_QUERY_ESC("SELECT
d.`network_id`,
d.`network_short_name`,
d.`network_title`,
d.`network_id`=t.`network_id`
WHERE
t.`network_type_id`=%s
-LIMIT 1',
+LIMIT 1",
array(bigintval($networkId)), __FUNCTION__, __LINE__);
// Do we have an entry?
$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`
+WHERE
+ `network_active`='Y'
ORDER BY
- `network_short_name` ASC', __FUNCTION__, __LINE__);
+ `network_short_name` ASC", __FUNCTION__, __LINE__);
// Do we have entries?
if (!SQL_HASZERONUMS($result)) {
$content = '';
// Query all types of this network
- $result = SQL_QUERY('SELECT
- t.`network_type_id`, t.`network_type_handler`, d.`network_title`
+ $result = SQL_QUERY("SELECT
+ t.`network_type_id`,
+ t.`network_type_handler`,
+ d.`network_title`
FROM
`{?_MYSQL_PREFIX?}_network_types` AS t
LEFT JOIN
`{?_MYSQL_PREFIX?}_network_data` AS d
ON
t.`network_id`=d.`network_id`
+WHERE
+ d.`network_active`='Y'
ORDER BY
d.`network_short_name` ASC,
- t.`network_type_handler` ASC', __FUNCTION__, __LINE__);
+ t.`network_type_handler` ASC", __FUNCTION__, __LINE__);
// Do we have entries?
if (!SQL_HASZERONUMS($result)) {
}
// Generates an options list of all available (hard-coded) handlers
-function generateNetworkTypesAvailableOptions () {
+function generateNetworkTypesAvailableOptions ($defaultType = NULL) {
// Is it cached?
- if (!isset($GLOBALS[__FUNCTION__])) {
+ if (!isset($GLOBALS[__FUNCTION__][$defaultType])) {
// Generate list
- $GLOBALS[__FUNCTION__] = generateOptionList(
+ $GLOBALS[__FUNCTION__][$defaultType] = generateOptionList(
'/ARRAY/',
array(
'banner',
'traffic'
),
array(),
- '',
+ $defaultType,
'', '',
$GLOBALS['network_types_disabled'],
'translateNetworkTypeHandler'
} // END - if
// Return content
- return $GLOBALS[__FUNCTION__];
+ return $GLOBALS[__FUNCTION__][$defaultType];
}
// Generates an options list (somewhat getter) ofr request keys
// Translates 'translate_name' for e.g. templates
function translateNetworkTranslationName ($name) {
- // Get the message id
- return '{--ADMIN_NETWORK_TRANSLATE_' . strtoupper($name) . '_NAME--}';
+ // Generate id
+ $messageId = 'ADMIN_NETWORK_TRANSLATE_' . strtoupper($name) . '_NAME';
+
+ // Is the message id there?
+ if (!isMessageIdValid($messageId)) {
+ // Not valid type
+ debug_report_bug(__FUNCTION__, __LINE__, 'type=' . $type . ' is invalid.');
+ } // END - if
+
+ // Return message id
+ return '{--' . $messageId . '--}';
}
// Translates the network type handler (e.g. banner, paidmail) for templates
function translateNetworkTypeHandler ($type) {
- // Get the message id
- return '{--ADMIN_NETWORK_HANDLER_TYPES_' . strtoupper($type) . '--}';
+ // Generate id
+ $messageId = 'ADMIN_NETWORK_TYPE_HANDLER_' . strtoupper($type);
+
+ // Is the message id there?
+ if (!isMessageIdValid($messageId)) {
+ // Not valid type
+ debug_report_bug(__FUNCTION__, __LINE__, 'type=' . $type . ' is invalid.');
+ } // END - if
+
+ // Return message id
+ return '{--' . $messageId . '--}';
}
// Translates request type
function translateNetworkRequestType ($type) {
- // Get the message id
- return '{--ADMIN_NETWORK_REQUEST_TYPE_' . strtoupper($type) . '--}';
+ // Generate id
+ $messageId = 'ADMIN_NETWORK_REQUEST_TYPE_' . strtoupper($type) . '';
+
+ // Is the message id there?
+ if (!isMessageIdValid($messageId)) {
+ // Not valid type
+ debug_report_bug(__FUNCTION__, __LINE__, 'type=' . $type . ' is invalid.');
+ } // END - if
+
+ // Return message id
+ return '{--' . $messageId . '--}';
}
// Translates request parameter
function translateNetworkRequestParamKey ($param) {
- // Get the message id
- return '{--ADMIN_NETWORK_REQUEST_PARAMETER_' . strtoupper($param) . '--}';
+ // Generate id
+ $messageId = 'ADMIN_NETWORK_REQUEST_PARAMETER_' . strtoupper($param) . '';
+
+ // Is the message id there?
+ if (!isMessageIdValid($messageId)) {
+ // Not valid param
+ debug_report_bug(__FUNCTION__, __LINE__, 'param=' . $param . ' is invalid.');
+ } // END - if
+
+ // Return message id
+ return '{--' . $messageId . '--}';
}
// Translates API index
$GLOBALS['network_display'] = false;
} else {
// Nothing selected/found
- loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_HANDLER_TYPES_NOTHING_FOUND--}');
+ loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPE_HANDLER_NOTHING_FOUND--}');
}
} // END - if
}
// Is the network type handle already used with given network?
if (isNetworkTypeHandleValid(postRequestElement('network_type_handler'), getRequestElement('network_id'))) {
// Already added
- loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_HANDLER_TYPES_HANDLE_ALREADY_ADDED=' . postRequestElement('network_type_handler') . '%}');
+ loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_TYPE_HANDLER_ALREADY_ADDED=' . postRequestElement('network_type_handler') . '%}');
// ... so abort here
return false;
loadTemplate('admin_network_type_added', false, postRequestArray());
} else {
// Not added
- loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_HANDLER_TYPES_NOT_ADDED=' . postRequestElement('network_type_handler') . '%}');
+ loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_TYPE_HANDLER_NOT_ADDED=' . postRequestElement('network_type_handler') . '%}');
}
}
// Do we have updates?
if ($updated > 0) {
// Updates done
- displayMessage('{%message,ADMIN_NETWORK_HANDLER_TYPES_UPDATED=' . $updated . '%}');
+ displayMessage('{%message,ADMIN_NETWORK_TYPE_HANDLER_UPDATED=' . $updated . '%}');
} else {
// Nothing changed
- loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_HANDLER_TYPES_NOTHING_CHANGED--}');
+ loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPE_HANDLER_NOTHING_CHANGED--}');
}
} // END - if
}
// Do we have removes?
if ($removed > 0) {
// Removals done
- displayMessage('{%message,ADMIN_NETWORK_HANDLER_TYPES_REMOVED=' . $removed . '%}');
+ displayMessage('{%message,ADMIN_NETWORK_TYPE_HANDLER_REMOVED=' . $removed . '%}');
} else {
// Nothing removed
- loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_HANDLER_TYPES_NOTHING_REMOVED--}');
+ loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPE_HANDLER_NOTHING_REMOVED--}');
}
} // END - if
}
}
// Adds a request parameter to given network and type
-function doAdminNetworkProcessAddNetworkRequestParams () {
+function doAdminNetworkProcessAddRequestParam () {
// Is the request parameter already used with given network?
if (isNetworkRequestElementValid(postRequestElement('network_request_param_key'), postRequestElement('network_type_id'), getRequestElement('network_id'))) {
// Already added
}
// Only adds network type configuration if not yet present
-function doAdminNetworkProcessAddHandlerTypesConfig () {
+function doAdminNetworkProcessAddHandlerTypesConfig ($displayMessage = true) {
// Remove the 'ok' part
unsetPostRequestElement('ok');
$content = array();
$id = 'network_max_reload_time_ye';
$skip = false;
+
+ // Get all POST data
$postData = postRequestArray();
// Convert "reload time selections"
return;
} // END - if
- // Get SQL query for new entry
- $SQL = getInsertSqlFromArray(postRequestArray(), 'network_types_config');
+ // Copy 'set all' and remove it from POST data
+ $setAll = (postRequestElement('set_all') === 'Y');
+ unsetPostRequestElement('set_all');
- // Run the query
- SQL_QUERY($SQL, __FUNCTION__, __LINE__);
+ // Shall we set for all?
+ if ($setAll === true) {
+ // Get all handlers
+ $result = SQL_QUERY_ESC('SELECT `network_type_id` FROM `{?_MYSQL_PREFIX?}_network_types` WHERE `network_id`=%s ORDER BY `network_type_id` ASC',
+ array(bigintval(getRequestElement('network_id'))), __FUNCTION__, __LINE__);
- // Output message
- if (!SQL_HASZEROAFFECTED()) {
- // Successfully added
- displayMessage('{--ADMIN_CONFIG_NETWORK_HANDLER_TYPE_HANDLER_SAVED--}');
+ // Do we have entries?
+ if (SQL_HASZERONUMS($result)) {
+ // No, then abort here
+ displayMessage('{--ADMIN_CONFIG_NETWORK_HANDLER_SET_ALL_404--}');
+ return;
+ } // END - if
+
+ // Init number of rows
+ $numRows = 0;
+
+ // Fetch all ids
+ while (list($typeId) = SQL_FETCHROW($result)) {
+ // Set it in GET data
+ setGetRequestElement('network_type_id', $typeId);
+
+ // Call this function again
+ $numRows += doAdminNetworkProcessAddHandlerTypesConfig(false);
+ } // END - while
+
+ // Free result
+ SQL_FREERESULT($result);
+
+ // Output message
+ if ($numRows > 0) {
+ // Something has been updated
+ displayMessage('{%message,ADMIN_CONFIG_NETWORK_HANDLER_TYPE_ALL_HANDLER_SAVED=' . bigintval($numRows) . '%}');
+ } else {
+ // Nothing has been saved
+ loadTemplate('admin_settings_unsaved', false, '{--ADMIN_CONFIG_NETWORK_HANDLER_TYPE_HANDLER_NOT_CHANGED--}');
+ }
} else {
- // Not added
- loadTemplate('admin_settings_unsaved', false, '{--ADMIN_CONFIG_NETWORK_HANDLER_TYPE_HANDLER_NOT_SAVED--}');
+ // Get SQL query for new entry
+ $SQL = getInsertSqlFromArray(postRequestArray(), 'network_types_config');
+
+ // Run the query
+ SQL_QUERY($SQL, __FUNCTION__, __LINE__);
+
+ // Shall we display the message?
+ if ($displayMessage === true) {
+ // Output message
+ if (!SQL_HASZEROAFFECTED()) {
+ // Successfully added
+ displayMessage('{--ADMIN_CONFIG_NETWORK_HANDLER_TYPE_HANDLER_SAVED--}');
+ } else {
+ // Not added
+ loadTemplate('admin_settings_unsaved', false, '{--ADMIN_CONFIG_NETWORK_HANDLER_TYPE_HANDLER_NOT_SAVED--}');
+ }
+ } else {
+ // Return amount of affected rows (1 or 2)
+ return SQL_AFFECTEDROWS();
+ }
}
}
// Only changes network type configuration if not yet present
-function doAdminNetworkProcessEditHandlerTypesConfig () {
+function doAdminNetworkProcessEditHandlerTypesConfig ($displayMessage = true) {
// 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.
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'));
+ // Copy 'set all' and remove it from POST data
+ $setAll = (postRequestElement('set_all') === 'Y');
+ unsetPostRequestElement('set_all');
- // Run the query
- SQL_QUERY($SQL, __FUNCTION__, __LINE__);
+ // Shall we set for all?
+ if ($setAll === true) {
+ // Get all data entries
+ $result = SQL_QUERY_ESC('SELECT `network_data_id` FROM `{?_MYSQL_PREFIX?}_network_types_config` WHERE `network_id`=%s ORDER BY `network_type_id` ASC',
+ array(bigintval(getRequestElement('network_id'))), __FUNCTION__, __LINE__);
- // Output message
- if (!SQL_HASZEROAFFECTED()) {
- // Successfully added
- displayMessage('{--ADMIN_CONFIG_NETWORK_HANDLER_TYPE_HANDLER_SAVED--}');
+ // Do we have entries?
+ if (SQL_HASZERONUMS($result)) {
+ // No, then abort here
+ displayMessage('{--ADMIN_CONFIG_NETWORK_HANDLER_SET_ALL_404--}');
+ return;
+ } // END - if
+
+ // Init number of rows
+ $numRows = 0;
+
+ // Fetch all ids
+ while (list($dataId) = SQL_FETCHROW($result)) {
+ // Set it in GET data
+ setPostRequestElement('network_data_id', $dataId);
+
+ // Call this function again
+ $numRows += doAdminNetworkProcessEditHandlerTypesConfig(false);
+ } // END - while
+
+ // Free result
+ SQL_FREERESULT($result);
+
+ // Output message
+ if ($numRows > 0) {
+ // Something has been updated
+ displayMessage('{%message,ADMIN_CONFIG_NETWORK_HANDLER_TYPE_ALL_HANDLER_SAVED=' . bigintval($numRows) . '%}');
+ } else {
+ // Nothing has been saved
+ loadTemplate('admin_settings_unsaved', false, '{--ADMIN_CONFIG_NETWORK_HANDLER_TYPE_HANDLER_NOT_CHANGED--}');
+ }
} else {
- // Not added
- loadTemplate('admin_settings_unsaved', false, '{--ADMIN_CONFIG_NETWORK_HANDLER_TYPE_HANDLER_NOT_CHANGED--}');
+ // 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__);
+
+ // Shall we display the message?
+ if ($displayMessage === true) {
+ // Output message
+ if (!SQL_HASZEROAFFECTED()) {
+ // Successfully added
+ displayMessage('{--ADMIN_CONFIG_NETWORK_HANDLER_TYPE_HANDLER_SAVED--}');
+ } else {
+ // Not added
+ loadTemplate('admin_settings_unsaved', false, '{--ADMIN_CONFIG_NETWORK_HANDLER_TYPE_HANDLER_NOT_CHANGED--}');
+ }
+ } else {
+ // Return amount of affected rows (1 or 2)
+ return SQL_AFFECTEDROWS();
+ }
}
}
__FUNCTION__, __LINE__);
// Start an empty SQL query
- $SQL = '';
+ $SQL = "<pre>INSERT INTO `{?_MYSQL_PREFIX?}_network_data` (`network_short_name`,`network_title`,`network_reflink`,`network_data_separator`,`network_row_separator`,`network_request_type`,`network_charset`,`network_require_id_card`,`network_query_amount`) VALUES\n";
// Load all entries
while ($content = SQL_FETCHARRAY($result)) {
// Add row
- $SQL .= "<pre>('" .
+ $SQL .= "('" .
$content['network_short_name'] . "', '" .
$content['network_title'] . "', '" .
$content['network_reflink'] . "', '" .
$content['network_request_type'] . "', '" .
$content['network_charset'] . "', '" .
$content['network_require_id_card'] . "', " .
- $content['network_query_amount'] . '),</pre>';
+ $content['network_query_amount'] . "),\n";
} // END - while
// Remove last commata and close braces
- $SQL = substr($SQL, 0, -7) . '</pre>';
+ $SQL = substr($SQL, 0, -2) . '</pre>';
// Free result
SQL_FREERESULT($result);
`network_type_handler`,
`network_type_api_url`,
`network_type_click_url`,
- `network_type_banner_url`
+ `network_type_banner_url`,
+ `network_type_reload_time_unit`
FROM
`{?_MYSQL_PREFIX?}_network_types`
WHERE
// Is the column NULL?
if (is_null($content['network_type_banner_url'])) {
// Column is NULL
- $SQL .= "NULL),\n";
+ $SQL .= 'NULL';
} else {
// Column is set
- $SQL .= $content['network_type_banner_url'] . "'),\n";
+ $SQL .= "'" . $content['network_type_banner_url'] . "'";
}
+
+ // Add more
+ $SQL .= $content['network_type_reload_time_unit'] . "')\n";
} // END - while
// Remove last commata and close braces
$content['network_id'] . ', ' .
$content['network_type_id'] . ", '" .
$content['network_request_param_key'] . "', '" .
- $content['network_request_param_value'] . "', '";
+ $content['network_request_param_value'] . "', ";
// Is the column NULL?
if (is_null($content['network_request_param_default'])) {
$SQL .= "NULL),\n";
} else {
// Column is set
- $SQL .= $content['network_request_param_default'] . "'),\n";
+ $SQL .= "'" . $content['network_request_param_default'] . "'),\n";
}
} // END - while