[STONEGOLD]

PHP код:

    new playerserial[128];
    new gpcii = gpci(playerid,playerserial,sizeof(playerserial));
    pData[playerid][pGPCI] = gpcii;
            
        format(query, sizeof(query), "UPDATE `players` SET " );
        
        format(tmp, sizeof(tmp), "`GPCI`=%s, ", pData[playerid][pGPCI] );
        strcat(query, tmp); 


not working because of %s. Any idea? i m trying to saving player gpci every last login so it keep updates every time player will quit games

[nickdodd25]

Missing '' in your query string. Change your format line to this...

pawn Код:

format(tmp, sizeof(tmp), "`GPCI`= '%s', ", pData[playerid][pGPCI] );

And it should work now.

[STONEGOLD]

it looks like this here.

[Jefff]

gpci is a string

pawn Код:

new playerserial[50];
gpci(playerid,playerserial,sizeof(playerserial));

// pGPCI in enum should be a string too, pGPCI[50]

pData[playerid][pGPCI] = playerserial;

format(query, sizeof(query), "UPDATE `players` SET `GPCI` = '%s' WHERE something = something", playerserial, some array here);

[STONEGOLD]

Well, I am using stract. any help?

[Stev]

Still the same concept with or without strcat..