The Arcive of Official vBulletin Modifications Site.

Recycle Bin & Moderator Log · **Released**: 01-06-2003

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.

N9ne · #2 01-07-2003, 02:50 PM

Thanks for beta releasing this, I will be sure to test it out once my server is setup

.

Sasq · #3 01-07-2003, 02:51 PM

Well, being honest I have the actual hack itself running in production.. - I'm more scared about the installe

Dean C · #4 01-07-2003, 05:14 PM

Well i'll give it a try locally if i get a chance and let you know how i get on

It won't be til this weeekend at least though

Thanks for releasing the hack btw

Regards

- miSt

DannyITR · #5 01-07-2003, 06:27 PM

Please explain what you mean by not installing on a live board. Where else would the hack go? Do mean just turn it off while you install the hack? And what does Beta mean?

I really want to install the hack but I don't know what the warmings mean.

NTLDR · #6 01-07-2003, 06:42 PM

Quote:

Originally posted by DannyITR
[B]Please explain what you mean by not installing on a live board. Where else would the hack go?

A test board.

Quote:

And what does Beta mean?

This means that its unfinished and may not be suitable for a production site (IE your live forums with real visitiors). However it should be reasonably stable without too many bugs.

Sasq · #7 01-08-2003, 12:02 AM

Another thing on my todo list is write a better intro...

Basically the hack itself works, and while it does add any new columns to any of the vBB tables - it uses two of its own. It does require 39 ~ 40 small file inserts to handle the logging, and keep the recycle bin function behaving. Also it uses about 9 templates I'll add more info as to what goes on in the first post in a bit.

At this stage, if you have an un hacked 2.2.9 board, it *should* install without *any* problems. It it goes fubar, just copy those files that it altered back, drop the recycle bin forum it creates and the extra templates. And all *should* be well.

BUT at this point I'm not willing to say that all WILL be well. I do have to try to dig up some older versions of vBB to see how the hack responds to them.

I'll also try to make some screen shots and post them up in a bit.

Dan

Sasq · #8 01-08-2003, 12:34 AM

Ok, here are some pics showing you what the hack looks like.

Like I Said the actual log viewer, needs to be made a little prettier but most of the needed functionality is there.

Dan

bitbender · #9 01-08-2003, 01:19 AM

/me will try it on a 2.2.6 "moderately hacked" test board *clicks* download

Sasq · #10 01-08-2003, 01:56 AM

My main problem with testing previous versions... I'm not the main licence holder, just the code moneky for my forum.
I used to have 2.2.4 and 2.2.5 but i lost it in a hard drive crash..

Must check if I can get my hands on older versions.

Dan

alkatraz · #11 01-08-2003, 06:18 AM

Can't wait to see a final version of this! Great job!

Sasq · #12 01-08-2003, 10:14 AM

Uploaded a new zip due to a bug in the installer package, - downloading the patched file produced a 0 length file.

MetroSports82 · #13 01-08-2003, 12:17 PM

this is awesome. keep up the good work sasg!

Metro.

Sasq · #14 01-09-2003, 03:31 AM

Ok, a few of you have downloaded this.
I need feedback on the installer. any bugs/misses/did it find all the code to patch.

and if it did miss any patches what ver of vbb and which file/which patch would be great.

Dan

bitbender · #15 01-09-2003, 02:17 PM

It's on my schedule for today, I'll post back, shortly, sasg

Being a full time engineer sure can interrupt a guys time from what I really LIKE doing!!

N9ne · #16 01-09-2003, 05:21 PM

I think for some, who have very hacked boards, it would be a good idea for you to include a .txt file with instructions. (I think you said something about being able to create one from the installer, but to save time, creating it and putting it in the .zip would be more convenient

)

Sasq · #17 01-09-2003, 09:16 PM

Yeah a nice text file is on my to do list. But I'm sorta busy with other stuff atm - damn back to work today

Well at least make the installer spit up the data a little eaiser..

But as I've also said, this is not a simple hack to install, if you really want to add each part by hand..

What I will do get the installer to spit up a html page with the changes to your actual script so you can compare it to the changes that need to be made.

Also get it to list only the mods that didn't install - for the partially patched download.

Dan

Sasq · #18 01-12-2003, 08:25 AM

Ok, do appologise for the lack of updates to the install and work on the admin log section.

Our host has just upgraded our server, and now I'm busy stamping out brushfires -like collapsing databases. - sigh

XIanX · #19 01-26-2003, 09:27 PM

I've had this hack installed for about a week now and I'm really loving it except one thing. All the posts in my Gamecube forum(It's a gaming forum) sometimes end up getting placed in the Recycle Bin. To fix this, I have Mass Move the threads back in. It doesn't happen when I do anything specific, it just randomly it seems to do this.

Sasq · #20 01-29-2003, 11:35 PM

Work has been really busy recently. I'll try to get to it on the weekend - as long as they leave me alone long enough

It would be great if you could dump me the relevant part of the log - hopefully its logging something when it moves the threads. it might help me to work out whats going on

Dan

ps pm me and i'll give you my private email address so you can email it to me

XIanX · #21 01-30-2003, 01:18 AM

I seem to have fixed the problem by re-creating the Recycle Bin forum and setting up the configuration again. Theirs a template error in the "Edited Posts/Deleted Posts(I forgot which one)" template for this hack. The link to the "Original Thread" wasn't pointing to the correct location, a simple edit fixed this.

I'm also recieving a JavaScript error when I view one of the threads dedicated to Edited/Deleted posts. The exact error is:

Code:

Line: 55
Char: 1
Error: Expected '}'
Code: 0

The relevent code relating to this error starts on Line 51:

<script language="javascript" type="text/javascript">
<!--
function aimwindow(aimid) {
        window.open("member.php?s=&action=aimmessage&aim="+aimid,"_blank","toolbar=no,location=no,menubar=no,scrollbars=no,width=175,height=275,resizeable=yes,status=no")
        } -->
        </script>
        </head>
        <body bgcolor="#666696" text="#000000" id="all" leftmargin="10" topmargin="10" marginwidth="10" marginheight="10" link="#000020" vlink="#000020" alink="#000020">
        <!-- logo and buttons -->

I hope this helps. I did not take the time to investigate the JavaScript error.

Pikok · #22 02-02-2003, 11:06 AM

this is the error I got :

PHP Code:


			
  Install for Moderator Logger and Recycle bin page5 

Now doing file modifications 

index.php

All patches correctly (I hope ;) applied to this file.

 

postings.php

All patches correctly (I hope ;) applied to this file.

 



Warning: ChDir: No such file or directory (errno 2) in d:\gearhost\hostingaccounts\realitydesign\www\pyrio\forums\admin\loginstall.php on line 422

 admin/functions.php

All patches correctly (I hope ;) applied to this file.

 



Warning: ChDir: No such file or directory (errno 2) in d:\gearhost\hostingaccounts\realitydesign\www\pyrio\forums\admin\loginstall.php on line 422

 editpost.php

All patches correctly (I hope ;) applied to this file.

 



Warning: ChDir: No such file or directory (errno 2) in d:\gearhost\hostingaccounts\realitydesign\www\pyrio\forums\admin\loginstall.php on line 422

 showthread.php

All patches correctly (I hope ;) applied to this file.

 



Warning: ChDir: No such file or directory (errno 2) in d:\gearhost\hostingaccounts\realitydesign\www\pyrio\forums\admin\loginstall.php on line 422

Sasq · #23 02-02-2003, 12:08 PM

Do you have your admin folder in a non standard directory, or is it per standard setup?

Dan

Patrick · #24 02-05-2003, 09:47 AM

I got an error at line 58 of index.php relating to getlogset();
It really fugged up something, but I managed to get it back to working. It also did NOT complete the install when it said it did, so it did a half-job of it. Basically it did the forums/thread/post, as well as the forums/index.php modification, but no others. It may have gotten to the templates/mysql mods, but I can't verify that right now.

If you have any suggestions as to a cause of this, please let me know.

Sasq · #25 02-05-2003, 10:31 PM

Again the install package is pretty well beta. so any information is appreciated. each page will give feedback on if that particular section was modded, I notice the errors you posted originally.
I will hopefully have time to look this weekend.

I do appologise about being busy, I just have lots of work and family related issues atm.

Dan

Patrick · #26 02-06-2003, 05:55 PM

Dan,

I was able to fix the errors originally by chmodding all files to 777. Then I went through an automatic install, nothing manual. I had it do all the mods, and it said it completed successfully. When I went to confirm this, all I saw that it did was make the changes in index.html of forums dir. It also added the 1 forum and both threads and both posts. Other than that, it didn't finish the install. When you get the time, much help would be appreciated as this is an excellent hack I'd like to see operational.

Sasq · #27 02-08-2003, 10:53 AM

Ok, had a little trouble having a look at your forum. your script didn't like me comeing from Japan so much.

It shouldn't write to index.html at all. Of the top of my head the only thing i can think is the install is hard coded to deal with .php extentions and the default file directories. if you are running the php3 version it won't be able to find the files.

Dan

350Chevy · #28 03-09-2003, 06:07 PM

Any updates or progress on this?

350Chevy · #29 03-09-2003, 06:12 PM

I have 40+ hacks installed and this installed just fine. I had to edit a few of the files (index.php) and one line in the Functions.php but it all seems to be working properly except for the admin panel...

If I click on Configure Mod Logging or the Mod & Recycle bin log link I get this error:

Code:

Warning: Failed opening '/home/*******/****/forums/admin/modlog2.php' for inclusion (include_path='.:/usr/share/pear') in Unknown on line 0

350Chevy · #30 03-09-2003, 11:48 PM

Nevermind.. it was a permissions thing.. All works 100%

Sasq · #31 03-10-2003, 12:26 PM

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 · #32 03-10-2003, 02:32 PM

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 · #33 03-10-2003, 02:43 PM

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 · #34 03-11-2003, 03:45 PM

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 · #35 03-11-2003, 09:40 PM

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 · #36 03-11-2003, 09:44 PM

these changes seems to be because of an hack.

i won't ever use a query like

Code:

INSERT INTO table VALUES (...)

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

always use:

Code:

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

Sasq · #37 03-11-2003, 10:11 PM

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 · #38 03-12-2003, 10:02 AM

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

350Chevy · #39 03-12-2003, 10:34 AM

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

Sasq · #40 03-12-2003, 11:27 AM

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.13763 seconds Memory Usage 2,632KB Queries Executed 53 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (4)bbcode_code (1)bbcode_php (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (40)post_thanks_box (40)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (40)post_thanks_postbit_info (39)postbit (40)postbit_onlinestatus (40)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!