SQL Query error
#2

The code it too long, try this:

pawn Код:
format(szQuery, sizeof(szQuery), "UPDATE players SET Username = '%s', Password = '%s', Level = %d, AdminLevel = %d, AdminName = '%s', BanAppealer = %d, Donator = %d, Tokens = %d, Banned = %d, Permabanned = %d, Disabled = %d, LastIP = '%s', Registered = %d, Tutorial = %d, Sex = %d, Age = %d, Skin = %d WHERE ID = %d",szPlayerName, PlayerInfo[playerid][pKey], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], szAdminName, PlayerInfo[playerid][pBanAppealer], PlayerInfo[playerid][pDonator], PlayerInfo[playerid][pTokens], PlayerInfo[playerid][pBanned], PlayerInfo[playerid][pPermaBanned], PlayerInfo[playerid][pDisabled], PlayerInfo[playerid][pIP], PlayerInfo[playerid][pReg], PlayerInfo[playerid][pTut], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pID]);

format(szQuery, sizeof(szQuery), "UPDATE players SET PosX = '%f', PosY = '%f', PosZ = '%f', PosR = '%f', ConnectTime = %d, Respect = %d, PhoneNumber = %d, Warnings = %d, Gang = %d, Faction = %d, Leader = %d, Rank = %d, GarageKey = %d, TogVIP = %d, GiftTime = %d, BuddyInvited = %d WHERE ID = %d", PlayerInfo[playerid][pPos_x],PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z], PlayerInfo[playerid][pPos_r], PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pRespect], PlayerInfo[playerid][pNumber], PlayerInfo[playerid][pWarns], PlayerInfo[playerid][pGang],PlayerInfo[playerid][pFaction], PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pRank],PlayerInfo[playerid][pPgaragekey], PlayerInfo[playerid][pToggedVIPChat], PlayerInfo[playerid][pGiftTime], PlayerInfo[playerid][pBuddyInvited], PlayerInfo[playerid][pID]);
Reply


Messages In This Thread
SQL Query error - by und3rcore - 20.04.2013, 11:32
Re: SQL Query error - by PaulDinam - 20.04.2013, 12:22
Re: SQL Query error - by und3rcore - 20.04.2013, 12:29

Forum Jump:


Users browsing this thread: 2 Guest(s)