[mikiii18]

Hello.

I've download that script:

Код:

stock carregarPlayer(playerid)
{
        //Carregar
    if(mysql_fetch_row(Query))
        {
        sscanf(Query, "e<p<|>s[24]s[35]ddddfffddddd>", PlayerInfo[playerid]);
                mysql_free_result();
        }
    //Fim
    SendClientMessage(playerid, -1, "------------------------------------------------");
    SendClientMessage(playerid, 0xEEEEEEAA, "Versгo: MySQL 0.3");
    SendClientMessage(playerid, 0xEEEEEEAA, "Criador: Ricop522");
    SendClientMessage(playerid, -1, "------------------------------------------------");
    SetSpawnInfo(playerid, 0, PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pPosX], PlayerInfo[playerid][pPosY], PlayerInfo[playerid][pPosZ], 1.0, 0, 0, 0, 0, 0, 0);
        SetPlayerSkin(playerid, PlayerInfo[playerid][pSkin]);
    SpawnPlayer(playerid);
    if(PlayerInfo[playerid][pTut] == 0)
    {
        SendClientMessage(playerid, -1, "Tutorial nгo iniciado !");
    }
    return 1;
}

Well, I can't understand why in "sscanf(Query, "e<p<|>s[24]s[35]ddddfffddddd>", PlayerInfo[playerid]);", he used "e<p<|>" instead of "p<|>"


Help please.

[Shabi RoxX]

No way , I think he did it wrong... Current way is

pawn Код:

sscanf(Query, "p<|>e<s[24]s[35]ddddfffddddd>", PlayerInfo[playerid]);//format p<|> and this e<> goes for enum

[Vince]

Both work and both do the same thing.

[mikiii18]

Right.

Help please:

Quote:

Originally Posted by mikiii18 Hello. For loading player data, I'm using this: Код: mysql_real_escape_string(inputtext, EscPass); format(Query, sizeof(Query), "SELECT * FROM `playerinfo` WHERE `user` = '%s' AND `password` = md5('%s')", pName(playerid), EscPass); mysql_query(Query); mysql_store_result(); stock savePlayer(playerid) { if(mysql_fetch_row(Query)) { sscanf(Query, "p<|>e<s[32]dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddfffddddffddddddddddddddddddddddddddddddddddddddddddddddddds[32]ds[32]ds[32]ds[32]ds[32]dddddddddddddddddddddddddddddd>", PlayerInfo[playerid]); mysql_free_result(); } } That is pretty useful because I don't need to write all the playerinfo variables, it includes all.. How can I do something simillar to save player data? Thank's.

[Unte99]

e stands for an enumerator.

pawn Код:

enum PlayerInfo
{
    Pass,
    Admin,
    Money,
    .....
}

So when you write an "e" in the parameters section, it will load the whole enumerator, starting from the top to bottom.

Or in other script:

pawn Код:

PlayerInfo=Pass,Admin,Money... // Instead of writing lots of words, you just write the name of the enumerator and you are done.

[mikiii18]

How can I do something simillar to save player data?

How can I do something simillar to save player data?

How can I do something simillar to save player data?

How can I do something simillar to save player data?

[mikiii18]

How can I do something like that:

Код:

stock savePlayer(playerid)
{
    	if(mysql_fetch_row(Query))
        {
 			 	sscanf(Query, "p<|>e<s[32]dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddfffddddffddddddddddddddddddddddddddddddddddddddddddddddddds[32]ds[32]ds[32]ds[32]ds[32]dddddddddddddddddddddddddddddd>", PlayerInfo[playerid]);
                mysql_free_result();
        }
}

But for save player data?

[mikiii18]

How can I do something like that:

Код:

stock savePlayer(playerid)
{
    	if(mysql_fetch_row(Query))
        {
 			 	sscanf(Query, "p<|>e<s[32]dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddfffddddffddddddddddddddddddddddddddddddddddddddddddddddddds[32]ds[32]ds[32]ds[32]ds[32]dddddddddddddddddddddddddddddd>", PlayerInfo[playerid]);
                mysql_free_result();
        }
}

But for save player data?

[Shabi RoxX]

you cant , use mysql_query to UPDATE table, see mysql tutorial for more detail..

[mikiii18]

Ok, thank's.


That's just because PlayerInfo have more than 2 hundred variables, and I'll need to write them all.. Wont I?