SQL annoying me.
#1

Hello, I've got my SQL system, but it seems to save the wrong information in the wrong column on the SQL database...

I have:

pawn Код:
stock SaveStats(playerid)
{
    new pname[24];
    GetPlayerName(playerid,pname,24);
    format(SQL_Query,sizeof(SQL_Query),"UPDATE `Accounts` SET `Money` = '%i', `Level` = '%i', `AdminLevel` = '%i', `Faction` = '%i', `FactionRank` = '%i', `RegistrationStep` = '%i', `BirthDay` = '%i', `BirthMonth` = '%i', `BirthYear` = '%i', `SpawnPoint` = '%i', `TutorialComplete` = '%i' WHERE `Username` = '%s'",
    Player[playerid][Money],
    Player[playerid][Level],
    Player[playerid][AdminLevel],
    Player[playerid][Faction],
    Player[playerid][FactionRank],
    Player[playerid][RegistrationStep],
    Player[playerid][BirthDay],
    Player[playerid][BirthMonth],
    Player[playerid][BirthYear],
    Player[playerid][SpawnPoint],
    Player[playerid][TutorialComplete],
    pname);

    mysql_query(SQL_Query);
    mysql_free_result();
    return 1;
}
It just doesn't save the right thing in the right place, what the hell can be wrong?
Reply


Messages In This Thread
SQL annoying me. - by iGetty - 23.05.2012, 08:52
Re: SQL annoying me. - by Pizzy - 23.05.2012, 11:15
Re: SQL annoying me. - by Vince - 23.05.2012, 11:58
Re: SQL annoying me. - by iGetty - 23.05.2012, 11:59
Re: SQL annoying me. - by Pizzy - 23.05.2012, 12:05
Re: SQL annoying me. - by ReneG - 23.05.2012, 12:13
Re: SQL annoying me. - by iGetty - 23.05.2012, 12:43
Re: SQL annoying me. - by Verbal - 23.05.2012, 12:46

Forum Jump:


Users browsing this thread: 2 Guest(s)