Doing a select statement off the AMember db

Discussion in 'Integration' started by DavidPayer, Jan 9, 2008.

  1. DavidPayer

    DavidPayer New Member

    Joined:
    May 30, 2004
    Messages:
    7
    I am attempting an integration of AMember with Joomla (1.5 in legacy mode) using a module (http://hery.blaogy.org/2007/05/03/joomla-mysql-auth/ ) that will do a select off a mysql database for the username/password. I also just found out that my install of PhpMyAdmin doesn't work properly on my server at the moment so I will have to get the db column names here if possible.

    1) are the passwords encrypted in amembers db?

    2) what would the select statement be off the database for amember

    Here is the default one in the joomla mod's admin interface.:

    SELECT uid, concat(lname, ' ', fname) as name, username, email FROM users WHERE username='%{user}' and password=('{pass}')

    so I need the column names for firstname lastname username email and I need to know the table name (I know my prefix).

    Could anyone help me with this info? I am running the latest version of amember.

    DP

Share This Page