--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/php/read/updateTierLink.php	Thu Feb 16 22:29:02 2017 +0000
@@ -0,0 +1,129 @@
+<?PHP
+
+$isbn1 = strval($_GET['isbn1']);
+echo $isbn1;
+$isbn2 = strval($_GET['isbn2']);
+echo $isbn2;
+$state = strval($_GET['state']);
+echo $state;
+if (isset($_GET['userID'])) {
+  $userID=$_GET['userID'];
+ }
+$loc = strval($_GET['loc']);
+echo $loc;
+
+include "../../../private/db.php";  
+//$addState = 0;
+
+$query1 = "CALL b_getLinkID('$isbn1', '$isbn2', $loc)";  // "select LinkID from scoretable where BookID1 = '$isbn1' and BookID2 = '$isbn2' and LocID = $loc";
+//echo $query1;
+$data1 = mysqli_query($link, $query1) or exit( mysqli_error( $link ));
+mysqli_close($link);	//do not remove. reset is needed otherwise mysqli_fetch_array doesn't work after first loop
+include "../../../private/db.php"; 
+
+if ( mysqli_num_rows( $data1 ) < 1 )		//does the link exist
+{
+	if($state == 7)
+		$queryL = "CALL b_addNewSearchLink('$isbn1','$isbn2',0, $loc)";
+	else
+		$queryL = "CALL b_addNewLink('$isbn1','$isbn2',0, $loc)";
+	//echo $queryL;
+	$results = mysqli_query($link, $queryL);
+	
+	$rows=mysqli_fetch_array($results, MYSQLI_ASSOC);
+	$linkid=$rows['LinkID'];
+	
+	//reset connection
+	mysqli_close($link);	//do not remove. reset is needed otherwise mysqli_fetch_array doesn't work after first loop
+	include "../../../private/db.php"; 
+			
+	
+	//if(isset($userID))
+	//	$addState = 1;
+}
+else
+{
+	$rows=mysqli_fetch_array($data1, MYSQLI_ASSOC);
+	$linkid=$rows['LinkID'];
+}
+	
+	$query3 = "CALL b_getLinkIDLinks($linkid)";  //"select LinkID, Positive, Buy, StrongInterest, MiddleInterest, WeakInterest, SearchRel, PositiveLogIn, BuyLogIn, StrongInterestLogIn, BuyLogIn, StrongInterestLogIn, MiddleInterestLogIn, WeakInterestLogIn, SearchRelLogIn from links where LinkID = $linkid";
+	//echo $query3;
+	$data = mysqli_query($link, $query3) or exit( mysqli_error( $link ));
+	
+	//reset connection
+	mysqli_close($link);	//do not remove. reset is needed otherwise mysqli_fetch_array doesn't work after first loop
+	include "../../../private/db.php"; 
+	
+while($line = mysqli_fetch_assoc($data))
+{
+	$linkID = $line["LinkID"];
+	$pos = $line["Positive"];
+	$buy = $line["Buy"];
+	$strong = $line["StrongInterest"];
+	$middle = $line["MiddleInterest"];
+	$weak = $line["WeakInterest"];
+	$searchrel = $line["SearchRel"];
+	
+	$posLogIn = $line["PositiveLogIn"];
+	$buyLogIn = $line["BuyLogIn"];
+	$strongLogIn = $line["StrongInterestLogIn"];
+	$middleLogIn = $line["MiddleInterestLogIn"];
+	$weakLogIn = $line["WeakInterestLogIn"];
+	$searchrelLogIn = $line["SearchRelLogIn"];
+	
+	/*    
+	RECOMM = 1;
+    BUY = 2;
+    STRONG = 3;
+    WEAK = 4;
+    CONTEMPLATE = 5;
+    BROWSE = 6;
+    SEARCH = 7;*/
+
+	if(isset($userID))
+	{
+		if($state == 1)
+			$posLogIn += 1;
+		else if($state == 2)
+			$buyLogIn += 1;
+		else if ($state == 3)
+			$strongLogIn += 1;
+		else if ($state == 4)
+			$weakLogIn += 1;
+		else if ($state == 5)
+			$middleLogIn += 1;
+		else if ($state == 7)
+			$searchrelLogIn += 1;
+	}	
+	else
+	{
+		if($state == 1)
+			$pos += 1;
+		else if($state == 2)
+			$buy += 1;
+		else if ($state == 3)
+			$strong += 1;
+		else if ($state == 4)
+			$weak += 1;
+		else if ($state == 5)
+			$middle += 1;
+		else if ($state == 7)
+			$searchrel += 1;
+	}
+	
+	$updateQuery = "CALL b_increaseTierLink($linkID,$pos,$buy,$strong,$weak,$middle,$searchrel,$posLogIn,$buyLogIn,$strongLogIn,$weakLogIn,$middleLogIn,$searchrelLogIn)";
+	//echo $updateQuery;
+	$dataFinal = mysqli_query($link, $updateQuery);
+	
+	if($state == 1)
+	{
+		$stateQuery = "CALL b_insertThumbState($userID,$linkID,1)";		
+		//echo $stateQuery;
+		$stateFinal = mysqli_query($link, $stateQuery);
+	}
+}
+
+mysqli_close($link);
+
+?>