./includes/dynamic/gates.pwn(1063) : error 075: input line too long (after substitutions) ./includes/dynamic/gates.pwn(1064) : error 037: invalid string (possibly non-terminated string) ./includes/dynamic/gates.pwn(1064) : error 017: undefined symbol "UPDATE" ./includes/dynamic/gates.pwn(1064) : error 017: undefined symbol "gates" ./includes/dynamic/gates.pwn(1064) : fatal error 107: too many error messages on one line
stock SaveGate(id)
{
mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "UPDATE `gates` SET \
`HID`=%d, \
`Speed`=%f, \
`Range`=%f, \
`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, \
`Allegiance`=%d, \
`GroupType`=%d, \
`GroupID`=%d, \
`RenderHQ`=%d, \
`Timer`=%d, \
`Automate`=%d, \
`Locked`=%d, \
`TIndex`=%d, \
`TModel`=%d, \
`TTXD`='%e', \
`TTexture`='%e', \
`TColor`=%d, \ <-1063
`Facility`=%d \ <-1064
WHERE `ID`=%d",
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],
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(MainPipeline, szMiscArray, "OnQueryFinish", "i", SENDDATA_THREAD);
return 0;
}
mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "UPDATE `gates` SET \ `HID`=%d, \ `Speed`=%f, \ `Range`=%f, \ `Model`=%d, \ `VW`=%d, \ `Int`=%d, \ `Pass`='%e', \ `PosX`=%f, \ `PosY`=%f, \ `PosZ`=%f, \ `RotX`=%f, \ `RotY`=%f, \ `RotZ`=%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] ); mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "%s\ `PosXM`=%f, \ `PosYM`=%f, \ `PosZM`=%f, \ `RotXM`=%f, \ `RotYM`=%f, \ `RotZM`=%f, \ `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][gPosXM], GateInfo[id][gPosYM], GateInfo[id][gPosZM], GateInfo[id][gRotXM], GateInfo[id][gRotYM], GateInfo[id][gRotZM], 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(MainPipeline, szMiscArray, "OnQueryFinish", "i", SENDDATA_THREAD);
|
The best way is to use Zeex's compiler which increases the limit of input line: https://github.com/pawn-lang/compiler/releases
Other option is strcat: https://sampwiki.blast.hk/wiki/Strcat Do you really need to update all these columns? |
\include\YSI\internal\..\internal\..\y_scriptinit.inc(62) : fatal error 100: cannot read from file: "a_samp"
#include <a_samp>
// YSI libraries after a_samp
#include <YSI\y_iterate>
// any other include
#include <YSI/y_iterate>
|
You can split and join them with strcat before the query.
Or just split the mysql_format (as long you have enough string buffer size) like this: Код:
mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "UPDATE `gates` SET \ `HID`=%d, \ `Speed`=%f, \ `Range`=%f, \ `Model`=%d, \ `VW`=%d, \ `Int`=%d, \ `Pass`='%e', \ `PosX`=%f, \ `PosY`=%f, \ `PosZ`=%f, \ `RotX`=%f, \ `RotY`=%f, \ `RotZ`=%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] ); mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "%s\ `PosXM`=%f, \ `PosYM`=%f, \ `PosZM`=%f, \ `RotXM`=%f, \ `RotYM`=%f, \ `RotZM`=%f, \ `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][gPosXM], GateInfo[id][gPosYM], GateInfo[id][gPosZM], GateInfo[id][gRotXM], GateInfo[id][gRotYM], GateInfo[id][gRotZM], 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(MainPipeline, szMiscArray, "OnQueryFinish", "i", SENDDATA_THREAD); |