Onderwerp: [NT] Scouting Database

Last played position isn't in the xml data of players so, Ill need one or two additional query PER player (and we have currently 230k) so nope I'm sorry.
(gewijzigd)

Ok, thanks for your answer :-)

It's in xml data of the matches, so you can have at least 22 per query:

xml/match-35550744.xml:


(gewijzigd)

Don't worry :)

UPDATE 01/07/2019

Added: Date End of auction of NT players in transfer list.

this needs to get matches list first, so more queries needed but thanks anyway

I'm sure matchIDs are generated sequentially. You would only need to begin from the first match of the week and add 1 until there are no more matches :P

Number of teams: 138437

Half of that are the number of matches, I guess :)

That's absolutely inefficient.

I'm sorry guys but I'll have to say no to anything that means more queries. (Right now there are lot of queries and the entire process take hours!). More time, more cpu, more memory, more bandwidth, etc.
(gewijzigd)

may be just adding number of assists and goals for players; is that also too much?

edit: then we can assume if numbers are 0 0 or really low that its GK. not perfect but helpful imho
(gewijzigd)

no? yes?

any chance to update the list of players?

Arturo8a said the update is week 1 of each season

That's right :)

Wow thanks a lot Arturo!
My name is also Arturo and I really appreciate what you did here!
So amazing,
Muchos Gracias!

You are welcome :)!

This is an awesome tool, thank you.

I did notice that this player was not included in the list though, and thought I might mention it so you can work out what happened and give feedback

Mike Newton [36585007]

He is in an active team, and has been around a long time

As the topic was started on 2019-06-22 01:00:25 it seems that it didn't take into consideration players without clubs.

And that was for your example http://sokker.org/transfers_player/ID_human/36585007


he was sacked and then transferred from nowhere on 25.06