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