Jump to content
  • 0

Add items to traders.


Tricks

Question

2 answers to this question

Recommended Posts

  • 0

When it comes to databases I admit I am a noob.

 

So make sure you have a safe backup and beware that if you try this it is at your own risk.

 

If you imported all the SQL files from the epoch server files you should have an event called updateStockDaily.  at a quick glance it looks like this

UPDATE `Traders_DATA` SET qty=10 WHERE qty=0 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat'

if you modify it to look like this it MIGHT WORK... and I Stress MIGHT as it is untested.

UPDATE `Traders_DATA` SET qty=1000 WHERE qty<100 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat'

I would think this should update stock to 1000 if it is less then 100 daily, but I highly recommend Backup before you try this.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Discord

×
×
  • Create New...