[Melktert]

For some reason, pawncc.exe crashes because of this coding...

Код:

     if(Logged[playerid] == 1)
    {
        //If the player disconnects before registering,
        //we want to make sure it doesn't try update
        //so we check if the player is logged in.
        new score = GetPlayerScore(playerid); //Gets players score
        new money = GetPlayerMoney(playerid); //Gets players money
        new query[200], pname[24]; //Creates the variables
        GetPlayerName(playerid, pname, 24); //Gets the players name.
        format(query, sizeof(query), "UPDATE playerdata SET score=%d, money=%d WHERE user='%s'", score, money, pname);
        mysql_query(query);
        //No need to store a result for a update string

[Antoniohl]

change

Quote:

format(query, sizeof(query), "UPDATE playerdata SET score=%d, money=%d WHERE user='%s'", score, money, pname);

to this

Quote:

format(query, sizeof(query), "UPDATE `playerdata` SET `score` = '%d', `money` = '%d' WHERE `user` = '%s'", score, money, pname);

and make sure to close the brackets

[Melktert]

Still not working, when I comment out those lines, it doesn't crash. But still gives errors (which I will fix)

[Antoniohl]

If you can't fix them post and i will do my best.

[Melktert]

I just uncommented the lines to see if this was the problem, I still need helping fixing these lines, whatever's wrong with them.

[czerwony03]

Show errors, maybe you lost some brackets somewhere?

[introzen]

I'm no MySQL expert but I believe a connectionhandle under mysql_query is necessary.

[czerwony03]

@up
Some plugins don't need connection handle in mysql_query();

[iKevin]

Quote:

Originally Posted by czerwony03 @up Some plugins don't need connection handle in mysql_query();

Most of them do.