vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Switch which default style, retain member choice? (https://vborg.vbsupport.ru/showthread.php?t=44233)

TutorialForums 10-03-2002 05:30 AM

Switch which default style, retain member choice?
 
Hi -

I'm trying to change one of my secondary styles to become my Default style.... well doing that alone of course is very simple... but I want to have it so that members will retain their style selection (i.e. those who were using the "original" default style will still use it, those who were using the secondary-now-default style will still use that). When I change the style as is, now all those who used the original are using the new, and all those who were using the new are using the original.

Actually I ran into another problem as well while messing with this - now if I upload either of the styles, trying to return things to how they were before, it changes BOTH to the same style, no matter what.

Anyhow - hoping someone can help. Worst case I guess I can reset everyone to use the new Default, and let them re-select the style of their choice....

Thanks!

g-force2k2 10-04-2002 01:50 AM

first find out what style id the defualt and the new one both are... and remember them!

in this instance XX will represent the default style id and YY will repesent the new style id

then run this query: (changes to an non existance so the switch can be preformed)

UPDATE user SET styleid=0 WHERE styleid=XX AND userid != 0

then run this: (update the YY users style to XX users style)

UPDATE user SET styleid=XX WHERE styleid=YY AND userid !=0

finally run this query: (updates the XX users style to YY users styl)

UPDATE user SET styleid=YY WHERE styleid=0 AND userid != 0

hope that helps... regards...

g-force2k2

Katman 10-14-2002 04:00 AM

I did this and it worked, problem is it made EVERYONE's default style the new style. But I suppose they can change it back if they want.

But at the same time visitors still see the old style, it did not change the default style for guests/visitors to the new style.

Any ideas on how to do that?


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

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00973 seconds
  • Memory Usage 1,709KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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