Change Style Drop-Down

This is exactly what you see here, on this board's main page.
It allows you to easily change the style you are using.
Please note that it does not update your user profile as well, it simply sets a cookie, and until it expires you will see the style you selected.
Anyhow, download the attached .txt file and do what it says.

Scroll down to a post by me if you'd like the hack to update the user setting in the database!
The attached version does NOT do that!

Have fun and happy holidays!

[pahbi]

I keep having trouble to:

When I make more than 2 styles, only the first 2 styles are shown in the drop down box.

When I looked at this bit of the code:

// style drop down box (by FireFly)
$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");
while ($thisstyle=$DB_site->fetch_array($allstyles)) {
print "test";
if ($styleid==$thisstyle[styleid]) {
$stylesel='selected';
} else {
$stylesel='';
}
eval("\$dropdownbits .= \"".gettemplate('forumhome_dropdownbit')."\";") ;
}
// style drop down box (by FireFly)

I added the "print 'test';" within the while loop to see how many times it was cycleing, and it seems that the while loop only cycles 2 times, even though I have 3 styles that I've entered.

If I go to my user cp, and choose the last style that I added, and then reload the web page, the while loop then cycles 3 times and shows all available styles.

Is there anyway to configure the mySQL query that is reading the available styles, to print out all the styles that are available?

Thanks,
- Pahbi

[Dalius]

[Dalius]

Come on FireFly, help us out here

[pahbi]

I fixed my problem, and it works fine now.

First I changed in index.php: (its the bit of code for this hack)

$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");

To:

$allstyles=$DB_site->query("SELECT styleid,title FROM style ORDER BY title");

And then in the forumhome_dropdownbit template I changed the text to read:

<option value="$thisstyle[styleid]" $stylesel>$thisstyle[title]</option>

I don't get a users count anymore, but that really wasn't very important to me anyways. The most important thing is that it lists all of the styles available, and allows the person to choose one, and in that regard, this works perfect for me.

- Pahbi

[Graphic-Forums]

Firefly, if you get some time, can you add this to my siote, ive tried. I wouldnt normally ask for help, but I can figure it out.

[Admin]

E-Mail me with your site info (FTP and admin account for vBulletin).

[Graphic-Forums]

Firefly, I emailed you.

[Admin]

Done.

[UtilityGeek]

Sweet hack. Applied it with no problems. Thanks!

[patvdv]

When applying the second version of the hack, I get this error:

[QUOTE]Fatal error: Call to undefined function: getuserinfo() in /opt/apache/htdocs/baan/baanboard/admin/sessions.php on line 323