Inserting New Members Directly
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=30306
Printed Date: 30 March 2026 at 10:08pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Inserting New Members Directly
Posted By: Live Music HQ
Subject: Inserting New Members Directly
Date Posted: 04 May 2012 at 10:20pm
|
I am updating my web site ( http://www.LiveMusicHQ.com - www.LiveMusicHQ.com) to require new user registrations for the main site. As part of this registration process, I'd like to automatically insert the required record(s) into my WebWiz forum table(s) to auto register the member into the forums using the same login as my main site. I wrote the site in classic ASP/VBscript with SQL Server for the database. And, I have no problem with the coding or SQL part, but before I started hacking away at this, I just wanted to see if anyone that has already done this (or is otherwise intimately familiar with the WebWiz forum database schema) can guide me through *which* table or tables I'll need to insert into and any caveats to be aware of in this process. Thanks! --Loren--
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 04 May 2012 at 10:23pm
|
You should use the Existing Member API already built in to Web Wiz Forums. See the page below for more information:- http://www.webwiz.net/web-wiz-forums/kb/existing-members-api.htm" rel="nofollow - http://www.webwiz.net/web-wiz-forums/kb/existing-members-api.htm
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Live Music HQ
Date Posted: 04 May 2012 at 10:26pm
| YES! That is the best possible answer. Thank you! |
Posted By: GhOs+
Date Posted: 05 January 2013 at 8:56am
|
Bruce, can you please help me understand the Member API a bit better -- the way I understand it is that the Forum will assume any USER, PASSWORD, and EMAIL session values passed to it are valid and create a username with the specified email. If the USER session value that is passed to the forum is already a member, that member's stats (points, etc) are used, correct? What happens in these situations: 1. The username is changed for a member on the member's record (in my user/registration table), is the new USER session passed to the Forum and a new username created? 2. The Email or the Password is changed for a member on the member's record (in my user/registration table), does it get changed/updated in the Forum Author table also - for the specific USER? The USER field in the forum must be unique, correct?
|
Posted By: WebWiz-Bruce
Date Posted: 06 January 2013 at 3:22pm
|
The API relies on the username. If you change the password or email address in the session variables passed to the forum it will update these in the forums database. The link between your system and the forum is the username. If you change the username on your system the link between the member accounts would be lost and a new member created in the forums database. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: GhOs+
Date Posted: 06 January 2013 at 4:17pm
very cool. 
|
Posted By: GhOs+
Date Posted: 15 January 2013 at 12:24pm
| I have more users in the forum than in the new database tables; is there any easy way to capture the username/password as users log in to the forum? The idea is to transfer them over to the new database, and the migration will be seamless for most users.I tried poking around the functions_login.asp and haven't been successful... |
Posted By: WebWiz-Bruce
Date Posted: 17 January 2013 at 6:31pm
|
There is not as passwords in Web Wiz Forums are 160bit one way encrypted along with a salt values, so is impossible to decode user passwords. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: GhOs+
Date Posted: 18 January 2013 at 11:14am
|
Right - what I had in mind was perhaps capturing the username/password as entered for a month or so and then migrating that to the new registration app, this way the most active users wouldn't have a password reset, and the transition would be seamless for most users.
I think I can see you shaking your head "no, not gonna happen", but I thought I'd ask perhaps you can point out where (ASP page and lines/variables) and what I can use to pick up this data (and perhaps save it to a text file outside of the public www folder) so I can use it later.
|