-$result = SQL_QUERY_ESC("SELECT `used_points`, `ref_payout` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1",
- array(getUserId()), __FILE__, __LINE__);
-list($usedPoints, $PAY) = SQL_FETCHROW($result);
-SQL_FREERESULT($result);
-
-// Initialize variables
-$CONFIRMED = '---'; $SENT = '---'; $RECEIVED = '---';
-
-// Only user >= v0.1.2: Fetch confirmed mails counter
-if (getExtensionVersion('user') >= '0.1.2') {
- $add = '';
- if (getExtensionVersion('user') >= '0.1.4') {
- $add = ", `emails_sent`, `emails_received`";
- }
- $result = SQL_QUERY_ESC("SELECT `mails_confirmed`".$add." FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1", array(getUserId()), __FILE__, __LINE__);
- list($CONFIRMED, $SENT, $RECEIVED) = SQL_FETCHROW($result);
- SQL_FREERESULT($result);
-
- // Please update the user extension if you see 3 dashes
- if (empty($SENT)) $SENT = '---';
- if (empty($RECEIVED)) $RECEIVED = '---';
-} else {
- // Please update!
- $CONFIRMED = '---';
-}
-
-// If TLOCK is 0 add 3 zeros for floating
-if ($TLOCK == '0') $TLOCK = '0.00000';
-
-// Remember several values in constants
-$content['used'] = translateComma($usedPoints);
-$content['tpts'] = translateComma($totalPoints - $usedPoints);
-$content['tref'] = $TREF;
-$content['tlock'] = translateComma($TLOCK);
-