Код 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;
}