08.10.2011, 16:03
Looking at that line:
The error is easy to spot. You're missing the variable for HeadValue (after PlayerInfo[playerid][pPayCheck] and before PlayerInfo[playerid][pJailed]). That's why the query is invalid.
A good way to keep track of query errors (and this query _will_ produce one) is through the debug files both MySQL plugins have the option for.
Also, even if just for testing - why something as pointless as that? And 19 queries? Are you kidding me...
pawn Код:
format(query, sizeof(query), "UPDATE utilisateurs SET BiggestFish=%d, Job=%d, PayCheck=%d, HeadValue=%d, Jailed=%d, JailTime=%d, Materials=%d WHERE Pseudo='%s'", PlayerInfo[playerid][pBiggestFish], PlayerInfo[playerid][pJob], PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pMats], PlayerInfo[playerid][pMatsf], pName);
A good way to keep track of query errors (and this query _will_ produce one) is through the debug files both MySQL plugins have the option for.
Also, even if just for testing - why something as pointless as that? And 19 queries? Are you kidding me...