SA-MP Forums Archive
mysql_query - argument type mismatch error - 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 - argument type mismatch error (/showthread.php?tid=632281)


mysql_query - argument type mismatch error - Melktert - 11.04.2017

error 035: argument type mismatch (argument 1)

Code:

Код:
CheckAccountExists(account[])
{
	new string[128];
	format(string, sizeof(string), "SELECT * FROM Users WHERE Name = '%s'", account);
	mysql_query(string);  // This line

	mysql_store_result();
	new value;
	value = mysql_num_rows();
	mysql_free_result();
	return value;
}


Re: mysql_query - argument type mismatch error - DarkSkull - 11.04.2017

PHP код:
CheckAccountExists(account[])
{
    new string[128];
    format(string, sizeof(string), "SELECT * FROM Users WHERE Name = %s", account);
    mysql_query(string);  // This line
    mysql_store_result();
    new value;
    value = mysql_num_rows();
    mysql_free_result();
    return value;
} 
Try it without the single quotes

Re: mysql_query - argument type mismatch error - Melktert - 11.04.2017

Still the same error. It's something to do with this line...

PHP код:
    mysql_query(string); 


Re: mysql_query - argument type mismatch error - DarkSkull - 11.04.2017

Can you show us where you use the CheckAccountExists Function?

Re: mysql_query - argument type mismatch error - DarkSkull - 11.04.2017

EDIT:
mysql_query has 2 mandatory arguments.
The first : Connection handle
The second : The query

https://sampwiki.blast.hk/wiki/MySQL/R33#mysql_query

PHP код:
mysql = mysql_connect("host", "user", "database", "pass");
mysql_query(mysql, query); 


Re: mysql_query - argument type mismatch error - Melktert - 11.04.2017

So this is my connection handle...

PHP код:
CheckMySQL()
{
        mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PASS);
} 
So I changed the code to

PHP код:
CheckAccountExists(account[])
{
    new string[128];
    format(string, sizeof(string), "SELECT * FROM Users WHERE Name = '%s'", account);
    mysql_query(checkmysql, string);  // This line

    mysql_store_result();
    new value;
    value = mysql_num_rows();
    mysql_free_result();
    return value;
} 
and i still get the same error...

Re: mysql_query - argument type mismatch error - DarkSkull - 11.04.2017

Change your connection handle to this
PHP код:
CheckMySQL()
{
        return mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PASS);
} 
On the top of the script just below the function add,

PHP код:
new MySql = CheckMySQL(); 
Then change your Function to this:

PHP код:
CheckAccountExists(account[])
{
    new string[128];
    format(string, sizeof(string), "SELECT * FROM Users WHERE Name = '%s'", account);
    mysql_query(MySql, string);  // This line
    mysql_store_result();
    new value;
    value = mysql_num_rows();
    mysql_free_result();
    return value;
} 


Re: mysql_query - argument type mismatch error - Melktert - 11.04.2017

After a few minutes of struggling...

This causes the Pawn Compiler Library to stop working...

PHP код:
new MySql = CheckMySQL(); 


Re: mysql_query - argument type mismatch error - Melktert - 11.04.2017

EDIT: This is probably where the errors come from...

PHP код:
SavePlayer(playerid)
{
    if(!PlayerLogged[playerid])
        return 0;

    UserStats[playerid][Money] = GetPlayerMoney(playerid);


    CheckMySQL();

    new string[256];
    format(string, sizeof(string), "UPDATE Users SET Password='%s',Money='%d' WHERE Name='%s'", UserStats[playerid][Password], UserStats[playerid][Money], UserStats[playerid][Name]);
    mysql_query(MySql, string);
    return 1;
} 


Re: mysql_query - argument type mismatch error - DarkSkull - 11.04.2017

PHP код:
new MySql;
CheckMySQL()
{
        MySql = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PASS);
} 
Try This: