| Author |
 Topic  |
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
 Posted - 15 August 2003 : 23:54:50
|
| Nikkol, just a thought, but why not just make it so you can define your own prefix for the group tables? Like Table and Members and the other one in config.asp... just add another line to it for the Usergroups. |
Reinsnitz (Mike) |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 16 August 2003 : 00:07:36
|
Ya, I made Deny permissions override any of the other settings.
So, what's your thinking on which of the tables would get the new prefix? There's the USERGROUPS table, the USERGROUPS_MEMBERS table (depends on members and usergroups) table and the ALLOWED_USERGROUPS table (which depends on both the forums and usergroups). So, which tables get which prefixes? |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 19 August 2003 : 21:21:00
|
I'd make it for all of them
Give the option to use a custom one or a new one... just set the variable line in the config.asp so the end user can make it different for every forum, or the same for every one :) Or use it in a custom application like I'm doing that I don't want mixed with the forum tables :)
That is a hard one to answer nikkol :) |
Reinsnitz (Mike) |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 22 August 2003 : 11:35:09
|
maby 2 groups? Make the actual Permissions table be the same as the FORUM tables... make the group table customizable... and the Members other one... um... whichever it makes sence :)
That would work realy well... so some of it ties to the forum specific... but allows for the groups and members to be shared with other forums, but keeps the stuff that is forum specific to the existing forum. |
Reinsnitz (Mike) |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 22 August 2003 : 11:44:30
|
Another bug found... post.asp: quote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[TCX][MyODBC]You have an error in your SQL syntax near 'AND USERGROUP_ID = 14' at line 1
/forum/post.asp, line 1365
This is where you create a new forum, in the littel box next to the statement: "UserGroup Permissions:"
There is a SQL statement here: if (arUGs(2,UGCnt) = 0 and mlev = 3) or mlev = 4 then
strSql = "SELECT PERMS FROM " & strTablePrefix & "ALLOWED_USERGROUPS " &_
"WHERE FORUM_ID = " & strRqForumID & " AND USERGROUP_ID = " & arUGs(0,UGCnt)
set rsPerms = my_Conn.execute(strSql)
I looked through the code, and couldn't find anything about "PERMS" anywhere but in that SQL statement.
Ideas? |
Reinsnitz (Mike) |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 22 August 2003 : 13:26:31
|
It's a great MOD :) this should be on every forum :)
Found Perms and am trying to figure it out :) |
Reinsnitz (Mike) |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 22 August 2003 : 13:55:52
|
Resulting SQL statement:quote:
SELECT PERMS FROM FORUM_ALLOWED_USERGROUPS WHERE FORUM_ID = AND USERGROUP_ID = 14
So for some reason the FORUM_ID is not showing up :( |
Reinsnitz (Mike) |
|
|
|
ajhvdb
Junior Member
Netherlands
392 Posts |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
Kal Corp
Average Member
USA
878 Posts |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 23 August 2003 : 10:21:54
|
| I didn't code it to, as I don't use a forum with NT/AD authentication. I can maybe look at that after I get the first version finalized. If you wanted to take a stab at it yourself, I believe we would need another "member type" in the USERGROUP_MEMBERS table for NT groups. The when checking if a member is a member of a usergroup, we would need to account for the nt groups too. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
dimitrisv
Starting Member
Greece
19 Posts |
Posted - 25 August 2003 : 11:24:21
|
Nikkol hi!
When are you going to release version 1?
I am considering using your mod but I preffer to wait until this release. Any plans? How can we help you to make it SQL 2000 compatible? Have you got a release with all the fixes to all the bugs reported here so far, in order to work with this?
Keep up the good work
Dimitris
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 25 August 2003 : 12:46:45
|
| i haven't heard that there were any problems with sql. you can read through this topic and see if anyone has reported anything. I've been meaning to release it soon but real life has been too demanding. Maybe Labor day weekend will allow me the time. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 25 August 2003 : 18:12:27
|
quote:
Originally posted by ajhvdb
I think this is related http://forum.snitz.com/forum/topic.asp?TOPIC_ID=46997
Did this and it now allows the creation of new forums/URL's.
When i went in to edit the forum however, I set hte permissions for all the groups within the "Edit Forum" screen. And it didn't save any of my settings? |
Reinsnitz (Mike) |
|
|
|
Topic |
|
Topic Locked
