Population Statistics Website

[Darkside]

Greetings,

I am creating a new dedicated thread for my web site which handles the gathering and compiling of population data from the 3 Salem servers as well as HnH and displays the data in graphs.

So, what's it do exactly?

I have a cron job on my web host which runs every 15 minutes and scrapes the server stats off the Salem server status page and the HnH portal page and records them to a MySQL database.

Then I write sql scripts which pull the data in desired format and pass the compiled data to the php jp graph library to create nice looking graphs

Currently I run the sql and compile the graph per request but I plan to produce images on those 15 minute intervals when I scrape the data instead to reduce the unnecessary repeated processing.

Okay, show me some graphs!

Here is a main page showing the three main graphs for Salem:

http://www.webatrocity.com/salem/poptrack.php

The first graph shows population in the last 24 hours across all 3 servers where the data collected from every 15-minute interval scrape is plotted. The right side of the graph is the most recent data collected. The number on the x-axis is the hour in 24-hour format of the Greenwich Meantime timezone.

The second graph shows population in the last week, where each hour of data is averaged and plotted on the graph. The data flows from oldest on the left to newest on the right.

The third graph shows population in the last month, where all the data from a full day is averaged to a single number and then plotted to the graph. Such a daily average will be most indicative of any long term trend in the population of the server.

Anything for HnH or comparing Salem to HnH?

Yes, I have a few HnH graphs available separately for now:

http://www.webatrocity.com/salem/hnh_24hour.php
This one is the past 24 hour data graph and has the same exact setup as the 24-hour salem graph described above

http://www.webatrocity.com/salem/hnh_1week.php
This is the past week data graph for HnH and has the same exact setup as the past week salem graph described above

http://www.webatrocity.com/salem/hnh_1month.php
This is the past month data graph for HnH and has the same exact setup as the past month salem graph described above

http://www.webatrocity.com/salem/hnh_vs ... 24hour.php
This one takes the total of Salem's server pop from all 3 servers and compares it to the pop of HnH's single server, in the last 24 hours.

Your feedback

Feel free to ask any questions on these graphs or how I compile the data or to offer up any suggestions in this thread.

Please refrain from going into debates on Salem vs. HnH in this thread, try to keep it to discussion about the gathering, compiling and display of the data or the web site in general.

Thanks!

[sabinati]

can you do week and month graphs for haven and haven vs salem, or do you not have enough datapoints yet?

[Darkside]

can you do week and month graphs for haven and haven vs salem, or do you not have enough datapoints yet?

I do have enough for a week for sure, will work on that next

[Greb]

Very nice graphs, great job!

[colesie]

Sticky

[Mereni]

It'll be interesting to see how the populations change now with the way things are changing in development.

[uncleseano]

ah effin dirty nerd *****, fantastic work

[Droj]

very nice & useful!

[Dallane]

glorious!

[Claeyt]

Fantastic work Darkside, nice job, thank you

Works with all browsers perfectly except chrome. The page still crashes to "broken image link" after full download with chrome, like I pm'd you about before, but you can just hit "stop loading" and it'll stop and show all the graphs perfectly. The HnH one's work perfectly on Chrome.

Is that big drop on HnH at hr 17 in the initial 24hr graph a lag spike or is it Colesie logging off his 500 bots and going to bed?