Query for adding forums

[DaveNGU]

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,

[ForceHSS]

You want a query that will make forums for you?

[final kaoss]

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

[DaveNGU]

Originally Posted by ForceHSS

You want a query that will make forums for you?

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.

[ForceHSS]

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

INSERT INTO `forum` VALUES ('1', '0', 'Main Category', 'Main Category', 'Main Category Description', 'Main Category Description', '86017', '0', '1', '0', '0', '', '0', '', '0', '0', '', '0', '-1', '', '', '-1', '1,-1', '', '', '1,2,-1', 'lastpost', 'desc', '');

Forum inside main section

INSERT INTO `forum` VALUES ('2', '0', 'Main Forum', 'Main Forum', 'Main Forum Description', 'Main Forum Description', '89799', '0', '1', '0', '0', '', '0', '', '0', '0', '', '0', '-1', '', '', '1', '2,1,-1', '', '', '2,-1', 'lastpost', 'desc', '');

This is only a guide

[Elite_360_]

Originally Posted by DaveNGU

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.

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

[DaveNGU]

Originally Posted by Elite_360_

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

100 new forums which are marked inactive .

[vBNinja]

Originally Posted by DaveNGU

100 new forums which are marked inactive .

Would they all have the same parent forum/category?

[squidsk]

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.

[DaveNGU]

Originally Posted by vBNinja

Would they all have the same parent forum/category?

Yes!