session_start(); $dbUser = "mysql"; $dbPasswd = "sl1ce"; $dbHost = "localhost"; $DB = mysql_connect( $dbHost, $dbUser, $dbPasswd ); mysql_select_db ('atitd'); if ($_POST['calc']) { // Get yeast - specific data //if (!$_POST['yeast_id']) $yeast_id=48; // default if (!$_POST['time']) $_POST['time'] = 3600; // default $res = mysql_query("SELECT * from yeast WHERE yeast_id=" . $yeast_id); $b=array( burnt=>array("color"=>12,"vitamins"=>0,"glucose"=>0,"maltose"=>2,"barley"=>0,"tannin"=>0,"grassy"=>0,"honey"=>0), dark=>array("color"=>6,"vitamins"=>4.3,"glucose"=>2,"maltose"=>10,"barley"=>6,"tannin"=>1.5,"grassy"=>0,"honey"=>0), med=>array("color"=>3,"vitamins"=>5.7,"glucose"=>2,"maltose"=>10,"barley"=>6,"tannin"=>2,"grassy"=>0,"honey"=>0), light=>array("color"=>1.5,"vitamins"=>8.5,"glucose"=>2,"maltose"=>10,"barley"=>6,"tannin"=>3,"grassy"=>1.5,"honey"=>0), raw=>array("color"=>1,"vitamins"=>10.8,"glucose"=>1,"maltose"=>5,"barley"=>12,"tannin"=>6,"grassy"=>6,"honey"=>0), honey=>array("color"=>0,"vitamins"=>1,"glucose"=>10,"maltose"=>0,"barley"=>0,"tannin"=>0,"grassy"=>0,"honey"=>1) ); if ($yeast_id) { $flavors=array("barley","orange","banana","cherry","date","honey","nutmeg","cinnamon","tannin","grassy","nasty"); } else { $flavors=array("barley","honey","tannin","grassy"); } $total = $_SESSION["total"]; $addedIngr = $_SESSION["addedIngr"]; $tick = ceil($_POST['time']/36); foreach($b as $ingr => $data) { if ($_POST[$ingr]) { //echo "
" . $ingr . ":
";
foreach ($data as $attr => $baseValue) {
if ($attr != "vitamins" && $attr != "glucose" && $attr != "maltose" && $attr !="honey") {
$value = ($baseValue*$_POST[$ingr]) * ((1/6) + ((5/6)*($tick/100)));
} elseif ($attr == "vitamins") {
$temp = pow(((100 - $tick) / 10 ),2);
$value = ($baseValue*$_POST[$ingr])*(1+ ((3/36) * $temp));
} elseif ($attr == "honey") {
//$value = ($baseValue*$_POST[$ingr]) * ((2/3) + ((1/3)*(100/$tick)));
$value = ($baseValue*$_POST[$ingr]) * (100/(5+$tick));
} else {
$value = $baseValue * $_POST[$ingr];
}
$total[$attr] += round($value);
}
}
}
$yeast = mysql_fetch_array($res);
if ($yeast_id > 0) {
// figure alcohol
if ($yeast['max_alcohol'] < 1) $yeast['max_alcohol'] = 10000;
$glucoseToConsume=MAX(($total['glucose']-$yeast['min_glucose']),0);
$maltoseToConsume=MAX(($total['maltose']-$yeast['min_maltose']),0);
$glucose = $total['glucose'] - MIN($glucoseToConsume,$yeast['max_alcohol']);
$maltose = $total['maltose'] - MIN($maltoseToConsume,($yeast['max_alcohol']-($total['glucose']-$glucose)));
$alcohol = min($total['glucose'] - $glucose + $total['maltose'] - $maltose,$yeast['max_alcohol']) ;
// figure vitamins
$vitamins = round($total['vitamins'] - ($alcohol * $yeast['vit_consume']));
if ($vitamins < $yeast['min_vit']) {
$alcohol = round(($total['vitamins']-$yeast['min_vit'])/$yeast['vit_consume']);
$vitamins = $yeast['min_vit'];
}
} else {
$alcohol = "n/a";
$glucose = $total['glucose'];
$maltose = $total['maltose'];
}
// figure flavors
$res = mysql_query("SELECT * from yeast_flavor WHERE yeast_id=" . $yeast_id);
$flavorData = mysql_fetch_array($res);
foreach ($flavors as $flav) {
$flavor[$flav] = round(($alcohol/$flavorData[$flav])) + $total[$flav];
}
} else {
//if form hasn't yet been submitted, pull all available yeasts
$res = mysql_query("SELECT yeast_id from yeast");
}
?>