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) |
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 The result: Code: username postnum tyl_unumrcvtyls ratio However, 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 Result: Code: name postnum tyl_unumrcvtyls tyl_unumrcvtyls/postnum ratio Now everything is accounted for: the amount of thanks, amount of thanks per post, and amount of posts. Fun! |