[Johnson_boy]

Oh boy. It hurts to see how you deal with the passwords in this filterscript, and then release it to the public...

Passwords should never be hashed in the SQL query, nor should MD5 be ever used for hashing passwords.

[Mellnik]

Quote:

Originally Posted by Johnson_boy Oh boy. It hurts to see how you deal with the passwords in this filterscript, and then release it to the public... Passwords should never be hashed in the SQL query, nor should MD5 be ever used for hashing passwords.

I refer to https://sampforum.blast.hk/showthread.php?tid=496953

[Johnson_boy]

Quote:

Originally Posted by Mellnik I refer to https://sampforum.blast.hk/showthread.php?tid=496953

pawn Код:

stock CheckPlayerPassword(playerid, hash[])
{
    #if USE_MYSQL == true
    new query[256];
    mysql_real_escape_string(hash, hash);
    format(query, sizeof(query), "SELECT `Hash` FROM `"#MYSQL_TABLE"` WHERE `PlayerName` = '%s' AND `Hash`= MD5('%s')", GetName(playerid), hash);
    if(mysql_ping(gSQL))
    {
        mysql_query(query, _CHECK_PASSWORD, playerid, gSQL);
    }
    #else

I'm pretty sure the password is hashed in the query. Variable hash contains user input from the dialog, and is hashed using MySQL's MD5 function.

[aoEXE]

If I change '#define USE_MYSQL' to 'True', why returns this error?

Код:

Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase

Header size:           5296 bytes
Code size:           147048 bytes
Data size:           205224 bytes
Stack/heap size:       9600 bytes; estimated max. usage: unknown, due to recursion
Total requirements:  367168 bytes

I'm sorry for my bad English!

[satafinix]

Nice job

[iRaiDeN]

Nice!

[driftpower]

well done!

[SecretBoss]

Glad to see you here Mellnik
Also thanks for sharing this system is AMAZING , I hope you to keep it up

Black_and_red

[pitchooo]

Hello,
I have a problem with this admin system.
Use Garhouse, GangSystem
Once I put this system admin, I do not work properly these systems.
For example, I can not buy a house, I can not create the Ganges.
Write /gang goes my everything, but clicking anywhere in the window disappears.
Can anybody help me?
I apologize for bad English.
FS that I do not work:
Garhouse - By [03] Garsino.
GangSystem - http://www.samp-ru.org/load/filtersc...2_0/18-1-0-130

[SpikY_]

nice one! keep it up!

[GSTLX]

Very good！

[Sc0pion]

It's time for me to learn mysql, found a good system, but why the link no longer works? So bad :/

[Marv123]

Anyone have MellAdmin? If have PM me guys please I need melladmin