Item System

[Joe]

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.

[Torankusu]

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.

[Joe]

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.

[John]

Add an extra row for type?

[Joe]

Add an extra row for type?

itemCategory is equal to type :P