Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- RegisterPlayer(playerid)
- {
- if (IsPlayerConnected(playerid))
- {
- new playername[MAX_PLAYER_NAME],
- playerip[MAX_PLAYER_IP],
- password[MAX_PLAYER_PASSWORD];
- GetPlayerName(playerid, playername, sizeof(playername));
- GetPlayerIp(playerid, playerip, sizeof(playerip));
- strmid(password, MD5_Hash(PlayerRegInfo[playerid][pRegPassword]), 0, strlen(MD5_Hash(PlayerRegInfo[playerid][pRegPassword])), MAX_PLAYER_PASSWORD);
- MySQLCheckDatabaseConnection();
- debug("MySQL Report: Creating Account %s...", playername);
- // Make shure that the Strings are correct
- mysql_real_escape_string(playername, playername);
- mysql_real_escape_string(password, password);
- mysql_real_escape_string(PlayerRegInfo[playerid][pRegEMail], PlayerRegInfo[playerid][pRegEMail]);
- mysql_real_escape_string(playerip, playerip);
- 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')",
- playername,
- password,
- PlayerRegInfo[playerid][pRegEMail],
- playerip,
- playername,
- PlayerRegInfo[playerid][pRegGender],
- PlayerRegInfo[playerid][pRegCitizen],
- PlayerRegInfo[playerid][pRegAge],
- PlayerRegInfo[playerid][pRegChar],
- PlayerRegInfo[playerid][pRegModel]);
- mysql_query(bigquery);
- debug("MySQL Report: Player %s (%d) Created !", playername, playerid);
- // Server Users
- ServerInfo[sUsers]++;
- UpdateServerStats("users",1);
- }
- return 1;
- }
Add Comment
Please, Sign In to add comment