Posts: 734
Threads: 8
Joined: Jun 2009
Quote:
Originally Posted by FireCat
Like it's setting everyone's column the same, the column "TrashMasterMissions"
pawn Код:
static gQuery[60]; format(gQuery,sizeof gQuery,"UPDATE `Accounts` SET `TrashMasterMissions` = '%i' WHERE `ID` = '%i' LIMIT 1;",PInfo[playerid][TrashMasterMissions],PInfo[playerid][ID]); mysql_query(gQuery);
|
For starters the syntax is wrong, I mean, drop the ' around integer values, '' are used to enclose strings, just use %i, or %d. Then print the ID to see if there's anything wrong that might set the same values for every user.
Oh and, stop using static keyword for mysql queries, use new to declare a new variable.