[Melktert]

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;
}

[DarkSkull]

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

[Melktert]

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

PHP код:

    mysql_query(string); 


[DarkSkull]

Can you show us where you use the CheckAccountExists Function?

[DarkSkull]

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); 


[Melktert]

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...

[DarkSkull]

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;
} 


[Melktert]

After a few minutes of struggling...

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

PHP код:

new MySql = CheckMySQL(); 


[Melktert]

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;
} 


[DarkSkull]

PHP код:

new MySql;
CheckMySQL()
{
        MySql = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PASS);
} 


Try This: