<? include('../include/procs.php'); ?>
<?
$id = $_GET['id'];
$sid = $_GET['sid'];
$recipenumber = $_GET['recipenumber'];
$lp = 0;
if (!isset($id)) { $id = $recipenumber; };
$rn = $id;
$final = false;
do {
  $qry = mysql_query("SELECT replaced_by FROM recipe_replacements WHERE recipenumber=$rn");
  if ($row = mysql_fetch_array($qry)) {
    $rn = $row[0];
    $lp++;	
  } else {
    $final = true;	
  };
} while (($lp<10) && (!$final));	
if ($lp != 0) {
  mysql_query("UPDATE recipe_replacements SET hops=$lp,last_hopped=NOW() WHERE recipenumber=$id");
};
if (($final) && ($lp != 0)) {
  $id = $rn;
};	
if ($_SESSION["UID"] != "") { 
  mysql_query("DELETE FROM history WHERE uid=".$_SESSION["UID"]." AND value='$id' AND type='RECIPE'");
  mysql_query("INSERT INTO history (uid,session,type,value,historytime) VALUES (".$_SESSION["UID"].",'".session_id()."','RECIPE','$id',sysdate())");
  mysql_query("UPDATE user SET count_view=count_view+1 WHERE uid=".$_SESSION["UID"]);
  $qry = mysql_query("SELECT COUNT(*) FROM history WHERE uid=".$_SESSION["UID"]);
  $row = mysql_fetch_array($qry);
} else {  
  mysql_query("DELETE FROM history WHERE uid=0 AND value='$id' AND type='RECIPE'");
  mysql_query("INSERT INTO history (uid,session,type,value,historytime) VALUES (0,'".session_id()."','RECIPE','$id',sysdate())");
  $qry = mysql_query("SELECT COUNT(*) FROM history WHERE uid=0");
  $row = mysql_fetch_array($qry);
};  
mysql_query("UPDATE recipeindex SET views=views+1 WHERE id=$id");
if ($_SESSION["RECIPENUMBER"] > 0) {
  mysql_query(sprintf("INSERT INTO follow_recipe (recipeid_from,recipeid_to,follow_date) VALUES (%d,%d,NOW())",$_SESSION["RECIPENUMBER"],$id));
};  
$_SESSION["RECIPENUMBER"] = $id;
$_SESSION["SORTID"] = $sid;		

if (checkBot()) {
  include("recipe_mm.php");
} else {
  mysql_query("UPDATE statistics SET views=views+1 WHERE day=CURDATE()");
  mysql_query("UPDATE statistics_viewtime SET views=views+1 WHERE minutes=FLOOR(TIME_TO_SEC(NOW())/60)");
  switch ($_SESSION["RECIPEVIEW"]) {
    case "mealmaster" : 
      session_write_close();
      include("recipe_mm.php");
      break;
    case "cuisine" :
      session_write_close();
      include("recipe_cuisine.php");
      break;
    default        : 
      session_write_close();
      include("recipe_cuisine.php");
      break;
  };	  
};  
?>