03.01.2015, 15:00
pawn Code:
case DIALOG_LOGIN:
{
if(!response)
{
SendClientMessage(playerid, RED, "You must login before you spawn!");
ShowDialog(playerid, DIALOG_LOGIN);
}
if(response)
{
new query[200], pname[24], escapepass[100];
GetPlayerName(playerid, pname, 24);
mysql_real_escape_string(inputtext, escapepass);
format(query, sizeof(query), "SELECT `user` FROM playerdata WHERE user = '%s' AND password = SHA1('%s')", pname, escapepass);
mysql_query(query);
mysql_store_result();
new numrows = mysql_num_rows();
if(numrows == 1)
{
MySQL_Login(playerid);
Muted[playerid] = 0;
SendClientMessage(playerid, GREEN, "You have successfully logged in");
new string[256];
Clan[playerid] = pInfo[playerid][pClan];
}