cant add new item npc

[Tripple2]

guys anyone know why i not add item npc ?
anyone trans me ?

i try only not work when i add refshopgods

[Worshiper]

dont use this program better will made alot of problem in database

[HECKT0R]

Which tool you are using to add items for npc? Or you are adding them manually?

[Tripple2]

Originally Posted by msbmohamed

Which tool you are using to add items for npc? Or you are adding them manually?

i using program
only not work with godbless idk why
and not work manually

Originally Posted by Tripple2

i using program
only not work with godbless idk why
and not work manually

nobody knows

[EurS]

for manually adding use
database:
1- _RefPackageItem
2- _RefPricePolicyOfItem
3- _RefScrapOfPackageItem
4- _RefShopGoods

Client:
1- refpackageitem.txt
2- refpricepolicyofitem.txt
3- refscrapofpackageitem.txt
4 -refshopgoods.txt

[Tripple2]

Originally Posted by EurS

for manually adding use
database:
1- _RefPackageItem
2- _RefPricePolicyOfItem
3- _RefScrapOfPackageItem
4- _RefShopGoods

Client:
1- refpackageitem.txt
2- refpricepolicyofitem.txt
3- refscrapofpackageitem.txt
4 -refshopgoods.txt

bro i know problem only when i add line from _RefShopGoods gameserver close only _RefShopGoods

[EurS]

Originally Posted by Tripple2

bro i know problem only when i add line from _RefShopGoods gameserver close only _RefShopGoods

Be sure there is not an item in the same slot in the same tap of NPC
you can use this query to check
select * FROM _RefShopGoods WHERE RefPackageItemCodeName LIKE 'item code here'

[Tripple2]

Originally Posted by EurS

Be sure there is not an item in the same slot in the same tap of NPC
you can use this query to check
select * FROM _RefShopGoods WHERE RefPackageItemCodeName LIKE 'item code here'

YES NOT ANY NPC HAVE

[mkbyme]

Originally Posted by Tripple2

YES NOT ANY NPC HAVE

Coz your query string is wrong, when using "LIKE" to search "keyword" that in name, u must wrap it in % and %
example:

SELECT * FROM dbo._RefShopGoods WHERE RefPackageItemCodeName LIKE '%ITEM_NURSIS_GODBLESS%'

=>it will show all item, which contain "ITEM_NURSIS_GODBLESS" in
RefPackageItemCodeName

Try again, and show your result here.

[ScarOnline]

the most problem in godbless
check refobjcommon columns CanBuy, CanSell edit them to 1 instead of 0

[iAmAndrew]

you are still a noob xD, the program have 2 sides, one for add the item already existe on SQL with price other for items dosent existe price in SQL yet, also, better to add by yourself cuz the program have alot of bugs good luck