Failed service queries still deduct currency.

[AnchyDev]

When creating a service query on the store, if your query fails for whatever reason (no rows affected for example) your currency is still deducted.

It would be nice if query was verified first to see if it affected any rows or failed before deducting the currency and checking out.
You can replicate this issue by:

• Create a new store item with the Query item type.
• Write a query that you know will not affect any rows and save.
• Use the store and observe it still takes your money.

[CraftedRO]

yea I can confirm, it only check if realm is online and if it is on it will execute the query (even if is wrong) and take your currency then it will appear: Your order has been processed.

Anyway we need also a fix for the other case when the query is correct it seems it will execute it but after you checkout the spinner remain stuck spinning without announcement with your order status (even if it has been executed already) so you have to force refresh the page.

[Err0r1]

In my opinion, you don't need a check for that
if you can't write or test a query properly, you shouldn't use the query option anyway

I don't see a bug here either
As far as I know there is no safe way to get the affected rows

I played around a lot with "$this->db->affected_rows()" because of my modules and it often shows 0, even though the query was executed

But the whole store needs an update in my opinion

[CraftedRO]

yea agree, but still we need a fix for the case when query is correct and spinner remain stuck without notice you the final status of the order like

[Err0r1]

Can you explain it?
Do you mean if the query fails?

[CraftedRO]

2023-05-27.21-57-07.mp4

[Err0r1]

Is there an error in the log file or browser console?
As far as i know, query also shows a success message

[CraftedRO]

well I got only

ERROR - 2023-05-27 21:15:17 --> Invalid query: (nothing here)

but as you can see in video is really valid

you can try too my cms query:

UPDATE account_data SET avatar=1 WHERE id={ACCOUNT};

[Err0r1]

Can you try it without ";" ?

[CraftedRO]

well ok now worked without ";" kinda strange but usually you need an end to any query 😀

[AnchyDev]

In my opinion, you don't need a check for that if you can't write or test a query properly, you shouldn't use the query option anyway

I don't see a bug here either As far as I know there is no safe way to get the affected rows

I played around a lot with "$this->db->affected_rows()" because of my modules and it often shows 0, even though the query was executed

But the whole store needs an update in my opinion

Sorry, I didn't explain the issues we are having enough I guess and maybe this should be a feature request.

We need to run a query to detect if the player should be able to use the service based on other parameters, so sometimes the query will change 0 rows because they don't meet the requirements.
Maybe having another query box where we can write a select statement and if it returns no rows then the store will tell the player they are not eligible for this service?

If a similar feature exists already it would be greatly appreciated if pointed out. Thanks.