SA-MP Forums Archive
simple bug - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: simple bug (/showthread.php?tid=619996)



simple bug - StR_MaRy - 24.10.2016

hey guys why if i am in a clan and relog it will create another account ?

Код HTML:
public OnPlayerConnect(playerid)
{
gQuery[0] = (EOS);
	mysql_format(handle, gQuery, sizeof(gQuery), "SELECT `Name` FROM `players` WHERE `AName` = '%e' LIMIT 1", GetName(playerid));
	new Cache:result = mysql_query(handle, gQuery);
}

function OnPlayerRegister(playerid, password[])
{
	if(IsPlayerConnected(playerid))
	{
  		gQuery[0] = (EOS);
		mysql_format(handle, gQuery, sizeof(gQuery), "INSERT INTO `players` (`Name`,`AName`,`Password`) VALUES ('%e','%e','%e')", GetName(playerid), GetName(playerid), MD5_Hash(password));
		mysql_tquery(handle, gQuery, "", "");

		format(PlayerInfo[playerid][pPassword], 64, MD5_Hash(password));

		format(gString, sizeof(gString), "Te rugam sa scrii parola pentru logare mai jos:", GetName(playerid));
		ShowPlayerDialog(playerid, DIALOG_LOGIN ,DIALOG_STYLE_PASSWORD, "Logare", gString, "Logare", "Exit");
	}
	return 1;
}

function OnPlayerLoginIn(playerid, password[])
{
	if(IsPlayerConnected(playerid))
	{
		gQuery[0] = (EOS);
		mysql_format(handle, gQuery, sizeof(gQuery), "SELECT * FROM `players` WHERE `Name`='%e' AND `Password`='%e'", GetName(playerid), MD5_Hash(password));
		mysql_tquery(handle, gQuery, "WhenPlayerLogin", "i", playerid);
	}
	return 1;
}