connectSQL(); // get the rest of the info from DB $result = $myVCMS_DB->runStatement("SELECT * FROM general"); $row = mysql_fetch_assoc($result); ?> <?php echo checkEscapeDecode($row['name']); ?>  
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
Pages: 1) { ?> << >>
Controls:
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
Pages: 1) { ?> << >>
Controls:
setDie(true); ?>