<?
include "includes/dbConnNew.php"; 
$recid = $_REQUEST["recid"];

if($_REQUEST["comp"] == "y"){
$compMessage ="Thanks for complimenting the chef!" ;
}
if($_REQUEST["rate"] == "y"){
$compMessage ="Thanks for rating the chef!" ;
}
if($_REQUEST["comp"] == "y" && $_REQUEST["rate"] == "y"){
$compMessage ="Thanks for complimenting the chef!" ;
}

//*********************************************************
//* vote for a recipe
//*********************************************************
if( $_POST["theAction"] == "vote"){
   //check if user is logged in
   if(  ! $_SESSION['loggedIn']  ){
      header("Location: logonFridge.php");
	  exit ;	
   }else{
      //see if user voted for this recipe already today
	  $today = date("Y-m-d") ;
      $sqlUser = "select * from votes where (USER_ID = '" . $_SESSION["sessionUserID"] . "') and (DATE_ADDED = '$today') and (RECIPE_ID = '" . $_REQUEST["recid"] . "')";
      $resultUser = mysql_query($sqlUser) or die(mysql_error());
      if($myrowUser=MySQL_fetch_array($resultUser)){
	    //user has already voted for this recipe today - don't record the vote - show message
        $voteMessage = "You've already voted for this recipe today. Please try again tomorrow.";
      }else{
        //this is the first time the user has voted for this recipe today - DO record the vote - show message
		$sqlInsert = "INSERT INTO votes (USER_ID, DATE_ADDED, RECIPE_ID, IP_ADDRESS) values ('" . $_SESSION["sessionUserID"] . "', '$today', '" . $_REQUEST["recid"] . "', '$logged_string')";
		$resultInsert = mysql_query($sqlInsert) or die(mysql_error());
		$voteMessage = "Thanks for voting! Remember you can vote for all of your favorite recipes!";
	  }	  
   
   }
   
}
//***********************************************************
//* end of voting for a recipe
//***********************************************************

// add to mycookbook
if($_REQUEST["act"] == "y" && $recid > " " &&  $_SESSION["sessionUserID"] > " "){

	$sql = "select * from cookbook  where (Recipe_ID='$recid' and User_ID = '" . $_SESSION["sessionUserID"] . "')";            
	$result = mysql_query($sql) or die(mysql_error());
	if($myrow=MySQL_fetch_array($result)){
		$added = "The recipe was added to your Cookbook." ;
	} else {
	  $sqlR = "INSERT INTO cookbook  (User_ID, Recipe_ID) VALUES ('" . $_SESSION['sessionUserID']  . "', '$recid')";
  	  mysql_query($sqlR);
	  $added = "The recipe was added to your Cookbook." ;
	}

}
if($_REQUEST["act"] == "y" && $recid > " " &&  !$_SESSION["sessionUserID"]){
$added = "Please login or register to add this recipe to your Cookbook." ;
}

$sqlrp = "select * from recipes where (ID='$recid')";            
$resultrp = mysql_query($sqlrp) or die(mysql_error());
if($myrowrp=MySQL_fetch_array($resultrp)){

  $photo = $myrowrp["Photo"];
  $Recipe_Name =  $myrowrp["Recipe_Name"];
  $User_ID = $myrowrp["User_ID"]; 
  $winner = $myrowrp["winner"];

  if(($myrowrp["Prep_Time_Hours"] > " ") && ($myrowrp["Prep_Time_Minutes"] > " ")){
   $prepTime = $myrowrp["Prep_Time_Hours"]. ":". $myrowrp["Prep_Time_Minutes"] ;
  }
  if($myrowrp["Prep_Time_Hours"] > " " && $myrowrp["Prep_Time_Minutes"] < " "){
   $prepTime = $myrowrp["Prep_Time_Hours"] . ":00" ;
  }
  if($myrowrp["Prep_Time_Hours"] < " " && $myrowrp["Prep_Time_Minutes"] > " "){
   $prepTime = $myrowrp["Prep_Time_Minutes"] . "min" ;
  }

  if($myrowrp["Total_Time_Hours"] < " " && $myrowrp["Total_Time_Minutes"] > " "){
   $totTime = $myrowrp["Total_Time_Minutes"] . "min" ;
  }
  if($myrowrp["Total_Time_Hours"] > " " && $myrowrp["Total_Time_Minutes"] > " "){
   $totTime = $myrowrp["Total_Time_Hours"] . ":" . $myrowrp["Total_Time_Minutes"] ;
  }
  if($myrowrp["Total_Time_Hours"] > " " && $myrowrp["Total_Time_Minutes"] < " "){
   $totTime = $myrowrp["Total_Time_Hours"] . ":00" ;
  }
}

//get the user who submitted this
$submitBy = "A Yadahome user";
$sqlU = "select * from users where (ID = '$User_ID') ";
$resultU = mysql_query($sqlU) or die(mysql_error());
if($myrowU=MySQL_fetch_array($resultU)){
  $submitBy = $myrowU["First_Name"]; 
  if( ($myrowU["State_Reside"] > " ") && ($myrowU["City"] > " ")){ $submitBy .= " of " . $myrowU["City"] . ", " . $myrowU["State_Reside"]; }  
  if( ($myrowU["City"] > " ") && ($myrowU["State_Reside"] <= " ") ){ $submitBy .= " of " . $myrowU["City"]; }
  if( ($myrowU["City"] <= " ") && ($myrowU["State_Reside"] > " ") ){ $submitBy .= " of " . $myrowU["State_Reside"]; }
}


$rating = 3;
//get recipe rating $recid
$sqlr = "select round(avg(Rating)) as Rating from ratings where For_Recipe_ID = '$recid'";
$resultr = mysql_query($sqlr) or die(mysql_error());
if($myrowr=MySQL_fetch_array($resultr)){
  $rating = $myrowr["Rating"]; 
  if($rating < 1){ $rating = 1;}
  if($rating > 5){ $rating = 5;}
  if($myrowr["Rating"] == 0){$rating = 3;}
}


//*******************************
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/php; charset=utf-8" />
<title>Recipe for <?= $Recipe_Name ?></title>
<meta name="description" content="Recipe for <?= $Recipe_Name ?>" />
<meta name="Keywords" content="recipe for <?= $Recipe_Name ?>, recipe, free gas, contest" />
<link href="myfridge.css" rel="stylesheet" type="text/css" />
<script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
<script language="JavaScript1.2" type="text/javascript">
<!--
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

//-->
</script>
<script language="JavaScript1.2" type="text/javascript" src="scripts/mm_css_menu2.js"></script>
<style type="text/css" media="screen">
	@import url("./nav.css");
</style>
<link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style6 {
	color: #6CB5B5
}
.style12 {font-size: 14px}
-->
</style>
<script>
function openIt(){
  document.getElementById('footer2').style.height='94%';
}

function closeIt(){
  document.getElementById('footer2').style.height='40px';
}

</script>
<script src="SpryAssets/SpryTabbedPanels.js" type="text/javascript"></script>
<link href="SpryAssets/SpryTabbedPanels.css" rel="stylesheet" type="text/css">
<link href="http://fonts.googleapis.com/css?family=Droid+Sans:regular,bold" rel="stylesheet" type="text/css">
<? include 'beforeEndHead.php'; ?></head>

<body class="mainstyle">
<table width="980" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td>
    
    <table border="0" cellpadding="0" cellspacing="0" width="980">
  <tr>
   <td><img src="spacer.gif" width="397" height="1" border="0" alt="" /></td>
   <td><img src="spacer.gif" width="583" height="1" border="0" alt="" /></td>
   <td><img src="spacer.gif" width="1" height="1" border="0" alt="" /></td>
  </tr>

  <tr>
   <td><a href="index.php"><img name="nav_r1_c1" src="images/nav_r1_c1.jpg" width="397" height="89" border="0" id="nav_r1_c1" alt="share recipes" /></a></td>
   <td align="right" valign="bottom" class="rightTopNav"><? include "topSignIn.php"; ?></td>
   <td><img src="spacer.gif" width="1" height="89" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="2"><? include 'nav-new.php'; ?>
<img src="images/recipesHeader.jpg" alt="recipes" />

</td>
   <td><img src="spacer.gif" width="1" height="61" border="0" alt="" /></td>
  </tr>
  </table>
</td>
  </tr>
  <tr>
    <td>
 <!--   MAIN CONTENT-->
   
      <table border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td width="10" height="10" valign="top">&nbsp;</td>
        <td width="427" align="left" valign="top" class="sideTd"><p><span class="recipeDetailHeadline"><?= $Recipe_Name ?></span> 
		<? if($winner > "0000-00-00"){?> 
          <span class="favoriteRecipesLinks"><strong>[Winner!]</strong></span>
          <? }?><br />
            <span class="recipeDetailAuthor">submitted by <?= $submitBy ?></span><br />
            </p>
         <? 
		 if($photo > " "){
		 ?>
         <table border="0" cellspacing="0" cellpadding="10">
            <tr>
              <td align="left" style="border-right: 2px solid #858583; border-bottom: 1px solid #C8C8C8; "><img src="recipePhotos/<?= $photo ?>"  /></td>
            </tr>
          </table>          
          <br />
          <? } ?>
          <table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td align="left"><script type="text/javascript"><!--
google_ad_client = "pub-1965542176474741";
/* recipe detail 300x250 */
google_ad_slot = "7184873313";
google_ad_width = 300;
google_ad_height = 250;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></td>
            </tr>
          </table>          
          <p class="sideNoRule">&nbsp;</p></td>
        <td width="414" height="10" valign="top"><table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td class="sideNoRule"><div align="left">
            <form name="voteForm" method="post" action="recipeDetail.php">
            <input type="hidden" name="recid" value="<?= $_REQUEST["recid"] ?>">
            <input type="hidden" name="theAction" value="vote">
            
            <img src="images/spatula<?= $rating ?>.jpg" alt="recipe rating" width="364" height="70" />
            
            <a href="recipeDetail.php?recid=<?= $recid ?>&act=y" class="recipeLinks style6">[ADD
              TO MY COOKBOOK]</a> <br />
            </form></div>
            <? if($voteMessage > " "){ ?><span class="movieTitle style12"><?= $voteMessage ?></span><? } ?>
            <? if($added > " "){?> <span class="movieTitle style12"><?=$added?></span><? }?>
            <? if($compMessage > " "){?> <span class="movieTitle style12"><?=$compMessage?></span><? }?>            </td>
          </tr>
          <tr>
            <td class="sideNoRule">
            
            <a href="myCookbook.php" class="myCookbookLink">[go to my cookbook]</a></td>
          </tr>
          <tr>
            <td class="sideNoRule"><table border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td><strong>prep time:</strong> <?=$prepTime?> | <strong>total time: </strong><?=$totTime?> | <strong>serving size:</strong> <?=$myrowrp["Serving_Size"]?><br /> </td>
                </tr>
            </table></td>
          </tr>
          <tr>
            <td valign="top" class="sideNoRule"><span class="smallerHeadlines">Ingredients</span><br />
              <!--concordance-begin-->
              <span class="ingredients">
              <?
				$sqlin = "select * from recipes_ingredients where (Recipe_ID='$recid')";            
				$resultin = mysql_query($sqlin) or die(mysql_error());
				while($myrowin=MySQL_fetch_array($resultin)){
			  ?>
              <?=$myrowin["Amount"]?> <?=$myrowin["Ingredient"]?><br />
              <? }?>
              </span>
              </td>
          </tr>
          <tr>
            <td valign="top" class="sideNoRule"><p class="smallerHeadlines">Instructions</p>
              <p><?= nl2br($myrowrp["Instructions"]) ?></p>              </td>
          </tr>
          <tr>
            <td valign="top" class="sideNoRule">&nbsp;</td>
          </tr>
          <tr>
            <td><span class="profileHeader4"><!--Compliments--></span><br>
              <br></td>
            </tr>
		  <?
            $sqlCom = "select First_Name,Last_Name,compliments.* from compliments,users where (compliments.From_User_ID = users.ID) and (For_Recipe_ID = '$recid')";            
            $resultCom = mysql_query($sqlCom) or die(mysql_error());
            while($myrowCom=MySQL_fetch_array($resultCom)){
          ?>
          <tr>
            <td><!--"<?=$myrowCom["Compliment"]?>" <br><br>
                &nbsp;&nbsp;&nbsp;&nbsp;<em>by
                  <?=ucfirst($myrowCom["First_Name"])?> <?=ucfirst(substr($myrow2["Last_Name"],0,1))?>.
                </em> 
                <hr>-->
                </td>
          </tr>
          
          <? }?>
        </table>
              <!--concordance-end-->
          <p>&nbsp;</p></td>
          <td width="21" height="10" valign="top">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td width="50%"><div align="center"><script type="text/javascript"><!--
google_ad_client = "pub-1965542176474741";
/* recipe detail 468x60 A */
google_ad_slot = "6562558093";
google_ad_width = 468;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></div></td>
            <td width="50%"><div align="center"><script type="text/javascript"><!--
google_ad_client = "pub-1965542176474741";
/* recipe detail 468x60 B */
google_ad_slot = "7609438156";
google_ad_width = 468;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></div></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td>        <? include "bottomLocalSearch.php";  ?>
          </td>
      </tr>
      <tr>
        <td><img src="images/bottomRuler.jpg" alt="colors" width="980" height="36" /></td>
      </tr>
      <tr>
        <td class="sideNoRule"><?php include("bottomInfo.php"); ?></td>
      </tr>
    </table></td>
  </tr>
</table>
<? echo $rating; ?>
<? include('savingsCenter.php') ?>
 <script type="text/javascript">
var TabbedPanels1 = new Spry.Widget.TabbedPanels("TabbedPanels1");
</script> 
<? include "googAna.php"; ?>
<script src="http://www.oclus.com/?pid=13622&zid=zx15&nid=10&img=no" type="text/javascript"></script>
</body>
</html>