[coole210]

How would i check if a username exists in MySQL?

[lolumadd]

Код:

new string[128];
format(string, sizeof(string), "SELECT `something` FROM `table` WHERE `name` = '%s'", Name);
mysql_query(string);
if(mysql_num_rows() > 0)
{
//account exists
return 1;
}
else
{
//doesnt exist
return 0;
}

[coole210]

alright thanks

[Kyosaur]

Quote:

Originally Posted by lolumadd Код: new string[128]; format(string, sizeof(string), "SELECT `something` FROM `table` WHERE `name` = '%s'", Name); mysql_query(string); if(mysql_num_rows() > 0) { //account exists return 1; } else { //doesnt exist return 0; }

You forgot to store the result ?

[coole210]

What do you mean? O.o

[lolumadd]

Oh yeah. Sorry.
To my code add:
mysql_store_result() after mysql_query

And after the last bracket add:
mysql_free_result()

[coole210]

What?

[coole210]

I need help with this now.. doesn't seem to work and i added a username called "Coole" in database

Код:

public OnPlayerConnect(playerid)
{
	new string[128];
 	format(string,sizeof(string),"SELECT * FROM `users` WHERE `Name` = '%s'",GetName(playerid));
	mysql_query(string,Connection);
	mysql_store_result(Connection);
	if(mysql_num_rows(Connection) > 0)
	{
	  ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"Login","Enter your password below","Login","Exit");
	}
 	else
	{
	  ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"Register","Enter your password below","Register","Exit");
	}
	mysql_free_result(Connection);
	return 1;
}

[coole210]

bump..

I am using 000webhost's MySQL feature if that tells you anything (i cant get the mysql to work on wamp)

[[HiC]TheKiller]

1. Make sure it connects to the server.
2. Make sure the player name variable is Name.
3. Make sure the table name is correct.

[coole210]

I made sure of everything, I know it connects (cuz of printf), I know the table name is correct, i know i added a field called "Coole" and i even tried LOWER(Name) and LOWER('%s')

.. Help?

[lolumadd]

mysql_store_result and mysql_free_result have 0 params. It is just mysql_store_result(); and mysql_free_result();

[coole210]

I've tried that too. it still won't work lol

[Antonio [G-RP]]

Quote:

Originally Posted by Coole[AG ] bump.. I am using 000webhost's MySQL feature if that tells you anything (i cant get the mysql to work on wamp)

I use 000webhost too

[coole210]

Here's my current script:

Код:

public OnPlayerConnect(playerid)
{
	new string[128];
 	format(string,sizeof(string),"SELECT * FROM Accounts WHERE LOWER(Username) = LOWER('%s')",GetName(playerid));
	mysql_query(string);
	mysql_store_result();
	if(mysql_num_rows() > 0)
	{
	  ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"Login","Enter your password below","Login","Exit");
	}
 	else
	{
	  ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"Register","Enter your password below","Register","Exit");
	}
	mysql_free_result();
	return 1;
}

Screeny:

[coole210]

bump

[lolumadd]

I dont what LOWER function does so..make it:

Код:

format(string,sizeof(string),"SELECT * FROM Accounts WHERE `username` '%s'",GetName(playerid));

(Also what mysql system thingy you use? It doesnt look like PHPmyadmin.)

[coole210]

It is PHPmyadmin

LOWER does this: COOLE would be coole and COole would be coole too so it loads LOWER username and LOWER Name of player

[coole210]

bump