DataBase Edit, need help!

[mrpaion223]

Hello, i need help, how to add in server Copper, Iron, Plate and Gold Coins can be bought at Hotan Potion Merchant. 1 Copper Coin = 1Mgold | 1 Iron = 2 Copper | 1 Plate = 2 Iron | 1 Gold = 2 Plate. You need Coins in order to buy SOM, SON and SUN items System?

[NoIdeaForAName]

Use the NPC tool to edit and add stuff you desire.

[mrpaion223]

Originally Posted by NoIdeaForAName

Use the NPC tool to edit and add stuff you desire.

Can you recommend, with what NPC tool, i can do this?

Originally Posted by NoIdeaForAName

Use the NPC tool to edit and add stuff you desire.

in this site, with this NPC Tool i cant add coin's, dont find

[EdwardTeach+-]

Hi, mrpain223,
when you looking for something not exists in "RefPackageItem",
you have to use this form

[mrpaion223]

Originally Posted by EdwardTeach+-

Hi, mrpain223,
when you looking for something not exists in "RefPackageItem",
you have to use this form

but i get this error when try add

[leo2111]

Originally Posted by mrpaion223

but i get this error when try add

I had that error too , in the past.
You have to do the next steps :
1. Go to _RefScrapOfPackageItem and add the items manually , because the tool stopped at _RefScrapOfPackageItem, cound't continue the process due some errors.
2. Make a full backup of your database and then open the tool and go to ->EDIT SQL.
3. Click on START EDITING and wait for the end of the process.
4. Try again to add items into any npc and this time I'm sure you won't get any error.
Cheers!

[MrCatGardens]

very simple way:
add a new package and refpackageitem
add this package to the desired npc at refshopgoods
add your package to refscrapofpackageitems
set your package-price at refpricepolicyofitems

do the same at media.pk2

done.

[sro_cyklon]