mysql login
#1

Hi, i have a problem with login after register.

At normal login it works, but at login after register it receives any password
Code:
	}
	if(dialogid == 100)
	{
        if(response)
        {
            if(strlen(inputtext))
            {
                if(strlen(inputtext) > 15 || strlen(inputtext) < 5)
		    	{
			    	SendClientMessage(playerid, COLOR_WHITE, "SERVER: Your password must be under 15 and above 5 characters.");
                    new regstring[128];
                    new regname[64];
                    GetPlayerName(playerid,regname,sizeof(regname));
                    format(regstring,sizeof(regstring),"Hello %s, welcome to the Server. You dont have an account.\n\nPlease register:\n\n",regname);
                    ShowPlayerDialog(playerid, 100, DIALOG_STYLE_PASSWORD,"Register",regstring,"Register","Exit");
		    	}
		    	else
		    	{
					new query[320];
	                new	hashedregister[129]; // de editat
		        	WP_Hash(hashedregister, 129, inputtext);
                    mysql_real_escape_string(inputtext,hashedregister);
					format(query, sizeof(query),"INSERT INTO `users` (`Username`, `Password`) VALUES ('%s', '%s')",returnName(playerid),hashedregister);
	    	    	mysql_function_query(mysqlh, query, false, "CreateDataBaseID", "");
			    	OnPlayerRegister(playerid,hashedregister);
			    }
			}
	    }
	    else
	    {
	        Kick(playerid);
		}
	}
    if(dialogid == 101 || dialogid == 102)
    {
        if(response)
        {
		    if(strlen(inputtext))
		    {
	            new	hashedinput[129];
		       	WP_Hash(hashedinput, 129, inputtext);
                mysql_real_escape_string(inputtext,hashedinput);
	            if(!strcmp(PlayerInfo[playerid][pKey], hashedinput, true, 129))
				{
                  	new szQuery[800];
                 	format(szQuery,	sizeof(szQuery),"SELECT * FROM `users` WHERE `Username` = '%s'", returnName(playerid));
                  	mysql_function_query(mysqlh, szQuery, true, "OnPlayerLogin", "is", playerid);
	            }
            	else
     	        {
	        gPlayerLogTries[playerid] += 1;
	        if(gPlayerLogTries[playerid] == 4) { Ban(playerid); }
	        return 1;
				}
			}
		}
	    else
	    {
	        Kick(playerid);
		}
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)