$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'));
// 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`
+ `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?