Won't SELECT md5 - Printable Version

Won't SELECT md5 - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Won't SELECT md5 (/showthread.php?tid=186553)

Won't SELECT md5 - ajwar - 29.10.2010

Hi, why this don't load the MD5 PASSWORD ?

format(Query, sizeof(Query), "SELECT * FROM `playerinfo` WHERE `user` = '%s' AND `password` = MD5('%s')", escpname, inputtext);

I did the same in INSERT, and it inserts MD5 password in DB. But not here in selecting.

Re: Won't SELECT md5 - ajwar - 29.10.2010

anyone ?

Re: Won't SELECT md5 - s0nic - 20.03.2011

Ehh..try this and make sure that what your trying to select and whatnot is actually in your db:

pawn Код:

format(Query, sizeof(Query), "SELECT * FROM playerinfo WHERE user=%s AND password= MD5('%s')", escpname, inputtext);