2. PHPRunner General questions
  3. User name and group in different tables
This topic is locked

User name and group in different tables

 		1/31/2007 12:50:36 PM
PHPRunner General questions
T
 tparki authorDevClub member

I need to run PHPRunner screens inside my CMS (e107) and in order to use the latter's user name and group to define which tables can be displayed by PHPRunner I have the problem that user name & password are in one table and user group in another with the two linked on ID defining group. Can I use the master/detail setup in some way to achieve the security I require? I do realise that users are going to have to login a second time to use the PHPRunner generated screens but that is a small price to pay for proper security.
Alexey admin 2/1/2007

Hi,
PHPRunner requires usergroups and usernames to be stored in the same table.
I recommend join these two tables in a query, create a view for this query in your database using CREATE VIEW command.

Then select this view as a Login table in PHPRunner.
T
 		tparki authorDevClub member 2/1/2007

Hi,

PHPRunner requires usergroups and usernames to be stored in the same table.
I recommend join these two tables in a query, create a view for this query in your database using CREATE VIEW command.

Then select this view as a Login table in PHPRunner.
T
 		tparki authorDevClub member 2/1/2007

Thanks, Alexey. Your reply gives me a clear idea as to what I need to do. I just need to get out the SQL manual and do it.

Cheers

Tim
A
 		asimha 8/24/2007

Hi,

PHPRunner requires usergroups and usernames to be stored in the same table.
I recommend join these two tables in a query, create a view for this query in your database using CREATE VIEW command.

Then select this view as a Login table in PHPRunner.


I am also trying to integrate with PHP Fusion which has it's own user table.
When you say "join the tables" is this possible when the other table is in a different database?
Thanks

Andre