MySQL Saving
#4

pawn Код:
stock SavePlayerCharacters(playerid)
{
    if(Logged[playerid] == 1)
    {
        new query[200];
        format(query, sizeof(query), "UPDATE Accounts SET Character1='%s', Character2='%s', Character3='%s', Character4='%s', Character5='%s', Adminlevel=%i WHERE Username='%s'", \
        CharacterInfo[playerid][0], CharacterInfo[playerid][1], CharacterInfo[playerid][2], CharacterInfo[playerid][3], CharacterInfo[playerid][4], pInfo[playerid][Username]);
        mysql_query(query);
    }
    return 1;
}
You need to put single quotes around the string specifier, so it would look like the code above ('%s' not %s)
Reply


Messages In This Thread
MySQL Saving - by Kindred - 04.07.2012, 08:02
Re: MySQL Saving - by Vince - 04.07.2012, 10:08
Re: MySQL Saving - by Kindred - 04.07.2012, 22:22
Re: MySQL Saving - by Tee - 04.07.2012, 22:26
Re: MySQL Saving - by Kindred - 04.07.2012, 22:33
Re: MySQL Saving - by Tee - 04.07.2012, 22:34
Re: MySQL Saving - by Kindred - 04.07.2012, 22:38
Re: MySQL Saving - by FUNExtreme - 04.07.2012, 22:43
Re: MySQL Saving - by Tee - 04.07.2012, 22:43
Re: MySQL Saving - by FUNExtreme - 04.07.2012, 22:54

Forum Jump:


Users browsing this thread: 1 Guest(s)