');
// Check for possible running rallyes
$ADD = " AND d.is_active='Y'";
if (isAdmin()) $ADD = '';
$result = SQL_QUERY("SELECT
d.id, d.admin_id, a.login, d.title, d.descr, d.template, d.start_time, d.end_time, d.min_users, d.min_prices
FROM
`{?_MYSQL_PREFIX?}_rallye_data` AS d
INNER JOIN
`{?_MYSQL_PREFIX?}_admins` AS a
ON
d.admin_id=a.id
WHERE
d.notified='Y'" . $ADD . "
ORDER BY
d.end_time
LIMIT 1", __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Found some (normally one...
list($id, $adminId, $login, $title, $descr, $templ, $start, $end, $min_users, $min_prices) = SQL_FETCHROW($result);
$expired = false;
if ($end < time()) {
// Rallye is expired
$content['extras'] = '{--RALLYE_HAS_EXPIRED--}';
$expired = true;
} elseif (time() >= ($end - getConfig('ONE_DAY'))) {
// Rallye will expire in less one day!
$content['extras'] = '{--RALLYE_EXPIRE_ONE_DAY--}';
} else {
$content['extras'] = '{--RALLYE_REGISTER_NOW--}';
}
// Set admin line (currently set to impressum, later to contact form)
// @TODO Reactivate this: $content['admin'] = '' . $login . '';
// Set title
$content['title'] = $title;
// Handle description...
if ((empty($descr)) && (!empty($templ))) {
// Use description from template
$content['descr'] = loadTemplate('rallye_' . $templ, true);
} else {
// Use description from database
$content['descr'] = $descr;
}
// Set start and end time
$content['start'] = generateDateTime($start, 1);
$content['end'] = generateDateTime($end , 1);
// Determine min_users
$content['min_users'] = determineReferalRallyeMinimumUsers($min_users);
// Determine min prices (now in function)
$content['min_prices'] = determineReferalRallyeMinimumPrices($min_prices);
if ($expired === true) {
$content['prices'] = addReferalRallyeWinners($id);
$content['top_users'] = '' . $content['extras'] . '
';
$content['can_win_this'] = '{--RALLYE_OUR_WINNERS_ARE--}';
} else {
$content['prices'] = addReferalRallyePrices($id, 'html');
$content['top_users'] = addReferalRallyeTopUsers($id, getMemberId());
$content['can_win_this'] = '{--RALLYE_YOU_CAN_WIN--}';
}
// And load final template
loadTemplate('guest_rallye_show', false, $content);
} else {
// No rallye found so far
loadTemplate('guest_no_rallyes');
}
// Close the div tag
outputHtml('');
// [EOF]
?>