// 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__);
-// Do we have entries?
+// Are there entries?
if (!SQL_HASZERONUMS($result)) {
// Init output
$OUT = '';
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']),
getMemberId()
), __FILE__, __LINE__);
- // Do we have an entry?
+ // Is there an entry?
if (SQL_NUMROWS($result2) == 1) {
// Load it
$content = merge_array($content, SQL_FETCHARRAY($result2));
// Free result
SQL_FREERESULT($result2);
- // Do we have user_earning data available?
+ // Is there user_earning data available?
if (!isset($content['earning_active'])) {
// Load row template "open subscription"
- $OUT .= loadTemplate('member_earning_' . strtolower($content['earning_group']) . '_form_row', true, $content);
+ $OUT .= loadTemplate('member_earning_' . strtolower($content['earning_group']) . '_form_row', TRUE, $content);
} else {
// Load row template "already subscribed"
- $OUT .= loadTemplate('member_earning_' . strtolower($content['earning_group']) . '_row', true, $content);
+ $OUT .= loadTemplate('member_earning_' . strtolower($content['earning_group']) . '_row', TRUE, $content);
}
} // END - while
// Load main template
- loadTemplate('member_earning', false, $OUT);
+ loadTemplate('member_earning', FALSE, $OUT);
} else {
// Display message
displayMessage('{--MEMBER_EARNINGS_404--}');