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);
}
// Checks wether the given network type is already used (valid)
function isNetworkTypeHandleValid ($type, $networkId) {
// Query for it
- $result = SQL_QUERY_ESC("SELECT `network_type_id` FROM `{?_MYSQL_PREFIX?}_network_types` WHERE `network_id`=%s AND `network_type_handle`='%s' LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `network_type_id` FROM `{?_MYSQL_PREFIX?}_network_types` WHERE `network_id`=%s AND `network_type_handler`='%s' LIMIT 1",
array(
$networkId,
$type
$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_charset`,
d.`network_require_id_card`,
d.`network_query_amount`,
- t.`network_type_handle`,
+ t.`network_type_handler`,
t.`network_type_api_url`,
t.`network_type_click_url`,
t.`network_type_banner_url`
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?
$result = SQL_QUERY_ESC('SELECT
`network_type_id`,
`network_id`,
- `network_type_handle`,
+ `network_type_handler`,
`network_type_api_url`,
`network_type_click_url`,
`network_type_banner_url`
$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)) {
// Query all types of this network
$result = SQL_QUERY_ESC('SELECT
`network_type_id`,
- `network_type_handle`
+ `network_type_handler`
FROM
`{?_MYSQL_PREFIX?}_network_types`
WHERE
`network_id`=%s
ORDER BY
- `network_type_handle` ASC',
+ `network_type_handler` ASC',
array(
bigintval($networkId)
), __FUNCTION__, __LINE__);
$content = '';
// Query all types of this network
- $result = SQL_QUERY('SELECT
- t.`network_type_id`, t.`network_type_handle`, 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_handle` ASC', __FUNCTION__, __LINE__);
+ t.`network_type_handler` ASC", __FUNCTION__, __LINE__);
// Do we have entries?
if (!SQL_HASZERONUMS($result)) {
$GLOBALS[__FUNCTION__][$networkId] = generateOptionList(
'network_types',
'network_type_id',
- 'network_type_handle',
+ 'network_type_handler',
$networkId,
'',
sprintf(
}
// 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
array(),
'',
'', '',
- $GLOBALS['network_params_disabled'],
- 'translateNetworkRequestElement'
+ $GLOBALS['network_request_params_disabled'],
+ 'translateNetworkRequestParamKey'
);
} // END - if
// 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_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 translateNetworkRequestElement ($param) {
- // Get the message id
- return '{--ADMIN_NETWORK_REQUEST_PARAMETER_' . strtoupper($param) . '--}';
+function translateNetworkRequestParamKey ($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
}
// Displays selected networks for editing
-function doAdminNetworkProcessHandleNetwork () {
+function doAdminNetworkProcessHandleNetworks () {
// Do we have selections?
if (ifPostContainsSelections()) {
// Something has been selected, so start displaying one by one
}
// Handle network type form
-function doAdminNetworkProcessHandleNetworkType () {
+function doAdminNetworkProcessHandleNetworkTypes () {
// Do we have selections?
if (ifPostContainsSelections()) {
// Load network data
$GLOBALS['network_display'] = false;
} else {
// Nothing selected/found
- loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_FOUND--}');
+ loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPE_HANDLER_NOTHING_FOUND--}');
}
} // END - if
}
// Do we have selections?
if (ifPostContainsSelections()) {
// Init cache array
- $GLOBALS['network_params_disabled'] = array();
+ $GLOBALS['network_request_params_disabled'] = array();
// Load network data
$networkData = getNetworkDataById(getRequestElement('network_id'));
if (count($networkRequestData) > 0) {
if (isFormSent('edit')) {
// Add row template for deleting
- $OUT .= loadTemplate('admin_edit_network_params_row', true, $networkRequestData);
+ $OUT .= loadTemplate('admin_edit_network_request_params_row', true, $networkRequestData);
} elseif (isFormSent('delete')) {
// Get type data
$networkRequestData['network_type_data'] = getNetworkTypeDataById($networkRequestData['network_type_id']);
// Add row template for deleting
- $OUT .= loadTemplate('admin_delete_network_params_row', true, $networkRequestData);
+ $OUT .= loadTemplate('admin_delete_network_request_params_row', true, $networkRequestData);
} else {
// Problem!
debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
if (!empty($OUT)) {
// Output main template
if (isFormSent('edit')) {
- loadTemplate('admin_edit_network_params', false, $OUT);
+ loadTemplate('admin_edit_network_request_params', false, $OUT);
} elseif (isFormSent('delete')) {
- loadTemplate('admin_delete_network_params', false, $OUT);
+ loadTemplate('admin_delete_network_request_params', false, $OUT);
} else {
// Problem!
debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
}
// Changes given networks
-function doAdminNetworkProcessChangeNetwork () {
+function doAdminNetworkProcessChangeNetworks () {
// Do we have selections?
if (ifPostContainsSelections()) {
// By default nothing is updated
}
// Removes given networks
-function doAdminNetworkProcessRemoveNetwork () {
+function doAdminNetworkProcessRemoveNetworks () {
// Do we have selections?
if (ifPostContainsSelections()) {
// By default nothing is removed
// 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_id'))) {
+ if (isNetworkTypeHandleValid(postRequestElement('network_type_handler'), getRequestElement('network_id'))) {
// Already added
- loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_TYPES_HANDLE_ALREADY_ADDED=' . postRequestElement('network_type_handle') . '%}');
+ 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_TYPES_NOT_ADDED=' . postRequestElement('network_type_handle') . '%}');
+ loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_TYPE_HANDLER_NOT_ADDED=' . postRequestElement('network_type_handler') . '%}');
}
}
// Changes given network type handlers
-function doAdminNetworkProcessChangeNetworkType () {
+function doAdminNetworkProcessChangeHandlerTypes () {
// Do we have selections?
if (ifPostContainsSelections()) {
// By default nothing is updated
// Do we have updates?
if ($updated > 0) {
// Updates done
- displayMessage('{%message,ADMIN_NETWORK_TYPES_UPDATED=' . $updated . '%}');
+ displayMessage('{%message,ADMIN_NETWORK_TYPE_HANDLER_UPDATED=' . $updated . '%}');
} else {
// Nothing changed
- loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_CHANGED--}');
+ loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPE_HANDLER_NOTHING_CHANGED--}');
}
} // END - if
}
// Changes given network request parameters
-function doAdminNetworkProcessChangeNetworkParam () {
+function doAdminNetworkProcessChangeRequestParams () {
// Do we have selections?
if (ifPostContainsSelections()) {
// By default nothing is updated
}
// Removes given network type handlers
-function doAdminNetworkProcessRemoveNetworkType () {
+function doAdminNetworkProcessRemoveNetworkTypes () {
// Do we have selections?
if (ifPostContainsSelections()) {
// By default nothing is removed
// Do we have removes?
if ($removed > 0) {
// Removals done
- displayMessage('{%message,ADMIN_NETWORK_TYPES_REMOVED=' . $removed . '%}');
+ displayMessage('{%message,ADMIN_NETWORK_TYPE_HANDLER_REMOVED=' . $removed . '%}');
} else {
// Nothing removed
- loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_REMOVED--}');
+ loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPE_HANDLER_NOTHING_REMOVED--}');
}
} // END - if
}
// Removes given network request parameters
-function doAdminNetworkProcessRemoveNetworkParam () {
+function doAdminNetworkProcessRemoveNetworkRequestParams () {
// Do we have selections?
if (ifPostContainsSelections()) {
// By default nothing is removed
}
// Adds a request parameter to given network and type
-function doAdminNetworkProcessAddNetworkParam () {
+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 doAdminNetworkProcessAddNetworkTypesConfig () {
+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"
// 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--}');
+ displayMessage('{--ADMIN_NETWORK_HANDLER_TYPE_HANDLER_ALREADY_CONFIGURED--}');
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_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_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 doAdminNetworkProcessEditNetworkTypesConfig () {
+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.
// 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--}');
+ displayMessage('{--ADMIN_NETWORK_HANDLER_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'));
+ // 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_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_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();
+ }
}
}
// Network type handler
'list_network_types' => 'network_types',
// Network request parameter
- 'list_network_params' => 'network_request_params',
+ 'list_network_request_params' => 'network_request_params',
// Network API response array index translation
'list_network_array_translation' => 'network_array_translation',
);
__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);
$result = SQL_QUERY_ESC('SELECT
`network_type_id`,
`network_id`,
- `network_type_handle`,
+ `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
), __FUNCTION__, __LINE__);
// Start an empty SQL query
- $SQL = "<pre>INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`,`network_id`,`network_type_handle`,`network_type_api_url`,`network_type_click_url`,`network_type_banner_url`) VALUES\n";
+ $SQL = "<pre>INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`,`network_id`,`network_type_handler`,`network_type_api_url`,`network_type_click_url`,`network_type_banner_url`) VALUES\n";
// Load all entries
while ($content = SQL_FETCHARRAY($result)) {
$SQL .= '(' .
$content['network_type_id'] . ', ' .
$content['network_id'] . ", '" .
- $content['network_type_handle'] . "', '" .
+ $content['network_type_handler'] . "', '" .
$content['network_type_api_url'] . "', '" .
$content['network_type_click_url'] . "', ";
// 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
- $SQL = substr($SQL, 0, -1) . '</pre>';
+ $SQL = substr($SQL, 0, -2) . '</pre>';
// Free result
SQL_FREERESULT($result);
$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
projects / mailer.git / blobdiff