Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 12-24-2009, 07:03 PM
BioFall BioFall is offline
 
Join Date: Sep 2009
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Easy way to change the Style ID?

The reason I want to change the style ID on my styles is that I'm using vb xperience as a rewards system. Once users get however many points they unlock a new style for my forum. To change styles they have to download a .txt file that tells them the styleid
ex.
Code:
Congratulations you have unlocked a new Style!

To Change Styles Simply type in one of the URL?s below into the URL bar in your Browser.

Styles you have unlocked
Default Style:     http://www.domain.com/forums/index.php?styleid=13  
vBulletin original:  http://www.domain.com/forums/index.php?styleid=1
As you can see it would be pretty easy to guess the styles, so I need away to change the styleid so one style would be 5 another 213 etc.
Reply With Quote
  #2  
Old 12-29-2009, 12:16 PM
sheppardzwc sheppardzwc is offline
 
Join Date: Dec 2008
Location: South Carolina
Posts: 104
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Just tried it on my dev site - I believe you can use an SQL query and change them, then set them hidden in the AdminCP. Just make sure you have a default style set for users that you already created and didn't edit in MySQL. But might want to ask around a little more - not quite sure how this would affect them completely.

SQL is:

Code:
UPDATE style SET styleid='thenewstyleid' WHERE styleid='theoldstyleid';

Tell me if it works alright. This would be a nice modification.
Reply With Quote
  #3  
Old 08-25-2011, 02:30 PM
PhilG PhilG is offline
 
Join Date: Apr 2003
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I just did it:

1. run the following sql:

Code:
UPDATE style SET styleid='##NEWSTYLEID##', parentlist = '##NEWSTYLEID##,-1' WHERE styleid='##OLDSTYLEID##';
UPDATE stylevar SET styleid='##NEWSTYLEID##' WHERE styleid='##OLDSTYLEID##';
UPDATE template SET styleid='##NEWSTYLEID##' WHERE styleid='##OLDSTYLEID##';
UPDATE templatehistory SET styleid='##NEWSTYLEID##' WHERE styleid='##OLDSTYLEID##';
2. Go to Maintenance > Update Counters > Rebuild Styles. Run
3. Go to Settings > Options > Style & Language Settings. Click Save (no changes necessarily)

That should do it.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:01 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.09130 seconds
  • Memory Usage 2,170KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete