Installing with Existing User Table
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8857
Printed Date: 07 April 2026 at 11:29am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Installing with Existing User Table
Posted By: Google
Subject: Installing with Existing User Table
Date Posted: 13 January 2004 at 1:28pm
|
I have a portal which has it's own users table, which obviously manages user profiles etc... I would like to integrate this forum with my existing user table [table name is "users"]. I've just briefly looked over the code and what it would take. I've come to the conclusion that it would be a new completly customized forum code.
Ordinarily this would be ok but would severly limit me in implementing any new bug fixes or new updates made to the forum code. I've noticed other FREE forums have this feature [use with existing user table]. What are my options at this point with Web Wiz Forums? Should I cutomize myself so I only have one users table [one for the portal] or wait until this feature is implemented? Thanks for any insight. |
Replies:
Posted By: ljamal
Date Posted: 13 January 2004 at 4:27pm
|
I don't think this feature will be implemented as this is the last major version of the ASP forum. I have implemented this and manage to keep up with the upgrades, but as this is the last major upgrade it shouldn't be a problem in the future. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: Google
Date Posted: 13 January 2004 at 4:38pm
|
What does this mean for the forum, are you suggesting that no more releases of this software will take place or are you suggesting that the next major release will be 8.0? You also mentioned that this won't be a problem in future. What exactly not be a problem, your keeping up with updates or that future releases of Web Wiz Forums will encorporate the feature I'm looking for. Would you mind shedding some light on how extensive the changes were to get this forum working with your existing users table. Thanks |
ljamal wrote:Posted By: ljamal
Date Posted: 13 January 2004 at 4:48pm
|
borg has stated that he is moving from ASP to ASP.Net with the forum, so this is to be the last version of the ASP forum unless there are major security hole found.
What I did to integrate the forum is use a SQL join to mesh my use table to a modified version of the WWF user table. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: Google
Date Posted: 13 January 2004 at 4:53pm
|
Ah, ok, .NET... Your SQL Join interests me. But you still would need to tweak most of the code to handle updates to wwf tables unless all interactions with db are via stored procs, in that case you simply edit the stored procs. If you did have to edit asp code which files did you see the most work being done on. thanks |
Posted By: ljamal
Date Posted: 13 January 2004 at 5:24pm
|
I use SQL which allows limited updates on JOINs, the only table affected is the Author table and the most updated field there is the last login field and the groupID.
Basically, I rename the WWF Author table and strip out all the redundant information. The create a joined table with the original name of the author table and join all the fields that were present in the original table. The only section that needed to be updated was the registration page and the member management admin stuff which I didn't need to use. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |