| | Posted: 21 Aug 2019 07:34 | |
zag
Posts: 3,627
Joined: 2020
| | If you edit an event (for example, adding the highlights link) and has the time imported from XMLsoccer, when you save, the time added resets into 23:59:59. It seems that it's caused because time is imported like this: 17:00:00+00:00 and on the edit section, you can only add time, not GMT/UTC indicator
| |
 |
| | Posted: 21 Aug 2019 07:35 | |
zag
Posts: 3,627
Joined: 2020
| | If you edit an event (for example, adding the highlights link) and has the time imported from XMLsoccer, when you save, the time added resets into 23:59:59. It seems that it's caused because time is imported like this: 17:00:00+00:00 and on the edit section, you can only add time, not GMT/UTC indicator
I’ve been meaning to point this out for a while, I’ve been working round it by changing the date each time
| |
|
| | Posted: 30 Aug 2019 09:41 | |
zag
Posts: 3,627
Joined: 2020
| | Just come across this. When on a football results page that shows the teams lineup , like this one https://www.thesportsdb.com/event/602144, if you click on the away team goalkeeper you get results for the home team centre forward. Seems to be the same through all leagues
| |
|
| | Posted: 30 Aug 2019 09:44 | |
zag
Posts: 3,627
Joined: 2020
| | Just come across this. When on a football results page that shows the teams lineup , like this one https://www.thesportsdb.com/event/602144, if you click on the away team goalkeeper you get results for the home team centre forward. Seems to be the same through all leagues
Nice catch! Fixed.
| |
|
| | Posted: 30 Aug 2019 09:45 | |
zag
Posts: 3,627
Joined: 2020
| | If you edit an event (for example, adding the highlights link) and has the time imported from XMLsoccer, when you save, the time added resets into 23:59:59. It seems that it's caused because time is imported like this: 17:00:00+00:00 and on the edit section, you can only add time, not GMT/UTC indicator
Yes I noticed this as well, still looking into a fix for that one.
EDIT: Hopefully fixed!
| |
|
| | Posted: 31 Aug 2019 18:49 | |
zag
Posts: 3,627
Joined: 2020
| | When you delete an event, it's still displayed on the front page & on TV channel pages. Here an example of a deleted one:
| |
|
| | Posted: 03 Sep 2019 04:45 | |
zag
Posts: 3,627
Joined: 2020
| | Hi Zag,
Please can you check if something is wrong with the highlights field? I'm trying to add videos from YouTube, but they don't keep stored on the DB. These ones are the ones I tried to add without success:
https://www.youtube.com/watch?v=QE-afxKQXEo to the event https://www.thesportsdb.com/event/611704
https://www.youtube.com/watch?v=jihxS6u-WCA to the event https://www.thesportsdb.com/event/611711
TY!
| |
|
| | Posted: 03 Sep 2019 06:17 | |
zag
Posts: 3,627
Joined: 2020
| | Hi,
This API call https://www.thesportsdb.com/api/v1/json ... ?id=134870, return a PHP error:
<br />
<b>Notice</b>: Undefined index: num in <b>C:\inetpub\thesportsdb\api\v1\json\1\eventslast.php</b> on line <b>18</b><br />
Same with this other https://www.thesportsdb.com/api/v1/json ... ?id=134870.
Thanks for your work .
| |
|
| | Posted: 03 Sep 2019 08:27 | |
zag
Posts: 3,627
Joined: 2020
| | Hi Zag,
Please can you check if something is wrong with the highlights field? I'm trying to add videos from YouTube, but they don't keep stored on the DB. These ones are the ones I tried to add without success:
https://www.youtube.com/watch?v=QE-afxKQXEo to the event https://www.thesportsdb.com/event/611704
https://www.youtube.com/watch?v=jihxS6u-WCA to the event https://www.thesportsdb.com/event/611711
TY!
Whoops! Nasty edit event bug. All fixed I hope.
| |
|
| | Posted: 03 Sep 2019 08:31 | |
zag
Posts: 3,627
Joined: 2020
| |
Same with this other https://www.thesportsdb.com/api/v1/json ... ?id=134870.
Thanks for your work .
Whoops x 2!
Looks like I broke the JSON adding the beta feature for limiting the events. All fixed now. Thats why they call it a BETA
Thanks for reporting.
EDIT: This will only work on the "1" developer key for now as its still a beta feature.
| |
|
| | Posted: 07 Sep 2019 09:38 | |
zag
Posts: 3,627
Joined: 2020
| |
As it can be seen on the image, Rafinha from Barcelona is displaying a total nr of honours of 30, but if you check his page (https://www.thesportsdb.com/player/34146374) you can see as he only has 12. So why is displaying 30? Because also are taking into account the ones related to Rafinha from Bayern Munich (https://www.thesportsdb.com/player/34146686) who has 18 honours.
Another example is Maicon (retired player from Inter Milan) who currently has a total count of 29, but if you check his page (https://www.thesportsdb.com/player/34147209) only has 19. The other ones are related to Maicon from Galatasaray (https://www.thesportsdb.com/player/34146583) who has 10.
Is it possible to modify the hounours count from Player Name into Player ID nr. in order to avoid these mistakes, please?
reminder
| |
|
| | Posted: 21 Sep 2019 10:51 | |
zag
Posts: 3,627
Joined: 2020
| | The issues with Wehen Wiesbaden and Osnabrueck are back with the last adds of teams from XMLsoccer...
| |
|
| | Posted: 16 Oct 2019 04:49 | |
zag
Posts: 3,627
Joined: 2020
| | On today "Missing scores" section appears "19.com English Open 2019 Day 2" (snooker), but there's no field to enter scores
| |
|
| | Posted: 16 Oct 2019 09:22 | |
zag
Posts: 3,627
Joined: 2020
| | On today "Missing scores" section appears "19.com English Open 2019 Day 2" (snooker), but there's no field to enter scores
Actually thats a feature
I think we should start adding text in the results field. I need to fix it though for sports that dont have a home and away score so it may not dissapear yet. That is indeed a bug.
EDIT: I improved the screen to now have 3 sections:
- Team vs Team events
- Events that need results text added
- Events that have a UTC +1 date such as american sports (This is to catch the NBA/NHL matches that are shown as next day but actually are finished at 1am)
https://www.thesportsdb.com/missing.php
| |
|
| | Posted: 16 Oct 2019 23:25 | |
zag
Posts: 3,627
Joined: 2020
| | Hi,
I just signed up and found a possible duplicated team:
https://www.thesportsdb.com/team/134463
https://www.thesportsdb.com/team/136250
The first link seems to be the one with more data
| |
|
| | Posted: 17 Oct 2019 09:58 | |
zag
Posts: 3,627
Joined: 2020
| | Hi,
I've noticed that some leagues that are marked as automated results are not displaying the last results correctly:
| |
|
| | Posted: 17 Oct 2019 10:15 | |
zag
Posts: 3,627
Joined: 2020
| | Hi, I've noticed that some leagues that are marked as automated results are not displaying the last results correctly:
Yes good spot! At the moment I just put an icon there for all soccer leagues as they are supposed to be automated. Sadly our data source is less than reliable with some of the smaller leagues.
I will try to get the icon showing more accurate.
I will also fix the errors on the league standings page. That is indeed a bug.
EDIT: fixed the error when some teams dont have any results for the season yet.
| |
|
| | Posted: 17 Oct 2019 10:26 | |
zag
Posts: 3,627
Joined: 2020
| |
Yes good spot! At the moment I just put an icon there for all soccer leagues as they are supposed to be automated. Sadly our data source is less than reliable with some of the smaller leagues.
I will try to get the icon showing more accurate.
I will also fix the errors on the league standings page. That is indeed a bug.
I'm also a web developer and got alot of experience with php, sql, data scrapping, apis (json, xml), webservices...
if you need some help, let me know.
| |
|
| | Posted: 17 Oct 2019 11:02 | |
zag
Posts: 3,627
Joined: 2020
| | I'm also a web developer and got alot of experience with php, sql, data scrapping, apis (json, xml), webservices...
if you need some help, let me know.
Great!
Well we always need help with source data. If you can write anything that can output a JSON, XML or CSV file with scores, events and teamIDs then its useful to us.
Basically most of our importers are just reading some JSON on the internet somewhere and attaching it to TeamIDs or Team names in our database as a text file to import
We also have some python and even powershell importers that other random people wrote over the years
| |
|
| | Posted: 19 Oct 2019 06:04 | |
zag
Posts: 3,627
Joined: 2020
| | Hi,
I've noticed that in the api the current standings and stats of season 19/20, Serie A is incorrect.
Thanks in advance
| |
|
| | Posted: 19 Oct 2019 08:40 | |
zag
Posts: 3,627
Joined: 2020
| | Hi,
I've noticed that in the api the current standings and stats of season 19/20, Serie A is incorrect.
Thanks in advance
Is this just because of goal difference? Or is it a wider problem?
I have a fix for GD to apply soon.
| |
|
| | Posted: 20 Oct 2019 05:29 | |
zag
Posts: 3,627
Joined: 2020
| |
Is this just because of goal difference? Or is it a wider problem?
I have a fix for GD to apply soon.
Hmm, I don't know what causes it but i think there's an extra game for some of the teams. The games played/score is wrong.
| |
|
| | Posted: 20 Oct 2019 12:02 | |
zag
Posts: 3,627
Joined: 2020
| |
Hmm, I don't know what causes it but i think there's an extra game for some of the teams. The games played/score is wrong.
Thanks, Sounds like a data issue then. Perhaps a duplicate event somewhere.
I will take a look.
| |
|
| | Posted: 21 Oct 2019 19:21 | |
zag
Posts: 3,627
Joined: 2020
| |
Hmm, I don't know what causes it but i think there's an extra game for some of the teams. The games played/score is wrong.
I found 2 extra events on 15 september, I remove them and now the table should be correct.
| |
|
| | Posted: 26 Oct 2019 17:38 | |
zag
Posts: 3,627
Joined: 2020
| |
I found 2 extra events on 15 september, I remove them and now the table should be correct.
Thank you very much
| |
|