setDie(false);
$sql = "select count(*) from podcasts where xmlonly=false and pubdate <= now()";
$result = $myVCMS_DB->runStatement($sql);
if (!$result)
{
// some error, don't process
}
else if (!is_resource($result))
{
// some error, don't process
}
else if (mysql_num_rows($result) <= 0)
{
// some error, don't process
}
else
{
$row = mysql_fetch_array($result);
$total = $row[0];
}
if (isset($_REQUEST['submitForm']))
{
// get the values passed in
$p = $_REQUEST['P'];
$s = $_REQUEST['S'];
$limit = $_REQUEST['L'];
if ($_REQUEST['submitForm'] == "list1")
{
$s = '1';
}
elseif ($_REQUEST['submitForm'] == "list2")
{
$s = '2';
}
elseif ($_REQUEST['submitForm'] == "limit")
{
// reset to page 1
$p = '1';
}
else;
}
else
{
// get the values passed in
$p = isset($_REQUEST['P']) ? $_REQUEST['P'] : '1';
$s = isset($_REQUEST['S']) ? $_REQUEST['S'] : '1';
$limit = isset($_REQUEST['L']) ? $_REQUEST['L'] : 10;
}
// get start episodes for this page
$skip = $limit * ($p - 1);
// get total pages
if ($limit <= 0) $limit = $total;
$totalPages = ($total/$limit);
if ((($total%$limit)/$limit) > 0)
{
$totalPages -= (($total%$limit)/$limit);
$totalPages++;
}
$p = mysql_real_escape_string($p);
$limit = mysql_real_escape_string($limit);
$s = mysql_real_escape_string($s);
// check for custom fields
$customCount;
$customTitles;
$customTypes;
$customValues;
getCustomFields();
for($i=0; $i<$customCount; $i++)
{
$customValues[$i] = "";
}
// clear values
$url = "";
$eurl = "";
$pubdate = "";
$title = "";
$sub = "";
$short = "";
$full = "";
$sid = "";
$restricted = "";
$explicit = "";
$month = "";
$day = "";
$year = "";
$hh = "";
$mm = "";
$ss = "";
$cover = "";
$photos = "";
$userTitle = "";
$userValue = "";
$picture = '';
$forum = '';
$author = '';
$authorpic = '';
$az = '';
$azi = '';
$sdesc = "";
$spic = "";
// get podcast data from database
$sql = "select * from podcasts where xmlonly=false and pubdate <= now() order by pubdate desc limit $skip, $limit";
$result = $myVCMS_DB->runStatement($sql);
if (!$result)
{
// no data
}
else if (!is_resource($result))
{
// no data
}
else
{
?>
ARCHIVES
runStatement("SELECT * FROM series WHERE id = $sid");
if (!$result2)
{
// no data
}
else if (!is_resource($result2))
{
// no data
}
else
{
// get the returned data and process it
$row = mysql_fetch_assoc($result2);
$spic = checkEscapeDecode($row['image']);
}
// get image data from database
$result2 = $myVCMS_DB->runStatement("SELECT * FROM podcast_images WHERE pid = $id");
if (!$result2)
{
// no data
}
else if (!is_resource($result2))
{
// no data
}
else
{
// get the returned data and process it
$row = mysql_fetch_assoc($result2);
$cover = checkEscapeDecode($row['cover']);
}
// determine cover image (check order: cover, series, default)
$book = "";
if (trim($cover) != "")
{
// cover
$book = $cover;
}
else if (trim($spic) != "")
{
// series
$book = $spic;
}
else
{
// default
$book = "./images/common/dftCover.jpg";
}
// write out some data
?>
|
|
Play Now
|
setDie(true);
?>