Author |
Topic  |
|
Lady_Cazadores
Starting Member
United States
2 Posts |
Posted - 09 December 2008 : 02:57:49
|
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
|
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.< |
 |
|
Lady_Cazadores
Starting Member
United States
2 Posts |
Posted - 09 December 2008 : 03:25:12
|
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!< |
 |
|
Classicmotorcycling
Development Team Leader
    
Australia
2085 Posts |
Posted - 09 December 2008 : 03:41:15
|
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 |
 |
|
HuwR
Forum Admin
    
United Kingdom
20595 Posts |
Posted - 09 December 2008 : 03:57:42
|
you can't delete a post by accident, that is why there is a confirmation dialog < |
 |
|
Etymon
Advanced Member
    
United States
2395 Posts |
Posted - 09 December 2008 : 04:12:19
|
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 < |
 |
|
SiSL
Average Member
  
Turkey
671 Posts |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 09 December 2008 : 08:48:00
|
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 |
 |
|
Podge
Support Moderator
    
Ireland
3776 Posts |
Posted - 09 December 2008 : 09:07:51
|
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. |
 |
|
Etymon
Advanced Member
    
United States
2395 Posts |
Posted - 09 December 2008 : 13:16:58
|
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 |
 |
|
Podge
Support Moderator
    
Ireland
3776 Posts |
Posted - 09 December 2008 : 13:25:56
|
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. |
 |
|
Etymon
Advanced Member
    
United States
2395 Posts |
Posted - 09 December 2008 : 13:27:26
|
That's the idea Podge! < |
 |
|
MaD2ko0l
Senior Member
   
United Kingdom
1053 Posts |
Posted - 09 December 2008 : 13:30:07
|
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 |
 |
|
|
Topic  |
|