MySQL position saving and loading
#1

Well, i have an problem.
pawn Код:
public OnPlayerDisconnect(playerid, reason)
{
    if(Logged[playerid] == 1)
    {
        new mangutunde = GetPlayerScore(playerid);
        new raha = GetPlayerMoney(playerid);
        new Float:x, Float:y, Float:z, query[200], pname[24];
        GetPlayerName(playerid, pname, 24);
        GetPlayerPos(playerid, x, y, z);
        format(query, sizeof(query), "UPDATE playerinfo SET mangutunde=%d AND raha=%d AND `x`= '%f' AND `y`= '%f' AND `z`= '%f' WHERE kasutaja='%s'", mangutunde, raha, x, y, z, pname);
        mysql_query(query);

    }
    return 1;
}
This code wont save x,y and z. Can somebody help me?

http://www.upload.ee/image/1843317/lolololo.PNG this is at the phpmyadmin.
Reply


Messages In This Thread
MySQL position saving and loading - by vent - 27.11.2011, 12:30
Re: MySQL position saving and loading - by vardanega - 27.11.2011, 12:55
Re: MySQL position saving and loading - by KaleOtter - 27.11.2011, 12:56
Re: MySQL position saving and loading - by vent - 27.11.2011, 12:58
Re: MySQL position saving and loading - by KaleOtter - 27.11.2011, 14:30
Re: MySQL position saving and loading - by vent - 27.11.2011, 15:45

Forum Jump:


Users browsing this thread: 2 Guest(s)