
Untitled
By: a guest on
May 8th, 2012 | syntax:
C# | size: 1.06 KB | hits: 15 | expires: Never
forward OnPlayerRegister(playerid,password[]);
public OnPlayerRegister(playerid,password[])
{
new EscapedText[60], name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name, sizeof(name));
mysql_real_escape_string(password, EscapedText);
new query[128];
format(query, sizeof(query), "SELECT * FROM Users WHERE username = '%s'", name);
mysql_function_query(1, query, true, "RegisterAccount", "is", playerid,password);
return 1;
}
forward RegisterAccount(playerid,password[]);
public RegisterAccount(playerid,password[])
{
new name[MAX_PLAYER_NAME],query[128],squery[128];
GetPlayerName(playerid, name, sizeof(name));
format(squery, sizeof(squery), "SELECT * FROM Users WHERE username = '%s",name);
mysql_query(squery,0,0,1);
mysql_store_result();
if(mysql_num_rows() == 0){
format(query, sizeof(query), "INSERT INTO Users (username, password, Admin) VALUES ('%s',MD5('%s'),0)",name,password);
mysql_query(query,0,0,1);
}
else SendClientMessage(playerid, COLOR_PINK, "This account already exist.");
mysql_free_result();
return 1;
}