Web Wiz Support and Community Forums : Existing user database integration + segregation https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 20:02:44 +0000 Fri, 20 Oct 2006 09:35:09 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=21637 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Existing user database integration + segregation : Looks good ]]> https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115859.html#115859 Author: WebWiz-Bruce
Subject: 21637
Posted: 20 October 2006 at 9:35am

Looks good Clap]]> Fri, 20 Oct 2006 09:35:09 +0000 https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115859.html#115859 <![CDATA[Existing user database integration + segregation : Well, I&#039;m happy to say that...]]> https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115849.html#115849 Author: gariputro
Subject: 21637
Posted: 19 October 2006 at 7:59pm

Well, I'm happy to say that after messing around with the code for the past 12 hours or so (my eyes hurt) I have a workable solution.  Is it the best possible solution?  Well, probably not, but I'm open to some guru taking my example, cleaning it up and writing it in as a feature in the future (attn: boRg Smile).  I resorted to using an SQL insert statement to change the database because I was having troubles with writing using rsCommon.

All modifications were done to functions_members_API.asp.  Line markers are estimates and may be off by a few.

Line 90 (insert):
Dim strGroup
Dim oldGroupID
 
Line 98 (insert):
'Get the current user group ID passed in your session; rename Group to whatever you called your session variable
strGroup = Session("Group")
 
Line 109 (replace):
strSQL = "SELECT " & strDbTable & "Author.Password, " & strDbTable & "Author.Salt, " & strDbTable & "Author.Username, " & strDbTable & "Author.Author_ID, " & strDbTable & "Author.User_code, " & strDbTable & "Author.Active, " & strDbTable & "Author.Login_attempt, " & strDbTable & "Author.Group_ID " & _
 
Line 139 (insert):
oldGroupID = rsCommon("Group_ID")
 
Line 194 (insert):
'If the Session Group_ID does not match that on record we need to overwrite it in the db
If NOT strGroup = oldGroupID Then 
  
  'Set the forum group ID number for an Existing Member
  'Check tblPermissions for values used below
  '1 = Adminsitrator (reserved for Admin only)
  '2 = Guest (default)
  '3 = Moderator (all User Admins)
  '4 = Newbie
  '5 = Operator
  '6 = Power User
 
  If strGroup = 1 or strGroup = 2 Then
    intForumStartingGroup = 5
  ElseIf strGroup = 3 Then
    intForumStartingGroup = 6
  ElseIf strGroup = 4 Then
    intForumStartingGroup = 3
  ElseIf strGroup = 9 Then
    intForumStartingGroup = 1
  Else
    intForumStartingGroup = 2
  End If
   
  'Setup SQL statement to update tblAUthor db with new Group_ID
  strSQL2 = "UPDATE " & strDbTable & "Author " & strRowLock & _
  " SET Group_ID=" & intForumStartingGroup & _
  " WHERE Author_ID =" & lngUserID & ";" 
   
  'Set error trapping
  On Error Resume Next
   
  'Write SQL query to the db
  adoCon.Execute(strSQL2)
   
  'If an error has occured write an error to the page
  If Err.Number <> 0 Then Call errorMsg("An error has occured while writing to the database.", "existingMemberAPI()_update_pass", "functions_member_API.asp")
      
  'Disable error trapping
  On Error goto 0
  
End If
 
*EDIT* Oops, I lied.  I made one addition to database_connections.asp for the SQL statement I ran.
Line 73 (insert):
Dim strSQL2


Edited by gariputro - 19 October 2006 at 8:02pm]]> Thu, 19 Oct 2006 19:59:30 +0000 https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115849.html#115849 <![CDATA[Existing user database integration + segregation : Found a solution, no. Have a theory,...]]> https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115753.html#115753 Author: gariputro
Subject: 21637
Posted: 18 October 2006 at 6:33pm

Found a solution, no.  Have a theory, yes!
 
I'll post back if I can figure out how to make this work.  I'm sure someone else can benefit from my sweat. Smile
]]> Wed, 18 Oct 2006 18:33:48 +0000 https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115753.html#115753 <![CDATA[Existing user database integration + segregation : Without going all through the...]]> https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115747.html#115747 Author: WebWiz-Bruce
Subject: 21637
Posted: 18 October 2006 at 5:30pm

Without going all through the code it looks like you might have found a solution yourself.

If you download the Access version and open the database you will get all the table names and field names so you shouldn't get them wrong.

All the table names and field names are the same no matter which database you are using.
]]> Wed, 18 Oct 2006 17:30:59 +0000 https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115747.html#115747 <![CDATA[Existing user database integration + segregation : Well, I by no means am an ASP...]]> https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115746.html#115746 Author: gariputro
Subject: 21637
Posted: 18 October 2006 at 5:25pm

Well, I by no means am an ASP programmer.  PHP, that's another story.
 
In looking at the code, I realize it wouldn't be a quick fix, but wouldn't it still be rather easy?  I would need to modify the SQL statement to also pull 'strDbTable & "Permissions.Group_ID"' from the Permissions table (this is all on a shared server which I have limited access to, so if I get a tbl name wrong, don't burn me), then read it as an rsCommon and overwrite it.  Have I oversimplified it?
]]> Wed, 18 Oct 2006 17:25:47 +0000 https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115746.html#115746 <![CDATA[Existing user database integration + segregation : It looks like a simple change...]]> https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115745.html#115745 Author: WebWiz-Bruce
Subject: 21637
Posted: 18 October 2006 at 5:11pm

It looks like a simple change may not do it and the API file may need to be re-written to accommodate the customisations you require. If you are unsure about ASP programming you may need to ask a developer about this.]]> Wed, 18 Oct 2006 17:11:29 +0000 https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115745.html#115745 <![CDATA[Existing user database integration + segregation : And now onto my question #2... How...]]> https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115744.html#115744 Author: gariputro
Subject: 21637
Posted: 18 October 2006 at 4:51pm

And now onto my question #2...
 
How can I update this the GroupID on the fly, so that when I change a user designation within my own login system, the next time that user logs in their GroupID is changed?
 
Your previous example works perfectly for users visiting the forum for the very first time.  Once I got that up and running, I copied and inserted the code to around line 172 in functions_members_API.asp and then inserted: 
 
rsCommon.Fields("Group_ID") = intForumStartingGroup
 
at line 182 (just before the rsCommon.Update) hoping that the user designation would be read from Session, converted to a GroupID number and rewritten to the database, just as a changed password would.  Doing this however, gives me an error message:
 
Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_existingMemberAPI()_update_pass
File Name:- functions_member_API.asp

Error details:-
ADODB.Recordset
Item cannot be found in the collection corresponding to the requested name or ordinal.
 
Did I miss something?
]]> Wed, 18 Oct 2006 16:51:45 +0000 https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115744.html#115744 <![CDATA[Existing user database integration + segregation : That is just the type of answer...]]> https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115699.html#115699 Author: gariputro
Subject: 21637
Posted: 17 October 2006 at 4:55pm

That is just the type of answer I was looking for!  I was hoping that someone would point me to a spot in the scripts where the group is assigned/checked.  I will give this a try.  Thanks boRg!]]> Tue, 17 Oct 2006 16:55:29 +0000 https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115699.html#115699 <![CDATA[Existing user database integration + segregation : The simplest way would be for...]]> https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115697.html#115697 Author: WebWiz-Bruce
Subject: 21637
Posted: 17 October 2006 at 4:39pm

The simplest way would be for you to edit the file functions_member_API.asp

At line 222 you will find the following line:-

intForumStartingGroup = CInt(rsCommon("Group_ID"))

This line gets the Gorup_ID number of the strating group to place the user in.

What you would need to do is change this so based on your login system if it is user A they are given the group ID of the group you want them to be in and another for group B users:-

If UserA Then
    intForumStartingGroup = 3
ElseIf UserB Then
    intForumStartingGroup = 4
End If

You can get the Group_ID number by looking in ten tblGroup table in the database and get the ID numbers for the groups you want to use.
]]> Tue, 17 Oct 2006 16:39:50 +0000 https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115697.html#115697 <![CDATA[Existing user database integration + segregation : I know it sounds confusing, so...]]> https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115693.html#115693 Author: gariputro
Subject: 21637
Posted: 17 October 2006 at 4:22pm

I know it sounds confusing, so let me explain.  I have a site that contains an existing SQL user database.  I already know how, and have performed, the function of using my existing user database as the forum members database:
http://forums.webwiz.net/forum_posts.asp?TID=19621&KW=integrate+user+database
 
Now that I have the forum setup and users are able to access it without logging in, I need the ability to control what the users see based on their rights within the website (see example):
 
User A logs into the website, visits the forum, and is only allowed to see section A of the forum
User B logs into the website, visits the forum, and is only allowed to see section B of the forum
 
I have the forum set up with group permissions and I have User A separate from User B in the SQL database based on a field where I store an access rights number (eg A=1, B=2, Admin=9, etc), so how do I pass that information to the forum and automatically assign them to a group when they visit, thereby restricting what they can view within the forum?


Edited by gariputro - 17 October 2006 at 4:23pm]]> Tue, 17 Oct 2006 16:22:29 +0000 https://forums.webwiz.net/existing-user-database-integration-segregation_topic21637_post115693.html#115693