Commit graph

2 commits

Author SHA1 Message Date
Zach Toogood
ca3bdd22fe [SQL] Add COLLATE=utf8mb4_general_ci to all tables 2024-01-04 18:25:12 +00:00
Corey Sotiropoulos
1cda207af6 Make AH results retail accurate
Track which items have been listed on the AH using a new protected table
and trigger. Only show these items in the AH by default. This is controlled
by the `search.OMIT_NO_HISTORY` setting and is now on by default.

Run the following query to populate the new table using your existing
auction house history:
```
INSERT IGNORE INTO auction_house_items(itemid)
SELECT itemid FROM auction_house
GROUP BY itemid;
```
2023-08-13 20:32:25 -04:00