username  password        asd
kispisti  petikejelszava  125

#include <amxmodx>
#include <amxmisc>
#include <sqlx>
 
#define PLUGIN "MYSQL Login"
#define VERSION "1.0"
#define AUTHOR "IrOn"
 
#define TABLA felhasznalok
 
new Handle:g_SqlTuple
new g_error[512]
new sqllekerdezes[1024];
new asd[33];
new bool:onevan[33];
 
public plugin_init() {
	register_plugin(PLUGIN, VERSION, AUTHOR)
 
	register_concmd("amx_sqllogin", "SQLLogin");
 
	g_SqlTuple = SQL_MakeDbTuple("kiszolgalo","felhasznalo", "jelszo","adatbazis")
	new errorcode, Handle:SqlConnection = SQL_Connect(g_SqlTuple, errorcode, g_error, charsmax(g_error))
	if(SqlConnection == Empty_Handle) 
	{
		server_print("nemcsatlakozva")
		set_fail_state(g_error)
	}
	else
	{
		server_print("csatlakozva")
	}
	new Handle:Query
	Query = SQL_PrepareQuery(SqlConnection, "CREATE TABLE IF NOT EXISTS `iron` (`kiraly az iron` varchar(255) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8")
	SQL_FreeHandle(Query)
	SQL_FreeHandle(SqlConnection)
}
 
public SQLLogin(id)
{
	new felh[ 32 ];
   	read_argv( 1, felh, charsmax( felh ) );
 
	new jelszo[ 32 ];
   	read_argv( 2, felh, charsmax( jelszo ) );
 
	new dataid[1]
	dataid[0] = id
	formatex(sqllekerdezes, charsmax(sqllekerdezes), "SELECT * FROM TABLA WHERE username=^"%s^" AND password=^"%s^";", felh, jelszo)	
	SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", sqllekerdezes, dataid, 1)
}
 
public QuerySelectData(FailState, Handle:Query, error[], errorcode, data[], datasize, Float:fQueueTime)
{ 
	if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED)
	{
		log_amx("%s", error)
		return
	}
	else
	{
		new id = data[0];
		new asderteke = SQL_FieldNameToNum(Query, "asd")
		while(SQL_MoreResults(Query)) 
		{
			asd[id] = SQL_ReadResult(Query, asderteke)
			onevan[id]=true;
			SQL_NextRow(Query)
		}
		if(onevan[id])
			write("vanilyen páros")
		else
			write("nincsilyen páros")
	}
}