<?php 
// By Jim Miotke
// April 2024

// show the photo 
require '../../_system_info.php';  
require '../../_dbconnect.php';  
require '../_functions.php';

$seoTitle = "Beautiful Photo - BetterPhoto IS Photo Courses, Contests, and Websites";
$seoMetaDescription = "Look at this photo! Check out the contest winners to see inspiring photography; check out our courses to learn how to make your own beautiful photos.";

if (isset($_GET['photoID'])) {
  $photoID=$_GET['photoID'];
  if (is_numeric($photoID)) {

    // echo "it's a number";
    $FindCats = "SELECT photoID, photoTitle, photoDescription FROM Photos WHERE photoID = ".$photoID;
    $stmt = $conn->prepare($FindCats);
    $stmt->execute();
    $subcatphotos = mysqli_fetch_assoc($stmt->get_result());

    if($subcatphotos){
      $photoID = $subcatphotos['photoID'];
      $photoTitle = $subcatphotos['photoTitle'];
      $photoDescription = $subcatphotos['photoDescription'];
      $photoDescription = str_replace(" i "," I ",str_replace("& ","and ",str_replace("\n","",str_replace("\r","",str_replace("\r\n","",str_replace("\r\n\r\n","",str_replace("'","&#39;",str_replace("|","",$photoDescription))))))));

      if (!empty($photoTitle)) {
        $seoTitle = "Inspiring Photo: " . $photoTitle . " #" . $photoID;
        $seoMetaDescription = $photoTitle . " ";
      } else {
        $seoTitle = "Inspiring Photo at BetterPhoto: Untitled Photograph #" . $photoID;
      }
      if (strlen($seoTitle) > 65) {
        $seoTitle = left($seoTitle,62) . "...";
      }
      if (!empty($photoDescription)) {
        $seoMetaDescription .= "- Photographer's Description: " . $photoDescription;
      } else {
        $seoMetaDescription .= "- See this inspiring, creative photo curated by the editors at BetterPhoto. Photo #" . $photoID;
      }
    }

  } else {
    header("Location: /gallery.php");
    exit();
  } 
}

require '/var/www/html/betterphoto.fun/public_html/_mailerThatWorks.php';
require '../incHeadWithoutRequired.php'; 

// we use for nextPhoto button
$justPhotoID=0;


$mem4show = $_GET['mem4show'] ?? ''; // if they want to see photos in their fav categories
$mem4gall = $_GET['mem4gall'] ?? ''; // if they only want to see their own photos
$mem4Wins = $_GET['mem4Wins'] ?? '';
$contestCatID = $_GET['contestCatID'] ?? '';
$camID = $_GET['camID'] ?? '';
$catID = $_GET['catID'] ?? '';
if (empty($catID)) {
  $catID = $_GET['galleryID'] ?? '';  
}
$FavMemID = $_GET['FavMemID'] ?? '';
$Favpt = $_GET['Favpt'] ?? '';
$sortBye = $_GET['sortBye'] ?? ''; 

$cn = $_GET['cn'] ?? ''; 

$courseID = $_GET['courseID'] ?? '';
if (!empty($courseID)) {
  // do a double check on courseID
  $q="SELECT courseID FROM CoursesMemberCross WHERE memberID = " . $memAuth . " AND courseID = " . $courseID;
  $datacchk = mysqli_query($conn, $q);
  $tCountcchk=mysqli_num_rows($datacchk); 
  if ($tCountcchk == 0) {
    // not a real course student
    $courseID = '';
  }
}


$critiquePrefGrow1 = $_GET['critiquePrefGrow1'] ?? '';
if (empty($critiquePrefGrow1)) {
  // do a double check on critiquePref
  $q="SELECT critiquePrefGrow FROM Members WHERE memberID = " . $memAuth;
  $datacchkCQ = mysqli_query($conn, $q);
  $tCountcchkCQ=mysqli_num_rows($datacchkCQ); 
  if ($tCountcchkCQ == 1) {
    // wants it straight
    $critiquePrefGrow1 = 'GROW';
  } else {
    $critiquePrefGrow1 = 'LOVE';
  }
}

// for going back to right page in category when they go back
$start = $_GET['s'] ?? '';
// for finding prev and next 
$rowNumber = $_GET['rowNumber'] ?? '';
$rowsPerPage = $_GET['rowsPerPage'] ?? '';
//??
$memberGall = $_GET['memberGall'] ?? ''; 

if ($mem4gall == "" && $mem4Wins == "" && $mem4show == "" && $contestCatID == "" && $camID == "" && ($catID == "" || $catID == "FAV") && $Favpt == "" && $sortBye == "") {
  $justPhotoID=1;
}

//now that we've passed the JustOnePhoto gate, reset some things
if ($sortBye == "") {
  $sortBye="New";
}
//$sortBye=strtoupper($sortBye);  WHY WAS THIS HERE

// for prev and next photo buttons
if ($sortBye == "Love") {
  // works only when photoScore is in the first part of the SQL SELECT
  $sqlOrderBy = "n.photoScore";    
//} elseif $sortBye == "NEWPIX"     && $mem4gall = "0") {     same as above but NOT personal
// NEWEST UPLOADS
} elseif ($sortBye == "New") { 
  $sqlOrderBy = "p.dateCreated";// same as by photoID 
// default to MOST RECENTLY CATEGORIZED
} else {         
  // sorting by new categorized,   SAME AS $sortBye == "New" ???
  // works only when photoScore is in the first part of the SQL SELECT
  $sqlOrderBy = "pcc.dateCreated";    
}

if ($mem4gall == "") {
  $mem4gall="0";
}

if (!empty($catID) && is_numeric($catID) == false) {
  header("Location: /galleryTOCDynoSub.php?cat=541");
  exit();
}
$originURL=$_SERVER['SCRIPT_NAME']."?".$_SERVER['QUERY_STRING'];
if (strpos($originURL,"/photocourses/") > 0) {
  $photoCatID=str_replace("https://www.BetterPhoto.com/photocourses/","",strtolower($originURL));
  if (_instr(0,$photoCatID,"/",0) > 0) {
    $photoCatID=substr($photoCatID,0,(_instr(0,$photoCatID,"/",0)-1));
  }
  /*
  if (is_numeric($photoCatID) == true) {
    header("Location: /photocourses/".$photoCatID."/gallDetail.php?photoID=".$photoID);
    exit();
  }
  */
}

// FUNCTIONS 
function sb_MemberFavoritePhotographer($conn, $memberID, $favPhotographerID) {
  // sp_CheckExistenceOfMemberFavPhotographerByMemberID           member likes favPhotog
  $q="SELECT favID FROM PhotographerFavorites WHERE favPhotographerID = " . $favPhotographerID . " AND memberID = " . $memberID; 
  $data = mysqli_query($conn, $q);
  $tCount=mysqli_num_rows($data); 
  if ($tCount == 0) {
    // not a favorite photographer yet, show add link
    echo "<br /><img src='/images/icon_camera.gif' alt='Follow this photographer' border=0 align=middle>&nbsp;&nbsp;";
    echo "<a href='/faver-photoSQL.php?ai=2&id=" . $favPhotographerID . "&courseID=" . $courseID . "' title='Follow this photographer'>Follow this photographer</a>";
  } else {
    // already a favorite, show remove link
    while($ImageSet = mysqli_fetch_assoc($data)) {
      $favID = $ImageSet['favID'];
    }
    echo "<br /><img src='/images/icon_favs.gif' alt='Stop following this photographer' border=0 align=middle>&nbsp;&nbsp;";
    echo "<a href='/faver-photoSQL.php?ai=4&id=" . $favID . "&courseID=" . $courseID . "' title='Stop following this photographer'>Stop followin'</a>";
  }
}

function sb_link2SendPrivateMemberMessage($memberID) {
  echo "<br /><img src='/images/icon_email.gif' alt='Send message to member' border=0 align=middle>&nbsp;";
  echo "<a href='/a_26MessageCreate.php?id=" . $memberID . "' title='Send a message to this member' class=tinyText>Send a Message</a>";
}


?>  
<script language=JavaScript>
<!--

//Disable right mouse click Script
//By Maximus (maximus@nsimail.com) w/ mods by DynamicDrive
//For full source code, visit http://www.dynamicdrive.com

var message="Photos and other materials at this Web site are protected by copyright law. Please contact the photographer with questions regarding image use.";

///////////////////////////////////
function clickIE4(){
if (event.button==2){
alert(message);
return false;
}
}

function clickNS4(e){
if (document.layers||document.getElementById&&!document.all){
if (e.which==2||e.which==3){
alert(message);
return false;
}
}
}

if (document.layers){
document.captureEvents(Event.MOUSEDOWN);
document.onmousedown=clickNS4;
}
else if (document.all&&!document.getElementById){
document.onmousedown=clickIE4;
}

document.oncontextmenu=new Function("alert(message);return false")

// --> 
</script>


<script src="https://www.google.com/recaptcha/api.js?render=6LfwevEUAAAAAKGfAyL6rbG_t_utsjYw7hvDQluk"></script>
<script>
function getReCaptcha(){
  grecaptcha.ready(function() {
      grecaptcha.execute('6LfwevEUAAAAAKGfAyL6rbG_t_utsjYw7hvDQluk', {action: 'discussion'}).then(function(token) {
          var recaptchaResponse = document.getElementById('recaptchaResponse');
          recaptchaResponse.value = token;
      });
  });
}

getReCaptcha();  // This is the initial call
setInterval(function(){getReCaptcha();}, 60000);
</script>


<script src="/js/countdown.js" type="text/javascript"></script>

</header><!-- Header Ends -->

<?php 
require '../incHprofile.php'; ?>

<?php
// here for second time
if($_SERVER['REQUEST_METHOD'] == 'POST') {

  $baseline_score = 0.5; // Set your initial score threshold

  $referrerURL = $_POST['referrerURL'] ?? ''; 
  $input = $_POST['input'] ?? '';
  $topic = $_POST['topic'] ?? '';
  $memberID = $_POST['memberID'] ?? '';

  $courseID = $_POST['courseID'] ?? '';

  $identityInfo = substr("*DiscussAddSQL*".$_SERVER['HTTP_HOST']." *** ".$_SERVER['HTTP_USER_AGENT'],0,150);

  $threadID = $_POST['threadID'] ?? '';
  $photoID = $_POST['photoID'] ?? '';

  $inputType = $_POST['inputType'] ?? '';
  $notifyMemberInTheFuture = $_POST['notifyMemberInTheFuture'] ?? 'No';

  $firstNameOrig = $_POST['firstNameOrig'] ?? '';
  $emailOrig = $_POST['emailOrig'] ?? '';
  $notifyDiscOrig = $_POST['notifyDiscOrig'] ?? '';

  // for photo discussions that get email notifications
  $notifyPh = $_POST['notifyPh'] ?? '';
  $emailPh = $_POST['emailPh'] ?? '';
  $firstNamePh = $_POST['firstNamePh'] ?? '';
  $memberNamePh = $_POST['memberNamePh'] ?? '';

  // for return querystring
  $catID = $_POST['catID'] ?? '';
  $contestCatID = $_POST['contestCatID'] ?? '';
  $camID = $_POST['camID'] ?? '';
  $mem4gall = $_POST['mem4gall'] ?? '';
  $mem4show = $_POST['mem4show'] ?? '';
  $sortBye = $_POST['sortBye'] ?? '';
  $FavMemID = $_POST['FavMemID'] ?? '';
  $Favpt = $_POST['Favpt'] ?? '';
  $mem4Wins = $_POST['mem4Wins'] ?? '';
  $start = $_POST['start'] ?? '';
  // for finding prev and next 
  $rowNumber = $_POST['rowNumber'] ?? '';
  $rowsPerPage = $_POST['rowsPerPage'] ?? '';

  $errors = array();

  // do recaptcha only if not in a course, in the public
  if (isset($_POST['recaptcha_response']) && empty($courseID)) {
    // Build POST request:
    $recaptcha_url = 'https://www.google.com/recaptcha/api/siteverify';
    $recaptcha_secret = '6LfwevEUAAAAAJ9OCCOfB_Jq27t9M2i3dTuJEaa1';
    $recaptcha_response = $_POST['recaptcha_response'];

    // Make and decode POST request:
    $recaptcha = file_get_contents($recaptcha_url . '?secret=' . $recaptcha_secret . '&response=' . $recaptcha_response);
    $recaptcha = json_decode($recaptcha);

    
    if (isset($memberID)) {
      // Query to check if memberID is in the MembersWhitelisted table
      $query = "SELECT 1 FROM MembersWhitelisted WHERE memberID = ?";
      $stmt = $conn->prepare($query);
      $stmt->bind_param("i", $memberID);
      $stmt->execute();
      $stmt->store_result();

      if ($stmt->num_rows > 0) {
          // Member is whitelisted, adjust the baseline score
          $baseline_score = 0.1; // or any value you deem appropriate for bypassing reCAPTCHA
      } else {
          // Proceed with the regular reCAPTCHA validation
          if ($recaptcha->score < 0.5 && $memberID <= 540331) {
            // The score is lower but the member is a long-time user (low memberID), accept
              $baseline_score = 0.3;
          }
      }

      // Continue with the rest of your logic
      $stmt->close();
    }

    // Take action based on the score returned:
    if ($recaptcha->score >= $baseline_score) {

      // successful recaptcha
      
      // check for errors
      if (empty($input)) {
        $errors[] = "No discussion input.";
      // input too long
      } elseif (strlen($input) > 3000) {
        $errors[] = "Discussion input too long.";
      }

    } else {
      // What happens when the CAPTCHA failed
      
      // notify
      $toAddress = "jim.miotke@gmail.com";
      $toName = "BetterPhoto Owner";
      $subject = "Photo Detail RecapthaFailed score=".$recaptcha->score ." baseline=".$baseline_score;

      $str = "A reCAPTCHA failure occurred.\n";
      $str .= "Member ID: " . $memberID . "\n";
      $str .= "User IP: " . $_SERVER['REMOTE_ADDR'] . "\n";
      $str .= "Date and Time: " . date("Y-m-d H:i:s") . "\n";
      $str .= "Score: " . $recaptcha->score . "\n";
      $str .= "Baseline Score: ".$baseline_score;
      mailerThatRocks($toAddress, $subject, $str, $toName);

      $errors[] = "<br>&nbsp;<br>The reCAPTCHA failed. Rest assured, Team BetterPhoto has been notified. Error code: " . $baseline_score . " This sometimes happens when you're on the page for more than 2 minutes before posting. Other times, it has to do with privacy settings on your browser. One solution: next time, write your comment somewhere else (such as the URL field above), select & copy what you write, paste your comment into the discussion, and click 'Send' button. Then, if it fails, you can go back and try to paste it in again. Thanks for your patience. ";
    } 
  } elseif (empty($courseID)) {
    // no posted recaptcha
    $errors[] = "No reCAPTCHA posted.";
  }

  if (empty($errors)) {

//echo "<p>TEST";
    // clean out the weird characters  use html entities or similar??? 
    $memberID = mysqli_real_escape_string($conn, $memberID);
    $threadID = mysqli_real_escape_string($conn, $threadID);
    $topic = mysqli_real_escape_string($conn, $topic);
    $input = mysqli_real_escape_string($conn, $input);
    $notifyMemberInTheFuture = mysqli_real_escape_string($conn, $notifyMemberInTheFuture);
    $photoID = mysqli_real_escape_string($conn, $photoID);

    if (strpos(strtolower($topic),"betterphoto.") === FALSE) { 
      $topic = str_replace("http", "", str_replace("https", "", str_replace(">", "", str_replace("<a ", "", str_replace("href","", $topic)))));
    }
    if (strpos(strtolower($input),"betterphoto.") === FALSE) { 
      $input = str_replace("http", "", str_replace("https", "", str_replace(">", "", str_replace("<a ", "", str_replace("href","", $input)))));
    }
    /* 
    $topic = str_replace('"">','>',str_replace('""','',str_replace(",","&#39;",$topic)))   Replace(Replace(Replace("<a href=""","<a href="),"|",""),"'","")
    input= Replace(Replace(Replace(Replace(Replace(Replace(input," i "," I "),"& ","&amp; "),vbCrLf . vbCrLf,"<p>"),vbCrLf,"<br>"),"|",""),"'","&#39;")s
    input = Replace(Replace(input,"</b>",""),"<b>","")
    input = Replace(Replace(input,"http://lsqrd.blogspot.com/",""),"blogspot","")
    input = Replace(Replace(input,"<font color=""#195CB7""><b>",""),"<b><font color=gray><br>","")
    */

    if (empty($courseID)) { // a regular discussion 

      if ($inputType == "additionalComment") {
        // insert discussion response
        // sp_InsertDiscussionResponse    memberID //  The Judges 121519          
        $q="INSERT INTO DiscussionResponses (memberID, inputMemo, identityInfo, threadID, notifyMember) VALUES (" . $memberID . ", '" . $input . "', '" . $identityInfo . "', " . $threadID . ", '" . $notifyMemberInTheFuture . "')";
        $dataI = mysqli_query($conn, $q);
        
      } else {
        // insert discussion
        $q="INSERT INTO Discussions (memberID, topic, inputMemo, identityInfo, hasPhotos, notifyMember, dateModified) VALUES (" . $memberID . ", '" . $topic . "', '" . $input . "', '" . $identityInfo . "', 'Yes', '" . $notifyMemberInTheFuture . "', '" . date('Y-m-d H:i:s') . "')";
        $dataI = mysqli_query($conn, $q);
      }


      // Now get the threadID or inputID for the item just inserted, used to stamp photos
      if ($inputType == "additionalComment") {
        $SQLTHREADID="SELECT threadID FROM DiscussionResponses ORDER BY inputID DESC LIMIT 1";
      } else {
        $SQLTHREADID="SELECT MAX(threadID) AS threadID FROM Discussions";
      }
      if ($dataD = mysqli_query($conn, $SQLTHREADID)) {
        while($tid = mysqli_fetch_assoc($dataD)) {
          $newThreadInputID = $tid['threadID'];
        }
      }

      // if this photo is getting a 1st comment, stamp photo with threadID  and put this discussion into NEW DISCS cat
      if (!empty($photoID) && $inputType == "comment") {
        $SQLUPDATEPHOTO ="UPDATE Photos SET discussThreadID = " . $newThreadInputID . " WHERE photoID = " . $photoID;
        $dataU = mysqli_query($conn, $SQLUPDATEPHOTO);

        $q1="INSERT INTO DiscCatsCross (catID, threadID) VALUES (100, " . $newThreadInputID . ")";
        $dataInA = mysqli_query($conn, $q1);

      }

      // if an answer was inserted, stamp discuss thread with current date for dateModified  and put disc into NEW RESPONSES cat
      $prevdiscCat = "";
      // it's a comment not a start of a new discussion
      if ($inputType == "additionalComment") {
        $SQLUPDATEQ="UPDATE Discussions SET dateModified = '" . date('Y-m-d H:i:s') . "' WHERE threadID = " . $threadID;
        $dataU = mysqli_query($conn, $SQLUPDATEQ);

        // check if this thread has been categorized
        $q="SELECT catID FROM DiscCatsCross WHERE threadID = " . $threadID . "";
        // if there is one, this thread has a cat so update it
        $dataU2 = mysqli_query($conn, $q);
        $tCountInCat = mysqli_num_rows($dataU2); 
      
        // it has already been catted
        if ($tCountInCat > 0){
          while($cid = mysqli_fetch_assoc($dataU2)) {
            $prevdiscCat = $cid['catID'];
          }
          // if it's previous cat is NEW DISC, make it NEW RESPONSE now
          if ($prevdiscCat == 100) { 
            $q8="UPDATE DiscCatsCross SET catID=101 WHERE (threadID=" . $threadID . " AND catID=100)";
            $dataIn8 = mysqli_query($conn, $q8);
          } elseif ($prevdiscCat == 101) { 
  //   $q9="UPDATE DiscCatsCross SET catID=101 WHERE (threadID=" . $threadID . " AND catID=101)";
  //        $dataIn8 = mysqli_query($conn, $q9);

  // it's already in 101 so maybe put it to a AdminCat Queue
            $q1="INSERT INTO DiscCatsCross (catID, threadID) VALUES (112, " . $threadID . ")";
            $dataInA = mysqli_query($conn, $q1);

          } 
        } else {
            $q1="INSERT INTO DiscCatsCross (catID, threadID) VALUES (101, " . $threadID . ")";
            $dataInA = mysqli_query($conn, $q1);
        }
      }
/* 
103 How Did U?; 
104 Digital Tech
102 Friendly Praise
111 Before and After
113 Where
114 Constructive

105 Trad Tech; 
110 Trouble
115 Suggestions
116 Thoughtful Analysis
*/

      //this newestThread is used for discussion categories page, to show newest image

      // if it's a new thread, use new threadID to update 100 in DiscCats
      $discCat = 101;
      $threadID4picStamp = $threadID;
      if ($inputType == "comment") {
        $threadID4picStamp = $newThreadInputID;
        $discCat = 100;
      }
  // after it's gone through 100 then 101  ... it will be put into another cat

      // if it's already been categorized... get lowest cat with this threadID
      $SQLpicStamp="SELECT catID FROM DiscCatsCross WHERE threadID = " . $threadID4picStamp . " ORDER BY catID LIMIT 1";
  //echo "<p>111<p>111<p>q2=" . $q;
      // if there is one, this thread has a cat so update newestThread
      if ($dataD = mysqli_query($conn, $SQLpicStamp)) {
        while($tid = mysqli_fetch_assoc($dataD)) {
          $discCat = $tid['catID'];
        }
      }

      $qC="UPDATE DiscCats SET newestThreadID = " . $threadID4picStamp . ", lastActivity = '" . date('Y-m-d H:i:s') . "' WHERE catID = " . $discCat;
      $dataUp2 = mysqli_query($conn, $qC);

    } else { // a course

      // put in course critiques here  


      if ($inputType == "additionalComment") {
        // insert discussion response         
        $q="INSERT INTO CourseCritiqueResponses (memberID, inputMemo, threadID, notifyMember) VALUES (" . $memberID . ", '" . $input . "', " . $threadID . ", '" . $notifyMemberInTheFuture . "')";
//echo "<p>TestoInA=".$q;
        $dataI = mysqli_query($conn, $q);
        
      } else {
        // insert discussion 
        $q="INSERT INTO CourseCritiques (memberID, topic, inputMemo, hasPhotos, notifyMember, dateModified) VALUES (" . $memberID . ", '" . $topic . "', '" . $input . "', 'Yes', '" . $notifyMemberInTheFuture . "', '" . date('Y-m-d H:i:s') . "')";
//echo "<p>TestoInD=".$q;
        $dataI = mysqli_query($conn, $q);
      }


      // Now get the threadID or inputID for the item just inserted, used to stamp photos
      if ($inputType == "additionalComment") {
        $SQLTHREADID="SELECT threadID FROM CourseCritiqueResponses ORDER BY inputID DESC LIMIT 1";
      } else {
        $SQLTHREADID="SELECT MAX(threadID) AS threadID FROM CourseCritiques";
      }
      if ($dataD = mysqli_query($conn, $SQLTHREADID)) {
        while($tid = mysqli_fetch_assoc($dataD)) {
          $newThreadInputID = $tid['threadID'];
        }
      }

      // if this photo is getting a 1st comment, stamp photo with threadID  and put this discussion into NEW DISCS cat
      if (!empty($photoID) && $inputType == "comment") {
        $SQLUPDATEPHOTO ="UPDATE Photos SET courseCritiqueThreadID = " . $newThreadInputID . " WHERE photoID = " . $photoID;
        $dataU = mysqli_query($conn, $SQLUPDATEPHOTO);

        $q1="INSERT INTO CourseCritiqueCatsCross (catID, threadID) VALUES (103, " . $newThreadInputID . ")";
//echo "<p>Testo1a=".$q1;
        $dataInA = mysqli_query($conn, $q1);

      }

      // if an answer was inserted, stamp discuss thread with current date for dateModified  and put disc into NEW RESPONSES cat
      $prevdiscCat = "";
      // it's a comment not a start of a new discussion
      if ($inputType == "additionalComment") {
        $q="UPDATE CourseCritiques SET dateModified = '" . date('Y-m-d H:i:s') . "' WHERE threadID = " . $threadID;
//echo "<p>Testo=".$q;
        $dataU = mysqli_query($conn, $q);

        // check if this thread has been categorized
        $q="SELECT catID FROM CourseCritiqueCatsCross WHERE threadID = " . $threadID . "";
        // if there is one, this thread has a cat so update it
        $dataU2 = mysqli_query($conn, $q);
        $tCountInCat = mysqli_num_rows($dataU2); 
      
        // it has already been catted
        if ($tCountInCat > 0){
          while($cid = mysqli_fetch_assoc($dataU2)) {
            $prevdiscCat = $cid['catID'];
          }
          // if it's previous cat is NEW DISC, make it NEW RESPONSE now
          if ($prevdiscCat == 103) { 
            $q8="UPDATE CourseCritiqueCatsCross SET catID=104 WHERE (threadID=" . $threadID . " AND catID=103)";
//echo "<p>Testo8=".$q8;
            $dataIn8 = mysqli_query($conn, $q8);
          } elseif ($prevdiscCat == 104) { 

  // it's already in 101 so maybe put it to a AdminCat Queue
            $q1="INSERT INTO CourseCritiqueCatsCross (catID, threadID) VALUES (112, " . $threadID . ")";
   // $dataInA = mysqli_query($conn, $q1);

          } 
        } else {
          $q1="INSERT INTO CourseCritiqueCatsCross (catID, threadID) VALUES (104, " . $threadID . ")";
//echo "<p>Testo1=".$q1;
          $dataInA = mysqli_query($conn, $q1);
        }
      }


    }


    $partThatDoesntChange = "To see it (and be inspired), visit BetterPhoto.com at:\n\n";
    $partThatDoesntChange .= "https://www.BetterPhoto.com/gallery/dynoGallDetail.php?photoID=" . $photoID . "&courseID=" . $courseID . "\n\n";

    $partThatDoesntChange .= "Thanks!\n\n";

    $partThatDoesntChange .= Application("name_customerSupport") . "\n";
    $partThatDoesntChange .= Application("email_customerSupport") . "\n\n" . Application("universalSignature") . "\n\n\n\n";

    $partThatDoesntChange .= "P.S. Some email programs may display the following code better than the above link; if yours does, feel free to use it: <a href='https://www.BetterPhoto.com/gallery/dynoGallDetail.php?photoID=" . $photoID . "&courseID=" . $courseID . "'> Alternate link to BetterPhoto.com </a>\n\n";


    if ($photoID == 850) { //  go to the video page
      
    } else {

      // when the original commenter indicated they wanted notification (so for Responses only)
      if ($notifyDiscOrig == "Yes" && !empty($emailOrig)) {
        
        // first is their email address any good?
        // sp_CheckEmailStatusByEmail"    
        $q="SELECT emailStatus FROM Members WHERE email = '" . $emailDisc . "'";
        if ($resultE = mysqli_query($conn, $q)) {
            while ($dataE = mysqli_fetch_assoc($resultE)) {
            $emailStatusQ = $dataE['emailStatus'];
          }
          
          if ($emailStatusQ != "BAD" && $emailStatusQ != "HRD" && $threadID != '1736976') {
            // create the object to send the email
            if (!empty($courseID) && !empty($memberNamePh)) {
              $subject = "Course Critique on Photo by " . $memberNamePh . ", at BetterPhoto.com - #" . $photoID;
            } elseif (!empty($memberNamePh)) {
              $subject = "Discussion on Photo by " . $memberNamePh . ", at BetterPhoto.com - #" . $threadID;
            } else {
              $subject = "Photo Discussion at BetterPhoto.com - #" . $threadID;
            }
            $responseForm = "Hi " . $firstNameOrig . "\n\n";
            $responseForm .= "There has been recent activity on ";
            if (!empty($firstNamePh)) {
              $responseForm .= $firstNamePh . "'s ";
            } else {
              $responseForm .= "a ";
            }
            $responseForm .= "photo at BetterPhoto.com. \n\n";
            
            $responseForm .= $partThatDoesntChange . "\n\n";
            
            $responseForm .= "#" . $memberID . " - " . "-NoteOrig=Yes---";
            
            $toAddress = $emailDisc; // respond to original commenter
     // during testing ++++++MAIL++++ go to me
    //$toAddress = "jimtestin@ProductiveAndHappy.com";
            $toName = "BetterPhoto Original Photo Commenter";
            $message = $responseForm;
            mailerThatRocks($toAddress, $subject, $message, $toName);

          }
        }
      }


    } // End if // video


    // when the photographer indicated they wanted notification     
//I am not receiving any notifications when I receive comments on my photos
    if ($notifyPh == "Yes") {
      // sp_CheckEmailStatusByEmail       
      $q="SELECT emailStatus FROM Members WHERE email = '" . $emailPh . "'";

      if ($dataP = mysqli_query($conn, $q)) {
          while ($rowP = mysqli_fetch_assoc($dataP)) {
          $emailStatusPh = $rowP['emailStatus'];
        }

        $threadID4email = $threadID;
        if ($inputType == "comment") {
          $threadID4email = $newThreadInputID;
        }
        if ($emailStatusPh != "BAD" && $emailStatusPh != "HRD" && $threadID4email != '1736976') {
        
     // during testing ++++++MAIL++++ go to me
    //$toAddress = "jimtestin@ProductiveAndHappy.com";

    //echo "<p>subject1=" . $subject;
    //echo "<p>form1=" . $responseFormPh;


          // if this is not the questioner (who has already been dealt with)
          if ($emailPh != $emailOrig) {
            // create the object to send the email
            
            if (!empty($courseID) && !empty($memberNamePh)) {
              $subject = "Course Critique: Photo by " . $memberNamePh . ", at BetterPhoto.com - #" . $photoID;
            } elseif (!empty($memberNamePh)) {
              $subject = "Discussion on Photo by " . $memberNamePh . ", at BetterPhoto.com - #" . $threadID4email;
            } else {
              $subject = "Photo Discussion at BetterPhoto.com - #" . $threadID4email;
            }
            $responseFormPh = "Hi " . $firstNamePh . "\n\n";
            $responseFormPh .= "There has been recent activity on your photo at BetterPhoto.com. \n\n";
            
            $responseFormPh .= $partThatDoesntChange . "\n\n";
            
            $responseFormPh .= "#" . $memberID . "-NotePH=Yes---";
          
            $toAddress = $emailPh;  //"eiKoae2uzXEsvy@dkimvalidator.com"     // respond to photographer
            $toName = "BetterPhoto Photographer";
            $message = $responseFormPh;
            mailerThatRocks($toAddress, $subject, $message, $toName);
          }
        }
      }
    }


    if ($photoID == 850) { //  go to the video page
      
    } else {
      
      if ($inputType == "additionalComment") {
        
        //  get all answerers on this thread with non-bad emails
        // only gets members with global "notify me" turned on
        // sp_FindDiscussersEmailsByThreadID"    
        if (empty($courseID)) {
          $q="SELECT m.email, m.firstName, m.memberID FROM Members m INNER JOIN DiscussionResponses a ON a.memberID = m.memberID WHERE ((a.threadID = " . $threadID . " ) AND (a.status != 'ARC') AND (m.emailStatus != 'BAD') AND (a.notifyMember = 'Yes')) ORDER BY m.memberID";
        } else {
          $q="SELECT m.email, m.firstName, m.memberID FROM Members m INNER JOIN CourseCritiqueResponses a ON a.memberID = m.memberID WHERE ((a.threadID = " . $threadID . " ) AND (a.status != 'ARC') AND (m.emailStatus != 'BAD') AND (a.notifyMember = 'Yes')) ORDER BY m.memberID";
        }
        $dataA = mysqli_query($conn, $q);
        
          while($aid = mysqli_fetch_assoc($dataA)) {

            $AnswererEmail = $aid['email'];
            $AnswererFName = $aid['firstName'];
            $AnswererMemberID = $aid['memberID'];     
          
          // response to answerers; exclude the most recent inputter; skip it when looping
          if ($AnswererMemberID != $memberID) {
          
            // only do it once for those who have many answers on the thread
            if ($AnswererMemberID != $laterpreviousAnswererMemberID) {
            
              //if this is not the questioner or photographer (who have already been dealt with)
              if ($AnswererEmail != $emailOrig && $AnswererEmail != $emailPh && $threadID != '1736976') {
                // create the object to send the email
                if (!empty($courseID) && !empty($memberNamePh)) {
                  $subject = "Course Critique on Photo by " . $memberNamePh . ", at BetterPhoto.com - #" . $photoID;
                } elseif (!empty($memberNamePh)) {
                  $subject = "Discussion on Photo by " . $memberNamePh . ", at BetterPhoto.com - #" . $threadID;
                } else {
                  $subject = "Photo Discussion at BetterPhoto.com - #" . $threadID;
                }
                $responseForm = "Hi " . $AnswererFName . "\n\n";
                $responseForm .= "There has been recent activity on ";
                if (!empty($firstNamePh)) {
                  $responseForm .= $firstNamePh . "'s ";
                } else {
                  $responseForm = $responseForm . "a ";
                }
                $responseForm .= "photo at BetterPhoto.com.\n\n" . $partThatDoesntChange;
              
              
                $responseForm .= "P.P.S. If you would like to stop being notified each time there is activity on this thread, visit:\n" .
                "https://www.BetterPhoto.com/notifyNoMore.php?pOrQ=p&t=" . $threadID . "&m=" . $AnswererMemberID . "\r\n\r\n\r\n\r\n";
        
                $responseForm .= "#" . $memberID . "-Aid" . $AnswererMemberID . "-lpAid" . $laterpreviousAnswererMemberID;
        
                if (!empty($AnswererEmail)) {
                  $toAddress = $AnswererEmail;
                } else {
                  $toAddress = "jimError@ProductiveAndHappy.com";
                }
                $toName = "BetterPhoto Photo Commenter";
                $message = $responseForm;
                mailerThatRocks($toAddress, $subject, $message, $toName);

              }
            }
          }
        
          $laterpreviousAnswererMemberID = $AnswererMemberID;
        
        } // EmailRSA.movenext loop
      } // End if ' if an additional comment, go thru other additional comments

    } // End if // don't do if video

    $q="SELECT role, firstName, lastName FROM MemberVolunteers mv JOIN Members m ON m.memberID = mv.memberID WHERE mv.memberID = " . $memberID;
    $dataXV = mysqli_query($conn, $q);
    $tCountXV = mysqli_num_rows($dataXV); 
    if ($tCountXV > 0){

      while ($Sid = mysqli_fetch_assoc($dataXV)) {
        $roleBPV = $Sid['role'];
        $firstNameBPV = $Sid['firstName'];
        $lastNameBPV = $Sid['lastName'];
      }
    //if($memberID == "18159" || $memberID == "512652" || $memberID == "514903" || $memberID == "294243" || $memberID == "50267" || $memberID == "521275" || $memberID == "342009" || $memberID == "365554" || $memberID == "525882" || $memberID == "463726" || $memberID == "169334" || $memberID == "516663" || $memberID == "49948" || $memberID == "522088" || $memberID == "38076" || $memberID == "138988" || $memberID == "23144" || $memberID == "412484" || $memberID == "126389" || $memberID == "274303" || $memberID == "52305" || $memberID == "529909" || $memberID == "151641" || $memberID == "516876"){

      // Notify me of team work
      $subject = "9x9 Discussion by " . $roleBPV . ": " . $firstNameBPV . " " . $lastNameBPV;
      $strN = "Nice 9 x 9 to " . $memberID . "\n\nTo see, go to:\n" . "https://www.BetterPhoto.com/gallery/dynoGallDetail.php?photoID=" . $photoID . "&courseID=" . $courseID . "\n\nEnjoy!\n\n";

      $toAddress = "jim@ProductiveAndHappy.com";
      $toName = "BetterPhoto Owner";
      $message = $strN;
      //mailerThatRocks($toAddress, $subject, $message, $toName);
    } 
  } else {
    // show the errors
    echo '<div class="alert alert-warning" role="alert">';
    foreach ($errors as $v) {
      echo "$v\n";
    }
    echo '</div>';
  } // End if  no errors

/*  NO LONGER USING
if ($photoID == 850) { //  go to the video page
if ($referrerURL == "video3") {
$URL="/video4.php";
} elseif ($referrerURL == "video3") {
$URL="/video3.php";
} elseif ($referrerURL == "video2") {
$URL="/video2.php";
} else {
$URL="/video.php";
}
} 
*/
} 
//  show photo below, even if here for a 2nd time

$courseCritiqueThreadID = '';

if (empty($catID)) {
  // sp_FindImageAndCatByPhotoID"
  $q="SELECT p.photoName, p.photoTitle, p.photoDescription, p.memberID, p.directory, p.post, p.threadID, p.InputID, p.DiscussThreadID, p.courseCritiqueThreadID, p.cameraID, p.contestWinner, DATE_FORMAT(p.dateCreated, '%M %d, %Y') as dateCreated, p.photoWidthLarge, p.photoHeightLarge, p.exifData, p.notifyMember, DATE_FORMAT(p.dateEnteredContest, '%M %d, %Y %H:%i:%s') AS dateEnteredContest, pcc.catID FROM Photos p LEFT OUTER JOIN PhotoCatsCross pcc ON p.photoID = pcc.photoID WHERE p.photoID = " . $photoID . " ORDER BY catID DESC LIMIT 1";
} else {
  // sp_FindImageByPhotoID
  $q="SELECT p.photoName, p.photoTitle, p.photoDescription, p.memberID, p.directory, p.post, p.threadID, p.InputID, p.DiscussThreadID, p.courseCritiqueThreadID, p.cameraID, p.contestWinner, DATE_FORMAT(p.dateCreated, '%M %d, %Y %H:%i:%s') as dateCreated, p.photoWidthLarge, p.photoHeightLarge, p.exifData, p.notifyMember, DATE_FORMAT(p.dateEnteredContest, '%M %d, %Y %H:%i:%s') AS dateEnteredContest FROM Photos p WHERE photoID = " . $photoID;
}
//echo "<p>echo=".$q;
$dataPic = mysqli_query($conn, $q);
if ($ImageSet = mysqli_fetch_assoc($dataPic)) {
  $photoName = $ImageSet['photoName'];
  $photoTitle = $ImageSet['photoTitle'];
  if (empty($photoTitle)) $photoTitle = "Untitled";
  $photoDescription = $ImageSet['photoDescription'];
  $phMemberID = $ImageSet['memberID'];
  $photoDirectory = $ImageSet['directory'];
  $post = $ImageSet['post'];
  $threadID = $ImageSet['threadID'];
  $inputID = $ImageSet['InputID'];
  $discussThreadID = $ImageSet['DiscussThreadID'];
  $courseCritiqueThreadID = $ImageSet['courseCritiqueThreadID'];
$cameraID = $ImageSet['cameraID'];
  $contestWinner = $ImageSet['contestWinner'];
  $dateCreated = $ImageSet['dateCreated'];
  $photoWidthLarge = $ImageSet['photoWidthLarge'];
  $photoHeightLarge = $ImageSet['photoHeightLarge'];
  $exifData = $ImageSet['exifData'];
  $notifyPh = $ImageSet['notifyMember'];
  $dateEnteredContest = $ImageSet['dateEnteredContest'];
  if (empty($catID)) $catID = $ImageSet['catID'];
  
  // clear photoDescription if it contains a link JIM 3/2016
  if (strpos(strtolower($photoDescription),"<a ") > 0) {
    if (strpos(strtolower($photoDescription),"betterphoto.") > 0) { // and it's not a good internal link
      $photoDescription = str_replace("http:", "https:", $photoDescription);
    } else {
      $photoDescription = "";
    }
  }
  
  //   USE SITE URL here instead     +++++++++++      AmazonDirectoryFlag = 0 ' isAmazonDirectory(photoDirectory)
  
  // get keywords if there are any
  // sp_GetMatchingKeywordsByPhotoIDOnly           photoID
  $photoKeywords = '';
  $q="SELECT keyword, count(photoKeywordCrossID) FROM KeywordsCross kc JOIN Keywords k ON  kc.keywordID = k.keywordID WHERE photoID = " . $photoID . " GROUP BY keyword HAVING count(photoKeywordCrossID) > 0 ORDER BY count(photoKeywordCrossID) DESC";
  // SHUT OFF JUNE 2020    $dataKW = mysqli_query($conn, $q);
  //while($kSet = mysqli_fetch_assoc($dataKW)) {
    //$photoKeywords .= strtolower($kSet['keyword']) . ', ';
  //}
  // trim final comma
  if (right($photoKeywords, 2) == ', ') {
      $photoKeywords = rtrim($photoKeywords,', ');
  }
  
  // do a check to see if this is a Editor's Pick
  $isEC = sp_ValidateEditorsChoicePhoto($conn, $photoID);

  // do a check to see if this is a POTD photo
  $isPOTD = sp_ValidatePotdPhoto($conn, $photoID);
  // do a check to see if this is a GEM photo
  $isGOTD = sp_ValidateGemPhoto($conn, $photoID);

  //echo "<p>post=".$post;
  if ($post == "Yes") { // if public or an example from a photo course lesson
    
    ?>
    <!-- Photo Feed Content Starts -->
    <section id="feed">

    <div class="container">


      <div class="feed-col">
      <?php
      if (!empty($phMemberID)) {
        // sp_FindMemberByMemberID" phMemberID
        $q="SELECT email, firstName FROM Members WHERE memberID = " . $phMemberID;
        $dataE = mysqli_query($conn, $q);
        while($eSet = mysqli_fetch_assoc($dataE)) {
          $emailPh = $eSet['email'];
          $firstNamePh = $eSet['firstName'];
        }
        
       $memberNamePh = get_full_member_name($conn, $phMemberID);
      }
      ?>
    

        <div class="feed-item">
          <div class="feed-item-description"><!-- Photo Feed image description starts -->
            <?php 
            if (!empty($photoTitle)) {
              echo '<p class="feed-image-title">' . $photoTitle;
              if (!empty($catID) && !empty($cn)) {
                $catNameFromURL = str_replace("+", " ", str_replace("-", " ", str_replace("-and-", " &amp; ", $cn)));  // Girl+Photos

                echo ' <a href="dynoGall2.php?catID=' . $catID . '&cn=' . $cn . '&courseID=' . $courseID . '&sortBye=' . $sortBye . '&contestCatID=' . $contestCatID . '&camID=' . $camID . '&mem4gall=' . $mem4gall . 'FavMemID=' . $FavMemID . '&Favpt=' . $Favpt . '&s=' . $start . '">[' . $catNameFromURL . ']</a>'; 
              }
              if (!empty($courseID)) {
                echo ' <a href="/courses/interactive/home_crs.php?courseID=' . $courseID . '">[Online Photography Course]</a>'; 
              }
              echo '</p>'; 
            }
            ?>
      
            <?php // show photographers name
            if (!empty($phMemberID)) {
              ?><p class="feed-image-photographer"><a href="/gallery/gallerySorter.php?memberID=<?php echo $phMemberID ?>"><?php 
              if (!empty($memberNamePh)) {
                echo "&copy;&nbsp;" . $memberNamePh;
              } else { 
                echo "Photographer";
              } 
              echo "</a> ";
              // show photographers website, BVP status  anything else?
              showDlxOrProIfMemberHasOneWithProOrDlx($conn, $phMemberID);
              echo "</p>";
            } 
            ?>
          </div><!-- Photo Feed image description ends -->

          <!-- Image div starts -->
          <div class="feed-image">
            <div class="feed-image-inner">

              <!-- Image hover div starts -->
            <div class="feed-image-hover">
                <div class="image-details">
                    <!--<p class="camera-model">
        Click the "i" to view comments &amp; details 
        Shutter Speed: 44 s </p>        
        <p class="camera-lens">Aperture: f/2.8</p>
                  <p class="iso">ISO/Film: 800</p> -->
                </div>

                <!-- Comment bar opening button  -- we default to info box open for ipad and mobile without hover -->
                <div class="comment-description-icon">
                  <i class="fa fa-info"></i><!--   -->
                </div>

              </div><!-- Image hover div ends -->

              <!-- Main image -->
               <?php 
                echo "<img class='img-responsive' src='";
                if (isMovedtoNewServer($conn,$photoID)==1) {  
                  echo SITE_URL;
                } else {
                  echo SITE_URL_OLD;
                }
                echo $photoDirectory . "/" . $photoName .".jpg' border='0' alt='" . $photoTitle . "'>";
      

//updaterAccess WAS HERE
?>
            </div> <!-- ends feed-image-inner -->


            <!-- Comment and Description Bar Starts -->
            <div class="comment-description-bar clearfix opened">

              <p align="center"><?php 
                if (!empty($dateCreated)) {  
                  echo "Uploaded: " . $dateCreated;
                } 
                if (!empty($dateEnteredContest)) {  
                  echo " | Entered: " . $dateEnteredContest;
                } ?></p>
                
              <!-- Comments bar starts -->
              <div class="comments">
        
                <!-- Image Description starts -->
                <div class="description-line">
                  <?php 
                  $exifDataClean = str_replace("Unavailable", "", $exifData);
                  if (strpos($exifDataClean, "Camera:  ; Shutter Speed: ; Aperture: ; ISO: ; ") !== false || strpos($exifDataClean, "Camera:  ; Shutter Speed: ; Aperture: ; ISO: ;") !== false) {
                    $exifDataClean = ""; //strip it
                  }
                  if (!empty($photoDescription) || !empty($exifDataClean)) {
                    echo "<h3>Description</h3><p>";
                  }
                  
                  if (!empty($photoDescription)) { 
                    echo $photoDescription . "<br><br>";
                  } 

                  if (!empty($exifDataClean)) { 
                    echo "Exif: " . $exifDataClean . "<br><br>";  
                  } 
                  if (!empty($photoDescription) || !empty($exifDataClean)) {
                    echo "</p>";
                  }
                ?></div><!-- Image Description ends -->

                <!-- Tags Starts -->
                <div class="tags-line">
                <?php if (!empty($photoKeywords) && 1 == 0 ) {   // TURNED OFF JUNE 2020   +++++++++++++++
                  echo "<h5>Keywords:&nbsp;";
                  // parse the string
                  $a = explode(', ', $photoKeywords); 
                  // loop
                  foreach ($a as $x) {
                    $y = trim($x);
                    
                    if (!empty($y) && $y != ",") {
                      echo "<a href='/search.php?szTerm=" . $y . "'>#" . $y . "</a>&nbsp;";
                    } // End if
                  } // next
                  echo "</h5>";
                } ?>
                </div><!-- Tags Ends -->

                <!-- Camera details starts --> 
                <div class="made-with">
                  <?php     // TURNED OFF JUNE 2020   +++++++++++++++
                  if (!empty($cameraID) && $cameraID != "17635") {
                    // sp_GetCameraNameByID     cameraID 
                    $q="SELECT DISTINCT ri.reviewableItemID, bc.name, ri.itemName FROM ReviewableItems ri, ReviewableItemBrands bc WHERE ri.reviewableItemID = " . $cameraID ." AND ri.manufacturerID = bc.manufacturerID";
                    $resultCam=mysqli_query($conn,$q);
                    while($cameraInfo=mysqli_fetch_array($resultCam)) {
                      $brandName = $cameraInfo['name'];
                      $cameraName = $cameraInfo['itemName'];
                      
                      //echo "<h3>Made With</h5><p>Camera: <a href='/gallery/dynoGall2.php?camID=" . $cameraID . "'>" . $brandName . "&nbsp;" . $cameraName . "</a></p>";
                    }
                  } 
                  ?>
                  <!-- <p>Lens: Tokina 11-16</p>
                  <p>Focal Length: 11mm</p> -->
                </div><!-- Camera details Ends -->


                <?php
                if (!empty($courseID)) {
                  ?>
                  <h3>Course Comments &amp; Critiques</h3>
                  <?php
                  echo '<div class="comment-area">';
//if (!empty($courseCritiqueThreadID)) { } 
                     
      
                  $inputType = "comment";

                  $notifyDiscOrig = '';
                  // COURSE CRITIQUES
                  if (!empty($courseCritiqueThreadID) && $courseCritiqueThreadID != "-1") {
                    
//echo "<p>dt=".$courseCritiqueThreadID;
                    $inputType = "additionalComment";
                    
                    if (!empty($courseCritiqueThreadID)) {   
                      $q="SELECT topic, inputMemo, DATE_FORMAT(dateCreated, '%M %d, %Y') as dateCreated, memberID, notifyMember, threadID FROM CourseCritiques WHERE threadID = " . $courseCritiqueThreadID . " AND status != 'ARC'";
                    
                    } elseif (!empty($inputID)) {
                      $q="SELECT d.topic,  d.inputMemo, DATE_FORMAT(d.dateCreated, '%M %d, %Y') as dateCreated, d.memberID, d.notifyMember, d.threadID FROM CourseCritiques d JOIN CourseCritiqueResponses r ON d.threadID = r.threadID WHERE  r.inputID = " . $inputID . " AND d.status != 'ARC'";
                    }
//echo "<p>testo=sql=".$q."";                 
                    if ($resultsCS = mysqli_query($conn, $q)) {
                      while ($dataCS = mysqli_fetch_assoc($resultsCS)) {
                        $inputMemo = $dataCS['inputMemo'];
    
                        $dateCreatedOrig = $dataCS['dateCreated'];
                        $memberIDQ = $dataCS['memberID'];
                        $notifyDiscOrig = $dataCS['notifyMember'];
                        $courseCritiqueThreadID = $dataCS['threadID'];
                        
                        // sp_GetMemberInfoByMemberID memberIDQ
                        $q="SELECT email, firstName, MiniPicPath FROM Members WHERE memberID = " . $memberIDQ;
//echo "<p>testo=sql=".$q."";  
                        if ($resultsM = mysqli_query($conn, $q)) {
                          while ($dataM = mysqli_fetch_assoc($resultsM)) {
                            $emailDiscOrig = $dataM['email'];
                            $firstNameOrig = $dataM['firstName']; 
                            $MiniPicPathOrig = $dataM['MiniPicPath'];
                            if (!empty($MiniPicPathOrig)) {
                              //$MiniPicPathOrig = str_replace("\","/",$MiniPicPathOrig);
                            }
                          }
                        }
                        
                        $memberNameOrig = get_full_member_name($conn, $memberIDQ);
  $fanaticStyleOrig = false;                      
                        $paidMemberOrig = false;
                        //sp_FindMemberPaidGallery      
                        $paidMemberOrig = check_paidGalleryOwner($conn, $memberIDQ);
                        
                        // go find all Deluxe BetterPholios associated with this memberID
                        // sp_GetDeluxeSiteByMemberID
                        $postDeluxeOrig = '';
                        $q="SELECT post, dateImageSalesPaid FROM DeluxeSites WHERE memberID = ".$memberIDQ." AND dateExpiration is not null ORDER BY post desc, siteID DESC";
  //echo "<p>testo=sql=".$q."";  
                        $stmt =  $conn->query($q);
                        while ($rsWebC = $stmt->fetch_array()) { 
                          $postDeluxeOrig = $rsWebC['post']; // they gave a paid website
                          $dlxdateProPaidOrig = $rsWebC['dateImageSalesPaid']; 
                        }

                        if ($postDeluxeOrig == "Yes" && is_null($dlxdateProPaidOrig) == false) { // PRO site     
                          $levelIconOrig = "level-addict";
                        } elseif ($postDeluxeOrig == "Yes" && is_null($dlxdateProPaidOrig) == True) {   // DLX site 
                          $levelIconOrig = "level-deluxe";
                        } elseif ($paidMemberOrig == True && $fanaticStyleOrig == True) {   
                          $levelIconOrig = "level-fanatic";
                        } elseif ($paidMemberOrig == True) {  
                          $levelIconOrig = "level-classic";
                        } else {
                          $levelIconOrig = "";
                        }
                        
                        ?>
                        <!-- Comment item starts -->
                        <div class="comment clearfix row row-over">
                          <!-- Commenter profile pic -->
                          <div class="col-xs-2 col-sm-1 row-over comment-pic-bar">
                            <!-- To change profile pic image, need just change "comment-user-prof-pic" div's "backgroud-image" style url -->
                            <div class="comment-user-prof-pic" style="background-image: url(<?php
                            if (!empty($MiniPicPathOrig)) {
                              echo $MiniPicPathOrig;
                            } else {
                              echo "/images/anonymousBPmember2.jpg";
                            } 
                            ?>)">
                            </div>
                          </div>

                          <div class="col-xs-10 col-sm-10 row-over comment-text-bar">
                            <p class="comment-user">
                            <a href="gallerySorter.php?memberID=<?php echo $memberIDQ ?>"><?php echo $memberNameOrig ?></a>
                            <?php
                            if (!empty($levelIconOrig)) {
                              echo '<a href="/levels.php"><img class="comment-username-level" src="/images/' . $levelIconOrig . '.png" alt="' . $levelIconOrig . '"></a>';
                            }
                            ?><!-- Shows which level has user -->
       
                            <span class="comment-calendar"><?php echo $dateCreatedOrig ?></span><!-- Shows when the comment was left -->
                            <span class="love-comment">
                            <?php
                            $notYetFavedDisc = 0;

                            if (!empty($memAuth)) {     
                              $q="SELECT favID FROM CourseCritiquesFavorites WHERE favInputID = " . $courseCritiqueThreadID . " AND memberID = " . $memAuth;
                              $dataChk1 = mysqli_query($conn, $q);
                              $tCountD=mysqli_num_rows($dataChk1); 
                              if ($tCountD == 0){

                                $notYetFavedDisc = 1;
                                // not a favorite yet, show add link
           echo "<a href='/faver-commentSQL.php?ai=5&id=" . $courseCritiqueThreadID . "&photoID=" . $photoID . "&courseID=" . $courseID . "&notifyDiscer=" . $notifyDiscOrig . "&mIDLoved=" . $memberIDQ . "' title='Love this critique'>";
                              }
                            }
                            echo sb_FavoriteCourseCritiqueCount($conn, $courseCritiqueThreadID);
                            echo '<i class="fa fa-heart"></i>';
                            if ($notYetFavedDisc == 1) {
                              echo '<font size="-1">love it</font></a>';
                            }
                            ?></span><!-- Show how many love its has comment -->
                                </p>
                                <span class="comment-text"><?php echo $inputMemo ?> <font size="-2" color="grey">#<?php echo $courseCritiqueThreadID ?></font></span><!-- Main comment text -->

                          </div> <!-- comment-text-bar -->
                        </div><!-- Comment item ends -->
                        <?php 
                        // find all records in Responses table that have this threadID    
                        $q="SELECT inputID, inputMemo, DATE_FORMAT(dateCreated, '%M %d, %Y') as dateCreated, memberID, notifyMember FROM CourseCritiqueResponses WHERE threadID = " . $courseCritiqueThreadID . " AND status != 'ARC' ORDER BY inputID";

  //echo "<p>testo=sql=".$q.""; 

                        if ($resultsCA = mysqli_query($conn, $q)) {
                          while ($dataCA = mysqli_fetch_assoc($resultsCA)) {

                            $inputIDA = $dataCA['inputID'];
                            $inputMemoA = $dataCA['inputMemo'];
     
                            $dateCreatedA = $dataCA['dateCreated'];
                            $memberIDA = $dataCA['memberID'];
                            $notifyDiscLoved = $dataCA['notifyMember']; // for if this comment gets loved
                            if (!empty($memAuth) && is_null($memberIDA) == false) {
                              if ($memAuth == $memberIDA) { //  the comment is by logged-in user
                                $notifyAdditionalCommenter = $dataCA['notifyMember'];
                              }
                            }
                            
                            // sp_GetMemberInfoByMemberID 
                            $q="SELECT email, MiniPicPath FROM Members WHERE memberID = " . $memberIDA;
                            if ($resultMA = mysqli_query($conn, $q)) {
      //$emailDiscA = $dataMA['email'];
                              while ($dataMA = mysqli_fetch_assoc($resultMA)) {
                                $MiniPicPathDiscA = $dataMA['MiniPicPath'];
                              }
                              
                              if (!empty($MiniPicPathDiscA)) {
                                //$MiniPicPathDiscA = str_replace("\","/",$MiniPicPathDiscA);
                              }
                            }
                            
                            $memberNameDiscA = "";

      $fanaticStyleA = false;                      
                            $paidMemberA = false;
                            //sp_FindMemberPaidGallery      
                            $paidMemberA = check_paidGalleryOwner($conn, $memberIDA);

                            $memberNameDiscA = get_full_member_name($conn, $memberIDA);  

                            // go find all Deluxe    memberIDA
                            $postDeluxeA = '';
                            $q="SELECT post, dateImageSalesPaid FROM DeluxeSites WHERE memberID = ".$memberIDA." AND dateExpiration is not null ORDER BY post desc, siteID DESC";
                            $stmt =  $conn->query($q);
                            while ($rsWebCA = $stmt->fetch_array()) { 
                              $postDeluxeA = $rsWebCA['post']; // they gave a paid website
                              $dlxdateProPaidA = $rsWebCA['dateImageSalesPaid']; 
                            }

                            if ($postDeluxeA == "Yes" && is_null($dlxdateProPaidA) == false) { // PRO site     
                              $levelIconDiscA = "level-addict";
                            } elseif ($postDeluxeA == "Yes" && is_null($dlxdateProPaidA) == True) {   // DLX site 
                              $levelIconDiscA = "level-deluxe";
                            } elseif ($paidMemberA == True && $fanaticStyleA == True) {   
                              $levelIconDiscA = "level-fanatic";
                            } elseif ($paidMemberA == True) {  
                              $levelIconDiscA = "level-classic";
                            } else {
                              $levelIconDiscA = "";
                            } 
                              
                            ?>
                            <div class="comment clearfix row row-over">
                              <div class="col-xs-2 col-sm-1 row-over comment-pic-bar">
                                <div class="comment-user-prof-pic" style="background-image: url(<?php
                                  if (!empty($MiniPicPathDiscA)) {
                                    echo $MiniPicPathDiscA;
                                  } else {
                                    echo "/images/anonymousBPmember2.jpg";
                                  } 
                                  ?>)">
                                </div>
                              </div>

                              <div class="col-xs-10 col-sm-10 row-over comment-text-bar">
                                <p class="comment-user">
                                <a href="gallerySorter.php?memberID=<?php echo $memberIDA ?>"><?php echo $memberNameDiscA ?></a>
                                <?php
                                if (!empty($levelIconDiscA)) {
                                  echo '<a href="/levels.php"><img class="comment-username-level" src="/images/' . $levelIconDiscA . '.png" alt="' . $levelIconDiscA . '"></a>';
                                }
                                ?>
                                <span class="comment-calendar"><?php echo $dateCreatedA ?></span>
                                <span class="love-comment">
                                <?php 
                                $notYetFavedDiscR = 0;

                                if (!empty($memAuth)) {
      
                                  $q="SELECT favID FROM CourseCritiqueResponsesFavorites WHERE favInputID = " . $inputIDA . " AND memberID = " . $memAuth;
                                  $dataChkDR = mysqli_query($conn, $q);
                                  $tCountDR=mysqli_num_rows($dataChkDR); 
                                  if ($tCountDR == 0){

                                    $notYetFavedDiscR = 1;
                                    // not a favorite yet, show add link
                                    echo "<a href='/faver-commentSQL.php?ai=6&id=" . $inputIDA . "&photoID=" . $photoID . "&courseID=" . $courseID . "&notifyDiscer=" . $notifyDiscLoved . "&mIDLoved=" . $memberIDA . "' title='Love this comment'>";
                                  }

                                }
                                echo sb_FavoriteCourseCritiqueResponseCount($conn, $inputIDA) ?><i class="fa fa-heart"></i><?php 
                                 if ($notYetFavedDiscR == 1) {
                                    echo '<font size="-1">love it</font></a>';
                                  }
                                  echo '</span> </p> <span class="comment-text">' . $inputMemoA . ' <font size="-2" color="grey">#' . $inputIDA;
                                  ?></font></span>

                              </div> 
                            </div>

                          <?php
                          } // answers while
                        } // answers if 
                      } // thread while 
                    } // End If  any existing comments or thread  
                  } else { 
                    ?>
                    Be the first... <?php if (empty($memAuth)) echo "Sign in and then"; ?> critique below.
                  <?php
                  } // End If a courseCritiqueThreadID
                  echo '</div><!-- Comments area ends -->';
                  ?>
            
                  <!-- Comment Textarea starts -->
                  <div class="comment-textarea">
                    <?php 
                    if (!empty($memAuth)) { ?>
                      <form method="post" action="" id="commInput" name="commInput">
                      <textarea name="input" placeholder="Critique..."></textarea>
            
<div class="checkbox">
  <label>
    <input TYPE="checkbox" NAME="notifyMemberInTheFuture" VALUE="Yes" <?php 
    if ($memAuth == $phMemberID) { // this is commenter's photo 
      if ($notifyPh == "Yes") { // i as photog want notification 
          echo "checked";
      }
    } elseif ($memAuth == $notifyDiscOrig) { //commenter is original discusser 
      if ($notifyDiscOrig == "Yes") { // i as orig discusser want notice  
        echo "checked";
      }
    } elseif (!empty($notifyAdditionalCommenter)) { // commenter is additional discusser, flagged above 
      if ($notifyAdditionalCommenter == "Yes") { // i as additional discusser want notice  
        echo "checked";
      } 
    } else { // global 
      if ($emailNotifyDefaultCA1 == 1) {
        echo "checked";
      }
    } 
    ?>>&nbsp;&nbsp;Notify&nbsp;me&nbsp;of&nbsp;future&nbsp;critiques
  </label>
</div>

                      <input type="Hidden" name="courseID" value="<?php echo $courseID ?>">

                      <input type="Hidden" name="topic" value="<?php echo $photoTitle ?>">
                      <input type="Hidden" name="memberID" value="<?php echo $memAuth ?>">
                      <input type="Hidden" name="photoID" value="<?php echo $photoID ?>">
                      <input type="Hidden" name="notifyPh" value="<?php echo $notifyPh ?>">
                      <input type="Hidden" name="emailPh" value="<?php echo $emailPh ?>">
                      <input type="Hidden" name="firstNamePh" value="<?php echo $firstNamePh ?>">
                      <input type="Hidden" name="memberNamePh" value="<?php echo $memberNamePh ?>">

                      <input type="Hidden" name="inputType" value="<?php echo $inputType ?>">
                      <input type="Hidden" name="threadID" value="<?php echo $courseCritiqueThreadID ?>">

                      <input type="Hidden" name="notifyDiscOrig" value="<?php echo $notifyDiscOrig ?>">
                      <input type="Hidden" name="emailOrig" value="<?php echo $emailOrig ?>">
                      <input type="Hidden" name="firstNameOrig" value="<?php echo $firstNameOrig ?>">
                      
                      <input type="Hidden" name="catID" value="<?php if ($catID != "966") echo $catID ?>">
                      <input type="Hidden" name="contestCatID" value="<?php echo $contestCatID ?>"> 
                      <input type="Hidden" name="camID" value="<?php echo $camID ?>">
                      <input type="Hidden" name="mem4gall" value="<?php echo $mem4gall ?>">
                      <input type="Hidden" name="mem4show" value="<?php echo $mem4show ?>">
                      <input type="Hidden" name="mem4Wins" value="<?php echo $mem4Wins ?>">
                      <input type="Hidden" name="sortBye" value="<?php echo $sortBye ?>">
                      <input type="Hidden" name="FavMemID" value="<?php echo $FavMemID ?>">
                      <input type="Hidden" name="Favpt" value="<?php echo $Favpt ?>">
                      <input type="Hidden" name="start" value="<?php echo $start ?>">
                      <input type="Hidden" name="rowNumber" value="<?php echo $rowNumber ?>">
                      <input type="Hidden" name="rowsPerPage" value="<?php echo $rowsPerPage ?>">

                      <button class="btn btn-main btn-orange btn-send-comment">Send</button>
                      </form>
                    <?php     
                    } else { ?>
                      <br><font size="-1">To critique, first log in.</font>
                    <?php 
                    }
                    ?>
                  </div><!-- 2nd Comment Textarea ends -->
      

                  <?php
                } else { // courseID
                  ?>

                  <h3>Comments</h3>

                  <div class="comment-area">
                  <?php 
                  $inputType = "comment";

                  $notifyDiscOrig = '';
                  // DISCUSSIONS
                  if (!empty($discussThreadID) && $discussThreadID != "-1" && $discussThreadID != "1736976") {
                    
//echo "<p>dt=".$discussThreadID;
                    $inputType = "additionalComment";
                    
                    if (!empty($discussThreadID)) {
                      // sp_FindDiscussionByThreadID    
                      $q="SELECT topic, inputMemo, DATE_FORMAT(dateCreated, '%M %d, %Y') as dateCreated, memberID, notifyMember, threadID FROM Discussions WHERE threadID = " . $discussThreadID . " AND status != 'ARC'";
                    
                    } elseif (!empty($inputID)) {
                      // sp_FindDiscussionByInputID
                      $q="SELECT d.topic,  d.inputMemo, DATE_FORMAT(d.dateCreated, '%M %d, %Y') as dateCreated, d.memberID, d.notifyMember, d.threadID FROM Discussions d JOIN DiscussionResponses r ON d.threadID = r.threadID WHERE  r.inputID = " . $inputID . " AND d.status != 'ARC'";
                    }
                    
                    if ($resultsS = mysqli_query($conn, $q)) {
                      while ($dataS = mysqli_fetch_assoc($resultsS)) {
                        $inputMemo = $dataS['inputMemo'];
                        /* 
                        inputMemo = Replace(Replace(inputMemo,"</b>",""),"<b>","")
                        inputMemo = Replace(Replace(inputMemo,"http://lsqrd.blogspot.com/",""),"blogspot","")
                        inputMemo = Replace(Replace(inputMemo,"<font color=""#195CB7""><b>",""),"<b><font color=gray><br>","")
                        */
                        $dateCreatedOrig = $dataS['dateCreated'];
                        $memberIDQ = $dataS['memberID'];
                        $notifyDiscOrig = $dataS['notifyMember'];
                        $discussThreadID = $dataS['threadID'];
                        
                        // sp_GetMemberInfoByMemberID memberIDQ
                        $emailDiscOrig = '';
                        $q="SELECT email, firstName, MiniPicPath FROM Members WHERE memberID = " . $memberIDQ;
                        if ($resultsM = mysqli_query($conn, $q)) {
                          while ($dataM = mysqli_fetch_assoc($resultsM)) {
                            $emailDiscOrig = $dataM['email'];
                            $firstNameOrig = $dataM['firstName']; 
                            $MiniPicPathOrig = $dataM['MiniPicPath'];
                            if (!empty($MiniPicPathOrig)) {
                              //$MiniPicPathOrig = str_replace("\","/",$MiniPicPathOrig);
                            }
                          }
                        }
                        
                        $memberNameOrig = get_full_member_name($conn, $memberIDQ);
  $fanaticStyleOrig = false;                      
                        $paidMemberOrig = false;
                        //sp_FindMemberPaidGallery      
                        $paidMemberOrig = check_paidGalleryOwner($conn, $memberIDQ);
                        
                        // go find all Deluxe BetterPholios associated with this memberID
                        // sp_GetDeluxeSiteByMemberID
                        $postDeluxeOrig = '';
                        $q="SELECT post, dateImageSalesPaid FROM DeluxeSites WHERE memberID = ".$memberIDQ." AND dateExpiration is not null ORDER BY post desc, siteID DESC";
                        $stmt =  $conn->query($q);
                        while ($rsWeb = $stmt->fetch_array()) { 
                          $postDeluxeOrig = $rsWeb['post']; // they gave a paid website
                          $dlxdateProPaidOrig = $rsWeb['dateImageSalesPaid']; 
                        }

                        if ($postDeluxeOrig == "Yes" && is_null($dlxdateProPaidOrig) == false) { // PRO site     
                          $levelIconOrig = "level-addict";
                        } elseif ($postDeluxeOrig == "Yes" && is_null($dlxdateProPaidOrig) == True) {   // DLX site 
                          $levelIconOrig = "level-deluxe";
                        } elseif ($paidMemberOrig == True && $fanaticStyleOrig == True) {   
                          $levelIconOrig = "level-fanatic";
                        } elseif ($paidMemberOrig == True) {  
                          $levelIconOrig = "level-classic";
                        } else {
                          $levelIconOrig = "";
                        }
                        
                        ?>
                        <!-- Comment item starts -->
                        <div class="comment clearfix row row-over">
                          <!-- Commenter profile pic -->
                          <div class="col-xs-2 col-sm-1 row-over comment-pic-bar">
                            <!-- To change profile pic image, need just change "comment-user-prof-pic" div's "backgroud-image" style url -->
                            <div class="comment-user-prof-pic" style="background-image: url(<?php
                            if (!empty($MiniPicPathOrig)) {
                              echo $MiniPicPathOrig;
                            } else {
                              echo "/images/anonymousBPmember2.jpg";
                            } 
                            ?>)">
                            </div>
                          </div>

                          <div class="col-xs-10 col-sm-10 row-over comment-text-bar">
                            <p class="comment-user">
                            <a href="gallerySorter.php?memberID=<?php echo $memberIDQ ?>"><?php echo $memberNameOrig ?></a>
                            <?php
                            if ($memberIDQ == 124) {
                              echo '<a href="/online-photography-courses.php"><img class="comment-username-level" src="/images/' . $levelIconOrig . '.png" alt="' . $levelIconOrig . '"> My Courses</a>';
                            } elseif (!empty($levelIconOrig)) {
                              echo '<a href="/levels.php"><img class="comment-username-level" src="/images/' . $levelIconOrig . '.png" alt="' . $levelIconOrig . '"></a>';
                            }
                            ?><!-- Shows which level has user -->
       
                            <span class="comment-calendar"><?php echo $dateCreatedOrig ?></span><!-- Shows when the comment was left -->
                            <span class="love-comment">
                            <?php
                            $notYetFavedDisc = 0;

                            if (!empty($memAuth)) {  //         Session("memberID") != "" Then 
                              // sp_CheckExistenceOfMemberFavDiscussionByMemberID   memAuth        
                              $q="SELECT favID FROM DiscussionsFavorites WHERE favInputID = " . $discussThreadID . " AND memberID = " . $memAuth;
                              $dataChk1 = mysqli_query($conn, $q);
                              $tCountD=mysqli_num_rows($dataChk1); 
                              if ($tCountD == 0){

                                $notYetFavedDisc = 1;
                                // not a favorite yet, show add link
                                echo "<a href='/faver-commentSQL.php?ai=1&id=" . $discussThreadID . "&photoID=" . $photoID . "&courseID=" . $courseID . "&notifyDiscer=" . $notifyDiscOrig . "&mIDLoved=" . $memberIDQ . "' title='Love this comment'>";
                              }
                            }
                            echo sb_FavoriteDiscussionCount($conn, $discussThreadID);
                            echo '<i class="fa fa-heart"></i>';
                            if ($notYetFavedDisc == 1) {
                              echo '<font size="-1">love it</font></a>';
                            }
                            ?></span><!-- Show how many love its has comment -->
                                </p>
                                <span class="comment-text"><?php echo $inputMemo ?> <font size="-2" color="grey">#<?php echo $discussThreadID ?></font></span><!-- Main comment text -->

                          </div> <!-- comment-text-bar -->
                        </div><!-- Comment item ends -->
                        <?php 
                        // find all records in discussion Responses table that have this threadID 
                        // sp_FindDiscussion ResponsesBythreadID     
                        $q="SELECT inputID, inputMemo, DATE_FORMAT(dateCreated, '%M %d, %Y') as dateCreated, memberID, notifyMember FROM DiscussionResponses WHERE threadID = " . $discussThreadID . " AND status != 'ARC' ORDER BY inputID";
                      
                      
                        if ($resultsA = mysqli_query($conn, $q)) {
                          while ($dataA = mysqli_fetch_assoc($resultsA)) {

                            $inputIDA = $dataA['inputID'];
                            $inputMemoA = $dataA['inputMemo'];
                            /* 
                            inputMemo = Replace(Replace(inputMemo,"</b>",""),"<b>","")
                            inputMemo = Replace(Replace(inputMemo,"http://lsqrd.blogspot.com/",""),"blogspot","")
                            inputMemo = Replace(Replace(inputMemo,"<font color=""#195CB7""><b>",""),"<b><font color=gray><br>","")
                            */
                            $dateCreatedA = $dataA['dateCreated'];
                            $memberIDA = $dataA['memberID'];
                            $notifyDiscLoved = $dataA['notifyMember']; // for if this comment gets loved
                            if (!empty($memAuth) && is_null($memberIDA) == false) {
                              if ($memAuth == $memberIDA) { //  the comment is by logged-in user
                                $notifyAdditionalCommenter = $dataA['notifyMember'];
                              }
                            }
                            
                            // sp_GetMemberInfoByMemberID 
                            $q="SELECT email, MiniPicPath FROM Members WHERE memberID = " . $memberIDA;
                            if ($resultMA = mysqli_query($conn, $q)) {
      //$emailDiscA = $dataMA['email'];
                              while ($dataMA = mysqli_fetch_assoc($resultMA)) {
                                $MiniPicPathDiscA = $dataMA['MiniPicPath'];
                              }
                              
                              if (!empty($MiniPicPathDiscA)) {
                                //$MiniPicPathDiscA = str_replace("\","/",$MiniPicPathDiscA);
                              }
                            }
                            
                            $memberNameDiscA = "";

      $fanaticStyleA = false;                      
                            $paidMemberA = false;
                            //sp_FindMemberPaidGallery      
                            $paidMemberA = check_paidGalleryOwner($conn, $memberIDA);

                            $memberNameDiscA = get_full_member_name($conn, $memberIDA);  

                            // go find all Deluxe    memberIDA
                            $postDeluxeA = '';
                            $q="SELECT post, dateImageSalesPaid FROM DeluxeSites WHERE memberID = ".$memberIDA." AND dateExpiration is not null ORDER BY post desc, siteID DESC";
                            $stmt =  $conn->query($q);
                            while ($rsWebA = $stmt->fetch_array()) { 
                              $postDeluxeA = $rsWebA['post']; // they gave a paid website
                              $dlxdateProPaidA = $rsWebA['dateImageSalesPaid']; 
                            }

                            if ($postDeluxeA == "Yes" && is_null($dlxdateProPaidA) == false) { // PRO site     
                              $levelIconDiscA = "level-addict";
                            } elseif ($postDeluxeA == "Yes" && is_null($dlxdateProPaidA) == True) {   // DLX site 
                              $levelIconDiscA = "level-deluxe";
                            } elseif ($paidMemberA == True && $fanaticStyleA == True) {   
                              $levelIconDiscA = "level-fanatic";
                            } elseif ($paidMemberA == True) {  
                              $levelIconDiscA = "level-classic";
                            } else {
                              $levelIconDiscA = "";
                            } 
                              
                            ?>
                            <div class="comment clearfix row row-over">
                              <div class="col-xs-2 col-sm-1 row-over comment-pic-bar">
                                <div class="comment-user-prof-pic" style="background-image: url(<?php
                                  if (!empty($MiniPicPathDiscA)) {
                                    echo $MiniPicPathDiscA;
                                  } else {
                                    echo "/images/anonymousBPmember2.jpg";
                                  } 
                                  ?>)">
                                </div>
                              </div>

                              <div class="col-xs-10 col-sm-10 row-over comment-text-bar">
                                <p class="comment-user">
                                <a href="gallerySorter.php?memberID=<?php echo $memberIDA ?>"><?php echo $memberNameDiscA ?></a>
                                <?php
                                if ($memberIDA == 124) {
                                  echo '<a href="/online-photography-courses.php"><img class="comment-username-level" src="/images/' . $levelIconOrig . '.png" alt="' . $levelIconOrig . '"> My Courses</a>';
                                } elseif (!empty($levelIconDiscA)) {
                                  echo '<a href="/levels.php"><img class="comment-username-level" src="/images/' . $levelIconDiscA . '.png" alt="' . $levelIconDiscA . '"></a>';
                                }
                                ?>
                                <span class="comment-calendar"><?php echo $dateCreatedA ?></span>
                                  <span class="love-comment">
                                <?php 
                                $notYetFavedDiscR = 0;

                                if (!empty($memAuth)) {

                                  // sp_CheckExistenceOfMemberFavDiscussionResponseByMemberID         
                                  $q="SELECT favID FROM DiscussionResponsesFavorites WHERE favInputID = " . $inputIDA . " AND memberID = " . $memAuth;
                                  $dataChkDR = mysqli_query($conn, $q);
                                  $tCountDR=mysqli_num_rows($dataChkDR); 
                                  if ($tCountDR == 0){

                                    $notYetFavedDiscR = 1;
                                    // not a favorite yet, show add link
                                    echo "<a href='/faver-commentSQL.php?ai=2&id=" . $inputIDA . "&photoID=" . $photoID . "&courseID=" . $courseID . "&notifyDiscer=" . $notifyDiscLoved . "&mIDLoved=" . $memberIDA . "' title='Love this comment'>";
                                  }

                                }
                                echo sb_FavoriteDiscussionResponseCount($conn, $inputIDA) ?><i class="fa fa-heart"></i><?php 
                                 if ($notYetFavedDiscR == 1) {
                                    echo '<font size="-1">love it</font></a>';
                                  }
                                  echo '</span> </p> <span class="comment-text">' . $inputMemoA . ' <font size="-2" color="grey">#' . $inputIDA;
                                  ?></font></span>
                              </div> 
                            </div>

                          <?php
                          } // answers while
                        } // answers if 
                      } // thread while 
                    } // End If  any existing comments or thread  
                  } else { 
                    ?>
                    Be the first... <?php if (empty($memAuth)) echo "Sign in and then"; ?> comment below.
                  <?php
                  } // End If a discussThreadID
                  ?>

                  </div><!-- Comments area ends -->
                  <!-- Comment Textarea starts -->
                  <div class="comment-textarea">
                    <?php 
                    if (!empty($memAuth)) { ?>
                      <form method="post" action="" id="commInput" name="commInput">
                      <textarea name="input" placeholder="Comment...<?php 
                      if ($critiquePrefGrow1 == "GROW") {
                        echo "Tell me what's great and, if anything, what can be improved!";
                      }else{
                        echo "Just tell me what is great!";
                      }
                      ?>"></textarea>
            
                      <div class="checkbox">
                        <label>
                          <input TYPE="checkbox" NAME="notifyMemberInTheFuture" VALUE="Yes" <?php 
                          if ($memAuth == $phMemberID) { // this is commenter's photo 
                            if ($notifyPh == "Yes") { // i as photog want notification 
                                echo "checked";
                            }
                          } elseif ($memAuth == $notifyDiscOrig) { //commenter is original discusser 
                            if ($notifyDiscOrig == "Yes") { // i as orig discusser want notice  
                              echo "checked";
                            }
                          } elseif (!empty($notifyAdditionalCommenter)) { // commenter is additional discusser, flagged above 
                            if ($notifyAdditionalCommenter == "Yes") { // i as additional discusser want notice  
                              echo "checked";
                            } 
                          } else { // global 
                            if ($emailNotifyDefaultCA1 == 1) {
                              echo "checked";
                            }
                          } 
                          ?>>&nbsp;&nbsp;Notify&nbsp;me&nbsp;of&nbsp;future&nbsp;comments
                        </label>
                      </div>

                      <input type="Hidden" name="topic" value="<?php echo $photoTitle ?>">
                      <input type="Hidden" name="memberID" value="<?php echo $memAuth ?>">
                      <input type="Hidden" name="photoID" value="<?php echo $photoID ?>">
                      <input type="Hidden" name="notifyPh" value="<?php echo $notifyPh ?>">
                      <input type="Hidden" name="emailPh" value="<?php echo $emailPh ?>">
                      <input type="Hidden" name="firstNamePh" value="<?php echo $firstNamePh ?>">
                      <input type="Hidden" name="memberNamePh" value="<?php echo $memberNamePh ?>">

                      <input type="Hidden" name="inputType" value="<?php echo $inputType ?>">
                      <input type="Hidden" name="threadID" value="<?php echo $discussThreadID ?>">

                      <input type="Hidden" name="notifyDiscOrig" value="<?php echo $notifyDiscOrig ?>">
                      <input type="Hidden" name="emailOrig" value="<?php echo $emailOrig ?>">
                      <input type="Hidden" name="firstNameOrig" value="<?php echo $firstNameOrig ?>">
                      
                      <input type="Hidden" name="catID" value="<?php if ($catID != "966") echo $catID ?>">
                      <input type="Hidden" name="contestCatID" value="<?php echo $contestCatID ?>"> 
                      <input type="Hidden" name="camID" value="<?php echo $camID ?>">
                      <input type="Hidden" name="mem4gall" value="<?php echo $mem4gall ?>">
                      <input type="Hidden" name="mem4show" value="<?php echo $mem4show ?>">
                      <input type="Hidden" name="mem4Wins" value="<?php echo $mem4Wins ?>">
                      <input type="Hidden" name="sortBye" value="<?php echo $sortBye ?>">
                      <input type="Hidden" name="FavMemID" value="<?php echo $FavMemID ?>">
                      <input type="Hidden" name="Favpt" value="<?php echo $Favpt ?>">
                      <input type="Hidden" name="start" value="<?php echo $start ?>">
                      <input type="Hidden" name="rowNumber" value="<?php echo $rowNumber ?>">
                      <input type="Hidden" name="rowsPerPage" value="<?php echo $rowsPerPage ?>">

                      <button class="btn btn-main btn-orange btn-send-comment">Send</button>
                      <input type="hidden" name="recaptcha_response" id="recaptchaResponse">
                      </form>
                    <?php     
                    } else { ?>
                      <br><font size="-1">To discuss, first log in or sign up (buttons are at top center of page).</font>
                    <?php 
                    }
                    ?>
                  </div><!-- Comment Textarea ends -->

                <?php
                } // if showing public comments
                ?>
                

              </div><!-- Comments bar ends -->

              <!-- Did you know bar starts -->
              <div class="description">
                
                <?php 
                if (empty($courseID)) {
                  echo "<h3>Get Constructive Critiques</h3>";

                  echo "<p>Sign up for an <a href='/online-photography-courses.php'>interactive online photography course</a> to get critiques on your photos.</p>";
                }
                ?>

                
<!--  Final HOURS of                Last Chance for        Reopen for one day onl
<h2><a href="/levels.php">2-for-1 Super Sale. Extended until...</a></h2>   

<script language="javascript">
      var test1 = new Countdown({
            year  : 2021, 
            month : 10, 
            
            day   : 06,  
            hour  : 11,
        ampm  : "pm",
        hideLine  : true,
//style     : "boring",   // "flip" or "boring" (only "flip" uses image/animation)
        rangeHi   : "day",  
        minute  : 59, 
        second  : 59,
        numbers   :   {
          font  : "Arial", // Arial Times Verdana etc... see "numberMarginTop" above to correct vertical centering
          color : "#FFFFFF",
          bkgd  : "#ff8f00",
          rounded : 0.15,       // percentage of size 
          shadow  : {
                x : 0,      // x offset (in pixels)
                y : 3,      // y offset (in pixels)
                s : 4,      // spread
                c : "#000000",  // color
                a : 0.4     // alpha  // <- no comma on last item!
                }
          },  
        labels    :   {
          font  : "Arial",
          color : "#000000",
          weight  : "normal"
          }     
      });
    </script>
-->

    <!-- <h3><strong>Sale!</strong> <strike><font color="#ff0000">$199</font></strike> just $99 <br><a href=/course-better-backyard-photography.php>Better Backyard Photography</a> </h3>
    <div>

      and <a href=/online-photography-courses.php>Interactive Courses</a> "Last Chance" 

    <div> 
    <br><strong><a href="/online-photography-courses.php">Take a photography class... sale ends:</a></strong>
    </div> 
    

    <script language="javascript">
      var test1 = new Countdown({
            year  : 2021, 
            month : 10, 
            
            day   : 06,  
            hour  : 11,
        ampm  : "pm",
        hideLine  : true,
//style     : "boring",   // "flip" or "boring" (only "flip" uses image/animation)
        rangeHi   : "day",  
        minute  : 59, 
        second  : 59,
        numbers   :   {
          font  : "Arial", // Arial Times Verdana etc... see "numberMarginTop" above to correct vertical centering
          color : "#FFFFFF",
          bkgd  : "#ff8f00",
          rounded : 0.15,       // percentage of size 
          shadow  : {
                x : 0,      // x offset (in pixels)
                y : 3,      // y offset (in pixels)
                s : 4,      // spread
                c : "#000000",  // color
                a : 0.4     // alpha  // <- no comma on last item!
                }
          },  
        labels    :   {
          font  : "Arial",
          color : "#000000",
          weight  : "normal"
          }     
      });
    </script>
-->
                  <?php
                  echo "<br>&nbsp;<br>";
                  echo "<h3>Did You Know?</h3>";

                  // echo "<p><strong>TITLE:</strong></p>";
/*
We do not allow photos or links that are clearly business ads (aka spam).

"<p><strong>Social Bar Hiding:</strong> If it's blocking items on the page that you'd like to see, you can hide the social media bar on the left by clicking the small x at the bottom. Using the buttons on this bar to help share BetterPhoto with others helps us thrive.</p>";


                  echo "<p><strong>Title Your Photo:</strong> Giving your photo a title will help identify it for the future. To help people find your photo when they are searching, give it a unique title perhaps including a specific place, name, or descriptive phrase. </p>";

                  echo "<p><strong>Photo of the Day by Member:</strong> You can view POTD's by a particular member <a href=/contest/leaderboard-potd.php>by checking out the POTD leaderboards</a>.</p>";

                  echo "<p><strong>Camera Settings:</strong> Giving data on your camera settings helps others to learn and practice. Google how to view EXIF data and add this on the Manage/Enter page in your Profile. </p>";

*/
                  echo "<p><strong>Discussions by Category:</strong> You can view photo discussions on various themes in the Community > Photo Discussions section of the site. </p>";

                  echo "<p><strong>BetterPhoto Websites:</strong> If you see an orange website link directly under the photographer's name, it's totally okay. It's not spam. The reason: BetterPhoto is the one that offers these personal photography websites. We are supporting our clients with those links.</p>";
                  echo "<p><strong>Unavailable EXIF:</strong> If there is no other information but 'Unavailable' in the EXIF (meaning no EXIF data exists with the photo), the 'Unavailable' blurb is not displayed. If there is any info, it shows. Many photos have the EXIF stripped out when people modify the image and resave it, before uploading. </p>";


                  echo "<br>&nbsp;<br><p><strong>The following truth</strong> is one of the core philosophies of BetterPhoto: </p>";
                  echo "<p>I hear, I forget.<br> I see, I remember.<br>I do, I understand. </p>";
                  echo "<p>You learn by doing. Take your next <a href='/online-photography-courses.php'>online photography class</a>. </p>";

                  ?>


                </div><!-- Did you Know bar ends -->
              </div><!-- Comment . Description Bar Ends -->
            </div><!-- Image div ends -->

      
      <!-- Love it button starts -->
      <div class="love-button">
      <?php 

      // get prev and next if they exist
      $prevPhotoID = 0;
      $nextPhotoID = 0;

      $pics4PNstr = $_GET['pics4PNstr'] ?? '';
      $photos4PNarr = array();
      $photos4PNarr = explode(",",$pics4PNstr);

      // from this qstring array and calculate positions to call for prev and next

      $prevRow = max($rowNumber-2,0);  // since array starts at zero
      if ($rowNumber == 1 && $start == 0) { // first image of FIRST page  
        $prevPhotoID = 0; // no arrow
      } elseif ($rowNumber == 1) { // first image of a 2nd, 3rd, etc page  
        $prevPhotoID = 1; // this will send then to prev dynoGallPage
      } else {
        $prevPhotoID = $photos4PNarr[$prevRow];
      }

      $nextRow = $rowNumber; // since array starts at zero
      if ($nextRow >= $rowsPerPage && $justPhotoID == 0) {
        $nextPhotoID = 1; // this will send then to next dynoGallPage
      } else {
        $nextPhotoID = $photos4PNarr[$nextRow];
      }

// last image of last page ?

      
      if (!empty($memAuth)) { 
        // sp_CheckExistenceOfMemberFavPhotoByMemberID                 
        $q="SELECT favID FROM  PhotoFavorites WHERE favPhotoID = " . $photoID . " AND memberID = " . $memAuth;
        $resultFct=mysqli_query($conn,$q);
        $tCountFct=mysqli_num_rows($resultFct);
        if ($tCountFct == 0) { 
          // not a favorite photo yet, show add link
          echo "<a href='/faver-photoSQL.php?ai=1&id=" . $photoID;
          if ($nextPhotoID > 1) {
            echo "&nid=" . $nextPhotoID;
          }
          echo "&courseID=" . $courseID . "' title='Add to My Favorite Photos'>";
        }
      } else {
        echo "<a data-toggle='modal' data-target='#loginModal' title='Log in to Favorite Photos'>";
      }
       ?><i class="fa fa-heart"></i>
              <div class="love-it-count">
          <p class='not-loved-it'><?php sb_FavoritePhotoCount($conn, $photoID) ?></p><!-- Shows by default hover -->
          <p class='loved-it'>You &amp; <?php sb_FavoritePhotoCount($conn, $photoID) ?></p>
                <p>Love It!</p></a>
              </div>
            </div><!-- Love it button starts -->

      <?php   
      if (!empty($pics4PNstr)) {  //  !empty($prevPhotoID) || !empty($nextPhotoID
        if (!empty($prevPhotoID)) {
          if ($prevPhotoID == 1) { // at the end of the set
            echo "<div class='prev-button'><a href='dynoGall2.php?catID=" . $catID . "&cn=" . $cn . "&sortBye=" . $sortBye . "&contestCatID=" . $contestCatID . "&courseID=" . $courseID . "&camID=" . $camID . "&mem4gall=" . $mem4gall . "FavMemID=" . $FavMemID . "&Favpt=" . $Favpt . "&s=" . ($start - $rowsPerPage) . "&rowsPerPage=" . $rowsPerPage . "&pics4PNstr=" . $pics4PNstr . "' TITLE='PREVIOUS PAGE'><i class='fa fa-angle-left'></i></a></div>";
          } else {
            echo "<div class='prev-button'><a href='dynoGallDetail.php?photoID=" . $prevPhotoID . "&catID=" . $catID . "&contestCatID=" . $contestCatID . "&courseID=" . $courseID . "&camID=" . $camID . "&mem4gall=" . $mem4gall . "&mem4show=" . $mem4show . "&mem4Wins=" . $mem4Wins . "&sortBye=" . $sortBye . "&FavMemID=" . $FavMemID . "&Favpt=" . $Favpt . "&cn=" . $cn . "&rowNumber=" . ($rowNumber - 1) . "&rowsPerPage=" . $rowsPerPage . "&s=" . $start . "&pics4PNstr=" . $pics4PNstr . "' TITLE='PREVIOUS PHOTO'><i class='fa fa-angle-left'></i></a></div>";
          }
        }

        if (!empty($nextPhotoID)) {
          if ($nextPhotoID == 1) { // at the end of the set
            echo "<div class='next-button'><a href='dynoGall2.php?catID=" . $catID . "&cn=" . $cn . "&sortBye=" . $sortBye . "&contestCatID=" . $contestCatID . "&courseID=" . $courseID . "&camID=" . $camID . "&mem4gall=" . $mem4gall . "FavMemID=" . $FavMemID . "&Favpt=" . $Favpt . "&s=" . ($start + $rowsPerPage) . "&rowsPerPage=" . $rowsPerPage . "&pics4PNstr=" . $pics4PNstr . "' TITLE='NEXT PAGE'><i class='fa fa-angle-right'></i></a></div>";
          } else {
            echo "<div class='next-button'><a href='dynoGallDetail.php?photoID=" . $nextPhotoID . "&catID=" . $catID . "&contestCatID=" . $contestCatID . "&courseID=" . $courseID . "&camID=" . $camID . "&mem4gall=" . $mem4gall . "&mem4show=" . $mem4show . "&mem4Wins=" . $mem4Wins . "&sortBye=" . $sortBye . "&FavMemID=" . $FavMemID . "&Favpt=" . $Favpt . "&cn=" . $cn . "&rowNumber=" . ($rowNumber + 1) . "&rowsPerPage=" . $rowsPerPage . "&s=" . $start . "&pics4PNstr=" . $pics4PNstr . "' TITLE='NEXT PHOTO'><i class='fa fa-angle-right'></i></a></div>";
          }
        }
        
      } // End If prev next  
      ?>


<!--

  150  x 78  GEM

-->

    <div style="width:180px; margin:0 auto;"> 
      <?php 
      $isAllTime = "";
      if ($contestWinner != 'EPEPEP') $isAllTime = left(right($contestWinner,2),1);
      if ($isAllTime == "E") { ?><a href="/gallery/dynoGall2.php?catID=66541&cn=All-Time-Best-Photography-Contest-Editors-Picks"><img src="/images/photography-all-time-editors-pick.png" class="img-responsive img-center" width="150" height="89" alt="BetterPhoto.com All Time Best Photo Contest Editor's Pick" border="0"></a><?php } elseif ($isAllTime == "V") { ?><br><a href="/gallery/dynoGall2.php?catID=66665&cn=All-Time-Best-Photography-Contest-Staff-Favorites"><img src="/images/photography-all-time-staff-fav.png" class="img-responsive img-center" width="150" height="89" alt="BetterPhoto.com All Time Best Photo Contest Staff Favorite" border="0"></a><?php } elseif ($isAllTime == "N") { ?><br><a href="/gallery/dynoGall2.php?catID=66666&cn=All-Time-Best-Photography-Contest-Finalists"><img src="/images/photography-all-time-finalist.png" class="img-responsive img-center" width="150" height="78" alt="BetterPhoto.com All Time Best Photo Contest Finalist" border="0"></a><?php } elseif ($isAllTime == "W") { ?><br><a href="/gallery/dynoGall2.php?catID=66667&cn=All-Time-Best-Photography-Contest-Winners"><img src="/images/photography-all-time-winner.png" class="img-responsive img-center" width="150" height="79" alt="BetterPhoto.com All Time Best Photo Contest Winner" border="0"></a><?php } ?>
      <?php if (right($contestWinner,1) == "0") { ?>
      <a href="/contest/winners.php"><img src="/images/photography-contest-grand-prize-winner.png" class="img-responsive img-center" width="150" height="78" alt="BetterPhoto.com Photo Contest GRAND PRIZE Winner" border="0"></a><?php } elseif (right($contestWinner,1) == "1") {  ?>
      <a href="/contest/winners.php"><img src="/images/photo-contest-first-place.png" class="img-responsive img-center" width="150" height="78" alt="BetterPhoto.com Photo Contest FIRST PLACE Winner" border="0"></a><?php } elseif (right($contestWinner,1) == "2") {  ?>
      <a href="/contest/winners.php"><img src="/images/photo-contest-second-place.png" class="img-responsive img-center" width="150" height="78" alt="BetterPhoto.com Photo Contest SECOND PLACE Winner" border="0"></a><?php } elseif (right($contestWinner,1) == "F") { ?>
      <a href="/contest/finalists.php"><img src="/images/photo-contest-finalist.png" class="img-responsive img-center" width="150" height="78" alt="BetterPhoto.com Photo Contest Finalist" border="0"></a><?php } elseif (right($contestWinner,1) == "S") {  ?><a href="/contest/staffFavorites.php"><img src="/images/betterphoto-staff-favorite-photo.png" class="img-responsive img-center" width="150" height="89" alt="BetterPhoto.com Staff Favorite" border="0"></a><?php } elseif ($isEC == 1 && $Favpt != "EPs") { ?><br><a href="/contest.php"><img src="/images/photography-editors-pick.png" class="img-responsive img-center" width="150" height="89" alt="BetterPhoto.com Editor's Pick" border="0"></a></a>
      <?php } 
      if ($isPOTD == 1 && strpos(strtolower($cn),"photo-of-the-day") == 0) { ?><a href="/gallery/dynoGall2.php?catID=4125&cn=Photo-of-the-Day"><img src="/images/photo-of-the-day-daily-winner.png" class="img-responsive img-center" width="150" height="89" alt="Photography Contest Photo of the Day" border="0"></a>
      <?php } 

      if ($isGOTD == 1) { ?><a href="/gallery/dynoGall2.php?catID=69384&cn=Gem-of-the-Day"><img src="/images/photography-contest-gem-of-the-day.png" width="150" height="78" alt="Photography Contest Gem of the Day" border="0"></a>
      <?php }
      $crewRole  = '';
      $q="SELECT role FROM MemberVolunteers WHERE memberID = " . $phMemberID;
      $stmt =  $conn->query($q);
      while ($rsMembV = $stmt->fetch_array()) { 
        $crewRole = $rsMembV['role'];
      }
      if (!empty($crewRole)) { 
        echo '<a href="/volunteers.php"><img src="/images/betterphoto-crew-volunteers.jpg" width="150" height="86" alt="BetterPhoto Crew: ' . $crewRole . '"></a>';
      }
      ?>
    </div> 
     
    <div align="center">
      <p id="smallBrightTextOnDark"><br>Copyright for this photo belongs solely to <?php if (!empty($memberNamePh)) echo $memberNamePh ?>. <br>Images may not be copied, downloaded, or used in any way without the expressed, written permission of the photographer. 
      <?php 
      showGalleryIfPaidGalleryOwner($conn, $phMemberID, "Contact photographer via gallery", 'contact');
      if (!empty($memAuth)) { 
        sb_link2SendPrivateMemberMessage($phMemberID);
        sb_MemberFavoritePhotographer($conn, $memAuth, $phMemberID);
        ?><br>
        <a href="reportPhoto.php?ID=<?php echo $photoID ?>&courseID=<?php echo $courseID ?>">Report this photo</a><?php 
      } else {
        ?> <br>
        Log in to follow or message this photographer or report this photo. <?php 
      } ?>
      
      </p>
    </div>
    

      </div> <!-- item ends -->

    </div> <!-- column ends -->
    </div> <!-- container ends -->
    
    </section><!-- Photo Feed Content Ends -->


    <?php 
  } else { //  if Post = Yes
    ?> 
    <div style="padding-left:10px;">
      <br clear=all /><br />
      
      <div align="center">
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<h2>Nothing to See Here... </h2> 
      <p>
        This photo has been removed, or set to private. The website owner likely is only wants to publish it on his or her BetterPholio Website. 
      </p>
      <p>
        Either way, the photo you have requested is not set to publically display here. <a href="/home.php">Return.</a>
      </p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
      </div>
    </div>
    <?php 
  } // End If
  
} else { // if photo found in db
  ?>  
  <div style="padding-left:10px;">
    <br clear=all /><br />
    <h2>Photo Not Found</h2>
    <p>Sorry - the photo you have requested is not available. <?php if (!empty($originURL)) {
        echo '<a href="' . $originURL . '">Return.</a>';
        }
        ?></p>
    <p>&nbsp;</p>
  </div>
  <?php 
} // End if photo found in db

require '../incFoot.php'; 
?>
<script type="text/javascript" src="/js/comments-bar.js"></script>
<script type="text/javascript" src="/js/like.js"></script>
</body>
</html>