Existing user database integration + segregation

Post Reply

Page 12 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
gariputro Members Profile Find Members Posts Newbie Joined: 17 October 2006 Location: United States Status: Offline Points: 13	Post Options Post Reply Quote gariputro Report Post Thanks(0) Quote Reply Topic: Existing user database integration + segregation 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

gariputro Members Profile Find Members Posts Newbie Joined: 17 October 2006 Location: United States Status: Offline Points: 13	Post Options Post Reply Quote gariputro Report Post Thanks(0) Quote Reply 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!

gariputro Members Profile Find Members Posts Newbie Joined: 17 October 2006 Location: United States Status: Offline Points: 13	Post Options Post Reply Quote gariputro Report Post Thanks(0) Quote Reply 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?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

gariputro Members Profile Find Members Posts Newbie Joined: 17 October 2006 Location: United States Status: Offline Points: 13	Post Options Post Reply Quote gariputro Report Post Thanks(0) Quote Reply 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?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

gariputro Members Profile Find Members Posts Newbie Joined: 17 October 2006 Location: United States Status: Offline Points: 13	Post Options Post Reply Quote gariputro Report Post Thanks(0) Quote Reply 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.

Post Reply	Page 12 >

Forum Jump

Forum Permissions View Drop Down

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