error 017: undefined symbol "INSERT"

error 017: undefined symbol "INSERT" - 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 017: undefined symbol "INSERT" (/showthread.php?tid=631140)

error 017: undefined symbol "INSERT" - Johangelo1 - 23.03.2017

How can i fix this?

Код:

MG.pwn(10494) : error 075: input line too long (after substitutions)
MG.pwn(10495) : error 037: invalid string (possibly non-terminated string)
MG.pwn(10495) : error 017: undefined symbol "INSERT"
MG.pwn(10495) : error 017: undefined symbol "INTO"
MG.pwn(10495) : fatal error 107: too many error messages on one line

PHP код:



format(Query, sizeof(Query), "INSERT INTO `users` (`name`, `password`, `ip`,`registro`,`score`, `dinero`, `admin`,`kills`, `deaths`, `jail`, `jailsec`, `skin`, `Turbo`, `Radio`, `Autofix`, `Nivel`, `Experiencia`,`MonsterKills`, `Color`, `Headshot`,`Horas`, `Minutos`, `Segundos`, `DuelosWins`,`VIP`, `VIPTIME`,`CHATCOLOR`, `RACE`,`HOUSES`, `CONNECTED`, `PLAYERID`, `LCONNECT`, `POSX`, `POSY`, `POSZ`) VALUES ('%s','%s','%s,'%s',0,0,0,0,0,0,0,0,0,'1',0,0,0,0,'-1',0,0,0,0,0,0,0,'16777215',0,0,1,'%d',0,0,0,0)",


DB_Escape(PI[playerid][JugadorNick]),DB_Escape(hashpass),

PlayerIP(playerid),PI[playerid][registro],playerid);

                    

 db_query(_DB_, Query);

I did it that way and the error still persists

PHP код:



format(Query, sizeof(Query), "INSERT INTO `users` (`name`, `password`, `ip`,`registro`,`score`, `dinero`, `admin`,`kills`, `deaths`, `jail`, `jailsec`, `skin`, `Turbo`, `Radio`, `Autofix`, `Nivel`, `Experiencia`,`MonsterKills`, `Color`, `Headshot`,`Horas`, `Minutos`, `Segundos`, `DuelosWins`, \

                    `VIP`, `VIPTIME`,`CHATCOLOR`, `RACE`,`HOUSES`, `CONNECTED`, `PLAYERID`, `LCONNECT`, `POSX`, `POSY`, `POSZ`) VALUES ('%s','%s','%s,'%s',0,0,0,0,0,0,0,0,0,'1',0,0,0,0,'-1',0,0,0,0,0,0,0,'16777215',0,0,1,'%d',0,0,0,0)",


DB_Escape(PI[playerid][JugadorNick]),DB_Escape(hashpass),

PlayerIP(playerid),PI[playerid][registro],playerid);

                    

 db_query(_DB_, Query);

HELP ME!

Re: error 017: undefined symbol "INSERT" - Mencent - 23.03.2017

Hello.

Look at my post like here:
https://sampforum.blast.hk/showthread.php?tid=631025

Respuesta: Re: error 017: undefined symbol "INSERT" - Johangelo1 - 23.03.2017

Quote:

Originally Posted by Mencent

Hello.

Look at my post like here:
https://sampforum.blast.hk/showthread.php?tid=631025

But that is UPDATE as I do in this case?

Re: error 017: undefined symbol "INSERT" - Mencent - 23.03.2017

You can do it just like this.

Respuesta: Re: error 017: undefined symbol "INSERT" - Johangelo1 - 23.03.2017

I did it like that. What can you see as evil?

EDIT: Does not create the table

PHP код:



                    format(Query,sizeof(Query),"INSERT INTO `users` (`name`, `password`, `ip`,`registro`,`score`, `dinero`, `admin`,`kills`, `deaths`, `jail`, `jailsec`, `skin`, `Turbo`, `Radio`, `Autofix`, `Nivel`, `Experiencia`,`MonsterKills`, `Color`, `Headshot`,`Horas`, `Minutos`, `Segundos`, `DuelosWins`) VALUES ('%s','%s','%s,'%s',0,0,0,0,0,0,0,0,0,'1',0,0,0,0,'-1',0,0,0,0,0)",

                    DB_Escape(PI[playerid][JugadorNick]),DB_Escape(hashpass),PlayerIP(playerid),PI[playerid][registro],playerid);  

                    

                    format(Query,sizeof(Query),"%d, `VIP`, `VIPTIME`,`CHATCOLOR`, `RACE`,`HOUSES`, `CONNECTED`, `PLAYERID`, `LCONNECT`, `POSX`, `POSY`, `POSZ`) VALUES (0,0,'16777215',0,0,1,'%d',0,0,0,0)",

                    Query);   

                    

                    db_query(_DB_, Query);

Re: error 017: undefined symbol "INSERT" - Private200 - 23.03.2017

You are formatting Query with a new input. You are simply clearing the old value and inserting

Quote:

"%d, `VIP`, `VIPTIME`,`CHATCOLOR`, `RACE`,`HOUSES`, `CONNECTED`, `PLAYERID`, `LCONNECT`, `POSX`, `POSY`, `POSZ`) VALUES (0,0,'16777215',0,0,1,'%d',0,0,0,0)"

Go for:

PHP код:



strcat(Query, "INSERT INTO `users` (`name`, `password`, `ip`,`registro`,`score`, `dinero`, `admin`,`kills`, `deaths`, `jail`, `jailsec`, `skin`, `Turbo`, `Radio`, `Autofix`, `Nivel`, `Experiencia`,`MonsterKills`, `Color`,");

strcat(Query, "`Headshot`,`Horas`, `Minutos`, `Segundos`, `DuelosWins`,`VIP`, `VIPTIME`,`CHATCOLOR`, `RACE`,`HOUSES`, `CONNECTED`, `PLAYERID`, `LCONNECT`, `POSX`, `POSY`, `POSZ`");

strcat(Query, " VALUES ('%s','%s','%s,'%s',0,0,0,0,0,0,0,0,0,'1',0,0,0,0,'-1',0,0,0,0,0,0,0,'16777215',0,0,1,'%d',0,0,0,0)");

format(Query, sizeof(Query),  DB_Escape(PI[playerid][JugadorNick]),DB_Escape(hashpass), 

PlayerIP(playerid),PI[playerid][registro],playerid); 

                     

 db_query(_DB_, Query);

It should work.

Re: error 017: undefined symbol "INSERT" - Private200 - 25.03.2017

Did it get solved?

Re: error 017: undefined symbol "INSERT" - DobbysGamertag - 25.03.2017

Why on earth are you writing all those 0's to the database? Doesn't anyone use default values anymore?