R7 Formats Not Showing Values:
#1

Код:
strcat(MySQL, "UPDATE users SET Score='%d', Money='%d', Admin='%d', Team='%d', BankBalance='%d',");
strcat(MySQL, "JailedMins='%d', JailedSecs='%d', WantedLevel='%d', BetaTesting='%d',");
strcat(MySQL, "Fishnet='%d', FishPermit='%d', On‌Drugs='%d', DrugAmount='%d',");
strcat(MySQL, "PoliceRank='%d', TempArrests='%0.1f', Crime='%s' WHERE Username='%s'");
    
mysql_format(MySQLConnection, MySQL2, MySQL, GetPlayerScore(playerid), PMoney[playerid], UserInfo[playerid][Admin], UserInfo[playerid][Team], UserInfo[playerid][BankBalance],
UserInfo[playerid][JailedMins], UserInfo[playerid][JailedSecs],	UserInfo[playerid][WantedLevel], UserInfo[playerid][BetaTesting], UserInfo[playerid][FishNet],
UserInfo[playerid][FishPermit], UserInfo[playerid][OnDrugs], UserInfo[playerid][DrugAmount], UserInfo[playerid][PoliceRank],UserInfo[playerid][CopWorkArrest],
CrimeString, UserInfo[playerid][Name]);


mysql_function_query(MySQLConnection, MySQL2, false, "NoThreadResult", "i", INVALID_PLAYER_ID);
This is the outcome but it prints the values fine but apart from the last three it's shown as:

TempArrests='%0.1f', Crime='%s' WHERE Username='%s')

Insted of numbers / Strings.

If you want the full print debug of the query click here: http://pastebin.com/sJDyGxy8

Thank you.
Reply


Messages In This Thread
R7 Formats Not Showing Values: - by Kyle - 11.06.2012, 22:43
Re: R7 Formats Not Showing Values: - by Kar - 11.06.2012, 23:13
Re: R7 Formats Not Showing Values: - by JernejL - 12.06.2012, 08:52
Re: R7 Formats Not Showing Values: - by Blacklite - 12.06.2012, 09:43
Re: R7 Formats Not Showing Values: - by AndreT - 12.06.2012, 12:08
Re: R7 Formats Not Showing Values: - by Blacklite - 12.06.2012, 20:07

Forum Jump:


Users browsing this thread: 2 Guest(s)