tsturgeon
Posts: 7
|
| Posted: 03/15/2005, 8:02 AM |
|
Right now, the security (CCS 2.3.2.24) settings for the project force me to have all of the account information in one table.
However, since I am using a third-party's application database for the login information, I would like to add a new table with just 2 columns (userid, groupid), rather than extend the existing user table.
I do not want to add a field to the existing user table in case the third-party vendor updates their database schema. I just want to link my new table with their user table.
So, basically, where can I modify the select statement to join the two tables?
|
 |
 |
tsturgeon
Posts: 7
|
| Posted: 03/16/2005, 6:17 AM |
|
In the CCLoginUser($login, $password) of common.php is a $SQL variable holding the SQL statement.
Just edit this statement and do the appropriate joins to integrate the new group/user map table.
|
|
|
|
RonB
Posts: 228
|
| Posted: 03/17/2005, 12:11 PM |
|
depending on the features of the database you are using and the priveliges you have on that database you could make a view holding both tables and use the view for codecharge.
|
|
|
|
|
