Input line too long (after substitutions)

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: Input line too long (after substitutions) (/showthread.php?tid=647859)

Input line too long (after substitutions) - Immortal99 - 12.01.2018

Hey ya'll,

I'm getting this error on line 1063:

PHP код:



error 075: input line too long (after substitutions)

Heres the code:

PHP код:



stock SaveGate(id)

{

    mysql_format(MySQLDAtabase, Array11, sizeof(Array11), "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, \         (This is line 1063)

        `Facility`=%d \

        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(MySQLDAtabase, Array11, "OnQueryFinish", "i", SENDDATA_THREAD);

    return 0;

}

Re: Input line too long (after substitutions) - chneubeul - 12.01.2018

Hello,

you need to split your string :/

Re: Input line too long (after substitutions) - Immortal99 - 12.01.2018

Quote:

Originally Posted by chneubeul

Hello,

you need to split your string :/

and how do I do that? lol

Re: Input line too long (after substitutions) - Shaneisace - 12.01.2018

You shouldn't be getting this issue; even in the current script it still as you show it

Код:

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, \
		`Facility`=%d \
		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;
}

As shown on their github; I would suggest not using the script it's a proper mess lol

Re: Input line too long (after substitutions) - Fratello - 12.01.2018

Give the

Код:

#pragma dynamic 8600

a try.

Re: Input line too long (after substitutions) - Immortal99 - 12.01.2018

Yes, its NGG script, I really dont know whats the problem, i increased the variable amound "szMiscArray" still doesnt work

Re: Input line too long (after substitutions) - wallee - 12.01.2018

you either need to split the string or use this:

https://sampforum.blast.hk/showthread.php?tid=473595

Re: Input line too long (after substitutions) - Shaneisace - 12.01.2018

Quote:

Originally Posted by Immortal99

Yes, its NGG script, I really dont know whats the problem, i increased the variable amound "szMiscArray" still doesnt work

If you need to split it take a look at the house saving method:

Код:

stock SaveHouse(houseid) {

	szMiscArray[0] = 0;
	mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "UPDATE `houses` SET \
		`Owned`=%d, \
		`Level`=%d, \
		`Description`='%s', \
		`OwnerID`=%d, \
		`ExteriorX`=%f, \
		`ExteriorY`=%f, \
		`ExteriorZ`=%f, \
		`ExteriorR`=%f, \
		`InteriorX`=%f, \
		`InteriorY`=%f, \
		`InteriorZ`=%f, \
		`InteriorR`=%f, \
		`ExtIW`=%d, \
		`ExtVW`=%d, \
		`IntIW`=%d, \
		`IntVW`=%d \
		WHERE `id` =%d",
		HouseInfo[houseid][hOwned],
		HouseInfo[houseid][hLevel],
		g_mysql_ReturnEscaped(HouseInfo[houseid][hDescription]),
		HouseInfo[houseid][hOwnerID],
		HouseInfo[houseid][hExteriorX],
		HouseInfo[houseid][hExteriorY],
		HouseInfo[houseid][hExteriorZ],
		HouseInfo[houseid][hExteriorR],
		HouseInfo[houseid][hInteriorX],
		HouseInfo[houseid][hInteriorY],
		HouseInfo[houseid][hInteriorZ],
		HouseInfo[houseid][hInteriorR],
		HouseInfo[houseid][hExtIW],
		HouseInfo[houseid][hExtVW],
		HouseInfo[houseid][hIntIW],
		HouseInfo[houseid][hIntVW],
		houseid+1
	);
	mysql_tquery(MainPipeline, szMiscArray, "OnSaveHouse", "ii", houseid, 0);

	mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "UPDATE `houses` SET \
		`Lock`=%d, \
		`Rentable`=%d, \
		`RentFee`=%d, \
		`Value`=%d, \
		`SafeMoney`=%d, \
		`Pot`=%d, \
		`Crack`=%d, \
		`Materials`=%d, \
		`Heroin`=%d, \
		`Meth`=%d, \
		`Ecstasy`=%d, \
		`Weapons0`=%d, \
		`Weapons1`=%d, \
		`Weapons2`=%d, \
		`Weapons3`=%d, \
		`GLUpgrade`=%d, \
		`CustomInterior`=%d, \
		`CustomExterior`=%d, \
		`ExteriorA`=%f, \
		`InteriorA`=%f, \
		`MailX`=%f, \
		`MailY`=%f, \
		`MailZ`=%f, \
		`MailA`=%f, \
		`MailType`=%d, \
		`ClosetX`=%f, \
		`ClosetY`=%f, \
		`ClosetZ`=%f \
		WHERE `id` =%d",
		HouseInfo[houseid][hLock],
		HouseInfo[houseid][hRentable],
		HouseInfo[houseid][hRentFee],
		HouseInfo[houseid][hValue],
   		HouseInfo[houseid][hSafeMoney],
		HouseInfo[houseid][hPot],
		HouseInfo[houseid][hCrack],
		HouseInfo[houseid][hMaterials],
		HouseInfo[houseid][hHeroin],
		HouseInfo[houseid][hMeth],
		HouseInfo[houseid][hEcstasy],
		HouseInfo[houseid][hWeapons][0],
		HouseInfo[houseid][hWeapons][1],
		HouseInfo[houseid][hWeapons][2],
		HouseInfo[houseid][hWeapons][3],
		//HouseInfo[houseid][hWeapons][4],
		HouseInfo[houseid][hGLUpgrade],
		HouseInfo[houseid][hCustomInterior],
		HouseInfo[houseid][hCustomExterior],
		HouseInfo[houseid][hExteriorA],
		HouseInfo[houseid][hInteriorA],
		HouseInfo[houseid][hMailX],
		HouseInfo[houseid][hMailY],
		HouseInfo[houseid][hMailZ],
		HouseInfo[houseid][hMailA],
		HouseInfo[houseid][hMailType],
		HouseInfo[houseid][hClosetX],
		HouseInfo[houseid][hClosetY],
		HouseInfo[houseid][hClosetZ],
		houseid+1
	);
	mysql_tquery(MainPipeline, szMiscArray, "OnSaveHouse", "ii", houseid, 1);

	mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "UPDATE `houses` SET \
		`SignDesc`='%s', \
		`SignX`=%f, \
		`SignY`=%f, \
		`SignZ`=%f, \
		`SignA`=%f, \
		`SignExpire`=%d, \
		`LastLogin`=%d, \
		`Expire`=%d, \
		`Inactive`=%d, \
		`Ignore`=%d, \
		`Counter`=%d \
		WHERE `id` =%d",
		g_mysql_ReturnEscaped(HouseInfo[houseid][hSignDesc]),
		HouseInfo[houseid][hSign][0],
		HouseInfo[houseid][hSign][1],
		HouseInfo[houseid][hSign][2],
		HouseInfo[houseid][hSign][3],
		HouseInfo[houseid][hSignExpire],
		HouseInfo[houseid][hLastLogin],
		HouseInfo[houseid][hExpire],
		HouseInfo[houseid][hInactive],
		HouseInfo[houseid][hIgnore],
		HouseInfo[houseid][hCounter],
		houseid+1
	);
	mysql_tquery(MainPipeline, szMiscArray, "OnSaveHouse", "ii", houseid, 2);

	mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "UPDATE `houses` SET \
		`Listed`=%d, \
		`PendingApproval`=%d, \
		`ListedTimeStamp`=%d, \
		`ListingPrice`=%d, \
		`LinkedDoor0`=%d, \
		`LinkedDoor1`=%d, \
		`LinkedDoor2`=%d, \
		`LinkedDoor3`=%d, \
		`LinkedDoor4`=%d, \
		`ListingDescription`='%s', \
		`LinkedGarage0`=%d, \
		`LinkedGarage1`=%d, \
		`Lights`=%d \
		WHERE `id`=%d",
		HouseInfo[houseid][Listed],
		HouseInfo[houseid][PendingApproval],
		HouseInfo[houseid][ListedTimeStamp],
		HouseInfo[houseid][ListingPrice],
		HouseInfo[houseid][LinkedDoor][0],
		HouseInfo[houseid][LinkedDoor][1],
		HouseInfo[houseid][LinkedDoor][2],
		HouseInfo[houseid][LinkedDoor][3],
		HouseInfo[houseid][LinkedDoor][4],
		HouseInfo[houseid][ListingDescription],
		HouseInfo[houseid][LinkedGarage][0],
		HouseInfo[houseid][LinkedGarage][1],
		HouseInfo[houseid][h_iLights],
		houseid+1
	); // Array starts from zero, MySQL starts at 1 (this is why we are adding one).
	mysql_tquery(MainPipeline, szMiscArray, "OnSaveHouse", "ii", houseid, 3);
}

This is how you can split the string, Did you recently download this script from their Github or obtain via someone?

If you got it via someone download it from their official github you shouldn't run into any issues

Re: Input line too long (after substitutions) - Immortal99 - 12.01.2018

Quote:

Originally Posted by Fratello

Give the

Код:

#pragma dynamic 8600

a try.

Does not work

Re: Input line too long (after substitutions) - Immortal99 - 12.01.2018

Quote:

Originally Posted by Shaneisace

If you need to split it take a look at the house saving method:

Код:

stock SaveHouse(houseid) {

	szMiscArray[0] = 0;
	mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "UPDATE `houses` SET \
		`Owned`=%d, \
		`Level`=%d, \
		`Description`='%s', \
		`OwnerID`=%d, \
		`ExteriorX`=%f, \
		`ExteriorY`=%f, \
		`ExteriorZ`=%f, \
		`ExteriorR`=%f, \
		`InteriorX`=%f, \
		`InteriorY`=%f, \
		`InteriorZ`=%f, \
		`InteriorR`=%f, \
		`ExtIW`=%d, \
		`ExtVW`=%d, \
		`IntIW`=%d, \
		`IntVW`=%d \
		WHERE `id` =%d",
		HouseInfo[houseid][hOwned],
		HouseInfo[houseid][hLevel],
		g_mysql_ReturnEscaped(HouseInfo[houseid][hDescription]),
		HouseInfo[houseid][hOwnerID],
		HouseInfo[houseid][hExteriorX],
		HouseInfo[houseid][hExteriorY],
		HouseInfo[houseid][hExteriorZ],
		HouseInfo[houseid][hExteriorR],
		HouseInfo[houseid][hInteriorX],
		HouseInfo[houseid][hInteriorY],
		HouseInfo[houseid][hInteriorZ],
		HouseInfo[houseid][hInteriorR],
		HouseInfo[houseid][hExtIW],
		HouseInfo[houseid][hExtVW],
		HouseInfo[houseid][hIntIW],
		HouseInfo[houseid][hIntVW],
		houseid+1
	);
	mysql_tquery(MainPipeline, szMiscArray, "OnSaveHouse", "ii", houseid, 0);

	mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "UPDATE `houses` SET \
		`Lock`=%d, \
		`Rentable`=%d, \
		`RentFee`=%d, \
		`Value`=%d, \
		`SafeMoney`=%d, \
		`Pot`=%d, \
		`Crack`=%d, \
		`Materials`=%d, \
		`Heroin`=%d, \
		`Meth`=%d, \
		`Ecstasy`=%d, \
		`Weapons0`=%d, \
		`Weapons1`=%d, \
		`Weapons2`=%d, \
		`Weapons3`=%d, \
		`GLUpgrade`=%d, \
		`CustomInterior`=%d, \
		`CustomExterior`=%d, \
		`ExteriorA`=%f, \
		`InteriorA`=%f, \
		`MailX`=%f, \
		`MailY`=%f, \
		`MailZ`=%f, \
		`MailA`=%f, \
		`MailType`=%d, \
		`ClosetX`=%f, \
		`ClosetY`=%f, \
		`ClosetZ`=%f \
		WHERE `id` =%d",
		HouseInfo[houseid][hLock],
		HouseInfo[houseid][hRentable],
		HouseInfo[houseid][hRentFee],
		HouseInfo[houseid][hValue],
   		HouseInfo[houseid][hSafeMoney],
		HouseInfo[houseid][hPot],
		HouseInfo[houseid][hCrack],
		HouseInfo[houseid][hMaterials],
		HouseInfo[houseid][hHeroin],
		HouseInfo[houseid][hMeth],
		HouseInfo[houseid][hEcstasy],
		HouseInfo[houseid][hWeapons][0],
		HouseInfo[houseid][hWeapons][1],
		HouseInfo[houseid][hWeapons][2],
		HouseInfo[houseid][hWeapons][3],
		//HouseInfo[houseid][hWeapons][4],
		HouseInfo[houseid][hGLUpgrade],
		HouseInfo[houseid][hCustomInterior],
		HouseInfo[houseid][hCustomExterior],
		HouseInfo[houseid][hExteriorA],
		HouseInfo[houseid][hInteriorA],
		HouseInfo[houseid][hMailX],
		HouseInfo[houseid][hMailY],
		HouseInfo[houseid][hMailZ],
		HouseInfo[houseid][hMailA],
		HouseInfo[houseid][hMailType],
		HouseInfo[houseid][hClosetX],
		HouseInfo[houseid][hClosetY],
		HouseInfo[houseid][hClosetZ],
		houseid+1
	);
	mysql_tquery(MainPipeline, szMiscArray, "OnSaveHouse", "ii", houseid, 1);

	mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "UPDATE `houses` SET \
		`SignDesc`='%s', \
		`SignX`=%f, \
		`SignY`=%f, \
		`SignZ`=%f, \
		`SignA`=%f, \
		`SignExpire`=%d, \
		`LastLogin`=%d, \
		`Expire`=%d, \
		`Inactive`=%d, \
		`Ignore`=%d, \
		`Counter`=%d \
		WHERE `id` =%d",
		g_mysql_ReturnEscaped(HouseInfo[houseid][hSignDesc]),
		HouseInfo[houseid][hSign][0],
		HouseInfo[houseid][hSign][1],
		HouseInfo[houseid][hSign][2],
		HouseInfo[houseid][hSign][3],
		HouseInfo[houseid][hSignExpire],
		HouseInfo[houseid][hLastLogin],
		HouseInfo[houseid][hExpire],
		HouseInfo[houseid][hInactive],
		HouseInfo[houseid][hIgnore],
		HouseInfo[houseid][hCounter],
		houseid+1
	);
	mysql_tquery(MainPipeline, szMiscArray, "OnSaveHouse", "ii", houseid, 2);

	mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "UPDATE `houses` SET \
		`Listed`=%d, \
		`PendingApproval`=%d, \
		`ListedTimeStamp`=%d, \
		`ListingPrice`=%d, \
		`LinkedDoor0`=%d, \
		`LinkedDoor1`=%d, \
		`LinkedDoor2`=%d, \
		`LinkedDoor3`=%d, \
		`LinkedDoor4`=%d, \
		`ListingDescription`='%s', \
		`LinkedGarage0`=%d, \
		`LinkedGarage1`=%d, \
		`Lights`=%d \
		WHERE `id`=%d",
		HouseInfo[houseid][Listed],
		HouseInfo[houseid][PendingApproval],
		HouseInfo[houseid][ListedTimeStamp],
		HouseInfo[houseid][ListingPrice],
		HouseInfo[houseid][LinkedDoor][0],
		HouseInfo[houseid][LinkedDoor][1],
		HouseInfo[houseid][LinkedDoor][2],
		HouseInfo[houseid][LinkedDoor][3],
		HouseInfo[houseid][LinkedDoor][4],
		HouseInfo[houseid][ListingDescription],
		HouseInfo[houseid][LinkedGarage][0],
		HouseInfo[houseid][LinkedGarage][1],
		HouseInfo[houseid][h_iLights],
		houseid+1
	); // Array starts from zero, MySQL starts at 1 (this is why we are adding one).
	mysql_tquery(MainPipeline, szMiscArray, "OnSaveHouse", "ii", houseid, 3);
}

I got it from there github, put everything where it should be, opened my pawno and compiled and then got this error