forked from rho_n/hpr_generator
49 lines
1.7 KiB
HTML
49 lines
1.7 KiB
HTML
|
<!--% PROCESS 'shared-episode-summary.tpl.html' %-->
|
||
|
|
<!--% PROCESS 'shared-avatar.tpl.html' %-->
|
||
|
|
<!--% USE DBI(constants.driver, constants.user, constants.password) %-->
|
||
|
|
<!--% query_series = DBI.prepare('SELECT miniseries.id, miniseries.name,
|
||
|
|
miniseries.description,
|
||
|
|
miniseries.private, miniseries.image, miniseries.valid,
|
||
|
|
ep.number_of_episodes, ep.latest_show, ep.earliest_show
|
||
|
|
FROM miniseries
|
||
|
|
INNER JOIN
|
||
|
|
(SELECT series,
|
||
|
|
COUNT(eps.id) AS number_of_episodes,
|
||
|
|
MAX(eps.date) AS latest_show,
|
||
|
|
MIN(eps.date) AS earliest_show
|
||
|
|
FROM eps
|
||
|
|
GROUP BY series) AS ep ON ep.series = miniseries.id
|
||
|
|
WHERE miniseries.id = ?
|
||
|
|
ORDER BY name')
|
||
|
|
%-->
|
||
|
|
<!--% series_result = query_series.execute(id) %-->
|
||
|
|
<article>
|
||
|
|
<!--% FOREACH series IN series_result %-->
|
||
|
|
<h1 class="title">In-Depth Series: <!--% series.name %--></h1>
|
||
|
|
<ul>
|
||
|
|
<li>Number of episodes: <!--% series.number_of_episodes %--></li>
|
||
|
|
<li>Open/closed: open</li>
|
||
|
|
<li>Date of earliest show: <!--% series.earliest_show %--></li>
|
||
|
|
<li>Date of latest show: <!--% series.latest_show %--></li>
|
||
|
|
<li>Series RSS feeds: <a href="hpr_ogg_rss.php?series=79&full=1&gomax=1">ogg</a>, <a href="hpr_spx_rss.php?series=79&full=1&gomax=1">spx</a>, <a href="hpr_mp3_rss.php?series=79&full=1&gomax=1">mp3</a></li>
|
||
|
|
</ul>
|
||
|
|
<div><em><!--% series.description %--></em></div>
|
||
|
|
<!--% END %-->
|
||
|
|
<!--% query_shows = DBI.prepare('SELECT
|
||
|
|
id, date, title,
|
||
|
|
duration, summary, notes,
|
||
|
|
explicit, eps.license, tags,
|
||
|
|
hosts.host, hosts.hostid
|
||
|
|
FROM eps
|
||
|
|
INNER JOIN hosts
|
||
|
|
ON eps.hostid = hosts.hostid
|
||
|
|
WHERE series = ?
|
||
|
|
ORDER BY date DESC
|
||
|
|
')
|
||
|
|
%-->
|
||
|
|
<!--% show_results = query_shows.execute(id) %-->
|
||
|
|
<!--% FOREACH show IN show_results %-->
|
||
|
|
<!--% show_summary(show) %-->
|
||
|
|
<!--% END %-->
|
||
|
|
</article>
|