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

[PennylessZ28]

I don't want to be a butthole, but I'd be werry too of someone with 29 posts releashing their first hack that evades and empties your database.

[Marco van Herwaarden]

Originally Posted by GTAce

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

Like i said, vB don't have any unneeded tables, they all have their purpose. Unless you know very good what you are doing and don't need a table in your situation, i would advise against using this.

Originally Posted by Gizmo5h1t3

so are you deffo warning against using this marco??

See above.

Originally Posted by XtremeOffroad

Also would uninstalling this fix or restore any possible breaks in the permissions.

I didn't have a look in the hack itself. But i guess no permissions will be broken, just that some stuff that is controlled by an admin permission in standard vB, will probably be open for use without the permission (assumption).

Originally Posted by Symen_4ab

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).

That is exactly my point. There are some situation (full-text for example) in which it could be good to empty the word table, but in all other cases it could for example break your search. Without warnings like that, i advise not to use this, unless you are capable of checking what it exactly does, and know 100% that it wil be the best to do in your situation.

Originally Posted by Symen_4ab

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)

That could be a reason to do it, but you would need to be aware that you would loose info or have to rebuild info after the move.

[Symen_4ab]

Originally Posted by MarcoH64

Like i said, vB don't have any unneeded tables, they all have their purpose. Unless you know very good what you are doing and don't need a table in your situation, i would advise against using this.
See above.
I didn't have a look in the hack itself. But i guess no permissions will be broken, just that some stuff that is controlled by an admin permission in standard vB, will probably be open for use without the permission (assumption).
That is exactly my point. There are some situation (full-text for example) in which it could be good to empty the word table, but in all other cases it could for example break your search. Without warnings like that, i advise not to use this, unless you are capable of checking what it exactly does, and know 100% that it wil be the best to do in your situation.
That could be a reason to do it, but you would need to be aware that you would loose info or have to rebuild info after the move.

Congrats on 7000th post Marco

Hum.. Back on topic, to say that I have nothing more to say..

[Tidy]

Just What I Need Thank You Very Much!

[Tidy]

Just What I Need Thank You Very Much!

[Zia]

Should I Use It ??

[XtremeOffroad]

Originally Posted by Zia

Should I Use It ??

I thaught by now the creater would have had some updates on details or comments on their hack.
After all the warnings most if not all coders would have at least come by to explain a bit more details or try to back up their hack.
Coders I have alot of trust in have commented on this and I'll take their warnings till the author comes here and shows otherwise.

[Gizmo5h1t3]

mebbe it would be wise to remove this, until the author supplys a reasonable argument as to how this could serve any useful purpose,while having it remain safe for users.
dont forget....most ppl on here..(including me)...ARENT l33t coders etc.....and might just install this, and find things going wrong...

props to marco for the warning tho....

[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.

[HaMaDa4eVeR]

Originally Posted by MarcoH64

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).

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 ,
the full list of tables you will find screen shot that i attached it here , and when you install it I named the link with table name , if you click (Clean Word Tables) you will empty the word tables and so on...

Symen_4ab: yes that's my aims ,, if you want transfer your site from host to anther and your database size 700 MB , sure my hack will help you , coz. word tables took more than 20% from post tables .
I advice you to test 1st in your test forum ,
thanks all and sorry for delay replay