| Author |
 Topic  |
|
Morpheus73
Average Member
Denmark
597 Posts |
 Posted - 25 April 2002 : 08:22:32
|
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
|
lol - thanks Morph.
Nikkol |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 25 April 2002 : 17:18:47
|
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 |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 25 April 2002 : 18:44:28
|
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 |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 25 April 2002 : 19:27:47
|
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 |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 25 April 2002 : 20:21:10
|
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 |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 25 April 2002 : 20:39:36
|
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 |
|
|
|
XavierSlater
Junior Member
United Kingdom
137 Posts |
Posted - 28 April 2002 : 11:05:49
|
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
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 28 April 2002 : 11:13:01
|
That's on the "to do" list XavierSlater. Just haven't had time to work on it. 
Nikkol |
|
|
|
Morpheus73
Average Member
Denmark
597 Posts |
Posted - 28 April 2002 : 11:51:13
|
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.
|
|
|
|
XavierSlater
Junior Member
United Kingdom
137 Posts |
Posted - 30 April 2002 : 11:12:57
|
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?
|
|
|
|
Morpheus73
Average Member
Denmark
597 Posts |
Posted - 30 April 2002 : 13:05:16
|
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)
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 30 April 2002 : 18:10:13
|
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 |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 30 April 2002 : 18:14:02
|
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 |
|
|
|
XavierSlater
Junior Member
United Kingdom
137 Posts |
Posted - 30 April 2002 : 20:45:08
|
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
|
|
|
|
Topic |
|
Topic Locked
