07.02.2013, 02:16
Something like this should work.
pawn Код:
new string[512];
new fstring[512];
string = "UPDATE Users\n SET Password='%s',Admin=%d,Money=%d,Skin=%d,Armor=%f,Health=%f,Xpos=%f,Ypos=%f,Zpos=%f,Apos=%f,";
strcat(string, "Interior=%d, VWorld=%d WHERE Name='%s'");
format(fstring, sizeof(fstring), string,
UserStats[playerid][Password], UserStats[playerid][Admin], UserStats[playerid][Money],
UserStats[playerid][Skin], UserStats[playerid][Armor], UserStats[playerid][Health],
UserStats[playerid][Xpos], UserStats[playerid][Ypos], UserStats[playerid][Zpos],
UserStats[playerid][Apos], UserStats[playerid][Interior],
UserStats[playerid][World], UserStats[playerid][Name]
);
mysql_query(fstring);
