Guest User

Untitled

a guest
May 22nd, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.62 KB | None | 0 0
  1. RegisterPlayer(playerid)
  2. {
  3. if (IsPlayerConnected(playerid))
  4. {
  5. new playername[MAX_PLAYER_NAME],
  6. playerip[MAX_PLAYER_IP],
  7. password[MAX_PLAYER_PASSWORD];
  8.  
  9. GetPlayerName(playerid, playername, sizeof(playername));
  10. GetPlayerIp(playerid, playerip, sizeof(playerip));
  11.  
  12. strmid(password, MD5_Hash(PlayerRegInfo[playerid][pRegPassword]), 0, strlen(MD5_Hash(PlayerRegInfo[playerid][pRegPassword])), MAX_PLAYER_PASSWORD);
  13.  
  14. MySQLCheckDatabaseConnection();
  15.  
  16. debug("MySQL Report: Creating Account %s...", playername);
  17.  
  18. // Make shure that the Strings are correct
  19. mysql_real_escape_string(playername, playername);
  20. mysql_real_escape_string(password, password);
  21. mysql_real_escape_string(PlayerRegInfo[playerid][pRegEMail], PlayerRegInfo[playerid][pRegEMail]);
  22. mysql_real_escape_string(playerip, playerip);
  23.  
  24. format(bigquery, sizeof(bigquery), "INSERT INTO `"TABLE_PLAYERS"` (`name`, `password`, `eMail`, `ipAddress`, `displayName`, `registrationDate`, `gender`, `citizen`, `age`, `char`, `model`) VALUES ('%s', '%s', '%s', '%s', '%s', DATE_FORMAT(curdate(), '%%d/%%m/%%Y'), '%d', '%d', '%d', '%d', '%d')",
  25. playername,
  26. password,
  27. PlayerRegInfo[playerid][pRegEMail],
  28. playerip,
  29. playername,
  30. PlayerRegInfo[playerid][pRegGender],
  31. PlayerRegInfo[playerid][pRegCitizen],
  32. PlayerRegInfo[playerid][pRegAge],
  33. PlayerRegInfo[playerid][pRegChar],
  34. PlayerRegInfo[playerid][pRegModel]);
  35.  
  36. mysql_query(bigquery);
  37.  
  38. debug("MySQL Report: Player %s (%d) Created !", playername, playerid);
  39.  
  40. // Server Users
  41. ServerInfo[sUsers]++;
  42. UpdateServerStats("users",1);
  43. }
  44. return 1;
  45. }
Add Comment
Please, Sign In to add comment