2009-10-10, 12:47
I agree with stoli, so +1 rep to Mpauley73.
Still no luck getting leading zeros for the season & episodes to work.
Still no luck getting leading zeros for the season & episodes to work.
craigey1 Wrote:I agree with stoli, so +1 rep to Mpauley73.
Still no luck getting leading zeros for the season & episodes to work.
MPauley73 Wrote:Replace the TV statement with this...
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
craigey1 Wrote:I agree with stoli, so +1 rep to Mpauley73.
Still no luck getting leading zeros for the season & episodes to work.
Response= replace(Response,"S1E1","S01E01")
response.write(Response)
Response = xbmcAPI("QueryVideoDatabase(SELECT '<title>',strTitle,': ', C00, ' ('S<% if C12 < 10 then response.write("0") %>', c12, 'E', c13 ,')', '</title>'
Select Right(Replicate('0',2) + c12,2) from episodeid
whufclee Wrote:How do I find out what port I need to use?
<?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>
<?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>
<?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>