Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Beta Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Recycle Bin & Moderator Log Details »»
Recycle Bin & Moderator Log
Version: 1.00, by Sasq Sasq is offline
Developer Last Online: Jun 2013 Show Printable Version Email this Page

Version: 2.2.x Rating:
Released: 01-06-2003 Last Update: Never Installs: 16
Is in Beta Stage  
No support by the author.

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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #32  
Old 03-10-2003, 12:26 PM
Sasq's Avatar
Sasq Sasq is offline
 
Join Date: Mar 2002
Location: Japan
Posts: 71
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #33  
Old 03-10-2003, 02:32 PM
350Chevy's Avatar
350Chevy 350Chevy is offline
 
Join Date: Nov 2002
Location: Tampa, FL
Posts: 258
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #34  
Old 03-10-2003, 02:43 PM
Sasq's Avatar
Sasq Sasq is offline
 
Join Date: Mar 2002
Location: Japan
Posts: 71
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #35  
Old 03-11-2003, 03:45 PM
The Red Devil The Red Devil is offline
 
Join Date: Mar 2003
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #36  
Old 03-11-2003, 09:40 PM
Sasq's Avatar
Sasq Sasq is offline
 
Join Date: Mar 2002
Location: Japan
Posts: 71
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #37  
Old 03-11-2003, 09:44 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 (...)
Reply With Quote
  #38  
Old 03-11-2003, 10:11 PM
Sasq's Avatar
Sasq Sasq is offline
 
Join Date: Mar 2002
Location: Japan
Posts: 71
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #39  
Old 03-12-2003, 10:02 AM
Mike11212 Mike11212 is offline
 
Join Date: Jul 2002
Posts: 134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

when will this hack be out of beta any release date?
Reply With Quote
  #40  
Old 03-12-2003, 10:34 AM
350Chevy's Avatar
350Chevy 350Chevy is offline
 
Join Date: Nov 2002
Location: Tampa, FL
Posts: 258
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I just upgraded to 2.3.0 RC3 and all 40+ hacks I have installed including this one work like a charm.
Reply With Quote
  #41  
Old 03-12-2003, 11:27 AM
Sasq's Avatar
Sasq Sasq is offline
 
Join Date: Mar 2002
Location: Japan
Posts: 71
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:20 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02978 seconds
  • Memory Usage 2,310KB
  • Queries Executed 27 (?)
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
  • (2)bbcode_code
  • (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
  • (4)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)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_postinfo_query
  • fetch_postinfo
  • 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