[maikons]

Base: (compiling-no erros)

pawn Код:

stock MySQL_SAVE(playerid)
{
    new query[128];
    new Float:x, Float:y, Float:z;
    GetPlayerPos(playerid, x, y, z);
    mysql_format(g_Write, query, sizeof(query), "UPDATE accounts SET PosX = %f, PosY = %f, PosZ = %f WHERE UserID = %d", x, y, z, pInfo[playerid][UserID]);
    mysql_pquery(g_Write, query);
    return 1;
}

Right above code compiling without errors,
But when I put my replaces the line here under \/

pawn Код:

mysql_format(g_Write, query, sizeof(query), "UPDATE accounts SET Username = %s, Senha = %s, IP = %s, scorelevel = %d, maconha = %d, sementes = %d, BPsize = %d, wanted = %d, moneybag = %d, COPskills = %d, CRIMINALskills = %d, PARAMEDICskills = %d, admin = %d, money = %d, bank = %d, kills = %d, deaths = %d, DP = %d, VIP = %d, fmembro = %d, fcargo = %d, preso = %d, presotime = %d, startVIPdia = %d, startVIPmes = %d, startVIPano = %d, carid = %d, carpos0 = %f, carpos1 = %f, carpos2 = %f, carpos3 = %f, spawnpoint = %d, housekey = %d, idiom = %d, tutorial = %d, banned = %d, leftBANdia = %d, leftBANmes = %d, leftBANano = %d WHERE UserID = %d", PlayerName(playerid), Senha[playerid], IP[playerid], scorelevel[playerid], maconha[playerid], sementes[playerid], BPsize[playerid], wanted[playerid], moneybag[playerid], COPskills[playerid], CRIMINALskills[playerid], PARAMEDICskills[playerid], admin[playerid], money[playerid], bank[playerid], kills[playerid], deaths[playerid], DP[playerid], VIP[playerid], fmembro[playerid], fcargo[playerid], preso[playerid], presotime[playerid], startVIPdia[playerid], startVIPmes[playerid], startVIPano[playerid], carid[playerid], carpos[playerid][0], carpos[playerid][1], carpos[playerid][2], carpos[playerid][3], spawnpoint[playerid], housekey[playerid], idiom[playerid], tutorial[playerid], banned[playerid], leftBANdia[playerid], leftBANmes[playerid], leftBANano[playerid] , pInfo[playerid][UserID]);

pawn Код:

error 075: input line too long (after substitutions)
error 037: invalid string (possibly non-terminated string)
error 017: undefined symbol "UPDATE"
error 017: undefined symbol "accounts"
 fatal error 107: too many error messages on one line

It seems that the text was too big someone can share it to me in Syntactic sure if that?
And tell me 'cause it happens?

[JeaSon]

there is a limit use strcat

pawn Код:

new query[540]; // query should a bit big
format(query, sizeof(query),"");
strcat(query,"UPDATE accounts SET Username = %s, Senha = %s, IP = %s, scorelevel = %d, maconha = %d, sementes = %d, BPsize = %d, wanted = %d, moneybag = %d, COPskills = %d,");
strcat(query,"%s CRIMINALskills = %d, PARAMEDICskills = %d, admin = %d, money = %d, bank = %d, kills = %d, deaths = %d, DP = %d, VIP = %d, fmembro = %d, fcargo = %d, preso = %d, presotime = %d, startVIPdia = %d, startVIPmes = %d,");
strcat(query,"%s startVIPano = %d, carid = %d, carpos0 = %f, carpos1 = %f, carpos2 = %f, carpos3 = %f, spawnpoint = %d, housekey = %d, idiom = %d, tutorial = %d, banned = %d, leftBANdia = %d, leftBANmes = %d, leftBANano = %d WHERE UserID = %d");
mysql_format(g_Write, query, sizeof(query),PlayerName(playerid),Senha[playerid], IP[playerid], scorelevel[playerid], maconha[playerid], sementes[playerid], BPsize[playerid], wanted[playerid], moneybag[playerid], COPskills[playerid], CRIMINALskills[playerid], PARAMEDICskills[playerid], admin[playerid], money[playerid], bank[playerid], kills[playerid], deaths[playerid], DP[playerid], VIP[playerid], fmembro[playerid], fcargo[playerid], preso[playerid], presotime[playerid], startVIPdia[playerid], startVIPmes[playerid], startVIPano[playerid], carid[playerid], carpos[playerid][0], carpos[playerid][1], carpos[playerid][2], carpos[playerid][3], spawnpoint[playerid], housekey[playerid], idiom[playerid], tutorial[playerid], banned[playerid], leftBANdia[playerid],leftBANmes[playerid], leftBANano[playerid] , pInfo[playerid][UserID]);

[maikons]

error 075: input line too long (after substitutions)

pawn Код:

strcat(query,"%s startVIPano = %d, carid = %d, carpos0 = %f, carpos1 = %f, carpos2 = %f, carpos3 = %f, spawnpoint = %d, housekey = %d, idiom = %d, tutorial = %d, banned = %d, leftBANdia = %d, leftBANmes = %d, leftBANano = %d WHERE UserID = %d");

rep[Namer] += 1;

[maikons]

I use

pawn Код:

new query[1024];
format(query, sizeof(query), "UPDATE accounts SET Username = '%s', Senha = '%s', IP = '%s', scorelevel = %d, maconha = %d, sementes = %d, BPsize = %d, wanted = %d, moneybag = %d, COPskills = %d, CRIMINALskills = %d, PARAMEDICskills = %d, admin = %d, money = %d, bank = %d, kills = %d, deaths = %d, ",
    PlayerName(playerid), Senha[playerid], IP[playerid], scorelevel[playerid], maconha[playerid], sementes[playerid], BPsize[playerid], wanted[playerid], moneybag[playerid], COPskills[playerid], CRIMINALskills[playerid], PARAMEDICskills[playerid], admin[playerid], money[playerid], bank[playerid], kills[playerid], deaths[playerid]);
format(query, sizeof(query), "%sDP = %d, VIP = %d, fmembro = %d, fcargo = %d, preso = %d, presotime = %d, startVIPdia = %d, startVIPmes = %d, startVIPano = %d, carid = %d, carpos0 = %f, carpos1 = %f, carpos2 = %f, carpos3 = %f, spawnpoint = %d, housekey = %d, idiom = %d, tutorial = %d, banned = %d, leftBANdia = %d, leftBANmes = %d, leftBANano = %d WHERE UserID = %d",
    query, DP[playerid], VIP[playerid], fmembro[playerid], fcargo[playerid], preso[playerid], presotime[playerid], startVIPdia[playerid], startVIPmes[playerid], startVIPano[playerid], carid[playerid], carpos[playerid][0], carpos[playerid][1], carpos[playerid][2], carpos[playerid][3], spawnpoint[playerid], housekey[playerid], idiom[playerid], tutorial[playerid], banned[playerid], leftBANdia[playerid], leftBANmes[playerid], leftBANano[playerid] , pInfo[playerid][UserID]);
mysql_pquery(g_Write, query);

Good?

[maikons]

edited