Advertisement:

Author Topic: who's using that theme?  (Read 22515 times)

Offline LostProphecy

  • Jr. Member
  • **
  • Posts: 381
  • Gender: Female
    • The Lost Prophecy
who's using that theme?
« on: September 21, 2004, 04:24:35 AM »
hey all :)

i was just running through about 20 of my themes (by way of profile>look and layout preferences)

and i look down the list and see things like "2 people using this theme" i thought it would be a good idea if we could somehow have something that we could click on, either in this window or maybe even the admin area where we could tell which exact members are using which theme... maybe even just make the "2 people using this theme" a link to a page that would state who those ppl are...

it could be for just the admins, or maybe any normal member could be able to see who is using what :)

~Jessi
Angelus Ex Quo Nox

Offline Oldiesmann

  • Developer
  • SMF Super Hero
  • *
  • Posts: 24,814
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • http://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: who's using that theme?
« Reply #1 on: September 22, 2004, 10:53:57 AM »
Nice idea. Here's a simple MySQL query to get you this information...

Code: [Select]
SELECT m.userName, t.ID_THEME FROM smf_members AS m, smf_themes AS t WHERE t.value = 'yourthemename' AND m.ID_THEME = t.ID_THEME;
Michael Eshom
Webmaster / SMF Lead Developer
oldiesmann@simplemachines.org

Offline Tomer

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 1,652
  • Gender: Male
    • Aromazing
Re: who's using that theme?
« Reply #2 on: September 22, 2004, 11:46:50 AM »
You can enter phpMyAdmin and view yourself. :P

Offline Oldiesmann

  • Developer
  • SMF Super Hero
  • *
  • Posts: 24,814
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • http://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: who's using that theme?
« Reply #3 on: September 22, 2004, 02:51:06 PM »
If you know the theme ID, you can do this:

Code: [Select]
SELECT userName FROM smf_members WHERE ID_THEME='x'
There are several queries that will get the username and theme name together since both the userID and themeID are stored in the members and themes tables...
Michael Eshom
Webmaster / SMF Lead Developer
oldiesmann@simplemachines.org

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: who's using that theme?
« Reply #4 on: September 22, 2004, 10:06:52 PM »
There is no userName.  There's memberName (login name) and realName (displayed name.)

SELECT mem.realName, mem.ID_THEME
FROM smf_members AS mem, smf_themes AS th
WHERE mem.ID_THEME = th.ID_THEME
   AND th.value = 'yourthemename';

Or even better yet, just for phpMyAdmin...

SELECT mem.memberName AS Login, mem.realName AS Name, th.value AS Theme
FROM smf_members AS mem, smf_themes AS th
WHERE mem.ID_THEME = th.ID_THEME
ORDER BY mem.memberName ASC;

-[Unknown]

Offline Anguz

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 3,430
  • Gender: Male
    • cristianlavaque.com
Re: who's using that theme?
« Reply #5 on: September 22, 2004, 11:07:07 PM »
This looks like a good topic for the Tips & Tricks board. :)
Cristián Lávaque http://cristianlavaque.com

Offline Oldiesmann

  • Developer
  • SMF Super Hero
  • *
  • Posts: 24,814
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • http://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: who's using that theme?
« Reply #6 on: September 24, 2004, 08:47:38 AM »
Sorry about that... :)
Michael Eshom
Webmaster / SMF Lead Developer
oldiesmann@simplemachines.org

Offline bhz

  • Newbie
  • *
  • Posts: 8
Re: who's using that theme?
« Reply #7 on: October 04, 2004, 05:11:47 PM »
FYI: To get just the Theme Names and not all the other associated values add, and th.variable='name' to the where clause...

phpMyAdmin SQL:
Code: [Select]
SELECT mem.memberName AS Login, mem.realName AS Name, th.value AS Theme
FROM smf_members AS mem, smf_themes AS th
WHERE mem.ID_THEME = th.ID_THEME and th.variable='name'
ORDER BY mem.memberName ASC LIMIT 0, 30

-bhz

Offline epyon

  • Semi-Newbie
  • *
  • Posts: 44
  • Gender: Male
    • The Poké Lab
Re: who's using that theme?
« Reply #8 on: July 28, 2005, 04:30:25 PM »
hey i think this is a good idea too, i was looking for somthing liek this on the admin panel but wtvr, any ways im kindov new to this but how would i add this setting? i mean i see the codes u guys have provided but where do i put it?

Offline Vinspire^

  • Semi-Newbie
  • *
  • Posts: 82
Re: who's using that theme?
« Reply #9 on: May 02, 2006, 12:20:37 PM »
hey i think this is a good idea too, i was looking for somthing liek this on the admin panel but wtvr, any ways im kindov new to this but how would i add this setting? i mean i see the codes u guys have provided but where do i put it?

Same question here  :D :D :D

Offline Vinspire^

  • Semi-Newbie
  • *
  • Posts: 82
Re: who's using that theme?
« Reply #10 on: May 05, 2006, 06:16:43 AM »
I got the answer & manage to get it working  8) 8) 8)

Offline Vinspire

  • Sr. Member
  • ****
  • Posts: 852
  • Gender: Male
    • The Box Of Heart Forum
Re: who's using that theme?
« Reply #11 on: May 10, 2006, 11:46:27 PM »
Hopefully this function is build into the next SMF upgrade :)