01.11.2018, 16:15
Here's an example from my script:
You've got a lot of MYSQL tutorials around the forums, they can and should help you. If you still need help, don't hesitate.
pawn Code:
SavePlayer(playerid)
{
new query[1024];
mysql_format(Database, query, sizeof(query), "UPDATE `users` SET `Cash` = '%d', `Kills` = '%d', `Deaths` = '%d', `PosX` = '%f', `PosY` = '%f', `PosZ` = '%f', `Angle` = '%f', `Health` = '%f', `Armor` = '%f' WHERE `ID` = '%d'",
PlayerInfo[playerid][Cash], PlayerInfo[playerid][Kills], PlayerInfo[playerid][Deaths],
PlayerInfo[playerid][PosX], PlayerInfo[playerid][PosY], PlayerInfo[playerid][PosZ], PlayerInfo[playerid][Angle],
PlayerInfo[playerid][Health], PlayerInfo[playerid][Armor], PlayerInfo[playerid][ID]);
mysql_query(Database, query);
return 1;
}

