HELP MYSQL LOGIN!
#1

Hey i need help y am making my own mysql login and register system here is the problem

i dont know how to make in mysql the login.. take password of the inputtext in dialog... take password of the sql database... and if passworddialog = passwordsql
LOGIN!!
and else ... kick the player...

here is my code i dont know the problem

Код:
if(dialogid == 2)
  {
    if(response == 1)
		{
			new query[128];
			format(query, sizeof(query), "SELECT %d FROM jugadores WHERE nombre = %d LIMIT 1", inputtext, pname);
			mysql_query(query);
			mysql_store_result();
			if(mysql_fetch_row(inputtext)==1)
				{
				  SendClientMessage(playerid, COLOR_LIGHTBLUE, "** Has Sido Logueado Correctamente.");
					return 1;
				}
				else
				{
				  SendClientMessage(playerid, COLOR_LIGHTBLUE, "** Contraseсa Incorrecta.");
				  Kick(playerid);
				}
		}
		else
		{
		  SendClientMessage(playerid, COLOR_LIGHTBLUE, "** Has Cancelado. Tienes que loguear Obligatoriamente.");
		  Kick(playerid);
		}
    return 1;
  }
Reply


Messages In This Thread
HELP MYSQL LOGIN! - by Zafire2008 - 24.01.2010, 18:23
Re: HELP MYSQL LOGIN! - by Zafire2008 - 24.01.2010, 19:01
Re: HELP MYSQL LOGIN! - by Toney - 24.01.2010, 19:20
Re: HELP MYSQL LOGIN! - by Zafire2008 - 24.01.2010, 19:28
Re: HELP MYSQL LOGIN! - by Toney - 24.01.2010, 19:36
Re: HELP MYSQL LOGIN! - by Zafire2008 - 24.01.2010, 19:55
Re: HELP MYSQL LOGIN! - by Toney - 24.01.2010, 19:59
Re: HELP MYSQL LOGIN! - by Zafire2008 - 24.01.2010, 20:03
Re: HELP MYSQL LOGIN! - by Toney - 24.01.2010, 20:06
Re: HELP MYSQL LOGIN! - by Zafire2008 - 24.01.2010, 20:08

Forum Jump:


Users browsing this thread: 5 Guest(s)