Style Select Drop Down (users using it)

[wolfe]

how do i add next to the Style name how many users are using it like VB.org have Blue (6789 Users)

anyone

[DiSS Troya]

if im not mistaking that should automatically be there.

make sure your script says:

<option value="$thisstyle[styleid]" $stylesel>$thisstyle[title] ($thisstyle[count] users)</option>

the particular bolded information, so the count will show up..

[wolfe]

here m8 here is what i got code because that don't work

<form>
<p align="right">
<select name="newstyleset" onChange="location.href=('index.php?styleid='+this .options[form.newstyleset.selectedIndex].value)">
<option selected>Style Seletor</option>
<option value="1">Blue</option>
<option value="2">Black & White</option>
</select>
</p>
</form>

and that bit of code don''t work

[DiSS Troya]

Try and make sure you've done all of this..


In index.php, find this:
=========================
// if user is know, then welcome

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

Now create a new template, call it forumhome_dropdownbit with this in it:
================================================== ========================
<option value="$thisstyle[styleid]" $stylesel>$thisstyle[title] ($thisstyle[count] users)</option>

And last but not least, add the following to your forumhome template anywhere you want:
================================================== ======================================
<select name="styleid" onchange="window.location=('index.php?s=$session[sessionhash]&styleid='+this.options[this.selectedIndex].value)">
$dropdownbits
</select>

By the way, you don't have to add the value names to each of your style sets to the code, because when you add the drop down option code to each of your style sets, and having selected them all via user cp, they'll all appear available for you to use