| Author |
 Topic  |
|
dayve
Forum Moderator
USA
5820 Posts |
 Posted - 13 February 2003 : 19:55:45
|
Found A Bug. The Moderation Icons will NOT show in default.asp and active.asp when this mod is used. The following changes must be made in order for one to be aware that there are posts needing moderation:
inc_moderation.asp
Find this line:
strSql = strSql & " AND T.FORUM_ID = F.FORUM_ID AND F.F_MODERATION in (1,2)" & " AND T.T_STATUS > 1 "
and change it to this:
strSql = strSql & " AND T.FORUM_ID = F.FORUM_ID AND F.F_MODERATION in (1,2,9)" & " AND T.T_STATUS > 1 "
Find this line:
strSql = strSql & " AND R.FORUM_ID = F.FORUM_ID AND F.F_MODERATION in (1,3)" & " AND R.R_STATUS > 1 "
and change it to this:
strSql = strSql & " AND R.FORUM_ID = F.FORUM_ID AND F.F_MODERATION in (1,3,9)" & " AND R.R_STATUS > 1 " |
 |
 |
|
|
jfitz
Junior Member
USA
345 Posts |
Posted - 22 February 2003 : 22:22:24
|
| Ahhhhhh, that explains why I needed to add a "Do not approve or move this post" that required moderation to make the icon show up! |
--Jördan
It's a wasted day if you don't spend at least part of it flying upside down. |
|
|
|
jfitz
Junior Member
USA
345 Posts |
Posted - 22 February 2003 : 22:26:18
|
| We've added a new field to our FORUM_MEMBERS table (M_ON_PROBATION) as a binary flag. In addition to having the first n posts moderated, any member on probation will also have his/her posts moderated. It's a relatively minor addition to this great mod, but without a corresponding Admin function, it does require a manual DB entry / update. Not bad in our case, since we host our own DB, and it's a rare need for this capability, but it has become ocassionally necessary. |
--Jördan
It's a wasted day if you don't spend at least part of it flying upside down. |
|
|
|
MDGamezz
Junior Member
USA
100 Posts |
Posted - 27 May 2003 : 21:06:50
|
Sorry guys , can't reply to the other topic.
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=39015
I'm kinda stumped here.
I'm working on setting up a 3.4 version of the forum.
Along the way I had bookmarked this topic and finally made my way back to it.
I'm kinda slow about upgrading my forum to the latest version.
Anyhow , I seem to have a slight glitch with this from what I've seen.
I 've made the changes that GB has listed.
On the other topic I made the changes that Dayve listed about the moderated post not showing up on default and active.asp
In the testing I've done.
A new topic by a new member will show on active.asp (for moderation)
However if I reply to a topic it doesn't show on default.asp or active.asp
Everything works fine from what I can tell other than the fact I can't see the replies. |
MDGamezz |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 27 May 2003 : 22:09:17
|
| Since the fist topic was not approved there is no relationship to show the replies. You will need to approve the topic first and then the link between your replies and topics will show. |
|
|
|
|
MDGamezz
Junior Member
USA
100 Posts |
Posted - 28 May 2003 : 20:00:46
|
Dayve
My understanding of what your saying would contain all post under one topic.
Would this be correct?
I can approve the new topic and the replies to other topics still do not show for moderation.
So the new topics work just fine.
It's the replies to any topic that seem to be missing something.
I'll triple check the code that was added.
It seems simple enough to add and there were not that many problems judging from the length of the topic(s).
Thanks for your reply.. |
MDGamezz |
|
|
|
Topic |
|
Topic Locked
