Mysql saving won't work
#8

Maybe now:
pawn Код:
stock SavePlayer(playerid)
{
    new pname[24], query[600];
    GetPlayerName(playerid, pname, 24);
    GetPlayerPos(playerid, PlayerInfo[playerid][pPosX], PlayerInfo[playerid][pPosY], PlayerInfo[playerid][pPosZ]);
    //mysql_query("UPDATE playerdata SET PositionX=%d WHERE user='s'", PlayerInfo[playerid][pPosX], pname);
    format(query, sizeof(query), "UPDATE playerdata SET PositionX=%f, PositionY=%f, PositionZ=%f, Admin=%i WHERE user='%s'", PlayerInfo[playerid][pPosX], PlayerInfo[playerid][pPosY], PlayerInfo[playerid][pPosZ], PlayerInfo[playerid][pAdmin], pname);
    mysql_query(query);
    format(query, sizeof(query), "UPDATE playerdata SET  Accent=%i, age=%i, race=%s, imprisonment=%s, features=%s WHERE user='%s'", PlayerInfo[playerid][pAccent], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pRace], PlayerInfo[playerid][pImprisonment], PlayerInfo[playerid][pFeatures], pname);
    mysql_query(query);
    return 1;
}
Reply


Messages In This Thread
Mysql saving won't work - by Kindred - 07.04.2012, 23:54
Re: Mysql saving won't work - by [DOG]irinel1996 - 07.04.2012, 23:56
Re: Mysql saving won't work - by Kindred - 08.04.2012, 00:10
Re: Mysql saving won't work - by [DOG]irinel1996 - 08.04.2012, 00:25
Re: Mysql saving won't work - by Kindred - 08.04.2012, 00:29
Re: Mysql saving won't work - by [DOG]irinel1996 - 08.04.2012, 00:30
Re: Mysql saving won't work - by Kindred - 08.04.2012, 01:17
Re: Mysql saving won't work - by [DOG]irinel1996 - 08.04.2012, 01:19
Re: Mysql saving won't work - by Kindred - 08.04.2012, 01:38
Re: Mysql saving won't work - by [DOG]irinel1996 - 08.04.2012, 10:54

Forum Jump:


Users browsing this thread: 5 Guest(s)