login register r41-2

[frostyk]

Salut, am incercat sa fac un sistem de login/register pe mysql r41-2. Nu imi da nicio eroare, dar cand intru sa ma loghez nu se salveaza contul in baza de date

Am creeat baza de date incorect sau?

frostyk.pwn

 

 

[frostyk]

accounts.sqlasta e baza de date

[Sancky]

verifica log-urile mysql

[Sancky]

mysql_format(handle, query, sizeof(query), "INSERT INTO `accounts` ('name', 'password') VALUES ('%e', '%e')", getname(playerid), inputtext);

 

aici ai pus apostrof la numele coloanelor, ori nu pui nimic, ori pui intre ``

 

mysql_format(handle, query, sizeof(query), "INSERT INTO `accounts` (`name`, `password`) VALUES ('%e', '%e')", getname(playerid), inputtext);

[frostyk]

4 minutes ago, Sancky said:

mysql_format(handle, query, sizeof(query), "INSERT INTO `accounts` ('name', 'password') VALUES ('%e', '%e')", getname(playerid), inputtext);

 

aici ai pus apostrof la numele coloanelor, ori nu pui nimic, ori pui intre ``

 

mysql_format(handle, query, sizeof(query), "INSERT INTO `accounts` (`name`, `password`) VALUES ('%e', '%e')", getname(playerid), inputtext);

tot asa e

 

[Sancky]

4 minutes ago, frostyk said:

tot asa e

 

da, nu trimiti query-ul catre mysql cum trebuie, acolo ai 'mysql_pquery(handle, "", "");', tu practic trimiti un query gol.

pune mysql_pquery(handle, query);

[frostyk]

mersi mult, acum functioneaza

[noddy28]

Try with this compiler
https://www.mediafire.com/file/nz6y1ixhjwjo0bd/Pawno-3.10.10-Custom.zip/file

Edited July 12, 2023 by noddy28

[Sancky]

1 minute ago, noddy28 said:

Try with this compiler
https://www.mediafire.com/file/nz6y1ixhjwjo0bd/Pawno-3.10.10-Custom.zip/file

don't post keyloggers here, if someone need the last version of the community compiler, is here: https://github.com/pawn-lang/compiler/releases

[noddy28]

1 minute ago, Sancky said:

don't post keyloggers here, if someone need the last version of the community compiler, is here: https://github.com/pawn-lang/compiler/releases

It is not keylogger, it is fixed compiler...My compiler was crashing when I was using from github it wasnt working.