MYSQL login problem
#1

Hello guys. I have problems with my login script. My samp-server.exe crashes and there's nothing in server-log file.
Код:
public OnPlayerLogin(playerid,password[])
{

    MySQLCheckConnection();
    new string[128];
	MySQLFetchAcctSingle(GetPVarInt(playerid, "SQLID"), "Password", string);
	SetPVarString(playerid, "Passowrd", string);
	if(strcmp(ReturnPVarString(playerid, "Password"),password, true ) == 0 )
	{
		new Data[1024];
		new Field[64];
		new rcnt = 1;
		MySQLFetchAcctRecord(GetPVarInt(playerid, "SQLID"), Data);
		samp_mysql_strtok(Field, "|", Data);
		SetPVarInt(playerid, "Logged", 1);
		while (samp_mysql_strtok(Field, "|", "")==1)
		{
			if (rcnt == 3) SetPVarInt(playerid, "AdminLevel", strval(Field));
			rcnt++;
		}

	}
	else
	{
		ShowPlayerDialog(playerid,LOGIN_DIALOG,DIALOG_STYLE_INPUT,"Login","Љifa koju ste unjeli nije\nvazeca. Pokusajte ponovno!","Login","Izlaz");
	  SetPVarInt(playerid, "LogTries", GetPVarInt(playerid, "LogTries") + 1);
	  if(GetPVarInt(playerid, "LogTries") == 4)
		{
			SendClientMessage(playerid, ERROR_COLOR, "Previse puta ste unjeli pogresnu sifru. Kickani ste!");
			Kick(playerid);
		}
	}
	return 1;
}

Код:
public MySQLFetchAcctSingle(sqlplayerid, sqlvalname[], sqlresult[])
{
	new query[128];
	format(query, sizeof(query), "SELECT %s FROM players WHERE id = %d LIMIT 1", sqlvalname, sqlplayerid);
	samp_mysql_query(query);
	samp_mysql_store_result();
	if(samp_mysql_fetch_row(sqlresult)==1)
	{
		return 1;
	}
	return 0;
}

public MySQLFetchAcctRecord(sqlplayerid, sqlresult[]) // by Luk0r
{
	new query[64];
	format(query, sizeof(query), "SELECT * FROM players WHERE id = %d LIMIT 1", sqlplayerid);
	samp_mysql_query(query);
	samp_mysql_store_result();
	if(samp_mysql_fetch_row(sqlresult)==1)
	{
		return 1;
	}
	return 0;
}
Reply


Messages In This Thread
MYSQL login problem - by misko28 - 04.06.2010, 08:34
Re: MYSQL login problem - by DJDhan - 04.06.2010, 08:38
Re: MYSQL login problem - by misko28 - 04.06.2010, 08:42

Forum Jump:


Users browsing this thread: 1 Guest(s)