Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2006
Posts: 464
Likes: 1
M
Addict
Addict
M Offline
Joined: Jun 2006
Posts: 464
Likes: 1
I thought it might be nice to have a quick query of which styles are being used on your site. I have like 15 styles and it would be good to remove the styles no one uses.

This could be a link in the Styles edit area in a form based inquiry type metaphor..


Happy Customer !!!
Joined: Aug 2006
Posts: 1,358
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,358
Sirdude posted a query once you can use for that. Would be nice to have it buildin, including stats about post_side/post_top and other user preferences.

SD's query:
Code
SELECT CONCAT( '[*][url=http://themepark.nl/ubb/ubbthreads.php?ubb=previewskin&skin=', t2.STYLE_ID, ']', STYLE_NAME, '[/url]' ) AS Style, CONCAT( '[color:red](', COUNT( t2.STYLE_NAME ) , ')[/color]' ) AS Count FROM ubbt_STYLES AS t2, ubbt_USER_PROFILE AS t1 WHERE t1.USER_STYLE = t2.STYLE_ID GROUP BY t2.STYLE_ID ORDER BY t2.STYLE_NAME


[Linked Image from siemons.org]
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
Good idea and it has legs with other info too.

Full Pm Boxes etc..


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
Where would you put this and such?

Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
In the control panel for admin use (Stats if you like).

Currently we can save a query in the Tools Section.
But as above would be good to have a default set wink


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
Can this be put in a custom island?

Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
That would be a hack over at Dev i reckon.

Not sure why you would want to share a style count with members?


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
Most people really don't even know they are there and it would advertise to them that people are using different styles and or check them out.

After putting work into creating them or putting them on the board it is always nice to see them used.

Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
I think with 7.3 and having the drop box (Style Chooser)
i'm sure they will experiment.



BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Joined: Jun 2006
Posts: 684
H
Addict
Addict
H Offline
Joined: Jun 2006
Posts: 684
I was thinking about this earlier, and I thought a comprehensive stats page would be nice. Posts made in the last year, month, week and day, and all of the other stuff in the same fashion. It might make for a good hack over at UBBdev.

Joined: Aug 2006
Posts: 1,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
Likes: 1

BB stats would be nice -- and I had forgotten about the nice, helpful page .Classic had until I saw a reference here earlier today. What'd be mostly helpful would be things like "x% use threaded mode", "x% use this language, and x% use that", "x% use this theme, x% use that", etc...



GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
I thought that SD or someone had mouse overs that showed the style/theme (or maybe I saw it on another board) but I've seen it somewhere.

Maybe a link to a page that has images of how each looks at least for now until 7.4 where Rick says he is going to do an overhaul for styles.


Joined: Aug 2006
Posts: 1,358
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,358
ubb.STATS. One of those things on my todo list.

I have a very extensive stats script, that creates top lists per forum, which posting icons are used the most, who created the most topics etc etc.

Thing is, it's in visual basic smile I have a data retreiving script that is interpreted by that Visual Basic program.


[Linked Image from siemons.org]
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
We have words for people like you in Liverpool

.
.
.
.
.
.

smart arse lol


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Joined: Aug 2006
Posts: 1,358
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,358
Could be, but I just love the fact that if I want something, I can create it without knocking on too many doors smile


[Linked Image from siemons.org]
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
/me hides

Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
lol you know who you are lol


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
spam issues
by ECNet - 03/19/2024 11:45 PM
Who's Online Now
1 members (1 invisible), 875 guests, and 141 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)