QuoteReplyTopic: Application Integration Posted: 09 February 2004 at 2:00am
Hello,
I am using WWF 7.6.... We are currently integrating the forum into our website and also trying to integrate the username/password into the web application we use on this site also... but for the application to check the password in the db, its cant since this is encrypted... so everyone would get an error trying to login... Is it possible to find the routine for this? Or is there something else i can do?? PLEASE HELP!! We may have wasted alot of time here already but i hope not... Thanks in advance... JR
I am using WWF 7.6.... We are currently integrating the forum into our website and also trying to integrate the username/password into the web application we use on this site also... but for the application to check the password in the db, its cant since this is encrypted... so everyone would get an error trying to login... Is it possible to find the routine for this? Or is there something else i can do?? PLEASE HELP!! We may have wasted alot of time here already but i hope not... Thanks in advance... JR
It still amazes me that people still follow the track of integration which involves authenticating against the WWF tables, or feel that is the only approach.
We have successfully, and very easily, integrated our shop app, member area and associated apps with WWF by authenticating against our own database and leaving the WWF alone.
When we login to the site all we have to do is set the WWF UID cookie .. and everything is done.
The ONLY coding that was involved was setting a trigger on our own customer table which copies across member details from our tables to WWF .. and it wasn't a complicated trigger.
Im going to try the same approach. I agree, it's a simplier tactic. Unfortunately I'm not using a SQL database for my current user database. It's an Access database. Do you have an ASP include of the code you used to replicate the information into WWF's tables?
Im going to try the same approach. I agree, it's a simplier tactic. Unfortunately I'm not using a SQL database for my current user database. It's an Access database. Do you have an ASP include of the code you used to replicate the information into WWF's tables?
I know I (and others) would appreciate it.
No ... not as an ASP page.
As it is an SQL trigger it occurs at the database level ... so whenever we add a customer record to our table, it automatically populates the WWF Author table.
For example, our trigger on insrt calls the following stored procedure:
Sorry for bumping an old thread, but I am interested in the topic here.
I have an ASP.NET site that I want to integrate with the Web Wiz Forums in the same way the original poster did. My site's Users table has basically the same information as tblAuthors, so there is no point me keeping both tables.
I have disabled the encrypted passwords feature, so when someone clicks my normal login, I simply point them to the WWForums login page. When they register, I point them to the WWForums registration page. It's all pretty simple so far.
But, when my other pages want to know who the currently logged in user is, how do I check? I understand there is a "UID" cookie that stores info on the current user. Do I simply take that value and check it against the User_code field in tblAuthors?
That should be the only processing I need to do. Thanks in advance for helping!
Im going to try the same approach. I agree, it's a simplier
tactic. Unfortunately I'm not using a SQL database for my current
user database. It's an Access database. Do you have an ASP
include of the code you used to replicate the information into WWF's
tables?
I know I (and others) would appreciate it.
No ... not as an ASP page.
As it is an SQL trigger it occurs at the database level ... so
whenever we add a customer record to our table, it automatically
populates the WWF Author table.
For example, our trigger on insrt calls the following stored procedure:
Hi,
Do you have a separate page aside from the forum settings (profile)
where a user can update/edit their password? or other personal
information? If so, do you also have a trigger to update the
tblAuthor table when they occur? Is there an example of
such? I have my own profile update page which I'd need to keep,
and have any changes made on this page be reflected in the forum
profile as well. I will disable the ability to make those changes
on the forum profile which can also be done on my original profile page
(username, password, realname, email, dob, etc) and allow update
ability on forum specific items ( avatar, signature, etc). Sorry
for the lengthy reply.
As it is an SQL trigger it occurs at the database level ... so whenever we add a customer record to our table, it automatically populates the WWF Author table.
For example, our trigger on insrt calls the following stored procedure:
CREATE PROCEDURE sp_AddUserForum <snip>
End GO
Hi, Do you have a separate page aside from the forum settings (profile) where a user can update/edit their password? or other personal
Yes. My own profile page had all the personal/contact inforamtion collected. The forum profile page has been edited to only show things like ICQ/AIM/preferences etc.
information? If so, do you also have a trigger to update the tblAuthor table when they occur? Is there an example of such? I have my own
Yes ... spot on. Have an update trigger on our Customer table
profile update page which I'd need to keep, and have any changes made on this page be reflected in the forum profile as well. I will disable the ability to make those changes on the forum profile which can also be done on my original profile page (username, password, realname, email, dob, etc) and allow update ability on forum specific items ( avatar, signature, etc). Sorry for the lengthy reply.
I think your integration solution is the simplest I've see yet. I like that! is it possible for you to share here the code you use to set the WWF cookie on your other applications login page, of course leaving out any details for security. I have looked through the common.asp and fail to see what needs to take place cookie-wise for a user to not have to login.
I am not very familiar with using cookies
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.
Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.
Topic Options
Post Options
Thanks(0)
OR_JR wrote:
