Error in function mysql_format

Error in function mysql_format - 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: Error in function mysql_format (/showthread.php?tid=565662)

Error in function mysql_format - RafaelOsio - 28.02.2015

Hello guys , I'm creating a login and registration system using MySQL database to save the information . The problem is that when using the mysql_format function, I use only 12 fields. Trying to save the 13 ° field , the compiler complains errors .

Using 12 fields:

Код:

      mysql_format(conexao, query, sizeof(query), "INSERT INTO players (Nick, Senha, Dinheiro, Skin, Level, IP, NivelProcura, AdmLvL, Profissao, Vip, Casa, Empresa) VALUES ('%s', '%s', '%i', '%i', '%i', '%s', '%i', '%i', '%s', '%i', '%i', '%i')", nome, inputtext, Player[playerid][Dinheiro], Player[playerid][Skin], Player[playerid][Level], Player[playerid][Ip], Player[playerid][Procurado], Player[playerid][LevelAdm], Profissao, Player[playerid][Vip], Player[playerid][Casa], Player[playerid][Empresa]);

Using 13 fields:

Код:

				mysql_format(conexao, query, sizeof(query), "INSERT INTO players (Nick, Senha, Dinheiro, Skin, Level, IP, NivelProcura, AdmLvL, Profissao, Vip, Casa, Empresa, Veiculo) VALUES ('%s', '%s', '%i', '%i', '%i', '%s', '%i', '%i', '%s', '%i', '%i', '%i', '%i')", nome, inputtext, Player[playerid][Dinheiro], Player[playerid][Skin], Player[playerid][Level], Player[playerid][Ip], Player[playerid][Procurado], Player[playerid][LevelAdm], Profissao, Player[playerid][Vip], Player[playerid][Casa], Player[playerid][Empresa], Player[playerid][Veiculo]);

The error that appears when using the 13 field.

Код:

error 075: input line too long (after substitutions)
error 017: undefined symbol "Em"
warning 217: loose indentation
error 017: undefined symbol "presa"
error 029: invalid expression, assumed zero
error 029: invalid expression, assumed zero
fatal error 107: too many error messages on one line

I honestly do not know what's causing it. I ask you to help me , please.

Re : Error in function mysql_format - simo0000 - 28.02.2015

Quote:

Originally Posted by RafaelOsio

Hello guys , I'm creating a login and registration system using MySQL database to save the information . The problem is that when using the mysql_format function, I use only 12 fields. Trying to save the 13 ° field , the compiler complains errors .

Using 12 fields:

Код:

      mysql_format(conexao, query, sizeof(query), "INSERT INTO players (Nick, Senha, Dinheiro, Skin, Level, IP, NivelProcura, AdmLvL, Profissao, Vip, Casa, Empresa) VALUES ('%s', '%s', '%i', '%i', '%i', '%s', '%i', '%i', '%s', '%i', '%i', '%i')", nome, inputtext, Player[playerid][Dinheiro], Player[playerid][Skin], Player[playerid][Level], Player[playerid][Ip], Player[playerid][Procurado], Player[playerid][LevelAdm], Profissao, Player[playerid][Vip], Player[playerid][Casa], Player[playerid][Empresa]);

Using 13 fields:

Код:

				mysql_format(conexao, query, sizeof(query), "INSERT INTO players (Nick, Senha, Dinheiro, Skin, Level, IP, NivelProcura, AdmLvL, Profissao, Vip, Casa, Empresa, Veiculo) VALUES ('%s', '%s', '%i', '%i', '%i', '%s', '%i', '%i', '%s', '%i', '%i', '%i', '%i')", nome, inputtext, Player[playerid][Dinheiro], Player[playerid][Skin], Player[playerid][Level], Player[playerid][Ip], Player[playerid][Procurado], Player[playerid][LevelAdm], Profissao, Player[playerid][Vip], Player[playerid][Casa], Player[playerid][Empresa], Player[playerid][Veiculo]);

The error that appears when using the 13 field.

Код:

error 075: input line too long (after substitutions)
error 017: undefined symbol "Em"
warning 217: loose indentation
error 017: undefined symbol "presa"
error 029: invalid expression, assumed zero
error 029: invalid expression, assumed zero
fatal error 107: too many error messages on one line

I honestly do not know what's causing it. I ask you to help me , please.

you can use this
http://www.solidfiles.com/d/2e7cd73b2c/zeex.rar
remplace those files in pawno
+rep if i helped

Re: Error in function mysql_format - RafaelOsio - 28.02.2015

thanks man. +rep for you