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!

[JJR512]

I would just like to have the number of users using each style show up by the style name in the drop-down box in the user cp->Edit Options screen. Could someone show me how to do that?

[futureal]

It's very simple, actually.

In member.php, search for $thisstylename to get you near the correct area (exact like is 739 in my modified file in 2.2.6).

Replace:

PHP Code:

   $stylesets=$DB_site->query("SELECT * FROM style WHERE userselect=1 ORDER BY title"); 


With this query from FireFly (line break added):

PHP Code:

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


A few lines down, right after this:

PHP Code:

      $thisstylename = $thisset['title']; 


Add this:

PHP Code:

      $thisstylecount = $thisset['count']; 


Then change the template modifyoptions_styleset to look something like:

PHP Code:

<option value="$thisid" $selected> $thisstylename ($thisstylecount users)</option> 


And that should do it. At least, that worked in my forums (I just tried it).

[JJR512]

Thanks! You know, I had tried that EXACTLY, and it didn't work for me...until I saw in your directions that I had one little mistake. I had used $thisstylecount = $thisstyle['count']; instead of $thisstylecount = $thisset['count'];. Oops! Thanks.

[BigJohnson]

That works great but still how do you fix that prob if no one is using that style it wont show up in the drop down? HUH. And I don't want to place each style maually in the drop down because I like the feature where it says how many people are using that style. Unless there is another way please help me. Tell me my options. Thanks.

[Smoothie]

register a user for each style that has no users.

[BigJohnson]

lol hehehe. What about a real way to fix the prob hehe.

[Angelus]

Hello. Thus only times I excuse for my bad English and secondly legend I thank myself for this hack. But unfortunately I have thereby a problem. If I change thereby the Style, in the User Controll Pannel unfortunately nothing one changes. Thus if someone changes and stores attitudes, he gets the default back Style. Then one there perhaps which make?

[countryboy713]

Can someone Post here on how to fix the un-selected style problem?

A real one, lol, i dont want more empty users on my board than there is already!

[Kasper_H]

I love this hack!
Working perfectly I don't mind the "bug" which does that styles not used won't show up... I actually think that's good

[HappyPike]

I did what futureal wrote in post #112 but the how many users are using each style number is still not accurate. Can someone help? I am running 2.26.

My forum