| | Posted: 16 Jun 2018 09:31 | |
zag
Posts: 3,511
Joined: 2020
| | "_deceased" players are not included on Hall of Fame page. Example:
Maria Bueno (https://www.thesportsdb.com/player/34163365) has 7 honours, but she's not displayed on Tennis HoF (https://www.thesportsdb.com/hall_of_fame.php?s=Tennis)
| |
 |
| | Posted: 08 Jul 2018 13:47 | |
zag
Posts: 3,511
Joined: 2020
| | Impossible to transfer players from other teams in to M'gladbach (https://www.thesportsdb.com/team/134779). I'm always getting this error:
Fatal error: Uncaught Error: Call to undefined method ezSQL_mysqli::sql_return_on_error() in C:\inetpub\thesportsdb\forum\phpbb\session.php:1580 Stack trace: #0 C:\inetpub\thesportsdb\forum\includes\functions.php(4995): phpbb\session->update_session_infos() #1 C:\inetpub\thesportsdb\forum\includes\functions.php(4083): page_header('Information') #2 [internal function]: msg_handler(512, 'Incorrect integ...', 'C:\\inetpub\\thes...', 272, Array) #3 C:\inetpub\thesportsdb\includes\ez_sql_mysqli.php(272): trigger_error('Incorrect integ...', 512) #4 C:\inetpub\thesportsdb\player.php(174): ezSQL_mysqli->query('UPDATE players ...') #5 {main} thrown in C:\inetpub\thesportsdb\forum\phpbb\session.php on line 1580
| |
|
| | Posted: 25 Aug 2018 09:10 | |
zag
Posts: 3,511
Joined: 2020
| | Hi Zag!
Is there a limit of TV events to be displayed on the main page? See today's one:
| |
|
| | Posted: 28 Aug 2018 08:28 | |
zag
Posts: 3,511
Joined: 2020
| | Spanish and couple more league table response
08-28 09:32:19.506 3946-4175/com.voinovski.goran.sportsonyourpalm D/Retrofit: Received response for https://www.thesportsdb.com/api/v1/json ... 335&s=1819 in 925.5ms
date: Tue, 28 Aug 2018 07:32:19 GMT
content-type: application/json; charset=utf-8
set-cookie: __cfduid=d293c33cca0d0ad707878919d97c0344c1535441539; expires=Wed, 28-Aug-19 07:32:19 GMT; path=/; domain=.thesportsdb.com; HttpOnly; Secure
x-powered-by: PHP/7.0.9
x-powered-by: ASP.NET
access-control-allow-origin: *
expect-ct: max-age=604800, report-uri="https://report-uri.cloudflare.com/cdn-cgi/beacon/expect-ct"
server: cloudflare
cf-ray: 45151554da7b3dcb-MXP
Body <br />
<b>Warning</b>: Invalid argument supplied for foreach() in <b>C:\inetpub\thesportsdb\api\v1\json\1\lookuptable.php</b> on line <b>103</b><br />
<br />
<b>Warning</b>: Invalid argument supplied for foreach() in <b>C:\inetpub\thesportsdb\api\v1\json\1\lookuptable.php</b> on line <b>103</b><br />
<br />
<b>Warning</b>: Invalid argument supplied for foreach() in <b>C:\inetpub\thesportsdb\api\v1\json\1\lookuptable.php</b> on line <b>96</b><br />
<br />
<b>Warning</b>: Invalid argument supplied for foreach() in <b>C:\inetpub\thesportsdb\api\v1\json\1\lookuptable.php</b> on line <b>96</b><br />
{"table":[{"name":"Real Madrid","teamid":"133738","played":3,"goalsfor":6,"goalsagainst":1,"goalsdifference":5,"win":2,"draw":1,"loss":0,"total":7},{"name":"Barcelona","teamid":"133739","played":2,"goalsfor":4,"goalsagainst":0,"goalsdifference":4,"win":2,"draw":0,"loss":0,"total":6},{"name":"Ath Bilbao","teamid":"133727","played":2,"goalsfor":4,"goalsagainst":3,"goalsdifference":1,"win":1,"draw":1,"loss":0,"total":4},{"name":"Ath Madrid","teamid":"133729","played":2,"goalsfor":2,"goalsagainst":1,"goalsdifference":1,"win":1,"draw":1,"loss":0,"total":4},{"name":"Celta Vigo","teamid":"133937","played":2,"goalsfor":3,"goalsagainst":2,"goalsdifference":1,"win":1,"draw":1,"loss":0,"total":4},{"name":"Espanol","teamid":"133734","played":2,"goalsfor":3,"goalsagainst":1,"goalsdifference":2,"win":1,"draw":1,"loss":0,"total":4},{"name":"Huesca","teamid":"135454","played":2,"goalsfor":4,"goalsagainst":3,"goalsdifference":1,"win":1,"draw":1,"loss":0,"total":4},{"name":"Sevilla","teamid":"133735","played":2,"goalsfor":10,"goalsagainst":1,"goalsdifference":9,"win":1,"draw":1,"loss":0,"total":4},{"name":"Sociedad","teamid":"133724","played":2,"goalsfor":4,"goalsagainst":3,"goalsdifference":1,"win":1,"draw":1,"loss":0,"total":4},{"name":"Getafe","teamid":"133731","played":2,"goalsfor":2,"goalsagainst":2,"goalsdifference":0,"win":1,"draw":0,"loss":1,"total":3},{"name":"Girona","teamid":"134700","played":4,"goalsfor":1,"goalsagainst":4,"goalsdifference":-3,"win":0,"draw":3,"loss":1,"total":3},{"name":"Levante","teamid":"133732","played":2,"goalsfor":4,"goalsagainst":2,"goalsdifference":2,"win":1,"draw":0,"loss":1,"total":3},{"name":"Valladolid","teamid":"133841","played":3,"goalsfor":0,"goalsagainst":1,"goalsdifference":-1,"win":0,"draw":2,"loss":1,"total":2},{"name":"Alaves","teamid":"134221","played":2,"goalsfor":0,"goalsagainst":3,"goalsdifference":-3,"win":0,"draw":1,"loss":1,"total":1},{"name":"Betis","teamid":"133722","played":2,"goalsfor":0,"goalsagainst":3,"goalsdifference":-3,"win":0,"draw":1,"loss":1,"total":1},{"name":"Leganes","teamid":"134701","played":2,"goalsfor":3,"goalsagainst":4,"goalsdifference":-1,"win":0,"draw":1,"loss":1,"total":1},{"name":"Valencia","teamid":"133725","played":2,"goalsfor":1,"goalsagainst":3,"goalsdifference":-2,"win":0,"draw":1,"loss":1,"total":1},{"name":"Villarreal","teamid":"133740","played":2,"goalsfor":1,"goalsagainst":2,"goalsdifference":-1,"win":0,"draw":1,"loss":1,"total":1},{"name":"Eibar","teamid":"134626","played":2,"goalsfor":1,"goalsagainst":4,"goalsdifference":-3,"win":0,"draw":0,"loss":2,"total":0},{"name":"Vallecano","teamid":"133728","played":2,"goalsfor":1,"goalsagainst":5,"goalsdifference":-4,"win":0,"draw":0,"loss":2,"total":0}]}
| |
|
| | Posted: 28 Aug 2018 11:22 | |
zag
Posts: 3,511
Joined: 2020
| | Thanks for the reports, fixed api and tv listing display errors.
| |
|
| | Posted: 01 Sep 2018 09:15 | |
zag
Posts: 3,511
Joined: 2020
| | Football importer error for Spanish La Liga:
As you can see on the image, the importer is adding events 4 and 5 by round related to Real Madrid. I delete them every week, by they are added automatically the next day again.
Also creates fake events as the one marked in round 1. This event never existed.
Thank you!
| |
|
| | Posted: 02 Sep 2018 07:47 | |
zag
Posts: 3,511
Joined: 2020
| | Thanks for the reports, fixed api and tv listing display errors.
| |
|
| | Posted: 04 Sep 2018 07:19 | |
zag
Posts: 3,511
Joined: 2020
| | Fixed again
Too much data hehe.
EDIT: the La Liga data is a soccer xml issue, I would advise not to delete any data and just wait for them to fix it. The importer updates each day.
| |
|
| | Posted: 08 Sep 2018 10:03 | |
zag
Posts: 3,511
Joined: 2020
| | XML issue is still present. See next and past events for Real Madrid:
| |
|
| | Posted: 13 Sep 2018 10:58 | |
zag
Posts: 3,511
Joined: 2020
| | I've cleaned up la liga past round 5. It may take 24hrs to sync. Let me know if that fixes it.
| |
|
| | Posted: 16 Dec 2018 14:22 | |
zag
Posts: 3,511
Joined: 2020
| | Curaçao flag is missing. See Eloy Room (https://www.thesportsdb.com/player/34155773) profile
| |
|
| | Posted: 21 Dec 2018 10:47 | |
zag
Posts: 3,511
Joined: 2020
| | Thanks fixed
| |
|
| | Posted: 22 Dec 2018 11:36 | |
zag
Posts: 3,511
Joined: 2020
| | Invicta FC events are wrongly pointing to another league (ACB MMA):
See this event as an example: https://www.thesportsdb.com/event/593230
Same issue is happening with ACB MMA events which are poiting to wrong league. In this case to "Cage Warriors".
See this events as an example: https://www.thesportsdb.com/event/593227
Also the team created for Invicta FC is wrong as it's displaying "ACB MMA Men" when it should be "Invicta FC Women"
TY!
| |
|
| | Posted: 22 Dec 2018 14:29 | |
zag
Posts: 3,511
Joined: 2020
| | adding events to Cage Warriors points to here.. https://www.thesportsdb.com/edit_event_add.php?l=4492 , which is the wrong screen for this type of event
| |
|
| | Posted: 22 Dec 2018 17:05 | |
zag
Posts: 3,511
Joined: 2020
| | Thanks fixed, needed the cage warrior mens team to be present in the league
| |
|
| | Posted: 27 Dec 2018 12:32 | |
zag
Posts: 3,511
Joined: 2020
| | While moving all events related to Pro14 2018/19 season to the right season (they were all imported on the 2017/18) I have detected that all events related to Bennetton (https://www.thesportsdb.com/team/135595) were not imported and I think that it's because the team name is not correctly written. One "T" is missing on the name.
| |
|
| | Posted: 29 Dec 2018 13:13 | |
zag
Posts: 3,511
Joined: 2020
| | thx, corrected the name to "Benetton"
| |
|
| | Posted: 19 Jan 2019 08:45 | |
zag
Posts: 3,511
Joined: 2020
| | I have found an issue using "Contracts". Kiko Casilla (https://www.thesportsdb.com/player/34149403) has been transfered from Real Madrid to Leeds and I have added his new contract to the DB (up to 2023), but at team level, it's still displaying the countdown related to Real Madrid's contract (1) instead of the one related to Leeds (4)
| |
|
| | Posted: 19 Jan 2019 09:11 | |
zag
Posts: 3,511
Joined: 2020
| | Yes another Bug recently I need to record is the apostrophe in events not escaping properly.
| |
|
| | Posted: 05 Mar 2019 18:51 | |
zag
Posts: 3,511
Joined: 2020
| | If there is already a poster at league level, it can be updated. Pencil is missing
| |
|
| | Posted: 06 Mar 2019 12:39 | |
zag
Posts: 3,511
Joined: 2020
| | If there is already a poster at league level, it can be updated. Pencil is missing
Thx fixed
| |
|
| | Posted: 17 Apr 2019 16:00 | |
zag
Posts: 3,511
Joined: 2020
| | For rescheduled events, if on the original date was added a TV channel then when you add a TV channel which a different date/time, on the main page all events are wrongly displayed. You can see some examples on today's page (marked on red):
Nantes vs PSG
Lazio vs Udinese
Thanks!
| |
|
| | Posted: 12 May 2019 15:56 | |
zag
Posts: 3,511
Joined: 2020
| | Team number updates don't work on basketball players
| |
|
| | Posted: 13 May 2019 09:20 | |
zag
Posts: 3,511
Joined: 2020
| | Team number updates don't work on basketball players
Fixed
| |
|
| | Posted: 09 Jul 2019 18:34 | |
zag
Posts: 3,511
Joined: 2020
| | Honours count displayed in "Hall of Fame" is wrong for different players with same name. Some examples:
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?
| |
|