adding subforums via mysql

[wazo]

Hi guys

This is what i would like to do

I run a mobile phone site and have about 9 main categories and 500 sub categories, I would like to convert this to vbulletin as forums and then subforums, I created a script to run that would add it to the 'forums' table in mysql but it looks like vbulletin doesnt actually use this to see which forums are to be displayed

So my questions are

1)Where are the forums and subforums kept in mysql
2) What would be the best process for me to do?

Many thanks

Chris

[Opserty]

It is a tiny bit more complex then just an SQL query, things like the forumcache need to be updated e.t.c. You may want to look at using the vB_DataManager_Forum (http://members.vbulletin.com/api/vBulletin/vB_DataManager_Forum.html), though you will require a bit of knowledge in PHP & vBulletin to get it working correctly.

One thing I would say though is that 500 Subforms seems a bit excessive. My recommendation would be to wait for the stable release of 3.7, this features Thread Prefixes. Using this you could drastically reduce the number subforums you have, if you want to.

[Dismounted]

Which software are you converting from?