Change Style dropdown on ALL of your vB pages :) (hardcoded, no queries)
 

HACK: Change Style dropdown on ALL of your vB pages :) (hardcoded, no queries)
BY: KuraFire [www.kurafire.com]
DESCRIPTION: Allows users/guests to change the style on ANY given vB page of yours
DIFFICULTY: Medium
INSTALL-TIME: 10 minutes
STEPS: 9

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 not require a query for every pageload to get the different Styles, but it does require you to hardcode your Styles into the global.php file. There is also a version where you don't have to do that, but that will add one query to every page load.

PROS FOR THIS VERSION:
- no query extra for every page load of your vB
- drop down box isn't as wide as with the other version of the hack
CONS FOR THIS VERSION:
- the amount of users using each style is not displayed;
- if you add more styles, you have to hardcode the new ones into your global.php again.

Personally, I use this version, for I don't add styles very often at all (made 6 initial ones and will only add 1 more style somewhere in the coming year or two :D), and I like to keep my query count as low as possible on every page load :)



Install instructions are in the attachment. Enjoy / good luck :)

This file is needed for Step 4 of this hack (put it in your /admin directory!!)

Ill try

Sigh .. what can I say :)

Another feature filled by kurafire :) Thank you! :)

nice, might try...

The hack is nice, might use it in the future ;)

Having some trouble with step 8, you say:

Step 8
----------
Run this query on your database (in phpMyAdmin or wherever you run your queries on):

UPDATE template SET templatesetid='-1' WHERE title LIKE 'header_stylebox%' LIMIT 2;

I'm pretty new to php, how do I run this query? I assume phpMyAdmin is a seperate program sort of like Telnet?

Thanks in advance for any tips.

you just have to run that query on your database. phpMyAdmin is a webbased administration system in which you can very easily run queries on your DB, but you can also telnet to your server, login to the mysql server and run that query from there. :)

I tried to run the Query in phpMyAdmin but it didnt seem to work.

I went to menu SQL (right to Structure) and pasted

UPDATE template SET templatesetid='-1' WHERE title LIKE 'header_stylebox%' LIMIT 2;

into the "Run SQL query/queries..." field. Then I hit Go. After that, it says "Affected rows: 0" and I dont see any changes to the database.

Any help would be greatly appreciated!!!

I'm not sure if there is a reason fo rit, but I found a problem with the instructions for Step 5.

I found that on installing this on my test board the nc_stylechangebit needed to be changed to header_styleboxbit which is a template the instructions tell you to make in Step 6.

Anyway since I'm still just learning the finer points of php it might just be me, but I thought I should bring it up.