| Author |
 Topic  |
|
K.Storm
Starting Member
Andorra
23 Posts |
 Posted - 08 March 2004 : 08:40:45
|
can't edit link as moderator, works fine as admin ??? 
why ??? it is going back to the links.asp
/k.storm< |
Edited by - K.Storm on 08 March 2004 15:09:19 |
 |
|
|
Jake 18
New Member
99 Posts |
Posted - 09 March 2004 : 00:11:26
|
In
Admin Section
Links Administration
Links Feature Configuration
is "Editing Allowed For:" set to "Admins, Moderators"?< |
|
|
|
K.Storm
Starting Member
Andorra
23 Posts |
Posted - 09 March 2004 : 03:00:33
|
quote:
Originally posted by Jake 18
In
Admin Section
Links Administration
Links Feature Configuration
is "Editing Allowed For:" set to "Admins, Moderators"?
that is set to moderators, still no edit of links, other than the links made by that user. Links Feature Configuration is set to Admins, Moderators and members... and still admin can edit all links..
/K.storm
< |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
K.Storm
Starting Member
Andorra
23 Posts |
Posted - 09 March 2004 : 06:43:31
|
quote:
What do you mean with "can't edit link as moderator"? Doesn't the Edit icon ( ) show up?
It works fine even on Beta 2, you can take a look at the demo forum I've set up: http://www.onewaymule.org/onewayscripts/lm3/
The edit icon is there, but when you click on the icon, you are send back to links.asp, i works for admin that can edit all and members that can edit there own links, but moderators can't edit at all.
i have looked on this part of the links.asp:
CASE "edit"
If Request.QueryString("id") = "" or IsNumeric(Request.QueryString("id")) = False Then Response.Redirect("links.asp")
intLinkID = Request.Querystring("id")
AllowEdit = 0
If mLev = 4 Then
AllowEdit = 1
End If
If intLMEdit > 0 and mLev >= 3 Then
AllowEdit = 1
End If
If mLev < 3 and strLMEdit = 2 Then
strsql = "SELECT MEMBER_ID FROM " & strTablePrefix & "LINKS WHERE LINK_ID= " & intLinkID
Set lrs = my_conn.execute(strsql)
If lrs.EOF Then
lrs.Close
Set lrs = Nothing
Response.Redirect("links.asp")
Else
lmID = lrs("MEMBER_ID")
lrs.Close
set lrs = nothing
End If
If lmID = getMemberID(Request.Cookies(strUniqueID & "User")("Name")) Then
AllowEdit = 1
End If
End If
If AllowEdit <> 1 Then
Response.Redirect("links.asp")
End If
it is here that it is going wrong
/K.storm
Ps: i'am using a MySQL 3.23.58 database< |
|
|
|
K.Storm
Starting Member
Andorra
23 Posts |
Posted - 09 March 2004 : 06:53:36
|
quote:
What do you mean with "can't edit link as moderator"? Doesn't the Edit icon () show up?
It works fine even on Beta 2, you can take a look at the demo forum I've set up: http://www.onewaymule.org/onewayscripts/lm3/
i have tryed your linkpage, and it is the same, try logon as user: moderator1 and pass: moderator1 and try to edit links !!!!!
/K.Storm< |
|
|
|
JakeG
Starting Member
USA
9 Posts |
Posted - 12 March 2004 : 00:14:42
|
OWM,
I must say I am very pleased with Beta 3 and I am looking forward to a full release. I have beta3 running at www.nthelp.org/forum/links.asp
I did find some problems, all were related to MySQL. I am using MySQL version 4.1.0 alpha. There are 3 main problems and I'll address each.
1. You already know about this one. "SHOW" is a reserved word in MySQL so the table creation scripts needed to be modifed to "SHOWLINK" and then all of your mod pages needed to be modified anywhere you built an SQLStr that had "SHOW =" in it.
2. I believe this is a new error for MySQL in 4.1.0A. If you open a recordset and return a Count(fieldname) MySQL returns the value as a String, not an integer.
This issue is with ALL of snitz forums so I already know how to fix this one.
Here is an example:
OLD CODE:
Approx Line 507 of Links.asp
Set RScounts = my_Conn.Execute(sqlcount)
rcounts = RScounts(0)
RScounts.Close
Set RScounts = Nothing
If rcounts <> 0 Then
NEW CODE Line 508 of Links.asp
rcounts = CInt(RScounts(0))
Notice the CInt() function surrounding the RS value. This needs to be done to EVERY RSCount() returned where you subsequently do a integer evaluation. Sometimes the RS name is different.
3. Your search box. For me it didn't work. The error was something about object doesn't support bookmarks. I fixed it though by doing this:
Approx Line 289 of Links.asp
objPagingRS.Open strSQL, my_Conn, adOpenStatic, adLockReadOnly, adCmdText
Right above it I added
objPagingRS.CursorLocation = adUseClient
Other than those issues everything went smoothly and I've been populating the cats/subcats/links. Here are a few suggestions.
1. While browsing a subcategory, turn the location display into a link. I am talking about the category name right above the Sort By box.
2. Add a drop down box on the Right side of bar that contains the cat and/or subcat (same as mentioned in item 1) that contains a list of other subcats in the same Category. Or categories if in a top level category. Then use a Go button to move between the cats without having to navigate back up the tree.
3. Sub-Sub-Categories.
Keep up the good work!
< |
- Jake
www.nthelp.org / www.computershowoff.com
Microsoft MVP - IIS
http://mvp.support.microsoft.com |
|
|
|
JakeG
Starting Member
USA
9 Posts |
Posted - 12 March 2004 : 00:22:37
|
I forgot one other problem.
Anywhere you did a SQL query against the members table, you need to strMemberTablePrefix instead of strTablePrefix while building the SQL query.
< |
- Jake
www.nthelp.org / www.computershowoff.com
Microsoft MVP - IIS
http://mvp.support.microsoft.com |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
JakeG
Starting Member
USA
9 Posts |
Posted - 12 March 2004 : 12:56:47
|
No prob. This thread is so long, I kind of sped-read most if it so I wasn't sure what had been actually documented.
I just thought of another suggestion as well. If you do or don't add this I might try and add it myself.
Cat/SubCat relationship link to a forum thread and vice-versa.
In my forums, I have this thread http://www.nthelp.org/forum/forum.asp?FORUM_ID=19
which I created a Links Cat/Subcat that matches at http://www.nthelp.org/forum/links.asp?action=showsubcat&id=23
Both are \Programming\ADSI For the most part most of my cats/threads will be relational.
In the links section I would add the link to the forum in the same Nav bar area where the Cat: SubCat (link count) is located. Saying something like "Go To Related Forum Area"
The relationship would have to be manually created in the properties of the Cat and/or Subcat, with a link to the forum thread.
Then in the Forum thread itself, I would put a link saying "Related Links" with the link icon next to it. This could be placed right next to where it says "New Topic"
Would it be possible to add the same relationship links to the Folder style menu at the top left? Next to the current level have "(Related Links)" or "(Related Forum)"
Just brainstorming here on how to setup the tables. I guess it would be easiest to create a new table that has the CatID, SubCatID, and RelationalLink (could be a link to someone elses forum or site for all I care). The query from the forum would check for entires matching the RelationalLink field and if 1 or more are found display the link. Then if 1 is found, go right to that cat or subcat. If more then 1, display the listed related cats/subcats (almost like a search I guess). I don't see why that couldn't be reversed as well to show multiple forum threads related to one links cat/subcat.
< |
- Jake
www.nthelp.org / www.computershowoff.com
Microsoft MVP - IIS
http://mvp.support.microsoft.com |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
JakeG
Starting Member
USA
9 Posts |
Posted - 12 March 2004 : 13:27:58
|
Not a problem!
I would agree somewhat on not linking to topics. But I don't want to limit to Forum_ID's only. I would like to have Links-Cats associate with Board-Cats, and Links-SubCats associate with Board-Forums.
The boards are setup like:
Category->Forum->Topic
and links are:
Category->SubCat->Link
So having a relationship at the same level and as well as to a different level would be nice.
Guess what, I have yet another suggestion. :)
1 link to multiple locations.
Example:
Both of the following subcats contain a link which I had to add twice. The link is to www.aspin.com
www.nthelp.org/forum/links.asp?action=showsubcat&id=10" target="_blank">http://www.nthelp.org/forum/links.asp?action=showsubcat&id=10
www.nthelp.org/forum/links.asp?action=showsubcat&id=11" target="_blank">http://www.nthelp.org/forum/links.asp?action=showsubcat&id=11
The problem with doing this is when you do a search for 'ASP', the link is returned twice because it exists twice. If I started adding more links like this my search results are going to be chock full of duplicates and possibly triplicates.
Heh, and you thought you were almost done with the final version. ;)
I know how it goes, I myself develop a free asp based IIS admin control panel. It's been downloaded quite a bit, but I don't get a whole lot of improvement suggestions. Maybe that's good because I've already added a lot of features and I am working on getting a new version out soon with even more features.
< |
- Jake
www.nthelp.org / www.computershowoff.com
Microsoft MVP - IIS
http://mvp.support.microsoft.com |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
Posted - 12 March 2004 : 13:45:03
|
quote:
I would agree somewhat on not linking to topics. But I don't want to limit to Forum_ID's only. I would like to have Links-Cats associate with Board-Cats, and Links-SubCats associate with Board-Forums.
..
So having a relationship at the same level and as well as to a different level would be nice.
Good idea.
quote:
Guess what, I have yet another suggestion. :)
1 link to multiple locations.
Hmmm... not sure about this one, I originally wanted to avoid having the same link submitted more than once. I will have to think more about this one. 
quote:
The problem with doing this is when you do a search for 'ASP', the link is returned twice because it exists twice. If I started adding more links like this my search results are going to be chock full of duplicates and possibly triplicates.
That would not be a problem, if I'd include the feature of having one Link in several Cats/Subcats, it would be added to the database only once, but put into more than one Cat/Subcat.
quote:
Heh, and you thought you were almost done with the final version. ;)
I'm actually glad suggestion come in before the final version is out so I can include as many features as possible.  < |
My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch
Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
|
|
|
|
JakeG
Starting Member
USA
9 Posts |
Posted - 12 March 2004 : 14:46:23
|
quote:
Hmmm... not sure about this one, I originally wanted to avoid having the same link submitted more than once. I will have to think more about this one.
You can always have it as feature that the board admin can turn on/off.
quote:
That would not be a problem, if I'd include the feature of having one Link in several Cats/Subcats, it would be added to the database only once, but put into more than one Cat/Subcat.
Exactly!
< |
- Jake
www.nthelp.org / www.computershowoff.com
Microsoft MVP - IIS
http://mvp.support.microsoft.com |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
Topic |
|
MOD: Links Manager v3.0 Beta (Snitz v3.4)
