Like Ra's Naughty Forum
Site statistics - Printable Version

+- Like Ra's Naughty Forum (https://www.likera.com/forum/mybb)
+-- Forum: Technical section (https://www.likera.com/forum/mybb/Forum-Technical-section)
+--- Forum: News (https://www.likera.com/forum/mybb/Forum-News)
+--- Thread: Site statistics (/Thread-Site-statistics)

Pages: 1 2 3 4 5 6 7 8

RE: Site statistics - Like Ra - 01 Jan 2024

(01 Jan 2024, 20:11 )Like Ra Wrote: Most active threads in 2023:
Interestingly enough, 13 out 20 top threads are hypno related.

(01 Jan 2024, 19:14 )Like Ra Wrote: January 01! The Statistics Day!
3 most viewed threads (2.7million combined views) are hypno related.

Since hypno-users "overflow" to other threads, adding the hypnosis section is a success to the whole site.

RE: Site statistics - Vixien - 01 Jan 2024

Can you make comparison by top thred/year ?
Maybe it would be interesting to see how we change during the years

RE: Site statistics - Like Ra - 01 Jan 2024

(01 Jan 2024, 22:01 )Vixien Wrote: Can you make comparison by top thread/year ?
Not sure if I understand what you mean? By the amount of comments per year? Have a look here: https://www.likera.com/forum/mybb/activethreads.php - at the bottom you can choose the date until which to count replies (e.g. 2021-01-01), and the amount of days to count (e.g. 365)

Or do you mean something different?

RE: Site statistics - Vixien - 02 Jan 2024

You wrote that most active threads in 2023 are hypno related .

It would be interested to see what were the most active threads in past years.

RE: Site statistics - Like Ra - 02 Jan 2024

(02 Jan 2024, 00:21 )Vixien Wrote: It would be interested to see what were the most active threads in past years.
Then my quick tutorial will work 😊 - you can choose any period of time, beginning 2006 and check by yourself.

The thing is, the pure amount of posts per year has grown significantly, so, post-amount-wise, it's difficult to compare.

RE: Site statistics - ltxrob - 02 Jan 2024

(01 Jan 2024, 21:24 )Like Ra Wrote: Interestingly enough, 13 out 20 top threads are hypno related.
and Hypno is the topic of least interest for me!
But i do occasionally glance at the odd thread here and there...

but if its great for the site... then thats a bonus!

RE: Site statistics - Like Ra - 02 Jan 2024

(02 Jan 2024, 09:18 )ltxrob Wrote: Hypno is the topic of least interest for me!
That's why we have hundreds of others! 😉

RE: Site statistics - Like Ra - 02 Jan 2024

Oh, another stat! Time spent online in hours:

OrderUsernameTimeOnline
1@Like Ra44396.5547
2@nacd123410782.2789
3@NoNeedToBreathe2171.7597
4@jasapasa1586.5303
5@madjack1473.1856
6@Atsta1410.9553
7@Culmor1240.0569
8@Ruis1232.5850
9@krinlyc1211.2539
10@essanym1114.9575
11@Chel1082.4289
12@trismegist1067.2231
13@Penguin1036.9906
14@DeWired838.2264
15@Tinker D832.3650
16@Zooy818.3619
17@ephemeral809.3753
18@Jiraiya796.4642
19@jtr765712.7722
20@Vacbedbound702.3811



RE: Site statistics - Like Ra - 02 Jan 2024

Offtopic: BTW, I used ChatGPT to format the results in MyBB tables. Brilliant!

RE: Site statistics - Like Ra - 04 Jan 2024

Since I'm learning SQL, here's another stat for you: amount of attachments and the total attachment size per user:




OrderUsernameAttachmentsTotal size (MB)
1@Like Ra2378926125.2675
2@madjack101763782.9977
3@helpless8522222686.8327
4@Culmor1748960.6063
5@madboyevil1288414.2951
6@TightSlip1169518.1381
7@PurpleVibes102289.2773
8@jessilongstocking672140.3578
9@Bound Whore579900.8296
10@Vacbedbound441874.3204
11@mysecretpantyhose413201.5382
12@q1911319151.3579
13@Anne280355.8364
14@FagMan259118.8914
15@Strappado24836.8794
16@latexballet22858.3596
17@essanym199250.1289
18@ltxrob187132.3637
19@Tinker D148119.7455
20@latexpert14829.7706




Code:
WITH t AS (
SELECT mybb_users.username, COUNT(mybb_attachments.uid) AS cnt, SUM(mybb_attachments.filesize)/1048576 AS sum
FROM mybb_attachments
JOIN mybb_users
ON mybb_users.uid = mybb_attachments.uid
GROUP BY mybb_attachments.uid
ORDER BY cnt DESC
LIMIT 20)
SELECT ROW_NUMBER() OVER (), t.username, t.cnt, t.sum
FROM t

If anybody speaks SQL, can this be done more efficiently? I'm just trying various things...