Jump to content
  • 0
Sign in to follow this  
Kildaru

How to restock vendors items

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.

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites
  • 0

on Dayz.ST server, put -

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

and get

#1142 - UPDATE command denied to user 'bliss_*****ext'@'69.************1' for table 'traders_data'

as an error. Any Ideas what Im doing o so wrong?

Share this post


Link to post
Share on other sites
  • 0

Seems like your database user has no access rights to the UPDATE command, that was the error says,, you have to ask DayZ.st support why that is, all i know is DayZ.st has many restrictions you can't do youself and have to ask the support all the time...

Share this post


Link to post
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;

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

  • Advertisement
  • Supporters
  • Discord

×
×
  • Create New...