SA-MP Forums Archive
MySQL Query failing with 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: MySQL Query failing with format. (/showthread.php?tid=397846)


MySQL Query failing with format. - FalconWingsX - 07.12.2012

Hi,

I am having some problems since I just changed my MySQL Plugin to the R7 and am having problems with the query.

So, here is the code ( the mysql_query is line 467):
pawn Код:
format(query, sizeof(query),"INSERT INTO playerdb (username,password,score,money,factionid,deaths) VALUES ('%s',md5('%s'),%d,%d,%d,%d)",playerdb[playerid][username],inputtext,1,5000,0,0);
        mysql_query(query);
And this is what I get from the compiler

Код:
.pwn(467) : error 017: undefined symbol "mysql_query"
I am using BlueG's R7 MySQL Plugin, tried to look up some help within the thread, but it was no help for me.

Re: MySQL Query failing with format. - Djole1337 - 07.12.2012

Probably wrong inc file.

Re: MySQL Query failing with format. - FalconWingsX - 07.12.2012

Checked both inc files, they are the same. Also, the plguin is the correct version.

I am pretty sure it's something wrong on the script. Just dont know what.

Re: MySQL Query failing with format. - Vince - 07.12.2012

Did you even bother searching? "Undefined symbol mysql_query" is bound to give you a ton of results.

Re: MySQL Query failing with format. - InfiniTy. - 07.12.2012

Blueg's MySQL plugin version R7 doesn't have mysql_query.
It has mysql_function_query.
There's a tutorial for R7 --> https://sampforum.blast.hk/showthread.php?tid=337810