function includeNewestOffersBlock()
{
    global $db, $template, $lang, $board_config;
    $auction_config_data = init_auction_config();
    // Just display if switched on via ACP
    if ($auction_config_data['auction_block_display_newest_offers'] == 1) {
        $template->assign_block_vars('newest_offers_block', array('AUCTION_NEWEST_OFFER' => $lang['auction_newest_offer']));
        $sql = "SELECT o.auction_offer_title,\r\n                                   o.PK_auction_offer_id,\r\n                                   o.auction_offer_time_start\r\n                            FROM " . AUCTION_OFFER_TABLE . " o\r\n                            WHERE ( o.auction_offer_state=0 AND\r\n                                    o.auction_offer_time_stop>" . time() . " AND\r\n                                    o.auction_offer_time_start<" . time() . "\r\n                            AND o.auction_offer_paid = 1 )\r\n                            ORDER BY o.auction_offer_time_start DESC\r\n                            LIMIT 0, " . $auction_config_data['auction_config_newest_offers_number'] . "";
        if (!($result = $db->sql_query($sql))) {
            message_die(GENERAL_ERROR, 'Could not query newest offer block', '', __LINE__, __FILE__, $sql);
        }
        // End if
        while ($auction_newest_offers_block = $db->sql_fetchrow($result)) {
            $template->assign_block_vars('newest_offers_block.newest_offers_block_offer', array('U_AUCTION_NEWEST_OFFER_TITLE' => append_sid("auction_offer_view.php?" . POST_AUCTION_OFFER_URL . "=" . $auction_newest_offers_block['PK_auction_offer_id']), 'AUCTION_NEWEST_OFFER_TITLE' => substr($auction_newest_offers_block['auction_offer_title'], 0, 15), 'AUCTION_NEWEST_OFFER_TIME' => create_date($board_config['default_dateformat'], $auction_newest_offers_block['auction_offer_time_start'], $board_config['board_timezone'])));
        }
        // End while
    }
    // End if
}
}
$phpbb_root_path = "./../";
require $phpbb_root_path . 'extension.inc';
require './pagestart.' . $phpEx;
include $phpbb_root_path . 'includes/functions_selects.' . $phpEx;
include $phpbb_root_path . 'auction/functions_general.php';
include $phpbb_root_path . 'auction/auction_constants.php';
// Start Include language file
$language = $board_config['default_lang'];
if (!file_exists($phpbb_root_path . 'language/lang_' . $language . '/lang_auction.' . $phpEx)) {
    $language = 'english';
}
// if
include $phpbb_root_path . 'language/lang_' . $language . '/lang_auction.' . $phpEx;
// end include language file
$auction_config_data = init_auction_config();
// Mode setting
if (isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode'])) {
    $mode = isset($HTTP_POST_VARS['mode']) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];
    $mode = htmlspecialchars($mode);
} else {
    $mode = "";
}
// if
// Sort setting
if (isset($HTTP_POST_VARS['sort']) || isset($HTTP_GET_VARS['sort'])) {
    $sort = isset($HTTP_POST_VARS['sort']) ? $HTTP_POST_VARS['sort'] : $HTTP_GET_VARS['sort'];
    $sort = htmlspecialchars($sort);
} else {
    $sort = "";
}