STPL is great, but there is no good place where you can get data, the topic of r & s has no dates, it's hard to find out what's going on (mb there are some dates anywhere but it's hard to find[?]). With BWCL it's different, you enter a page, you choose which week, you have given the date, who with who to whom he played etc.

Navane

Netherlands2748 Posts

October 18 2018 08:38 GMT

#183

I agree STPL is a bit harder to find results.

here are all the results of all three rounds so far: http://www.teamliquid.net/forum/bw-tournaments/534275-stpl-r-and-s-shinhan-tank-proleague-18-19-season

But they indeed do not include the play dates. So I compiled them here for you. If you keep this list with the thread above, it should be fairly straight forward. But really, qikz should just export this shit to a google sheet or smt


Round 1
-------

Week 1 dM vs Red and iRk vs WHITE -  	26/03/2018
Week 1 NW vs SK-B and SouL vs NaS - 	28/03/2018
Week 1 TL vs SK-A and ReV vs aSh -	30/03/2018

Week 2 dM vs SK-A and ReV vs iRk -	02/04/2018
Week 2 SK-B vs Red and WHITE vs NaS -	04/04/2018
Week 2 pSi vs TL and FBW vs aSh  - 	06/04/2018

Week 3 pSi vs SK-A and iRk vs NaS - 	10/04/2018
Week 3 dM vs SK-B and FBW vs ReV - 	11/04/2018
Week 3 dM vs SK-B and FBW vs ReV	13/04/2018

Week 4 TL vs Red and iRk vs FBW - 	17/04/2018
Week 4 dM vs pSi and aSh vs WHITE - 	18/04/2018
Week 4 dM vs SK-A and SouL vs ReV - 	20/04/2018

Week 5 Red vs SK-A and WHITE vs ReV -	23/04/2018
Week 5 nW vs pSi and aSh vs NaS -	25/04/2018
Week 5 TL vs SK-B and SouL vs FBW - 	27/04/2018

Week 6 Red vs pSi and iRk vs SouL - 	02/05/2018
Week 6 dM vs NW and FBW vs WHITE and ReV vs NaS - 04/05/2018

Week 7 dM vs SK-B and FBW vs NaS - 	09/05/2018
Week 7 iRk vs aSh and WHIITE vs SouL - 	11/05/2018

Round 1 Tiebreak// iRk vs WHITE -	21/05/2018


Round 1 Playoffs / NW vs iRk / dM vs WHITE - 	01/06/2018
Round 1 / Third Place Match / NW vs dM - 	07/06/2018
Round 1 / Playoff Finals / iRk vs WHITE - 	08/06/2018


Round 2
-------

Week 1 – 17/06/2018
Week 2 – 08/07/2018
Week 3 – 15/07/2018
Week 4 – 22/07/2018
Week 5 – 29/07/2018
Week 6 - 05/07/2018
Week 7 – 12/08/2018

Semi Final A / Red vs NW - 	05/09/2018
Semi Final B / SouL vs WHITE - 	07/09/2018
3rd Place / Red vs SouL - 	12/09/2018
Finals / NetWars vs WHITE - 	14/09/2018

Round 3
-------

Week 1 – 23/09/2018
Week 2 – 30/09/2018
Week 3 – 07/10/2018
Week 4 – 14/10/2018
Week 5 – 21/10/2018
Week 6 – 28/10/2018
Week 7 – 04/11/2018

kogeT

Poland2040 Posts

October 18 2018 08:58 GMT

#184

kogeT

Poland2040 Posts

October 18 2018 09:01 GMT

#185

On October 18 2018 16:43 Poegim wrote:
STPL is great, but there is no good place where you can get data, the topic of r & s has no dates, it's hard to find out what's going on (mb there are some dates anywhere but it's hard to find[?]). With BWCL it's different, you enter a page, you choose which week, you have given the date, who with who to whom he played etc.

Shouldn't Qikz have some kind of a master data base? Like a big Excel file for all that?

Poegim

Poland264 Posts

October 18 2018 09:15 GMT

#186

Ye mb he have, but i cant include past games, if i add some event fom ex: 10.10.2018 i cant add any games played before that date, it is (almost)impossible to perform a backward calculation in such a way, I would have to move the whole database back to this match and calculate from the beginning. But the site is not automated, i am adding game by game manualy, entering dates and players one by one.

Navane

Netherlands2748 Posts

October 18 2018 11:08 GMT

#187

I don't think qikz has that. I think the production you see on his casts is a nicely hacked set of scripts that just do enough to display the overlays.

Poegim, I really encourage you to decouple the data from the elo ranking. That way you can also graph elo over time.

Have a table with just the player/score/date, and let your algorithm crawl over this table from the beginning of time to now, creating a new table with date/player/elo.

I really like your initiative.

Qikz

United Kingdom12022 Posts

October 18 2018 11:21 GMT

#188

On October 18 2018 18:01 kogeT wrote:

Show nested quote +

Shouldn't Qikz have some kind of a master data base? Like a big Excel file for all that?

I set up my mySQL database very weirdly to start with so I don't have things like dates as it doesn't record them as games, just numbers. I'm working with Radley at the minute to improve on that since he works with Databases for a living so he's being a huge help to getting that fixed moving forward. Based on everything I've talked about with him I should be able to store everything as matches and games rather than just numbers, I'll need to change all my code but that's fine I don't mind it.

Radley <3

I'm sorry I've made it impossible for you to use STPL poegim, perhaps you can add it when I fix all the database and everything.

Poegim

Poland264 Posts

October 19 2018 15:39 GMT

#189

Added PvP feature, you can now check player vs player ratio and games history. Just start entering a nickname in textbox and pick players.

http://rankgim.eu/pvp.php

kogeT

Poland2040 Posts

October 19 2018 17:14 GMT

#190

Wow that is so cool. :D

[sc1f]eonzerg

Belgium6635 Posts

October 19 2018 17:37 GMT

#191

On October 20 2018 00:39 Poegim wrote:
Added PvP feature, you can now check player vs player ratio and games history. Just start entering a nickname in textbox and pick players.

http://rankgim.eu/pvp.php

lanos = lancerx

Red.T45

Germany28 Posts

October 19 2018 21:10 GMT

#192

Red.T45 race = Terran

Navane

Netherlands2748 Posts

March 26 2019 18:50 GMT

#193

What happened here guys? The site appears down.

radley

Poland582 Posts

March 26 2019 20:51 GMT

#194

Poegim said he stopped project for now due to losing interest but he may update scores until 2019 R1 in the nearest future and post table with rankings here on TL. So for now somebody can try to make new ranking using
GreyShades app

In a few days, I'm going to post here on TL a new thread, to get opinions and discuss about new website portal idea, which would be pretty big project, where foreign elo ranking would be only one of the features. But I may only guess it can take at least half of the year to see the results, after I get green light from community and can start working on it. This gonna also require cooperation from main foreign leagues organisators and some volunteers to help updating content.

dark.matter

177 Posts

March 27 2019 17:52 GMT

#195

I might be interested in helping radley. That elo stuff definitely needs to be online.

Poegim

Poland264 Posts

March 28 2019 10:34 GMT

#196

ill put it online soon, didnt touch this since october, and spend whole last 4 days on it. There is alot of games to update, im just in middle of january, or smth like it. Finally i rewrited engine so i can ez fix now past games, i can also add past tournaments (hi STPL?) and recalculate it in few minutes (except adding games to list takes a bit longer). Also writing some new features like History highest peaks rank (this is ready, already). I hope i ll finish updating game list in 1 week. Not sure adress will be same becouse of domain cost.

+ Show Spoiler +

dM-White

Chile340 Posts

March 28 2019 21:23 GMT

#197

On March 28 2019 19:34 Poegim wrote:
ill put it online soon, didnt touch this since october, and spend whole last 4 days on it. There is alot of games to update, im just in middle of january, or smth like it. Finally i rewrited engine so i can ez fix now past games, i can also add past tournaments (hi STPL?) and recalculate it in few minutes (except adding games to list takes a bit longer). Also writing some new features like History highest peaks rank (this is ready, already). I hope i ll finish updating game list in 1 week. Not sure adress will be same becouse of domain cost.

+ Show Spoiler +

Nice!!! rankings are back :D

Jealous

10175 Posts

March 28 2019 21:34 GMT

#198

Cool! Glad to have you back

FlaShFTW

United States10193 Posts

March 29 2019 01:57 GMT

#199

where's my boy jaeyun :c

radley

Poland582 Posts

March 29 2019 08:01 GMT

#200

I'll provide data from stpl for that. Just need to know whats best format of games data for that so I can write query most close to it. Gonna do this until tomorrow's evening.