X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-rallyes.php;h=43afabe64ddebad8cc450c4595834e51f45a3a64;hp=be0254f732f50cc7d02dae0f81ee625bba5208b1;hb=4f7df133f736da124e6f7bd02008b9093f736451;hpb=7b0f17cd637e388049d2167811e4332cec1e979b diff --git a/inc/modules/guest/what-rallyes.php b/inc/modules/guest/what-rallyes.php index be0254f732..43afabe64d 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` ASC +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); + $content = SQL_FETCHARRAY($result); - $expired = false; - if ($end < time()) { + $expired = FALSE; + if (($content['end_time'] < time()) && (getTotalConfirmedUser() >= $content['min_users']) && (getTotalRallyeWinners($content['id']) >= $content['min_prices'])) { // Rallye is expired - define('__RALLYE_EXTRAS', getMessage('RALLYE_HAS_EXPIRED')); - $expired = true; - } elseif (time() >= ($end - getConfig('one_day'))) { + $content['extras'] = '{--RALLYE_HAS_EXPIRED--}'; + $expired = TRUE; + } elseif (time() >= ($content['end_time'] - 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.""); - // Set title - define('__RALLYE_TITLE', COMPILE_CODE($title)); + // Set admin line (currently set to impressum, later to contact form) + // @TODO Reactivate this: $content['admin'] = '' . $content['login'] . ''; // Handle description... - if ((empty($descr)) && (!empty($templ))) { + if ((empty($content['descr'])) && (!empty($content['template']))) { // Use description from template - define('__RALLYE_DESCR', LOAD_TEMPLATE("rallye_".$templ, true)); - } else { - // Use description from database - define('__RALLYE_DESCR', COMPILE_CODE($descr)); - } + $content['descr'] = loadTemplate('rallye_' . $content['template'], TRUE); + } // END - if // Set start and end time - define('__RALLYE_START', generateDateTime($start, "1")); - define('__RALLYE_END' , generateDateTime($end , "1")); + $content['start_time'] = generateDateTime($content['start_time'], 1); + $content['end_time'] = generateDateTime($content['end_time'] , 1); // Determine min_users - define('__RALLYE_MAX_USERS', RALLYE_DETERMINE_MIN_USERS($min_users)); + $content['min_users'] = determineReferralRallyeMinimumUsers($content['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'] = determineReferralRallyeMinimumPrices($content['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')); + if ($expired === TRUE) { + $content['prices'] = addReferralRallyeWinners('guest', $content['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'] = addReferralRallyePrices($content['id'], 'html'); + $content['top_users'] = addReferralRallyeTopUsers('guest', $content['id'], getMemberId()); + $content['can_win_this'] = '{--RALLYE_YOU_CAN_WIN--}'; } // And load final template - LOAD_TEMPLATE("guest_rallye_show"); + loadTemplate('guest_show_rallye', FALSE, $content); } else { // No rallye found so far - LOAD_TEMPLATE("guest_no_rallyes"); + loadTemplate('guest_rallye_404'); } // Close the div tag -OUTPUT_HTML("
"); +outputHtml(''); -// +// [EOF] ?>