Epoch traders help

Run this in your database:
Code:
UPDATE `traders_data` SET qty=10 WHERE `item` LIKE '%ItemVault%' AND qty=0;

Make sure traders_data is the same capitalization as your table, and change ItemVault to the item classname that needs more stock.
 
Or you can check the stock manually by this simple way:

Open your trader data table.

Click on upper side " search" button

On the right culumn of Qty line just write 0 and presse execute.
It will open all the list of item with stock quantity on 0

Then modify each of them by adding the stock you wanting.
 
Or you can check the stock manually by this simple way:

Open your trader data table.

Click on upper side " search" button

On the right culumn of Qty line just write 0 and presse execute.
It will open all the list of item with stock quantity on 0

Then modify each of them by adding the stock you wanting.

are there anyways to add new item into the trader?
 
Sure.

- 1 : You have to found wich trader you want to add the item ( each trader v got a trader ID, with this trader ID u can found wich TIDs is used for him)

- 2 : Add the item to the trader item table ( with the right group and afile)

- 3 : Add this new item to the trader data table with the price, quantity, etc and with the right TIDs

restart your server and it will be done

( The most difficulty is to found the right TIDs for the trader you want)
 
Sure.

- 1 : You have to found wich trader you want to add the item ( each trader v got a trader ID, with this trader ID u can found wich TIDs is used for him)

- 2 : Add the item to the trader item table ( with the right group and afile)

- 3 : Add this new item to the trader data table with the price, quantity, etc and with the right TIDs

restart your server and it will be done

( The most difficulty is to found the right TIDs for the trader you want)


thanks for replying however i have no idea how to do this. could you go slowly from what am i suppose to click? im pretty new to editing database :(
 
Ok, here we go...

1:
In your mission.pbo, open the server_trader.sqf.
In this file you v got a list of all your trader.
Found the one you want to add item ( for this exemple we will take the:

// Friendly Vehicles
menu_Profiteer4 = [
[["Bikes and ATV",608],["Buses and Vans",563],["Cargo Trucks",564],["Fuel Trucks",492],["Military Unarmed",491],["Trucks",495],["Used Cars",585],["Utility Vehicles",565]],
[],
"friendly"
];

)
It's supposed to be the Klem trader selling vehicules
Now we will add a vehicules to the Military Unarmed categories. This categories v got the TIDs 491 (["Military Unarmed",491]") Keep in mind this numbers 491

2: Open your database and go to your "trader item" table.
Once you are in this item trader table click on " Insert" on top of the page.
It will open a new age where you will add the item...
Now on this new window add this: ( only on the second collumn, leave the first collumn blank...)

ID : let this one blank
Classname : M1133_MEV_EP1
Type : 2
Group : Military Unarmed
afile: trade_any_vehicle

and then click execute... Give it some secondes to execute it this step is done...

3: Open your trader's data table and click on insert ( top of page)

ID : leave it blank
item : ["M1133_MEV_EP1",2]
qty : 30
buy : [1,"ItemGoldBar10oz",1]
sell : [3,"ItemGoldBar10oz",1]
order : 0
tid : 491
afile : trade_any_vehicle

and then execute.

4: restart your server and go to your Klem vehicule trader you should found in unarmed vehicle this new vehicles...
 
Ok, here we go...

1:
In your mission.pbo, open the server_trader.sqf.
In this file you v got a list of all your trader.
Found the one you want to add item ( for this exemple we will take the:

// Friendly Vehicles
menu_Profiteer4 = [
[["Bikes and ATV",608],["Buses and Vans",563],["Cargo Trucks",564],["Fuel Trucks",492],["Military Unarmed",491],["Trucks",495],["Used Cars",585],["Utility Vehicles",565]],
[],
"friendly"
];

)
It's supposed to be the Klem trader selling vehicules
Now we will add a vehicules to the Military Unarmed categories. This categories v got the TIDs 491 (["Military Unarmed",491]") Keep in mind this numbers 491

2: Open your database and go to your "trader item" table.
Once you are in this item trader table click on " Insert" on top of the page.
It will open a new age where you will add the item...
Now on this new window add this: ( only on the second collumn, leave the first collumn blank...)

ID : let this one blank
Classname : M1133_MEV_EP1
Type : 2
Group : Military Unarmed
afile: trade_any_vehicle

and then click execute... Give it some secondes to execute it this step is done...

3: Open your trader's data table and click on insert ( top of page)

ID : leave it blank
item : ["M1133_MEV_EP1",2]
qty : 30
buy : [1,"ItemGoldBar10oz",1]
sell : [3,"ItemGoldBar10oz",1]
order : 0
tid : 491
afile : trade_any_vehicle

and then execute.

4: restart your server and go to your Klem vehicule trader you should found in unarmed vehicle this new vehicles...


you are one of the nicest person i've met. this really helps me alot. one last thing. below i have highlighted some of the words. could you describe to me what does it represent?



ID : let this one blank
Classname : M1133_MEV_EP1
Type : 2
Group : Military Unarmed
afile: trade_any_vehicle

ID : leave it blank
item : ["M1133_MEV_EP1",2]
qty : 30
buy : [1,"ItemGoldBar10oz",1]
sell : [3,"ItemGoldBar10oz",1]
order : 0
tid : 491
afile : trade_any_vehicle
 
Type :

1 = ammo, pasta, coke etc
2 = Vehicles
3 = weapon

Each item v got a type number, if u use for exempe a vehicle classname witth the wrong type number it will not spawn correctly...

Afile : you v got some different afile like, trade_any_vehicle / trade_items / trade_weapons
Again each item v got his own afile, a vehicle must be added with the trade_any_vehicles afile or it will not spawn correctly..

Order : i dont really know for what it s used ( but i herd it's something like the % for trader to sell or buy this item) anyway i never settled it other than 0
 
Type :

1 = ammo, pasta, coke etc
2 = Vehicles
3 = weapon

Each item v got a type number, if u use for exempe a vehicle classname witth the wrong type number it will not spawn correctly...

Afile : you v got some different afile like, trade_any_vehicle / trade_items / trade_weapons
Again each item v got his own afile, a vehicle must be added with the trade_any_vehicles afile or it will not spawn correctly..

Order : i dont really know for what it s used ( but i herd it's something like the % for trader to sell or buy this item) anyway i never settled it other than 0



Ah thanks
How about this sir?
item : ["M1133_MEV_EP1",2]

What does the number 2 represent?
 
Back
Top