Reply to thread

Message

<blockquote data-quote="Tide" data-source="post: 253264" data-attributes="member: 71470">This is what I have so far.&nbsp; My P:\Program Files\Team MediaPortal\MediaPortal\database\TVDatabaseV21.db3 file has what I am guessing is the stock 11 TV channels.When I set up the TV server I set up a MySQL database.&nbsp; In that database if I[CODE]SELECT * FROM tvlibrary.channel c;[/CODE]I get the results posted in the attachment.I am guessing MyVoice needs to have a way to tell between a &quot;client only&quot; and a &quot;client server&quot; setup.&nbsp; If it is a &quot;client server setup&quot; then it will need to figure out if it is a SQLite database or a MySQL database (assuming this matters) and get its data from there.&nbsp; I am guessing the table &quot;tvlibrary.channel will provide the data you are looking for to determine the radio and TV channels. There is a column in the tvlibrary.channel called isTV and one called isRadio.&nbsp; They return values of b'0' for &quot;No' and b'1' for &quot;Yes&quot;.&nbsp; You could for instance say (I am no programmer this just makes logical sense):Count = tvlibrary.channel where isTV == b'1' then(Whatever you do with it for myVoice maybe something like)Write myVoice.db3 tvchannels.total == CountFor i in Count Add entry to tvchnnels.list(Whatever you need to collect here maybe Channel id, Channel Name, etc.)Then you could do the same with Radio.I wish I could actually do this myself but I am not even close yet.&nbsp; I can help with testing it and figuring out the logic though.If anyone can take this up and add it that would be great.For now do you think there would be any harm in manually editing my P:\Program Files\Team MediaPortal\MediaPortal\database\TVDatabaseV21.db3 and RadioDatabase4.db3 to reflect what is in my MySQL database so your program will pull the correct information?&nbsp; I do not know if any other file references this but if it does it is wrong anyway so I edited TVDatabaseV21.db3 and added my channels manually.&nbsp; Now I can verbally change the channel past channel 13!!!&nbsp; Guess I will do the radio database next.&nbsp; Hopefully someone can code a fox for this setup.&nbsp; I know I can't be the only person running into this.&nbsp; I have just begun to look at C# but I know nothing.&nbsp; I looked at the source and can tell a little about what is going on but I have no clue how to create an if statement to check for tv server and then to check for database type and then to get the data from the database and then use it instead of what is used for a client only installation.If anyone wants me to post anymore information or test anything to solve this please let me know.</blockquote>

[QUOTE="Tide, post: 253264, member: 71470"] This is what I have so far. My P:\Program Files\Team MediaPortal\MediaPortal\database\TVDatabaseV21.db3 file has what I am guessing is the stock 11 TV channels. When I set up the TV server I set up a MySQL database. In that database if I [CODE]SELECT * FROM tvlibrary.channel c;[/CODE] I get the results posted in the attachment. I am guessing MyVoice needs to have a way to tell between a "client only" and a "client server" setup. If it is a "client server setup" then it will need to figure out if it is a SQLite database or a MySQL database (assuming this matters) and get its data from there. I am guessing the table "tvlibrary.channel will provide the data you are looking for to determine the radio and TV channels. There is a column in the tvlibrary.channel called isTV and one called isRadio. They return values of b'0' for "No' and b'1' for "Yes". You could for instance say (I am no programmer this just makes logical sense): Count = tvlibrary.channel where isTV == b'1' then (Whatever you do with it for myVoice maybe something like) Write myVoice.db3 tvchannels.total == Count For i in Count Add entry to tvchnnels.list (Whatever you need to collect here maybe Channel id, Channel Name, etc.) Then you could do the same with Radio. I wish I could actually do this myself but I am not even close yet. I can help with testing it and figuring out the logic though. If anyone can take this up and add it that would be great. For now do you think there would be any harm in manually editing my P:\Program Files\Team MediaPortal\MediaPortal\database\TVDatabaseV21.db3 and RadioDatabase4.db3 to reflect what is in my MySQL database so your program will pull the correct information? I do not know if any other file references this but if it does it is wrong anyway so I edited TVDatabaseV21.db3 and added my channels manually. Now I can verbally change the channel past channel 13!!! Guess I will do the radio database next. Hopefully someone can code a fox for this setup. I know I can't be the only person running into this. I have just begun to look at C# but I know nothing. I looked at the source and can tell a little about what is going on but I have no clue how to create an if statement to check for tv server and then to check for database type and then to get the data from the database and then use it instead of what is used for a client only installation. If anyone wants me to post anymore information or test anything to solve this please let me know. [/QUOTE]

Verification