* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2012 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 *
} elseif (!isGetRequestElementSet('do')) {
// Skip any further requests
return;
+ } elseif ((getHttpRequestMethod() != 'POST') && (getRequestElement('do') != 'export')) {
+ // Do not process non-POST requests that are not 'do=export'
+ return;
}
// Process the request
// Checks whether 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_handler`='%s' LIMIT 1",
- array(
- $networkId,
- $type
- ), __FUNCTION__, __LINE__);
-
- // Does it exist?
- $isValid = (SQL_NUMROWS($result) == 1);
-
- // Free result
- SQL_FREERESULT($result);
+ // Is there cache?
+ if (!isset($GLOBALS[__FUNCTION__][$networkId][$type])) {
+ // Does it exist?
+ $GLOBALS[__FUNCTION__][$networkId][$type] = (countSumTotalData(bigintval($networkId), 'network_types', 'network_type_id', 'network_id', TRUE, sprintf(" AND `network_type_handler`='%s'", sqlEscapeString($type))) == 1);
+ } // END - if
// Return result
- return $isValid;
+ return $GLOBALS[__FUNCTION__][$networkId][$type];
}
// Checks whether the given network request parameter is already used (valid)
-function isNetworkRequestElementValid ($key, $type, $networkId) {
- // Query for it
- $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?
- $isValid = (SQL_NUMROWS($result) == 1);
-
- // Free result
- SQL_FREERESULT($result);
-
- // Return result
- return $isValid;
-}
-
-// Checks whether the given vcheck request parameter is already used (valid)
-function isNetworkVcheckElementValid ($key, $networkId) {
- // Query for it
- $result = SQL_QUERY_ESC("SELECT `network_vcheck_param_id` FROM `{?_MYSQL_PREFIX?}_network_vcheck_params` WHERE `network_id`=%s AND `network_vcheck_param_key`='%s' LIMIT 1",
- array(
- $networkId,
- $key
- ), __FUNCTION__, __LINE__);
-
- // Does it exist?
- $isValid = (SQL_NUMROWS($result) == 1);
-
- // Free result
- SQL_FREERESULT($result);
+function isNetworkRequestElementValid ($key, $networkTypeId, $networkId) {
+ // Is there cache?
+ if (!isset($GLOBALS[__FUNCTION__][$networkId][$networkTypeId][$key])) {
+ // Does it exist?
+ $GLOBALS[__FUNCTION__][$networkId][$networkTypeId][$key] = (countSumTotalData(bigintval($networkId), 'network_request_params', 'network_request_param_id', 'network_id', TRUE, sprintf(" AND `network_type_id`=%s AND `network_request_param_key`='%s'", bigintval($networkTypeId), sqlEscapeString($key))) == 1);
+ } // END - if
// Return result
- return $isValid;
+ return $GLOBALS[__FUNCTION__][$networkId][$networkTypeId][$key];
}
// Checks whether the given network API array translation
-function isNetworkArrayTranslationValid ($key, $type, $networkId) {
- // Query for it
- $result = SQL_QUERY_ESC("SELECT `network_array_id` FROM `{?_MYSQL_PREFIX?}_network_array_translation` WHERE `network_id`=%s AND `network_type_id`=%s AND `network_array_index`='%s' LIMIT 1",
- array(
- $networkId,
- $type,
- $key
- ), __FUNCTION__, __LINE__);
-
- // Does it exist?
- $isValid = (SQL_NUMROWS($result) == 1);
-
- // Free result
- SQL_FREERESULT($result);
+function isNetworkArrayTranslationValid ($key, $networkTypeId, $networkId) {
+ // Is there cache?
+ if (!isset($GLOBALS[__FUNCTION__][$networkId][$networkTypeId][$key])) {
+ // Does it exist?
+ $GLOBALS[__FUNCTION__][$networkId][$networkTypeId][$key] = (countSumTotalData(bigintval($networkId), 'network_array_translation', 'network_array_id', 'network_id', TRUE, sprintf(" AND `network_type_id`=%s AND `network_array_index`='%s'", bigintval($networkTypeId), sqlEscapeString($key))) == 1);
+ } // END - if
// Return result
- return $isValid;
+ return $GLOBALS[__FUNCTION__][$networkId][$networkTypeId][$key];
}
// "Getter" for a network's data by provided id number
-function getNetworkDataById ($networkId, $column = '') {
+function getNetworkDataFromId ($networkId, $column = '') {
// Ids lower one are not accepted
if (!isValidId($networkId)) {
// Not good, should be fixed
$GLOBALS['network_data'][$networkId] = array();
// Query for the network data
- $result = SQL_QUERY_ESC('SELECT
+ $result = sqlQueryEscaped('SELECT
`network_id`,
`network_short_name`,
`network_title`,
array(bigintval($networkId)), __FUNCTION__, __LINE__);
// Is there an entry?
- if (SQL_NUMROWS($result) == 1) {
+ if (sqlNumRows($result) == 1) {
// Then get it
- $GLOBALS['network_data'][$networkId] = SQL_FETCHARRAY($result);
+ $GLOBALS['network_data'][$networkId] = sqlFetchArray($result);
} // END - if
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} // END - if
// Return result
$GLOBALS['network_type_data'][$networkTypeId] = array();
// Query for the network data
- $result = SQL_QUERY_ESC('SELECT
+ $result = sqlQueryEscaped('SELECT
`d`.`network_id`,
`d`.`network_short_name`,
`d`.`network_title`,
array(bigintval($networkTypeId)), __FUNCTION__, __LINE__);
// Is there an entry?
- if (SQL_NUMROWS($result) == 1) {
+ if (sqlNumRows($result) == 1) {
// Then get it
- $GLOBALS['network_type_data'][$networkTypeId] = SQL_FETCHARRAY($result);
+ $GLOBALS['network_type_data'][$networkTypeId] = sqlFetchArray($result);
} // END - if
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} // END - if
// Return result
$GLOBALS['network_type_data'][$networkTypeId] = array();
// Query for the network data
- $result = SQL_QUERY_ESC('SELECT
+ $result = sqlQueryEscaped('SELECT
`network_type_id`,
`network_id`,
`network_type_handler`,
array(bigintval($networkTypeId)), __FUNCTION__, __LINE__);
// Is there an entry?
- if (SQL_NUMROWS($result) == 1) {
+ if (sqlNumRows($result) == 1) {
// Then get it
- $GLOBALS['network_type_data'][$networkTypeId] = SQL_FETCHARRAY($result);
+ $GLOBALS['network_type_data'][$networkTypeId] = sqlFetchArray($result);
} // END - if
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} // END - if
// Return result
}
// "Getter" for all network type data by provided id number
-function getNetworkTypeDataById ($networkId) {
+function getNetworkTypeDataFromId ($networkId) {
// Ids lower one are not accepted
if (!isValidId($networkId)) {
// Not good, should be fixed
$GLOBALS['network_types'][$networkId] = array();
// Query for the network data
- $result = SQL_QUERY_ESC('SELECT
+ $result = sqlQueryEscaped('SELECT
`network_type_id`,
`network_id`,
`network_type_handler`,
array(bigintval($networkId)), __FUNCTION__, __LINE__);
// Is there an entry?
- if (!SQL_HASZERONUMS($result)) {
+ if (!ifSqlHasZeroNums($result)) {
// Then add all
- while ($row = SQL_FETCHARRAY($result)) {
+ while ($row = sqlFetchArray($result)) {
// Add it with new index as it is no longer required
$GLOBALS['network_types'][$networkId][] = $row;
} // END - if
} // END - if
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} // END - if
// Return result
}
// "Getter" for a network request parameter data by provided id number
-function getNetworkRequestParamsDataById ($networkRequestId) {
+function getNetworkRequestParamsDataFromId ($networkRequestId) {
// Ids lower one are not accepted
if (!isValidId($networkRequestId)) {
// Not good, should be fixed
$networkRequestData = array();
// Query for the network data
- $result = SQL_QUERY_ESC('SELECT
+ $result = sqlQueryEscaped('SELECT
`network_request_param_id`,
`network_id`,
`network_type_id`,
array(bigintval($networkRequestId)), __FUNCTION__, __LINE__);
// Is there an entry?
- if (SQL_NUMROWS($result) == 1) {
+ if (sqlNumRows($result) == 1) {
// Then get it
- $networkRequestData = SQL_FETCHARRAY($result);
+ $networkRequestData = sqlFetchArray($result);
} // END - if
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Return result
return $networkRequestData;
}
// "Getter" for a network array translation data by provided id number
-function getNetworkArrayTranslationsDataById ($networkTranslationId) {
+function getNetworkArrayTranslationsDataFromId ($networkTranslationId) {
// Ids lower one are not accepted
if (!isValidId($networkTranslationId)) {
// Not good, should be fixed
$networkTranslationData = array();
// Query for the network data
- $result = SQL_QUERY_ESC('SELECT
+ $result = sqlQueryEscaped('SELECT
`network_array_id`,
`network_id`,
`network_type_id`,
array(bigintval($networkTranslationId)), __FUNCTION__, __LINE__);
// Is there an entry?
- if (SQL_NUMROWS($result) == 1) {
+ if (sqlNumRows($result) == 1) {
// Then get it
- $networkTranslationData = SQL_FETCHARRAY($result);
+ $networkTranslationData = sqlFetchArray($result);
} // END - if
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Return result
return $networkTranslationData;
$GLOBALS['network_request_parameters'][$networkTypeId] = array();
// Search for all
- $result = SQL_QUERY_ESC('SELECT
+ $result = sqlQueryEscaped('SELECT
`network_id`,
`network_type_id`,
`network_request_param_key`,
), __FUNCTION__, __LINE__);
// Are there records?
- if (!SQL_HASZERONUMS($result)) {
+ if (!ifSqlHasZeroNums($result)) {
// Load all but make new indexes as the old are not required
- while ($row = SQL_FETCHARRAY($result)) {
+ while ($row = sqlFetchArray($result)) {
// Add it
$GLOBALS['network_request_parameters'][$networkTypeId][] = $row;
} // END - while
} // END - if
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} // END - if
// Return "cached" values
$GLOBALS['network_full_config'][$networkTypeId] = array();
// Search for all
- $result = SQL_QUERY_ESC('SELECT
+ $result = sqlQueryEscaped('SELECT
`nac`.`network_id`,
`ntc`.`network_type_id`,
`nac`.`network_api_affiliate_id`,
`nac`.`network_api_referral_link`,
`nac`.`network_api_referral_button`,
`nac`.`network_api_remaining_requests`,
+ `nac`.`network_api_visual_pay_check`,
`nts`.`network_type_reload_time_unit`,
`ntc`.`network_max_reload_time`,
`ntc`.`network_min_waiting_time`,
), __FUNCTION__, __LINE__);
// Is there one entry?
- if (SQL_NUMROWS($result) == 1) {
+ if (sqlNumRows($result) == 1) {
// Load it
- $GLOBALS['network_full_config'][$networkTypeId] = SQL_FETCHARRAY($result);
+ $GLOBALS['network_full_config'][$networkTypeId] = sqlFetchArray($result);
} // END - if
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} // END - if
// Return "cached" values
// Removes given network entry
function doAdminRemoveNetworkEntry ($table, $column, $id, $limit = 1) {
// Remove the entry
- SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_network_%s` WHERE `%s`=%s LIMIT %s",
+ sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_network_%s` WHERE `%s`=%s LIMIT %s",
array(
$table,
$column,
), __FUNCTION__, __LINE__);
// Return affected rows
- return SQL_AFFECTEDROWS();
+ return sqlAffectedRows();
}
// Generates a list of networks for given script and returns it
-function generateAdminNetworkList ($separated = FALSE, $includeConfigured = TRUE, $includeUnconfigured = TRUE, $extraName = '') {
+function generateAdminNetworkList ($separated = FALSE, $includeConfigured = TRUE, $includeUnconfigured = TRUE, $extraName = '', $addSql = '') {
// Init output
$content = '';
// Query for all networks
- $result = SQL_QUERY('SELECT
+ $result = sqlQuery('SELECT
`network_id`,
`network_short_name`,
`network_title`,
`network_active`
FROM
`{?_MYSQL_PREFIX?}_network_data`
-' . getNetworkActivatedColumn() . '
+' . getNetworkActivatedColumn('WHERE') . '
ORDER BY
`network_short_name` ASC', __FUNCTION__, __LINE__);
// Are there entries?
- if (!SQL_HASZERONUMS($result)) {
+ if (!ifSqlHasZeroNums($result)) {
// List all entries
$rows = array();
- while ($row = SQL_FETCHARRAY($result)) {
+ while ($row = sqlFetchArray($result)) {
// Is this valid, then add it
if ((is_array($row)) && (isset($row['network_id']))) {
// Exclude configured and is it configured or same for unconfired but only if not separated lists?
if (((($includeConfigured === FALSE) && (isNetworkApiConfigured($row['network_id']))) || (($includeUnconfigured === FALSE) && (!isNetworkApiConfigured($row['network_id'])))) && ($separated === FALSE)) {
// Skip this entry
continue;
+ // @TODO Unfinished: } elseif ((!empty($addSql)) && (
} // END - if
// Add entry
$content = generateSelectionBoxFromArray($rows, 'network_id', 'network_id', '', $extraName, 'network');
} else {
// Generate two small, first configured
- $content = generateAdminNetworkList(FALSE, TRUE, FALSE, '_configured');
+ $content = generateAdminNetworkList(FALSE, TRUE, FALSE, '_configured', $addSql);
// Then add unconfigured
- $content .= generateAdminNetworkList(FALSE, FALSE, TRUE, '_unconfigured');
+ $content .= generateAdminNetworkList(FALSE, FALSE, TRUE, '_unconfigured', $addSql);
}
} else {
// Nothing selected
- $content = loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_ENTRIES_404--}');
+ $content = displayErrorMessage('{--ADMIN_ENTRIES_404--}');
}
// Free the result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Return the list
return $content;
$content = '';
// Query all types of this network
- $result = SQL_QUERY_ESC('SELECT
+ $result = sqlQueryEscaped('SELECT
`network_type_id`,
`network_type_handler`
FROM
), __FUNCTION__, __LINE__);
// Are there entries?
- if (!SQL_HASZERONUMS($result)) {
+ if (!ifSqlHasZeroNums($result)) {
// List all entries
$rows = array();
- while ($row = SQL_FETCHARRAY($result)) {
+ while ($row = sqlFetchArray($result)) {
// Is this valid, then add it
if ((is_array($row)) && (isset($row['network_type_id']))) {
// Add entry
$content = generateSelectionBoxFromArray($rows, 'network_type', 'network_type_id');
} else {
// Nothing selected
- $content = loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_ENTRIES_404--}');
+ $content = displayErrorMessage('{--ADMIN_ENTRIES_404--}');
}
// Free the result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Return content
return $content;
$content = '';
// Query all types of this network
- $result = SQL_QUERY('SELECT
- t.`network_type_id`,
- t.`network_type_handler`,
- d.`network_title`
+ $result = sqlQuery('SELECT
+ `t`.`network_type_id`,
+ `t`.`network_type_handler`,
+ `d`.`network_title`
FROM
- `{?_MYSQL_PREFIX?}_network_types` AS t
+ `{?_MYSQL_PREFIX?}_network_types` AS `t`
LEFT JOIN
- `{?_MYSQL_PREFIX?}_network_data` AS d
+ `{?_MYSQL_PREFIX?}_network_data` AS `d`
ON
- t.`network_id`=d.`network_id`
+ `t`.`network_id`=`d`.`network_id`
' . getNetworkActivatedColumn('WHERE', 'd') . '
ORDER BY
- d.`network_short_name` ASC,
- t.`network_type_handler` ASC', __FUNCTION__, __LINE__);
+ `d`.`network_short_name` ASC,
+ `t`.`network_type_handler` ASC', __FUNCTION__, __LINE__);
// Are there entries?
- if (!SQL_HASZERONUMS($result)) {
+ if (!ifSqlHasZeroNums($result)) {
// List all entries
$rows = array();
- while ($row = SQL_FETCHARRAY($result)) {
+ while ($row = sqlFetchArray($result)) {
// Is this valid, then add it
if ((is_array($row)) && (isset($row['network_type_id']))) {
// Add entry
$content = generateSelectionBoxFromArray($rows, 'network_type', 'network_type_id', '', '_title');
} else {
// Nothing selected
- $content = loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_ENTRIES_404--}');
+ $content = displayErrorMessage('{--ADMIN_ENTRIES_404--}');
}
// Free the result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
//* DEBUG: */ die('<pre>'.encodeEntities($content).'</pre>');
// Return content
'skyscraper',
'skyscraper_click',
'skyscraper_view',
- 'halfbanner',
- 'halfbanner_click',
- 'halfbanner_view',
+ 'half_banner',
+ 'half_banner_click',
+ 'half_banner_view',
'layer',
'layer_click',
'layer_view',
return $GLOBALS[__FUNCTION__];
}
-// Generates an options list for vcheck request keys
-function generateNetworkVcheckKeyOptions () {
- // Is it cached?
- if (!isset($GLOBALS[__FUNCTION__])) {
- // Generate and cache it
- $GLOBALS[__FUNCTION__] = generateOptions(
- '/ARRAY/',
- array(
- 'network_key',
- 'site_id',
- 'payment',
- 'remote_address',
- 'campaign_id',
- 'status',
- 'reason',
- 'type',
- 'network_name',
- 'extra_value1',
- 'extra_value2',
- 'extra_value3',
- 'extra_value4',
- ),
- array(),
- '',
- '', '',
- $GLOBALS['network_vcheck_params_disabled'],
- 'translateNetworkVcheckParameterKey'
- );
- } // END - if
-
- // Return content
- return $GLOBALS[__FUNCTION__];
-}
-
// Generator (somewhat getter) for (return) array translation
function generateNetworkTranslationOptions ($default = '') {
// Is it cached?
}
// Checks if the given network is configured by looking its API configuration entry up
-function isNetworkApiConfigured ($networkId) {
+function isNetworkApiConfigured ($networkId, $addSql = '') {
// Is there cache?
if (!isset($GLOBALS[__FUNCTION__][$networkId])) {
// Check for an entry in network_api_config
reportBug(__FUNCTION__, __LINE__, 'Not yet implemented.');
}
+// Handles the network-delete-url request
+function handleNetworkDeleteUrlRequest () {
+ // @TODO Implement this function, don't forget to set HTTP status back to '200 OK' if everything went fine
+ reportBug(__FUNCTION__, __LINE__, 'Not yet implemented.');
+}
+
// Handle a single request parameter key by given network type handler id and "internal" key
function handleRequestParameterKey ($networkTypeId, $networkRequestKey) {
// Construct call-back function name
assert(in_array($type, array('MANUAL', 'CRON')));
// Is debug logging enabled or status code not 200 OK?
- if ((getConfig('network_logging_debug') == 'Y') || (!isHttpStatusOkay($response[0]))) {
+ if ((getConfig('network_logging_debug') == 'Y') || (!isHttpStatusOkay($headers[0]))) {
// Add entry
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_network_header_logging` (`network_id`, `network_type_id`, `network_http_status_code`, `network_http_headers`, `network_logging_type`) VALUES(%s, %s, '%s', '%s', '%s')",
+ sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_network_header_logging` (`network_id`, `network_type_id`, `network_http_status_code`, `network_http_headers`, `network_logging_type`) VALUES(%s, %s, '%s', '%s', '%s')",
array(
bigintval($networkId),
bigintval($networkTypeId),
// So is there cache?
if (countSumTotalData($networkId, 'network_cache', 'network_cache_id', 'network_id', TRUE, ' AND `network_type_id`=' . bigintval($networkTypeId)) == 1) {
// Entry found, so update it
- SQL_QUERY_ESC("UPDATE
+ sqlQueryEscaped("UPDATE
`{?_MYSQL_PREFIX?}_network_cache`
SET
`network_cache_data`='%s',
), __FUNCTION__, __LINE__);
} else {
// Add entry
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_network_cache` (`network_id`, `network_type_id`, `network_cache_data`, `network_cache_body`, `network_cache_type`, `network_cache_admin_id`) VALUES(%s, %s, '%s', '%s', '%s', %s)",
+ sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_network_cache` (`network_id`, `network_type_id`, `network_cache_data`, `network_cache_body`, `network_cache_type`, `network_cache_admin_id`) VALUES(%s, %s, '%s', '%s', '%s', %s)",
array(
bigintval($networkId),
bigintval($networkTypeId),
} // END - if
// Okay, so update database
- $result = SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_network_api_config` SET `network_api_remaining_requests`=`network_api_remaining_requests`-1 WHERE `network_id`=%s LIMIT 1",
+ $result = sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_network_api_config` SET `network_api_remaining_requests`=`network_api_remaining_requests`-1 WHERE `network_id`=%s LIMIT 1",
array(
bigintval($networkData['network_id'])
), __FUNCTION__, __LINE__);
// Return affected rows
- return SQL_AFFECTEDROWS();
+ return sqlAffectedRows();
}
/**
*/
function generateMetworkReferralLinkById ($networkId) {
// Simple output (no need for template!)
- $output = '<a href="{%network,getNetworkDataById,network_reflink=' . $networkId . '%}" target="_blank" title="{%network,getNetworkDataById,network_title=' . $networkId . '%}">{%network,getNetworkDataById,network_title=' . $networkId . '%}</a>';
+ $output = '<a href="{%network,getNetworkDataFromId,network_reflink=' . $networkId . '%}" target="_blank" title="{%network,getNetworkDataFromId,network_title=' . $networkId . '%}">{%network,getNetworkDataFromId,network_title=' . $networkId . '%}</a>';
// Return it
return $output;
return '{--' . $messageId . '--}';
}
-// Translates vheck request parameter
-function translateNetworkVcheckParameterKey ($param) {
- // Generate id
- $messageId = 'ADMIN_NETWORK_VCHECK_PARAMETER_' . strtoupper($param) . '';
-
- // Is the message id there?
- if (!isMessageIdValid($messageId)) {
- // Not valid param
- reportBug(__FUNCTION__, __LINE__, 'param=' . $param . ' is invalid.');
- } // END - if
-
- // Return message id
- return '{--' . $messageId . '--}';
-}
-
// Translate text-encoding
function translateNetworkTextEncoding ($encoding) {
// Generate id
$GLOBALS['network_array_index'] = array();
// Get all entries
- $result = SQL_QUERY('SELECT
+ $result = sqlQuery('SELECT
`network_array_id`,
`network_array_index`,
`network_translation_name`
`network_array_sort` ASC', __FUNCTION__, __LINE__);
// Are there entries?
- if (!SQL_HASZERONUMS($result)) {
+ if (!ifSqlHasZeroNums($result)) {
// Get all entries
- while ($row = SQL_FETCHARRAY($result)) {
+ while ($row = sqlFetchArray($result)) {
// Add it to our global array
$GLOBALS['network_array_index'][$row['network_array_index']] = $row;
} // END - while
} // END - if
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} // END - if
// Default name is unknown
// We can say here, the form is sent, so check if the network is already added
if (isNetworkNameValid(postRequestElement('network_short_name'))) {
// Already there
- loadTemplate('admin_settings_unsaved', FALSE, '{%message,ADMIN_NETWORK_ALREADY_ADDED=' . postRequestElement('network_short_name') . '%}');
+ displayErrorMessage('{%message,ADMIN_NETWORK_ALREADY_ADDED=' . postRequestElement('network_short_name') . '%}');
return FALSE;
} // END - if
// Add the whole request to database
- SQL_QUERY(getInsertSqlFromArray(postRequestArray(), 'network_data'), __FUNCTION__, __LINE__);
+ sqlQuery(getInsertSqlFromArray(postRequestArray(), 'network_data'), __FUNCTION__, __LINE__);
// Add the id for output only
- setPostRequestElement('network_id', SQL_INSERTID());
+ setPostRequestElement('network_id', getSqlInsertId());
// Output message
- if (!SQL_HASZEROAFFECTED()) {
+ if (!ifSqlHasZeroAffectedRows()) {
// Successfully added
loadTemplate('admin_network_added', FALSE, postRequestArray());
} else {
// Not added
- loadTemplate('admin_settings_unsaved', FALSE, '{%message,ADMIN_NETWORK_DATA_NOT_ADDED=' . postRequestElement('network_short_name') . '%}');
+ displayErrorMessage('{%message,ADMIN_NETWORK_DATA_NOT_ADDED=' . postRequestElement('network_short_name') . '%}');
}
}
// Is this selected?
if ($sel == 1) {
// Load this network's data
- $networkData = getNetworkDataById($networkId);
+ $networkData = getNetworkDataFromId($networkId);
// Is there found the network?
if (count($networkData) > 0) {
} // END - if
} // END - foreach
- // If we have no rows, we don't need to display the edit form
+ // If there are no rows, we don't need to display the edit form
if (!empty($OUT)) {
// Init array with generic element
$content = array(
$GLOBALS['network_display'] = FALSE;
} else {
// Nothing selected/found
- loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_NETWORK_NOTHING_FOUND--}');
+ displayErrorMessage('{--ADMIN_NETWORK_NOTHING_FOUND--}');
}
} // END - if
}
// Is there selections?
if (ifPostContainsSelections()) {
// Load network data
- $networkData = getNetworkDataById(getRequestElement('network_id'));
+ $networkData = getNetworkDataFromId(getRequestElement('network_id'));
// Something has been selected, so start displaying one by one
$OUT = '';
} // END - if
} // END - foreach
- // If we have no rows, we don't need to display the edit form
+ // If there are no rows, we don't need to display the edit form
if (!empty($OUT)) {
// Prepare array with generic elements
$content = array(
$GLOBALS['network_display'] = FALSE;
} else {
// Nothing selected/found
- loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_NETWORK_TYPE_HANDLER_NOTHING_FOUND--}');
+ displayErrorMessage('{--ADMIN_NETWORK_TYPE_HANDLER_NOTHING_FOUND--}');
}
} // END - if
}
$GLOBALS['network_request_params_disabled'] = array();
// Load network data
- $networkData = getNetworkDataById(getRequestElement('network_id'));
+ $networkData = getNetworkDataFromId(getRequestElement('network_id'));
// Something has been selected, so start displaying one by one
$OUT = '';
// Is this selected?
if ($sel == 1) {
// Load this network's data
- $networkRequestData = getNetworkRequestParamsDataById($networkId);
+ $networkRequestData = getNetworkRequestParamsDataFromId($networkId);
// Is there found the network?
if (count($networkRequestData) > 0) {
} // END - if
} // END - foreach
- // If we have no rows, we don't need to display the edit form
+ // If there are no rows, we don't need to display the edit form
if (!empty($OUT)) {
// Prepare array with generic elements
$content = array(
$GLOBALS['network_display'] = FALSE;
} else {
// Nothing selected/found
- loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_FOUND--}');
+ displayErrorMessage('{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_FOUND--}');
}
} // END - if
}
displayMessage('{%message,ADMIN_NETWORK_UPDATED=' . $updated . '%}');
} else {
// Nothing changed
- loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_NETWORK_NOTHING_CHANGED--}');
+ displayErrorMessage('{--ADMIN_NETWORK_NOTHING_CHANGED--}');
}
} // END - if
}
displayMessage('{%message,ADMIN_NETWORK_REMOVED=' . $removed . '%}');
} else {
// Nothing removed
- loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_NETWORK_NOTHING_REMOVED--}');
+ displayErrorMessage('{--ADMIN_NETWORK_NOTHING_REMOVED--}');
}
} // 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_TYPE_HANDLER_ALREADY_ADDED=' . postRequestElement('network_type_handler') . '%}');
+ displayErrorMessage('{%message,ADMIN_NETWORK_TYPE_HANDLER_ALREADY_ADDED=' . postRequestElement('network_type_handler') . '%}');
// ... so abort here
return FALSE;
} // END - if
// Add the whole request to database
- SQL_QUERY(getInsertSqlFromArray(postRequestArray(), 'network_types'), __FUNCTION__, __LINE__);
+ sqlQuery(getInsertSqlFromArray(postRequestArray(), 'network_types'), __FUNCTION__, __LINE__);
// Output message
- if (!SQL_HASZEROAFFECTED()) {
+ if (!ifSqlHasZeroAffectedRows()) {
// Successfully added
loadTemplate('admin_network_type_added', FALSE, postRequestArray());
} else {
// Not added
- loadTemplate('admin_settings_unsaved', FALSE, '{%message,ADMIN_NETWORK_TYPE_HANDLER_NOT_ADDED=' . postRequestElement('network_type_handler') . '%}');
+ displayErrorMessage('{%message,ADMIN_NETWORK_TYPE_HANDLER_NOT_ADDED=' . postRequestElement('network_type_handler') . '%}');
}
}
displayMessage('{%message,ADMIN_NETWORK_TYPE_HANDLER_UPDATED=' . $updated . '%}');
} else {
// Nothing changed
- loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_NETWORK_TYPE_HANDLER_NOTHING_CHANGED--}');
+ displayErrorMessage('{--ADMIN_NETWORK_TYPE_HANDLER_NOTHING_CHANGED--}');
}
} // END - if
}
displayMessage('{%message,ADMIN_NETWORK_REQUEST_PARAMETER_UPDATED=' . $updated . '%}');
} else {
// Nothing changed
- loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_CHANGED--}');
+ displayErrorMessage('{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_CHANGED--}');
}
} // END - if
}
// Changes given network array translations
-function doAdminNetworkProcessChangeArrayTranslations () {
+function doAdminNetworkProcessChangeArrayTranslation () {
// Is there selections?
if (ifPostContainsSelections()) {
// By default nothing is updated
displayMessage('{%message,ADMIN_NETWORK_ARRAY_TRANSLATION_UPDATED=' . $updated . '%}');
} else {
// Nothing changed
- loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_NETWORK_ARRAY_TRANSLATION_NOTHING_CHANGED--}');
+ displayErrorMessage('{--ADMIN_NETWORK_ARRAY_TRANSLATION_NOTHING_CHANGED--}');
}
} // END - if
}
displayMessage('{%message,ADMIN_NETWORK_TYPE_HANDLER_REMOVED=' . $removed . '%}');
} else {
// Nothing removed
- loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_NETWORK_TYPE_HANDLER_NOTHING_REMOVED--}');
+ displayErrorMessage('{--ADMIN_NETWORK_TYPE_HANDLER_NOTHING_REMOVED--}');
}
} // END - if
}
displayMessage('{%message,ADMIN_NETWORK_REQUEST_PARAMETER_REMOVED=' . $removed . '%}');
} else {
// Nothing removed
- loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_REMOVED--}');
+ displayErrorMessage('{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_REMOVED--}');
}
} // END - if
}
displayMessage('{%message,ADMIN_NETWORK_ARRAY_TRANSLATION_REMOVED=' . $removed . '%}');
} else {
// Nothing removed
- loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_NETWORK_ARRAY_TRANSLATION_NOTHING_REMOVED--}');
+ displayErrorMessage('{--ADMIN_NETWORK_ARRAY_TRANSLATION_NOTHING_REMOVED--}');
}
} // END - if
}
// 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
- loadTemplate('admin_settings_unsaved', FALSE, '{%message,ADMIN_NETWORK_REQUEST_PARAMETER_ALREADY_ADDED=' . postRequestElement('network_request_param_key') . '%}');
+ displayErrorMessage('{%message,ADMIN_NETWORK_REQUEST_PARAMETER_ALREADY_ADDED=' . postRequestElement('network_request_param_key') . '%}');
// ... so abort here
return FALSE;
} // END - if
// Add the whole request to database
- SQL_QUERY(getInsertSqlFromArray(postRequestArray(), 'network_request_params'), __FUNCTION__, __LINE__);
+ sqlQuery(getInsertSqlFromArray(postRequestArray(), 'network_request_params'), __FUNCTION__, __LINE__);
// Output message
- if (!SQL_HASZEROAFFECTED()) {
+ if (!ifSqlHasZeroAffectedRows()) {
// Successfully added
loadTemplate('admin_network_request_param_added', FALSE, postRequestArray());
} else {
// Not added
- loadTemplate('admin_settings_unsaved', FALSE, '{%message,ADMIN_NETWORK_REQUEST_PARAMETER_NOT_ADDED=' . postRequestElement('network_request_param_key') . '%}');
- }
-}
-
-// Adds a vheck request parameter to given network
-function doAdminNetworkProcessAddVcheckParam () {
- // Is the request parameter already used with given network?
- if (isNetworkVcheckElementValid(postRequestElement('network_vcheck_param_key'), getRequestElement('network_id'))) {
- // Already added
- loadTemplate('admin_settings_unsaved', FALSE, '{%message,ADMIN_NETWORK_VCHECK_PARAMETER_ALREADY_ADDED=' . postRequestElement('network_vcheck_param_key') . '%}');
-
- // ... so abort here
- return FALSE;
- } // END - if
-
- // Add id
- setPostRequestElement('network_id', bigintval(getRequestElement('network_id')));
-
- // Is network_vcheck_param_default set?
- if (!isPostRequestElementSet('network_vcheck_param_default')) {
- // Remove empty value to get a NULL for an optional entry
- unsetPostRequestElement('network_vcheck_param_default');
- } // END - if
-
- // Add the whole vcheck to database
- SQL_QUERY(getInsertSqlFromArray(postRequestArray(), 'network_vcheck_params'), __FUNCTION__, __LINE__);
-
- // Output message
- if (!SQL_HASZEROAFFECTED()) {
- // Successfully added
- loadTemplate('admin_network_vcheck_param_added', FALSE, postRequestArray());
- } else {
- // Not added
- loadTemplate('admin_settings_unsaved', FALSE, '{%message,ADMIN_NETWORK_VCHECK_PARAMETER_NOT_ADDED=' . postRequestElement('network_vcheck_param_key') . '%}');
+ displayErrorMessage('{%message,ADMIN_NETWORK_REQUEST_PARAMETER_NOT_ADDED=' . postRequestElement('network_request_param_key') . '%}');
}
}
// Is the request parameter already used with given network?
if (isNetworkArrayTranslationValid(postRequestElement('network_array_index'), postRequestElement('network_type_id'), getRequestElement('network_id'))) {
// Already added
- loadTemplate('admin_settings_unsaved', FALSE, '{%message,ADMIN_NETWORK_ARRAY_TRANSLATION_ALREADY_ADDED=' . postRequestElement('network_array_index') . '%}');
+ displayErrorMessage('{%message,ADMIN_NETWORK_ARRAY_TRANSLATION_ALREADY_ADDED=' . postRequestElement('network_array_index') . '%}');
// ... so abort here
return FALSE;
) + 1));
// Add the whole request to database
- SQL_QUERY(getInsertSqlFromArray(postRequestArray(), 'network_array_translation'), __FUNCTION__, __LINE__);
+ sqlQuery(getInsertSqlFromArray(postRequestArray(), 'network_array_translation'), __FUNCTION__, __LINE__);
// Output message
- if (!SQL_HASZEROAFFECTED()) {
+ if (!ifSqlHasZeroAffectedRows()) {
// Successfully added
loadTemplate('admin_network_array_translation_added', FALSE, postRequestArray());
} else {
// Not added
- loadTemplate('admin_settings_unsaved', FALSE, '{%message,ADMIN_NETWORK_ARRAY_TRANSLATION_NOT_ADDED=' . postRequestElement('network_array_index') . '%}');
+ displayErrorMessage('{%message,ADMIN_NETWORK_ARRAY_TRANSLATION_NOT_ADDED=' . postRequestElement('network_array_index') . '%}');
}
}
$GLOBALS['network_array_translation_disabled'] = array();
// Load network data
- $networkData = getNetworkDataById(getRequestElement('network_id'));
+ $networkData = getNetworkDataFromId(getRequestElement('network_id'));
// Something has been selected, so start displaying one by one
$OUT = '';
// Is this selected?
if ($sel == 1) {
// Load this network's data
- $networkTranslationsData = getNetworkArrayTranslationsDataById($networkId);
+ $networkTranslationsData = getNetworkArrayTranslationsDataFromId($networkId);
// Is there found the network?
if (count($networkTranslationsData) > 0) {
} // END - if
} // END - foreach
- // If we have no rows, we don't need to display the edit form
+ // If there are no rows, we don't need to display the edit form
if (!empty($OUT)) {
// Prepare array with generic elements
$content = array(
$GLOBALS['network_display'] = FALSE;
} else {
// Nothing selected/found
- loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_FOUND--}');
+ displayErrorMessage('{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_FOUND--}');
}
} // END - if
}
// Add id
setPostRequestElement('network_id', bigintval(getRequestElement('network_id')));
- // Is network_api_referral_button set?
- if (!isPostRequestElementSet('network_api_referral_button')) {
- // Remove empty value to get a NULL for an optional entry
- unsetPostRequestElement('network_api_referral_button');
- } // END - if
+ // NULL empty values
+ foreach (array('network_api_site_id', 'network_api_referral_button', 'network_api_visual_pay_check') as $key) {
+ // Is it set?
+ if (!isPostRequestElementSet($key)) {
+ // Remove empty value to get a NULL for an optional entry
+ unsetPostRequestElement($key);
+ } // END - if
+ } // END - foreach
// Is there already an entry?
if (isNetworkApiConfigured(getRequestElement('network_id'))) {
}
// Run the query
- SQL_QUERY($SQL, __FUNCTION__, __LINE__);
+ sqlQuery($SQL, __FUNCTION__, __LINE__);
// Output message
- if (!SQL_HASZEROAFFECTED()) {
+ if (!ifSqlHasZeroAffectedRows()) {
// Successfully added
displayMessage('{--ADMIN_CONFIG_NETWORK_API_SAVED--}');
} else {
// Not added
- loadTemplate('admin_settings_unsaved', FALSE, '{--ADMIN_CONFIG_NETWORK_API_NOT_SAVED--}');
+ displayErrorMessage('{--ADMIN_CONFIG_NETWORK_API_NOT_SAVED--}');
}
}
// 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',
+ $result = sqlQueryEscaped('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__);
// Are there entries?
- if (SQL_HASZERONUMS($result)) {
+ if (ifSqlHasZeroNums($result)) {
// No, then abort here
displayMessage('{--ADMIN_CONFIG_NETWORK_HANDLER_SET_ALL_404--}');
return;
$numRows = 0;
// Fetch all ids
- while (list($typeId) = SQL_FETCHROW($result)) {
+ while (list($typeId) = sqlFetchRow($result)) {
// Set it in GET data
setGetRequestElement('network_type_id', $typeId);
} // END - while
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Output message
if ($numRows > 0) {
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--}');
+ displayErrorMessage('{--ADMIN_CONFIG_NETWORK_HANDLER_TYPE_HANDLER_NOT_CHANGED--}');
}
} else {
// Get SQL query for new entry
$SQL = getInsertSqlFromArray(postRequestArray(), 'network_handler_config');
// Run the query
- SQL_QUERY($SQL, __FUNCTION__, __LINE__);
+ sqlQuery($SQL, __FUNCTION__, __LINE__);
// Shall we display the message?
if ($displayMessage === TRUE) {
// Output message
- if (!SQL_HASZEROAFFECTED()) {
+ if (!ifSqlHasZeroAffectedRows()) {
// 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--}');
+ displayErrorMessage('{--ADMIN_CONFIG_NETWORK_HANDLER_TYPE_HANDLER_NOT_SAVED--}');
}
} else {
// Return amount of affected rows (1 or 2)
- return SQL_AFFECTEDROWS();
+ return sqlAffectedRows();
}
}
}
// Shall we set for all?
if ($setAll === TRUE) {
// Get all data entries
- $result = SQL_QUERY_ESC('SELECT `network_data_id` FROM `{?_MYSQL_PREFIX?}_network_handler_config` WHERE `network_id`=%s ORDER BY `network_type_id` ASC',
+ $result = sqlQueryEscaped('SELECT `network_data_id` FROM `{?_MYSQL_PREFIX?}_network_handler_config` WHERE `network_id`=%s ORDER BY `network_type_id` ASC',
array(bigintval(getRequestElement('network_id'))), __FUNCTION__, __LINE__);
// Are there entries?
- if (SQL_HASZERONUMS($result)) {
+ if (ifSqlHasZeroNums($result)) {
// No, then abort here
displayMessage('{--ADMIN_CONFIG_NETWORK_HANDLER_SET_ALL_404--}');
return;
$numRows = 0;
// Fetch all ids
- while (list($dataId) = SQL_FETCHROW($result)) {
+ while (list($dataId) = sqlFetchRow($result)) {
// Set it in GET data
setPostRequestElement('network_data_id', $dataId);
} // END - while
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Output message
if ($numRows > 0) {
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--}');
+ displayErrorMessage('{--ADMIN_CONFIG_NETWORK_HANDLER_TYPE_HANDLER_NOT_CHANGED--}');
}
} else {
// Get SQL query for new entry
$SQL = getUpdateSqlFromArray(postRequestArray(), 'network_handler_config', 'network_data_id', postRequestElement('network_data_id'), array('network_data_id'));
// Run the query
- SQL_QUERY($SQL, __FUNCTION__, __LINE__);
+ sqlQuery($SQL, __FUNCTION__, __LINE__);
// Shall we display the message?
if ($displayMessage === TRUE) {
// Output message
- if (!SQL_HASZEROAFFECTED()) {
+ if (!ifSqlHasZeroAffectedRows()) {
// 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--}');
+ displayErrorMessage('{--ADMIN_CONFIG_NETWORK_HANDLER_TYPE_HANDLER_NOT_CHANGED--}');
}
} else {
// Return amount of affected rows (1 or 2)
- return SQL_AFFECTEDROWS();
+ return sqlAffectedRows();
}
}
}
'list_network_types' => 'types',
// Network request parameter
'list_network_request_params' => 'request_params',
- // Vcheck request parameter
- 'list_network_vcheck_params' => 'vcheck_params',
// Network API response array index translation
'list_network_array_translation' => 'array_translation',
);
// Exports (and displays) the table 'network_data'
function doAdminNetworkExportData () {
// Query for all networks
- $result = SQL_QUERY('SELECT
+ $result = sqlQuery('SELECT
`network_short_name`,
`network_title`,
`network_reflink`,
$SQL = '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`, `network_active`) VALUES' . PHP_EOL;
// Load all entries
- while ($content = SQL_FETCHARRAY($result)) {
+ while ($content = sqlFetchArray($result)) {
// Add row
$SQL .= "('" .
$content['network_short_name'] . "', '" .
$SQL = substr($SQL, 0, -2);
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Output the SQL query
loadTemplate('admin_export_network_data', FALSE, $SQL);
} // END - if
// Get all network types of given network
- $result = SQL_QUERY_ESC('SELECT
+ $result = sqlQueryEscaped('SELECT
`network_type_id`,
`network_id`,
`network_type_handler`,
$SQL = '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`, `network_type_reload_time_unit`, `network_text_encoding`) VALUES' . PHP_EOL;
// Load all entries
- while ($content = SQL_FETCHARRAY($result)) {
+ while ($content = sqlFetchArray($result)) {
// Add row
$SQL .= '(' .
$content['network_type_id'] . ', ' .
$SQL = substr($SQL, 0, -2);
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Output the SQL query
loadTemplate('admin_export_network_types', FALSE, $SQL);
} // END - if
// Get all network types of given network
- $result = SQL_QUERY_ESC('SELECT
+ $result = sqlQueryEscaped('SELECT
`network_id`,
`network_type_id`,
`network_request_param_key`,
$SQL = 'INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`, `network_type_id`, `network_request_param_key`, `network_request_param_value`, `network_request_param_default`) VALUES' . PHP_EOL;
// Load all entries
- while ($content = SQL_FETCHARRAY($result)) {
+ while ($content = sqlFetchArray($result)) {
// Add row
$SQL .= '(' .
$content['network_id'] . ', ' .
$content['network_type_id'] . ", '" .
$content['network_request_param_key'] . "', '" .
$content['network_request_param_value'] . "', ";
-
+
// Is the column NULL?
if (is_null($content['network_request_param_default'])) {
// Column is NULL
$SQL = substr($SQL, 0, -2);
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Output the SQL query
loadTemplate('admin_export_network_request_params', FALSE, $SQL);
}
-// Exports (and displays) the table 'network_vcheck_params'
-function doAdminNetworkExportVcheckParams () {
- // 'network_id' must be set
- if (!isGetRequestElementSet('network_id')) {
- // Only network vcheck parameters of one network will be exported per time
- reportBug(__FUNCTION__, __LINE__, 'network_id not provided, please fix your links.');
- } // END - if
-
- // Get all network types of given network
- $result = SQL_QUERY_ESC('SELECT
- `network_id`,
- `network_vcheck_param_key`,
- `network_vcheck_param_value`,
- `network_vcheck_param_default`
-FROM
- `{?_MYSQL_PREFIX?}_network_vcheck_params`
-WHERE
- `network_id`=%s
-ORDER BY
- `network_vcheck_param_id` ASC',
- array(
- bigintval(getRequestElement('network_id'))
- ), __FUNCTION__, __LINE__);
-
- // Start an empty SQL query
- $SQL = 'INSERT INTO `{?_MYSQL_PREFIX?}_network_vcheck_params` (`network_id`, `network_vcheck_param_key`, `network_vcheck_param_value`, `network_vcheck_param_default`) VALUES' . PHP_EOL;
-
- // Load all entries
- while ($content = SQL_FETCHARRAY($result)) {
- // Add row
- $SQL .= '(' .
- $content['network_id'] . ", '" .
- $content['network_vcheck_param_key'] . "', '" .
- $content['network_vcheck_param_value'] . "', ";
-
- // Is the column NULL?
- if (is_null($content['network_vcheck_param_default'])) {
- // Column is NULL
- $SQL .= "NULL),\n";
- } else {
- // Column is set
- $SQL .= chr(39) . $content['network_vcheck_param_default'] . "'),\n";
- }
- } // END - while
-
- // Remove last commata and close braces
- $SQL = substr($SQL, 0, -2);
-
- // Free result
- SQL_FREERESULT($result);
-
- // Output the SQL query
- loadTemplate('admin_export_network_vcheck_params', FALSE, $SQL);
-}
-
// Exports (and displays) the table 'network_array_translation'
function doAdminNetworkExportArrayTranslation () {
// 'network_id' must be set
} // END - if
// Get all network types of given network
- $result = SQL_QUERY_ESC('SELECT
+ $result = sqlQueryEscaped('SELECT
`network_id`,
`network_type_id`,
`network_array_index`,
$SQL = 'INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`, `network_type_id`, `network_array_index`, `network_array_sort`) VALUES' . PHP_EOL;
// Load all entries
- while ($content = SQL_FETCHARRAY($result)) {
+ while ($content = sqlFetchArray($result)) {
// Add row
$SQL .= '(' .
$content['network_id'] . ', ' .
$SQL = substr($SQL, 0, -2);
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Output the SQL query
loadTemplate('admin_export_network_array_translation', FALSE, $SQL);
}
// Load all network type handlers by given network id and extract only network_type_id
- $networkTypes = getArrayFromArrayIndex(getNetworkTypeDataById(postRequestElement('network_id')), 'network_type_id');
+ $networkTypes = getArrayFromArrayIndex(getNetworkTypeDataFromId(postRequestElement('network_id')), 'network_type_id');
// Set generated array
setAjaxReplyContent(encodeJson($networkTypes));