Jump to content

Random statistics


  • Please log in to reply
37 replies to this topic

#1 Guest_ElatedOwl_*

Guest_ElatedOwl_*
  • Guests

Posted 14 November 2012 - 03:08 PM

Thank's to Gol's thread the other day and my need to get acquainted with MySQL I've been inspired to post random site statistics.

Let's start with top 10 profile views...
  • INTELIDOT 2135
  • SpleenBeGone 2040
  • crawling 1638
  • Gol~ 1290
  • Wolf 1074
  • emosaurusrex 967
  • Rob 902
  • K_N 899
  • Chrissaysay 861
  • Xiaolian 783


Registration emails:
gmail: 159
yahoo: 70
live/hotmail: 58
AOL: 10

I'm also open to taking requests if anyone has anything interesting.

#2 Cthulhu

Cthulhu

    The Hick

  • Members
  • 1,151 posts
  • LocationDixieland

Posted 14 November 2012 - 03:28 PM

Uhhh who's crawling?

#3 Wolf

Wolf

    Zettabyte

  • Members
  • 6,487 posts

Posted 14 November 2012 - 03:29 PM

Most logged-in page views, ie board usage.

#4 Guest_ElatedOwl_*

Guest_ElatedOwl_*
  • Guests

Posted 14 November 2012 - 03:32 PM

Uhhh who's crawling?

Flippy, http://nerdforum.org...27-v-m-v-︵-┻━┻/

#5 Guest_ElatedOwl_*

Guest_ElatedOwl_*
  • Guests

Posted 14 November 2012 - 03:35 PM

Most logged-in page views, ie board usage.

Unfortunately I don't see any data for me to be able to pull this from. I'll keep flipping through, no promises though.

#6 Calvary

Calvary

    Conceptual

  • Members
  • 6,624 posts
  • Locationwww.

Posted 14 November 2012 - 04:50 PM

Most time spent on the forum browsing? =D

tumblr_om7nwjm5Wm1rsea1wo1_500.gif
Ask for my discord/Insta/Tumblr if you want.


#7 Guest_ElatedOwl_*

Guest_ElatedOwl_*
  • Guests

Posted 14 November 2012 - 06:50 PM

Unfortunately not possible either. :[ It doesn't log time spent logged in.

#8 twa

twa

    The Actual Administrator

  • Members
  • 2,728 posts

Posted 14 November 2012 - 07:22 PM

Damn, look at me. Such an interesting specimen I am. Also, you should change twa to my current username.

Zi9JkgO.gif

 

あ な た を 信 じ て い る 私 を 信 じ て 


#9 SpleenBeGone

SpleenBeGone

    Deer Leader of the Goriest Revolution

  • Administrators
  • 14,951 posts
  • LocationHouston

Posted 14 November 2012 - 07:44 PM

I'm sad that there's sill 10 people using AOL, and and that there's nothing keeping up with the time spent online. Is there any way to start tracking time logged in, or would that not be terribly simple to do?
nmjUGDL.jpg

#10 Guest_ElatedOwl_*

Guest_ElatedOwl_*
  • Guests

Posted 14 November 2012 - 08:10 PM

It wouldn't be too hard to do, just a scalability issue. The ACP might even have something to turn it on, I'm not sure.

#11 twa

twa

    The Actual Administrator

  • Members
  • 2,728 posts

Posted 14 November 2012 - 09:32 PM

I remember when I used to have an AOL. Even had the AOL internet browser thing. Don't even remember what it looked like. But it was back in the dial up era.

Zi9JkgO.gif

 

あ な た を 信 じ て い る 私 を 信 じ て 


#12 Affray

Affray

    Knower of things

  • Members
  • 5,753 posts
  • LocationThe Great White North

Posted 14 November 2012 - 10:26 PM

I'm sad that there's sill 10 people using AOL, and and that there's nothing keeping up with the time spent online. Is there any way to start tracking time logged in, or would that not be terribly simple to do?


If it weren't for the art of mockery I wouldn't even remember what AOL was.

It is perfectly acceptable to fear and admire a being you could not possibly understand.


#13 Bowsette

Bowsette

    Tentacular!

  • Members
  • 4,064 posts

Posted 15 November 2012 - 09:31 AM

I like AOL. Or rather, AIM. >.>

LL1Yc5i.gif

“Shimatta! Bare… nan no koto kashira?”


#14 SpleenBeGone

SpleenBeGone

    Deer Leader of the Goriest Revolution

  • Administrators
  • 14,951 posts
  • LocationHouston

Posted 15 November 2012 - 09:31 AM

I used to use AIM a ton.
nmjUGDL.jpg

#15 Calvary

Calvary

    Conceptual

  • Members
  • 6,624 posts
  • Locationwww.

Posted 15 November 2012 - 09:32 AM

Oh man I loved the dial-up noise. What was that old browser? Mosaic? I think I remember the passover from Mosaic to IE, although on second thoughts Mosaic was before my time so I'm not sure.

tumblr_om7nwjm5Wm1rsea1wo1_500.gif
Ask for my discord/Insta/Tumblr if you want.


#16 SpleenBeGone

SpleenBeGone

    Deer Leader of the Goriest Revolution

  • Administrators
  • 14,951 posts
  • LocationHouston

Posted 15 November 2012 - 09:40 AM

It wouldn't be too hard to do, just a scalability issue. The ACP might even have something to turn it on, I'm not sure.

AFAIK it doesn't. I know I had my old 2.3 board modded for it, but it never made it to the newer versions. What kind of scalability issues would be encountered?
nmjUGDL.jpg

#17 Guest_ElatedOwl_*

Guest_ElatedOwl_*
  • Guests

Posted 15 November 2012 - 09:53 AM

Since PHP is stateless* you'd end up having to add two fields to Members or a new table designed with MemberID, LastRequest, TotalTime. Every time a logged in user requests a page it would have to check if the last activity date longer than the timeout duration (predetermined, 10 minutes or whatever you would want to set it to); if it was too long it simply appends the new date to LastRequest, otherwise it gets the time difference in minutes and adds it to TotalTime.

But then you're going to run into an issue where TotalTime is going to exceed the max int value

*someone please correct me if I'm wrong here

#18 SpleenBeGone

SpleenBeGone

    Deer Leader of the Goriest Revolution

  • Administrators
  • 14,951 posts
  • LocationHouston

Posted 15 November 2012 - 10:02 AM

Hrm. I know that forums have this, even large ones. What would be the max value?
If we stored as hours to x decimal point instead of minutes, and then converted that on page to minute, would that work out?
nmjUGDL.jpg

#19 Guest_ElatedOwl_*

Guest_ElatedOwl_*
  • Guests

Posted 15 November 2012 - 10:06 AM

Well, when it overflowed you could add another row but you'd have to combine them. I'll have to look at how IPB keeps track of logged in users, it might already be appending last activity.

#20 SpleenBeGone

SpleenBeGone

    Deer Leader of the Goriest Revolution

  • Administrators
  • 14,951 posts
  • LocationHouston

Posted 15 November 2012 - 10:09 AM

Yeah, I can see how this could eat up space with lots of users. If you get a chance, check if IPB has any of it in place and let me know.
nmjUGDL.jpg