MyBB Community Forums

MyBB Community Forums > 1.8 Support > General Support > query to move users from theme to theme
Full Version: query to move users from theme to theme
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

andrewjs18

2015-01-27, 07:22 AM
Hi,

I have a 4 theme options on my forum right now.  I'm going to be reducing that to 2 soon.  how can I move users who use say theme 1 to theme 3 and users who use theme 2 to theme 4?

thanks!

dragonexpert

2015-01-27, 07:25 AM
UPDATE mybb_users SET style=3 WHERE style=1;
UPDATE mybb_users SET style=4 WHERE style=2;

andrewjs18

2015-01-27, 07:32 AM
(2015-01-27, 07:25 AM)dragonexpert Wrote: [ -> ]
UPDATE mybb_users SET style=3 WHERE style=1;
UPDATE mybb_users SET style=4 WHERE style=2;

thanks.  I'll try it out shortly.

.m.

2015-01-27, 07:57 AM
just a note : theme id can be found from themes section of admin panel.
hovering mouse point on theme shows theme number in browser status bar (~/index.php?module=style-themes&action=edit&tid=x)
MyBB Community Forums > 1.8 Support > General Support > query to move users from theme to theme