[XStormiest]

Код:

forward SaveAccount(playerid);
public SaveAccount(playerid)
{
	new rows;
	cache_get_row_count(rows);
	if(rows >= 1)
	{
	    new string[2048];
	    format(string, sizeof(string), "UPDATE `ptp` SET `Admin` = '%d', `Kills` = '%d', `Deaths` = '%d', `Ratio` = '%f' ,`HoursPlayed` = '%d', `MinutesPlayed` = '%d', `SecondsPlayed` = '%d', `Score` = '%d', `Cash` = '%d' WHERE `username` = '%s'", P_Account[playerid][Admin], P_Account[playerid][Kills], P_Account[playerid][Deaths], P_Account[playerid][Ratio], P_Account[playerid][HoursPlayed], P_Account[playerid][MinutesPlayed], P_Account[playerid][SecondsPlayed], P_Account[playerid][Score], P_Account[playerid][Cash]);
	    
	}
	return 1;
}

[Eoussama]

I use strcat and format in these situations

[BiosMarcel]

U can insert line breaks like this:

PHP код:

format(string, sizeof(string), "UPDATE `ptp` SET `Admin` = '%d', `Kills` = '%d', `Deaths` = '%d', `Ratio`\
 = '%f' ,`HoursPlayed` = '%d', `MinutesPlayed` = '%d', `SecondsPlayed` = '%d', `Score` = '%d', `Cash` =\
  '%d' WHERE `username` = '%s'", P_Account[playerid][Admin], P_Account[playerid][Kills], P_Account[playerid][Deaths],\
   P_Account[playerid][Ratio], P_Account[playerid][HoursPlayed], P_Account[playerid][MinutesPlayed], \
   P_Account[playerid][SecondsPlayed], P_Account[playerid][Score], P_Account[playerid][Cash]); 


[GoldenLion]

Quote:

Originally Posted by [Bios]Marcel U can insert line breaks like this: PHP код: format(string, sizeof(string), "UPDATE `ptp` SET `Admin` = '%d', `Kills` = '%d', `Deaths` = '%d', `Ratio`\  = '%f' ,`HoursPlayed` = '%d', `MinutesPlayed` = '%d', `SecondsPlayed` = '%d', `Score` = '%d', `Cash` =\   '%d' WHERE `username` = '%s'", P_Account[playerid][Admin], P_Account[playerid][Kills], P_Account[playerid][Deaths],\    P_Account[playerid][Ratio], P_Account[playerid][HoursPlayed], P_Account[playerid][MinutesPlayed], \    P_Account[playerid][SecondsPlayed], P_Account[playerid][Score], P_Account[playerid][Cash]);

I'm pretty sure these slashes are not needed.
What you can also do is break the string into pieces like this:

Код:

format(string, sizeof(string), "item1 = 1, item2 = 2);
format(string, sizeof(string), %s, item3 = 3, item4 = 4, string);

[BiosMarcel]

Quote:

Originally Posted by GoldenLion I'm pretty sure these slashes are not needed. What you can also do is break the string into pieces like this: Код: format(string, sizeof(string), "item1 = 1, item2 = 2); format(string, sizeof(string), %s, item3 = 3, item4 = 4, string);

Opinion based ^^ but yeah, that would work, but you shouldnt use format when you could do this:

PHP код:

string = "Test%dTest";
format(string, sizeof(string), string, 5); 


[Vince]

But what you should do is remove stuff that isn't needed. Admin level doesn't change on a constant basis so isn't needed. Ratio is (presumably) kills divided by deaths so isn't needed, sixty seconds is one minute and sixty times sixty seconds is an hour so MinutesPlayed and HoursPlayed aren't needed. That's four out of nine columns that can be eliminated by applying logic.

[oMa37]

or just simply use Zeex's PAWN Compiler.