DataBase Edit, need help!

12/14/2016 21:02 mrpaion223#1
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? :)
12/14/2016 21:58 NoIdeaForAName#2
Use the NPC tool to edit and add stuff you desire.
12/14/2016 23:25 mrpaion223#3
Quote:
Originally Posted by NoIdeaForAName View Post
Use the NPC tool to edit and add stuff you desire.
Can you recommend, with what NPC tool, i can do this? :)

Quote:
Originally Posted by NoIdeaForAName View Post
Use the NPC tool to edit and add stuff you desire.
[Only registered and activated users can see links. Click Here To Register...] in this site, with this NPC Tool i cant add coin's, dont find
12/15/2016 05:44 EdwardTeach+-#4
Hi, mrpain223,
when you looking for something not exists in "RefPackageItem",
you have to use this form
[Only registered and activated users can see links. Click Here To Register...]
12/15/2016 09:05 mrpaion223#5
Quote:
Originally Posted by EdwardTeach+- View Post
Hi, mrpain223,
when you looking for something not exists in "RefPackageItem",
you have to use this form
[Only registered and activated users can see links. Click Here To Register...]
but i get this error [Only registered and activated users can see links. Click Here To Register...] when try add
12/15/2016 10:33 leo2111#6
Quote:
Originally Posted by mrpaion223 View Post
but i get this error [Only registered and activated users can see links. Click Here To Register...] 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!
12/19/2016 09:15 MrCatGardens#7
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.
12/20/2016 09:11 sro_cyklon#8
[Only registered and activated users can see links. Click Here To Register...]