Change Style dropdown on ALL of your vB pages :) (dynamic, +1 query)

HACK: Change Style dropdown on ALL of your vB pages (dynamic, +1 query)
BY: KuraFire [www.kurafire.com]
DESCRIPTION: Allows users/guests to change the style on ANY given vB page of yours
DIFFICULTY: Fairly Easy
INSTALL-TIME: 5-10 minutes
STEPS: 8

Demo: www.kurafire.com/thecouch/
Just browse around and try changing the style on various pages

EXTENDED DESCRIPTION:
This hack will put a small drop-down box in your Header template, containing all the styles of your vBulletin forum. This particular version of the hack will do one query to gather all your styles (and the amount of users using each style). There is also a version I released which relies on hardcoding the styles into your global.php so that you don't have one additional query on every pageload, which is the case with this hack.

PROS FOR THIS VERSION:
- the amount of users using each style;
- if you add more styles, it's automatically updated
CONS FOR THIS VERSION:
- one query extra for every page load of your vB
- drop down box is fairly wide (due to count-users addition)


Install instructions are in the attachment. Enjoy / good luck

[Oxygen]

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!

[Oxygen]

Place :
$dropdownbox
anywhere in your Home_* templates

[gengar003]

hmm.. I installed it, but the dropdownbox is blank, with no styles on it at all....