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 ;)