Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 8th, 2012  |  syntax: C#  |  size: 1.06 KB  |  hits: 15  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. forward OnPlayerRegister(playerid,password[]);
  2. public OnPlayerRegister(playerid,password[])
  3. {
  4.     new EscapedText[60], name[MAX_PLAYER_NAME];
  5.     GetPlayerName(playerid, name, sizeof(name));
  6.     mysql_real_escape_string(password, EscapedText);
  7.     new query[128];
  8.     format(query, sizeof(query), "SELECT * FROM Users WHERE username = '%s'", name);
  9.     mysql_function_query(1, query, true, "RegisterAccount", "is", playerid,password);
  10.         return 1;
  11. }
  12. forward RegisterAccount(playerid,password[]);
  13. public RegisterAccount(playerid,password[])
  14. {
  15.         new name[MAX_PLAYER_NAME],query[128],squery[128];
  16.         GetPlayerName(playerid, name, sizeof(name));
  17.         format(squery, sizeof(squery), "SELECT * FROM Users WHERE username = '%s",name);
  18.         mysql_query(squery,0,0,1);
  19.         mysql_store_result();
  20.         if(mysql_num_rows() == 0){
  21.                 format(query, sizeof(query), "INSERT INTO Users (username, password, Admin) VALUES ('%s',MD5('%s'),0)",name,password);
  22.                 mysql_query(query,0,0,1);
  23.         }
  24.         else SendClientMessage(playerid, COLOR_PINK, "This account already exist.");
  25.         mysql_free_result();   
  26.         return 1;
  27. }