// Check for all earnings
$result = SQL_QUERY('SELECT
- d.`earning_id`,
- d.`earning_group`,
- d.`earning_provider`
+ `d`.`earning_id`,
+ `d`.`earning_group`,
+ `d`.`earning_provider`
FROM
- `{?_MYSQL_PREFIX?}_earning_data` AS d
+ `{?_MYSQL_PREFIX?}_earning_data` AS `d`
ORDER BY
- d.`earning_sorting` ASC', __FILE__, __LINE__);
+ `d`.`earning_sorting` ASC', __FILE__, __LINE__);
// Are there entries?
if (!SQL_HASZERONUMS($result)) {
while ($content = SQL_FETCHARRAY($result)) {
// Load user_earning data
$result2 = SQL_QUERY_ESC('SELECT
- u.`earning_active`,
- UNIX_TIMESTAMP(u.`earning_added`) AS `earning_added`,
- UNIX_TIMESTAMP(u.`earning_canceled`) AS `earning_canceled`,
- u.`earning_daily_amount`,
- u.`earning_points`
+ `u`.`earning_active`,
+ UNIX_TIMESTAMP(`u`.`earning_added`) AS `earning_added`,
+ UNIX_TIMESTAMP(`u`.`earning_canceled`) AS `earning_canceled`,
+ `u`.`earning_daily_amount`,
+ `u`.`earning_points`
FROM
- `{?_MYSQL_PREFIX?}_user_earning` AS u
+ `{?_MYSQL_PREFIX?}_user_earning` AS `u`
WHERE
- u.`earning_id`=%s AND
- u.`earning_userid`=%s
+ `u`.`earning_id`=%s AND
+ `u`.`earning_userid`=%s
LIMIT 1',
array(
bigintval($content['earning_id']),