Skip to Content

PvMP Stats Site updates (in progress)

19 replies [Last post]
Sat, 03/06/2010 - 21:39
Akulz
User offline. Last seen 2 days 13 hours ago. Offline
Joined: 10/20/2008
Posts:

So, I'm sure V and others would love the ability to graph whatever they wanted to, and however they wanted to, on the stats site.

I've written one graphing-tool, which can create nice "renown/infamy gain" graphs.  One example is

Preview graph

You can select any number of classes, and any number of servers.  So you can graph BAs on E vs all creeps on Arkenstone.  Or champions and reavers on Windfola, against weavers and runekeepers on vilya. 

I don't (yet) have a decent interface to it, I've bugged Hell a bit about designing something new that we can work with, but I wanted to show what I have so far.  Main reason for this is so you guys can recommend changes, or new ideas.

 

 

Top

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Wed, 03/24/2010 - 05:17
#1
Akulz
User offline. Last seen 2 days 13 hours ago. Offline
Joined: 10/20/2008
Posts:

I wasn't actively monitoring it, I just saw the logfile which said "connection to mysql server died" or something similar.  No time or date that I can give, so it could be anything, possibly unrelated to the SQL server even (internet hiccup or something).

Top
Tue, 03/23/2010 - 17:50
#2
Vyxe
Vyxe's picture
User offline. Last seen 3 hours 2 min ago. Offline
Joined: 08/12/2008
Posts:

I was wondering what happened to my stats.  That said, any idea what happened?  I just looked into it and it appears that the machine with the SQL had no reported issues, but if anything goes on long term, PM me to let me know asap so I can put in a trouble ticket

__________________

Violence, Reaver Vyxe, Warleader You're going to die in my raids. Really.

Top
Tue, 03/23/2010 - 17:39
#3
Akulz
User offline. Last seen 2 days 13 hours ago. Offline
Joined: 10/20/2008
Posts:

Just for those keeping an eye on stats, the SQL server died/stopped responding last night, so the scrape did not complete (and therefore no data was added).

I'm running a new scrap now, but it's ~12 hours delayed, so the stats will be slightly off.

Top
Tue, 03/16/2010 - 02:57
#4
Akulz
User offline. Last seen 2 days 13 hours ago. Offline
Joined: 10/20/2008
Posts:

Vyxe wrote:

Yup, if it's not much work.  otherwise again I can yank them from Surugi.

 

Ive had a third look, and it will actually take some time.  Some significant time.  I don't keep a history of what rank everyone was at every point.  I just track what renown people had when they actually earned some, so if you didn't earn any in a day, you aren't listed for that day.

So for each day, I'll have to find all the people who have had gains listed on that day, or earlier, and find their renown that way.  And then work out what rank.

 

It's definitely do-able, just don't expect anything any time soon :P

Top
Sun, 03/14/2010 - 14:08
#5
Hywelbane
Hywelbane's picture
User offline. Last seen 1 day 1 hour ago. Offline
Joined: 11/09/2008
Posts:

Bog wrote:

Yeah, there are a lot of high ranked creeps on E now. But its not a 1 sided problem. If freeps came out in numbers more often, then they'd see that they are not doing nearly as badly as they think they are. In fact, the majority of people complaining freepside are those that don't realize that freeps are not meant to be solo gods, their strength lies in their numbers and their group buffs/abilities.

Bog, I think that's a really good point.  If you look at the folks who either flipped to freepside or transferred off E or simply quit playing creepside because they though they were OPed, almost none of them were regular raiders on creepside.  Well-played freeps have always been much formidable when they are out in force and grouped up against creeps who are out in force and grouped up, which they'd know if they'd been in Vyxe's raids on a regular basis instead of soloing or very small grouping.

Top
Sat, 03/13/2010 - 21:26
#6
Vyxe
Vyxe's picture
User offline. Last seen 3 hours 2 min ago. Offline
Joined: 08/12/2008
Posts:

Yup, if it's not much work.  otherwise again I can yank them from Surugi. 

 

The interesting point is that your data has a hole when you got it back online, and Surugi has a hole at Jan 2010 when he didn't fix his script for a while.  So if I combine both datasets I can clear up both holes

__________________

Violence, Reaver Vyxe, Warleader You're going to die in my raids. Really.

Top
Sat, 03/13/2010 - 20:42
#7
Akulz
User offline. Last seen 2 days 13 hours ago. Offline
Joined: 10/20/2008
Posts:

Actually, I realised, I do "somewhat" have daily stats, I'd just forgotten about a field in the database.  So historical data "should" be fine.

Top
Sat, 03/13/2010 - 20:24
#8
Akulz
User offline. Last seen 2 days 13 hours ago. Offline
Joined: 10/20/2008
Posts:

I can see them (I was actually on vent when you first mentioned them too, so I've had a look around).  Just clarifying though, is the following is what you want?

New stacked bar graphs for creep and freep class distributions, per server and total.

Update graphs comparing mean rank of freepies and creepies, per server and total.

Count of creeps/freeps per rank, per server and total.

The big issue is that "my" stats don't have any historical data, unlike Surugi's.  Also, Surugi's stats only record rank 3 and above.  I could only pull out rank3s and above, easily, but finding historical data is harder.

 

Top
Sat, 03/13/2010 - 11:38
#9
Vyxe
Vyxe's picture
User offline. Last seen 3 hours 2 min ago. Offline
Joined: 08/12/2008
Posts:

If you could have your site aggregate and compile the stats (on a weekly basis is fine) per what I just did in the BAOS gallery, that would be frigging sweet.

 

If not.. I already have my scripts to scrape Surugi's site done

__________________

Violence, Reaver Vyxe, Warleader You're going to die in my raids. Really.

Top
Sat, 03/13/2010 - 06:19
#10
Hellnakh
User offline. Last seen 6 hours 28 min ago. Offline
Joined: 08/18/2008
Posts:

Hywelbane wrote:

Hell, your forum sig is way out of date (Rank 10?!)

 

I fixed it. :D

__________________

Hellnakh: Warleader, Rank 11 | Estelle: Warg, Rank 6 | Disaster: Black Arrow, Rank 4 | Azali: Defiler, Rank 4 | Hectic: Reaver, Rank 3 | Edessa: Weaver, Rank 4  

Top
Fri, 03/12/2010 - 23:02
#11
Bog
Bog's picture
User offline. Last seen 35 min 18 sec ago. Offline
Joined: 08/15/2008
Posts:

Yeah, there are a lot of high ranked creeps on E now. But its not a 1 sided problem. If freeps came out in numbers more often, then they'd see that they are not doing nearly as badly as they think they are. In fact, the majority of people complaining freepside are those that don't realize that freeps are not meant to be solo gods, their strength lies in their numbers and their group buffs/abilities.

__________________

NotBogu - R10 Reaver - All Good maps ScaredyCat - R6 BA - some maps Bogutyi - R2 Warg - some crudes Telerono - R6 Hunter Bogutyr - R5 Guardian Guntar - R4 Minstrel

Top
Fri, 03/12/2010 - 16:33
#12
Hywelbane
Hywelbane's picture
User offline. Last seen 1 day 1 hour ago. Offline
Joined: 11/09/2008
Posts:

Hellnakh wrote:

You left Meneldor off the list. :)

Hell, your forum sig is way out of date (Rank 10?!) -- kind of like the ideas (according to Vyxe's latest stats on the home page) that high-ranked creeps have flooded and ruined E over the past year, and that creeps are ranking up like mad.

Top
Fri, 03/12/2010 - 02:57
#13
Akulz
User offline. Last seen 2 days 13 hours ago. Offline
Joined: 10/20/2008
Posts:

Fixered.  Also can set whatever dataset name you want now. 

Top
Fri, 03/12/2010 - 02:11
#14
Hellnakh
User offline. Last seen 6 hours 28 min ago. Offline
Joined: 08/18/2008
Posts:

You left Meneldor off the list. :)

__________________

Hellnakh: Warleader, Rank 11 | Estelle: Warg, Rank 6 | Disaster: Black Arrow, Rank 4 | Azali: Defiler, Rank 4 | Hectic: Reaver, Rank 3 | Edessa: Weaver, Rank 4  

Top
Sun, 03/07/2010 - 15:46
#15
Akulz
User offline. Last seen 2 days 13 hours ago. Offline
Joined: 10/20/2008
Posts:

Good idea.  That should be fairly easy to do, as well.

Top
Sun, 03/07/2010 - 07:43
#16
Vyxe
Vyxe's picture
User offline. Last seen 3 hours 2 min ago. Offline
Joined: 08/12/2008
Posts:

With the graph if you could also put a datatable below it also it would be great so I can dump it in excel and do further calculations.

__________________

Violence, Reaver Vyxe, Warleader You're going to die in my raids. Really.

Top
Sun, 03/07/2010 - 02:57
#17
Akulz
User offline. Last seen 2 days 13 hours ago. Offline
Joined: 10/20/2008
Posts:

http://pvmpstats.alanlouie.com/new_interface/test.html

There's a rudimentary interface.  I know it looks like ass.  And I'm also working on the code to allow you to have multiple (> 2) datasets on one graph, but it's a start.

I also aim to let people set arbitrary dates to choose from.  All this is still in the works.

Top
Sat, 03/06/2010 - 22:01
#18
Vyxe
Vyxe's picture
User offline. Last seen 3 hours 2 min ago. Offline
Joined: 08/12/2008
Posts:

As soon as you get an interface together i'll be sure to check it out and figure out what we need!

 

As far as server load we can assess it as you roll it out.  The PvMP site is at 15,000 requests per day on average which is 625 requests per hour and that load isn't bad thus far.  I have no bandwidth cap so it's only memory usage in the calculations which may drive up RAM usage, so i'll keep an eye on it and let you know

__________________

Violence, Reaver Vyxe, Warleader You're going to die in my raids. Really.

Top
Sat, 03/06/2010 - 21:42
#19
Akulz
User offline. Last seen 2 days 13 hours ago. Offline
Joined: 10/20/2008
Posts:

Oh, also wanted to add, V, I don't know how your server is running, whether it's busy or not, but currently I'm not caching these.  I "can", but there's so many options, and daily data updates, that I don't think it's worth it.  Once we set it up, you can check it out and see how the load is.  It shouldn't be noticable though.

Top

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.


Theme by Dr. Radut.