connect_error) { die("Connection failed: " . $conn->connect_error); } // Get user preference for showing refunded items $showRefunded = isset($_GET['show_refunded']) ? $_GET['show_refunded'] : '0'; // Updated query to include all necessary fields $query = "SELECT id, item, purchase_date, refund_date, status, price, minecraft_username, hidden FROM purchases WHERE username = ?"; if ($showRefunded === '0') { $query .= " AND (status != 'refunded' OR hidden = 0)"; } $query .= " ORDER BY purchase_date DESC"; $stmt = $conn->prepare($query); $stmt->bind_param('s', $_SESSION['username']); $stmt->execute(); $result = $stmt->get_result(); $purchases = $result->fetch_all(MYSQLI_ASSOC); $stmt->close(); $conn->close(); ?> Inventory - Dreamscape

Your Inventory

View and manage your purchases

Active Items Show Refunded

No Items Found

Your inventory is empty. Visit our shop to get started with some amazing items!

Visit Shop

Minecraft Username:

Price: $

Purchase Date:

Refund Date: