I debated whether having the forum show or not. I ended up deciding to hide the forum if there are deny permissions. For the time being, you can edit inc_func_secure.asp so that it works as you expect it to. In the chkDisplayForum function just comment out these lines of code:
'####### Begin UserGroup MOD #######
if isDeniedMember(fForum_ID, UserNum) = 1 then
chkDisplayForum = false
exit function
end if
'####### End UserGroup MOD #######
However, beware that topic titles will then show on search.asp and maybe on active.asp as well.
This was just what I was looking for/expecting! Thanks, yet again!
vmplanet ... try this and let me know if it works for you:
first add the part in red to your connection string: strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME;option=16387" '## MySQL
then, find these lines in admin_usergroups.asp and add the line in red:
'## check for usergroup name uniqueness
set rsGroup = Server.CreateObject("ADODB.Recordset")
rsGroup.CursorLocation = 2
rsGroup.open strTablePrefix & "USERGROUPS", my_Conn, 1, 3, 2
rsGroup.AddNew
Excellent mod, thanks Nikkol. I have been toying with writing my own usergroup mod but tbh could not be bothered
Not sure if it was me not copying the full db script, but the first time I ran the forum with the mod installed on SQL server I recieved an error about the missing table: FORUM_USERGROUPS
I copied/pasted the db script again and it worked so not sure what went wrong.
thanks Ricci. Are you talking about using the full download, or on an existing forum where you had to copy and paste the text into the Alternate MOD box?
I used waynemr's SQl Server script in the Query Analyzer of Enterprise Manager and it set the tables up in a second flat. I have installed the mod on ServerHacker V9++ and so far it seems to work well, except I recently moved hosts and just propogated the DNS and seem to be plagued by the famous Cookies ghosts, but I don't think the mod is causing any problems. As I progress I will report further.
Clustered just creates a clustered index instead of a non-clustered one and textimage_on just has to do with moving blob fields to a different filegroup. I wouldn't worry much about these.
I see no need to use the script to create the tables. They are correctly created both if you use the dbs file or create a new forum altogether. The script posted here seems to show some precaution with performance by allowing different parts of the DB to be split between different filegroups, but I would guess that the other normal DB tables were changed as well.
Topic Locked
Posted - 23 June 2003 : 14:15:18
