Mod Name / Version: Stylesheet Popularity 1.0

Description: Adds a quick link (graphical interface) in the Admin menu to display how many users are using which of your stylesheets. Saves having to remember the query.

Working under: 6.2

Any pre-requisites: none

Author(s): JoshPet from www.joshuapettit.com
              for discussions and bugs go to www.ubbdev.com

Date: 2/21/03

Credits: The Real Kudos go to RandyJG for the Query I used.

Files Altered: /admin/menu.php

Database Altered: No.

New Files: csspopularity.php is added to the admin directory of your threads install.

Notes: Very simple hack.

Added this one... interesting to see which one the folks are using. I was surprised.

Very !

If we delete lines:

// -------------
// Get the input
$Cat = get_input("Cat","get");

File will be work under [6.1.1] version

That's good to know, I think I'll install it then. It's a nice little script.

he he
You gotta get to 6.2.

Easiest mod I've ever added! Nice work

Well, I can answer 6.1.1 questions easier, so maybe I'll just stick to this version. =] Nahh. Just need to get my site moved to a new CMS before I upgrade threads, and I also think my users need some time before any more changes to threads. They are very frail, any change at all and they go completely insane. Even if it is something they've been bugging me to fix for ages...

Very good. Thanks Josh

Very nice one Josh! Thanks for that!

I never knew how popular some stylesheets are!

What about the option to force the users who have selected "style sheet x" to now use "style sheet y" so that if you change the style sheets you can fix style sheet errors before people complain

This is great... one queston i have 16 people useing a style that has NO Name... yesterday I had forced everyone to use default.

I have cleared my style sheets and uploaded only the default one plus my styles.

Any thoughts?

[]yesterday I had forced everyone to use default[/]

How exactly did you do that?

josh told me how

https://ubbdev.com/threads/php/...ew=collapsed&sb=5&o=&fpart=1

The same thing happened to me.

Yeah, I've noticed Blank Stylesheets to... which would cause them to end up being shown the default.

But I notice that even shorly after I reset everyone with the query.

Ok. The default value for a user's stylesheet is NULL, which is interpreted the same as 'usedefault', and would show up as an empty string when this hack is used.

Thanke for the explanation dave! Is this another one of those "irritations" in Threads that needs to be fixed?

Dave, is this is another case where "NULL" shouldn't be used?

Shouldn't the default setting in the database be 'usedefault'?

Sounds like it. They can really make things work in quirky ways.

There's really no point in allowing NULL for that column. If could just as easily default to 'usedefault', or ''. I would prefer '', since it saves space. If you have 10000 users with 'usedefault', that's 10 * 10000 = 100000 bytes just to store that info, which is silly.

If you don't like the fact that this hack displays no name when U_Stylesheet is NULL (or ''), just display 'usedefault' instead for those cases.

Neat, needs updating since 6.3 has editable languages Was the blank result ever fixed?

I return to this hack, how change srpit to show not file names but only describe of stylesheets.

Could anyone 6.5 this script, or is there some other script that does the same now?

This script isn't needed anymore - all the old mod did was "store" the query for you (before Threads had the ability to save SQL Queries. I responded with directions in your other thread.

Here's the query that it used... https://www.ubbdev.com/forum/showflat.php/Number/123064#Post123064