| Author |
 Topic  |
|
homeacademy
Junior Member
USA
163 Posts |
 Posted - 23 June 2003 : 14:15:18
|
quote:
Originally posted by Nikkol
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!  |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 23 June 2003 : 16:24:13
|
vmplanet, I'll have to investigate that. I'm not great with MySql syntax and such, so I'll post a solution when I find one.
BTW .. what value were you trying to enter for the group name? |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
Edited by - Nikkol on 23 June 2003 16:31:41 |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 23 June 2003 : 16:47:38
|
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 |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
Edited by - Nikkol on 23 June 2003 16:51:33 |
|
|
|
Ricci
Starting Member
1 Posts |
Posted - 23 June 2003 : 17:27:52
|
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. |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 23 June 2003 : 17:38:55
|
| 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? |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
vmplanet
Junior Member
112 Posts |
Posted - 23 June 2003 : 18:26:26
|
I get still an error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/forum/admin_usergroups.asp, line 84
line 84: rsGroup.open strSql, my_Conn, 3
The strange thing is the groups are there, but the forum is slow now.
|
|
|
|
vmplanet
Junior Member
112 Posts |
Posted - 23 June 2003 : 18:27:59
|
| The forum is fast again now, it because slow after making a group. When i make a group i get the error. But the group those get made. |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
DJBBIZ
Junior Member
214 Posts |
Posted - 23 June 2003 : 21:04:58
|
| 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. |
"The difference between good ideas and good results is performance"
the management institute | tmiFinance | tmiCreative | ProfileOnDemand |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 23 June 2003 : 22:48:13
|
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. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Carnivorous
Starting Member
5 Posts |
Posted - 24 June 2003 : 10:02:09
|
Thank you so much for this MOD! It's going to make life so much easier for us. Administration is going to be a breeze now.
THANKS! |
|
|
|
Topic |
|
Topic Locked
