Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Nikkols UserGroup Mod ALPHA
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 3

Morpheus73
Average Member

Denmark
597 Posts

Posted - 25 April 2002 :  08:22:32  Show Profile
Name: Usergroups ALPHA 02

Location: http://www.ls3k.com/snitz/mods.asp

Description: Usergroups for snitz. Still Nikkols version alpha, but permission working.

demo : demo of signup/moderation page (also there´s the whole admin/supermoderator stuff - demo later) - http://www.friserverplads.dk/openmedia/usergroups_signup.asp - login with guest/GUEST

New in Alpha 02

User-signup/signoff interface. Signup can be set for validation
Moderation - admin can assign moderators
View of members of individual groups
Global and local groups - usergroups have been transferred to use membertableprefix - groups can be set to either


More to come...

View Setting Show/hide members of groups/groups depending on admin setting
Forum to Forum sharing of groups - individual forums can share local usergroups even though they arent global

Hope someone can use this too

WARNING no security for handling setup on userinterface will be featured in ALPHA 03

morpheus73





Edited by - morpheus73 on 03 May 2002 19:22:39

Edited by - morpheus73 on 04 May 2002 06:50:42

Edited by - morpheus73 on 04 May 2002 06:51:21

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 25 April 2002 :  17:10:25  Show Profile
lol - thanks Morph.

Nikkol
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 25 April 2002 :  17:18:47  Show Profile
But it's missing a readme file. Here's are simple instructions:

Instructions for install:
1. Copy the two asp files over to your test forum folder.
2. Run admin_usergroups_setup.asp by typing the file name in your browser's address bar. This file adds the necessary tables to an ACCESS database. Once the file is run (without errors) you can delete the file.
3. Each text file included in the zip gives instructions on where and how to modify the asp files. 5 existing files must be modified: admin_home, inc_functions, pop_delete, post_info, and post.
4. After you've got the files modified, register a few test members. Then go to the Admin Options and click the link you made for UserGroup Manager. The group icon let's you add a new group. You will only be allowed to add groups to the allowed list of forums that have allowed list as the Auth type. Make a few test groups and play with assigning those test groups to certain forums.

Also, this was create for ACCESS databases only. Will only need a new setup file that works with MySQL and MS SQL, but I don't know the syntax.

Edited by - Nikkol on 25 April 2002 17:21:31
Go to Top of Page

Nathan
Help Moderator

USA
7664 Posts

Posted - 25 April 2002 :  18:44:28  Show Profile  Visit Nathan's Homepage
quote:

Also, this was create for ACCESS databases only. Will only need a new setup file that works with MySQL and MS SQL, but I don't know the syntax.



I think you could have combined the allowed users and allowed usergroups tables. . . . just add an extra column to distinguish beetween individual IDs and group ids. . . like the MEMBER_TYPE in the USERGROUPS_MEMBERS table. . . but No matter.

Disclaimer - I wrote this fill off the top of my head with no dbs reference, however, it may still work

dbs_usergroups.asp

Database Setup for Usergroups

[CREATE]
ALLOWED_USERGROUPS

USERGROUP_ID#int##
FORUM_ID#int##
[END]

[CREATE]
USERGROUPS
USERGROUP_ID
USERGROUP_NAME#varchar(100)##
USERGROUP_DESC#memo##
[END]

[CREATE]
USERGROUP_MEMBERS

USERGROUP_ID#int##
MEMBER_ID#int##
MEMBER_TYPE#int##
[END]


Nathan Bales
Snitz Exchange | Do's and Dont's
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 25 April 2002 :  19:27:47  Show Profile
Nathan, the reason why I didn't combine them was to make it as separate as possible from the original snitz base. That way it can be uninstalled a little easier. But yes, it can be done that way.

Thanks for the install code. Do you know if it preserves the primary key structure?

Nikkol
Go to Top of Page

Nathan
Help Moderator

USA
7664 Posts

Posted - 25 April 2002 :  20:21:10  Show Profile  Visit Nathan's Homepage
It makes USERGROUP_ID the Primary key of the USERGROUPS table.

The other tables would need a seperate column to have keys because the columns that exist will all have duplicate values.

Nathan Bales
Snitz Exchange | Do's and Dont's
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 25 April 2002 :  20:39:36  Show Profile
The only table that you need to worry about then is the USERGROUP_MEMBERS, since both users and usergroups can be members of a usergroup

Nikkol
Go to Top of Page

XavierSlater
Junior Member

United Kingdom
137 Posts

Posted - 28 April 2002 :  11:05:49  Show Profile  Visit XavierSlater's Homepage
I like this MOD a lot. It solves me an immediate problem for provdiding access to content based on usergroup for the rest of the website I am working on. I just have to figure out how yet...:-)

Would it be possible to assign a Moderator to manage a usergroup? So they can manage their own users, as well as Administrators?

Just thoughts?

Regards,

Stuart

Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 28 April 2002 :  11:13:01  Show Profile
That's on the "to do" list XavierSlater. Just haven't had time to work on it.

Nikkol
Go to Top of Page

Morpheus73
Average Member

Denmark
597 Posts

Posted - 28 April 2002 :  11:51:13  Show Profile
quote:

That's on the "to do" list XavierSlater. Just haven't had time to work on it.

Nikkol



I´m currently working on additions for this mod:

1. Usergroup moderation
2. User sign-up procedure depending on usergroup open or moderated
3. Canging it to use membertable header, so that usergroups can be shared across several forums.



Go to Top of Page

XavierSlater
Junior Member

United Kingdom
137 Posts

Posted - 30 April 2002 :  11:12:57  Show Profile  Visit XavierSlater's Homepage
quote:

<%
if Session(strCookieURL & "Approval") <> "number" then
scriptname = split(request.servervariables("SCRIPT_NAME"),"/")
Response.Redirect "admin_login.asp?target=" & scriptname(ubound(scriptname))
end if
%>



is the security arrangements for most of the admin functions, now what if this was to use User Groups instead.

What would I need to do to utilise the Usergroup number to give access to pages?

Thoughts?

Go to Top of Page

Morpheus73
Average Member

Denmark
597 Posts

Posted - 30 April 2002 :  13:05:16  Show Profile
I´m currently modifying the mod (in coordination with Nikkol) to use strmembertables instead of strForumTable so that usergroups can be shared like members can be shared - at the same time we are organizing the usergroups into Global groups,local groups and shared forum to forums groups + a function where memberlevels are chosen on a per forum level instead of membertable level - this enhances flexibility a lot. also a db table for setting for each forum is applied to handle wether - v1 was just the beginning the next updates will feature a lot more functions ( also Usergroup pending member, member, moderator and superModerator)

Go to Top of Page

Nathan
Help Moderator

USA
7664 Posts

Posted - 30 April 2002 :  18:02:59  Show Profile  Visit Nathan's Homepage
Hummm. . . wnat some help creating an n-level admin system?

Nathan Bales
Snitz Exchange | Do's and Dont's
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 30 April 2002 :  18:10:13  Show Profile
quote:

Hummm. . . wnat some help creating an n-level admin system?

Nathan Bales
Snitz Exchange | Do's and Dont's



Who you asking? I have way too many projects at work right now to concentrate on something of that magnitude, but I'd be happy to put in my two cents every now and then.

On another note (which may help with the n-level admin idea), I was going to rewrite the current usergroups so that group membership was checked at the beginning of the page and strung together like "3,8,10" (those would be the group ids) and then access to forums would be checked against the string (eliminating calls to the database).

Nikkol
Go to Top of Page

Nathan
Help Moderator

USA
7664 Posts

Posted - 30 April 2002 :  18:14:02  Show Profile  Visit Nathan's Homepage
I was asking Morph. But I now think that it would be wiser to wait till a usergroups system is solid before starting on a project of such . . . . intricacy.

Nathan Bales
Snitz Exchange | Do's and Dont's
Go to Top of Page

XavierSlater
Junior Member

United Kingdom
137 Posts

Posted - 30 April 2002 :  20:45:08  Show Profile  Visit XavierSlater's Homepage
Guys, I can appreciate all the wonderful work being put in, but a simple answer would have been nice...:-)

How do do I do it, how should I approach it, and can it be done.

Regards,

Stuart

Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000 Version 3.4.07