search

nuclearsilo583 / zephyrus-store-preview-new-syntax

My rewritten zephyrus store
61 stars 40 forks source link

Fixed item expiration SQL queries, part 3 #163

Closed azalty closed 1 year ago

azalty commented 1 year ago

Fixed SQLite query not working at all (wtf did I do)

Important fix on the MySQL query, that was basically deleting an item from ALL PLAYERS' INVENTORIES when a single item from someone was expired and equipped

✅ Compiles fine ✅ Works fine for SQLite - untested on MySQL

azalty commented 1 year ago

Bug: m_szQuery buffer too small, TODO: increase size

Currently have things to do IRL so I'll do that in a few hours

azalty commented 1 year ago

Seems to be working for SQLite. Untested on MySQL

azalty commented 1 year ago

@strteamservidores ^

I think this PR can be merged, testing from someone using MySQL might be useful though

nuclearsilo583 commented 1 year ago

thanks

strteamservidores commented 1 year ago

@strteamservidores ^

I think this PR can be merged, testing from someone using MySQL might be useful though

I will test, thanks!