[biker122]

So, I've been working on an achievements system; The problem is the achievements are not being saved into the variables.. BUT THEY DO RETRIEVE THEM. I can see the variables on the mysql log. I even tried printing the the variables on the console, but all of them shown 0.

pawn Код:

stock LoadPlayerAchievements(playerid)
{
    new TQuery[600], shotitname[24], shotid;
    format(TQuery, 600, "SELECT * FROM `"Achievements"` WHERE `Username` = '%s'", GetPName(playerid));
    mysql_query(TQuery), mysql_store_result();
    mysql_fetch_row_format(TQuery);
    for(new i = 0; i <= 15; i++)
    {
        sscanf(TQuery, "e<p<|>is[24]iiiiiiiiiiiiiiii>", shotid, shotitname, PInfo[playerid][Ach][i], PInfo[playerid][AchsCompleted]);
    }
    mysql_free_result(), printf("%s's completed var is %i", GetPName(playerid), PInfo[playerid][AchsCompleted]);
    return 1;
}