[Help] Please huge mistake!

[GateKeeper_]

I am using this pluggin: https://vborg.vbsupport.ru/showthread.php?t=260677

I made about 1000 sub forums however, each one is missing 1 option from:

Enable / Disable Features column

I need to enable one of the BBCodes which is [VIDEOS] but, it is automatically choosen as disable when creating new forums. Is it possible to change the setting without editing each forum one-by-one. I've been spending hours and hours editting these settings. Please help me. Also I can't mass delete these forums either. :(

[Brandon Sheley]

you should ask in that thread if it's about that mod..

[ProFifaLeagues]

Have you checked you have it set up Correct???
•When you add the list of sub-forums, you will notice it will inherit the “parent” forums settings and permissions

[GateKeeper_]

Have you checked you have it set up Correct???
?When you add the list of sub-forums, you will notice it will inherit the ?parent? forums settings and permissions

Yes, but the thing is it didn't the VIDEO tag was disabled. While the parent is enabled.

It's okay, I will just manually edit about 8000 forums, so far 2350/8000 it's been 2 and a half hours. 10 minute break each hour. ^^ Wish me luck. I feel so tired though.

[Kraxell]

USE SQL-COMMANDS!

Ask in topic, which command u use for this option and u set this option to all subforums with one command :)

Maybe:
UPDATE table SET option = REPLACE (option, 'off', 'on')

You must change the table/Option/on-off-field to your database-fields (dont know which this hack use)

[GateKeeper_]

USE SQL-COMMANDS!

Ask in topic, which command u use for this option and u set this option to all subforums with one command :)

Maybe:
UPDATE table SET option = REPLACE (option, 'off', 'on')

You must change the table/Option/on-off-field to your database-fields (dont know which this hack use)

How do you do that? I'm at 3120/8000

This would save me like 5 hours. Where can I find this option. Is it done from Settings?

I'm an amateur at this. Please guide me.

[Kraxell]

Best way you do is, to ask the developer of this addon, because i dont know/use it and dont know the table-names.

You make this with a sql-query (phpmyadmin).

There you can change one setting of all subforums with one command.

--------------- Added 1328650986 at 1328650986 ---------------

How call the feature you want to activate?

Maybe i can help now.

[GateKeeper_]

Best way you do is, to ask the developer of this addon, because i dont know/use it and dont know the table-names.

You make this with a sql-query (phpmyadmin).

There you can change one setting of all subforums with one command.

--------------- Added 1328650986 at 1328650986 ---------------

How call the feature you want to activate?

Maybe i can help now.

I am using this pluggin: https://vborg.vbsupport.ru/showthread.php?t=260677

I will try contacting the person who made this.

Under the Enable / Disable Feature column:
Allow [VIDEO] Code needs to be "ON" not "OFF"

Sorry for bothering you guys.

[Kraxell]

Is this the option for all BBCodes or only IMG? I dont find any option only for Video-BBCode....

Maybe u can make a screenshot for me of the option?

[GateKeeper_]

https://vborg.vbsupport.ru/external/2012/02/52.png

Here it is. I think its for the video itself that enables the video to be converted as embed not as link.

[Kraxell]

Ahhh....i use 4.1.9, there are no option for this....
Maybe try this:

ACP -> Maintenace -> SQL-Query
Maybe there is an option for this. Otherwise we must wait for tomorow, Lynne know the table for this command (iam sure).

[GateKeeper_]

Ahhh....i use 4.1.9, there are no option for this....
Maybe try this:

ACP -> Maintenace -> SQL-Query
Maybe there is an option for this. Otherwise we must wait for tomorow, Lynne know the table for this command (iam sure).

Yeah there is no option in SQL-Query, I will just do as many as I can today, and wait for the command tomorrow.

[Kraxell]

stop to do that manually, you can do it tomorow with one command, i'll help you then.

[GateKeeper_]

stop to do that manually, you can do it tomorow with one command, i'll help you then.

Okay I will wait until tomorrow thank you for your help and time.

[TalkVirginia]

Hey Gatekeeper,

Sorry to hear about all the trouble you're having. I just got an email about this. I just got home from work and will take a look at a fix for this. Can't promise a fix tonight but I'll do my best.

Thanks
Jim

[GateKeeper_]

Hey Gatekeeper,

Sorry to hear about all the trouble you're having. I just got an email about this. I just got home from work and will take a look at a fix for this. Can't promise a fix tonight but I'll do my best.

Thanks
Jim

Thank you so much. I really appreciate your help. I will be waiting for the fix.

Best Regards,
GateKeeper

[TalkVirginia]

Thank you so much. I really appreciate your help. I will be waiting for the fix.

Best Regards,
GateKeeper

How many top-level forum categories do you have?

I recommend taking a backup of your forum database before doing this.

You can run this SQL Query to enable the options listed below for ALL forums and categories however it will also change ALL of your top-level forum categories to look and act as forums. You will need to edit the options under the forum posting options to switch them back to top level categories.

Allow BB Code
Allow [IMG] Code
Allow [VIDEO] Code
Allow Smilies
Allow Post Icons
Allow Thread Ratings in this Forum
Count Posts Made in this Forum Towards User Post Counts
Show this Forum and Child Forums on the Quick Navigation menu


You will need to change to query to match the table prefix you are using. For instance, I'm using the "vb_" in front of all my vb table names. You should be able to run this from the maintenance section of your admincp or you can use phpmysqladmin.



UPDATE TABLEPREFIX_forum
SET options = '360135';



I'll try to add these options this weekend to the addon. Let me know if you have any questions.
hopefully this will make things a little easier. This was tested on vb 4.1.10.

Jim

[GateKeeper_]

Thank you Jim, it worked but there are extra lines now. Is that normal and what does that mean? Anyways this saved me tons of time! Really appreciate it.

https://vborg.vbsupport.ru/external/2012/02/51.png

--------------- Added 1328670730 at 1328670730 ---------------

I used ACP > Management > Execute SQL Query >

UPDATE TABLEPREFIX_forum
SET options = '360135';

(With my table prefix)

[TalkVirginia]

Thank you Jim, it worked but there are extra lines now. Is that normal and what does that mean? Anyways this saved me tons of time! Really appreciate it.

I used ACP > Management > Execute SQL Query >

UPDATE TABLEPREFIX_forum
SET options = '360135';

(With my table prefix)

Glad to hear it helped. :) I'm not sure what you mean by extra lines though.

[GateKeeper_]

Glad to hear it helped. :) I'm not sure what you mean by extra lines though.

Can you also give me the sql command that enables "Moderate Thread" under "Moderation Options" please. I forgot to enable this option for over 10,000 child forums. :( Doing it manually will take me over 24 hours of work.

[TalkVirginia]

Can you also give me the sql command that enables "Moderate Thread" under "Moderation Options" please. I forgot to enable this option for over 10,000 child forums. :( Doing it manually will take me over 24 hours of work.

Ok. I'm working on a better fix for this than a quick and dirty fix.

[Lynne]

Do you really need that many forums? Unless you have the most awesome servers around, I would not do that. Thread prefixes are the way to go.

[GateKeeper_]

Do you really need that many forums? Unless you have the most awesome servers around, I would not do that. Thread prefixes are the way to go.

Its for movies titles, genres, and etc. I have over 20,000 movies, I'm making a section for each one and each of the movies. Thats the reason why I have so many forums. If they are clumped in one forum it would be really messy in my opinion.

Does forum section really take that much bandwidth I haven't check lately how much the forum took. What happens if I make 20,000 forums?

@Talk Thank you for your help I will be waiting for your update.

[Kraxell]

i think a addon do this job better.

Maybe a wiki or something.

[GateKeeper_]

Any news on the update?

[setishock]

Link to your forum? PM if you like.

[TalkVirginia]

Any news on the update?

Working on it. :erm: I got swamped with work and family. Soonest I can get back on it is Friday night. Sorry. :(

[GateKeeper_]

Working on it. :erm: I got swamped with work and family. Soonest I can get back on it is Friday night. Sorry. :(

Okay I will be waiting. This option is extremely important, really appreciate your help.

Also can you make options like setting all the childforums as display order "1" and being able to add more than 20 forums with getting an error? Because, since like max you can add is like 20~30 forums, I have to re-add and the forum sections are all mixed up not in-order.

[GateKeeper_]

Working on it. :erm: I got swamped with work and family. Soonest I can get back on it is Friday night. Sorry. :(

Sorry, I was just wondering if there is any news about the update yet?

[GateKeeper_]

:(

/10char