$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) { case 'my_auctions': $page_title = $lang['auction_myauction_auctions']; include './includes/page_header.php';
$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)) { $auction_offer_rowset[] = $row; $total_offers++;