[craigey1]

I agree with stoli, so +1 rep to Mpauley73.

Still no luck getting leading zeros for the season & episodes to work.

[MDPauley]

I agree with stoli, so +1 rep to Mpauley73.

Still no luck getting leading zeros for the season & episodes to work.

Thanks,

I'm back home now so I'll take a look @ it again this evening...

[MDPauley]

Replace the TV statement with this...

Code:

select '<title>', tvshow.c00, ' - ', episode.C00, '</title>', '<description>', episode.c01,'</description>'
from episode JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode
JOIN tvshow ON  tvshowlinkepisode.idShow = tvshow.idShow ORDER BY
episode.idEpisode DESC LIMIT 15

Forgot a table prefix...

[MDPauley]

I agree with stoli, so +1 rep to Mpauley73.

Still no luck getting leading zeros for the season & episodes to work.

IF...THEN constructs are not in sqlite... this may not be possible with pure sql...

[craigey1]

Thanks.
I tried creating a function that used replace statements on the response before doing the response.write, but that didn't work.

Code:

Response= replace(Response,"S1E1","S01E01")
response.write(Response)

It was actually a bit smarter then that, but this is just an example of what I was trying.

Nor did breaking out of the sql code & doing an if then statement.

Code:

Response = xbmcAPI("QueryVideoDatabase(SELECT '<title>',strTitle,': ', C00, ' ('S<% if C12 < 10 then response.write("0") %>', c12, 'E', c13 ,')', '</title>'

The sqlite code I tried was

Code:

Select Right(Replicate('0',2) + c12,2) from episodeid

but sqlite didn't seem to like it.

[whufclee]

Sorry for the real noob style question guys but...

I've got this set up so I get 2 feeds at the bottom of the screen which say New Movies and then New TV Shows, however it isn't showing any results. I presume it's because I don't have the correct port set up in the line <link>http://localhost:89/rssmovies.asp/</link>

How do I find out what port I need to use? I'm using xbmc rev 23393 on xbox and have my network settings as automatic. I know I'm being thick but just can't get my head around network settings! Any help much appreciated, cheers.

[MDPauley]

How do I find out what port I need to use?

whufclee,

go to settings, network, servers and make sure webserver is enabled and the port is displayed right under it.

[hamd01]

Just what I was looking for. Works brilliant!

[HackerHelpDesk]

Ok still not working for my test library. Fresh install of nightly windows build and added 1 new movie and 1 new TV show. Everything is in place and the feed title is working but no listing after the title. I am also able to open the feed in a web browser and it still has no items after the title. I will test it tonight on my Xbox to see if I have better results.

[stoli]

Ensure you have the port set correctly in XBMC. To check from a pc to you xbox, in a browser open http://<xbox ip address>:80 or whatever port you have xbmc set to in network settings. This should at least bring up the web interface to xbmc.

[HackerHelpDesk]

Web console works http://192.168.1.50/rss.asp/, Rss feed appears but nothing is listed. I tried on my windows machine and my xbox.

[craigey1]

Can you try running the sql "select C00,c07,c01 from movie ORDER BY idMovie DESC LIMIT 20" in sqlite3Explorer & check the results returned, then run "SELECT C00,c12,c13,c01 FROM episodeview ORDER BY idEpisode DESC Limit 20" again check that the results return the data you expect.

Alternatively can you post the code in your rss.asp page? (particularly the response lines).

[HackerHelpDesk]

Here is my rss.asp file
<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
<channel>
<title>New in XBMC Video Library</title>
<link>http://localhost:80/rss.asp/</link>
<description>This is my rss 2 feed for newest xbmc movies</description>
<language>en-us</language>

<%
var Response;
var setHeader;
var resetHeader;

setHeader = xbmcAPI("setresponseformat(webheader;false;webfooter;false;opentag;<tag>;closetag;</tag>;openRecord;<item>;closeRecord;</item>;openField;\n;closeField;\n;closefinaltag;false)");
Response = xbmcAPI("QueryVideoDatabase(select '<title>', C00, ' (', c07, ')', '</title>', '<description>',c01,'</description>' from movie ORDER BY idMovie DESC LIMIT 15)");
write(Response);

Response = xbmcAPI("QueryVideoDatabase(select '<title>', tvshow.c00, ' - ', episode.C00, '</title>', '<description>', episode.c01,'</description>' from episode JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow ORDER BY episode.idEpisode DESC LIMIT 15)");
write(Response);
resetHeader = xbmcAPI("SetResponseFormat()");

%>
</channel>
</rss>

[HackerHelpDesk]

Not sure how to run sqlite3Explorer on the xbox.

[kizer]

Heres how my Xbox is setup: I did remove the date on the movies because I didn't want it shown, but I'm sure you can readd it. My xbox uses port 80.

/E/Apps/XBMC/UserData/RssFeeds.xml

Code:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<rssfeeds>
  <!-- RSS feeds. To have multiple feeds, just add a feed to the set. You can also have multiple sets.     !-->
  <!-- To use different sets in your skin, each must be called from skin with a unique id.                 !-->
  <set id="1">
    <feed updateinterval="30">http://localhost:80/movies.asp</feed>
    <feed updateinterval="30">http://localhost:80/tv.asp</feed>  
</set>

</rssfeeds>

/E/Apps/XBMC/web/movies.asp

Code:

<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
<channel>
<title>New Movies</title>
<link>http://localhost:80/movies.asp/</link>
<description>This is my rss 2 feed for newest xbmc movies</description>
<language>en-us</language>

<%
var Response;
var setHeader;
var resetHeader;

setHeader = xbmcAPI("setresponseformat(webheader;false;webfooter;false;opentag;<tag>;closetag;</tag>;openRecord;<item>;closeRecord;</item>;openField;\n;closeField;\n;closefinaltag;false)");
Response = xbmcAPI("QueryVideoDatabase(select '<title>', C00, '</title>', '<description>',c01,'</description>' from movie ORDER BY idMovie DESC LIMIT 5)");
write(Response);
resetHeader = xbmcAPI("SetResponseFormat()");
%>
</channel>
</rss>

/E/Apps/XBMC/web/tv.asp

Code:

<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
<channel>
<title>New TV Shows</title>
<link>http://localhost:80/tv.asp/</link>
<description>This is my rss 2 feed for newest xbmc tv shows</description>
<language>en-us</language>

<%
var Response;
var setHeader;
var resetHeader;

setHeader = xbmcAPI("setresponseformat(webheader;false;webfooter;false;opentag;<tag>;closetag;</tag>;openRecord;<item>;closeRecord;</item>;openField;\n;closeField;\n;closefinaltag;false)");
Response = xbmcAPI("QueryVideoDatabase(SELECT '<title>',strTitle,': ', C00, ' (S', c12, 'E', c13 ,')', '</title>', '<description>',c01,'</description>' FROM episodeview ORDER BY idEpisode DESC Limit 5)");
write(Response);
resetHeader = xbmcAPI("SetResponseFormat()");

%>
</channel>
</rss>