goblinSpy - league stats without upload needed

Everything dealing with the video game developed by Cyanide!
User avatar
mordrek
Posts: 188
Joined: 10 June 2009, 09:27

goblinSpy - league stats without upload needed

Postby mordrek » 30 November 2016, 18:26

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
Last edited by mordrek on 23 January 2017, 16:15, edited 6 times in total.

User avatar
Mercy Flush
Posts: 556
Joined: 08 October 2011, 02:21

Re: goblinSpy - league stats without upload needed

Postby Mercy Flush » 30 November 2016, 18:57

Thank you so much for your efforts on behalf of the CCL admin team.
Wonderful work as always mate.
Image

User avatar
dode74
Posts: 7016
Joined: 11 December 2008, 11:18
Location: Nr. Reading, UK
Contact:

Re: goblinSpy - league stats without upload needed

Postby dode74 » 30 November 2016, 19:08

Superb work, thank you.
Image

samt2806
Posts: 225
Joined: 05 February 2016, 03:22

Re: goblinSpy - league stats without upload needed

Postby samt2806 » 30 November 2016, 20:18

Very nice! Thank you!!!
Blood & Tears Perpetual Co-founder
PS4 CCL Admin
Your 6 concedes were disconnects and crashes?! Yeah right :mrgreen: "

User avatar
TheSpydyr
Posts: 1225
Joined: 02 April 2012, 16:03

Re: goblinSpy - league stats without upload needed

Postby TheSpydyr » 30 November 2016, 20:33

Mercy Flush wrote:Thank you so much for your efforts on behalf of the CCL admin team.
Wonderful work as always mate.


My sentiments exactly! Well done Mordrek and thanks for taking the time and putting for the energy for the entire BB community to take advantage of!
Spydyr

Image
The RNG is not broken, you are not "the unluckiest coach in the world" and the computer does not cheat, you just suck.

Twitch
YouTube

User avatar
TheSpydyr
Posts: 1225
Joined: 02 April 2012, 16:03

Re: goblinSpy - league stats without upload needed

Postby TheSpydyr » 30 November 2016, 20:38

mordrek wrote: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.



OH THIS IS SOOOOOO SWEET AND NICE! I just checked this with one of the GOBBLN leagues and it pulled up the statsgrabber info so we can get the individual player stats. Mordrek, you are THE MAN!

Kudos to you my friend!!!!

Spydyr
Spydyr

Image
The RNG is not broken, you are not "the unluckiest coach in the world" and the computer does not cheat, you just suck.

Twitch
YouTube

User avatar
TheSpydyr
Posts: 1225
Joined: 02 April 2012, 16:03

Re: goblinSpy - league stats without upload needed

Postby TheSpydyr » 30 November 2016, 21:07

TheSpydyr wrote:
mordrek wrote: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.



OH THIS IS SOOOOOO SWEET AND NICE! I just checked this with one of the GOBBLN leagues and it pulled up the statsgrabber info so we can get the individual player stats. Mordrek, you are THE MAN!

Kudos to you my friend!!!!

Spydyr



I do have one quick question on this though...do we still have to upload to statsgrabber to have this link appear? I'm guessing that we do.
Spydyr

Image
The RNG is not broken, you are not "the unluckiest coach in the world" and the computer does not cheat, you just suck.

Twitch
YouTube

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

Re: goblinSpy - league stats without upload needed

Postby mordrek » 30 November 2016, 22:25

TheSpydyr wrote:I do have one quick question on this though...do we still have to upload to statsgrabber to have this link appear? I'm guessing that we do.


Yes, unfortunately

User avatar
TheSpydyr
Posts: 1225
Joined: 02 April 2012, 16:03

Re: goblinSpy - league stats without upload needed

Postby TheSpydyr » 30 November 2016, 22:27

cool and no problem man...this is a great addition for the community!
Spydyr

Image
The RNG is not broken, you are not "the unluckiest coach in the world" and the computer does not cheat, you just suck.

Twitch
YouTube

seriousjest
Posts: 482
Joined: 09 May 2016, 18:30
Facebook: seriousjest
Twitter: seriousjest
Contact:

Re: goblinSpy - league stats without upload needed

Postby seriousjest » 01 December 2016, 05:56

Can PS4 take advantage of this, too?
PS4 Champion Cup co-admin, co-host of "Live from the ManCave!!!," and your favorite Blood Bowl coach's favorite Blood Bowl coach

Image


Return to “General”

Who is online

Users browsing this forum: PIngwin, Sid The Coach and 23 guests