Site
Home / Forum / General Discussion / [UPDATES] Complete Leagues

[UPDATES] Complete Leagues


Posted: 18 Sep 2020 13:37
smudgie
Posts: 340
Joined: 2020-06-17

looks great with all the renders done

zag
Posted: 20 Sep 2020 20:05

zag
Posts: 3,331
Joined: 2020-03-23

Tour De France complete with:

- Each stage winner, description, top 10 results
- Winner cyclist thumb, cutout and bike render
- YouTube Highlights

Posted: 13 Nov 2020 21:46

zag
Posts: 3,331
Joined: 2020-03-23

Big one complete today after a lot of work!

Player renders, cutouts, contracts and agents complete for all teams in La Liga!
Also checked all players are available to sync with lineups from API-Football.

https://www.thesportsdb.com/league/4335-Spanish-La-Liga

Ovokx, GOAviator
Posted: 17 Nov 2020 10:20
GOAviator
Posts: 50
Joined: 2020-08-24

Just noticed in granada team last match lineup there is a missing player, Lopez, whose id is of a belgian jupiter league player

Posted: 17 Nov 2020 11:27
curswine
Posts: 870
Joined: 2020-06-17

Just noticed in granada team last match lineup there is a missing player, Lopez, whose id is of a belgian jupiter league player

The lineup for the last Granada match looks fine to me. https://www.thesportsdb.com/event/1045864

Posted: 17 Nov 2020 12:39
GOAviator
Posts: 50
Joined: 2020-08-24

Just noticed in granada team last match lineup there is a missing player, Lopez, whose id is of a belgian jupiter league player

The lineup for the last Granada match looks fine to me. https://www.thesportsdb.com/event/1045864

For me Nicolas Perez is without any photo

Posted: 17 Nov 2020 13:25
curswine
Posts: 870
Joined: 2020-06-17

Just noticed in granada team last match lineup there is a missing player, Lopez, whose id is of a belgian jupiter league player

The lineup for the last Granada match looks fine to me. https://www.thesportsdb.com/event/1045864
For me Nicolas Perez is without any photo


Okay, it was just you mentioned something about a Lopez and I couldn't see anything relating to Lopez in any team line-up.

I have added the player, linked their API number, and refreshed the lineup.



Posted: 17 Nov 2020 22:43

zag
Posts: 3,331
Joined: 2020-03-23

Thanks yes I did a batch update of the player ids which used a fuzzy name match. There may be a few wrongly identified players but not many.

If you find any, please do fix by removing from the lineup and deleting the APIfootball player ID in the player edit screen. Even better if you can find or create the correct player and update the ID

I think I already fixed the above but there may be some more.

Posted: 30 Dec 2020 20:05

zag
Posts: 3,331
Joined: 2020-03-23

French League 1 is now complete with players and cutouts.

Big thanks to smudgie for clearing up the remaining teams

https://www.thesportsdb.com/league/4334

cydalby
Posted: 30 Dec 2020 21:08
smudgie
Posts: 340
Joined: 2020-06-17

Cheers Zag, couple of teams needed a lot of players moving around, some going back 2015/2016.
Will update to the latest kits. Looking good now though.

zag
Posted: 24 Jan 2021 21:23

zag
Posts: 3,331
Joined: 2020-03-23

Another big effort and we have another featured league complete! I hope ovokx is pleased...

https://www.thesportsdb.com/league/4408-Spanish-Liga-ACB

Ovokx
Posted: 25 Jan 2021 18:44

Ovokx
Posts: 1,700
Joined: 2020-06-17

Amazing job! Thanks for your help on this!

Posted: 25 Jan 2021 21:00
GOAviator
Posts: 50
Joined: 2020-08-24

Also Italian Serie A is completed

zag
Posted: 25 Jan 2021 22:43

zag
Posts: 3,331
Joined: 2020-03-23

Also Italian Serie A is completed

Incredible work, thanks for completing another featured league!

GOAviator
Posted: 08 Feb 2021 20:27

zag
Posts: 3,331
Joined: 2020-03-23

Yet another one of our featured leagues complete!

English Premiership Rugby
https://www.thesportsdb.com/league/4414-English-Premiership-Rugby

Posted: 09 Jun 2021 21:31

zag
Posts: 3,331
Joined: 2020-03-23

All credit to cardinaldiehard25

Super Rugby: https://www.thesportsdb.com/league/4551-Super-Rugby

Posted: 12 Jun 2021 04:34
cardinaldiehard25
Posts: 162
Joined: 2021-05-22

Pro14



https://www.thesportsdb.com/league/4446

zag
Posted: 14 Jun 2021 01:43
cardinaldiehard25
Posts: 162
Joined: 2021-05-22

CFL



https://www.thesportsdb.com/league/4405-CFL

zag
Posted: 14 Jun 2021 20:57

zag
Posts: 3,331
Joined: 2020-03-23

Both updated with a green tick!

Superb work

cardinaldiehard25
Posted: 15 Jun 2021 17:18
cardinaldiehard25
Posts: 162
Joined: 2021-05-22

French Top 14



https://www.thesportsdb.com/league/4430

Posted: 15 Jun 2021 17:31
cardinaldiehard25
Posts: 162
Joined: 2021-05-22

Six Nations Championship



https://www.thesportsdb.com/league/4714-Six-Nations-Championship

Posted: 16 Jun 2021 03:54
cardinaldiehard25
Posts: 162
Joined: 2021-05-22

Adriatic ABA League



https://www.thesportsdb.com/league/4477

zag
Posted: 16 Jun 2021 08:47

zag
Posts: 3,331
Joined: 2020-03-23

Wow!

Absolutely smashing it Are you using import scripts, i'm quite interested how you did it so fast

All green ticks added!

cardinaldiehard25
Posted: 16 Jun 2021 13:46
cardinaldiehard25
Posts: 162
Joined: 2021-05-22

Wow!

Absolutely smashing it Are you using import scripts, i'm quite interested how you did it so fast

All green ticks added!


Yes, I have been slowly writing some Python functions to continue to automate my contributions. I have been using Google Sheets to parse the information I want to contribute and pass that information is a .csv to my Python functions. I have also been spending way too much time on this site which is why it seems fast too lol.

For adding players this is how I currently have it set up:
- Create .csv file with as much details on that player as source has and add column for player image url
- add_player function will loop through each record and do the following:
- Add name, dob, position, and nationality
- Enter additional player details available
- Retrieve the player's thumbnail image from the image address
- Crop the largest square (center for wide images, top for tall images)
- Resize image to 700x700
- Then have the code select the new image from my files and upload it!

I also have functions for adding future events, adding past events w/ scores, logging in to the site, padding badges (instead of stretching), and saving jerseys and trying to make them transparent (not perfect yet).

When doing this I just have to be extra careful there are no mistakes before clicking go and mass adding to the site. If anyone has any requests I can try to focus on greencheck marking that league as I don't have much of a preference. I can also run the code for anyone that wants to help prepare the .csv.

I imagine there are a ton of other coders using this site who can help contribute to the functions and make them even better and create some new ones!

Adding the team artwork like banners, fan art, etc. has been manual so far, but that would probably be the next thing I try to work on. A league like the Adriatic ABA was very difficult to find images for, but I found their Facebook pages were the best sources. That is also where I usually find the highest quality badge for lesser known teams, just have to make the background transparent.

Python functions https://github.com/BlakeDuncan25/TheSportsDB-Contribution-Functions/blob/master/TheSportsDBFunctions.py

curswine, Ovokx, zag
Posted: 16 Jun 2021 15:11
curswine
Posts: 870
Joined: 2020-06-17

You've done some fantastic work with those scripts, much better than my attempts.


Who is Online?

In total there are 68 users online :: 3 registered, 0 hidden and 65 guests (based on users active over the past 5 minutes) Most users ever online was 424 on Fri Nov 10, 2017 9:02 pm

About Us

Discussion forum for TheSportsDB.com site and related topics

Rules

- Be Polite
- Respect other users
- Always post log files with issues
- Try to be helpful
- No Piracy discussion

Showing 100 to 125 (Total: 161)