All I want to do is verify if the player's POSTed "password" matches the password in their game account.
It appears that passwords are entered into the game database using:
Code: Select all
accounts (password)
VALUES (PASSWORD('%s'))
What do I need to do to verify that password? The following does not work:
Code: Select all
SELECT * FROM `accounts` WHERE id='$id' && password = PASSWORD($_POST[password])
Edit: Figured it out. =\ Spelling error. I've seriously been dealing with this for like 10 days. Gahhhhhh.