Mini Mods - Mass Child Forums

Add Mass Child Forums vBullentin Addon - v1.0.0

What does this addon do?
This addon is used to create mass child forums. Submit a list of child forums you want to create then select the parent forums you want them created under. For example, if you're running a statetalk forum that has 39 counties and 281 cities it would take you roughly 131+ hours to create and setup all those forums by hand. This Addon will do that for you with the click of a button.

INSTALL INSTRUCTIONS:
1. Back up current forum system if you feel it necessary.
2. FTP all contents under the upload folder to your site host where you have your forum installed.
3. Import the Add Mass Child Forums.xml file and refresh your browser.

You should see the "Add Mass Child Forums" menu item at the bottom of the "Forums & Moderators" AdminCP menu list.

This addon is based on the EPC Add Mass Child Forums Hack created by member blogtorank which was released in 2007 and hasn't been updated nor supported. Since I haven't been able to get intouch with the developer, I've taken the liberty to update the addon for those that have used it in the past and those that have been asking for this functionality. I give full credit to the original developer and all the work that was put into the original code.

How to use this hack:
1. Once you have read the installation and installed properly then you are ready to start utilizing this hack.
2. Login to your forums Admin Control Panel i.e. /admincp/ as an Administrator;
3. Navigate to: Forums & Moderators >> Add Mass Child Forums
4. Have your list of forums that you are ready to drop into ?Title? box.
5. Once you done the above, you can then press Save.

Key notes:
?Making sure your php.ini is set to allow for longer script running times. As an example, however not necessarily recommended. It?s nice to increase your settings if you are working on setting up a massive forums:
max_execution_time = 9000
memory_limit = 32M

?When you add the list of sub-forums, you will notice it will inherit the ?parent? forums settings and permissions. Do not set parent forums until you have all parent forums on there and ready to go, Example: Say you have parent forums set to "Closed" and it says (Forum is Closed for Posting), well this will inherit all those settings.

?If you do accidentally set the forums to closed, what you need to do is run a query inside MySQL as follows, as you see below we are telling MySQL to change all the following forums to be OPEN less the HTML allowed in the forums:

MySQL Query to run just in case.

UPDATE TABLEPREFIX_forum 
SET options = "89799" 
WHERE title IN ('Welcome Forums', 'General Forums', 'Family Forums', 'Event Forums', 'Animal Forums', 'Music Forums', 'NON-Profit Forums', 'Religious Forums', 'School Forums', 'Sports Forums', 'Business Forums', 'Consumer Forums', 'Employment Forums', 'Advertisement Forums');

Make sure you replace "TABLEPREFIX" with the table prefix you are using. For example: I'm using "vb_". Also, make sure you change the forum titles in the query with your own that you want to fix, otherwise nothing will happen.

That is basically it! If you have any ideas, concerns, or questions, feel free to ask. All support will be given here as best as I can. I work on addons in my spare time, so responses may be delayed. Remember this is a free hack and if you find that you like it, feel free to donate to show your appreciation.

[TalkVirginia]

Originally Posted by vAsia

Is there a way to add description too?

Ex:
Title;Description

I'll look into this over the weekend.

[Kraxell]

Hey virginia,

do you can take a look at this thread?
https://vborg.vbsupport.ru/showthrea...61#post2297261

I think the fingers of this guy are bleeding

[TalkVirginia]

Originally Posted by Kraxell

Hey virginia,

do you can take a look at this thread?
https://vborg.vbsupport.ru/showthrea...61#post2297261

I think the fingers of this guy are bleeding

Actually the name is Jim. but anyway, thanks for the heads up on this. He's all set. I'm going to try updating this mod over the coming weekend, providing my @home todo list isn't too long.

[vetty]

This Mod is a Life-Saver ! Works in v 4.1.11
Thank you very much TalkVirginia !!!

[davio33]

UPDATE TABLEPREFIX_forum
SET options = "89799"
WHERE title IN ('Welcome Forums', 'General Forums', 'Family Forums', 'Event Forums', 'Animal Forums', 'Music Forums', 'NON-Profit Forums', 'Religious Forums', 'School Forums', 'Sports Forums', 'Business Forums', 'Consumer Forums', 'Employment Forums', 'Advertisement Forums');

Does anyone know how to do a wildcard on the "WHERE title IN" Like if i had 20 forums and wanted the command to effect all the forums that included the word "shoes"

[final kaoss]

Thanks I'm looking into using this.

You should fix it up so we can add X amount of forums per batch. I only managed to get 285/1300 added. I'm using hostgator shared plan too which has a 30 second script limit I believe.

Check out how mysql dumper and the vbulletin built in scripts handle this stuff to avoid timeout issues.