[xX_Simon_Xx]

I do a system to save only the objects attached to the player that I would save all the 9 fields of '"SetPlayerAttachedObject" in one field of mysql instead of create 9.
Else is needed to use sscanf, but I do not understand how to use it to split a string.

well now I have made ​​the function to insert values ​​in database

PHP код:

stock SavePlayerObject(playerid, index, modelid, boneid, Float:fOffsetX, Float:fOffsetY, Float:fOffsetZ, Float:fRotX, Float:fRotY, Float:fRotZ, Float:fScaleX, Float:fScaleY, Float:fScaleZ)
{
    new string[500];
    switch(index)
    {
        case SLOT_TESTA:
        {
            format(string,sizeof(string),"%d,%d,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f",modelid, boneid, Float:fOffsetX, Float:fOffsetY, Float:fOffsetZ, Float:fRotX, Float:fRotY, Float:fRotZ, Float:fScaleX, Float:fScaleY, Float:fScaleZ);
            MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "OggettoTesta",string);
        }
        case SLOT_BOCCA:
        {
            format(string,sizeof(string),"%d,%d,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f",modelid, boneid, Float:fOffsetX, Float:fOffsetY, Float:fOffsetZ, Float:fRotX, Float:fRotY, Float:fRotZ, Float:fScaleX, Float:fScaleY, Float:fScaleZ);
            MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "OggettoBocca",string);
        }
        case SLOT_OCCHI:
        {
            format(string,sizeof(string),"%d,%d,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f",modelid, boneid, Float:fOffsetX, Float:fOffsetY, Float:fOffsetZ, Float:fRotX, Float:fRotY, Float:fRotZ, Float:fScaleX, Float:fScaleY, Float:fScaleZ);
            MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "OggettoOcchi",string);
        }
    }
} 


PHP код:

stock LoadPlayerObject(playerid)
{
    new index, modelid, boneid, Float:fOffsetX, Float:fOffsetY, Float:fOffsetZ, Float:fRotX, Float:fRotY, Float:fRotZ, Float:fScaleX, Float:fScaleY, Float:fScaleZ;
    //the string with all values it's PlayerInfo[playerid][pOggTesta]
    SetPlayerAttachedObject(playerid, index, modelid, boneid, Float:fOffsetX, Float:fOffsetY, Float:fOffsetZ, Float:fRotX, Float:fRotY, Float:fRotZ, Float:fScaleX, Float:fScaleY, Float:fScaleZ);
} 


I do not know how to separate the various fields separated by a comma and assign to each variable and mostly how to convert the string into a numeric variable

[SuperViper]

Use

pawn Код:

mysql_fetch_row(variableName);

after storing the result after your select and then

pawn Код:

sscanf(variableName, "p<|>ddfffffffff", all variables here, variable2, variable3, etc);

[xX_Simon_Xx]

Quote:

Originally Posted by SuperViper pawn Код: sscanf(variableName, "p<|>ddfffffffff", all variables here, variable2, variable3, etc);

i change <|> to <,> right ?

[SuperViper]

Nope, when you use

pawn Код:

mysql_fetch_row();

it seperates all of the columns with a '|'.

[xX_Simon_Xx]

Quote:

Originally Posted by SuperViper Nope, when you use pawn Код: mysql_fetch_row(); it seperates all of the columns with a '|'.

no you didn't understand

"PlayerInfo[playerid][pOggTesta]" already contains all variable in form of string because i've already set it whit all other PlayerInfo variables

Now for exemple PlayerInfo[playerid][pOggTesta] contains this string "1,1345,6,0.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00, 1.00"

how do I separate the string??

[SuperViper]

In that case, yes, change it to p<,>.

[xX_Simon_Xx]

ok tanks works fine

[xX_Simon_Xx]

sorry for double post but i test and will wont work i try this

PHP код:

stock LoadPlayerObject(playerid)
{
    new modelid, boneid, Float:fOffsetX, Float:fOffsetY, Float:fOffsetZ, Float:fRotX, Float:fRotY, Float:fRotZ, Float:fScaleX, Float:fScaleY, Float:fScaleZ;
    sscanf(PlayerInfo[playerid][pOggTesta], "p<,>ddfffffffff",modelid,boneid,fOffsetX,fOffsetY,fOffsetZ,fRotX,fRotY,fRotZ,fScaleX,fScaleY,fScaleZ);
    if(modelid != -1)
    {
        new string[60];
        SetPlayerAttachedObject(playerid, SLOT_TESTA, modelid, boneid, fOffsetX, fOffsetY, fOffsetZ, fRotX, fRotY, fRotZ, fScaleX, fScaleY, fScaleZ);
        format(string,sizeof(string),"%d,%d,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f",modelid,boneid,fOffsetX,fOffsetY,fOffsetZ,fRotX,fRotY,fRotZ,fScaleX,fScaleY,fScaleZ);
        SendClientMessage(playerid,COLOR_WHITE,string);
    }
    sscanf(PlayerInfo[playerid][pOggBocca], "p<,>ddfffffffff",modelid,boneid,fOffsetX,fOffsetY,fOffsetZ,fRotX,fRotY,fRotZ,fScaleX,fScaleY,fScaleZ);
    if(modelid != -1)
    {
        new string[60];
        SetPlayerAttachedObject(playerid, SLOT_BOCCA, modelid, boneid, fOffsetX, fOffsetY, fOffsetZ, fRotX, fRotY, fRotZ, fScaleX, fScaleY, fScaleZ);
        format(string,sizeof(string),"%d,%d,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f",modelid,boneid,fOffsetX,fOffsetY,fOffsetZ,fRotX,fRotY,fRotZ,fScaleX,fScaleY,fScaleZ);
        SendClientMessage(playerid,COLOR_WHITE,string);
    }
    sscanf(PlayerInfo[playerid][pOggOcchi], "p<,>ddfffffffff", modelid,boneid,fOffsetX,fOffsetY,fOffsetZ,fRotX,fRotY,fRotZ,fScaleX,fScaleY,fScaleZ);
    if(modelid != -1)
    {
        new string[60];
        SetPlayerAttachedObject(playerid, SLOT_OCCHI, modelid, boneid, fOffsetX, fOffsetY, fOffsetZ, fRotX, fRotY, fRotZ, fScaleX, fScaleY, fScaleZ);
        format(string,sizeof(string),"%d,%d,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f,%.2f",modelid,boneid,fOffsetX,fOffsetY,fOffsetZ,fRotX,fRotY,fRotZ,fScaleX,fScaleY,fScaleZ);
        SendClientMessage(playerid,COLOR_WHITE,string);
    }
} 


And in Game it return

PHP код:

[19:37:06] 0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00
[19:37:06] 0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00
[19:37:06] 0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00 


The values isn't setted to variables D: why??