Jump to content
  • 0

How to restock vendors items


Kildaru

Question

Hello, I'm trying to figure out how restock vendors items on our server. I'm very new to coding lingo, so a lot of it is all greek to me. I DL'd a PBO viewer to try and locate a file associated with traders, but to no avail I cannot find a damn thing. If anyone could lend me a hand with a dummies guide of how to refresh the inventory of traders I'd greatly appreciate it.

Link to comment
Share on other sites

20 answers to this question

Recommended Posts

  • 0

the venders stock is located in the database.

 

Im just installing 1.0.1.4 so will let you know for sure soon but it used to be in the traders_data table.

 

You can update the quantity of all of them by running this query

UPDATE epoch.traders_data SET qty = 10 WHERE qty = 0

change the epoch to what ever your database is called. this will update all venders with 0 stock to 10

Link to comment
Share on other sites

  • 0

You just need to run the codes up the top via SQL.

 

1. Enter your Database via the database link in your left hand menu of your CPanel.

2. Click on your Database in the left menu to open the schema.

3. Click SQL up the top of myphpadmin menu.

 

Insert one of the codes below and execute.

 

(To refill empty stock to 10)

UPDATE epoch.traders_data SET qty = 10 WHERE qty =

 

(To refill all stock to 10)

UPDATE epoch.traders_data SET qty = 10 WHERE qty < 10

Link to comment
Share on other sites

  • 0

BUMP we are currently using dayz.st and they don't allow us to enter that code... any body else using dayz.st found a solution,,

If you enter UPDATE epoch.traders_data SET qty = 10 WHERE qty < 10 it means you're updating a table called epoch.traders_data. I don't know about you but my DayzSt database doesn't have that table. The one you want to update is Traders_DATA, exactly like that, case sensitive.

Try this:

UPDATE `Traders_DATA` SET qty=10 WHERE qty<=10;

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
  • Advertisement
  • Discord

×
×
  • Create New...