Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Tracking Moderators actions
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Lady_Cazadores
Starting Member

United States
2 Posts

Posted - 09 December 2008 :  02:57:49  Show Profile
We have a "Dog breed club" site, that has several boards (All Snitz Forums) We also have several moderators...we suspect one is indiscriminately deleting posts of those she doesn't like, but she denies it...IS there a way to TELL who deleted a post...or a way to recover deleted posts?

We could just take away their moderator rights, I realize, but we want to avoid any sticky situations, by having "proof" of their having deleted posts which should not have been deleted...

Thanks for ANY help you can offer.

Michelle<

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 09 December 2008 :  03:00:35  Show Profile  Visit HuwR's Homepage
the answer is no to both questions.

what makes you think they are deleting posts ?
you must have a reasonable suspicion that this is happening, if so, just remove their moderator privilages.<
Go to Top of Page

Lady_Cazadores
Starting Member

United States
2 Posts

Posted - 09 December 2008 :  03:25:12  Show Profile
Yeah, that is probably what we'll do...but we wanted to have proof...and to prevent people from "Geee, OOOOOPS, sorry, I deleted that post" (Which just so happens to have said something I didn't like...but lets ignore that fact, cause if you catch me I'll just say it was a "Accident")

Lots of "passive aggressives" in this world...LOL

But if we could log it, and say, you deleted this on X date and this on X date...BUH BYE...don't let the door hitcha where the good lord...well, you probably know how that ends...

But we'd have proof, so when they started saying how unfair it was (Some people think being a "moderator" is a BIG honor and privilege. LOL )we would have proof, that they cannot deny...

Dang, oh well...never hurts to ask.

Thanks ya'll!<
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2085 Posts

Posted - 09 December 2008 :  03:41:15  Show Profile
Interesting idea for a MOD. WHen I go on leave, I might see if it is at all possible.

On sites that I have and have moderators, I have an area where the moderators are to place all the posts that they feel should be removed so they do not actually delete them and we have the word for word from the post if the user goes "where is my post" and we go back to the user and explain why it was removed. All my moderators now that they are never to delete a post or they loose their moderator access.<

Cheers,

David Greening
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 09 December 2008 :  03:57:42  Show Profile  Visit HuwR's Homepage
you can't delete a post by accident, that is why there is a confirmation dialog<
Go to Top of Page

Etymon
Advanced Member

United States
2395 Posts

Posted - 09 December 2008 :  04:12:19  Show Profile  Visit Etymon's Homepage
Classic,

It shouldn't be that hard to do. I am sure you will have fun with it when you get the chance!


Cheers,


Etymon
<
Go to Top of Page

SiSL
Average Member

Turkey
671 Posts

Posted - 09 December 2008 :  08:06:29  Show Profile  Visit SiSL's Homepage
Recovering might be too costy but making a log for moderator actions should be a nice idea for a mod.<

CHIP Online Forum

My Mods
Select All Code | Fix a vulnerability for your private messages | Avatar Categories W/ Avatar Gallery Mod | Complaint Manager
Admin Level Revisited | Merge Forums | No More Nested Quotes Mod
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 09 December 2008 :  08:48:00  Show Profile  Send ruirib a Yahoo! Message
quote:
Originally posted by SiSL

Recovering might be too costy but making a log for moderator actions should be a nice idea for a mod.


Actually it may not be too costly. You just need a backup table for deleted topics and replies and insert them there before deletion. Edits, that's a different story, but for edits there is, I believe, a mod by cripto9t that deals with those.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Podge
Support Moderator

Ireland
3776 Posts

Posted - 09 December 2008 :  09:07:51  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
If you have the raw IIS logs you may be able to work out who deleted which topics. I have done it in the past.

A pretty easy solution might be to modify the ChkString function to log all sql statements to a text file that begin with or contain DELETE (or just all sql statements) and prefix them with the username or member_id e.g.
username1: DELETE from FORUM_TOPICS where TOPIC_ID = 23
MEMBER_ID 343: DELETE from FORUM_TOPICS where TOPIC_ID = 566


It should be pretty easy to do.<

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

Etymon
Advanced Member

United States
2395 Posts

Posted - 09 December 2008 :  13:16:58  Show Profile  Visit Etymon's Homepage
You can track the deletions and by whom by updating a new table just prior to the deletion. I think that would be an easy route to take and not much hassle to create.

Restoring deletions is another issue. I would go about it differently than even the way that the request from Lady_Cazadores was phrased. I know that she meant literally restoring posts which have been deleted.

Instead of having a separate table of deleted posts and reinstating those deleted posts, I would not let the moderator delete at all, and instead let the moderator "think" the post was deleted by flagging the post either with an expanded field or with a new field.

Using the expanded field, I would hide the post from view by flagging it instead of deleting it so that the administrator can see what is qued to be deleted. This way you don't have to mess with the extreme time hog of adding more tables and too much more code. Honestly, the status of a post only goes from 0 to 3, so why not add one new value and go on from there?

0 = closed
1 = open
2 = moderation pending
3 = post moderated but has been held
4 = post is hidden from moderator and members but not admin due to deletion attempt

You could add that qualifier to the select statement and go on from there. If either the topic or reply has been qued for deletion, then only show it to an admin. The table that tracks the attempted delete can capture all of the particulars such as who, what, where, when, etc.

That's where I would start. I really don't have the time to create a public MOD for this sort of thing at the moment, but if this description will help someone else move on a with a MOD, then I'm happy to have been able to help out.
<

Edited by - Etymon on 09 December 2008 13:30:11
Go to Top of Page

Podge
Support Moderator

Ireland
3776 Posts

Posted - 09 December 2008 :  13:25:56  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
I'm not in favour of deleting posts from the db at all. I think they should be treated the same way as members are and given a status of deleted (4 in your example above). They could be shown in a Garbage forum at the bottom of the main page that has restricted access i.e. hidden from normal users but moderators can see them and only admins can permanently delete them.

Other status' could also be added for other stuff like

5 = Administrators only
6 = SPAM
7 = etc.<

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

Etymon
Advanced Member

United States
2395 Posts

Posted - 09 December 2008 :  13:27:26  Show Profile  Visit Etymon's Homepage
That's the idea Podge! <
Go to Top of Page

MaD2ko0l
Senior Member

United Kingdom
1053 Posts

Posted - 09 December 2008 :  13:30:07  Show Profile  Visit MaD2ko0l's Homepage
there was a mod not so long ago where by any edits that have been made were logged..coudl this not be adapted so that posts are only marked as read then only the admins can delete them if they are deemed inappropiate?<

© 1999-2010 MaD2ko0l
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.41 seconds. Powered By: Snitz Forums 2000 Version 3.4.07