vb.org Archive - What's the best way to switch all members from Style A to Style B?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - What's the best way to switch all members from Style A to Style B? (https://vborg.vbsupport.ru/showthread.php?t=47136)

alkatraz

12-30-2002 03:52 PM

What's the best way to switch all members from Style A to Style B?

My members are all using the default style, lets call it Style A.

I've been developing a new facelift for the forums as a seperate style/template/replacement set, lets call it Style B

Whats the best way to switch everyone over from Style A to Style B?

Thanks!

Dean C

12-30-2002 04:01 PM

Switch the templates and replacement sets round on the styles :p

SiXXGuNNZ

12-30-2002 06:08 PM

Quote:

Originally posted by Mist
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

alkatraz

12-30-2002 11:43 PM

thx for the help!

With that SQL query, can I do that from the main page of MyPHPAdmin or do I need to be in a certain table?

alkatraz

12-31-2002 02:02 AM

That worked great! I changed all my users to style 4, except you still see style 1 when you aren't logged in. How do I set visitors to style 4? I looked all over the place!!

Dean C

12-31-2002 08:53 AM

I still think the easiest thing to do is swap your templates and replacements around and then run that query to set everyone's style to defaul (with the new template and replacement set)

SiXXGuNNZ

12-31-2002 09:23 AM

default is the logged out style

alkatraz

12-31-2002 01:27 PM

doh Okay thx

So if I were to download the style and then re-upload it (via the Style DL/UL) and overwrite Default that will work, or do I have to manualy go in and copy and paste the contents of all my templates?

Thx so much for your help guys!

Dean C

12-31-2002 02:39 PM

That would work yes...

d/l'ng the style and overwriting default...

- miSt

Herman

01-01-2003 05:07 PM

Yea that would work good, though, then you'd have to run the query so that it's style ID 1

alkatraz

01-02-2003 01:42 AM

Worked great! Thanks guys for all the help

Dean C

01-02-2003 09:00 AM

Your Welcome

- miSt

Xyphen

01-05-2003 04:49 AM

Wow, it worked, thnx for such great help..

Dean C

01-06-2003 10:04 AM

Anytime :P

- miSt

All times are GMT. The time now is 12:46 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02226 seconds Memory Usage 1,731KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (14)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: