[Richie©]

How to save and load colors like this in mysql db?

pawn Код:

#define COLOR_RED 0xAA3333AA

Im making system so i can dynamicly change a team color in game and it saves in TeamInfo in the DB, and ofc loads correctly like the other data.


Loading it from DB:

pawn Код:

cache_get_field_content(i, "Colour", Data),    TeamInfo[teamid][tColour] = Data;

Saving it to DB:

pawn Код:

`Colour` = %x", TeamInfo[teamid][tColour] );

How to do it correct?

And is the Colour field in DB supposed to be varchar?

[Vince]

Treat it like any other normal integer value. The hexadecimal number system is just a way of representation.

[Richie©]

So when setting the colour i can do this?

pawn Код:

TeamInfo[i][tColour] = strval(inputtext);

[Vince]

If you're converting from user input then you're probably better off using sscanf.

[Richie©]

Ok, it worked out fine now. Thanks Vince!

[AiRaLoKa]

should i do this when setting my player's color(not on the /color command but on OnPlayerConnect) ??

pawn Код:

new color;
        color = pInfo[playerid][pColor];
        color <<= 8;
        color |= 0xFF;
        SetPlayerColor(playerid, color);