| Author |
 Topic  |
|
|
mafifi
Junior Member
USA
308 Posts |
 Posted - 10 June 2009 : 16:17:38
|
| I have a system of Records database and I would like to use it to register and authnticate forum users. How extensive the changes to the Snitz code? One or two files? |
Regards,
Mo |
Edited by - mafifi on 10 June 2009 16:18:10 |
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 11 June 2009 : 08:36:31
|
| Let me clarify my question. I have to use a Single Sign on (SSO) system that will hold the users information. Registration and authentication for the Snitz forum will be made on the SSO system. I am planning to host the M_NAME, M_USERNAME, M_PASSWORD and M_EMAIL on the SSO and keep the Snitz 'MEMBERS' table to hold all other user activities. A quick search thru the Snitz files, I found over 200 instances where there are DB calls that touches the 'MEMBERS' table. I may have missed few but I would very appreciate if any of the forum admins/contributors can confirm my findings and if there are other ways to accomplish this task but SSO is necessary. |
Regards,
Mo |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 June 2009 : 09:45:42
|
| It's hard to tell how many files include access to member's files. The way to approach this depends on what database you're using. With SQL Server, for example, I would just do everything database side: create a view emulating the forum members table and add triggers to handle additions, deletions and updates. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 11 June 2009 : 19:35:15
|
| Unfortunately, I can not use views. The database is Oracle and I am allowed to access it thru web services using SOAP 3.0 calls only. |
Regards,
Mo |
|
|
|
Carefree
Advanced Member
Philippines
4210 Posts |
Posted - 11 June 2009 : 20:09:40
|
quote:
Originally posted by mafifi
A quick search thru the Snitz files, I found over 200 instances where there are DB calls that touches the 'MEMBERS' table. I may have missed few but I would very appreciate if any of the forum admins/contributors can confirm my findings and if there are other ways to accomplish this task but SSO is necessary.
Actually, the default (non-modified) installation of Snitz 3.4.07 has 406 calls (using 51 files) to the member's table. |
Edited by - Carefree on 11 June 2009 20:10:20 |
|
|
| |
Topic |
|
Topic Locked
