| Author |
 Topic  |
|
Roger Fredriksson
Average Member
Sweden
556 Posts |
 Posted - 17 October 2005 : 12:54:29
|
| tribaliztic, it wouldn´t surprise me a bit if the solution is very simple. My solution has really nothing to do with the user groups mod, it only uses the tables usergroups and usergroups_member. As far as I can see the main disadvantage with my solution is that Zuel has to hard-code the number of which usergroup has accesss to the non-Snitz-page.< |
rf/www.avgifter.com |
 |
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 18 October 2005 : 20:17:30
|
quote:
Originally posted by Roger Fredriksson
tribaliztic, it wouldn´t surprise me a bit if the solution is very simple. My solution has really nothing to do with the user groups mod, it only uses the tables usergroups and usergroups_member. As far as I can see the main disadvantage with my solution is that Zuel has to hard-code the number of which usergroup has accesss to the non-Snitz-page.
Sorry, I haven't been around for a bit. Been working late and class.
I'll test it out now.< |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 18 October 2005 : 20:18:39
|
| Wait a minute...what is the connection_snitz.asp include file?< |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 19 October 2005 : 02:59:17
|
Probably the config.asp-page?
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Roger Fredriksson
Average Member
Sweden
556 Posts |
Posted - 19 October 2005 : 06:06:46
|
quote:
Originally posted by Zuel
Wait a minute...what is the connection_snitz.asp include file?
Remember that I am a non-pro-coder with code that works. I would appreciate if some Snitzer stepped in and gave you a pro-solution too.
The file connection_snitz.asp looks like this :
<%'Construct database path
sPath = Request.ServerVariables("Path_Translated")
'Response.Write ("sPath=" & sPath & "<br>")
sPath = Left(sPath,InStrRev(sPath,"\"))
'Open Connection and Recordset
set cnObj = Server.CreateObject("ADODB.Connection")
'Response.Write ("Create Object OK<br>")
cnObj.Open "Provider=Microsoft.Jet.OLEDB.4.0; User ID=Admin; Password=; Data Source=" & sPath & "../your_folder_for_db/name_of_your_db.mdb; Persist Security Info=True;"%>< |
rf/www.avgifter.com |
Edited by - Roger Fredriksson on 19 October 2005 13:28:24 |
|
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 21 October 2005 : 11:47:00
|
Sorry for the late response. Been working on a few other projects at the same time 
< |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 24 October 2005 : 03:34:15
|
Did you solve this or should I dig up my solution?
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 24 October 2005 : 09:41:01
|
| Not yet. Still playing around with it though.< |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 24 October 2005 : 10:09:13
|
Okay it is working!
Roger's method works except for a few things I had to change.
FORUM_USERGROUPS_MEMBERS doesn't exist. It is actually called FORUM_USERGROUP_USERS.
Also I get a syntax error when trying to set the ADO Constant. So I just commented that line out.
'adUseClient = 3
Everything else works as it should.
Also as a note, this will not pick up members who aren't assigned to any usergroup. Which is good, so if user is undefined then deny them.
Thanks Roger!< |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 24 October 2005 : 10:29:54
|
Awe, I tried to carry over the pages to the server and I get an internal server error. I can't get this line to point to my database correctly.
cnObj.Open "Provider=Microsoft.Jet.OLEDB.4.0; User ID=Admin; Password=; Data Source=" & sPath & "../your_folder_for_db/name_of_your_db.mdb; Persist Security Info=True;"%>< |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
Edited by - Zuel on 24 October 2005 10:30:40 |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 24 October 2005 : 10:49:22
|
Can't you use your already established connection from config.asp?
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Roger Fredriksson
Average Member
Sweden
556 Posts |
Posted - 24 October 2005 : 14:19:10
|
Tribaliztic, you are right. Delete the file connection_snitz.asp. In my first post with code: replace the line
ors.Open oSql, cnobj
with
oRS.Open oSql, strConnString
< |
rf/www.avgifter.com |
Edited by - Roger Fredriksson on 24 October 2005 14:21:39 |
|
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 25 October 2005 : 10:23:52
|
Bah, still get an internal server error with that. Man I wish I had debugging enabled on the server. I'm going to try to push for it.
I think I killed the server....it doesn't come up now.< |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
Edited by - Zuel on 25 October 2005 10:25:17 |
|
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 25 October 2005 : 10:36:24
|
Just talked to my website contact, he's going to try to push for debugging. I don't think the code killed the server I think there is a timeout feature that is causing the internal server errors.
I can't wait to fix the problem, I got it working on localhost perfect!< |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 16 November 2005 : 05:05:46
|
Well, I've stumbled upon some problems...
If I add a group to another group, then check the second group via the code in this thread, I get no hit. How does this work? =)
User1 is a member of usergroupA.
I have usergroupA and usergroupB, I add usergroupA INTO usergroupB, then check for User1 in usergroupB and get no hit.
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Topic |
|
Restrict Access on a Page
