Somewhat useless but rather neat statistics

F

fury

Administrator
Staff member
Board started: 4/15/02 00:18
Number of posts: 56850
Posts per day: 366.84
Number of topics: 2842
Topics per day: 18.34
Number of users: 226
Users per day: 1.46

Avatar directory size: 315.36 KB
Database size: 35.84 MB

Number of Attachments: 1252
Total Filesize: 59.41 MB
Attachment Quota: 100 MB
Number of Posts with Attachments: 1189
Number of Private Messages with Attachments: 10
Number of Topics with Attachments: 444
Number of Users who have Posted Attachments: 61

:headbang:
 
What'd be really cool would be to see the average number of replies each user tends to get when they start a thread. :D teehee
 
Scanty said:
What'd be really cool would be to see the average number of replies each user tends to get when they start a thread. :D teehee
Click to expand...
Your wish is my command

Code: 
+----------------+--------------+------------------------+---------------+
| averagereplies | averageviews | username               | topicsstarted |
+----------------+--------------+------------------------+---------------+
|        61.0000 |     337.0000 | daPirate               |             1 |
|        49.0000 |     121.5000 | sjracer                |             2 |
|        48.6667 |     250.0000 | Hootermelots           |             3 |
|        48.0000 |     391.0000 | Bill Gates             |             1 |
|        45.0000 |     211.0000 | Katz                   |             1 |
|        38.0000 |     226.0000 | Djcake                 |             1 |
|        37.0000 |     276.0000 | Q                      |             3 |
|        36.0000 |     133.0000 | AMDnut                 |             2 |
|        33.5000 |     188.5000 | Cutter                 |             2 |
|        31.4286 |     185.0000 | Cleveland              |             7 |
|        30.4000 |     156.1333 | fi                     |            15 |
|        29.5625 |     155.6250 | Scanty                 |            32 |
|        28.5000 |     220.6111 | krusty                 |            18 |
|        28.4000 |     155.0000 | Janimal                |             5 |
|        28.4000 |     132.5000 | Psycho                 |            10 |
|        28.3333 |     195.0000 | Kruz                   |             3 |
|        28.0000 |     167.0000 | GOD ALMIGHTY Version 2 |             1 |
|        27.7910 |     110.7015 | Anonymous              |           201 |
|        27.6000 |     216.8000 | ol' man                |             5 |
|        26.8333 |     142.8333 | Jas101                 |             6 |
|        26.5000 |     181.0000 | Ponch                  |             2 |
|        25.7500 |     137.0167 | outside looking in     |            60 |
|        25.1064 |     122.5957 | Shadowfax              |            47 |
|        24.3333 |     190.6667 | sunk                   |             3 |
|        23.0000 |     168.0000 | soniclos               |             1 |
|        22.8583 |     146.8031 | fury                   |           127 |
|        22.1463 |     113.9388 | LastLegionary          |           294 |
|        21.9192 |     132.3333 | sbcanada               |            99 |
|        21.7500 |     119.2500 | Bink                   |             4 |
|        21.5000 |     122.5000 | Kitty On Crack         |            12 |
|        21.3333 |     126.4872 | insert penis here      |            39 |
|        21.3333 |     143.0000 | NEIL                   |             3 |
|        21.0000 |     103.3333 | Magnux                 |             3 |
|        21.0000 |     124.3810 | Ardsgaine              |            21 |
|        20.7667 |     131.0667 | MuFu                   |            30 |
|        20.2500 |     130.2500 | hardtellin             |             8 |
|        20.1818 |     104.8182 | alex              |            11 |
|        19.7500 |     108.2500 | karlwb                 |             4 |
|        19.6667 |     138.6667 | AlladinSane            |             3 |
|        19.3000 |     115.2000 | flavio                 |            10 |
|        19.0000 |     118.0000 | fIxx3r                 |             1 |
|        18.9080 |      90.1534 | Luis G                 |           163 |
|        18.8333 |     114.8333 | ilovechris             |             6 |
|        18.8023 |     102.4186 | nalani                 |           172 |
|        18.5000 |      95.3696 | Nixy                   |            92 |
|        18.0311 |      97.3990 | kuulani                |           193 |
|        18.0000 |     127.8333 | nodnod                 |             6 |
|        17.7368 |     101.7368 | MitchSchaft            |            19 |
|        17.6667 |     115.0000 | crane                  |             3 |
|        17.3333 |     118.3333 | Lindsey                |             3 |
|        17.2703 |     107.8649 | greenfreak             |            37 |
|        17.0606 |     106.0303 | markjs                 |            33 |
|        17.0000 |     113.0000 | flurffmeister          |             1 |
|        17.0000 |     110.6667 | Mephisto               |             3 |
|        17.0000 |     101.0000 | Maxout                 |             1 |
|        17.0000 |     156.0000 | Zaphod                 |             1 |
|        17.0000 |     111.7333 | Professur              |            15 |
|        17.0000 |     103.0000 | warhorse               |             1 |
|        16.6298 |      96.5691 | Justintime             |           181 |
|        16.5990 |      95.3958 | Leslie                 |           192 |
|        16.4839 |     101.5484 | samcurry               |            62 |
|        16.3636 |     120.0000 | GOD ALMIGHTY           |            11 |
|        16.0000 |      84.0000 | DuronClocker           |             1 |
|        16.0000 |     101.5000 | HomeLAN                |             6 |
|        16.0000 |      98.5000 | equinoxe3d             |             2 |
|        16.0000 |      91.0000 | farley89hd             |             1 |
|        16.0000 |      77.1429 | ihcra                  |             7 |
|        16.0000 |      97.3548 | unclehobart            |            31 |
|        15.5417 |      92.5000 | HeXp£Øi±               |            24 |
|        15.5000 |      74.1250 | Toolbox                |            16 |
|        15.3529 |      90.8824 | tarez                  |            17 |
|        15.2353 |      80.0000 | CenturionStrategy      |            17 |
|        15.0000 |     114.0000 | Spirit                 |             2 |
|        14.5000 |      90.4286 | RecklessLeper          |            14 |
|        14.0000 |      92.0000 | Zig Commander          |             1 |
|        14.0000 |     102.0000 | Glok                   |             1 |
|        14.0000 |      97.0000 | trinity3               |             1 |
|        14.0000 |      94.0000 | Jeffy79                |             2 |
|        13.9167 |      81.9167 | [b]                    |            12 |
|        13.8600 |      83.1400 | PuterTutor             |            50 |
|        13.7500 |      82.0000 | BadBrain               |             4 |
|        13.5714 |      71.4286 | StuTheWise             |             7 |
|        13.3243 |      88.1892 | Gato_Solo              |            37 |
|        12.6667 |      75.0000 | JJR512                 |             3 |
|        12.3750 |      79.3750 | $ponge                 |             8 |
|        12.0000 |      70.5000 | efehle                 |             2 |
|        11.7317 |      55.8415 | ris                    |           164 |
|        11.6667 |      47.6667 | =FireSt0rM=            |             3 |
|        11.6667 |      59.3333 | Soler                  |             3 |
|        11.0000 |      58.7273 | Stop Laughing          |            11 |
|        10.5000 |      57.5000 | dimme                  |             2 |
|        10.1892 |      70.3514 | Gonz                   |            37 |
|        10.0000 |      61.0000 | A.B.Normal             |             1 |
|         9.5000 |      74.7500 | CoffeePotUnit          |            12 |
|         8.8000 |      72.0000 | zoom                   |             5 |
|         8.6667 |      67.6667 | squeeks                |             3 |
|         8.5714 |      52.4286 | a13antichrist          |             7 |
|         7.7778 |      48.1111 | Berserker              |             9 |
|         7.0000 |      29.0000 | systembuilder          |             1 |
|         6.0000 |      70.0000 | zinger                 |             1 |
|         6.0000 |      56.0000 | alwayenoughram         |             4 |
|         6.0000 |      85.0000 | jayjay2k2              |             1 |
|         6.0000 |      59.5000 | volcano                |             2 |
|         6.0000 |      78.5000 | trinity2               |             2 |
|         5.0000 |      56.5000 | lorrimar               |             2 |
|         5.0000 |      39.0000 | Gomez Addams           |             1 |
|         3.5000 |      37.5000 | freako104              |             2 |
|         3.0000 |      27.0000 | wrathchild_67          |             1 |
|         2.0000 |      50.0000 | ShaDowz111             |             1 |
|         2.0000 |      23.0000 | midnightz              |             1 |
|         2.0000 |      26.0000 | Anon                   |             1 |
|         2.0000 |      52.0000 | wingnut                |             1 |
|         1.0000 |      21.0000 | Inkara1                |             1 |
+----------------+--------------+------------------------+---------------+
 
For future reference, that was done with the following query:

select avg(t.topic_replies) AS averagereplies,avg(t.topic_views) AS averageviews,u.username,count(t.topic_id) AS topicsstarted FROM phpbb_topics t,phpbb_users u WHERE t.topic_poster = u.user_id GROUP BY t.topic_poster ORDER BY averagereplies DESC;

I can sort it by average views or by topics started if anyone wants to see that
 
fury said:
For future reference, that was done with the following query:

select avg(t.topic_replies) AS averagereplies,avg(t.topic_views) AS averageviews,u.username,count(t.topic_id) AS topicsstarted FROM phpbb_topics t,phpbb_users u WHERE t.topic_poster = u.user_id GROUP BY t.topic_poster ORDER BY averagereplies DESC;

I can sort it by average views or by topics started if anyone wants to see that
Click to expand...
Hm nice query... I tend to never caps my sql though. :)
 
I do it all the time, makes it easier to see where I need to stop when I'm arrowing back and forth through the command. (in the mysql console, you can't use the up key to change the position of the cursor in the current command, so you have to just hold down the left arrow key and pray that you stop at the right spot ;))
 
LastLegionary said:
I'm used to Oracle 9i and SQLPlus :p Oracle is SO freaking nice.
Click to expand...
I know a guy who will say otherwise. Ever heard of Sybase? http://forums.fanhome.com/ <-- The owner of this site converted vBulletin to MySQL and Sybase and has been a fanboy of Sybase ever since. (Maybe even before he converted it. Not sure exactly)
 
You must log in or register to reply here.
Back
Top