changeset 49:a67bf725e87b

put both paths in include_path and depend on that
author Charlie Root
date Wed, 16 Jan 2019 13:42:15 -0500
parents da133c130c1d
children 99a730ffeaf6
files .user.ini ca/index.php de/index.php facebook/facebookLogin.php facebook/invite.php fr/index.php goodreads/addToGRShelf.php goodreads/bkp/callback.php goodreads/bkp/getGoodReadsShelves.php goodreads/bkp/syncGoodreadsShelves.php goodreads/bkp/working/getGoodreadsShelves.php goodreads/bkp/working/syncGoodreadsShelves.php goodreads/callback.php goodreads/getGoodreadsShelves.php goodreads/getGoodreadsShelves2.php goodreads/syncGoodreadsShelves.php index.php mq.php newsletter/newsletter_110120.php newsletter/newsletter_110301.php newsletter/newsletter_110418.php php/read/addListToMyMap.php php/read/deleteSavedList.php php/read/getAllSavedBooks.php php/read/getBookDetails.php php/read/getBrowseNodes.php php/read/getLeaderboard.php php/read/getLinkedBooks.php php/read/map/getMapISBNCirclePaths.php php/read/map/getMapRecommPaths.php php/read/map/getMapRecommendations.php php/read/map/getMapSavedBooks.php php/read/map/regenerateMyMap.php php/read/removeBookFromUserList.php php/read/saveUserList.php php/read/sendToFriend.php php/read/setThumbState.php php/read/updateLink.php php/read/updateTierLink.php twitter/twitterLogin.php uk/index.php us/index.php user/checkLogin.php user/confirmation.php user/getFBSession.php user/newLogin.php user/resetEmail.php user/resetPassword.php user/uk/checkLogin.php user/uk/confirmation.php user/uk/newLogin.php user/uk/resetEmail.php user/uk/resetPassword.php user/unsubscribe.php xml/amazonBookSearch.php xml/doAmazonRequest.php xml/getAmazonInfo.php
diffstat 57 files changed, 93 insertions(+), 93 deletions(-) [+]
line wrap: on
line diff
--- a/.user.ini	Sun Jan 06 12:46:24 2019 -0500
+++ b/.user.ini	Wed Jan 16 13:42:15 2019 -0500
@@ -1,1 +1,1 @@
-include_path = ".:/var/test:/usr/share/php"
+include_path = ".:/var/test/ywww:/var/test/private:/usr/share/php"
--- a/ca/index.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/ca/index.php	Wed Jan 16 13:42:15 2019 -0500
@@ -124,7 +124,7 @@
 				$ret = 1;
 				$countryCode = 2;
 				
-				include "../../private/db.php"; 
+				include "db.php"; 
 				$query = "CALL b_getBookInfo('$isbn', $countryCode)";
 				//echo $query;
 				$res = mysqli_query($link, $query) or exit( mysqli_error( $link ));
@@ -168,7 +168,7 @@
 				$linkedRecommended = "";
 				for($i=0;$i<sizeof($xml->isbn);$i++){
 					$linkedISBN = $xml->isbn[$i];
-					include "../../private/db.php"; 
+					include "db.php"; 
 					$query = "CALL b_getBookInfo('$linkedISBN', $countryCode)";
 					//echo $query;
 					$res = mysqli_query($link, $query) or exit( mysqli_error( $link ));
--- a/de/index.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/de/index.php	Wed Jan 16 13:42:15 2019 -0500
@@ -124,7 +124,7 @@
 				$ret = 1;
 				$countryCode = 3;
 				
-				include "../../private/db.php"; 
+				include "db.php"; 
 				$query = "CALL b_getBookInfo('$isbn', $countryCode)";
 				//echo $query;
 				$res = mysqli_query($link, $query) or exit( mysqli_error( $link ));
@@ -168,7 +168,7 @@
 				$linkedRecommended = "";
 				for($i=0;$i<sizeof($xml->isbn);$i++){
 					$linkedISBN = $xml->isbn[$i];
-					include "../../private/db.php"; 
+					include "db.php"; 
 					$query = "CALL b_getBookInfo('$linkedISBN', $countryCode)";
 					//echo $query;
 					$res = mysqli_query($link, $query) or exit( mysqli_error( $link ));
--- a/facebook/facebookLogin.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/facebook/facebookLogin.php	Wed Jan 16 13:42:15 2019 -0500
@@ -23,7 +23,7 @@
 		$uid = $facebook->getUser();
 		$me = $facebook->api('/me');
 		
-		include "../../private/db.php"; 
+		include "db.php"; 
 		$Email = $me['email'];
 		$FirstName = $me['first_name'];
 		$Surname = $me['last_name'];
@@ -43,7 +43,7 @@
 				
 				//reset connection
 				mysqli_close($link);
-				include "../../private/db.php"; 
+				include "db.php"; 
 				
 				$sql3="SELECT FirstName, Surname, DisplayName, UserID from user WHERE Email ='$Email'";
 				//echo $sql3;
--- a/facebook/invite.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/facebook/invite.php	Wed Jan 16 13:42:15 2019 -0500
@@ -35,7 +35,7 @@
 				$uid = $facebook->getUser();
 				$me = $facebook->api('/me');
 				
-				include "../../private/db.php"; 
+				include "db.php"; 
 				$Email = $me['email'];
 				$FirstName = $me['first_name'];
 				$Surname = $me['last_name'];
@@ -55,7 +55,7 @@
 						
 						//reset connection
 						mysqli_close($link);
-						include "../../private/db.php"; 
+						include "db.php"; 
 						
 						$sql3="SELECT FirstName, Surname, DisplayName, UserID from user WHERE Email ='$User'";
 						//echo $sql3;
--- a/fr/index.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/fr/index.php	Wed Jan 16 13:42:15 2019 -0500
@@ -124,7 +124,7 @@
 				$ret = 1;
 				$countryCode = 4;
 				
-				include "../../private/db.php"; 
+				include "db.php"; 
 				$query = "CALL b_getBookInfo('$isbn', $countryCode)";
 				//echo $query;
 				$res = mysqli_query($link, $query) or exit( mysqli_error( $link ));
@@ -168,7 +168,7 @@
 				$linkedRecommended = "";
 				for($i=0;$i<sizeof($xml->isbn);$i++){
 					$linkedISBN = $xml->isbn[$i];
-					include "../../private/db.php"; 
+					include "db.php"; 
 					$query = "CALL b_getBookInfo('$linkedISBN', $countryCode)";
 					//echo $query;
 					$res = mysqli_query($link, $query) or exit( mysqli_error( $link ));
--- a/goodreads/addToGRShelf.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/goodreads/addToGRShelf.php	Wed Jan 16 13:42:15 2019 -0500
@@ -6,7 +6,7 @@
 //echo $userID;
 //echo $listName;
 
-include "../../private/db.php";
+include "db.php";
 $ynrList = "CALL b_getUserSavedList($userID,\"$listName\")";
 //echo $ynrList;
 //echo $add;
--- a/goodreads/bkp/callback.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/goodreads/bkp/callback.php	Wed Jan 16 13:42:15 2019 -0500
@@ -30,7 +30,7 @@
 $userID = $_SESSION['UserID'];
 //echo $userID;
 
-include "../../private/db.php"; 
+include "db.php"; 
 $add = "CALL addGoodreadsID($userID,$grID)"; 
 $run = mysqli_query($link, $add); 
 
--- a/goodreads/bkp/getGoodReadsShelves.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/goodreads/bkp/getGoodReadsShelves.php	Wed Jan 16 13:42:15 2019 -0500
@@ -16,7 +16,7 @@
 	$ret = preg_replace("/[^[:alnum:][:punct:][:space:]]/","",$ret);
 	//echo $ret;		
 	
-	include "../../private/db.php"; 
+	include "db.php"; 
 	
 	$xml = new SimpleXMLElement(convert_utf8($ret));
 	for($i=0;$i<sizeof($xml->shelves->user_shelf);$i++){
--- a/goodreads/bkp/syncGoodreadsShelves.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/goodreads/bkp/syncGoodreadsShelves.php	Wed Jan 16 13:42:15 2019 -0500
@@ -16,7 +16,7 @@
 	$ret = preg_replace("/[^[:alnum:][:punct:][:space:]]/","",$ret);
 	//echo $ret;		
 	
-	include "../../private/db.php"; 
+	include "db.php"; 
 	
 	$shelves = array();
 	
--- a/goodreads/bkp/working/getGoodreadsShelves.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/goodreads/bkp/working/getGoodreadsShelves.php	Wed Jan 16 13:42:15 2019 -0500
@@ -36,7 +36,7 @@
 	$ret = preg_replace("/[^[:alnum:][:punct:][:space:]]/","",$ret);
 	//echo $ret;		
 	
-	include "../../private/db.php"; 
+	include "db.php"; 
 	
 	$xml = new SimpleXMLElement(convert_utf8($ret));
 	for($i=0;$i<sizeof($xml->shelves->user_shelf);$i++){
--- a/goodreads/bkp/working/syncGoodreadsShelves.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/goodreads/bkp/working/syncGoodreadsShelves.php	Wed Jan 16 13:42:15 2019 -0500
@@ -37,7 +37,7 @@
 	$ret = preg_replace("/[^[:alnum:][:punct:][:space:]]/","",$ret);
 	//echo $ret;		
 	
-	include "../../private/db.php"; 
+	include "db.php"; 
 	
 	$shelves = array();
 	
--- a/goodreads/callback.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/goodreads/callback.php	Wed Jan 16 13:42:15 2019 -0500
@@ -31,7 +31,7 @@
 $userID = $_SESSION['UserID'];
 $backLoc = "http://www.yournextread.com/" . urldecode($_SESSION['backLocation']);
 
-include "../../private/db.php";
+include "db.php";
 $add = "CALL addGoodreadsID($userID,$grID)"; 
 //echo $add;
 $run = mysqli_query($link, $add); //add the book to the list in usersave
--- a/goodreads/getGoodreadsShelves.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/goodreads/getGoodreadsShelves.php	Wed Jan 16 13:42:15 2019 -0500
@@ -36,7 +36,7 @@
 	$ret = preg_replace("/[^[:alnum:][:punct:][:space:]]/","",$ret);
 	//echo $ret;		
 	
-	include "../../private/db.php"; 
+	include "db.php"; 
 	require_once('GoodreadsAPI.php');
 	session_start();
 	$access_token = $_SESSION['access_token'];
--- a/goodreads/getGoodreadsShelves2.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/goodreads/getGoodreadsShelves2.php	Wed Jan 16 13:42:15 2019 -0500
@@ -45,7 +45,7 @@
 	$ret = preg_replace("/[^[:alnum:][:punct:][:space:]]/","",$ret);
 	echo $ret;		
 	
-	include "../../private/db.php"; 
+	include "db.php"; 
 	
 	$xml = new SimpleXMLElement(convert_utf8($ret));
 	for($i=0;$i<sizeof($xml->shelves->user_shelf);$i++){
--- a/goodreads/syncGoodreadsShelves.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/goodreads/syncGoodreadsShelves.php	Wed Jan 16 13:42:15 2019 -0500
@@ -37,7 +37,7 @@
 	$ret = preg_replace("/[^[:alnum:][:punct:][:space:]]/","",$ret);
 	//echo $ret;		
 	
-	include "../../private/db.php"; 
+	include "db.php"; 
 	
 	$shelves = array();
 	
--- a/index.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/index.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,5 +1,5 @@
 <?php
-include_once "ywww/dlog.php";
+include_once "dlog.php";
 
 if (isset($_SERVER["GEOIP_COUNTRY_CODE"])) {
 $country_code = $_SERVER["GEOIP_COUNTRY_CODE"];
--- a/mq.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/mq.php	Wed Jan 16 13:42:15 2019 -0500
@@ -9,7 +9,7 @@
   else {
     $err=mysqli_error( $link );
     mysqli_close($link);
-    include_once "ywww/dlog.php";
+    include_once "dlog.php";
     dl("query from $d failed: $q\n$err\n");
     exit($err);
   }
--- a/newsletter/newsletter_110120.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/newsletter/newsletter_110120.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,6 +1,6 @@
 <?PHP
 
-include "../../private/db.php"; 
+include "db.php"; 
 
 $myFile = "newsletterOutput";
 $fh = fopen($myFile, 'w') or die("can't open file");
--- a/newsletter/newsletter_110301.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/newsletter/newsletter_110301.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,6 +1,6 @@
 <?PHP
 
-include "../../private/db.php"; 
+include "db.php"; 
 
 $myFile = "newsletterOutput";
 $fh = fopen($myFile, 'w') or die("can't open file");
--- a/newsletter/newsletter_110418.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/newsletter/newsletter_110418.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,6 +1,6 @@
 <?PHP
 
-include "../../private/db.php"; 
+include "db.php"; 
 
 $myFile = "newsletterOutput";
 $fh = fopen($myFile, 'w') or die("can't open file");
--- a/php/read/addListToMyMap.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/addListToMyMap.php	Wed Jan 16 13:42:15 2019 -0500
@@ -5,7 +5,7 @@
 //echo $userID;
 //echo $listName;
 
-include "../../../private/db.php";
+include "db.php";
 $ynrList = "CALL b_setMap_ChangeListName($userID,\"$listName\", \"MyMap\")";
 echo $ynrList;
 $results = mysqli_query($link, $ynrList) or exit( mysqli_error( $link ));
--- a/php/read/deleteSavedList.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/deleteSavedList.php	Wed Jan 16 13:42:15 2019 -0500
@@ -3,7 +3,7 @@
 $user = $_GET['User'];
 $list = $_GET['list'];
 
-include "../../../private/db.php";
+include "db.php";
 
 $query = "CALL b_deleteSavedList($user, \"$list\")";
 echo $query;
--- a/php/read/getAllSavedBooks.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/getAllSavedBooks.php	Wed Jan 16 13:42:15 2019 -0500
@@ -2,11 +2,11 @@
 
 if(isset($ret))
 {
-	include "../../private/db.php"; 
+	include "db.php"; 
 }
 else
 {
-	include "../../../private/db.php";
+	include "db.php";
 }
 
 $savedBooks = 0;
--- a/php/read/getBookDetails.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/getBookDetails.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,7 +1,7 @@
 <?php
-include_once "ywww/dlog.php";
+include_once "dlog.php";
 
-include_once "private/web.php";
+include_once "web.php";
 function findGenre($browseNode, &$ID, &$gen)
 {
 	if($browseNode->Name == "Subjects")
@@ -61,7 +61,7 @@
 	$output .=  "<BookDetails>";
 	
 	$proceed = true;
-	include "private/db.php";
+	include "db.php";
 
 	$query = "CALL b_getBookInfo('$isbn', $loc)";
 	//select Timestamp,Title,Author,Binding,DeweyDecimal,ImageURL,SalesRank,PublicationDate,Publisher,Genre1,Genre2,Genre3 from books where ISBN = '$isbn'";
@@ -107,7 +107,7 @@
 	if($proceed == true)
 	  {
 	    include "aws_signed_request.php";
-	    include_once "ywww/xml/doAmazonRequest.php";
+	    include_once "xml/doAmazonRequest.php";
 
 	    //book does not exist already so look up all the info from browse nodes....
 
@@ -154,7 +154,7 @@
 		  dl("Caught one bd: $isbn\n");
 		  dl(print_r($out, TRUE)."\n");
 		} );
-	      include "private/db.php";
+	      include "db.php";
 	
 	      $title="";
 	      $author="";
@@ -262,7 +262,7 @@
 		$salesRank = "null";
 		
 	      mysqli_close($link);	//do not remove. reset is needed otherwise mysqli_fetch_array doesn't work after first loop
-	      include "private/db.php";
+	      include "db.php";
 		
 	      $title = strtr($title, '"', "'");	
 	      $queryInsert = "CALL b_addNewBook(\"$isbn\",\"$title\", \"$author\",\"$binding\",\"$imageURL\", $dewey, $salesRank,$pubDate,\"$publisher\",$g1,$g2,$g3,$loc)";	
--- a/php/read/getBrowseNodes.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/getBrowseNodes.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,6 +1,6 @@
 <?PHP
 
-include "../../../private/db.php";
+include "db.php";
 
 $query = "CALL b_getBrowseNodes()";
 $results = mysqli_query($link, $query) or exit( mysqli_error( $link ));
--- a/php/read/getLeaderboard.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/getLeaderboard.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,6 +1,6 @@
 <?PHP
 
-include "private/db.php";
+include "db.php";
 
 $query = "CALL b_getLeaderboard()";
 $results = my_query( $query,'gl');
--- a/php/read/getLinkedBooks.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/getLinkedBooks.php	Wed Jan 16 13:42:15 2019 -0500
@@ -25,7 +25,7 @@
 	$loc = 1;	//default location is 1
 } 
 
-include "private/db.php"; 
+include "db.php"; 
 
 if(isset($ret))
 {
--- a/php/read/map/getMapISBNCirclePaths.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/map/getMapISBNCirclePaths.php	Wed Jan 16 13:42:15 2019 -0500
@@ -26,7 +26,7 @@
 	$listName = "MyMap";	//default location is 1
 } 
 
-include "../../../../private/db.php";
+include "db.php";
 $query = "CALL b_getMapUserList('$UserID',$loc, \"$listName\")"; // this generates fixed points - 
 //echo $query;
 $results = mysqli_query($link, $query) or exit( mysqli_error( $link ));
@@ -71,7 +71,7 @@
 //$output .= "</BookList>";
 
 mysqli_close($link);
-include "../../../../private/db.php";
+include "db.php";
 
 $query = "CALL b_getMap_isbnPaths('$UserID', $loc, \"$listName\")"; // this generates fixed points - 
 //echo $query;
--- a/php/read/map/getMapRecommPaths.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/map/getMapRecommPaths.php	Wed Jan 16 13:42:15 2019 -0500
@@ -25,7 +25,7 @@
 	$listName = "MyMap";	//default map
 } 
 
-include "../../../../private/db.php";
+include "db.php";
 //need to have an if statement to catch the first time it is run and call - CALL b_setMapAuthorXYcoord
 
 //Can swicth to this call if the map is having problems
@@ -45,12 +45,12 @@
 {
 	//populate the data
 	mysqli_close($link);
-	include "../../../../private/db.php";
+	include "db.php";
 	$query1 = "CALL b_setupUserMap($UserID, $loc,\"$listName\")"; 
 	$results1 = mysqli_query($link, $query1) or exit( mysqli_error( $link ));
 	
 	mysqli_close($link);
-	include "../../../../private/db.php";
+	include "db.php";
 //	$query = "CALL b_getMap_relatedBooksNPath($UserID, $loc,\"$listName\")"; 
 	$query = "CALL b_getMap_topRelatedBNP($UserID, $loc,\"$listName\")"; 
 
--- a/php/read/map/getMapRecommendations.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/map/getMapRecommendations.php	Wed Jan 16 13:42:15 2019 -0500
@@ -28,7 +28,7 @@
 	$loc = 1;	//default location is 1
 } 
 
-include "../../../../private/db.php";
+include "db.php";
 
 $query = "CALL b_getMap_relatedBooks($user,$loc,\"$listName\")";
 //echo $query;
--- a/php/read/map/getMapSavedBooks.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/map/getMapSavedBooks.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,6 +1,6 @@
 <?PHP
 
-include "../../../../private/db.php";
+include "db.php";
 
 $savedBooks = 0;
 
--- a/php/read/map/regenerateMyMap.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/map/regenerateMyMap.php	Wed Jan 16 13:42:15 2019 -0500
@@ -14,11 +14,11 @@
 	$listName = "MyMap";	//default map
 } 
  
-	include "../../../../private/db.php";
+	include "db.php";
 	$queryDel = "CALL b_deleteUserMap($UserID, $loc,\"$listName\")"; 
 	$results1 = mysqli_query($link, $queryDel) or exit( mysqli_error( $link ));
  
-	include "../../../../private/db.php";
+	include "db.php";
 	$query1 = "CALL b_setupUserMap($UserID, $loc,\"$listName\")"; 
 	$results1 = mysqli_query($link, $query1) or exit( mysqli_error( $link ));
 	
--- a/php/read/removeBookFromUserList.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/removeBookFromUserList.php	Wed Jan 16 13:42:15 2019 -0500
@@ -2,7 +2,7 @@
 
 $ID = $_GET['SaveID'];
 
-include "../../../private/db.php";
+include "db.php";
 
 $query = "CALL b_deleteBookFromList($ID)";
 echo $query;
--- a/php/read/saveUserList.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/saveUserList.php	Wed Jan 16 13:42:15 2019 -0500
@@ -2,7 +2,7 @@
 
 if( !empty($_POST) ){
 
-	include "../../../private/db.php"; 
+	include "db.php"; 
 
 	//echo $_POST["xml"];
 	//echo print_r($_POST);
--- a/php/read/sendToFriend.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/sendToFriend.php	Wed Jan 16 13:42:15 2019 -0500
@@ -2,7 +2,7 @@
 
 if( !empty($_POST) ){
 
-	include "../../../private/db.php";  
+	include "db.php";  
 
 	//echo $_POST["xml"];
 	//echo print_r($_POST);
--- a/php/read/setThumbState.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/setThumbState.php	Wed Jan 16 13:42:15 2019 -0500
@@ -5,7 +5,7 @@
 //echo $linkList;
 
 
-include "../../../private/db.php";  
+include "db.php";  
 
 $query1 = "select * from b_thumbstate where UserID= $userID and LinkID in ($linkList) and state <> 0"; //CALL b_setThumbState($userID, $linkList)"; 
 //echo $query1;
--- a/php/read/updateLink.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/updateLink.php	Wed Jan 16 13:42:15 2019 -0500
@@ -12,7 +12,7 @@
   }
 echo $userID;
 
-include "../../../private/db.php";  
+include "db.php";  
 
 $pos = 0;
 $neg = 0;
@@ -68,7 +68,7 @@
 	echo $stateQuery;
 	
 	mysqli_close($link);	//do not remove. reset is needed otherwise mysqli_fetch_array doesn't work after first loop
-	include "../../../private/db.php"; 
+	include "db.php"; 
 	$stateFinal = mysqli_query($link, $stateQuery) or exit( mysqli_error( $link ));
 }
 
--- a/php/read/updateTierLink.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/php/read/updateTierLink.php	Wed Jan 16 13:42:15 2019 -0500
@@ -12,14 +12,14 @@
 $loc = strval($_GET['loc']);
 echo $loc;
 
-include "../../../private/db.php";  
+include "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"; 
+include "db.php"; 
 
 if ( mysqli_num_rows( $data1 ) < 1 )		//does the link exist
 {
@@ -35,7 +35,7 @@
 	
 	//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"; 
+	include "db.php"; 
 			
 	
 	//if(isset($userID))
@@ -53,7 +53,7 @@
 	
 	//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"; 
+	include "db.php"; 
 	
 while($line = mysqli_fetch_assoc($data))
 {
--- a/twitter/twitterLogin.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/twitter/twitterLogin.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,5 +1,5 @@
 <?PHP
-	include "../../private/db.php"; 
+	include "db.php"; 
 
 	include 'EpiCurl.php';
 	include 'EpiOAuth.php';
@@ -40,7 +40,7 @@
 			
 			//reset connection
 			mysqli_close($link);
-			include "../../private/db.php"; 
+			include "db.php"; 
 			
 			$sql3="SELECT FirstName, Surname, DisplayName, UserID from user WHERE Email ='$User'";
 			//echo $sql3;
--- a/uk/index.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/uk/index.php	Wed Jan 16 13:42:15 2019 -0500
@@ -124,7 +124,7 @@
 				$ret = 1;
 				$countryCode = 1;
 				
-				include "../../private/db.php"; 
+				include "db.php"; 
 				$query = "CALL b_getBookInfo('$isbn', $countryCode)";
 				//echo $query;
 				$res = mysqli_query($link, $query);
@@ -175,7 +175,7 @@
 				$linkedRecommended = "";
 				for($i=0;$i<sizeof($xml->isbn);$i++){
 					$linkedISBN = $xml->isbn[$i];
-					include "../../private/db.php"; 
+					include "db.php"; 
 					$query = "CALL b_getBookInfo('$linkedISBN', $countryCode)";
 					//echo $query;
 					$res = mysqli_query($link, $query) or exit( mysqli_error( $link ));
--- a/us/index.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/us/index.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,5 +1,5 @@
 <?PHP
-include_once "ywww/dlog.php";
+include_once "dlog.php";
 
 session_start();
 
@@ -15,7 +15,7 @@
 		return $return;
 	}
   
-	include "ywww/mdetect.php";
+	include "mdetect.php";
 	$uagent_obj = new uagent_info();
 	$iPhone = $uagent_obj->DetectSmartphone();
 	$iPad = $uagent_obj->DetectIpad();
@@ -30,7 +30,7 @@
 		if($pos !== false || isset($_GET['facebook']))
 		{
 			//we are in facebook canvas so react appropriately
-			include_once 'ywww/facebook.php';
+			include_once 'facebook.php';
 
 			$facebook = new Facebook(array(
 				'appId'  => '128245333876633',
@@ -100,7 +100,7 @@
 				
 				$ret = 1;													
 								
-				$bookLists = include "ywww/php/read/getAllSavedBooks.php"; 			
+				$bookLists = include "php/read/getAllSavedBooks.php"; 			
 				$xml = new SimpleXMLElement($bookLists);
 				
 				$numOfLists = sizeof($xml->List) - 1;	//-1 for zero indexing 
@@ -126,12 +126,12 @@
 				$ret = 1;
 				$countryCode = 0;
 				
-				include "private/db.php"; 
+				include "db.php"; 
 				$query = "CALL b_getBookInfo('$isbn', $countryCode)";
 				//echo $query;
 				$res = mysqli_query($link, $query) or exit( mysqli_error( $link ));
-				include "ywww/xml/aws_signed_request.php";
-				include "ywww/xml/getAmazonInfo.php";
+				include "xml/aws_signed_request.php";
+				include "xml/getAmazonInfo.php";
 				if ( mysqli_num_rows( $res ) > 0 )
 				{
 					$rows=mysqli_fetch_array($res, MYSQLI_ASSOC);		
@@ -179,7 +179,7 @@
 					}
 				}
 
-				$linkedBooks = include "ywww/php/read/getLinkedBooks.php";
+				$linkedBooks = include "php/read/getLinkedBooks.php";
 				try {
 				$xml = new SimpleXMLElement($linkedBooks);
 				}
@@ -191,7 +191,7 @@
 				$linkedRecommended = "";
 				for($i=0;$i<sizeof($xml->isbn);$i++){
 				  $linkedISBN = $xml->isbn[$i];
-				  include "private/db.php"; 
+				  include "db.php"; 
 				  $query = "CALL b_getBookInfo('$linkedISBN', $countryCode)";
 				  //echo $query;
 				  $res = mysqli_query($link, $query) or exit( mysqli_error( $link ));
--- a/user/checkLogin.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/user/checkLogin.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,7 +1,7 @@
 <?php
 require "PasswordHash.php";
 
-include "../../private/db.php"; 
+include "db.php"; 
 
 // emailname and password sent from form
 $email=$_GET['email'];
--- a/user/confirmation.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/user/confirmation.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,5 +1,5 @@
 <?PHP
-include "../../private/db.php"; 
+include "db.php"; 
 
 
 // Passkey that got from link
@@ -59,7 +59,7 @@
 	mysqli_close($link);
 	$sql3="DELETE FROM $tbl_name1 WHERE confirm_code = '$passkey'";
 	//echo $sql3;
-	include "../../private/db.php"; 	//need to reinclude otherwise an error is thrown
+	include "db.php"; 	//need to reinclude otherwise an error is thrown
 	$result3=mysqli_query($link,$sql3);
 	mysqli_close($link);
 
--- a/user/getFBSession.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/user/getFBSession.php	Wed Jan 16 13:42:15 2019 -0500
@@ -18,7 +18,7 @@
 		$uid = $facebook->getUser();
 		$me = $facebook->api('/me');
 		
-		include "../../private/db.php"; 
+		include "db.php"; 
 		$Email = $me['email'];
 		$FirstName = $me['first_name'];
 		$Surname = $me['last_name'];
@@ -41,7 +41,7 @@
 				
 				//reset connection
 				mysqli_close($link);
-				include "../../private/db.php"; 
+				include "db.php"; 
 				
 				$sql3="SELECT FirstName, Surname, DisplayName, u.UserID, ReceiveEmail, GoodreadsState, LocID
 						from user u, userpref p 
--- a/user/newLogin.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/user/newLogin.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,7 +1,7 @@
 <?php
 require "PasswordHash.php";
 
-include "../../private/db.php"; 
+include "db.php"; 
 
 // emailname and password sent from form
 $email=$_GET['email'];
--- a/user/resetEmail.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/user/resetEmail.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,6 +1,6 @@
 <?php
 require "PasswordHash.php";
-include "../../private/db.php"; 
+include "db.php"; 
 
 // emailname and password sent from form
 $userID=$_GET['userID'];
--- a/user/resetPassword.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/user/resetPassword.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,7 +1,7 @@
 <?php
 require "PasswordHash.php";
 
-include "../../private/db.php";  
+include "db.php";  
 include "passGen.php";
 
 // emailname and password sent from form
--- a/user/uk/checkLogin.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/user/uk/checkLogin.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,7 +1,7 @@
 <?php
 require "PasswordHash.php";
 
-include "../../private/db.php";  
+include "db.php";  
 
 // emailname and password sent from form
 $email=$_GET['email'];
--- a/user/uk/confirmation.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/user/uk/confirmation.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,5 +1,5 @@
 <?PHP
-include "../../private/db.php";  
+include "db.php";  
 
 
 // Passkey that got from link
--- a/user/uk/newLogin.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/user/uk/newLogin.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,7 +1,7 @@
 <?php
 require "PasswordHash.php";
 
-include "../../private/db.php";  
+include "db.php";  
 
 // emailname and password sent from form
 $email=$_GET['email'];
--- a/user/uk/resetEmail.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/user/uk/resetEmail.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,6 +1,6 @@
 <?php
 require "PasswordHash.php";
-include "../../private/db.php";  
+include "db.php";  
 
 // emailname and password sent from form
 $userID=$_GET['userID'];
--- a/user/uk/resetPassword.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/user/uk/resetPassword.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,7 +1,7 @@
 <?php
 require "PasswordHash.php";
 
-include "../../private/db.php";  
+include "db.php";  
 include "passGen.php";
 
 // emailname and password sent from form
--- a/user/unsubscribe.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/user/unsubscribe.php	Wed Jan 16 13:42:15 2019 -0500
@@ -2,7 +2,7 @@
 
 $email = strval($_GET['email']);
 
-include "../../private/db.php";  
+include "db.php";  
 
 $query = "update userpref set ReceiveEmail = 0 where UserID in (select UserID from user where Email = '$email') ";
 $results = mysqli_query($link, $query);
--- a/xml/amazonBookSearch.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/xml/amazonBookSearch.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,8 +1,8 @@
 <?php
 
-include_once "ywww/dlog.php";
+include_once "dlog.php";
 
-include_once "ywww/xml/doAmazonRequest.php";
+include_once "xml/doAmazonRequest.php";
 
 $Adefault=array(
   'language'           =>'en',           //what language to render the page in
--- a/xml/doAmazonRequest.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/xml/doAmazonRequest.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,7 +1,7 @@
 <?php
-include_once "ywww/dlog.php";
+include_once "dlog.php";
 
-include_once "private/web.php";
+include_once "web.php";
 include "aws_signed_request.php";  
 
 function doAmazonRequest($ext, $parameters, $try, $dbl='x', $wantXML=True)
--- a/xml/getAmazonInfo.php	Sun Jan 06 12:46:24 2019 -0500
+++ b/xml/getAmazonInfo.php	Wed Jan 16 13:42:15 2019 -0500
@@ -1,5 +1,5 @@
 <?php
-include_once "ywww/dlog.php";
+include_once "dlog.php";
 include_once "doAmazonRequest.php";
 
 function getAmazonDet($isbn,$go,$localeIn)
@@ -251,7 +251,7 @@
       }
       $queryG = "CALL b_addBrowseNode($key,\"$value\")";	//add the name value pair for genre to new table	
       //echo $queryG;
-      include "private/db.php";
+      include "db.php";
       $resG = my_query($queryG,'gai0');
       mysqli_close($link);
 				
@@ -275,7 +275,7 @@
 			
     if($title != "")
       {
-	include "private/db.php";
+	include "db.php";
 	if ($publisher->count()==0) {
 	  $publisher="null";
 	}
@@ -330,7 +330,7 @@
 {
   global $output;
   //look up info from db	
-  include "private/db.php"; 
+  include "db.php"; 
   $query = "CALL b_getBookInfo('$searchparameterdata', $loc)";
   //echo $query;
   $res = my_query($query,'gai3');