User avatar
zag
Site Admin
Posts: 171
Joined: Tue Oct 11, 2016 9:43 am

Re: New site todo

Tue Jan 31, 2017 12:02 pm

RobSteeleAVFC wrote:Hi Zag,

Lookman does not get printed out. Transferring players from one side to another is working correctly as I have tested this.


I can't help too much with the Python module as not an expert in that launguage, but I can conform our API is working as it should for those players

You can test any player search with this URL, to check the backend data

http://www.thesportsdb.com/api/v1/json/ ... %20Lookman

User avatar
zag
Site Admin
Posts: 171
Joined: Tue Oct 11, 2016 9:43 am

Re: New site todo

Tue Jan 31, 2017 8:34 pm

New team landing page

http://www.thesportsdb.com/teams_main.php
http://www.thesportsdb.com/players_main.php
http://www.thesportsdb.com/events_main.php

Shows a few random and popular teams/players to get people browsing.

User avatar
Ovokx
Moderator
Posts: 97
Joined: Mon Jan 23, 2017 6:03 pm
Location: Spain

Re: New site todo

Tue Jan 31, 2017 9:44 pm

Great idea!

User avatar
zag
Site Admin
Posts: 171
Joined: Tue Oct 11, 2016 9:43 am

Re: New site todo

Thu Feb 09, 2017 2:07 pm

English Premiership rugby is now automated ;)

I might be able to do "rugby pro 12" as well if there is demand for that.

EDIT: Did both as the API was nice and easy to use

http://www.thesportsdb.com/league/4414
http://www.thesportsdb.com/league/4446

User avatar
zag
Site Admin
Posts: 171
Joined: Tue Oct 11, 2016 9:43 am

Re: New site todo

Fri Feb 17, 2017 11:41 am


User avatar
Ovokx
Moderator
Posts: 97
Joined: Mon Jan 23, 2017 6:03 pm
Location: Spain

Re: New Progress

Sat Feb 18, 2017 10:41 am

In order to be able to add players to these new sports, playing positions are missing which are mandatory to add new players to the db ;)

User avatar
Ovokx
Moderator
Posts: 97
Joined: Mon Jan 23, 2017 6:03 pm
Location: Spain

Re: New Progress

Sat Feb 18, 2017 10:59 am

Also I have added the first Tennis event (ABN AMRO World Tennis Tournament - Final) and it can't be editable. If you try to enter on it to add details, it returns the next error:

Code: Select all

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, 'You have an err...', 'C:\\inetpub\\thes...', 272, Array) #3 C:\inetpub\thesportsdb\includes\ez_sql_mysqli.php(272): trigger_error('You have an err...', 512) #4 C:\inetpub\thesportsdb\includes\ez_sql_core.php(164): ezSQL_mysqli->query('SELECT * FROM t...') #5 C:\inetpub\thesportsdb\event.php(137): ezSQLcore->get_row('SELECT * FROM t...') #6 {main} thrown in C:\inetpub\thesportsdb\forum\phpbb\session.php on line 1580

User avatar
Ovokx
Moderator
Posts: 97
Joined: Mon Jan 23, 2017 6:03 pm
Location: Spain

Re: New Progress

Sat Feb 18, 2017 11:07 am

Similar issue on cycling, but the event is not created ;)

Code: Select all

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\edit_event_add_process.php(211): ezSQL_mysqli->query('INSERT INTO edi...') #5 {main} thrown in C:\inetpub\thesportsdb\forum\phpbb\session.php on line 1580

User avatar
Ovokx
Moderator
Posts: 97
Joined: Mon Jan 23, 2017 6:03 pm
Location: Spain

Re: New Progress

Sat Feb 18, 2017 11:20 am

Also I have found another error adding fanart to Tennis league:

Code: Select all

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\uploadleaguefanart1.php(63): ezSQL_mysqli->query('INSERT INTO edi...') #5 {main} thrown in C:\inetpub\thesportsdb\forum\phpbb\session.php on line 1580


;)

User avatar
zag
Site Admin
Posts: 171
Joined: Tue Oct 11, 2016 9:43 am

Re: New Progress

Sat Feb 18, 2017 1:00 pm

OK, I should have tested first! Should all be fixed :)

The league fanart error has apparently been around for a while, its working now though.

EDIT: Also added a few playing positions for the new sports. Let me know if there are any more, or we want some honours added ;)

Return to “General Discussion”