Mysql saving won't work
#3

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;
}
Saving stock... Is it because i used query twice (I understand that the size is huge, but how do I see how much is needed?)

Picture of the structure:

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: 1 Guest(s)