Reset Style for all users?
 

I would like to know if there is a way, let's say, to change all the users style back to default. I use the what style's we are using hack, and reuploaded my styles. now it only shows the name of the theme I selected. I am wondering if I can run a query maybe to reset everyone back to default, and then let them choose a diff style so all users/style count is accounted for.

run this query:

[sql]
UPDATE user SET styleid=x
[/sql]

where "x" is the styleid of the style your want to be assigned to all the users...

__________

*waits for the you need to go here to be a fully licensed member thingy from a mod lol*

- miSt

thank you, worked like a charm :D

your welcome :D

- miSt

What if I deleted some styles but the database still says they are using that styleid even though it does not exist. It shows up in the what styles they are using as blank even though I think it automatically selects the next one for them.

What if I want to run a query to change every user in the db who has styleid x to styleid y?

He's licensed.

Some members might have to log out and log back in if they were cookied wiyh a styleid.

For the query anyway, you might try (not too sure):

[sql]UPDATE user SET styleid=x WHERE styleid=y[/sql]
x=new styleid
y=old styleid

:)

Satan

Look at the date of the post filburt ;)

It's still something people need to know...sans the license of course :p

Of course ;)

I have the same problem, but how would you know what styles they were using if they were deleted?

what I did was looked up the styleid for each of the remaining styles and note those down.

Then I used this hack [Who's Using Wich Style On One Page] to see which styles were being used and put the styleid number next to each of the ones that I knew. Since they are listed in numerical order, I then search the user table in phpmyadmin for the missing styles until I matched up each of the missing ones with a styleid. Then I ran the query to change those to the default.

Hell, too much work for me. I just updated all members to use styleid=1.

I'd probably have a riot on my hands if I did that, so I took a bit of time to do this. It really didnt take that long. It was easier than it sounds.

members on my board will get over it.