drop all non standard tables?

[bashy]

Hi

Is there a modification/hack/program that will drop/remove all non standard vb tables?

I am looking to clean up my act and remove every thing that is none standard and start again without loosing any posts or user information...?

[Staxed]

you could always just removed them via phpmyadmin...

[bashy]

well i thought about that but then some hacks add tables in the tables such as extra tables in the users tables, aint got a clue whats meant to be there and whats not?

[Staxed]

hmm...i thought there was a list somewhere...i'll see if i can find it

hmm...couldn't find it anywhere...just found this thread though...which mentioned doing a fresh install and then a table stucture dump...

http://www.vbulletin.com/forum/showthread.php?t=95997&highlight=table+list

[bashy]

Im sure theres a list somewhere also, i checked the manual but nothing...i will take a gander at your link thanks :)

Found it sort of, from your link, in the last post someone there pointed in the right direct.... /install/mysql-schema.php

Thanks for ya help :)

ps theres loads of tables and subtables, a proggy would have been great lol this is gonna take a lifetime and some :(

[Marco van Herwaarden]

If i remember correct, Andreas once made such a modification....long time ago.

[bashy]

Thanks for the info Marco, will take a look in his profile :)

Found it, https://vborg.vbsupport.ru/showthread.php?t=101486
Big help guys, thanks alot :)

[Staxed]

know if it works for 3.6.4?...as tables of 3.5 and 3.6 are probably different...

Thanks for the info Marco, will take a look in his profile :)

Found it, https://vborg.vbsupport.ru/showthread.php?t=101486
Big help guys, thanks alot :)

[bashy]

Nah, it didnt install anyway :( gutted....

[Staxed]

i just tried it...worked fine for me...

the installation doesn't finish...but it displays a list of the tables that were added or modified from the orinial (and it pulls info from the schema.php so it should work on any version)