changing all users' theme

Worker Joined: Dec 22, 2004 Posts: 135

I need some SQL code tht will change all of my users' theme to a new one. Is there an easy way to do this?

Posted: Wed Jan 19, 2005 10:42 pm

I would suggest changing in the Admin --> Preferences the default theme to the theme that you want and then using something like phpMyAdmin to run the following SQL to blank out all the user specified themes:

Code:




UPDATE  `nuke_users` 


SET  `theme` = NULL;

This would get your site and every user back to using some fixed, default theme of YOUR choice. BUT, make sure you really want to wipe out everyone's selected theme choice!

Regards,
montego

registered · Posted: Thu Jan 20, 2005 8:15 am

I've done that a few times. The responses are mixed. You will for sure get some opinions on the new theme you have installed.

Posted: Thu Jan 20, 2005 6:21 pm

Quote:

SQL-query :

UPDATE `nuke_users` SET `theme` = XP - Silver

MySQL said:

Unknown column 'XP' in 'field list'

how do i fix that?

Posted: Thu Jan 20, 2005 8:19 pm

Set your theme to XP Silver in Your_Account.

Then browse the database table "YOURPREFIX_users".

Find your ID and click the edit option.

Scroll down to theme and see what it shows for the value of the XP Silver theme.

(You need to format the name exactly for everyone else the exact same way it appears for your ID in the database).

Highlight the text and click "EDIT" / "COPY" in your browser.

Click the "SQL" option in phpmyadmin.

Then run the query:
UPDATE `nuke_users`
SET `theme` = "WHATEVER";

(Whatever being pasted in from what you copied out of your ID).

Posted: Thu Jan 20, 2005 9:17 pm

Quote:

Affected rows: 0

SQL-query : [Edit] [Create PHP Code]
UPDATE `nuke_users` SET `user_theme` = 'XP-Silver'

The code went through OK, but it didn't affect any rows. What's that mean?

Posted: Thu Jan 20, 2005 9:30 pm

nevermind, the correct code was 'theme' not 'users_theme'