1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Input line too long (after substitutions)
Immortal99
Big Clucker
***
Posts: 153
Threads: 35
Joined: Mar 2016
Reputation: 0
#1

12.01.2018, 13:06
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;
} 
Find
Reply
chneubeul
Little Clucker
**
Posts: 47
Threads: 4
Joined: May 2009
Reputation: 0
#2

12.01.2018, 13:10
Hello,

you need to split your string :/
Find
Reply
Immortal99
Big Clucker
***
Posts: 153
Threads: 35
Joined: Mar 2016
Reputation: 0
#3

12.01.2018, 13:28
Quote:
Originally Posted by chneubeul
Посмотреть сообщение
Hello,

you need to split your string :/
and how do I do that? lol
Find
Reply
Shaneisace
Big Clucker
***
Posts: 85
Threads: 4
Joined: Jan 2012
Reputation: 0
#4

12.01.2018, 13:33
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
Find
Reply
Fratello
Huge Clucker
****
Posts: 311
Threads: 27
Joined: May 2016
Reputation: 0
#5

12.01.2018, 13:35
Give the
Код:
#pragma dynamic 8600
a try.
Find
Reply
Immortal99
Big Clucker
***
Posts: 153
Threads: 35
Joined: Mar 2016
Reputation: 0
#6

12.01.2018, 13:35
Yes, its NGG script, I really dont know whats the problem, i increased the variable amound "szMiscArray" still doesnt work
Find
Reply
wallee
Huge Clucker
****
Posts: 266
Threads: 22
Joined: Jan 2017
Reputation: 0
#7

12.01.2018, 13:36
you either need to split the string or use this:

https://sampforum.blast.hk/showthread.php?tid=473595
Find
Reply
Shaneisace
Big Clucker
***
Posts: 85
Threads: 4
Joined: Jan 2012
Reputation: 0
#8

12.01.2018, 13:37
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
Find
Reply
Immortal99
Big Clucker
***
Posts: 153
Threads: 35
Joined: Mar 2016
Reputation: 0
#9

12.01.2018, 13:37
Quote:
Originally Posted by Fratello
Посмотреть сообщение
Give the
Код:
#pragma dynamic 8600
a try.
Does not work
Find
Reply
Immortal99
Big Clucker
***
Posts: 153
Threads: 35
Joined: Mar 2016
Reputation: 0
#10

12.01.2018, 13:40
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);
}
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
I got it from there github, put everything where it should be, opened my pawno and compiled and then got this error
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help