MySQL Save Bad pos
#7

I'm pretty sure field names are case-sensitive.
You're saving them as 'posX', 'posY' and 'posZ', but trying to read info from 'PosX', 'PosY', 'PosZ'.

Change this:
pawn Код:
mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `Admin`=%d, `Frakcio`=%d, `Money`=%d,   `posX`=%f, `posY`=%f, `posZ`=%f,`Uj`=%d,`Munka`=%d,`Skin`=%d,`FSkin`=%d  WHERE `ID`=%d",\
    pInfo[playerid][Admin], pInfo[playerid][Frakcio], pInfo[playerid][Money], xpos, ypos, zpos, pInfo[playerid][Uj], pInfo[playerid][Munka], pInfo[playerid][Skin], pInfo[playerid][FSkin], pInfo[playerid][ID]);
With this:
pawn Код:
mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `Admin`=%d, `Frakcio`=%d, `Money`=%d,   `PosX`=%f, `PosY`=%f, `PosZ`=%f,`Uj`=%d,`Munka`=%d,`Skin`=%d,`FSkin`=%d  WHERE `ID`=%d",\
    pInfo[playerid][Admin], pInfo[playerid][Frakcio], pInfo[playerid][Money], xpos, ypos, zpos, pInfo[playerid][Uj], pInfo[playerid][Munka], pInfo[playerid][Skin], pInfo[playerid][FSkin], pInfo[playerid][ID]);
Reply


Messages In This Thread
MySQL Save Bad pos - by SaVage96 - 01.08.2015, 11:10
Re: MySQL Save Bad pos - by [XST]O_x - 01.08.2015, 11:35
Re: MySQL Save Bad pos - by SaVage96 - 01.08.2015, 11:54
Re: MySQL Save Bad pos - by dominik523 - 01.08.2015, 11:58
Re: MySQL Save Bad pos - by DaniceMcHarley - 01.08.2015, 11:58
Re: MySQL Save Bad pos - by Vince - 01.08.2015, 11:59
Re: MySQL Save Bad pos - by [XST]O_x - 01.08.2015, 12:01
Re: MySQL Save Bad pos - by SaVage96 - 01.08.2015, 12:08
Re: MySQL Save Bad pos - by SaVage96 - 01.08.2015, 12:15
Re: MySQL Save Bad pos - by SaVage96 - 01.08.2015, 13:19

Forum Jump:


Users browsing this thread: 1 Guest(s)