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.

[MetroSports82]

Are there any plans, for further updates to improve this hack, or is this final?

thanks,
Metro.

[Sasq]

Apart from bug fixes, in the install, some work in the report script and a few bugs here and there its more or less good to go.
I've been very busy recently with getting ready to leave my Job, as well as my primary BB.

Left the job on monday this week, been spending some QT with the wife, and I should get some coding time early next week - Oh god I hope i can get some codeing time next week

Dan

[Holidazed]

I get the error during the installation

You have an error in your SQL syntax near '$DB_site->query("INSERT INTO forum VALUES (NULL, 1, 'RCBforum', '', 1, 1, 0, 0, ' at line 1

I get this when installing with the default values or when I try to do it manually. However, I get zero instruction on the screen (in manual mode) for setting up the database and noting in the readme file either.

[Sasq]

That is a bug - I should be able to get to withing the next 24 hours - wife and QT permitting.

Dan

[Sasq]

Ok, the installer is fixed regarding the forum creation errors.

I'll do my best to get to other stuff soon.

Dan

[Sue]

Warning: Failed opening '/home/libragrr/public_html/forums/showthread.php' for inclusion (include_path='.:/usr/local/lib/php') in Unknown on line 0

When I tried to go to a thread

and my index page is Kapoof! http://www.libragrrl.com/forums/index.php

[Sasq]

Sue, check your PM

[Zzed]

Today at 06:02 AM Sue said this in Post #46
When I tried to go to a thread

and my index page is Kapoof! http://www.libragrrl.com/forums/index.php

Sue, the board is up and runmning again. I fixed everything.

Check your Emails.

[Sasq]

Zzed, I'm most interested what was the fault...

Dan

[Zzed]

Today at 04:04 PM Sasq said this in Post #49
Zzed, I'm most interested what was the fault...

Dan

There were 2 problems.

index.php had been reduced to a 0 byte file, which I restored from the backup copies created by emacs.

The file permissions on forumdisplay.php had changed to -rw-rw--w-. Since Apache is not the same user and usergroup as Sue's ID on the server it had no read permission to read that file and hence the error message would pop. I cured that puppy with a chmod 644 forumdisplay.php.