09.02.2013, 21:12
This is my current code, I thought adding that = and putting name at the end fixed it but I guess not. I don't know what went wrong. Some help on this would really help, I've changed some stuff around as you can see. Also the first line is working but the second line isn't. (Working as in saving admin, money etc. but not working as in not saving interior,vworld, etc.)
pawn Код:
new string[500];
format(string, sizeof(string), "UPDATE Users SET Password='%s',Admin='%d',Money='%d',Skin='%d',Armor='%f',Health='%f',Xpos='%f',Ypos='%f',Zpos='%f',Apos='%f' WHERE Name='%s'", 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][Name]);
mysql_query(string);
format(string, sizeof(string), "UPDATE Users SET Interior='%d',VWorld='%d',Color='%s',FirstSpawn'%d' WHERE Name='%s'", UserStats[playerid][Interior], UserStats[playerid][VWorld], UserStats[playerid][Color], UserStats[playerid][FirstSpawn], UserStats[playerid][Name]);
mysql_query(string);

