Create Member Auth View

Article Topics: Setup

Creating a Mysql View allows for the list of active members to be directly related to the member table rather than have this information stored in a separate table. To create a Mysql view, either have you or your host run the following query:

CREATE VIEW member_auth_view AS SELECT member.memberid,member.username,member.password,member.cryptpass,member.siteid,member.networkid,identifier.tourid,identifier.optionid,identifier.programid,member.trial,member.token FROM member LEFT JOIN identifier ON member.identid=identifier.identid WHERE status=1

Once the View is created, authentication of your members area would look to this new table view "member_auth_view" rather than looking to "member_auth".

Please Note: Since Views do not have database keys, clients with a large amount of members should not consider using a MySQL view as this may cause performance problems on your server