Problem! Adding avatar to custom NPC

07/01/2014 20:18 gofik123#1
I been trying to add death assassin avatar to the custom NPC i made from kira and statiics guide. It is all fine in database just when i run client it crashes when i add refshopgoods.txt :mad: I am using statiic DB btw. I tried everything added as silk item, gold price. I spent like 3-4 days on this just for 1 avatar i want the pain to be over. All database side works fine client doesn't.

RefPackageItem
Code:
1	15	86444	PACKAGE_ITEM_MALL_AVATAR_M_DAY_DEATHASSASSIN_HAT	0	EXPAND_TERM_ALL	SN_ITEM_MALL_AVATAR_M_DAY_DEATHASSASSIN_HAT	SN_ITEM_MALL_AVATAR_M_DAY_DEATHASSASSIN_HAT_TT_DESC	item\Avatar\mall_avatar_m_day_deathassassin_hat.ddj	-1	XXX	-1	xxx	-1	xxx	-1	xxx
1	15	86445	PACKAGE_ITEM_MALL_AVATAR_W_DAY_DEATHASSASSIN_HAT	0	EXPAND_TERM_ALL	SN_ITEM_MALL_AVATAR_W_DAY_DEATHASSASSIN_HAT	SN_ITEM_MALL_AVATAR_W_DAY_DEATHASSASSIN_HAT_TT_DESC	item\Avatar\mall_avatar_w_day_deathassassin_hat.ddj	-1	XXX	-1	xxx	-1	xxx	-1	xxx
1	15	86446	PACKAGE_ITEM_MALL_AVATAR_M_DAY_DEATHASSASSIN	0	EXPAND_TERM_ALL	SN_ITEM_MALL_AVATAR_M_DAY_DEATHASSASSIN	SN_ITEM_MALL_AVATAR_M_DAY_DEATHASSASSIN_TT_DESC	item\Avatar\mall_avatar_m_day_deathassassin.ddj	-1	XXX	-1	xxx	-1	xxx	-1	xxx
1	15	86447	PACKAGE_ITEM_MALL_AVATAR_W_DAY_DEATHASSASSIN	0	EXPAND_TERM_ALL	SN_ITEM_MALL_AVATAR_W_DAY_DEATHASSASSIN	SN_ITEM_MALL_AVATAR_W_DAY_DEATHASSASSIN_TT_DESC	item\Avatar\mall_avatar_w_day_deathassassin.ddj	-1	XXX	-1	xxx	-1	xxx	-1	xxx
1	15	86448	PACKAGE_ITEM_MALL_AVATAR_M_DEATHASSASSIN_ATTACH	0	EXPAND_TERM_ALL	SN_ITEM_MALL_AVATAR_M_DEATHASSASSIN_ATTACH	SN_ITEM_MALL_AVATAR_M_DEATHASSASSIN_ATTACH_TT_DESC	item\Avatar\mall_avatar_m_day_deathassassin_attach.ddj	-1	XXX	-1	xxx	-1	xxx	-1	xxx
1	15	86449	PACKAGE_ITEM_MALL_AVATAR_W_DEATHASSASSIN_ATTACH	0	EXPAND_TERM_ALL	SN_ITEM_MALL_AVATAR_W_DEATHASSASSIN_ATTACH	SN_ITEM_MALL_AVATAR_W_DEATHASSASSIN_ATTACH_TT_DESC	item\Avatar\mall_avatar_w_day_deathassassin_attach.ddj	-1	XXX	-1	xxx	-1	xxx	-1	xxx
RefPricePolicyOfItem
Code:
1	15	PACKAGE_ITEM_MALL_AVATAR_M_DAY_DEATHASSASSIN_HAT	1	0	1	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	PACKAGE_ITEM_MALL_AVATAR_W_DAY_DEATHASSASSIN_HAT	1	0	1	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	PACKAGE_ITEM_MALL_AVATAR_M_DAY_DEATHASSASSIN	1	0	1	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	PACKAGE_ITEM_MALL_AVATAR_W_DAY_DEATHASSASSIN	1	0	1	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	PACKAGE_ITEM_MALL_AVATAR_M_DEATHASSASSIN_ATTACH	1	0	1	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	PACKAGE_ITEM_MALL_AVATAR_W_DEATHASSASSIN_ATTACH	1	0	1	-1	xxx	-1	xxx	-1	xxx	-1	xxx
RefScrapPackageofItem

Code:
1	15	PACKAGE_ITEM_MALL_AVATAR_M_DAY_DEATHASSASSIN_HAT	ITEM_MALL_AVATAR_M_DAY_DEATHASSASSIN_HAT	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx	88957
1	15	PACKAGE_ITEM_MALL_AVATAR_W_DAY_DEATHASSASSIN_HAT	ITEM_MALL_AVATAR_W_DAY_DEATHASSASSIN_HAT	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx	88958
1	15	PACKAGE_ITEM_MALL_AVATAR_M_DAY_DEATHASSASSIN	ITEM_MALL_AVATAR_M_DAY_DEATHASSASSIN	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx	88959
1	15	PACKAGE_ITEM_MALL_AVATAR_W_DAY_DEATHASSASSIN	ITEM_MALL_AVATAR_W_DAY_DEATHASSASSIN	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx	88960
1	15	PACKAGE_ITEM_MALL_AVATAR_M_DEATHASSASSIN_ATTACH	ITEM_MALL_AVATAR_M_DEATHASSASSIN_ATTACH	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx	88961
1	15	PACKAGE_ITEM_MALL_AVATAR_W_DEATHASSASSIN_ATTACH	ITEM_MALL_AVATAR_W_DEATHASSASSIN_ATTACH	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx	88962
RefShopGoods

Code:
1	15	STORE_ITEMMALL_TAB2	PACKAGE_ITEM_MALL_AVATAR_M_DAY_DEATHASSASSIN_HAT	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	STORE_ITEMMALL_TAB2	PACKAGE_ITEM_MALL_AVATAR_W_DAY_DEATHASSASSIN_HAT	1	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	STORE_ITEMMALL_TAB1	PACKAGE_ITEM_MALL_AVATAR_M_DAY_DEATHASSASSIN	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	STORE_ITEMMALL_TAB1	PACKAGE_ITEM_MALL_AVATAR_W_DAY_DEATHASSASSIN	1	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	STORE_ITEMMALL_TAB3	PACKAGE_ITEM_MALL_AVATAR_M_DEATHASSASSIN_ATTACH	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	STORE_ITEMMALL_TAB3	PACKAGE_ITEM_MALL_AVATAR_W_DEATHASSASSIN_ATTACH	1	-1	xxx	-1	xxx	-1	xxx	-1	xxx
07/01/2014 22:52 SkillsGoPewPew#2
Make sure that the NPC,tabgroups and tabs(including mappings) are all in the client.check if you don't have duplicates IDs in ScrapofPackageItem,PackageItem or other items on the same slots of those tabs.
Also check if the items are present in the itemdata.
if you are still having problems post the following files or send them to me in a PM
refmappingshopgroup.txt
refmappingshopwithtab.txt
refpackageitem.txt
refpricepolicyofitem.txt
refshop.txt
refscrapofpackageitem.txt
refshopgroup.txt
refshopgoods.txt
refshoptab.txt
refshoptabgroup.txt
+ the itemdata and characterdata where the items and npc are located

Always here to help.
07/01/2014 23:55 gofik123#3
I will check it all after breakfast!!

Edit/

NPCPos.txt is that where i was suppose to put the NPC location from Tab_RefNest?

Edit/

I will try send it to you i give up i made a notepad on what i put database side. I uploaded the files and linked you with scan etc in PM. Thank you for your time :)

Quote:
This should do it:

You have duplicate tab IDs in refshoptab
Change them in both client and database
only the client crashes from that issue, the server doesn't check for duplicate IDs in _RefShopTab because the table was originally designed with a constraint
oXo™ Thank you for solving my problem i will leave the solution here for people that have this kind of problem once again thank you for your help +1 for oXo
07/02/2014 13:35 SkillsGoPewPew#4
No problem, if there is something to help anyone with i'd be glad to do it.

#Reuqesting close, problem fixed.