Sort auctions by most sold

2 files changed, 4 insertions, 3 deletions

diff --git a/src/database.ts b/src/database.ts
index 2392332..d0ad04b 100644
--- a/src/database.ts
+++ b/src/database.ts
@@ -1142,14 +1142,14 @@ function toItemAuctionsSchemaBson(i: ItemAuctionsSchema): ItemAuctionsSchemaBson
 export async function fetchItemsAuctions(itemIds: string[]): Promise<ItemAuctionsSchema[]> {
 	const auctions = await itemAuctionsCollection?.find({
 		_id: { $in: itemIds }
-	}).toArray()
+	}).sort('oldestDate', -1).toArray()
 	return auctions.map(toItemAuctionsSchema)
 }
 
 
 /** Fetch all the Item Auctions for the item ids in the given array. */
 export async function fetchPaginatedItemsAuctions(skip: number, limit: number): Promise<ItemAuctionsSchema[]> {
-	const auctions = await itemAuctionsCollection?.find({}).skip(skip).limit(limit).toArray()
+	const auctions = await itemAuctionsCollection?.find({}).sort('oldestDate', -1).skip(skip).limit(limit).toArray()
 	return auctions.map(toItemAuctionsSchema)
 }
 
@@ -1165,6 +1165,7 @@ export async function updateItemAuction(auction: ItemAuctionsSchema) {
 export async function fetchItemsAuctionsIds(): Promise<string[] | undefined> {
 	if (!itemAuctionsCollection) return undefined
 	const docs = await itemAuctionsCollection?.aggregate([
+		{ $sort: { oldestDate: -1 } },
 		// this removes everything except the _id
 		{ $project: { _id: true } }
 	]).toArray()
diff --git a/src/hypixel.ts b/src/hypixel.ts
index a29a7b1..2e0c1bc 100644
--- a/src/hypixel.ts
+++ b/src/hypixel.ts
@@ -500,7 +500,7 @@ async function fetchAuctionItemsUncached() {
 	// if the item in the database isn't in the items api, just set the name to the id
 	for (const item of auctionItemIds)
 		if (!idsToNames.has(item))
-			idsToNames.set(item, item)
+			idsToNames.set(item, item.toLowerCase().replace(/^./, item[0].toUpperCase()).replace(/_/g, ' '))
 	return idsToNames
 }