NATS4 Create Member Auth View
From TMM Wiki
Revision as of 22:32, 9 January 2013 by TmmStephen (talk | contribs) (Created page with "Creating a Mysql View allows for the list of active members be directly related to the member table rather than have this information storred in a separate table. To create a...")
Creating a Mysql View allows for the list of active members be directly related to the member table rather than have this information storred 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".
