SQL query

[kito2]

Hi, can someone give me a query that:
- search on z_shop_history_item the account of who bought "x" item (offer_id value) and add "y" points to the acount of the player who bought "x" item.

x,y should be values that I should set.

Can someone help?

 

[Cykotitan]

SELECT from_account FROM z_shop_history_item WHERE offer_id = x

UPDATE accounts SET premium_points = premium_points + y WHERE id IN (SELECT from_account FROM z_shop_history_item WHERE offer_id = x)

 

[kito2]

Thanks, but how to make them work at same time?

 

[Cykotitan]

Thanks, but how to make them work at same time?

Use the 2nd one, if it even works.

 

[kito2]

Thanks man love ya!