ON
`p`.`id`=`s`.`pool_id`
WHERE
- `p`.`id`=%s
+ `s`.`pool_id`=%s
LIMIT 1",
bigintval(getRequestElement('id'))
);
$listed = TRUE;
$DATA = getRequestElement('id');
} elseif (((isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (postRequestElement('type') == 'bonus')) && (isExtensionActive('bonus'))) {
- // @TODO This constant might be unused? define('__LIST_UNCON_TITLE', '{--ADMIN_LIST_UNCONFIRMED_BONUS_LINKS--}');
-
// SQL query for mail data (both ids are required for compatiblity to above normal mail
- // @TODO `id` has been used two times???
$sql = sprintf("SELECT
`id`,
- `id` AS `sender`,
+ NULL AS `sender`,
`subject`,
`text`,
`url`,
// but it does only show unconfirmed mail links from existing user
// accounts. So if you have delete one you did not see those links
$result = SQL_QUERY_ESC("SELECT
- l.`userid`,
+ `l`.`userid`,
`u`.`status`,
`u`.`surname`,
`u`.`family`,
LEFT JOIN
`{?_MYSQL_PREFIX?}_user_data` AS `u`
ON
- l.`userid`=`u`.`userid`
+ `l`.`userid`=`u`.`userid`
WHERE
- l.`%s`=%s
+ `l`.`%s`=%s
ORDER BY
- l.`userid` ASC
+ `l`.`userid` ASC
LIMIT %s",
array(
$col,