About Items And Set Avatar

[gabrielranks]

hello people

I have a ploblema with items of 1.5 gunz can buy some item and some can not set more talks to buy some items that I can not make the purchase and what do

Source Sahar

[MentaL]

[Anju]

Just remove the isCashitem="true" or isCashitem="false" completely from the zitem listing for those that you want removed. Or maybe remove the foreign key from your dbo.Item database table.

[I Am NoLimiT]

is that the fixed sir anju?.cause i have that problem also when i try to buy avatar's and sniper's i use sahar's source.

[gabrielranks]

I already removed the key from the database and the only ones dbo.Item cashitem = true are the items in the staff zitem

i use source sahar too

[I Am NoLimiT]

the zitem is located inside your system.mrs and the copy is in your server/matchserver/zitem.xml.Just do what Sir Anju said.remove it completely..dont just change true to false..remove the line iscashitem="false" /> or iscashitem="true" />

[gabrielranks]

dont work

<ITEM id="29001" name="STR:ZITEM_NAME_29001" type="avatar" slot="avatar" avatar_head="eq_head_polarhunter"
avatar_chest="eq_chest_polarhunter" avatar_hand="eq_hands_polarhunter" avatar_legs="eq_legs_polarhunter" avatar_feet="eq_feet_polarhunter"
res_sex="m" res_level="0" bt_price="0" weight="0" desc="STR:ZITEM_DESC_29001" />

no cash item put in system and match and not work

[I Am NoLimiT]

did you remove the foreign key from your dbo.Item database table.?

[gabrielranks]

yes i remove the key in dbo.item database

[Anju]

MD5 problem then?

[I Am NoLimiT]

i think sir anju its db problem.we haven't add yet some items on dbo.item we nee queries to execute on db.or just add it manually,.

Sir Anju can you share your dbo.item script?.can you make backup?.

[Anju]

My dbo.Item doesn't have foreign key enabled. Also my files work fine with or without the foreign key.

[I Am NoLimiT]

i think we have the same problem with gabriel we just forgot to execute the items on dbo.item mannually.

[sahar042]

Put bounty to your character, Remove forgein keys, Exeute this:
UPDATE Item SET IsCashItem = 0
use the server files i released, don't use your own files.