Help MYSQL - Printable Version

Help MYSQL - 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)
+--- Thread: Help MYSQL (/showthread.php?tid=419674)

Help MYSQL - devil shill - 01.03.2013

Dear Forum member...

I have a problem my script has MYSQL and everything is created on the DB
but i cant see the user accounts my SQL says it has no key and it has something to do with this:

Код:

format(query, sizeof(query), "SELECT `user` FROM `accounts` WHERE user = '%s' AND password = md5('%s')", Name(playerid), pass);

If someone can help me out it would be great

Re: Help MYSQL - devil shill - 02.03.2013

Could someone please help me its a lil urgent,

Thanks

Re: Help MYSQL - Djole1337 - 02.03.2013

The query bellow looks ok.

Re: Help MYSQL - devil shill - 02.03.2013

strange it may be on the webmin mysql side but thanks

Re: Help MYSQL - devil shill - 02.03.2013

May this could help also what im seeing.

Re: Help MYSQL - pwincessnog - 02.03.2013

You need to create a Primary Key attribute on the table for each entry.

Re: Help MYSQL - devil shill - 02.03.2013

Thanks for helping guys, had a bit to figure it out but i got it working ^^

[SOLVED]

Re: Help MYSQL - pwincessnog - 02.03.2013

Will you post how you solved it so others in the future can refer to this?

Re: Help MYSQL - Misiur - 02.03.2013

No password salting, not good

Re: Help MYSQL - Bicentric - 02.03.2013

Quote:

Originally Posted by Misiur

No password salting, not good

Plus he's using MD5. I know the problem is fixed but I strongly urge you to use a much better hashing method other than MD5, Whrilpool or SHA512 are both good even without salting.