| Author |
 Topic  |
|
@tomic
Senior Member
USA
1790 Posts |
 Posted - 15 July 2001 : 20:29:26
|
I have used another MOD to create a Moderator section and have a link from that Moderator Admin page. I can see compliants when logged in as admin. If logged on as a moderator i see the following...
Could not locat a member ID for logged user
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'MEMBER_ID ='.
/forum/ComplaintManager.asp, line 92
@tomic
|
 |
|
|
kovan
Junior Member
134 Posts |
Posted - 15 July 2001 : 21:16:36
|
maybe its the mod thats not sending the moderator ID properly
whats your forum? i can have a look at it
|
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 15 July 2001 : 21:25:48
|
http://www.skepticfriends.org/forum
I will take a look myself and see what I can do. I also have made a few subtle changes that may or may not appeal to folks. I will post them when I am done.
@tomic
Edited by - @tomic on 15 July 2001 21:26:36 |
|
|
|
kovan
Junior Member
134 Posts |
Posted - 15 July 2001 : 22:24:39
|
if you want me to have a look
register a nick for me, give me moderator
and email me the password kovan@home.com
i will have a look at whats causing that problem
|
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 16 July 2001 : 03:38:20
|
There have been a few instances where I wanted to contact the person that sent a complaint in but it wasn't recorded anywhere.
To include a record of who sent the complaint go to line 57.
After:
IsTopic = Request.QueryString("IsTopic")
Add:
Complainer = Request.Cookies(strUniqueID & "User")("Name")
Then go to line 86. Between <TEXTAREA cols=40 name=msg rows=7 style="HEIGHT: 118px; WIDTH: 432px"> and </TEXTAREA> add:
<%= Complainer %> reports:
so that it looks like:
<TEXTAREA cols=40 name=msg rows=7 style="HEIGHT: 118px; WIDTH: 432px"><%= Complainer %> reports:</TEXTAREA>
Someone could send in a report without their real name but a frivolous complaint should be obvious enough.
@tomic
|
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 16 July 2001 : 04:15:13
|
I was able to fix the error I mentioned a few posts earlier where the moderator's ID wasn't found. At line 79 I had to change
SQL = "SELECT MEMBER_ID FROM FORUM_MEMBERS WHERE M_USERNAME='" & strDBNTUserName & "'"
to
SQL = "SELECT MEMBER_ID FROM FORUM_MEMBERS WHERE M_NAME='" & strDBNTUserName & "'"
Works like a charm now 
@tomic
|
|
|
|
trakfast11
Starting Member
32 Posts |
Posted - 22 July 2001 : 00:22:24
|
@tomic can you give me a link to the place where you heard about/downloaded a mod to give Moderators there own Moderator Options?
P.S: nevermind, i found it here
Edited by - trakfast11 on 22 July 2001 00:25:42 |
|
|
|
MotoX
Junior Member
201 Posts |
Posted - 15 August 2001 : 11:26:13
|
has anyone set this up for V3.3? If so could you please post the updated files and instructions?
Thanks |
|
|
|
kovan
Junior Member
134 Posts |
Posted - 16 August 2001 : 15:40:00
|
we have successfully implemented into a customized version of 3.3
which can be found at www.magicmushroom.org.uk
and most of the bugs found have been fixed
post a message on this forum and the files will be posted for you
and you can get any support you need over on that forum,
|
|
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 16 August 2001 : 16:10:42
|
I didn't see the files for d/l at Huwr's site. Can you post the link here?
********************
Who is this General Fault, and why is he reading my Hard Drive??? |
|
|
|
kovan
Junior Member
134 Posts |
|
|
MotoX
Junior Member
201 Posts |
Posted - 16 August 2001 : 18:45:51
|
I did what you said but it looks like I'm getting a SQL error:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/forum/ComplainToModerator.asp, line 112
I am using MS Access 2K
Here's that area of code:
function SaveMessage
dim RS
dim SQL
if ReplyID = "" then ReplyID = 0
SQL = "INSERT INTO " & strTablePrefix & "COMPLAINTS(ForumID, TopicID, CatID, Message, ReporterID, IsTopic, ReplyID, Solved)"
SQL = SQL & " VALUES(" & ForumID & ", " & TopicID & ", " & CatID & ", '" & message & "', " & ReporterID & ", " & IsTopic & ", " & ReplyID & ", " & 0 & ")"
'Response.Write SQL
my_Conn.execute SQL
Any help is appreciated.
|
|
|
|
MotoX
Junior Member
201 Posts |
Posted - 16 August 2001 : 19:51:44
|
nevermind. I figured it out. changed the last lines of code to this:
function SaveMessage
dim RS
dim SQL
if ReplyID = "" then ReplyID = 0
strSql = "INSERT INTO " & strMemberTablePrefix & "COMPLAINTS "
strSql = strSql & "(FORUMID"
strSql = strSql & ", TOPICID"
strSql = strSql & ", CATID"
strSql = strSql & ", MESSAGE"
strSql = strSql & ", REPORTERID"
strSql = strSql & ", ISTOPIC"
strSql = strSql & ", REPLYID"
strSql = strSql & ", SOLVED)"
strSql = strSql & " VALUES ("
strSql = strSql & "'" & ForumID & "'"
strSql = strSql & ", " & "'" & TopicID & "'"
strSql = strSql & ", " & "'" & CatID & "'"
strSql = strSql & ", " & "'" & message & "'"
strSql = strSql & ", " & "'" & ReporterID & "'"
strSql = strSql & ", " & "'" & IsTopic & "'"
strSql = strSql & ", " & "'" & ReplyID & "'"
strSql = strSql & ", " & "'" & 0 & "'"
strSql = strSql & ")"
my_Conn.Execute (strSql)
Response.Write " <center><b>Thank you for keeping this forum clean....... <br><br> redirection to forum page" & _
"<meta http-equiv='refresh' content='3;url=default.asp'>"
end function
WriteFooter
%>
|
|
|
|
extrafree
New Member
54 Posts |
Posted - 23 August 2001 : 11:25:33
|
hi!! it' a nice one mode!
do you know if is possible to show a icon in the section where someone had
reported topic to moderator,so that the moderator of that section can see that
have a new message from somebody???
thanks and sorry for my bad English!!!
http://www.extrafree.it/forum
|
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 27 August 2001 : 18:23:48
|
I have an issue where the Report to Admin icon (with hyperlink) only shows on the replies to posts. It is not visible on the original or first post. Any ideas?
Shannon |
|
|
|
Topic |
|
Topic Locked
