AuthMySQL Help

Hi, I am setting up a members area on my website and using authmysql to authenticate users against the mysql database.

I want to let expired members be able to login to the account, but not be able to view any of the media.

Heres what it looks like

/members/ "Users with expired accounts can login"
/members/media/ "Users with expired accounts cannot view the media"

I want to be able to do this with the user only logging in once.

I validate against a column called status in the DB to see if the member is expired or not.

Here is what I got, but its not working. Any help is much appricated it.

Thanks

Isn't media/ a directory, not a file?

I would guess that putting

inside /members/media/.htaccess would do it. Also consider making MySQL log queries so that you can inspect what authmysql is doing.

I need to have some kind of condition though, I want members to be able to login with expired users, but add another level of authenticaiton to check for status=1 when they try to view content in the media directory.

Thanks

Right. So the parent directory doesn't really have any conditions (no AuthMySQLUserConditions) while the media/ directory does.

I tried adding 2 htaccess files. One in the media folder with the condition and one in the members area without. But its still letting members with status != 1 view the content in media.

You're not including the <FilesMatch> right?

As a test, remove that authentication stuff in /members/.htaccess and put it all in /members/media/.htaccess instead, including the AuthMySQLUserConditions. Does that restrict you properly?