MySQL dont want to select player name and password

MySQL dont want to select player name and password - 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 dont want to select player name and password (/showthread.php?tid=574273)

MySQL dont want to select player name and password - SandKing94 - 15.05.2015

<removed>

Re: MySQL dont want to select player name and password - Konstantinos - 15.05.2015

Why did you add "1" to the arguments? Just remove it as it takes an integer instead of the name as first argument.

TIP: It's recommended to update to R39-3.

Re: MySQL dont want to select player name and password - Evocator - 15.05.2015

What is this 1? Also update your mysql plugin.

Code:

new query[200];
mysql_escape_string(inputtext, password, Connection);

format(query,sizeof(query), "SELECT * FROM `account` WHERE `name` = '%s' AND `pass` = '%s'", name(playerid), inputtext);
mysql_function_query(Connection,query,true,"CheckPass","i",playerid);

Re: MySQL dont want to select player name and password - SandKing94 - 15.05.2015

Thanks