Help MySQL
#10

Here's an example from my script:

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;
}
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.
Reply


Messages In This Thread
Help MySQL - by KamilPolska - 01.11.2018, 12:55
Re: Help MySQL - by TheToretto - 01.11.2018, 13:13
Re: Help MySQL - by KamilPolska - 01.11.2018, 13:33
Re: Help MySQL - by TheToretto - 01.11.2018, 13:49
Re: Help MySQL - by KamilPolska - 01.11.2018, 13:51
Re: Help MySQL - by Heress - 01.11.2018, 14:16
Re: Help MySQL - by KamilPolska - 01.11.2018, 15:07
Re: Help MySQL - by TheToretto - 01.11.2018, 15:39
Re: Help MySQL - by KamilPolska - 01.11.2018, 15:48
Re: Help MySQL - by TheToretto - 01.11.2018, 16:15
Re: Help MySQL - by KamilPolska - 01.11.2018, 16:43
Re: Help MySQL - by TheToretto - 01.11.2018, 16:50
Re: Help MySQL - by KamilPolska - 01.11.2018, 17:11
Re: Help MySQL - by KinderClans - 01.11.2018, 17:20
Re: Help MySQL - by KamilPolska - 01.11.2018, 17:28
Re: Help MySQL - by TheToretto - 01.11.2018, 17:35
Re: Help MySQL - by KamilPolska - 01.11.2018, 18:13
Re: Help MySQL - by TheToretto - 01.11.2018, 19:18
Re: Help MySQL - by KamilPolska - 01.11.2018, 20:29
Re: Help MySQL - by TheToretto - 01.11.2018, 20:56
Re: Help MySQL - by KamilPolska - 01.11.2018, 21:07

Forum Jump:


Users browsing this thread: 1 Guest(s)