[K0P]

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);

[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); 


[K0P]

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

[AbyssMorgan]

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); 


[K0P]

Not working

Код:

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