"; $User_ID_Identity= $_SESSION['Session_User_ID'] ; //echo "User_ID_Identity="; echo "$User_ID_Identity
"; function uservalidate_function_check() { include '/home/cursinu/tastingjournals.com/data/user/uservalidate.php'; return $login_check; } $login_result=uservalidate_function_check(); //echo "Login Result".$login_result; if (($_POST)) { include("/home/cursinu/cgi-bin/db/dbinfo.inc.php"); if(!$dbconnect = mysql_connect($host,$username,$password)) { echo "Connection failed to the host 'localhost'."; exit; } // if if (!mysql_select_db($database)) { echo "Cannot connect to database"; exit; } // if $result_Max_Journal_Number=0; if ($_SESSION['Session_Journal_Action']=="Update") { $User_ID_query="SELECT User_ID FROM TJ_JOURNAL where obsolete_date is null and Journal_Number=".$_POST['Journal_ID'].""; //echo $User_ID_query; $User_ID_dbresult = mysql_query($User_ID_query, $dbconnect); $User_ID_num = mysql_num_rows($User_ID_dbresult); while ($User_ID_row = mysql_fetch_array($User_ID_dbresult)) { $User_ID_Check=$User_ID_row["User_ID"]; } //echo "User_ID_Check".$User_ID_Check; //echo "User_ID_identity".$User_ID_Identity; if ($User_ID_Check==$User_ID_Identity) { $Obsolete_Journal_Query= " Update TJ_JOURNAL set obsolete_date=sysdate() where obsolete_date is null and Journal_Number=".$_POST['Journal_ID'].""; mysql_query($Obsolete_Journal_Query, $dbconnect); $result_Max_Journal_Number=$_POST['Journal_ID']; } $_SESSION['Session_Journal_Action']="N/A"; } if (!($_POST['Obsolete_Record']=="Obsolete")) { $Winery= $_POST['Winery']; //echo "Winery=";echo $Winery."
"; $WineName= $_POST['WineName']; //echo "WineName=";echo $WineName."
"; $Vintage= $_POST['Vintage']; //echo "Vintage=";echo $Vintage."
"; $Appellation= $_POST['Appellation']; //echo "Appellation=";echo $Appellation."
"; $Vineyard= $_POST['Vineyard']; //echo "Vineyard=";echo $Vineyard."
"; $Country= $_POST['Country']; $WineComposition1= $_POST['WineComposition1']; $WineComposition1Percentage= $_POST['WineComposition1Percentage']; $WineComposition2= $_POST['WineComposition2']; $WineComposition2Percentage= $_POST['WineComposition2Percentage']; $WineComposition3= $_POST['WineComposition3']; $WineComposition3Percentage= $_POST['WineComposition3Percentage']; $WineComposition4= $_POST['WineComposition4']; $WineComposition4Percentage= $_POST['WineComposition4Percentage']; $WineComposition5= $_POST['WineComposition5']; $WineComposition5Percentage= $_POST['WineComposition5Percentage']; $Aroma= $_POST['Aroma']; $Flavor= $_POST['Flavor']; $TastingNotes= $_POST['TastingNotes']; //echo "TastingNotes=";echo $TastingNotes."
"; $DateTested= $_POST['DateTested']; //echo "DateTested=";echo $DateTested."
"; $TastingOccasion= $_POST['TastingOccasion']; //echo "TastingOccasion=";echo $TastingOccasion."
"; $Location= $_POST['Location']; $Pairing= $_POST['Pairing']; $Overall= $_POST['Overall']; //echo "Overall=";echo $Overall."
"; $Balance= $_POST['Balance']; $FoodCompatibility= $_POST['FoodCompatibility']; $Appearance= $_POST['Appearance']; $Color= $_POST['Color']; $Body= $_POST['Body']; $Intensity= $_POST['Intensity']; $Acidity= $_POST['Acidity']; $Complexity= $_POST['Complexity']; $Sweetness= $_POST['Sweetness']; $Tannins= $_POST['Tannins']; $Oak= $_POST['Oak']; $Finish= $_POST['Finish']; $Flaws= $_POST['Flaws']; $Recommendation= $_POST['Recommendation']; $Price= $_POST['Price']; $FavWine= $_POST['FavWine']; //echo "FavWine=";echo $FavWine."
"; $OtherWine= $_POST['OtherWine']; //echo "OtherWine=";echo $OtherWine."
"; $JournalSave =$_POST['JournalSave']; //echo "JournalSave=";echo $JournalSave."
"; $Journal_Type =$_POST['Journal_Type']; //echo "Journal_Type=";echo $Journal_Type."
"; $WineType= $_POST['WineType']; //echo "WineType=";echo $WineType."
"; if ($WineType=="") {$WineType="None";} //echo "WineType="; echo "$WineType
"; $DateTested = dateconvert($DateTested, 1); //echo $DateTested; mysql_query($Insert_Journal_Query, $dbconnect); if ($result_Max_Journal_Number == 0){ $Max_Journal_Number_query = mysql_query("SELECT MAX(Journal_Number) FROM TJ_JOURNAL", $dbconnect); $result_Max_Journal_Number = mysql_result($Max_Journal_Number_query, 0, 0); $result_Max_Journal_Number=$result_Max_Journal_Number+1; //echo $result_Max_Journal_Number; } $Insert_Journal_Query= " Insert into TJ_JOURNAL ( User_ID, User_Login_ID, Winery_Name, Winery_ID, Wine_Name, Wine_ID, Vintage, Appellation, Vineyard, Country, Price, WineComposition1, WineComposition1Percentage, WineComposition2, WineComposition2Percentage, WineComposition3, WineComposition3Percentage, WineComposition4, WineComposition4Percentage, WineComposition5, WineComposition5Percentage, Aroma, Flavor, Tasting_Note, Tasting_Date, Tasting_Occasion, Location, Pairing, Overall, Balance, Food_Compatibility, Appearance, Color, Body, Intensity, Acidity, Complexity, Sweetness, Tannins , Oak, Finish , Flaw, Recommendation, Favorite_Wine, Other_Wine, Journal_Public_Type, Journal_Type, Wine_Type, Journal_Number,Create_Date ) values (". $User_ID_Identity.", '". $User_ID."', '". $Winery."', ". "NULL".", '". $WineName."', ". "NULL".", '". $Vintage."', '". $Appellation."', '". $Vineyard."', '". $Country."', '". $Price."', '". $WineComposition1."','". $WineComposition1Percentage."', '". $WineComposition2."', '". $WineComposition2Percentage."', '". $WineComposition3."', '". $WineComposition3Percentage."', '". $WineComposition4."', '". $WineComposition4Percentage."', '". $WineComposition5."', '". $WineComposition5Percentage."', '". $Aroma."', '". $Flavor."', '". $TastingNotes."', '". $DateTested."', '". $TastingOccasion."', '". $Location."', '". $Pairing."', ". $Overall.", ". $Balance.", ". $FoodCompatibility.", ". $Appearance.", ". $Color.", ". $Body.", ". $Intensity.", ". $Acidity.", ". $Complexity.", ". $Sweetness.", ". $Tannins.", ". $Oak.", ". $Finish.", '". $Flaws."', ". $Recommendation.", '". $FavWine."', '". $OtherWine."', '". $JournalSave ."', '". $Journal_Type."', '". $WineType."', ". $result_Max_Journal_Number.", ". "sysdate()) "; //echo $Insert_Journal_Query; mysql_query($Insert_Journal_Query, $dbconnect); } $Data_presentation="

Your TastingJournal has been saved.

"; } if (($_SESSION['Session_Login_Status']=="Logged_In")) {$sess_name="LOGGEDUSER";} else {$sess_name="NOTLOGGED"; $Data_presentation.=" "; } if ((!($login_result=="Passed")) and ($sess_name=="LOGGEDUSER")) { //echo "FAILED"; //echo "Failed Test"; //$Failed_Text=failed_login(); //$Data_presentation.= $Failed_Text; $Data_presentation.="

		Login or Register to Create your own TastingJournals!

		Your Session has expired. Please login again.
		Login Here.

"; } include("/home/cursinu/cgi-bin/db/dbinfo.inc.php"); if(!$dbconnect = mysql_connect($host,$username,$password)) { echo "Connection failed to the host 'localhost'."; exit; } // if if (!mysql_select_db($database)) { echo "Cannot connect to database"; exit; } // if $User_ID_Identity= $_SESSION['Session_User_ID'] ; //echo "User_ID_Identity="; echo "$User_ID_Identity
"; if ($login_result=="Passed") { $Data_presentation.=""; //echo "PASSED"; $Data_presentation.="

".$User_ID."'s - TastingJournals HomePage

Advanced Journal Search

"; $View_Journal_Query=" Select * from TJ_JOURNAL where obsolete_date is null and User_id=".$User_ID_Identity." order by Tasting_Date DESC"; //echo $View_Journal_Query; $dbresult_Journal = mysql_query($View_Journal_Query, $dbconnect); $num_Journal = mysql_num_rows($dbresult_Journal); while ($row = mysql_fetch_array($dbresult_Journal)) { $View_Tasting_Date=dateconvert($row["Tasting_Date"], 2); $View_Winery_Name=$row["Winery_Name"]; $View_Wine_Name=$row["Wine_Name"]; $View_Vintage=$row["Vintage"]; $View_Journal_ID=$row["Journal_ID"]; $View_Journal_Number=$row["Journal_Number"]; $View_Wine_Type=$row["Wine_Type"]; $View_Favorite_Wine=$row["Favorite_Wine"]; $View_Recommendation=$row["Recommendation"]; if ($View_Favorite_Wine=="Yes") {$Fav_Image=" "; }else{$Fav_Image="";} if ($View_Recommendation==1) {$Recommendation_Img="star1.gif";} if ($View_Recommendation==3) {$Recommendation_Img="star2.gif";} if ($View_Recommendation==5) {$Recommendation_Img="star3.gif";} if ($View_Recommendation==7) {$Recommendation_Img="star4.gif";} if ($View_Recommendation==10) {$Recommendation_Img="star5.gif";} $Fav_Image=""; $Data_presentation.=" "; } $Data_presentation.="

		Recommendation	Tasting Date	Winery	Wine Type	Wine	Vintage	View	Edit
		".$Fav_Image."	".$View_Tasting_Date."	".$View_Winery_Name."	".$View_Wine_Type."	".$View_Wine_Name."	".$View_Vintage."	select	Edit

"; } $Data_presentation.="

 

TastingJournals Community - Shared Journals

Advanced Journal Search

"; if ($login_result=="Passed") { $View_Journal_Query2=" Select * from TJ_JOURNAL where obsolete_date is null and Journal_Public_Type in ('Public', 'NotesPublic') and User_id not in (".$User_ID_Identity.") order by Tasting_Date desc LIMIT 20"; } else { $View_Journal_Query2=" Select * from TJ_JOURNAL where obsolete_date is null and Journal_Public_Type in ('Public', 'NotesPublic') order by Tasting_Date desc LIMIT 20"; } $dbresult_Journal2 = mysql_query($View_Journal_Query2, $dbconnect); $num_Journal2 = mysql_num_rows($dbresult_Journal2); while ($row2 = mysql_fetch_array($dbresult_Journal2)) { $View_Tasting_Date=dateconvert($row2["Tasting_Date"], 2); $View_Winery_Name=$row2["Winery_Name"]; $View_Wine_Name=$row2["Wine_Name"]; $View_Vintage=$row2["Vintage"]; $View_Journal_ID=$row2["Journal_ID"]; $View_Journal_Number=$row2["Journal_Number"]; $View_Wine_Type=$row2["Wine_Type"]; $View_Favorite_Wine=$row2["Favorite_Wine"]; $View_Recommendation=$row2["Recommendation"]; if ($View_Recommendation==1) {$Recommendation_Img="star1.gif";} if ($View_Recommendation==3) {$Recommendation_Img="star2.gif";} if ($View_Recommendation==5) {$Recommendation_Img="star3.gif";} if ($View_Recommendation==7) {$Recommendation_Img="star4.gif";} if ($View_Recommendation==10) {$Recommendation_Img="star5.gif";} $Fav_Image=""; $Data_presentation.=" "; } $Data_presentation.="

		Recommendation	Tasting Date	Winery	Wine Type	Wine	Vintage	View
		".$Fav_Image."	".$View_Tasting_Date."	".$View_Winery_Name."	".$View_Wine_Type."	".$View_Wine_Name."	".$View_Vintage."	select

View Additional Journals

 

 

"; ?> TastingJournals.com - TastingJournals Home Page"; ?>