MySQL not inserting entries
#3

Quote:
Originally Posted by Stormalle
View Post
HTML Code:
Dialog:DIALOG_REGISTER(playerid, response, listitem, inputtext[])
{
	if(!response) return Kick(playerid);
	new passhash[257];
	SHA256_PassHash(inputtext, #SALT, passhash, sizeof passhash);
	pInfo[playerid][Password] = passhash;
	new query[256];
	format(query, sizeof(query), "INSERT INTO `users` (`Password`, `Name`, `IP`) VALUES ('%s', '%s', '%s')", passhash, pName[playerid], pInfo[playerid][IP]);
	gSQL = mysql_tquery(gSQL, query, "OnPlayerRegister", "i", playerid);
	Dialog_Show(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "alone", "Please enter your password.", "Enter", "Exit");
	return 1;
}
maybe try this
Dafak?


1.Print the query after formating it and check (debug)
2.Does OnPlayerRegister get called? (you can check with debug)
3.Check mysql_logs for any errors
Reply


Messages In This Thread
MySQL not inserting entries [RESOLVED] - by Aerotactics - 02.09.2018, 19:27
Re: MySQL not inserting entries - by Stormalle - 02.09.2018, 20:08
Re: MySQL not inserting entries - by Shinja - 02.09.2018, 23:35
Re: MySQL not inserting entries - by Aerotactics - 03.09.2018, 02:46
Re: MySQL not inserting entries - by solstice_ - 03.09.2018, 02:58
Re: MySQL not inserting entries - by Aerotactics - 03.09.2018, 03:14
Re: MySQL not inserting entries - by solstice_ - 03.09.2018, 03:22
Re: MySQL not inserting entries - by Aerotactics - 03.09.2018, 04:14
Re: MySQL not inserting entries - by Zeth - 03.09.2018, 05:00
Re: MySQL not inserting entries - by Calisthenics - 03.09.2018, 08:19
Re: MySQL not inserting entries - by Shinja - 03.09.2018, 13:01

Forum Jump:


Users browsing this thread: 2 Guest(s)