Query for adding forums
 

Hello,

I'd like to add a list of forums and mark 'forum is active' as no, and would prefer to do it within a query to save time. What would be the correct format for this?

Thanks,

You want a query that will make forums for you?

Not sure about turning it "off" but there is an addon to automatically add forums.

Sort of, I guess, but the main trouble I'm having is with marking them as inactive.

I want to add a list of about 100 forums so it makes sense to do it in one query rather than manually.

would take u longer to make the query as u need to make a different name for each forum section and permissions for each
but here are two querys to get you started

Main section
Forum inside main section
This is only a guide

do you want to make a list of 100 new forums or make 100 forums inactive?

100 new forums which are marked inactive :).

Would they all have the same parent forum/category?

You'd be better off writing a php script that uses the forums datamanager and having that create 100 forums with the settings you need. Forum creation impacts more than just the forum table so just filling in entries in the forum table may or may not accomplish what you're after.

Yes!