0) && (isGetRequestElementSet('t'))) {
// Set row name
$t = '';
switch (getRequestElement('t')) {
case 'bonusid': // Bonus mail
$t = 'bonus_id';
break;
case 'mailid': // Regular member mail
$t = 'mail_id';
break;
default: // Invalid type
logDebugMessage(__FILE__, __LINE__, sprintf('Invalid type %s detected.', getRequestElement('t')));
break;
} // END - switch
// Valid type?
if (!empty($t)) {
// Check for data
$result = sqlQueryEscaped("SELECT
`d`.`userid`,
`b`.`level`,
`b`.`points`
FROM
`{?_MYSQL_PREFIX?}_user_data` AS `d`
INNER JOIN
`{?_MYSQL_PREFIX?}_bonus_turbo` AS `b`
ON
`d`.`userid`=`b`.`userid`
WHERE
`d`.`status`='CONFIRMED' AND
`d`.`userid`=%s AND
`b`.`%s`=%s
LIMIT 1",
array(
bigintval(getRequestElement('userid')),
$t,
bigintval(getRequestElement('d'))
), __FILE__, __LINE__);
// Entry found?
if (sqlNumRows($result) == 1) {
// Load data
$content = sqlFetchArray($result);
// Prepare constants for the pre-template
$content['mailid'] = bigintval(getRequestElement('d'));
$content['rows'] = addBonusRanks(bigintval(getRequestElement('d')), $t, bigintval(getRequestElement('userid')));
// Get some prepared content
$content = merge_array($content, $GLOBALS['ranking_content']);
// Load pre-template
$content['message'] = loadTemplate('show_bonus_msg', TRUE, $content);
} else {
// No data found
$content['message'] = '{--BONUS_SHOW_NO_DATA--}';
}
// Free memory
sqlFreeResult($result);
} else {
// Wrong type entered
$content['message'] = '{--BONUS_SHOW_WRONG_TYPE--}';
}
} else {
// Wrong call!
$content['message'] = '{--BONUS_SHOW_WRONG_CALL--}';
}
// Load final template
loadTemplate('show_bonus', FALSE, $content);
// Include footer
loadPageFooter();
// [EOF]
?>