[Matheus28]

Well, I have several "Unlocks", each one with an id string.
They all have only two states: unlocked (true) or locked (false).

What would be the best way to store a client unlocks in the database?
Generating a keyvalue string?
Making a simple text parser? (aaaa=1;bbbb=0;cccc=1;)

[r00tage]

Well, what I would say is if you are intending to do unlockables like RPG, you would implement it like this.

table name | field (int usually) -------------------------------------------- icestab | [5000] points allocated jump | [3000] points allocated

Then in your code, you just read the value of field and do an if else statement.

if (jumpxp > 2000)
//Player is level 2
else if(jumpxp > 1000)
//Player is level 1
else
//Level 0 how lame

Otherwise, a nifty boolean table would probably be enough for 1 time unlockables.

[Sammy-ROCK!]

Why not bit flags?

#define Unlock1 (1<<0) //1
#define Unlock2 (1<<1) //2
#define Unlock3 (1<<2) //4

new flags = 0;

flags |= Unlock1; //Adds Unlock1 flag
flags &= ~Unlock1; //Removes Unlock1 flag

new bool:HasUnlock1 = flags & Unlock1;

This way you have a simple interger and the limit is 32 (1<<31) and if you need more you can always make a 2nd integer.

[Matheus28]

Originally Posted by Sammy-ROCK! Why not bit flags? #define Unlock1 (1<<0) //1 #define Unlock2 (1<<1) //2 #define Unlock3 (1<<2) //4 new flags = 0; flags |= Unlock1; //Adds Unlock1 flag flags &= ~Unlock1; //Removes Unlock1 flag new bool:HasUnlock1 = flags & Unlock1; This way you have a simple interger and the limit is 32 (1<<31) and if you need more you can always make a 2nd integer.

Because I wanna support more than 200 unlocks, and I don't know how much I'll need to support, so I can't rely on it.

Also, unlocks aren't based on an exp level, the user chooses which one he wants to buy, he can buy more than one.

I am inclined to use the simple text parsing

[Matheus28]

Okay, I did it using a "simple text parser".

I just exploded the string on the ";" and then on the "=".

[FaTony]

You can store unlocks in a file or MySQL as very large bitstring.