How do i edit the database?

[Ephox]

Hey, i want to restock and add things to the traders, but how can i edit the database? I cant add anything new to it it seems.

I want to add building supplies like locks, mortar and the stone thing. lumber packs and all that. Also i want to add an M107 and mag for it at the bandit/hero trader.

[Revoplay]

have you access to the database over Navicat or Phpmyadmin?

[Ephox]

have you access to the database over Navicat or Phpmyadmin?

Yes

[Revoplay]

SQL to update the Stock

UPDATE `traders_data` SET `qty` = 10 WHERE qty = 0;

To add items to the Database you can use Webtools like "Nightmares Private Hive Tools" or look in the wiki for the right Command

[Ephox]

How do i use private hive tools? do i need a webpage? and where can i use commands? im new to servers and know nothing about the database.

[Revoplay]

You need a access to the Database over Navicat or Phpmyadmin. I recommend you to get knowlage over MySQL and Arma Server. A lot of reading but then you know what you do.

Here you found all Informations for adding Items and Maintain your Server: http://dayzepoch.com/wiki/index.php?title=Server_Configuration_Instructions

 

For the Private Hive tools you need a webserver/hoster

[Ephox]

You need a access to the Database over Navicat or Phpmyadmin. I recommend you to get knowlage over MySQL and Arma Server. A lot of reading but then you know what you do.

Here you found all Informations for adding Items and Maintain your Server: http://dayzepoch.com/wiki/index.php?title=Server_Configuration_Instructions

 

For the Private Hive tools you need a webserver/hoster

So i cant use the private hive tools on my computer at home? i really dont want to pay for a webserver

[Revoplay]

If you setup a xamp or wamp or apache Server on you computer, yes

[Revoplay]

Or try Navicat Free and you get a direct acces to your database

[Ephox]

Or try Navicat Free and you get a direct acces to your database

I tried navicat lite but i couldnt edit or add things. And can you post a tutorial for xamp/wamp so i can use it as admin tools on my computer?

[Revoplay]

I dont use xampp or anything else. At google you will find enough Informations

[Ephox]

I dont use xampp or anything else. At google you will find enough Informations

Is that for local servers or can i use it for my verthosting.com dayz epoch server?

[Revoplay]

Gameserverhosting is not the same than webhosting. But you can use it for private hive tools, with is then connected to your database