Changing styles en mass

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • Trevor Hannant
    replied
    ***MAKE SURE YOU HAVE A BACKUP OF YOUR DATABASE BEFORE RUNNING ANY QUERIES AGAINST IT***

    Try this:

    UPDATE user SET styleid=8
    WHERE styleid=4;

    If your table has a prefix, make sure to add this in also

    Leave a comment:


  • kersti
    started a topic [vB4] Changing styles en mass

    Changing styles en mass

    I've just done some changes to the styles and templates on my site following both a vB upgrade and a server upgrade that broke current settings in a nasty way. It was easier to start from a clean slate ut this means I've most users on broken styles.

    I'm looking for a way to migrate users from one style to another via a database query. For example, migrate all users currently using styleID 4 to use styleID 8

    Alternatively, is there a simple way to blow away all existing template and style changes for styleID4 and replace with styleID8?

    Can anyone help?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...