Bug with compilation
#1

Hi

I have a problem when I compile my script.
The compiler loads but never after that compiles and unresponsive.
And if I remove "adrenaline =% d", the compilation's going very well.
I do not understand or can come of this, the mysql plugin can be a size limit requests?

pawn Код:
forward UpdateAccount(playerid);
public UpdateAccount(playerid)
{
    F(query, sizeof(query), "UPDATE `accounts` SET pseudo='%s', ip='%s', mail='%s', sexe=%d, age=%d, origine='%s', argent=%d, banque=%d, cb=%d, skin=%d, score=%d, respect=%d, respectmax=%d, world=%d, interieur=%d, vie='%f', armure='%f', tuto=%d, prochExp=%d, job=%d, tempsJob=%d, tempsIg=%d, admin=%d, jail=%d, jailAdmin='%s', jailRaison='%s', avertissements=%d, telephone=%d, telephoneStatus=%d, telephoneCredits=%d,"\
    "clefP=%d, clefP2=%d, clefP3=%d, plaque='%s', weed=%d, coke=%d, adrenaline=%d WHERE pseudo='%s'",
    PlayerName(playerid),
    playerInfo[playerid][ip],
    playerInfo[playerid][mail],
    playerInfo[playerid][sexe],
    playerInfo[playerid][age],
    playerInfo[playerid][origine],
    playerInfo[playerid][argent],
    playerInfo[playerid][banque],
    playerInfo[playerid][cb],
    playerInfo[playerid][skin],
    playerInfo[playerid][score],
    playerInfo[playerid][respect],
    playerInfo[playerid][respectmax],
    playerInfo[playerid][world],
    playerInfo[playerid][interieur],
    playerInfo[playerid][vie],
    playerInfo[playerid][armure],
    playerInfo[playerid][tuto],
    playerInfo[playerid][prochExp],
    playerInfo[playerid][job],
    playerInfo[playerid][tempsJob],
    playerInfo[playerid][tempsIg],
    playerInfo[playerid][admin],
    playerInfo[playerid][jail],
    playerInfo[playerid][jailAdmin],
    playerInfo[playerid][jailRaison],
    playerInfo[playerid][avertissements],
    playerInfo[playerid][telephone],
    playerInfo[playerid][telephoneStatus],
    playerInfo[playerid][telephoneCredits],
    clefP[playerid][0],
    clefP[playerid][1],
    clefP[playerid][2],
    playerInfo[playerid][plaque],
    playerInfo[playerid][weed],
    playerInfo[playerid][coke],
    playerInfo[playerid][adrenaline],
    playerInfo[playerid][pseudo]);
    mysql_query(query);
    return printf("Compte %d - %s mis а jour", playerInfo[playerid][id], PlayerName(playerid));
}
Reply
#2

I had the same problem a while back, I just done this. INstead of having one huge Query,

Split everything into two querys, for example

FIrst query you will have from IP - Job and the rest you would have in a second query from Job to the bottom.

If I understood your question properly this is what worked for me when my pawno crashed while attempting to understad a large query
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)