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=600388)


Help - K0P - 07.02.2016

I get these errors even i tried to shorten the string using "\"

Errors
Код:
error 075: input line too long (after substitutions)
error 037: invalid string (possibly non-terminated string)
error 017: undefined symbol "INSERT"
error 017: undefined symbol "INTO"
fatal error 107: too many error messages on one line
Code:
Код:
new query[512];
PlayerInfo[playerid][Accountid] = cache_insert_id(mysql);
mysql_format(mysql, query, sizeof(query), "INSERT INTO `players` \
(`Account_ID`, \
`Name`, \
`Password`, \
`IP`, \
`Admin`, \
`VIP`, \
`FreeRoam_Score`, \
`Deathmatch_Score`, \
`Duel_Score`, \
`Deaths`, \
`Skin`, \
`Pms`, \
`Gos`, \
`God`, \
`Cms`, \
`MegaJump`, \
`Color`, \
`Fighting_Style`, \
`BanCount`, \
`JailCount`, \
`KickCount`, \
`MuteCount`, \
`ExplodeCount`, \
`SlapCount`, \
`WeaponRCount`, \
`Banned`, \
`Jailed`, \
`Muted`, \
`Frozen`, \
`Time`, \
`Weather`, \
`Last_Login`) \
VALUES \
(`%d`, \
'%e', \
'%e', \
'%e', \
0, \
0)",
PlayerInfo[playerid][Accountid],
PlayerInfo[playerid][pAdmin],
GetName(playerid),
inputtext,
ip);


Re: Help - AbyssMorgan - 07.02.2016

don't use \
PHP код:
new query[512];
PlayerInfo[playerid][Accountid] = cache_insert_id(mysql);
mysql_format(mysql, query, sizeof(query), "INSERT INTO `players` (`Account_ID`,
`Name`,
`Password`,
`IP`,
`Admin`,
`VIP`,
`FreeRoam_Score`,
`Deathmatch_Score`,
`Duel_Score`,
`Deaths`,
`Skin`,
`Pms`,
`Gos`,
`God`,
`Cms`,
`MegaJump`,
`Color`,
`Fighting_Style`,
`BanCount`,
`JailCount`,
`KickCount`,
`MuteCount`,
`ExplodeCount`,
`SlapCount`,
`WeaponRCount`,
`Banned`,
`Jailed`,
`Muted`,
`Frozen`,
`Time`,
`Weather`,
`Last_Login`) VALUES (`%d`,
'%e',
'%e',
'%e',
0,
0)",
PlayerInfo[playerid][Accountid],
PlayerInfo[playerid][pAdmin],
GetName(playerid),
inputtext,
ip); 


Re: Help - K0P - 07.02.2016

Quote:
Originally Posted by AbyssMorgan
Посмотреть сообщение
don't use \
PHP код:
new query[512];
PlayerInfo[playerid][Accountid] = cache_insert_id(mysql);
mysql_format(mysql, query, sizeof(query), "INSERT INTO `players` (`Account_ID`,
`Name`,
`Password`,
`IP`,
`Admin`,
`VIP`,
`FreeRoam_Score`,
`Deathmatch_Score`,
`Duel_Score`,
`Deaths`,
`Skin`,
`Pms`,
`Gos`,
`God`,
`Cms`,
`MegaJump`,
`Color`,
`Fighting_Style`,
`BanCount`,
`JailCount`,
`KickCount`,
`MuteCount`,
`ExplodeCount`,
`SlapCount`,
`WeaponRCount`,
`Banned`,
`Jailed`,
`Muted`,
`Frozen`,
`Time`,
`Weather`,
`Last_Login`) VALUES (`%d`,
'%e',
'%e',
'%e',
0,
0)",
PlayerInfo[playerid][Accountid],
PlayerInfo[playerid][pAdmin],
GetName(playerid),
inputtext,
ip); 
It will break the string

Re: Help - AbyssMorgan - 07.02.2016

hmm, try this
PHP код:
format(query, sizeof(query),
    "INSERT INTO `players` (`Account_ID`, `Name`, `Password`, `IP`, `Admin`, `VIP`, `FreeRoam_Score`,`Deathmatch_Score`,`Duel_Score`,`Deaths`, \
    `Skin`,`Pms`,`Gos`,`God`,`Cms`,`MegaJump`,`Color`,`Fighting_Style`,`BanCount`,`JailCount`,`KickCount`,`MuteCount`,`ExplodeCount`,`SlapCount`, \
    `WeaponRCount`,`Banned`,`Jailed`,`Muted`,`Frozen`,`Time`,`Weather`, `Last_Login`) VALUES (`%d`,'%e','%e','%e',0,0)", \
    PlayerInfo[playerid][Accountid], PlayerInfo[playerid][pAdmin], GetName(playerid), inputtext, ip); 


Re: Help - K0P - 07.02.2016

Not working

Код:
(3469 -- 3472) : error 075: input line too long (after substitutions)