Use mysql for register/load
#22

You do the saving in SaveUserStats, by using the MySQL UPDATE Query. %d is for numbers, %s is for strings.

You messed up the code a little bit, it will not work like this anymore.
Do the following:
Add to the enum:
Code:
pPassTmp[128],
OnPlayerConnect:
Code:
format(PlayerInfo[playerid][pPassTmp], 128, "");
And the two Dialogs to:
Code:
if(dialogid == DIALOG_REGISTER)
{
	//Se il giocatore seleziona Annulla/Esci
	if(!response) return Kick(playerid);

	//In tal caso l'utente inserisci una password troppo breve o non inserisce niente ritorna sullo stesso dialogo
	if(strlen(inputtext) < 3) return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Registrazione", "{FF0000}ERRORE:\n{000000}Hai inserito una password troppo corta\n{00FF00}Consiglio: Usa almeno 3 caratteri ed una password sicura!", "Continua", "Annulla");
	//Se va tutto bene inizierа a creare il giocatore nel database
	//MD5 и il protocollo di criptografia per la password (puoi anche rimuoverlo dalla stringa lasciandolo: ('%e', '%e')
	new infopass[145];
	format(infopass, sizeof(infopass), "{f8ff33}[INFO:]{00FF00} La tua password sarа: %s - puoi cambiarla con /cambiapassword", inputtext);
	SendClientMessage(playerid, 0xFFFFFF, infopass);
	format(PlayerInfo[playerid][pPassTmp], 128, inputtext);
	//Dopo di chи la query viene inviata e passa al dialogo successivo
	// email
	ShowPlayerDialog(playerid, DIALOG_REGISTER_EMAIL, DIALOG_STYLE_INPUT, "Registrazione", "{00FF00}Non manca molto:\n{000000}Inserisci una email per continuare\n{00FF00}INFO: Serve per proteggere il tuo account!", "Continua", "Annulla");
	return 1;
}

if(dialogid == DIALOG_REGISTER_EMAIL)
{
   
	//Se il giocatore seleziona Annulla/Esci
	if(!response) return Kick(playerid);
	//In tal caso l'utente inserisci una password troppo breve o non inserisce niente ritorna sullo stesso dialogo
	if(strlen(inputtext) < 5) return ShowPlayerDialog(playerid, DIALOG_REGISTER_EMAIL, DIALOG_STYLE_PASSWORD, "Registrazione", "{FF0000}ERRORE:\n{000000}Devi inserire una mail valide\n{00FF00}INFO: Servirа per proteggere meglio il tuo account!", "Continua", "Annulla");
	format(PlayerInfo[playerid][pEmail], 64, inputtext);
	//Dopo di chи la query viene inviata e passa al dialogo successivo
	// etа
	new query[256];
	mysql_format(handle, query, sizeof(query), "INSERT INTO users (name, password, email) VALUES ('%e', MD5('%e'), '%e')", PlayerInfo[playerid][pName], PlayerInfo[playerid][pPassTmp], inputtext);
	mysql_pquery(handle, query, "OnUserRegister", "d", playerid);
	format(PlayerInfo[playerid][pPassTmp], 128, "");
	return 1;
}
Then it should work like you want it.
Reply


Messages In This Thread
Use mysql for register/load - by OuDayas - 13.01.2019, 13:12
Re: Use mysql for register/load - by Jeffry - 13.01.2019, 13:20
Re: Use mysql for register/load - by OuDayas - 13.01.2019, 15:15
Re: Use mysql for register/load - by Jeffry - 13.01.2019, 15:55
Re: Use mysql for register/load - by OuDayas - 13.01.2019, 16:21
Re: Use mysql for register/load - by Jeffry - 13.01.2019, 17:51
Re: Use mysql for register/load - by OuDayas - 13.01.2019, 21:03
Re: Use mysql for register/load - by Jeffry - 14.01.2019, 19:52
Re: Use mysql for register/load - by codExpert - 14.01.2019, 20:40
Re: Use mysql for register/load - by OuDayas - 15.01.2019, 11:08
Re: Use mysql for register/load - by Jeffry - 15.01.2019, 18:15
Re: Use mysql for register/load - by OuDayas - 16.01.2019, 00:55
Re: Use mysql for register/load - by Jeffry - 16.01.2019, 16:54
Re: Use mysql for register/load - by OuDayas - 17.01.2019, 21:35
Re: Use mysql for register/load - by Jeffry - 19.01.2019, 11:37
Re: Use mysql for register/load - by OuDayas - 19.01.2019, 18:43
Re: Use mysql for register/load - by Stefhan - 20.01.2019, 02:28
Re: Use mysql for register/load - by Jeffry - 20.01.2019, 09:41
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 12:35
Re: Use mysql for register/load - by Jeffry - 20.01.2019, 13:37
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 14:35
Re: Use mysql for register/load - by Jeffry - 20.01.2019, 15:29
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 16:07
Re: Use mysql for register/load - by Jeffry - 20.01.2019, 16:15
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 19:27
Re: Use mysql for register/load - by SymonClash - 20.01.2019, 20:23
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 20:39
Re: Use mysql for register/load - by SymonClash - 20.01.2019, 20:45
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 20:55
Re: Use mysql for register/load - by SymonClash - 20.01.2019, 21:07
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 21:47
Re: Use mysql for register/load - by SymonClash - 20.01.2019, 22:11
Re: Use mysql for register/load - by SymonClash - 21.01.2019, 09:30
Re: Use mysql for register/load - by OuDayas - 21.01.2019, 22:58

Forum Jump:


Users browsing this thread: 2 Guest(s)