SQL Query error
#1

Hi SA-MP forums i'm trying to compile my script and once the compile finishes i get these errors:

C:\pwn\script.pwn(56053) : error 075: input line too long (after substitutions)
C:\pwn\script.pwn(56054) : error 037: invalid string (possibly non-terminated string)
C:\pwn\script.pwn(56054) : error 017: undefined symbol "UPDATE"
C:\pwn\script.pwn(56054) : error 017: undefined symbol "players"
C:\pwn\script.pwn(56054) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase

5 Errors.

The code where errors appear (It's the query for saving players stats, factions, etc.): http://pastebin.com/S9CRTiM7

I don't understand what's wrong with it anyways..i think some of the lines are too big

Thanks in advance!
Reply
#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
#3

Now i get these errors:

C:\pwn\script.pwn(56042) : error 075: input line too long (after substitutions)
C:\pwn\script.pwn(56042) : error 017: undefined symbol "PlayerIn"
C:\pwn\script.pwn(56043) : warning 217: loose indentation
C:\pwn\script.pwn(56043) : error 017: undefined symbol "fo"
C:\pwn\script.pwn(56043) : warning 215: expression has no effect
C:\pwn\script.pwn(56043) : error 001: expected token: ";", but found "]"
C:\pwn\script.pwn(56043) : error 029: invalid expression, assumed zero
C:\pwn\script.pwn(56043) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase


6 Errors.

http://pastebin.com/Adj8agzs - Code

(The lines are the ones you gave me)
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)