Help Understanding - Printable Version

Help Understanding - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Help Understanding (/showthread.php?tid=329587)

Help Understanding - mikiii18 - 29.03.2012

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.

Re: Help Understanding - Shabi RoxX - 29.03.2012

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

Re: Help Understanding - Vince - 29.03.2012

Both work and both do the same thing.

Re: Help Understanding - mikiii18 - 29.03.2012

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.

Re: Help Understanding - Unte99 - 29.03.2012

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.

Re: Help Understanding - mikiii18 - 29.03.2012

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?

Re: Help Understanding - mikiii18 - 29.03.2012

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?

Re: Help Understanding - mikiii18 - 29.03.2012

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?

Re: Help Understanding - Shabi RoxX - 29.03.2012

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

Re: Help Understanding - mikiii18 - 29.03.2012

Ok, thank's.

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