* $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 *
// Is there a network selected?
if (isGetRequestElementSet('network_id')) {
// Get its data for template
- $networkData = getNetworkDataById(getRequestElement('network_id'));
+ $networkData = getNetworkDataFromId(getRequestElement('network_id'));
$networkData['network_type_id'] = 0;
// Init disabled list
$ADD = '';
if ((isPostRequestElementSet('network_type_id')) && (!is_array(postRequestElement('network_type_id')))) {
// Only show from current type handler
- $ADD = sprintf(" AND p.`network_type_id`=%s", bigintval(postRequestElement('network_type_id')));
+ $ADD = sprintf(' AND `p`.`network_type_id`=%s', bigintval(postRequestElement('network_type_id')));
// Overwrite type id
$networkData['network_type_id'] = bigintval(postRequestElement('network_type_id'));
} // END - if
// Load all advert types for given network
- $result = SQL_QUERY_ESC("SELECT
- p.`network_request_param_id`,
- t.`network_type_id`,
- t.`network_type_handler`,
- p.`network_request_param_key`,
- p.`network_request_param_value`,
- p.`network_request_param_default`
+ $result = sqlQueryEscaped("SELECT
+ `p`.`network_request_param_id`,
+ `t`.`network_type_id`,
+ `t`.`network_type_handler`,
+ `p`.`network_request_param_key`,
+ `p`.`network_request_param_value`,
+ `p`.`network_request_param_default`
FROM
- `{?_MYSQL_PREFIX?}_network_request_params` AS p
+ `{?_MYSQL_PREFIX?}_network_request_params` AS `p`
INNER JOIN
- `{?_MYSQL_PREFIX?}_network_types` AS t
+ `{?_MYSQL_PREFIX?}_network_types` AS `t`
ON
- p.`network_type_id`=t.`network_type_id`
+ `p`.`network_type_id`=`t`.`network_type_id`
WHERE
- p.`network_id`=%s" . $ADD . "
+ `p`.`network_id`=%s" . $ADD . "
ORDER BY
- t.`network_type_handler` ASC,
- p.`network_request_param_id` ASC",
+ `t`.`network_type_handler` ASC,
+ `p`.`network_request_param_id` ASC",
array(bigintval(getRequestElement('network_id'))), __FILE__, __LINE__);
// Are there entries?
- if (!SQL_HASZERONUMS($result)) {
+ if (!ifSqlHasZeroNums($result)) {
// List all entries
$OUT = '';
- while ($row = SQL_FETCHARRAY($result)) {
+ while ($row = sqlFetchArray($result)) {
// Add it to network if the type matches selected
if ($row['network_type_id'] == postRequestElement('network_type_id')) {
// Matches, then add it for disabling this entry
}
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Add form for adding new params
loadTemplate('admin_add_network_request_param', FALSE, $networkData);