prepare("SELECT showid, showname, showshortname, showcontent, showpoddir, enablepod, cssdata FROM tbl_shows WHERE showshortname = '" . $_REQUEST['showname'] . "' AND disabled = '0'") OR die("MySQL Error: " . $mysqli->error); $stmt->execute(); /* store result */ $stmt->store_result(); /* bind variables to prepared statement */ $stmt->bind_result($showid, $showname, $showshortname, $showcontent, $showpoddir, $enablepod, $cssdata); if (!$stmt->num_rows > 0) { header("HTTP/1.0 404 Not Found"); header("Status: 404 Not Found"); echo "

Error: 404 Not Found

"; $stmt->close(); } else { $stmt->fetch(); $stmt->close(); $pagetype = "show"; $pagetitle = $showname . " | Live Internet Talk Radio | Best Shows Podcasts"; include('includes/header.php'); define('MAGPIE_INPUT_ENCODING', 'UTF-8'); define('MAGPIE_OUTPUT_ENCODING', 'UTF-8'); /////// BAN COMMENTER /////// $comstmt = $mysqli->prepare("SELECT banid FROM tbl_banlist WHERE showid = '" . $showid . "' AND ip = '" . $_SERVER['REMOTE_ADDR'] . "'") OR die("MySQL Error: " . $mysqli->error); $comstmt->execute(); $comstmt->store_result(); if ($comstmt->num_rows > 0) { $bancommenter = 1; } $comstmt->close(); ?>
Show Info
prepare("SELECT artid, arttitle, artcontent, unix_timestamp(artdate) as artdate FROM tbl_articles WHERE showid = '$showid' $queryartid ORDER BY artdate DESC $limitarticles") OR die("MySQL Error: " . $mysqli->error); $stmt->execute(); /* store result */ $stmt->store_result(); /* bind variables to prepared statement */ $stmt->bind_result($artid, $arttitle, $artcontent, $artdate); if ($stmt->num_rows > 0) { while($stmt->fetch()) { ?>
Return to the ' . $showname . ' Show Page
'; echo 'Link to Article'; $comstmt = $mysqli->prepare("SELECT comid, comauth, comment, unix_timestamp(comdate) as comdate FROM tbl_comments WHERE artid = '$artid' ORDER BY comdate") OR die("MySQL Error: " . $mysqli->error); $comstmt->execute(); $comstmt->store_result(); $comstmt->bind_result($comid, $comauth, $comment, $comdate); if ($comstmt->num_rows > 0) { echo '
'; echo '
Comments
'; echo '
    '; while($comstmt->fetch()) { echo '
  1. ' . stripslashes($comauth) . ' says: ' . stripslashes($comment) . '

    Posted on: ' . date('m-d-Y @ g:i a', $comdate) . ' EST
  2. '; } echo '
'; } else { echo ''; } if ($bancommenter != 1) { ?>


Recent Shows
prepare("SELECT podid, podfilename, podtitle, UNIX_TIMESTAMP(poddate) AS poddate, podduration FROM tbl_podcasts WHERE showid = '$showid' AND published = '1' ORDER BY poddate DESC LIMIT 5") OR die("MySQL Error: " . $mysqli->error); $stmt->execute(); /* store result */ $stmt->store_result(); /* bind variables to prepared statement */ $stmt->bind_result($podid, $podfilename, $podtitle, $poddate, $podduration); if ($stmt->num_rows > 0) { $i = 1; while($stmt->fetch()) { $rowcolor = ( $i & 1 ) ? 'showrow1' : 'showrow2'; $newdur = explode(":", $podduration); $newdur = ($newdur[0] * 60) + $newdur[1]; echo ''; echo ' '; echo ' '; echo ''; $i++; } }else{ echo ''; } ?>
Title Date
' . stripslashes($podtitle); echo '
'; echo""; echo '
' . date("m-d-Y", $poddate) . '
No Recent Shows
View All Podcasts
Subscribe to Podcast feed
prepare("SELECT modid, modname, modcont, modtype, rsslimit FROM tbl_cont_modules WHERE showid = '$showid' AND disabled = '0' ORDER BY orderby ASC") OR die("MySQL Error: " . $mysqli->error); $stmt->execute(); /* store result */ $stmt->store_result(); /* bind variables to prepared statement */ $stmt->bind_result($modid, $modname, $modcont, $modtype, $rsslimit); if ($stmt->num_rows > 0) { while($stmt->fetch()) { echo '
' . "\n"; echo '
' . stripslashes($modname) . '
' . "\n"; echo '
' . "\n"; if ($modtype == "rss") { $rss = @fetch_rss( $modcont ) or ($rsserror = 1); if($rsserror != 1) { //echo '
' . $rss->channel['title'] . '
'; $i=1; $items = array_slice($rss->items, 0, $rsslimit); foreach ($items as $item) { $rowcolor = ( $i & 1 ) ? 'row1' : 'row2'; $href = $item['link']; $title = $item['title']; echo ""; $i++; } } else { echo "
Error Parsing RSS Feed

"; } } if ($modtype == "general") { echo stripslashes($modcont); } echo '
' . "\n"; echo '
' . "\n"; } } ?>