error 075: input line too long (after substitutions) - 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: error 075: input line too long (after substitutions) (/showthread.php?tid=663624)
+- 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: error 075: input line too long (after substitutions) (/showthread.php?tid=663624)
error 075: input line too long (after substitutions) - ApoziX - 07.02.2019
How to fix it
Thanks for helpers +rep!
http://pastebin.ml/paste.php?id=13
Line 54937
`TColor`=%d, \
Re: error 075: input line too long (after substitutions) - Jaxium - 07.02.2019
I'm on phone currently, but I'll try to help. That error means that the text is too long, between the string quotes.
You can split the entire string into two. Declare a string variable and use strcat two times. Each time use half of the text you are currently using. Then use that variable into the mysql function.
Re: error 075: input line too long (after substitutions) - ApoziX - 07.02.2019
Quote:
|
Originally Posted by Jaxium
 I'm on phone currently, but I'll try to help. That error means that the text is too long, between the string quotes.
You can split the entire string into two. Declare a string variable and use strcat two times. Each time use half of the text you are currently using. Then use that variable into the mysql function. |
Could you do it for me?
Re: error 075: input line too long (after substitutions) - Kaliber - 07.02.2019
You can simply do this:
PHP Code:
mysql_format(connectionID, szMiscArray, sizeof(szMiscArray), "UPDATE `gates` SET \
`HID`=%d, \
`Speed`=%f, \
`Range`=%f, \54922
`Model`=%d, \
`VW`=%d, \
`Int`=%d, \
`Pass`='%e', \
`PosX`=%f, \
`PosY`=%f, \
`PosZ`=%f, \
`RotX`=%f, \
`RotY`=%f, \
`RotZ`=%f, \
`PosXM`=%f, \
`PosYM`=%f, \
`PosZM`=%f, \
`RotXM`=%f, \
`RotYM`=%f, \
`RotZM`=%f",
GateInfo[id][gHID],
GateInfo[id][gSpeed],
GateInfo[id][gRange],
GateInfo[id][gModel],
GateInfo[id][gVW],
GateInfo[id][gInt],
GateInfo[id][gPass],
GateInfo[id][gPosX],
GateInfo[id][gPosY],
GateInfo[id][gPosZ],
GateInfo[id][gRotX],
GateInfo[id][gRotY],
GateInfo[id][gRotZ],
GateInfo[id][gPosXM],
GateInfo[id][gPosYM],
GateInfo[id][gPosZM],
GateInfo[id][gRotXM],
GateInfo[id][gRotYM],
GateInfo[id][gRotZM]);
mysql_format(connectionID, szMiscArray, sizeof(szMiscArray), "%s \
`Allegiance`=%d, \
`GroupType`=%d, \
`GroupID`=%d, \
`RenderHQ`=%d, \
`Timer`=%d, \
`Automate`=%d, \
`Locked`=%d, \
`TIndex`=%d, \
`TModel`=%d, \
`TTXD`='%e', \
`TTexture`='%e', \
`TColor`=%d, \
`Facility`=%d \
WHERE `ID` = %d",
szMiscArray,
GateInfo[id][gAllegiance],
GateInfo[id][gGroupType],
GateInfo[id][gGroupID],
GateInfo[id][gRenderHQ],
GateInfo[id][gTimer],
GateInfo[id][gAutomate],
GateInfo[id][gLocked],
GateInfo[id][gTIndex],
GateInfo[id][gTModel],
GateInfo[id][gTTXD],
GateInfo[id][gTTexture],
GateInfo[id][gTColor],
GateInfo[id][gFacility],
id+1
);
mysql_tquery(connectionID, szMiscArray);
return 0;
}