Updating Traders.

[GhostTown]

So I have this SQL Event.

 

UPDATE `traders_data` SET qty=200 WHERE qty=0 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat'

 

How would I reword that to anything below lets say 20? Gets restocked to 200. I know if I just change 0 to 20 it will only restock stuff that is at 20 nothing below it.

Unless im wrong about that.

 

Also how would I change that to a function that I can run when needed?

[RipSaw]

UPDATE `traders_data` SET qty=200 WHERE qty<20 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat'

Does the trick for me

[RipSaw]

UPDATE `traders_data` SET qty=200 WHERE qty<20 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat'

Does the trick for me

Stupid double posting on my phone

[Radec59437]

UPDATE `Traders_DATA` SET qty=200 WHERE  qty<20

I'm not sure what you mean with "run when needed", you mean on a schedule or manually?

[GhostTown]

Awesome thanks for the reply!

 

I have a auto schedule setup.

But I wanted to create a function for what ever reason a trader is empty I can do it.