Different types of SQL Issues
#2

You are using the UPDATE wrong, watch this two lines very carefully:

pawn Код:
format(szQuery, sizeof(szQuery), "UPDATE `players` SET `Money` = '%d', `Score` = '%d', `Admin` = '%d', `Kills` = '%d', `Deaths` = '%d', `Weather` = '%d'",PlayerInfo[playerid][pCash], PlayerInfo[playerid][pScore], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pKills], PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][pWeather]);
    format(szQuery, sizeof(szQuery), "%s, Skin = %d, Time = %d, Color = %d, Tele = %d, Message = %d WHERE Username = '%s'", szQuery, PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pTime], PlayerInfo[playerid][pColor], PlayerInfo[playerid][pTele], PlayerInfo[playerid][pTele], PlayerInfo[playerid][pMessage], PlayerInfo[playerid][pWeather]);
Better said watch the last line your messing to much with it around. You have two times:
pawn Код:
PlayerInfo[playerid][pTele]
in a row remove one time.
Instead of the Playername does you try to save the weather.
pawn Код:
PlayerInfo[playerid][pWeather]
The last one in the second one should when i watched now correct be:
pawn Код:
PlayerInfo[playerid][pUsername]
//instead of
PlayerInfo[playerid][pWeather]
If you can't fix it urself, shout and i give you the fixed part.
Reply


Messages In This Thread
Different types of SQL Issues - by KiNG3 - 17.04.2013, 22:12
AW: Different types of SQL Issues - by ulbi1990 - 17.04.2013, 23:04
Re: Different types of SQL Issues - by KiNG3 - 17.04.2013, 23:09
Re: Different types of SQL Issues - by KiNG3 - 17.04.2013, 23:15

Forum Jump:


Users browsing this thread: 1 Guest(s)