[devil shill]

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

[devil shill]

Could someone please help me its a lil urgent,

Thanks

[Djole1337]

The query bellow looks ok.

[devil shill]

strange it may be on the webmin mysql side but thanks

[devil shill]

May this could help also what im seeing.

[pwincessnog]

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

[devil shill]

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

[SOLVED]

[pwincessnog]

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

[Misiur]

No password salting, not good

[Bicentric]

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.