PDA

View Full Version : Reset Style for all users?


SiXXGuNNZ
29 Sep 2002, 09:50
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.

Dean C
29 Sep 2002, 11:16
run this query:


UPDATE user SET styleid=x


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

SiXXGuNNZ
29 Sep 2002, 17:31
thank you, worked like a charm :D

Dean C
29 Sep 2002, 18:32
your welcome :D

- miSt

yzztik
21 Mar 2003, 19:22
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?

filburt1
21 Mar 2003, 19:31
09-29-02 at 06:16 AM Mist said this in Post #2 (http://www.vbulletin.org/forum/showthread.php?postid=303796#post303796)
run this query:


UPDATE user SET styleid=x


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

He's licensed.

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

Chris M
21 Mar 2003, 19:34
For the query anyway, you might try (not too sure):

UPDATE user SET styleid=x WHERE styleid=y
x=new styleid
y=old styleid

:)

Satan

Dean C
21 Mar 2003, 20:01
Look at the date of the post filburt ;)

filburt1
21 Mar 2003, 20:21
It's still something people need to know...sans the license of course :p

Dean C
22 Mar 2003, 11:09
Of course ;)

Smoothie
22 Mar 2003, 19:35
Yesterday at 03:22 PM yzztik said this in Post #5 (http://www.vbulletin.org/forum/showthread.php?postid=370870#post370870)
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
22 Mar 2003, 19:53
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 (http://www.vbulletin.org/forum/showthread.php?s=&threadid=34480&highlight=styles+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
22 Mar 2003, 20:00
Hell, too much work for me. I just updated all members to use styleid=1.

yzztik
22 Mar 2003, 20:07
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
22 Mar 2003, 20:12
I'd probably have a riot on my hands if I did thatmembers on my board will get over it.