Kodi Community Forum
WIP Unnamed/Sports Center - Sports for Kodi - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Add-on Support (https://forum.kodi.tv/forumdisplay.php?fid=27)
+---- Forum: Program Add-ons (https://forum.kodi.tv/forumdisplay.php?fid=151)
+---- Thread: WIP Unnamed/Sports Center - Sports for Kodi (/showthread.php?tid=216044)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

RE: Unnamed/Sports Center - Sports for Kodi - enen92 - 2015-04-23

(2015-04-23, 21:50)zag Wrote:
(2015-04-23, 16:26)enen92 Wrote: If you are terribly bored and in need of working on thesportsdb you can probably add a way of granting users the ability of define the event time when adding or editing events Rofl:

How are you calculating the time with python? Are you just taking the first 5 chars on the left?

Basically how should I store the time in the database?

EDIT: Nevermind, will just replicate the format from xmlsoccer

Yeah the same format is okay. In python I'm matching (.+?)\+ and then match (.+?)Sad.+?) to have the hour and minute. Then I'll convert them using pytz (not done yet).
Let me know an example when you have it working

RE: Unnamed/Sports Center - Sports for Kodi - zag - 2015-04-23

Should be editable and addable now

Format is

Code:
HH:MM:SS

I have not included the timezone data for now

RE: Unnamed/Sports Center - Sports for Kodi - enen92 - 2015-04-24

Progress: The addon works well with a static database I created by adding a few events to it through the db api of the addon.
Created with a script like this:

Code:
import sc_database

lista_ligas = ['4344','4335','4328','4387','4380']
for id_ in lista_ligas:
    sc_database.Inserter().insert_league(id_)
    
lista_teams = ['134850','134849','134855','134854','134869','134867','134882','134863','134116','134588','134114','134118','134386','134108','133738','133736','133739','133725','133610','133612','134777','133616','133613','133636']
for id_ in lista_teams:
    sc_database.Inserter().insert_team(id_)

lista_events = ['482649','482647','452436','452433','446426','446424','446430','443895','443893','441750','441752','441744']
for id_ in lista_events:
    sc_database.Inserter().insert_event(id_,'folder_or_file.mp4')

This is basically what the scrapper will do, try to find the event id and then call the db api to add that event, that league and the teams involved.

Season list and teams list in the submenu of the home menu are also working. See screenshots below:

watch gallery


Now missing a dialog/views for events and then the next step is the scrapper Smile

For the scrapper I will probably have a request for @zag. Probably we will need to add an entry in the database for Leagues and Teams called keywords. Something the site might ignore when searching for teams but that would be returned in the json response.

For instance if you have a file named:

EPL.1415.Chelsea.vs.Arsenal.mp4 it will be hard to find the league of the event without checking the teams first. EPL is a common name but we can only search the api for something like Premier League or British Premier League. A simple field (invisible in the main page as alternative name is right now) where one could fill keywords separated by ; would be helpfull. For instance for arsenal you could have:

Arsenal;gunners;arsenalfc;etc

RE: Unnamed/Sports Center - Sports for Kodi - zag - 2015-04-24

You want an alternative name for leagues?

RE: Unnamed/Sports Center - Sports for Kodi - enen92 - 2015-04-24

No, a static field where you can add keywords to identify a league or a team that are both different from the Default Name and the Alternative Name. This way users can colaborate with each other adding keywords there and helping each other getting better scrapper results.
Appart from this addon it can also be usefull for any other tools, apps or plugins that try to match teams and leagues in other websites with the ones on thesportsdb.

For instance I plan on developing an external module for this plugin for getyourfixtures.com to grab the tv channels where a match or event is going to be aired. And then starting the respective channel the user has on the Livetv/PVR section. So for instance, the keywords field would be awesome because if a team name is different on that website we can just add another keyword with the respective name and the teams will then be matched correctly.

Just a text input field where the data is separated somehow. Using ; or | or any other way.

RE: Unnamed/Sports Center - Sports for Kodi - Ovokx - 2015-04-24

enen92, if you want to test some events with manual time entries, I have just created a new season (all real events & real GMT+0 times) here: http://www.thesportsdb.com/season.php?l=4347&s=2015

Wink

RE: Unnamed/Sports Center - Sports for Kodi - enen92 - 2015-04-24

(2015-04-24, 19:36)Ovokx Wrote: enen92, if you want to test some events with manual time entries, I have just created a new season (all real events & real GMT+0 times) here: http://www.thesportsdb.com/season.php?l=4347&s=2015

Wink

That's probably a bad ideia until we can manually define which timezone the time is applicable. Until then, we should insert the times based on GMT-1 (Atlantic/Azores timezone).

RE: Unnamed/Sports Center - Sports for Kodi - zag - 2015-04-24

I think its probably best if we stick to GMT as a standard

RE: Unnamed/Sports Center - Sports for Kodi - enen92 - 2015-04-24

(2015-04-24, 20:01)zag Wrote: I think its probably best if we stick to GMT as a standard

For me it doesn't make any difference Wink . If you define a new standard you'll have to convert all the events you have on the database though.

RE: Unnamed/Sports Center - Sports for Kodi - Ovokx - 2015-04-25

So, which time zone should be used? For me it doesn't matter as I'm getting the info from flashscore.com where you can select any time zone to get the proper info.

Thanks for clarifying in order to enter the correct data Smile

RE: Unnamed/Sports Center - Sports for Kodi - zag - 2015-04-25

GMT, i'll try to make it clear on the site as well.

RE: Unnamed/Sports Center - Sports for Kodi - enen92 - 2015-04-25

@zag and anyone else:
Can you guys get me the epg data of soccer matches on your (your or any public source) epg? Both title and description when a football match is playing. Sky sports, ITV, BBC, wtv. I'm trying to find out the most used 'vs' format for soccer in the epg data of TV providers. The more channels the better.
Before we had rytec where se could grab this info but it is of was blocked a few time ago.

Cheers

PS: the idea is for the scrapper so we can press a key and get info from the match we are watching

RE: Unnamed/Sports Center - Sports for Kodi - Ovokx - 2015-04-25

Sky Sports: http://www1.skysports.com/watch/tv-guide
Canal+ Spain: http://www.plus.es/guia/
Yomvi: http://yomvi.plus.es/deportes/destacados/
Movistar TV: https://go.tv.movistar.es/#/tv-guide
Direct TV: https://www.directv.com/guide (see channel #206 and ahead for sports)
Be In Sports: http://www.en.beinsports.net/tv-guide
FOX Sports: http://www.foxsports.com.au/tvguide
BT: https://tv.bt.com/tvguide (see channel #501 & ahead for sports)
TV Guide: http://www.tvguide.com/sports/listings/
NBC Sports: http://affiliate.zap2it.com/tvlistings/ZCGrid.do?aid=nbcsports
NOWtv: http://watch.nowtv.com/sports/listings
Xfinity TV: http://xfinitytv.comcast.net/microsite/sports

RE: Unnamed/Sports Center - Sports for Kodi - zag - 2015-04-25

http://www.radiotimes.com/beta/tv/listings
http://www.tvguide.co.uk/

I think the most used in the UK is:

Manchester City v Aston Villa

RE: Unnamed/Sports Center - Sports for Kodi - Ovokx - 2015-04-25

In Spain the most used is:

Real Madrid - Barcelona