+- 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)
RE: Site statistics - Like Ra - 01 Jan 2018
Forum attachment statistics:
Top 5 Users Using the Most Disk Space
Username Total Size
Like Ra 4.77 GB
madjack 1.98 GB
culmor 975.32 MB
madboyevil 407.85 MB
jessilongstocking 124.13 MB
General Statistics
No. Uploaded Attachments 25,386
Attachment Space Used 9.63 GB
Estimated Bandwidth Usage 1.47 TB
Average Attachment Size 397.73 KB
RE: Site statistics - Like Ra - 01 Jan 2019
Happy New Year everybody! As you have guessed - today is the statistics day!
Look at how the dynamic has positively changed during the last year! More posts, more users, more content! We are growing faster! Thanks everybody!
RE: Site statistics - Like Ra - 01 Jan 2019
Top 10 users with the most received thanks:
madjack 2918
Like Ra 2153
TightSlip 346
madboyevil 307
Anne 191
Tinker D 141
mysecretpantyhose 130
FagMan 121
jessilongstocking 119
ltxrob 107
The most thankful users:
Like Ra 2866
madjack 1364
Vixien 681
bondagetom1 628
TightSlip 436
GuidoG 363
sabrina1970 292
laris069 256
Poorwhitetrash 242
wilsd 180
RE: Site statistics - Like Ra - 01 Jan 2019
Forum attachment statistics:
Top 5 Users Using the Most Disk Space
Username Total Size
Like Ra 8.23 GB
madjack 2.34 GB
culmor 1.09 GB
TightSlip 492 MB
madboyevil 407.85 MB
General Statistics
No. Uploaded Attachments 31,197
Attachment Space Used 14.62 GB
Estimated Bandwidth Usage 2.2 TB
Average Attachment Size 491.36 KB
RE: Site statistics - Like Ra - 01 Feb 2019
Jan 2019 is a record month in terms of transferred bytes:
Incoming: 30.3 GB
Outgoing: 362 GB
Total: 393 GB
RE: Site statistics - Like Ra - 01 Oct 2019
New record: Sep 2019
Incoming: 33.47 GB
Outgoing: 386.32 GB
Total: 419.78 GB
RE: Site statistics - Like Ra - 01 Jan 2020
New Year, another new statistics day!
RE: Site statistics - Like Ra - 01 Jan 2020
Top 10 users with the most received thanks:
madjack 3791
Like Ra 3588
TightSlip 399
madboyevil 316
Anne 296
ltxrob 255
Vacbedbound 200
Tinker D 185
mysecretpantyhose 180
essanym 148
The most thankful users:
Like Ra 3430
madjack 1703
bondagetom1 1209
Vixien 989
TightSlip 438
sabrina1970 409
GuidoG 363
MinnMan99 283
Christina 278
Poorwhitetrash 262
RE: Site statistics - Like Ra - 01 Jan 2020
Top 5 Users Using the Most Disk Space
Username Total Size
Like Ra 11.03 GB
madjack 2.69 GB
Culmor 1.09 GB
helpless85 1.03 GB
Vacbedbound 588.4 MB
General Statistics
No. Uploaded Attachments 35,828
Attachment Space Used 21.48 GB
Estimated Bandwidth Usage 5.56 TB
Average Attachment Size 628.6 KB
RE: Site statistics - Like Ra - 19 Mar 2020
Out of curiosity and to play with SQL and statistics, I ran the following query to get the top 20 thanks/posts ratio:
Code:
SELECT username, postnum, tyl_unumrcvtyls, tyl_unumrcvtyls/postnum AS ratio
FROM mybb_users
ORDER by ratio DESC
LIMIT 20The result:
Code:
username postnum tyl_unumrcvtyls ratio
xxxrjxxx 1 4 4.0000
ChrissVeraX 1 4 4.0000
deepthroatenthusiast 1 4 4.0000
latexcrane 3 10 3.3333
dgmillan 1 3 3.0000
goomaster0 2 6 3.0000
stan5364 2 6 3.0000
ephemeral 1 3 3.0000
xxxx25852 1 3 3.0000
HornyRubberSlave 1 3 3.0000
soul69 1 3 3.0000
Voraador 1 3 3.0000
TheGagger1986 1 3 3.0000
dolin 9 24 2.6667
TVClaireB 2 5 2.5000
Tamesstylest 5 11 2.2000
Althend 33 70 2.1212
Caty 1 2 2.0000
bakker11 1 2 2.0000
aznstefanie 1 2 2.0000However, the amount of posts is not accounted for, only the ratio. This one should look better:
Code:
SELECT username, postnum, tyl_unumrcvtyls, tyl_unumrcvtyls/postnum, (postnum*tyl_unumrcvtyls)/(tyl_unumrcvtyls+postnum) AS ratio
FROM mybb_users
ORDER by ratio DESC
LIMIT 20Result:
Code:
name postnum tyl_unumrcvtyls tyl_unumrcvtyls/postnum ratio
Like Ra 15339 4076 0.2657 3220.2814
madjack 3659 3948 1.0790 1899.0051
Culmor 2623 1411 0.5379 917.4648
TightSlip 613 403 0.6574 243.1486
ltxrob 764 296 0.3874 213.3434
Tinker D 1881 196 0.1042 177.5041
madboyevil 319 316 0.9906 158.7465
Strappado 922 153 0.1659 131.2242
Anne 218 298 1.3670 125.8992
Vacbedbound 203 272 1.3399 116.2442
essanym 299 168 0.5619 107.5632
mysecretpantyhose 150 193 1.2867 84.4023
bondagetom1 166 143 0.8614 76.8220
FagMan 154 152 0.9870 76.4967
The inspector 299 83 0.2776 64.9660
vanessa_fetish 184 85 0.4620 58.1413
jessilongstocking 95 132 1.3895 55.2423
krinlyc 321 65 0.2025 54.0544
herrpee 263 68 0.2586 54.0302
helpless85 96 114 1.1875 52.1143Now everything is accounted for: the amount of thanks, amount of thanks per post, and amount of posts. Fun!