SaveAccount taking too long time
#3

What The Hell is that, you make a query to save one variable while you can save all of them with just one query

Here is a correct usage (Not made by me)

Код:
SaveData(playerid)
{
	new query[2500];
	format(query, sizeof(query), "UPDATE `accounts` SET");
	format(query, sizeof(query), "%s `score` = '%d',", query, Data[playerid][Score]);
	format(query, sizeof(query), "%s `kills` = '%d',", query, Data[playerid][Kills]);
	format(query, sizeof(query), "%s `deaths` = '%d',", query, Data[playerid][Deaths]);
	format(query, sizeof(query), "%s `money` = '%d',", query, Data[playerid][Money]);

	mysql_format(connection, query, sizeof(query), "%s", query);
	mysql_query(connection, query, false);
	return 1;
}
Reply


Messages In This Thread
SaveAccount taking too long time - by Terrorizt - 12.02.2016, 15:31
Re: SaveAccount taking too long time - by Morpheine - 12.02.2016, 15:45
Re: SaveAccount taking too long time - by SecretBoss - 12.02.2016, 15:53
Re: SaveAccount taking too long time - by Vince - 12.02.2016, 16:08
Re: SaveAccount taking too long time - by Terrorizt - 12.02.2016, 16:51
Re: SaveAccount taking too long time - by Terrorizt - 12.02.2016, 16:58
Re: SaveAccount taking too long time - by AmigaBlizzard - 12.02.2016, 20:51
Re: SaveAccount taking too long time - by Sew_Sumi - 12.02.2016, 22:32
Re: SaveAccount taking too long time - by Tamer - 12.02.2016, 22:51
Re: SaveAccount taking too long time - by Sew_Sumi - 14.02.2016, 21:29
Re: SaveAccount taking too long time - by Tamer - 15.02.2016, 18:46
Re: SaveAccount taking too long time - by AmigaBlizzard - 16.02.2016, 07:58

Forum Jump:


Users browsing this thread: 1 Guest(s)