Clean vB Database

[HaMaDa4eVeR]

*** 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 (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=107134)
(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
=======================================

[OmeR4eVeR]

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

[GamerJunk.net]

Does this clear out the idea database?

[Developer]

thnx hamada4ever

[Marco van Herwaarden]

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

[GTAce]

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

[Gizmo5h1t3]

so are you deffo warning against using this marco??

[XtremeOffroad]

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

[Snake]

Wow thank you!

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

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)

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

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.
so are you deffo warning against using this marco??See above.
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).
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.
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]

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]

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]

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...
https://vborg.vbsupport.ru/attachment.php?attachmentid=42112
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

[Paul M]

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 damageI'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]

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?

[Marco van Herwaarden]

plainly this still being available to all cant be a good idea, if its gonna cause probs?
Warnings have been posted, if someone wants to install this, it is their own free choice.