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

OR_JR wrote: 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

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?

I know I (and others) would appreciate it.

wade-o wrote: 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:

CREATE PROCEDURE sp_AddUserForum
 @UserID int,
 @UserName varchar(60),
 @FirstName varchar(20),
  @LastName varchar(40),
 @Email varchar(50),
 @Password varchar(20),
 @City varchar(50),
 @State varchar(50),
 @Country varchar(50)
AS
Begin
 Insert into wwfAuthor (Author_ID,Group_ID,Username,Real_Name, User_Code, Password, Salt, Author_EMail, Show_EMail, Join_Date)
  Values
 (@UserID, 4, @UserName,  @Firstname + ' ' + @Lastname, @UserName + '1245FGH', @Password, 'GJDS456', @Email, 0, getdate() )

End
GO

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!

lamboap wrote: thekiwi wrote: wade-o wrote: <snip> 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: 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. Regards, Lambert