Clean vB Database

*** vB.org Staff NOTE: Please read this thread very well (especially post #5 and up), and make sure you understand the issues addressed before using this hack ***
(Note to author, don't remove this warning unless you provide enough information and warning about all aspects of using this hack yourself)

Introductions

Welcome to the Clean vB Database v 1.0 ,
Do you have big Database!
Do you want backup it quickly!
without database access you can empty all uneeded tables such as adminlog,session,word...etc.
our Mod. Can do this through your admincp.
Installation
, right here's the quick and short of it, bung the files in the relevant folders

forums/admincp/clean_db.php
forums/includes/xml/cpnav_clean.xml

from AdminCP >> Import file clean_products.xml as Product

You will Find our hack link in the bottom of Maintenace Menu
That's All
Have a fun.
Please Click
Install
(Optional)
If you want cleaning the database "Automaticlally" with scheduled task
please upload the file :

forums/includes/cron/clean_db_cron.php

and add a new cron job via your admin cp "scheduled tasks":
=======================================
Title:Clean vB DataBase
Day of the week: *
Day of the month: *
Hour: 12
Minute: 30 - - -
Log Entries: Yes
Filename: ./includes/cron/clean_db_cron.php
=======================================

[Paul M]

Originally Posted by HaMaDa4eVeR

dear marco :
I knew all vB tables have functions and jop , but the function of (word,adminlog,session) is not important , by anther meaning , if you empty these tables your vB database will not damage

I'm afraid that this sentence demonstrates quite clearly your lack of understanding of how vb works.

You seem to have randomly picked three tables.

• Adminlog - yes, not *that* important (unless you want to look back at who did something) - but then neither is moderatorlog, why one and not the other.
  
• Sessions - clearing out live users session entries is a bad idea and could log them off. Old sessions are automatically cleared anyway - this is pointless.
  
• Word - the worse of the lot - clearing this will break your search unless you use fulltext searching. Postindex is the other half of non FT searching, yet you missed that, resulting in a very broken search index.

I very rarely say a hack is a bad idea, but *this* is a bad idea.

[Zia]

hmmmin our case test on test site...test site is only a test site...only 10-12 post nothing els..
main site 6000 post with fully decorated ..

/me is thinking what to do ...

[Erwin]

I would warn against installing and using this, unless there is a specific need to empty certain tables like these.

[lazytown]

Wow, definitely a bad idea to have this floating around for newbies to install. It makes it sound like emptying the recycle bin in windows (which this is NOT). If an admin needs to do anything like this I advise

1) Fully understanding exactly what table you're "clearing" does and what you may have to do to restore it after a server move/etc
2) Backup your database first
3) Use something like PHPMYADMIN instead (or the vbulletin built in functions where possible).

-vissa

[Robbed]

If you have a big forum and you empty the word table, it will take you forever and a lot of server load to re create it.

In the admincp you can select what tables to backup so why empty them?

Just don't backup the word table and the backup will be faster.

[Rickie3]

hmmm i definately wont be using,those things are in vb for a reason

[Trigunflame]

Talk about giving someone hell. oO, he still has 22 installs though

[libertate]

Actually... I would like to see something "similar" to this.

I would like to see a "DB cleaner", that drops non-standard fields from a standard vB DB table.

It would come very very handy when I want to do a clean install but not have to mess with export/import of data.

[Marco van Herwaarden]

That is something completle different. You could already use one of Andreas hacks to identify non-standard fields i think. Just the drop would be manual (which i would prefer for safety).

[Gizmo5h1t3]

Originally Posted by Tulsa

Well since we're all admins of sites here, I would hope that anything that says it's going to be altering your database would scream "red flag" to you and you'd hold off installing this until it's value and safety is proven.

being an admin of a site is all well and good, but seeing as thers been 22 installs of this already, that comment dont really stick???

plainly this still being available to all cant be a good idea, if its gonna cause probs?