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
=======================================

WaW....
I Installed it ,,,, great hack hamada4ever ,,, well done

Does this clear out the idea database?

thnx hamada4ever

Let me warn future users of this hack that there are no 'uneeded tables' in vBulletin. All tables have their function, and emptying some tables should not be done without very good understanding what they are used for.

Personally i would advice strongly against a hack that not even give the full list of tables that are emptied, but just 'adminlog,session,word...etc.'.

Tables like adminlog, have already a standard vB function to clean, controlled by Admin permissions. Installing this seems to break those permission setting (or at least not use them).

Right...I dont understand...why would we want to empty out "unneeded tables"?

If we really wanted to, we could take a look at our db on our own and do it...I know I personally would never want some script decided what is important and what is not in my db

so are you deffo warning against using this marco??

Thanks for the heads up, If this was allready run what should I look for to see if any damage was done? if anything.
Also would uninstalling this fix or restore any possible breaks in the permissions.
Thanks

Wow thank you!

If this hack empties the "word" table, and you're not using mysql full-text search, you'll end up with a broken search function unless you rebuild your word index.
(using this as a cron job is a very bad idea).

But if you want to move to another host, "cleaning" your database is a good idea, so the database dump will be the smallest possible. (I don't know what it cleans, though)