* $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 *
// Handle a (maybe) sent form here
function doNetworkHandleForm () {
// Is there a form sent?
- if (countRequestPost() > 0) {
+ if ((!isPostRequestElementSet('save_expert')) && (countRequestPost() > 0)) {
// Detect sent POST form
detectNetworkProcessForm();
} elseif (!isGetRequestElementSet('do')) {
// Processes an admin form
function doAdminNetworkProcessForm () {
// Create function name
- $functionName = sprintf("doAdminNetworkProcess%s", capitalizeUnderscoreString(getRequestElement('do')));
+ $functionName = sprintf('doAdminNetworkProcess%s', capitalizeUnderscoreString(getRequestElement('do')));
// Is the function valid?
if (!function_exists($functionName)) {
// 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'", SQL_ESCAPE($type))) == 1);
+ $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
// 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), SQL_ESCAPE($key))) == 1);
+ $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
// 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), SQL_ESCAPE($key))) == 1);
+ $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
}
// "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`,
), __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
$content = '';
// Query for all networks
- $result = SQL_QUERY('SELECT
+ $result = sqlQuery('SELECT
`network_id`,
`network_short_name`,
`network_title`,
`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?
} // END - while
// Nothing found?
- if (count($rows) == 0) {
+ if (!isFilledArray($rows)) {
// Then return nothing ... ;-)
return '';
} // END - if
}
} else {
// Nothing selected
- $content = displayErrorMessage('{--ADMIN_ENTRIES_404--}');
+ $content = returnErrorMessage('{--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 = displayErrorMessage('{--ADMIN_ENTRIES_404--}');
+ $content = returnErrorMessage('{--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
+ $result = sqlQuery('SELECT
`t`.`network_type_id`,
`t`.`network_type_handler`,
`d`.`network_title`
`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 = displayErrorMessage('{--ADMIN_ENTRIES_404--}');
+ $content = returnErrorMessage('{--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',
'network_handler_config',
'network_data_id',
'network_type_id',
- true,
+ TRUE,
sprintf(' AND `network_id`=%s', bigintval($networkId))
) == 1);
} // END - if
// Is debug logging enabled or status code not 200 OK?
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;
$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
} // 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 {
// 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) {
+ if (isFilledArray($networkData)) {
// Add row template with given form name
$OUT .= loadTemplate('admin_' . getNetworkFormName() . '_networks_row', TRUE, $networkData);
} // END - if
} // 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(
// 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 = '';
$networkTypeData = getNetworkTypeDataByTypeId($networkId);
// Is there found the network?
- if (count($networkTypeData) > 0) {
+ if (isFilledArray($networkTypeData)) {
if (getNetworkFormName() == 'edit') {
// Add row template for deleting
$OUT .= loadTemplate('admin_edit_network_types_row', TRUE, $networkTypeData);
} // 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_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) {
+ if (isFilledArray($networkRequestData)) {
if (getNetworkFormName() == 'edit') {
// Add row template for deleting
$OUT .= loadTemplate('admin_edit_network_request_params_row', TRUE, $networkRequestData);
} // 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(
} // 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 {
} // 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 {
'network_array_translation',
'network_array_id',
'network_id',
- true,
- sprintf(" AND `network_type_id`=%s", bigintval(postRequestElement('network_type_id')))
+ TRUE,
+ sprintf(' AND `network_type_id`=%s', bigintval(postRequestElement('network_type_id')))
) + 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 {
$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) {
+ if (isFilledArray($networkTranslationsData)) {
if (getNetworkFormName() == 'edit') {
// Add row template for deleting
$OUT .= loadTemplate('admin_edit_network_array_translation_row', TRUE, $networkTranslationsData);
} // 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(
}
// 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 {
// 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) {
$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 {
}
} 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) {
$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 {
}
} else {
// Return amount of affected rows (1 or 2)
- return SQL_AFFECTEDROWS();
+ return sqlAffectedRows();
}
}
}
// 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);
} // 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);
$requestParams = getNetworkRequestParametersByTypeId(postRequestElement('network_type_id'));
// Is there at least one entry?
- if (count($requestParams) == 0) {
+ if (!isFilledArray($requestParams)) {
// No entry found, please setup some first
reportBug(__FUNCTION__, __LINE__, 'Network ' . $networkData['network_title'] . ' with id ' . $networkData['network_id'] . ' has no request parameters.');
} // END - if
}
// 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));
projects / mailer.git / blobdiff