[ComDuck]

Quote:

Originally Posted by CherryMond What is the best way to store items attached to a player in the mysql database? What should be the columns? This will be working, I think, but if player is using all slots (0-9), will be 10 rows per player, what do you think about this? maybe you have better ways?

I don't think there's any other way.

I don't see any redundant rows, and all your data dependencies make sense (based on https://sampwiki.blast.hk/wiki/SetPlayerAttachedObject). Although, I was thinking of an idea where you can compress each XYZ coordinates into a single line and separate the X, Y and Z float values with a separator character (-, /, etc), but why do all that extra work for your case? I don't even think it's a good idea anyways. What if you only want to modify a single coordinate value only?