Save kits and purchases on MySQL

I know how to save all the kits a player bought. But I wonder how to set the selected kit of a player for each minigame. I mean I need to create 6 columns (for 6 minigames), just for the selected kits... isnt there any othet way to do it? And if its the case, should I save the kits on an own kits table?

that's your decision, it's only a question of design. And can't mysql save arrays too?

Well idk

tables(players)
(key),(kits)
(name) , (json string array of kits name)

Sounds good, better than making a column for each game

you could try PHP sterilize but i think json is better

I would use serialize because it can store objects and other stuff. Json only save strings and arrays, also Json saves everything into stdClass while serialize saves the array.

I have found a good way to save it: - with prefix and suffix, I save it like this [TW]EggThrower[TW][OITC]Knockback[OITC].
To get it I will do explode("[OITC]", $kits);

you can decode it into a array FYI like

Code:

 json_decode($json, true) 

You can store them into a string with
[Prefix](name). {repeat}
the dot is use as separator and [Prefix] is used for sorting
you can sort it by [SW] is inside foreach ranks
that is if you rather store things in a string