MySQL R41
#1

Okay so here is the problem. When i enter server it requies password for registering. When i reconnect it is asking for password again. It won't create account..
here is dialogregister and OnPlayerRegister
PHP Code:
case DIALOG_REGISTER:
        {
            if(!
response)
            {
                return 
Kick(playerid);
            }
            if(
strlen(inputtext) <= 5)
            {
                
ShowPlayerDialog(playeridDIALOG_REGISTERDIALOG_STYLE_PASSWORD"Register""Your password needs to be longer that 5 characters""Register""Exit");
                return 
1;
            }
            for(new 
016i++)
            {
                
PlayerInfo[playerid][Salt][i] = random(94) + 33;
                
SHA256_PassHash(inputtextPlayerInfo[playerid][Salt], PlayerInfo[playerid][Password], 65);
                new 
query[221];
                
mysql_format(g_SQLquerysizeof(query), "INSERT INTO `players` (`username`, `password, `salt`), VALUES ('%e', '%s', '%e')"PlayerInfo[playerid][Name], PlayerInfo[playerid][Password], PlayerInfo[playerid][Salt]);
                
mysql_tquery(g_SQLquery"OnPlayerRegister""d"playerid);
            }
        }
        default: return 
0;
forward OnPlayerRegister(playerid);
public 
OnPlayerRegister(playerid)
{
    
PlayerInfo[playerid][ID] = cache_insert_id();
    
ShowPlayerDialog(playeridDIALOG_UNUSEDDIALOG_STYLE_MSGBOX"Registration""Account succesfully registered!\nYou have been automaticly logged in""Ok""");
    
PlayerInfo[playerid][IsLoggedIn] = true;
    
PlayerInfo[playerid][X_Pos] = DEFAULT_POS_X;
    
PlayerInfo[playerid][Y_Pos] = DEFAULT_POS_Y;
    
PlayerInfo[playerid][Z_Pos] = DEFAULT_POS_Z;
    
PlayerInfo[playerid][A_Pos] = DEFAULT_POS_A;
    
SetSpawnInfo(playeridNO_TEAM0PlayerInfo[playerid][X_Pos], PlayerInfo[playerid][Y_Pos], PlayerInfo[playerid][Z_Pos], PlayerInfo[playerid][A_Pos], 000000);
    
SpawnPlayer(playerid);
    return 
1;

Reply


Messages In This Thread
MySQL R41 - by Micko123 - 27.10.2016, 19:52
Re: MySQL R41 - by Vince - 27.10.2016, 19:55
Re: MySQL R41 - by Micko123 - 27.10.2016, 19:59
Re: MySQL R41 - by Micko123 - 27.10.2016, 20:04
Re: MySQL R41 - by Konstantinos - 27.10.2016, 20:11
Re: MySQL R41 - by Micko123 - 27.10.2016, 20:13
Re: MySQL R41 - by Konstantinos - 27.10.2016, 20:17
Re: MySQL R41 - by Micko123 - 27.10.2016, 20:24
Re: MySQL R41 - by Konstantinos - 27.10.2016, 20:26
Re: MySQL R41 - by Micko123 - 27.10.2016, 20:28

Forum Jump:


Users browsing this thread: 2 Guest(s)