[itachi]

Hello,

I need help with mysql table plase.

Код:

Registruj(playerid, const sheslo[])
{
	new heslo[64];
	mysql_escape_string(sheslo, heslo, handle);
	if (!KontrolaFormatu(heslo)) return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Registrбcia", "Zadaj svoje heslo\n(Dostupnй znaky: 0-9, a-Z)", "Ok", "Zruљ");
	new query[72+MAX_PLAYER_NAME+32];
	mysql_format(handle, query, sizeof(query), "INSERT INTO `ASystem` (nick, pass, hodnost, prihlaseny) VALUES ('%s', MD5('%s'), 0, 0)", Meno(playerid), heslo);
	mysql_query(handle, query);
	return 1;
}

My table not funciton :

Код:

CREATE TABLE IF NOT EXISTS `ASystem` (
  `nick` varchar(25) NOT NULL,
  `pass` varchar(64) NOT NULL,
  `hodnost` int(11) NOT NULL,
  `prihlaseny` int(11) NOT NULL,
  PRIMARY KEY (`nick`,`pass`,`hodnost`,`prihlaseny`),
  UNIQUE KEY `nick` (`nick`),
  UNIQUE KEY `pass` (`pass`),
  UNIQUE KEY `hodnost` (`hodnost`),
  UNIQUE KEY `prihlaseny` (`prihlaseny`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Thank you.

[ComDuck]

Код:

new query[72+MAX_PLAYER_NAME+32];

Код:

mysql_format(handle, query, sizeof(query), .... VALUES ('%s', MD5('%s'), 0, 0)", ... );

Why are you using MD5 without salting it? Let alone even using MD5 in the first place

Код:

mysql_query(handle, query);

mysql_query is deprecated. Please use the latest version of the MySQL plugin and the much safer natives that come with it.

I agree with ******, switch to a ready-made user management system that is more secure than this one. Or learn how to make a better one on your own with the latest functions.