nuclearsilo583 / zephyrus-store-preview-new-syntax

My rewritten zephyrus store
61 stars 40 forks source link

Fixed item expiration SQL queries, part 2 #161

Closed azalty closed 1 year ago

azalty commented 1 year ago

I previously broke item expiration SQL queries for MySQL, and fixed it for SQLite (see #147), due to me being dumb and not knowing the MySQL syntax (or MySQL not being powerful enough :D).

Thanks to @cleber1337 - @strteamservidores for reporting this issue and making a PR (#160) that essentially reverted my changes 😆

This should fix the problem for both MySQL and SQLite drivers. Sorry PostgreSQL, no one likes you.

This should also improve the code a bit (by removing the duplicate DB_HouseKeeping code). Let's hope nothing breaks this time!

❌ Didn't try to compile ❌ Didn't test in game

strteamservidores commented 1 year ago

seems to work fine!