X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=0.2.1%2Finc%2Fmodules%2Fmember%2Fwhat-rallyes.php;fp=0.2.1%2Finc%2Fmodules%2Fmember%2Fwhat-rallyes.php;h=14a9597bc34c068f9ba968a998a5edde83fee3fa;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hp=a801ad92869a9df9fe438be6ae47a39d8f8d760d;hpb=157ee010917df5ca07e6d31b42f67417b2516d74;p=mailer.git diff --git a/0.2.1/inc/modules/member/what-rallyes.php b/0.2.1/inc/modules/member/what-rallyes.php index a801ad9286..14a9597bc3 100644 --- a/0.2.1/inc/modules/member/what-rallyes.php +++ b/0.2.1/inc/modules/member/what-rallyes.php @@ -1,152 +1,152 @@ -"); - -// 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__); - -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); - SQL_FREERESULT($result); - - $expired = false; - if ($end < time()) - { - // Rallye is expired - define('__RALLYE_EXTRAS', RALLYE_HAS_EXPIRED); - $expired = true; - } - elseif (time() >= ($end - ONE_DAY)) - { - // Rallye will expire in less one day! - define('__RALLYE_EXTRAS', RALLYE_EXPIRE_ONE_DAY); - } - else - { - define('__RALLYE_EXTRAS', "".RALLYE_GET_REFLINK.""); - } - // Set admin line (currently set to impressum, later to contact form) - define('__RALLYE_ADMIN', "".$login.""); - - // Set title - define('__RALLYE_TITLE', COMPILE_CODE($title)); - - // Handle description... - if ((empty($descr)) && (!empty($templ))) - { - // Use description from template - define('__RALLYE_DESCR', LOAD_TEMPLATE("rallye_".$templ, true)); - } - else - { - // Use description from database - define('__RALLYE_DESCR', COMPILE_CODE($descr)); - } - - if ($min_users == 0) - { - // Rallye ends without user limitation - define('__RALLYE_MAX_USERS', RALLYE_END_NO_USER_LIMITATION); - } - else - { - // Rallye ends when X members are totally in your exchange - define('__RALLYE_MAX_USERS', RALLYE_END_USERS_1." ".$min_users." ".RALLYE_END_USERS_2); - } - if ($min_prices == 0) - { - // Rallye ends without user limitation - define('__RALLYE_MIN_PRICES', RALLYE_END_NO_PRICE_LIMITATION); - } - else - { - // Rallye ends when X members are totally in your exchange - define('__RALLYE_MIN_PRICES', RALLYE_END_PRICES_1." ".$min_prices." ".RALLYE_END_PRICES_2); - } - - // Set start and end time - define('__RALLYE_START', MAKE_DATETIME($start, "1")); - define('__RALLYE_END' , MAKE_DATETIME($end , "1")); - - if ($expired) - { - define('__RALLYE_PRICES', RALLYE_LIST_WINNERS($id)); - define('__RALLYE_TOP_USERS', "
".__RALLYE_EXTRAS."
"); - define('__RALLYE_CAN_WIN_THIS', RALLYE_OUR_WINNERS_ARE); - } - else - { - define('__RALLYE_PRICES', RALLYE_ADD_PRICES($id, "html")); - define('__RALLYE_TOP_USERS', RALLYE_ADD_TOPUSERS($id, $GLOBALS['userid'])); - define('__RALLYE_CAN_WIN_THIS', RALLYE_YOU_CAN_WIN); - } - - // And load final template - LOAD_TEMPLATE("guest_rallye_show"); -} - else -{ - // No rallye found so far - LOAD_TEMPLATE("guest_no_rallyes"); -} -// -OUTPUT_HTML (""); -// -?> +"); + +// 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__); + +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); + SQL_FREERESULT($result); + + $expired = false; + if ($end < time()) + { + // Rallye is expired + define('__RALLYE_EXTRAS', RALLYE_HAS_EXPIRED); + $expired = true; + } + elseif (time() >= ($end - ONE_DAY)) + { + // Rallye will expire in less one day! + define('__RALLYE_EXTRAS', RALLYE_EXPIRE_ONE_DAY); + } + else + { + define('__RALLYE_EXTRAS', "".RALLYE_GET_REFLINK.""); + } + // Set admin line (currently set to impressum, later to contact form) + define('__RALLYE_ADMIN', "".$login.""); + + // Set title + define('__RALLYE_TITLE', COMPILE_CODE($title)); + + // Handle description... + if ((empty($descr)) && (!empty($templ))) + { + // Use description from template + define('__RALLYE_DESCR', LOAD_TEMPLATE("rallye_".$templ, true)); + } + else + { + // Use description from database + define('__RALLYE_DESCR', COMPILE_CODE($descr)); + } + + if ($min_users == 0) + { + // Rallye ends without user limitation + define('__RALLYE_MAX_USERS', RALLYE_END_NO_USER_LIMITATION); + } + else + { + // Rallye ends when X members are totally in your exchange + define('__RALLYE_MAX_USERS', RALLYE_END_USERS_1." ".$min_users." ".RALLYE_END_USERS_2); + } + if ($min_prices == 0) + { + // Rallye ends without user limitation + define('__RALLYE_MIN_PRICES', RALLYE_END_NO_PRICE_LIMITATION); + } + else + { + // Rallye ends when X members are totally in your exchange + define('__RALLYE_MIN_PRICES', RALLYE_END_PRICES_1." ".$min_prices." ".RALLYE_END_PRICES_2); + } + + // Set start and end time + define('__RALLYE_START', MAKE_DATETIME($start, "1")); + define('__RALLYE_END' , MAKE_DATETIME($end , "1")); + + if ($expired) + { + define('__RALLYE_PRICES', RALLYE_LIST_WINNERS($id)); + define('__RALLYE_TOP_USERS', "
".__RALLYE_EXTRAS."
"); + define('__RALLYE_CAN_WIN_THIS', RALLYE_OUR_WINNERS_ARE); + } + else + { + define('__RALLYE_PRICES', RALLYE_ADD_PRICES($id, "html")); + define('__RALLYE_TOP_USERS', RALLYE_ADD_TOPUSERS($id, $GLOBALS['userid'])); + define('__RALLYE_CAN_WIN_THIS', RALLYE_YOU_CAN_WIN); + } + + // And load final template + LOAD_TEMPLATE("guest_rallye_show"); +} + else +{ + // No rallye found so far + LOAD_TEMPLATE("guest_no_rallyes"); +} +// +OUTPUT_HTML (""); +// +?>