Query Request: Which styles are my members using...

[TheMusicMan]

Hi All

I currently have 4 styles available for my members to choose from and I woudl like to get an idea as to which one is proving most popular. I don't wish to install the Style Hack, just want a count of members V's style - is this posible?

Could someone offer me the SQL please...

[Dean C]

Hmm I had a quick look at the database schema by this one and it seems that if you change the style with your style switcher it stores which style you're using in cookie. If you change it via usercp then it stores it in the styleid column in the user table.

I think this is about as accurate you're going to get if you have the style switcher in your footer:

[sql]
SELECT
user.styleid,
COUNT(user.styleid) AS total,
style.title
FROM
user
LEFT OUTER JOIN
style ON
style.styleid = user.styleid
WHERE
user.styleid <> 0
GROUP BY
styleid
ORDER BY
total
[/sql]

I did also notice that in the session table there's a styleid field so you may be able to get it from there. I haven't worked with vB3 enough to look into how it manages sessions so the above is all I can provide right now

[TheMusicMan]

Originally Posted by Dean C

Hmm I had a quick look at the database schema by this one and it seems that if you change the style with your style switcher it stores which style you're using in cookie. If you change it via usercp then it stores it in the styleid column in the user table.

I think this is about as accurate you're going to get if you have the style switcher in your footer:

[sql]
SELECT
user.styleid,
COUNT(user.styleid) AS total,
style.title
FROM
user
LEFT OUTER JOIN
style ON
style.styleid = user.styleid
WHERE
user.styleid <> 0
GROUP BY
styleid
ORDER BY
total
[/sql]

I did also notice that in the session table there's a styleid field so you may be able to get it from there. I haven't worked with vB3 enough to look into how it manages sessions so the above is all I can provide right now

Hey thanks Dean that was real quick. I will check it out later tonight.