You cannot purchase the item (M2019)

[I Am NoLimiT]

when i buying some items like avatar's that message pop out.You cannot purchase the item (M2019) 1st.i already remove iscashitem="false" /> or iscashitem="true" /> 2nd.i already remove the serial on database. Should i add items ID on dbo.item on database? SS: http://forum.ragezone.com/images/sty...attach/jpg.gif

[MentaL]

[Anju]

Maybe remove the isCashitem code tag and make sure in your dbo.Item that the isCashitem all equal to 0.

[medotarek]

maybe he didn't add the item id in the db

[I Am NoLimiT]

yah i think so..anyone have queries for items?.that i can execute on db?

[Anju]

Manually add them into your dbo.Item.

[I Am NoLimiT]

Thanks Sir Anju i will try that :) after i get my vps hacked.because i use Tannous release i got hacked.i never thought Tannous website release has many backdoors..

[Developer]

Yep, looks like you have the same issue i did about 6 days ago. Simply search through your zItem/Shop.xml and look through your database for what is NOT there. It will show in Shop because its in the zItem and Shop.xml's but you cannot buy it if its not in your DB :)

Lol, If ANYONE needs help, i'm currently in the process of Making my Own Server, and i'v encountered many Issues that i have Solved.
I havent been all that active due to me liking to figure stuff out for myself.

If anyone needs help, add my skype, i'm on almost 24/7

Skype: ShinobiStory

(No thats not the name of my server. Just my Skype =P Old game i scrapped. Just so u kno i'm NOT advertising anything Lol)

[I Am NoLimiT]

can you share your dbo.item queries?

Sir Anju why is that i cant add more lines on dbo.item?.can you tell me whats the problem the last Line ID on my dbo.item is 5000002 and after that im trying to add DessertWarrior Avatar for Female ID: 29009 but after when i executing give me some error on MSSQL.

[Anju]

It's possible that it is not showing the full list in your dbo.Item database table. Since I am using MSSQL 2012, it is only showing me the top 200 listing. I'm not quite sure how to get it to show the entire listing of the database table. The last line that you're seeing now could be just the last line of the top 200 listings. It's possible that the ItemID that you're trying to add is already added.

[wesman2232]

It's possible that it is not showing the full list in your dbo.Item database table. Since I am using MSSQL 2012, it is only showing me the top 200 listing. I'm not quite sure how to get it to show the entire listing of the database table. The last line that you're seeing now could be just the last line of the top 200 listings. It's possible that the ItemID that you're trying to add is already added.

Use Select Top 1000 Rows to show the full listings. (I know for sure the default DB doesn't go over 1000 items)
He would have to use some SQL to edit a row from there. Adding a whole new row should still work from Editing the Top 200.

[I Am NoLimiT]

problem fixed..i just remove the serial key on mssql2k5.