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