<?php
include("admin/db.php");
login();
//Latest Listen
$latestresult = SelectLatestListen();
$latestcount = mysql_num_rows($latestresult);

//BOOKSHELF
$featBookShelfResult = SelectFeaturedBookshelf();
$featBookShelfCount = mysql_num_rows($featBookShelfResult);

//FAVORITE
$featFavResult = SelectTopFeaturedFavorite();
$featFavCount = mysql_num_rows($featFavResult);

//UPDATES AKA NEWS
$featNewsResult = SelectFeaturedUpdates();
$featNewsCount = mysql_num_rows($featNewsResult);

//PICTURE / IMAGE
$featPicResult = SelectTopFeaturedPictures();
$featPicCount = mysql_num_rows($featPicResult);


?>
<?
global $urlVar;
global $titleVar;
global $bodyVar;
global $durVar;

  if($latestcount > 0)
  { 
  	while($latestrow = mysql_fetch_object($latestresult))
	{
		$idVar = $latestrow->ID;
		
		$oDate = new DateTime($latestrow->Date);
		$sDate = $oDate->format("F j, Y");
		
		$date_array = explode("-", $latestrow->Date);
		$yearVar = $date_array[0];
		$monthVar = $date_array[1];
		$dayVar = $date_array[2];
		
       	$urlVar = stripslashes($latestrow->URL);
		$titleVar = stripslashes($latestrow->tbxTitle);	
    	$bodyVar = stripslashes($latestrow->Body);
		$durVar = stripslashes($latestrow->tbxDuration);	

  	}//end while
  }//end if

  ?>
<!doctype html>
<html lang="en" class="no-js">
<head>
	<title>On The Menu Podcast Featuring Ann and Peter Haigh</title>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
	<meta http-equiv="description" content="The On The Menu podcast features talk of fine dining, restaurants, travel, good food and more! Starring Ann and Peter Haigh">
	<meta name="keywords" content="fine dining,food,restaurants,food reviews,restaurant reviews,Ann Haigh,Peter Haigh,food podcast,on the menu" />
	<link href="https://fonts.googleapis.com/css?family=Oswald:300,400%7CKarla:400,700" rel="stylesheet">
	<link rel="shortcut icon" href="images/favicon.ico">
	<link rel="stylesheet" href="assets/css/bootstrap-reboot.css">
	<link rel="stylesheet" href="assets/css/bootstrap-grid.css">
	<link rel="stylesheet" href="assets/css/material-design-iconic-font.css">
	<link rel="stylesheet" href="assets/css/style.css">
	<meta name="google-site-verification" content="1Eniy_Lo2ab-2dMbT7KFWQBS2L5OOSLMWgEzvX1B0S0" />
</head>
<body class="home">
	<header id="top" class="navbar navbar-sticky">
		<div class="container">
			<div class="row align-items-center">
				<? 
				include("site-title.php");
				?>
				<? 
				include("nav.php");
				?>
				<nav id="social-links-menu" style="padding-top:10px" class="col-lg-4 col-md-auto order-4 order-md-1 order-lg-3 col-sm-12">
				  <div class="row">
				   <div class="col-lg-4 col-md-4" style="padding-bottom: 10px;">
				   
					<? 
					include("sm-top.php");
					?>
					   
					</div>
					<div class="col-lg-8 col-md-8">
					<!--START TOP PLAYER-->
		
						<p style="font-size: 14px; margin: 0px; padding-bottom:2px; text-align: center">Listen To The Latest Episode</p>
						<audio class="wp-audio-shortcode" preload="none" style="width: 100%;" controls="controls">
						<source src="<?=$urlVar;?>" type="audio/mpeg" />
						</audio>
					<!--END TOP PLAYER-->
					</div>	
				</nav>
				
			
				<div class="site-menu-toggle col-auto order-2 order-sm-3">
					<a href="#site-menu">
						<span class="screen-reader-text">Toggle navigation</span>
					</a>
				</div>
			</div>
		</div>
	</header>

	<header id="featured" class="featured-content fade-background-0 padding-top-bottom">
		<div class="container">
			<div class="row align-items-center">
				<div class="col-12 col-lg-8 col-xl-7">
					<div class="latest-episode">
						<div class="podcast-episode">
							<p class="big text-uppercase" style="color: #000; font-size:1.8rem">Latest Episode</p>
							<h1 class="entry-title"><a href="episodes.php"><?=$sDate;?>: <?=$titleVar;?></a></h1>
							<div class="podcast-episode">
								<div class="podcast-episode-player" data-episode-download="<?=$urlVar;?>" data-episode-download-button="Download Episode" data-episode-duration="<?=$durVar;?>" data-episode-size="">
									<audio class="wp-audio-shortcode" preload="none" style="width: 100%;" controls="controls">
										<source src="<?=$urlVar;?>" type="audio/mpeg" />
									</audio>
								</div>
							</div>
							<p align="center">
								<a href="https://itunes.apple.com/us/podcast/on-the-menu/id73801404?mt=2&app=podcast" class="button button-white" target="_blank"><span class="zmdi zmdi-apple"></span> iTunes</a>
								<a href="https://play.google.com/music/listen#/ps/Idq6flgzbldnlnexlncnjlwzlbu" class="button button-white" target="_blank"><span class="zmdi zmdi-google-play"></span> Google Play</a>
								<a href="https://open.spotify.com/show/27CAv84ldYorrqYLnOOGcl" class="button button-white" target="_blank"><span class="zmdi zmdi-playlist-audio"></span> Spotify</a>
								<a href="episodes.php" class="button button-white"><span class="zmdi zmdi-caret-right-circle"></span> All Episodes</a>
							</p>
						</div>
					</div>
				</div>
			</div>
		</div>
	</header>

    <div class="latest-news margin-top-bottom  padding-top-bottom">
			<div class="container">
				<h1 class="add-separator"><span><span style="color:#fff">Browse</span> <em>Our Features</em></span></h1>
				<div class="row">
					<div class="col-12 col-md-4">
						
							<!--NEWS-->
							<?php
						  if($featNewsCount > 0)
							{ 
							while($featNewsRow = mysql_fetch_object($featNewsResult))
								{
									$newsID = $featNewsRow->ID;
									$newsTitle = stripslashes($featNewsRow->Title);
									$newsDate = stripslashes($featNewsRow->Date);
									$newsBody = stripslashes($featNewsRow->Body);

								}
							}								
									
								?>
							<article class="entry entry-post">
							<header class="entry-header">
								<div class="categories">
									<span class="screen-reader-text"></span> <a href="news.php" rel="category tag">OTM News</a>
								</div>
								<h2><a href="news.php" rel="bookmark"><?=$newsTitle;?></a></h2>
								
							</header>
							<div class="entry-content">
								<h3><?=stripslashes(strip_tags(substr($newsBody, 0, 100))). "....";?> <br>
								<a href="news.php" class="read-more">MORE INFO<span class="zmdi zmdi-trending-flat"></span></a></h3>
							</div>
						</article>
							<!--END NEWS-->
					</div>
					<div class="col-12 col-md-4">
						<article class="entry entry-post">
							<header class="entry-header">
								<div class="categories">
									<span class="screen-reader-text"></span> <a href="favorites.php" rel="category tag">OTM Favorites</a>
								</div>
								
							
							
							<!--FAVORITE-->
							<?php
						  if($featFavCount > 0)
							{ 
							while($featFavRow = mysql_fetch_object($featFavResult))
								{
									$favID = $featFavRow->ID;
									$favTitle = stripslashes($featFavRow->Title);
									$favDate = stripslashes($featFavRow->Date);
									
									$favURL = stripslashes($featFavRow->URL);
									$favBody = stripslashes($featFavRow->Body);
							


								}
							}								
									
								?>
							<h2><a href="favorites.php" rel="bookmark"><?=$favTitle;?></a></h2>
							</header>
							<div class="entry-content">
								<h3><?=stripslashes(strip_tags(substr($favBody, 0, 100))). "....";?><br>
								<a href="favorites.php" class="read-more">MORE INFO<span class="zmdi zmdi-trending-flat"></span></a></h3>
							</div>
							<!--END FAVORITE-->
						</article>
					</div>
					<div class="col-12 col-md-4">
						<article class="entry entry-post">
							<header class="entry-header">
								<div class="categories">
									<span class="screen-reader-text"></span> <a href="photos.php" rel="category tag">OTM Photos</a>
								</div>
						</header>
							<!--PICTURE-->
							<?php
						  if($featPicCount > 0)
							{ 
							while($featPicRow = mysql_fetch_object($featPicResult))
								{
									$picID = $featPicRow->ID;
									$picName = stripslashes($featPicRow->ImageName);									
									$picBody = stripslashes($featPicRow->Body);
									
									$file = "./pictures/$picName"; 
									if (!is_file($file))
										$picName = "comingsoon.png";
								

								}
							}								
									
								?>
						
							<div class="entry-content">
								<img src="pictures/<?=$picName;?>" alt="" style="width:229px; height:auto;" /><br>
								<h3><a href="photos.php" class="read-more">(SEE MORE)<span class="zmdi zmdi-trending-flat"></span></a></h3>
							</div>
								<!--END PICTURE-->
						</article>
					</div>
				</div>
				
			</div>
		</div>

	<main id="content" class="padding-top-bottom">
		<div class="container">
			<div class="row">
				<div class="col-12">
					<div class="episodes-listing">
						<h1 class="add-separator"><span>OTM <em>Bookshelf</em></span></h1>
						<!--BOOKSHELF -->
						<?php
						  if($featBookShelfCount > 0)
							{ 
							while($featBookShelfRow = mysql_fetch_object($featBookShelfResult))
								{
									$fbsID = $featBookShelfRow->ID;
									$fbsTitle = stripslashes($featBookShelfRow->Title);
									$fbsAuthor = stripslashes($featBookShelfRow->Author);
									$fbsURL = stripslashes($featBookShelfRow->URL);
									$fbsExcerpt = stripslashes($featBookShelfRow->Excerpt);
									
									
									if($featBookShelfRow->ImageName != '')
										$fbsImageName = stripslashes($featBookShelfRow->ImageName);
									else
										$fbsImageName =	"bookNotAvailable.jpg";
									
									$fbsDisplayOrder = stripslashes($featBookShelfRow->DisplayOrder);
									
									
								?>
						
						<article class="entry entry-episode">
							<div class="row align-items-lg-center">
								<!--IMAGE-->
								<div class="col-12 col-md-4 col-xl-2">
									<div class="entry-media entry-image multiply-effect">
										<a href="bookshelf.php">
											<img class="first" src="images/<?=$fbsImageName;?>"  alt="">
											
										</a>
									</div>
								</div>
								<div class="col-12 col-md-8 col-xl-9">
									<header class="entry-header">
										<!--BOOKSHELF TEXT-->
										<h4 class="entry-title" style="margin-bottom:0"><a href="bookshelf.php" rel="bookmark"><?=$fbsTitle;?></a></h4>
										<p style="color:#b82619; margin-bottom:10px">by <?=$fbsAuthor;?></p>
									</header>
									<div class="entry-content">
										<br><?=$fbsExcerpt;?> <a href="bookshelf.php">(More Info)</a>
									</div>
									<div class="entry-content">
										<p><a href="bookshelf.php">[View Entire Bookshelf]</a></p>
									</div>
									
								</div>
							</div>
						</article>
						<!--END A BOOKSHELF-->
						<?
						  	}//end while
						  }//end if

						  ?>
						
					</div>
				</div>
			</div>
		</div>
		
	</main>

	<? 
		include("footer.php");
	?>

	<script src="assets/js/jquery-3.2.1.min.js"></script>
	<script src="assets/js/modernizr-custom.js"></script>
	<script src="assets/js/functions.js"></script>

	<!-- MediaElement.js files -->
	<link rel="stylesheet" id="mediaelement-css"  href="assets/mediaelement/mediaelementplayer-legacy.css">
	<link rel="stylesheet" id="wp-mediaelement-css"  href="assets/mediaelement/wp-mediaelement.css">
	<link rel="stylesheet" id="castilo-additional-mediaelement-css"  href="assets/css/mediaelement-castilo.css">
	<script src="assets/mediaelement/mediaelement-and-player.js"></script>
	<script src="assets/mediaelement/mediaelement-migrate.js"></script>
	<script src="assets/mediaelement/wp-mediaelement.js"></script>
	<script src="assets/js/mediaelement-castilo.js"></script>
	<script src="assets/js/index.js"></script>
</body>
</html>