cant add new item npc

04/09/2018 18:09 Tripple2#1
guys anyone know why i not add item npc ?
anyone trans me ?
[Only registered and activated users can see links. Click Here To Register...]
i try only not work when i add refshopgods
04/09/2018 19:22 Worshiper#2
dont use this program better will made alot of problem in database
04/09/2018 20:00 HECKT0R#3
Which tool you are using to add items for npc? Or you are adding them manually?
04/09/2018 22:35 Tripple2#4
Quote:
Originally Posted by msbmohamed View Post
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

Quote:
Originally Posted by Tripple2 View Post
i using program
only not work with godbless idk why
and not work manually
nobody knows
04/22/2018 00:09 EurS#5
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
04/22/2018 15:54 Tripple2#6
Quote:
Originally Posted by EurS View Post
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
04/22/2018 23:41 EurS#7
Quote:
Originally Posted by Tripple2 View Post
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'
04/23/2018 00:48 Tripple2#8
Quote:
Originally Posted by EurS View Post
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 [Only registered and activated users can see links. Click Here To Register...]
05/06/2018 03:05 mkbyme#9
Quote:
Originally Posted by Tripple2 View Post
YES NOT ANY NPC HAVE [Only registered and activated users can see links. Click Here To Register...]
Coz your query string is wrong, when using "LIKE" to search "keyword" that in name, u must wrap it in % and %
example:
Code:
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.
05/07/2018 18:25 ScarOnline#10
the most problem in godbless :D
check refobjcommon columns CanBuy, CanSell edit them to 1 instead of 0
06/07/2018 16:53 iAmAndrew#11
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