goblinSpy - league stats without upload needed

Everything dealing with the video game developed by Cyanide!
User avatar
SirIronclad
Posts: 161
Joined: 10 October 2015, 18:57
Twitter: @SirIronclad

Re: goblinSpy - league stats without upload needed

Postby SirIronclad » 09 May 2017, 06:36

Mordrek, could you add a Team Value column to the "League standings" pages (including "Top/race")?

User avatar
mordrek
Posts: 190
Joined: 10 June 2009, 09:27

Re: goblinSpy - league stats without upload needed

Postby mordrek » 09 May 2017, 20:19

Mordrek, could you add a Team Value column to the "League standings" pages (including "Top/race")?
hm, perhaps :)
Only problem is I don't have the _current_ TV, only the TV at the start of last match.
Not sure that is good enough.
It is possible to collect current TV, but it requires more work :P

Ilgoth
Posts: 1
Joined: 10 May 2017, 07:49

Re: goblinSpy - league stats without upload needed

Postby Ilgoth » 10 May 2017, 07:52

Hey mordrek,

one of our league admins tried goblin spy on Big Crunch 2 (PC) but for some reason it only grasped one competition when there should be 9. Any idea why?

User avatar
mordrek
Posts: 190
Joined: 10 June 2009, 09:27

Re: goblinSpy - league stats without upload needed

Postby mordrek » 10 May 2017, 08:22

Hey mordrek,

one of our league admins tried goblin spy on Big Crunch 2 (PC) but for some reason it only grasped one competition when there should be 9. Any idea why?
hm, looks like some kind of problem with the activation.
I'll have to investigate.

User avatar
mordrek
Posts: 190
Joined: 10 June 2009, 09:27

Re: goblinSpy - league stats without upload needed

Postby mordrek » 10 May 2017, 09:14

Hey mordrek,

one of our league admins tried goblin spy on Big Crunch 2 (PC) but for some reason it only grasped one competition when there should be 9. Any idea why?
hm, looks like some kind of problem with the activation.
I'll have to investigate.
Yup broken activation. Should be collecting now.

If you see that the goblin misses a game, don't be afraid to PM the date and competition and I can perform collection of that date again.

cjblackburn
Posts: 162
Joined: 22 September 2015, 19:27

Re: goblinSpy - league stats without upload needed

Postby cjblackburn » 11 May 2017, 12:04

I'm sorry if I have missed it elsewhere but I have a question about the new seasons in goblinspy and statsgrabber.

We set up a multiple completions in the same league with the intention of rolling them forward and keeping the league from now on using the new season functionality. However I was wondering how your programmes would work with rolling seasons forward. We can work round it if it doesn't work we just need to know what we are facing.

User avatar
mordrek
Posts: 190
Joined: 10 June 2009, 09:27

Re: goblinSpy - league stats without upload needed

Postby mordrek » 11 May 2017, 12:33

I'm sorry if I have missed it elsewhere but I have a question about the new seasons in goblinspy and statsgrabber.

We set up a multiple completions in the same league with the intention of rolling them forward and keeping the league from now on using the new season functionality. However I was wondering how your programmes would work with rolling seasons forward. We can work round it if it doesn't work we just need to know what we are facing.
I'm not really familliar with the season functionality at all.
What I can say however is:
Both Statsgrabber and goblinSpy will consider two competitions being the same if they have the same competition name and league name. Games from both those identical competitions will be clumped together.

As far as I know there's no easy way to fix this, sorry.

cjblackburn
Posts: 162
Joined: 22 September 2015, 19:27

Re: goblinSpy - league stats without upload needed

Postby cjblackburn » 12 May 2017, 10:55

No problem mate I will just go back to the old way of doing it.

Thanks for all your work.

matti74
Posts: 4
Joined: 27 January 2017, 01:55
Facebook: https://www.facebook.com/matteucci.m

Re: goblinSpy - league stats without upload needed

Postby matti74 » 08 June 2017, 10:04

Hi all.

Cyanide has been kind enough to give me access to the real data, which means I can collect data without the need of players uploading anything.
Some admins had the idea that they wanted to be able to look at stats a little bit easier and asked for help, and here's the result:

http://www.mordrek.com/goblinSpy

// What is it?

It's a stat tracker that shows things like match results, rankings, racial win% etc.
It also has some limited capabilites to filter and sort the data to find out whatever you are interested in.

You can activate tracking for your own competitions, but tracking of Cabalvision Official League is prioritized in case of performance issues.
Worth noting is that I have no idea how it will behave in regards to competitions where you must confirm matches.
You probably need to confirm pretty soon in order for them to be collected. I can manually trigger new collection if you let me know and if it proves a big problem I might have to fix that.

If a replayed game is shown twice (the original+ the replayed), then you can go to the versus-page of the original and press the button "Mark as wrong" at the bottom.
The game will then be removed and stats for that date will be collected again and competition will be recalculated within a couple of hours.

// What kind of data is available

Only match-stats as they are given by Cyanide.
The data is collected for each day, so todays games will appear tomorrow (except see below).
Player stats are also collected, but match stats are always prioritized.
Games played today are also collected every hour or two if server has time for it (prioritized below yesterdays games/playerstats).
Competitions with no game played in a month is considered dead and might get their match stats and player stats removed.

Current default queries that can be viewed:
* League Results - Each match played. (+ /date /weekday /hour)
* Scheduled - Scheduled games for competitions that have schedule
* League Standings - The rankings and points. (+ top /race). I will change the ranking calculations when they change in-game.
* Team Matches - Each match in League Results becomes two in Team Matches, one for each team. Contains stats from the match.
* Race Wins - Win% calculations for the races
* Players - Player stats. Will require filtering to be of interest.

If you use BB2Stats (http://www.mordrek.com/BB2Stats) or Ricouds ReplayViewer (http://replay.bowllywood.ovh/), then these games will hopefully turn up as clickable links in goblinSpy.

// Tips and tricks

* Click on a column header and you can select to sort the query on the column.
* Click on a team name and you can look for that team name on other queries (often works for coach and race also).
Good if you want to see matches played by a team you spotted in the league standings for example.
* Click on the concede-value of a match and you can select to view all conceded matches by that coach
* Hover over ranking to view expected ranking if you win or lose the next game

// Altering the queries

Each Query can be altered through sorting by a column or by adding Filters.
Each Filter is a computation that must be true in order for a row to be shown.
So adding two Filters that says "Teamvalue > 1200" and "Race = Nurgle", and then press "Execute Query", then it will only list Nurgle teams with TV greater than 1200.
Queries are cleared back to default if reloading the page.

For the brave, there's also a hidden advanced query mode, that is not yet fully implemented and that may be confusing.
If you want more in depth data and know how to use SQL, then I can take a snapshot of the database for you if you PM me.

// Embedding stats or queries into web-pages

All queries, including those filtered or adjusted using advanced section, will have a button "Export View".
Clicking this will open a new window with only the results shown.
The Style will be the same as the currently chosen and the result will be updated when new data is collected.
To show this page inside another web page, use <iframe src="URL"></iframe> , where URL is the url of the opened page.

If the style clashes with the style of your homepage, then PM me and we'll fix it.

There's also a static overview .json file for each competition that get's rewritten when new data is collected.
The link to that data is available from the goblinSpy main page to the right of the "menu" buttons.

// Help me

If you find any major bugs or think it has missed a game you played, please report in this thread.
If you have any ideas for queries that would be nice to have as default query, then it can be easily added
If you are good at .css then please make a stylesheet and I'll add it to the menu
Hi Mordrek!!
Good job!
GoblinSpy did miss 1 game.
Can you check it please?
ZENA EXTREME LEAGUE
ZXL IV - Golden League
CAS dealers vs quezotec red devils
Some weeks ago.. I have replay file if you need

User avatar
mordrek
Posts: 190
Joined: 10 June 2009, 09:27

Re: goblinSpy - league stats without upload needed

Postby mordrek » 08 June 2017, 10:08

Hi all.

Cyanide has been kind enough to give me access to the real data, which means I can collect data without the need of players uploading anything.
Some admins had the idea that they wanted to be able to look at stats a little bit easier and asked for help, and here's the result:

http://www.mordrek.com/goblinSpy

// What is it?

It's a stat tracker that shows things like match results, rankings, racial win% etc.
It also has some limited capabilites to filter and sort the data to find out whatever you are interested in.

You can activate tracking for your own competitions, but tracking of Cabalvision Official League is prioritized in case of performance issues.
Worth noting is that I have no idea how it will behave in regards to competitions where you must confirm matches.
You probably need to confirm pretty soon in order for them to be collected. I can manually trigger new collection if you let me know and if it proves a big problem I might have to fix that.

If a replayed game is shown twice (the original+ the replayed), then you can go to the versus-page of the original and press the button "Mark as wrong" at the bottom.
The game will then be removed and stats for that date will be collected again and competition will be recalculated within a couple of hours.

// What kind of data is available

Only match-stats as they are given by Cyanide.
The data is collected for each day, so todays games will appear tomorrow (except see below).
Player stats are also collected, but match stats are always prioritized.
Games played today are also collected every hour or two if server has time for it (prioritized below yesterdays games/playerstats).
Competitions with no game played in a month is considered dead and might get their match stats and player stats removed.

Current default queries that can be viewed:
* League Results - Each match played. (+ /date /weekday /hour)
* Scheduled - Scheduled games for competitions that have schedule
* League Standings - The rankings and points. (+ top /race). I will change the ranking calculations when they change in-game.
* Team Matches - Each match in League Results becomes two in Team Matches, one for each team. Contains stats from the match.
* Race Wins - Win% calculations for the races
* Players - Player stats. Will require filtering to be of interest.

If you use BB2Stats (http://www.mordrek.com/BB2Stats) or Ricouds ReplayViewer (http://replay.bowllywood.ovh/), then these games will hopefully turn up as clickable links in goblinSpy.

// Tips and tricks

* Click on a column header and you can select to sort the query on the column.
* Click on a team name and you can look for that team name on other queries (often works for coach and race also).
Good if you want to see matches played by a team you spotted in the league standings for example.
* Click on the concede-value of a match and you can select to view all conceded matches by that coach
* Hover over ranking to view expected ranking if you win or lose the next game

// Altering the queries

Each Query can be altered through sorting by a column or by adding Filters.
Each Filter is a computation that must be true in order for a row to be shown.
So adding two Filters that says "Teamvalue > 1200" and "Race = Nurgle", and then press "Execute Query", then it will only list Nurgle teams with TV greater than 1200.
Queries are cleared back to default if reloading the page.

For the brave, there's also a hidden advanced query mode, that is not yet fully implemented and that may be confusing.
If you want more in depth data and know how to use SQL, then I can take a snapshot of the database for you if you PM me.

// Embedding stats or queries into web-pages

All queries, including those filtered or adjusted using advanced section, will have a button "Export View".
Clicking this will open a new window with only the results shown.
The Style will be the same as the currently chosen and the result will be updated when new data is collected.
To show this page inside another web page, use <iframe src="URL"></iframe> , where URL is the url of the opened page.

If the style clashes with the style of your homepage, then PM me and we'll fix it.

There's also a static overview .json file for each competition that get's rewritten when new data is collected.
The link to that data is available from the goblinSpy main page to the right of the "menu" buttons.

// Help me

If you find any major bugs or think it has missed a game you played, please report in this thread.
If you have any ideas for queries that would be nice to have as default query, then it can be easily added
If you are good at .css then please make a stylesheet and I'll add it to the menu
Hi Mordrek!!
Good job!
GoblinSpy did miss 1 game.
Can you check it please?
ZENA EXTREME LEAGUE
ZXL IV - Golden League
CAS dealers vs quezotec red devils
Some weeks ago.. I have replay file if you need
PM me the date (two dates if close to midnight) and I'll tell the goblin to fetch it again.


Return to “General”

Who is online

Users browsing this forum: No registered users and 1 guest

cron