Reset Style for all users?

[Smoothie]

Yesterday at 03:22 PM yzztik said this in Post #5
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?

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

[yzztik]

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.

[Smoothie]

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

[yzztik]

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.

[Smoothie]

I'd probably have a riot on my hands if I did that

members on my board will get over it.