How to restock vendors items

[Kildaru]

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.

[Achmed]

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

[Bungle]

This would work also?

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

[Achmed]

Pass as i just copy and paste but i see no reason why it wouldnt

[flashi]

For me it is also a problem with me are no items displayed since the update from 1.0.1.1. to 1.0.1.4.

 

http://dayzepoch.com/forum/index.php?/topic/550-dayz-epoch-1014-trader-problem/

[Achmed]

I have just replied to your post. Its different as yours is not a stock issue

[AngelOfDizeaze]

we are doing through dayzst servers...and no clue where on the database control panel to do any of this lol

[Bungle]

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 = 0 

 

(To refill all stock to 10)

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

[Tankschaf]

I´d love to have it automatically restocked with every serverrestart - how does that work?

[BetterDeadThanZed]

I´d love to have it automatically restocked with every serverrestart - how does that work?

 

Just going to bump an old topic as I'm interested in this as well.

[Achmed]

When you put events in the database you cab set how oftern they run, just set it to run 1 min before or after a restart

[BetterDeadThanZed]

When you put events in the database you cab set how oftern they run, just set it to run 1 min before or after a restart

 

How do you put events in the database?

[BetterDeadThanZed]

Anyone? How do you put events in the database?

[Gimmic]

BetterDeadThanZed:

http://dayzepoch.com/wiki/index.php?title=Server_Installation_Instructions_Extended

[havock]

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?

[Axe Cop]

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...

[havock]

You the man axe, thank you again! I'll shoot them a line tomorrow!

[KItnO]

Simply take the Epoch out of the code. For eg

 

UPDATE traders_data SET qty = 10 WHERE qty < 10

 

Kit

[penultimate]

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,,

[BetterDeadThanZed]

Did you ask dayz.st's support?

[Jutka]

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;