• Not to beat-up the author if sensitive "Allowed Member List" forum information suddenly becomes viewable by non-allowed members
• To help beta test this MOD to ensure it works in all environments

• UserGroups v1.0 BETA
• UserGroups v1.0 BETA - full (includes the Snitz 3.4.03 zip with bug fixes and UserGroups MOD preinstalled)

• Forum administrators can assign members to UserGroups and the use the UserGroups to restrict access to "Allowed Member List" forums based on three permission settings: Deny, Read-Only, and Allow.
• Forums that are not an "Allowed Member List" forum can have Deny and Read-Only permissions for each UserGroup.
• UserGroup visibility by members and moderators is configurable by forum administrators.
• Individual UserGroups can be set as Hidden.
• Auto-Join UserGroups on member registration.

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'FORUM_ID = AND USERGROUP_ID = 1'.

/ugtest/post.asp, line 1334

			strSql = "SELECT PERMS FROM " & strTablePrefix & "ALLOWED_USERGROUPS " &_
				"WHERE FORUM_ID = " & strRqForumID & " AND USERGROUP_ID = " & arUGs(0,UGCnt)
			set rsPerms = my_Conn.execute(strSql)
			strPerms = Null
			if not rsPerms.bof and not rsPerms.eof then strPerms = rsPerms("PERMS")
			rsPerms.close
			set rsPerms = Nothing

			strPerms = Null
			if strRqMethod = "EditURL" or strRqMethod = "EditForum" then
				strSql = "SELECT PERMS FROM " & strTablePrefix & "ALLOWED_USERGROUPS " &_
					"WHERE FORUM_ID = " & strRqForumID & " AND USERGROUP_ID = " & arUGs(0,UGCnt)
				set rsPerms = my_Conn.execute(strSql)
				if not rsPerms.bof and not rsPerms.eof then strPerms = rsPerms("PERMS")
				rsPerms.close
				set rsPerms = Nothing
			end if

CREATE TABLE [FORUM_USERGROUPS] (
	[USERGROUP_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[USERGROUP_NAME] [varchar] (100) NOT NULL ,
	[USERGROUP_DESC] [ntext] NOT NULL ,
	[USERGROUP_TYPE] [int] NOT NULL DEFAULT (0),
	[AUTOJOIN] [int] NOT NULL DEFAULT (0),
	[MEM_HIDE] [int] NOT NULL DEFAULT (0),
	[MOD_HIDE] [int] NOT NULL DEFAULT (0),
	CONSTRAINT [PK_FORUM_USERGROUPS] PRIMARY KEY  CLUSTERED 
	(
		[USERGROUP_ID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


CREATE TABLE [FORUM_USERGROUP_MEMBERS] (
	[USERGROUP_ID] [int] NOT NULL ,
	[MEMBER_ID] [int] NOT NULL ,
	[MEMBER_TYPE] [int] NOT NULL DEFAULT (1)
) ON [PRIMARY]
GO


CREATE TABLE [FORUM_ALLOWED_USERGROUPS] (
	[USERGROUP_ID] [int] NOT NULL ,
	[FORUM_ID] [int] NOT NULL ,
	[PERMS] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO

quote:

---

Originally posted by homeacademy

I may just be doing something wrong, or this may be normal, but:
Again using the full mod package, I created a normal, non-private, forum with deny usergroup permissions. I then logged in as my test member, and the new forum (with deny permissions) did not even show up in the forum list. I would expect this for Private (Hidden) forums, but for normal non-private forums? If I log out completely, and view the forum as a guest, I see the deny forum, but get the 'You Don't Have Access' message when clicking it. This is what I would expect to happen when logged in as well? Is this behaviour by design? TIA

---

'#######    Begin UserGroup MOD     #######
		if isDeniedMember(fForum_ID, UserNum) = 1 then
			chkDisplayForum = false
			exit function
		end if
'#######     End UserGroup MOD      #######

quote:

---

Originally posted by waynemr

In response to Nikkol:

It was done on an existing forum, so I did not use the full install of the MOD. I used the alternate MOD setup, which failed to create the needed tables. So, I added the tables in by hand.

BTW, the test forum I put this on has been significantly modded, and the usergroup mod still appears to function. I will run it through a number of tests tonight to make sure, and I will list all of the mods I have running so you can get some feedback on how this mod interacts with other mods.

---