Recycle Bin & Moderator Log

THIS IS A REAL BETA HACK, DO NOT INSTALL ON A LIVE BOARD

Ok, I brought up the idea over in this thread .

Here is a BETA hack for a recycle bin and mod logging system I've been working on.

It logs all mod activity for editing/deleting posts, moving threads etc. all admin selectable to log or not.
It creates a Forum (preferably hidden) to hold all the deleted threads - the logging function takes care of where they are from and who put them there.

It also dumps a copy of all user or mod (and admin) posts into an edited posts thread, also all deleted posts are dumped into a deleted posts thread.

Most of the logging is sorted, and configurable, I've probably forgotten something somewhere - which is why this is beta

The log info in the admin display is functional but still needs some work. I think the actual recycle logging functions themselves are up to scratch.

More (short ) notes in the readme.

I repeat do not install this hack on a live board

On the installer, this is probably more beta then the actual hack, thanks to firefly (Chen) for letting me borrow some of his hack installer code.

The installer works with a vanilla install of 2.2.9 but i have no idea what it will do with a hacked board, or different versions.

Also the hack itself is only tested on 2.2.9

The installer will (if you let it) install all of the forums, threads, templates and even do the file mod's. There is also a FTP function to ftp locally if you don't have chmod 777 set, failing direct file access or ftp, you can choose to download the hacked file without having to do all the edits by hand. (damn that took me some working)

The installer is still a little raw, I'll work on it more with some feed back.

Now what the hack actually does.

On the straight logging side.
How much and what is logged is selectable via the script in the admin CP
Code has been added to make an entry in the logdata table each time, a mod or user edits, deletes, opens, closes, sticks - basically everything.. a thread or a post.
(I think I have it logging all relevant information, but I may have missed something.)
You are then able to view the log history in the admin CP, also in the admin CP you can clear the logs, view stats, track down actions by a specific user.
I am working on a function to allow you to rebuild the thread and show edits/deletes as they happened in the timeline, but this part is not a high priority atm for me.

On the Recycle bin side.
-Uses the logging functions to keep track of the threads/posts.
The installer set up the recycle bin forum as a Posts do not count forum.
Most of the larger code inserts keep track of the posts/threads and provide undelete/full delete functions.
the main index.php has a small code insert to hide how many posts/threads are in the recycle bin forum from showing on the main page.
When a post/thread is deleted, the post count is still reduced form the users file, and the posts are unindexed from the search index.
If a thread/post is undeleted, the post counts are increased and the posts are re added to the search index.
If you 'return' an original post after editing, nothing changes with post counts etc.
The code also protects the Edited posts header post, and the Deleted posts header post. so while in the recycle bin, if you choose to 'full delete' either thread the main post and thread remains intact.

See this post for pics

I will try to dig up some older versions of vBB to check the installer with them..


Bugs....

Probably lots, but nothing really worrying that i can see

Todo
Better install instructions
Fix up the admin cp script so its pretty.
Make the Install script a little more stable.
Add anything that you think would be good, and won't take me another 10 solid days to program (I think the wife is going to leave me :speechless: )

Fixed:
Fixed - hopefully - the forum and post creation section on hacked forums

I'm looking forward to feed back etc

This hack is free, but I won't say no to paypal donations for a damn big beer

Dan

Edit, uploaded a new zip file due to a bug in the alternate download section of the installer.

[Sasq]

Yeah, planning on a more useful admin panel section, and any/all feedback on the installer glitches is welcomed.
the installer is more beta then the actual hack.

got a few code glitches to work through and then should all be purty.

I'm just in the process of leaving my current job (end of the month) so I'm pretty busy atm, planning on getting more done with this hack post leaving.

Dan

[350Chevy]

The install seemed to work pretty good. I backed up everything before hand just in case (knowing all the hacks I've done.)

I figured with everything I did to the board that something would go whacky but it all went very well. Very nice hack indeed and my Admin are now happier than two peas in a pod.

[Sasq]

Sweet
I know i have some work to do on the admin panel side of life, but any reqests - and i know there are a few old ones in this thread i still need to get to - damn salt mines job - I'll do my best to improve functionality just after the end of the month.

Dan

[The Red Devil]

Tried to install it on my board 2.3.0 and got this sql error
Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: INSERT INTO forum VALUES (NULL, 1, 'RCBforum', '', 1, 1, 0, 0, '', 0, 1, 1, 30, '', '', 0, 0, 1, 0, 0, 1, 1, -1, '', 1, 0, 0)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

[Sasq]

I havn't had a chance to play with 2.3.0 yet, the problem is only a change in the way column numbers...

However give me a little time to get 2.3.0 to play with it, not sure what changes they have made

Dan

[Xenon]

these changes seems to be because of an hack.

i won't ever use a query like

INSERT INTO table VALUES (...)

because it would mean you know the correct sortorder and ammount of tablefields

always use:

INSERT INTO table (fierld1, field2, ...) VALUES (...)

[Sasq]

yup, that was on my to change list I had the same problem this weekend due to vbportal on our test board.

Just waiting for evil job to finish and I'll release an updated installer.

Dan

[Mike11212]

when will this hack be out of beta any release date?

[350Chevy]

I just upgraded to 2.3.0 RC3 and all 40+ hacks I have installed including this one work like a charm.

[Sasq]

its beta mostly due to the fact I havn't gotten around to pollishing the admin cp script.

As you may have noticed the installer is more beta then anything else...

I'm hopeing to fix the stuff that needs to be fixed at the begining of next month, then after testing it will hopefully go gold