Site
Home / Forum / General Discussion / The tables

The tables


Posted: 06 Jun 2021 19:06
PassionFoot
Posts: 29
Joined: 2021-04-27

Tables are not correctly sorted (whatever the championship)
England : https://www.thesportsdb.com/api/v1/json/1/lookuptable.php?l=4328&s=2020-2021
Germany : https://www.thesportsdb.com/api/v1/json/1/lookuptable.php?l=4331&s=2020-2021
Italy : https://www.thesportsdb.com/api/v1/json/1/lookuptable.php?l=4332&s=2020-2021
France : https://www.thesportsdb.com/api/v1/json/1/lookuptable.php?l=4334&s=2020-2021

And ALL the others


Posted: 06 Jun 2021 20:50

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

Fixed and updated all API keys to the new methods.

This is a breaking change for all users of Soccer Tables, but best done now at the end of the season.

Posted: 07 Jun 2021 07:14
PassionFoot
Posts: 29
Joined: 2021-04-27

Some standings are wrong (like Venezuelian championship).
These championships are made by groups.
On TheSportsDB, these standing are only in one table and many teams are missing.
For example for the FUTVE there is 3 groups (central, occidental and oriental) and 21 teams (7 by group)
The API displays a table with 7 teams only (https://www.thesportsdb.com/api/v1/json/1/lookuptable.php?l=4513&s=2021)
The teams displayed in the table are the one of the Oriental group (Caracas, Mineros, Metropolitanos, Monagas, Atletico Venezuela, Lala FC and Universidad Central).



zag
Posted: 07 Jun 2021 09:45
curswine
Posts: 870
Joined: 2020-06-17

Use the raw result data to create your own table.

There are far too many variations in leagues for the site to cover every variety.

Posted: 07 Jun 2021 12:09
PassionFoot
Posts: 29
Joined: 2021-04-27

Excepted the standings with 14 other team don't appear anywhere.
Clearly the standing with these teams are missing so i cannot import them

Posted: 07 Jun 2021 15:14
curswine
Posts: 870
Joined: 2020-06-17

Excepted the standings with 14 other team don't appear anywhere.
Clearly the standing with these teams are missing so i cannot import them


I don't think you understood what I said.

Use the results to create your own tables with the rules of whatever league you're looking to emulate.

Here I've used the results of the Venezuelan league to create their league system ...
https://docs.google.com/spreadsheets/d/1n_roeGICNa-Fjwp1ns-A2dHXVnrj3HF1sK0DMV_pt84/edit?usp=sharing

Posted: 07 Jun 2021 18:08
PassionFoot
Posts: 29
Joined: 2021-04-27

There is still a bug on italian table (Empoli number one with Inter Milan and Salernitana number two with AC Milan - the two teams acceding to Serie A)
https://www.thesportsdb.com/api/v1/json/1/lookuptable.php?l=4332&s=2020-2021

zag
Posted: 08 Jun 2021 08:26
PassionFoot
Posts: 29
Joined: 2021-04-27

Same problem with French Ligue 1 standings

Posted: 08 Jun 2021 11:35
curswine
Posts: 870
Joined: 2020-06-17

The leagues are over, teams have been relegated and promoted.

Use the data to create past tables.

Posted: 08 Jun 2021 18:54

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

There is still a bug on italian table (Empoli number one with Inter Milan and Salernitana number two with AC Milan - the two teams acceding to Serie A)
https://www.thesportsdb.com/api/v1/json/1/lookuptable.php?l=4332&s=2020-2021


Yes this is a bug I think, but it is indeed because the seasons have finished and the teams are promoted (I think). Thx curswine.

I will do some more investigations.

EDIT: Fixed

Posted: 08 Jun 2021 18:59

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

Is this OK now for League 1?

https://www.thesportsdb.com/table.php?l=4334&s=2020-2021
https://www.thesportsdb.com/api/v1/json/1/lookuptable.php?l=4334&s=2020-2021

Posted: 09 Jun 2021 17:30
PassionFoot
Posts: 29
Joined: 2021-04-27

indeed, it seems OK for now


Posted: 15 Jun 2021 23:33
PassionFoot
Posts: 29
Joined: 2021-04-27

We can do very great things with the API
I made all the standings of all championships

All is full automatized with variables ...

Only two files (a php file + a css file) plus one file containing only the code of the championship to display the good one.
I have a php file supplementary cause i renamed all teams (the name of some teams are not understandable in french like some belgian or dutch teams)
and it is the same for results

zag

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 0 to 13 (Total: 13)