Item System

Hello Graalians,
I'm actually creating an Item System but I just need your opinion if it's right thought:

So I'll use a database and files storage:

-DATABASE (SQL)
Table: -playerItem: playerAcc, itemId, itemQuantity
-itemInfo : itemId, itemName, itemCategory, itemWeapon, itemPrice

-File:
So each file will be named by the itemId and will contain info depending on the type of the item.
Basics will be item description, item freezetime, item damage....

Is that a good way to do an Item System, how I could do something better?
(I don't want to use clientr variables as some Developer recommended me)

Thanks,
Joe.

i don't understand why you'd need file storage.

If you set up the tables correctly, you should be able to contain all the information you need within them.

Because all items won't be only guns or melee. So parameters would be much different if it's an healer item, a pet, a toy or idk, some params will be different so using tables would require so much tables :/ which doesn't seem good on my view.

Add an extra row for type?

Quote:

---

Originally Posted by John

Add an extra row for type?

---

itemCategory is equal to type :P