Reply to thread

Message

<blockquote data-quote="geoffstewart" data-source="post: 637413" data-attributes="member: 83396">Re: Schedules Direct US/Canadian/Mexico EPG Plugin (Updated April 2010)Hey poppabk,Are you looking in the database directly?If you are, I think you may be looking at the wrong field... The &quot;seriesNum&quot; field in the program table has EPxxxxxxxx in it... this identifies the whole series...The episodeNum field is either filled with the following 3 items:1. &quot;-&quot;:&nbsp; When no episode number information is available2. &quot;SxxExx&quot;: When this plugin finds the episode information on thetvdb.com3. Some other number/char combination:&nbsp; The episode number from SchedulesDirect that was either not found or not searched for on thetvdb.comIf you're using a database browser, used the following queries to determine how many entries were found in thetvdb.com:To find out the total number of entries in your program database:[CODE]select count(*) from program[/CODE]To find out the number of entries that have SxxExx formated episode numbers:[CODE]select count(*) from program where episodeNum LIKE 'S%E%'[/CODE]If you are not using a database browser, let me know where you're finding this info...Hope this helps.Cheers.Geoff</blockquote>

[QUOTE="geoffstewart, post: 637413, member: 83396"] [b]Re: Schedules Direct US/Canadian/Mexico EPG Plugin (Updated April 2010)[/b] Hey poppabk, Are you looking in the database directly? If you are, I think you may be looking at the wrong field... The "seriesNum" field in the program table has EPxxxxxxxx in it... this identifies the whole series... The episodeNum field is either filled with the following 3 items: 1. "-": When no episode number information is available 2. "SxxExx": When this plugin finds the episode information on thetvdb.com 3. Some other number/char combination: The episode number from SchedulesDirect that was either not found or not searched for on thetvdb.com If you're using a database browser, used the following queries to determine how many entries were found in thetvdb.com: To find out the total number of entries in your program database: [CODE]select count(*) from program[/CODE] To find out the number of entries that have SxxExx formated episode numbers: [CODE]select count(*) from program where episodeNum LIKE 'S%E%'[/CODE] If you are not using a database browser, let me know where you're finding this info... Hope this helps. Cheers. Geoff [/QUOTE]

Verification