goblinSpy - league stats without upload needed

@ugh Thanks for reporting.

Hi Mordrek,

The Champs ladder for Xbox season 10 seems to be missing games from 3rd to 6th of Nov. I've only played in that period and none of my teams/matches are showing.
Could you take a look when you have a chance please?

Thanks

@ronaldbeanio
Thanks for reporting.
Numbers looks a bit low for a couple of days around the end of the month.
I'll request new data for Oct 29 - Nov 6.
Take a look tomorrow and PM me if there are still problems.

Hi Mordrek,

just a suggestion for a possible improvement of your database:
I think people are really interested into statistics about the mm-pools, so an add-on would be to include a column to the database, which gives you some kind of id to a pool, which lead to the matchup. This way, people could look up, which teams were in one pool and get some overall statistics on how big pools are within a certain timeframe/within a league.

Remark: I had this idea, because I was thinking about doing the analysis again, which I did some month ago, but then I thought it might be really handy, if such data was already available on goblinspy. However, I can understand if this is a bit to fiddly to include.

@arne
Not sure how to get a pool id.
Or perhaps it's good enough with estimated pool sizes by grouping start time by 5 minute span ?

If you download the database from the competition page and then use http://sqlitebrowser.org/ to open the file , then you can group by interval like this (where 5 is the number of minutes):
:::
select datetime((strftime('%s', started) / (605)) * (605), 'unixepoch') interval,
count(*) cnt
from leaguematches
group by interval
order by interval
:::

Or if you want to save it as a table:
:::
create table pools as
select datetime((strftime('%s', started) / (605)) * (605), 'unixepoch') interval,
count(*) cnt
from leaguematches
group by interval
order by interval
:::

Perhaps something like that is what you are looking for?

last edited by mordrek

@Arne
Couldn't get spoilers right, should look like this inside:

select datetime((strftime('%s', started) / (60 * 5)) * (60 * 5), 'unixepoch') interval,
count(*) cnt
from leaguematches
group by interval
order by interval

and the second like this:

create table pools as
select datetime((strftime('%s', started) / (60 * 5)) * (60 * 5), 'unixepoch') interval,
count(*) cnt
from leaguematches
group by interval
order by interval

last edited by mordrek

@mordrek Hi, further to @ronaldbeanio request there also seems to be a couple of
48hr periods missing for PC & PS4 platforms around the same time as mentioned
(+ possibly a couple of days before?) I don't know if these are recoverable but
hoped you could check it out for us. TY

@mercy-flush
Sure, I'll request new data for those dates where there are gaps for ps4.
Dont' see any gaps for PC CCLX or am I missing something?
PM me tomorrow if you still miss something.

last edited by mordrek

@mordrek
Hi Mate, the Xbox Champs X doesn't seem to have updated since the 9th.
Could you take a look at some point please?

Thanks

@ronaldbeanio
Sure. I've started recollecting for 9/11 and forward

hm, weird. same for ps4 and I'm not getting any data for either.

last edited by mordrek

@mordrek
Hi fella, it's updated as far as the 11th now but obviously still missing a few days. I'm sure you're probably aware, but just in case you're not.

Thanks

@ronaldbeanio
Yea. I've done a new collection again and now it's up to a bit of yesterday.
Strange dip the 10/11 and 29/10 also, but perhaps they had server issues at those dates?
Seems to be problems only on ps4 and xbox1, pc works fine.

Hi,
just a quick heads up:
ps4 Champions league is missing at least one match:
I had a game against an Orc team, The Lazy Boyz, on 2017/11/19 00:02 and that's missing (the games before and after are there).

I also can't seem to find the orc team I played against from the database.

@gimletti Thanks for reporting. Started re-collection of that date for ps4

Hi, there’s an issue with the Mordrek data from over the weekend for Xbox 1.

Saturday 18th didn’t record any games at all, and only about half of the ones from the 19th.

Thanks for the tool — it’s awesome!

@cmmdr-slacker Thanks for reporting. Started re-collection of those dates for xb1

No worries, and thanks!

What you did worked... but the records still aren't quite right. (I want to create a summary sheet of qualifiers for the Xbox players)

I can't check where the hole is right now as I'm at work, but there must still be a gap, maybe the 17th?

Anyway cheers again for the tool -- really enhances the experience of the game.

@cmmdr-slacker : Started recollection of 17th.

Cheers! I'll see if that adds the missing records.

Hi Mordrek,

Last week I created 4 competitions to be monitored under Zena Extreme League.

They have been classified as "inactive".
On Monday, Tuesday and Wednesday some matches have been played but the competition are still inactive.

The 4 competition are the ones starting with ZXL 6

Thanks for your help

last edited by Matteo Matteucci