UpdatePlayerData query problem
#3

So you suggest me to reset player variables after the registration?

However did in this way:

pawn Код:
UpdatePlayerData(playerid)
{
    if (Player[playerid][IsLoggedIn] == false) return 0;

    new query[145];
    mysql_format(g_SQL, query, sizeof query, "UPDATE `players` SET `Kills` = %d, SET `Deaths` = %d, SET `Score` = %d, SET `Money` = %d, SET `Level` = %d, SET `Cookies` = %d, SET `Warns` = %d WHERE `id` = %d LIMIT 1",
    Player[playerid][Kills],
    Player[playerid][Deaths],
    Player[playerid][Score]),
    Player[playerid][Money],
    Player[playerid][Level],
    Player[playerid][Cookies],
    Player[playerid][Warns],
    Player[playerid][ID]),
    mysql_tquery(g_SQL, query);
    return 1;
}
Still the same..
Reply


Messages In This Thread
UpdatePlayerData query problem - by Face9000 - 18.03.2017, 20:39
Re: UpdatePlayerData query problem - by Konstantinos - 18.03.2017, 20:55
Re: UpdatePlayerData query problem - by Face9000 - 18.03.2017, 21:02
Re: UpdatePlayerData query problem - by iLearner - 18.03.2017, 21:02
Re: UpdatePlayerData query problem - by iLearner - 18.03.2017, 21:04
Re: UpdatePlayerData query problem - by Face9000 - 18.03.2017, 21:14
Re: UpdatePlayerData query problem - by iLearner - 18.03.2017, 21:18
Re: UpdatePlayerData query problem - by Face9000 - 18.03.2017, 21:42
Re: UpdatePlayerData query problem - by iLearner - 18.03.2017, 21:50
Re: UpdatePlayerData query problem - by Face9000 - 18.03.2017, 21:53

Forum Jump:


Users browsing this thread: 2 Guest(s)