SA-MP Forums Archive
Help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Help (/showthread.php?tid=342513)


Help - BillieJoe - 13.05.2012

Errors:

Код:
F:\gm\gamemodes\gm.pwn(2382) : error 075: input line too long (after substitutions)
F:\gm\gamemodes\gm.pwn(2383) : error 037: invalid string (possibly non-terminated string)
F:\gm\gamemodes\gm.pwn(2383) : error 017: undefined symbol "INSERT"
F:\gm\gamemodes\gm.pwn(2383) : error 017: undefined symbol "INTO"
F:\gm\gamemodes\gm.pwn(2383) : fatal error 107: too many error messages on one line

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


5 Errors.
And the lines:

pawn Код:
format(string,sizeof(string), "INSERT INTO `Accounts` (`Name`, `Password`, `AdminLevel`, `Money`, `Bank`, `Faction`, `Rank`, `HouseKey`, `BizKey`, `Skin`, `Spawn1`, `Spawn2`, `Spawn3`, `Spawn4`, `Spawn5`, `Reg`, `Sex`, `Wallet`, `Renting`, `Products`, `PhoneNumber`, `Minutes`, `Spawn6`, `Arrested`, `Prisoned`, `Jailed`, `JailTime`, `Cell`, `Towe`, `License`, `Linked`, `ForumName`, `ForumPassword`, `wLicense`, `Job`, `Donator`, `CarParts`, `PlayingTime`, `FightingStyle`, `Materials`) \
    VALUES('%s,md5('%s'),0,0,0,999,999,999,999,101,1981.7389,-1962.9572,16.6941,359.3499,0,0,0,300,0,0,-1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0)",
    name, SQLEscape[Escape][0]);
    mysql_query(string);


Re: Help - JaTochNietDan - 14.05.2012

Why do you bother setting all of those values if they are static? Just use default values for your columns in the MySQL database and whenever a row is created, those values will automatically be populated in the columns.

The problem with your code though is that it is too long, you will need to use something like strmid to build the string piece by piece without going over the line length limit of PAWN.

Re: Help - FalconX - 14.05.2012

Quote:
Originally Posted by JaTochNietDan
Посмотреть сообщение
Why do you bother setting all of those values if they are static? Just use default values for your columns in the MySQL database and whenever a row is created, those values will automatically be populated in the columns.

The problem with your code though is that it is too long, you will need to use something like strmid to build the string piece by piece without going over the line length limit of PAWN.
Strcat might help.