X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-rallyes.php;h=c8a79d642081d3219c92eda3421da65cbd5484fc;hp=afcb5b99134c161b31b41b31598dc80397a0e0d5;hb=c3b4eaf29946349ff058691db2dcb615a5379bb2;hpb=ccc4a69ce9b17aa8d7b1554a3b2b017db091821b diff --git a/inc/modules/guest/what-rallyes.php b/inc/modules/guest/what-rallyes.php index afcb5b9913..c8a79d6420 100644 --- a/inc/modules/guest/what-rallyes.php +++ b/inc/modules/guest/what-rallyes.php @@ -1,7 +1,7 @@ "); +outputHtml('
'); // Check for possible running rallyes -$ADMIN = " AND d.is_active='Y'"; -if (IS_ADMIN()) $ADMIN = ''; - -$result = SQL_QUERY("SELECT DISTINCT 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, `{!_MYSQL_PREFIX!}_admins` AS a -WHERE d.admin_id=a.id".$ADMIN." AND d.notified='Y' -ORDER BY d.end_time LIMIT 1", __FILE__, __LINE__); +$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, $aid, $login, $title, $descr, $templ, $start, $end, $min_users, $min_prices) = SQL_FETCHROW($result); + list($id, $adminId, $login, $title, $descr, $templ, $start, $end, $min_users, $min_prices) = SQL_FETCHROW($result); $expired = false; if ($end < time()) { // Rallye is expired - define('__RALLYE_EXTRAS', getMessage('RALLYE_HAS_EXPIRED')); + $content['extras'] = '{--RALLYE_HAS_EXPIRED--}'; $expired = true; - } elseif (time() >= ($end - getConfig('one_day'))) { + } elseif (time() >= ($end - getOneDay())) { // Rallye will expire in less one day! - define('__RALLYE_EXTRAS', getMessage('RALLYE_EXPIRE_ONE_DAY')); + $content['extras'] = '{--RALLYE_EXPIRE_ONE_DAY--}'; } else { - define('__RALLYE_EXTRAS', "{--RALLYE_REGISTER_NOW--}"); + $content['extras'] = '{--RALLYE_REGISTER_NOW--}'; } + // Set admin line (currently set to impressum, later to contact form) - define('__RALLYE_ADMIN', "".$login.""); + // @TODO Reactivate this: $content['admin'] = '' . $login . ''; // Set title - define('__RALLYE_TITLE', COMPILE_CODE($title)); + $content['title'] = $title; // Handle description... if ((empty($descr)) && (!empty($templ))) { // Use description from template - define('__RALLYE_DESCR', LOAD_TEMPLATE("rallye_".$templ, true)); + $content['descr'] = loadTemplate('rallye_' . $templ, true); } else { // Use description from database - define('__RALLYE_DESCR', COMPILE_CODE($descr)); + $content['descr'] = $descr; } // Set start and end time - define('__RALLYE_START', generateDateTime($start, '1')); - define('__RALLYE_END' , generateDateTime($end , '1')); + $content['start'] = generateDateTime($start, 1); + $content['end'] = generateDateTime($end , 1); // Determine min_users - define('__RALLYE_MAX_USERS', RALLYE_DETERMINE_MIN_USERS($min_users)); + $content['min_users'] = determineReferalRallyeMinimumUsers($min_users); - if ($min_prices == 0) { - // Rallye ends without user limitation - define('__RALLYE_MIN_PRICES', getMessage('RALLYE_END_NO_PRICE_LIMITATION')); - } else { - // Rallye ends when X members are totally in your exchange - define('__RALLYE_MIN_PRICES', getMessage('RALLYE_END_PRICES_1') . ' ' . $min_prices . ' ' . getMessage('RALLYE_END_PRICES_2')); - } + // Determine min prices (now in function) + $content['min_prices'] = determineReferalRallyeMinimumPrices($min_prices); if ($expired === true) { - define('__RALLYE_PRICES', RALLYE_LIST_WINNERS($id)); - define('__RALLYE_TOP_USERS', "
{!__RALLYE_EXTRAS!}
"); - define('__RALLYE_CAN_WIN_THIS', getMessage('RALLYE_OUR_WINNERS_ARE')); + $content['prices'] = addReferalRallyeWinners($id); + $content['top_users'] = '
' . $content['extras'] . '
'; + $content['can_win_this'] = '{--RALLYE_OUR_WINNERS_ARE--}'; } else { - define('__RALLYE_PRICES', RALLYE_ADD_PRICES($id, 'html')); - define('__RALLYE_TOP_USERS', RALLYE_ADD_TOPUSERS($id, getUserId())); - define('__RALLYE_CAN_WIN_THIS', getMessage('RALLYE_YOU_CAN_WIN')); + $content['prices'] = addReferalRallyePrices($id, 'html'); + $content['top_users'] = addReferalRallyeTopUsers($id, getMemberId()); + $content['can_win_this'] = '{--RALLYE_YOU_CAN_WIN--}'; } // And load final template - LOAD_TEMPLATE("guest_rallye_show"); + loadTemplate('guest_rallye_show', false, $content); } else { // No rallye found so far - LOAD_TEMPLATE("guest_no_rallyes"); + loadTemplate('guest_no_rallyes'); } // Close the div tag -OUTPUT_HTML("
"); +outputHtml(''); -// +// [EOF] ?>