Changing style IDs

[faeronsayn]

Okay I just decided to customize a theme and use it for a part of my forum, which forces users to default to my theme. So the one that I previously had is going to be switched with the one that I have customized. Problem is this, I have a lot of subforums in that section and I am not planning on going to each one and changing the style from there.

Is it somehow possible to switch the Style ID's so my new theme is now default for that whole section because it has the same style ID as my old one? Is that possible?

 

[Paul B]

Try this:

UPDATE xf_node
SET style_id = 3
WHERE style_id = 2;
 
UPDATE xf_node
SET effective_style_id = 3
WHERE effective_style_id = 2

So 2 is the existing style and 3 is the style you want to change it to.

Take a backup of that table first, just in case.

 

[faeronsayn]

Try this:

UPDATE xf_node
SET style_id = 3
WHERE style_id = 2;
 
UPDATE xf_node
SET effective_style_id = 3
WHERE effective_style_id = 2

So 2 is the existing style and 3 is the style you want to change it to.

Take a backup of that table first, just in case.

We don't need to specify which node we want to change the style ID of ? Or does it just look for a node that has a style ID of 2 and changes it to 3 ?

 

[Paul B]

The latter.

Any node which currently has a style ID of 2 will be changed to 3.