PHP код:
SQL_AttemptLogin(playerid, const password[])
{
new
query[300],
buffer[129];
WP_Hash(buffer, sizeof(buffer), password);
format(query, sizeof(query), "SELECT `ID` FROM `accounts` WHERE `Username` = '%s' AND `Password` = '%s'", PlayerData[playerid][pUsername], buffer);
mysql_tquery(g_iHandle, query, "OnQueryFinished", "dd", playerid, THREAD_LOGIN);
}
//////////////////////////////////////////////////////////
Dialog:NewPass(playerid, response, listitem, inputtext[])
{
if (response)
{
if (isnull(inputtext))
return Dialog_Show(playerid, NewPass, DIALOG_STYLE_PASSWORD, "Ââåäè íîâèé ïàðîëü", "Áóäü ëàñêà, ââåäè íîâèé ïàðîëü.\n\nÇàì³òêà: Áóäü ëàñêà, âèêîðèñòîâóé ñêëàäíèé, áåçïå÷íèé ïàðîëü.", "Çì³íèòè", "³äì³íà");
static
buffer[129],
query[256];
WP_Hash(buffer, sizeof(buffer), inputtext);
inputtext[0] = '\0';
format(query, sizeof(query), "UPDATE `accounts` SET `Password` = '%s' WHERE `Username` = '%s'", buffer, PlayerData[playerid][pUsername]);
mysql_tquery(g_iHandle, query);
SendServerMessage(playerid, "Òè çì³íèâ ñâ³é ïàðîëü.");
}
return 1;
}
/////////////////////////////////////////////////////////////////////
Dialog:ChangePassword(playerid, response, listitem, inputtext[])
{
if (response)
{
if (isnull(inputtext))
return cmd_changepass(playerid, "\1");
static
buffer[129],
query[256];
WP_Hash(buffer, sizeof(buffer), inputtext);
inputtext[0] = '\0';
format(query, sizeof(query), "SELECT `Password` FROM `accounts` WHERE `Username` = '%s' AND `Password` = '%s'", PlayerData[playerid][pUsername], buffer);
mysql_tquery(g_iHandle, query, "OnQueryFinished", "dd", playerid, THREAD_VERIFY_PASS);
}
return 1;
}