if ($total_users == 1) {
$l_total_user_s = $lang['Registered_user_total'];
} else {
$l_total_user_s = $lang['Registered_users_total'];
}
}
// End information for standard Who-is-online-Block
// START Include-Blocks
includeTickerBlock();
includeAuctionRoomBlock();
includeCloseToEndBlock();
includeStatisticBlock();
includeMyAuctionsBlock($userdata);
includeCalendarBlock();
includeSearchBlock();
includeTermsBlock();
includeNewsBlock();
includeAuctionSpecialBlock();
includeAuctionDropDownRoomBlock();
includeLastBidsBlock();
includeNewestOffersBlock();
// END Include-Blocks
// 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 (!empty($mode)) {
switch ($mode) {
break;
case 'store':
$sql = "SELECT *\r\n FROM " . AUCTION_USER_STORE_TABLE . "\r\n WHERE FK_user_id =" . $HTTP_GET_VARS[POST_USERS_URL];
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not query user-store information', '', __LINE__, __FILE__, $sql);
}
// if
$row = $db->sql_fetchrow($result);
$row['show_block_ticker'] ? includeTickerBlock() : "";
$row['show_block_rooms'] ? includeAuctionRoomBlock() : "";
$row['show_block_closetoend'] ? includeCloseToEndBlock() : "";
$row['show_block_statistics'] ? includeStatisticBlock() : "";
$row['show_block_myauction'] ? includeMyAuctionsBlock($userdata) : "";
$row['show_block_calendar'] ? includeCalendarBlock() : "";
$row['show_block_search'] ? includeSearchBlock() : "";
$row['show_block_priceinfo'] ? includeTermsBlock() : "";
$row['show_block_specials'] ? includeAuctionSpecialBlock() : "";
$row['show_block_drop_down'] ? includeAuctionDropDownRoomBlock() : "";
if ($userdata['user_id'] == $HTTP_GET_VARS[POST_USERS_URL]) {
$template->assign_block_vars('info_edit', array('L_STORE_EDIT' => $lang['store_edit'], 'U_STORE_EDIT' => append_sid("auction_mystore.php")));
}
include $phpbb_root_path . 'auction/auction_header.' . $phpEx;
$template->set_filenames(array('body' => 'auction_user_store.tpl'));
$template->assign_block_vars('store', array('STORE_HEADER' => stripslashes($row['store_header'])));
// Grab offer-data
$sql = "SELECT t.*,\r\n u.username,\r\n u.user_id,\r\n u2.username as maxbidder_user_name,\r\n u2.user_id as maxbidder_user_id\r\n FROM (" . AUCTION_OFFER_TABLE . " t\r\n LEFT JOIN " . USERS_TABLE . " u ON u.user_id = t.FK_auction_offer_user_id\r\n LEFT JOIN " . USERS_TABLE . " u2 ON u2.user_id = t.FK_auction_offer_last_bid_user_id)\r\n WHERE FK_auction_offer_user_id = " . $HTTP_GET_VARS[POST_USERS_URL] . "\r\n AND auction_offer_time_stop>" . time() . "\r\n AND auction_offer_time_start<" . time() . "\r\n AND auction_offer_paid = 1\r\n AND auction_offer_state = " . AUCTION_OFFER_UNLOCKED . "\r\n AND auction_offer_direct_sell_price > 0\r\n ORDER BY t.auction_offer_time_stop;";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not obtain offer information', '', __LINE__, __FILE__, $sql);
}
$total_offers = 0;
while ($row = $db->sql_fetchrow($result)) {