Query not being called - Printable Version

Query not being called - 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: Query not being called (/showthread.php?tid=373872)

Query not being called - Bmxerlmao5288 - 31.08.2012

For my SQL Login system, It seems that my query is not being called.

Код:

new szQuery[256];
format(szQuery,sizeof(szQuery),"INSERT INTO `players` (kills,death,pass) VALUES(0,0,'%s')",pName(playerid), Password);
mysql_query(szQuery, mRegisterAccount, playerid);

Re: Query not being called - Camacorn - 31.08.2012

What MySQL plugin are you using?

Re: Query not being called - Emmet_ - 01.09.2012

Do the tables 'kills, death, and pass' exist in the MySQL database?

You can also try this (probably won't work, but try it anyway):

pawn Код:

new szQuery[256];
format(szQuery,sizeof(szQuery),"INSERT INTO `players` (name, kills, death, pass) VALUES('%s', '0', '0', '%s')",pName(playerid), Password);
mysql_query(szQuery, mRegisterAccount, playerid);

You only specified one string placeholder for the password, when you needed 2.
Be sure to create the 'name' table in your database!