MySQL Input line too long - Printable Version

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

MySQL Input line too long - Zens - 16.07.2015

How can I possibly split this code in two to make it shorter? I'm getting this error,

Код:

C:\Users\Test\Desktop\roleplay.pwn(8228) : error 075: input line too long (after substitutions)
C:\Users\Test\Desktop\roleplay.pwn(8229) : error 037: invalid string (possibly non-terminated string)
C:\Users\Test\Desktop\roleplay.pwn(8229) : error 017: undefined symbol "UPDATE"
C:\Users\Test\Desktop\roleplay.pwn(8229) : error 029: invalid expression, assumed zero
C:\Users\Test\Desktop\roleplay.pwn(8229) : fatal error 107: too many error messages on one line

Код:

	format(query, sizeof(query), "UPDATE `companies` SET `companyName` = '%s', `companyColor` = '%d', `companyType` = '%d', `companyRanks` = '%d', `companyInformationX` = '%.4f', `companyInformationY` = '%.4f', `companyInformationZ` = '%.4f', `companyInformationInt` = '%d', `companyInformationWorld` = '%d', `companyPurchaseX` = '%.4f', `companyPurchaseY` = '%.4f', `companyPurchaseZ` = '%.4f', `companyPurchaseInt` = '%d', `companyPurchaseWorld` = '%d', `SpawnX` = '%f', `SpawnY` = '%f', `SpawnZ` = '%f', `SpawnInterior` = '%d', `SpawnVW` = '%d'",
		SQL_ReturnEscaped(CompanyData[companyid][companyName]),
		CompanyData[companyid][companyColor],
		CompanyData[companyid][companyType],
		CompanyData[companyid][companyRanks],
		CompanyData[companyid][companyInformationPos][0],
		CompanyData[companyid][companyInformationPos][1],
    	CompanyData[companyid][companyInformationPos][2],
		CompanyData[companyid][companyInformationInt],
		CompanyData[companyid][companyInformationWorld],
		CompanyData[companyid][companyPurchasePos][0],
		CompanyData[companyid][companyPurchasePos][1],
    	CompanyData[companyid][companyPurchasePos][2],
		CompanyData[companyid][companyPurchaseInt],
		CompanyData[companyid][companyPurchaseWorld],

AW: MySQL Input line too long - Mencent - 16.07.2015

Hello!

You have to do that like this:

PHP код:



format(query,sizeof query,"UPDATE `companies` SET `companyName`='%s',`companyColor`=%d,`companyType`=%d,`companyRanks`=%d,`companyInformationX`=%.4f,",

SQL_RetrunEscaped(CompanyData[companyid][companyName]),CompanyData[companyid][companyColor],CompanyData[companyid][companyType],CompanyData[companyid][companyRanks],

CompanyData[companyid][companyInformationPos][0]);

format(query,sizeof query,"%s`companyInformationY`=%.4f,`companyInformationZ`=%.4f,//and so on",

query,CompanyData[companyid][CompanyInformationPos][1]

It is an example so you have to complete this.

- Mencent

Re: AW: MySQL Input line too long - Zens - 16.07.2015

Quote:

Originally Posted by Mencent

Hello!

You have to do that like this:

PHP код:



format(query,sizeof query,"UPDATE `companies` SET `companyName`='%s',`companyColor`=%d,`companyType`=%d,`companyRanks`=%d,`companyInformationX`=%.4f,",

SQL_RetrunEscaped(CompanyData[companyid][companyName]),CompanyData[companyid][companyColor],CompanyData[companyid][companyType],CompanyData[companyid][companyRanks],

CompanyData[companyid][companyInformationPos][0]);

format(query,sizeof query,"%s`companyInformationY`=%.4f,`companyInformationZ`=%.4f,//and so on",

query,CompanyData[companyid][CompanyInformationPos][1]

It is an example so you have to complete this.

- Mencent

For some reason I'm getting this error now,

Код:

C:\Users\Test\Desktop\roleplay.pwn(8229 -- 8254) : error 001: expected token: ",", but found ";"

This is line 8229 - 8254

Код:

Company_Save(companyid)
{
	format(query, sizeof(query), "UPDATE `companies` SET `companyName` = '%s', `companyColor` = '%d', `companyType` = '%d', `companyRanks` = '%d',",
		SQL_ReturnEscaped(CompanyData[companyid][companyName]),
		CompanyData[companyid][companyColor],
		CompanyData[companyid][companyType],
		CompanyData[companyid][companyRanks],
	format(query, sizeof(query), "%s `companyInformationX` = '%.4f', `companyInformationY` = '%.4f', `companyInformationZ` = '%.4f', \
    `companyInformationInt` = '%d', `companyInformationWorld` = '%d',",
		CompanyData[companyid][companyInformationPos][0],
		CompanyData[companyid][companyInformationPos][1],
    	CompanyData[companyid][companyInformationPos][2],
		CompanyData[companyid][companyInformationInt],
		CompanyData[companyid][companyInformationWorld],
	format(query, sizeof(query), "%s `companyPurchaseX` = '%.4f', `companyPurchaseY` = '%.4f', `companyPurchaseZ` = '%.4f', \
	`companyPurchaseInt` = '%d', `companyPurchaseWorld` = '%d',",
		CompanyData[companyid][companyPurchasePos][0],
		CompanyData[companyid][companyPurchasePos][1],
    	CompanyData[companyid][companyPurchasePos][2],
		CompanyData[companyid][companyPurchaseInt],
		CompanyData[companyid][companyPurchaseWorld],
	format(query, sizeof(query), "%s `SpawnX` = '%f', `SpawnY` = '%f', `SpawnZ` = '%f', `SpawnInterior` = '%d', `SpawnVW` = '%d',",
		CompanyData[companyid][SpawnX],
		CompanyData[companyid][SpawnY],
	    CompanyData[companyid][SpawnZ],
    	CompanyData[companyid][SpawnInterior],
		CompanyData[companyid][SpawnVW]
	);

Re: MySQL Input line too long - Zens - 16.07.2015

Fixed..