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.

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

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

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

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.

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

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

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.

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

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?