|
Seuss
Error: divide byzero


Registered: 04/27/01
Posts: 23,480
Loc: Caribbean
Last seen: 14 days, 4 hours
|
Selective moderation
#558264 - 02/21/02 07:44 AM (21 years, 7 months ago) |
|
|
I noticed the other day that the vendor forum has become moderated. This sucks! I am not upset that the foum _is_ moderated, but rather that is _has_ to be moderated because of a handful of immature people. I got to thinking last night and came up with an idea... Add a selective moderation feature to the board. Everybody starts out with the ability to post. If a moderator thinks somebody is being abusive of their posting privledge, then the moderator can flag that user. Once a user has been flagged, all of their posts must be approved by a moderator, just like on a regular moderated board. The unflagged users can still post without moderation just like normal. I don't think it would be too much work on the code. You would need to probably add a table to identify a flagged user and board. The SQL would be simple, just a left join of the existing select with the new table. The hardest part would be adding to the UI for the moderator to flag/unflag a user.
-------------------- Just another spore in the wind.
|
djfrog
omgws!!!1!

Registered: 10/22/00
Posts: 3,710
|
Re: Selective moderation [Re: Seuss]
#558866 - 02/21/02 06:50 PM (21 years, 7 months ago) |
|
|
A left join? A left join and a new table? And you think that will be easy?
|
Seuss
Error: divide byzero


Registered: 04/27/01
Posts: 23,480
Loc: Caribbean
Last seen: 14 days, 4 hours
|
Re: Selective moderation [Re: djfrog]
#558886 - 02/21/02 07:10 PM (21 years, 7 months ago) |
|
|
I have been writing php (/w mysql) for a living for the last five years (clear back when it was php-fi), so yes, I think it would be that easy. Though I do admit that I haven't seen the code soooo... assuming good code structure: The majority of the work for the system is already done in the existing moderation code. You need a single table that contains a unique user identifier and a unique board identifier to record the flagged users of a board. You put a conditional in (probably where the join would go as well) where the system checks to see if a board is currently moderated to check for a flagged user. If the user is flagged, call the existing moderation post code, if the user is not flagged, call the regular non moderated post code. Again, the hard part is adding the user interface changes to flag/unflag a bad user by a moderator. If that doesn't work, you could probably hook in and fake a moderation approval for non-flagged users. Just depends on how the code is written.
-------------------- Just another spore in the wind.
|
3DSHROOM
loon


Registered: 04/19/99
Posts: 2,878
Last seen: 10 years, 7 months
|
Re: Selective moderation [Re: Seuss]
#558893 - 02/21/02 07:20 PM (21 years, 7 months ago) |
|
|
Again, the hard part is adding the user interface changes No, the hardest part would be reviewing every flagged user's posts. We don't have that much manpower so that user would just be banned before ever reviewing everyone of their posts.
-------------------- Your friendly neighborhood loon
|
Seuss
Error: divide byzero


Registered: 04/27/01
Posts: 23,480
Loc: Caribbean
Last seen: 14 days, 4 hours
|
Re: Selective moderation [Re: 3DSHROOM]
#558917 - 02/21/02 07:48 PM (21 years, 7 months ago) |
|
|
I was thinking on a per board basis... only for the vendors forum for example :-) Since that forum is already fully moderated, only having to review the flagged users would actually be less work. The UI was the part I was worried about. I haven't seen the admin side of things here, but having written enough of them, I know how tricky that part can be. Something to think about if you ever get board some weekend.
-------------------- Just another spore in the wind.
|
djfrog
omgws!!!1!

Registered: 10/22/00
Posts: 3,710
|
Re: Selective moderation [Re: Seuss]
#560682 - 02/23/02 01:37 PM (21 years, 6 months ago) |
|
|
Son, left joins don't just grow on trees.
|
|