vb.org Archive - Change Style dropdown on ALL of your vB pages :) (dynamic, +1 query)

So I love this hack, even with the bug in UserCP and User Styles. having to have one member or they do not show (there even may be a fix)

I wanted it to function on my vhHome...
Here is what I did:

in vhHomes global.php (BACK IT UP!!!!!!)

Find :

PHP Code:


		
			
// +--------------------------------------------------------------

// | Include sessions

// +--------------------------------------------------------------

include_once( './' . $adminpath . '/sessions.php' );

Above Place:

PHP Code:


		
			
//Style Addition

  if (isset($changestyle)) {

     $styleid = intval($changestyle);

  }

//Style Addition

Below Place:

PHP Code:


		
			
//Style Addition

  if (isset($changestyle)) {

    if ($styleid!=0 && is_numeric($styleid))

      $DB_site->query("UPDATE user SET styleid=$styleid WHERE userid=$bbuserinfo[userid]");

  }

//Style Addition

Find:

PHP Code:


		
			
$templatesused.= 'phpinclude,home_headinclude,home_header,home_footer,home_usernameloggedin,home_usernameloggedout,home_error';

Replace with:

PHP Code:


		
			
//Style Addition

$templatesused.='header_stylebox,header_styleboxbit,phpinclude,home_headinclude,home_header,home_footer,home_usernameloggedin,home_usernameloggedout,home_error';

//Style Addition

Find:

PHP Code:


		
			
$homeheadinclude = '';

$homeheader = '';

$homefooter = '';

$search = '';

$links = '';

Above Place:

PHP Code:


		
			
//Style Addition

$boxurl = $PHP_SELF . "?" . $_SERVER['QUERY_STRING'];

$boxurl = str_replace("s=$session[sessionhash]", "", $boxurl);

$boxurl = preg_replace("/(&changestyle=(.{0,2}))/", "", $boxurl);

$boxurl = str_replace("?&", "?", $boxurl);

if(substr($boxurl, -1)!="&"){

    $boxurl .= "&";

}

$dropdownbits = "";



$allstyles = $DB_site->query("SELECT style.title, user.styleid, COUNT(*) AS count FROM user LEFT JOIN style USING (styleid) WHERE style.styleid IS NOT NULL AND style.userselect=1 GROUP BY user.styleid");

// this query was thanks to FireFly's hack :)  (credit where credit is due)



while ($thisstyle = $DB_site->fetch_array($allstyles)){

    $stylesel = ($styleid==$thisstyle[styleid]) ? "selected=\"selected\"" : "";

    eval("\$dropdownbits .= \"".gettemplate('header_styleboxbit')."\";");

}

eval("\$dropdownbox = \"".gettemplate('header_stylebox')."\";");

//Style Addition

Upload and enjoy!

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01065 seconds Memory Usage 1,740KB 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 (7)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: