<?php
/**
* photos.htm
*
* Display the Dallas Sierra Club photo gallery.
*
* This program displays both the list of photo gallery categories and the photos
* in those galleries.
*
* @caterory     Dallas Sierra Club
* @package      website, photo gallery
* @author       Arthur Kuehne
* @copyright    2012 Sierra Club
* @version      1.0
* @link         http://www.dallassierraclub.org/photos.htm
*
*/
    session_start();
    $UserName = $_SESSION['UserName'];
    $AuthLevel = $_SESSION['AuthLevel'];
    $PageError = $_SESSION['PageError'];
    
    include ('DSC-include-DatabaseConfig.php');
    
    //process the GET string
    if (isset($_GET['c'])) {
        $photoGalleryControl = $_GET['c'];
        if (isset($_GET['i'])) { 
            $photoImageControl = $_GET['i'];
        } else {
            $photoImageControl = 1;
        }
    } else {
        $photoGalleryControl = 0;
        $photoImageControl = 0;
        unset($_SESSION['photos'], $_SESSION['photoCount']);
    }
    
    //be sure what we got from the GET string are numbers (not user monkey business)
    if ((!is_numeric($photoGalleryControl)) || (!is_numeric($photoImageControl))) {
        header("Location: photos.htm");
        exit();
    }
    
    //if the session photocount is set, be sure GET[i] is a valid number
    if (isset($_SESSION['photoCount'])) {
        if (($photoImageControl < 1) || ($photoImageControl > $_SESSION['photoCount'])) {
            header("Location: photos.htm");
            exit();
        }
    }
    
    // If we got here from a link (not from within photos.htm), then the stored session information will 
    // not be available, so we must rebuild it.    
    if (($photoGalleryControl > 0) && (!isset($_SESSION['photos']))) {
        //open the database
        $db_conn = new mysqli(DSC_DB_SERVER, DSC_DB_USER, DSC_DB_PASSWORD, DSC_DB_DATABASE);
        if (mysqli_connect_errno()) {
            echo 'Connection to database failed: ' . mysqli_connect_error();
            exit();
        }
        //build query
        $queryString = "SELECT * FROM photos WHERE categoryid = " . mysqli_real_escape_string($db_conn, $photoGalleryControl) . " ORDER BY sortnumber ASC";
        //get the results from the database
        $result = $db_conn->query($queryString);
        $_SESSION['photoCount'] = $numberOfResults = $result->num_rows;
        //check the number of results - if 0 then something is wrong, so got back to the list of galleries
        if ($numberOfResults == 0) { 
            header("Location: photos.htm");
            exit();
        }
        for ($i = 0; $i < $numberOfResults; $i++) {
            $row = $result->fetch_assoc();
            $photo[$i]['photoid']             = $row['photoid'];
            $photo[$i]['photographer']        = stripslashes($row['photographer']);
            $photo[$i]['photocaption']        = stripslashes($row['photocaption']);
            $photo[$i]['photowidth']          = stripslashes($row['photowidth']);
            $photo[$i]['photoheight']         = stripslashes($row['photoheight']);
        }
        $_SESSION['photos'] = $photo;
        
        //check the gallery name array - if it is empty, we got here via a link (not from the gallery list) so we need to rebuild it
        if (!isset($_SESSION['categories'])) {
            $queryString = "SELECT * FROM photocategory WHERE approved = '1' ORDER BY categorydate DESC";
            //get the results from the database
            $result = $db_conn->query($queryString);
            $numberOfResults = $result->num_rows;
            for ($i = 0; $i < $numberOfResults; $i++) {
                $row = $result->fetch_assoc();
                $catID                           = $row['categoryid'];
                $cat[$catID]['categoryid']       = $row['categoryid'];
                $cat[$catID]['categoryname']     = stripslashes($row['categoryname']);
                $cat[$catID]['categorydate']     = $row['categorydate'];
            }
            
            $_SESSION['categories'] = $cat;
        }
        
        mysqli_close($db_conn);
    }
    
    
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <link rel="shortcut icon" href="/favicon.ico" />
        <meta name="keywords" content="dallas sierra club, dallas sierra club photo page, environment, environmental, outings, conservation, singles, ico, inner city outings" />
        <meta name="description" content="The Sierra Club is America's oldest, largest, and most influential grassroots environmental organization." />
        <title>Dallas Sierra Club</title>
        <link href="styles/dallas-widepage.css" type="text/css" rel="stylesheet" />

    
        <?php
            //calculate the URL for the next and previous images - we will need them for the buttons and for the 
            //javascript that watches the navigation keys
            if ($photoImageControl == 1) {
                $pervious = "";
            } else {
                $previous = "photos.htm?c=" . $photoGalleryControl . "&amp;i=" . ($photoImageControl - 1) ;    
                $previousjs =str_replace('&amp;', '&', $previous); 
            }
            if ($photoImageControl == $_SESSION['photoCount']) {
                $next = "";
            } else {
                $next = "photos.htm?c=" . $photoGalleryControl . "&amp;i=" . ($photoImageControl + 1) ;
                $nextjs = str_replace('&amp;', '&', $next);
            }
        ?>
        
        
        <?php
            // only allow this javascript if we are displaying photos - don't load for the list of galleries
            if ($photoGalleryControl > 0) {
        ?>
                <script type="text/javascript">
                    // This routine traps any keystrokes, and tests for whether the navigation keys have been used.
                    // The right arrow, down arrow and spacebar advance the image.
                    // The left arrow goes back one image.
                    // The up arrow goes back to the index.
                    function checkKeycode(e) {
                        var keycode;
                        if (window.event) {
                            keycode = window.event.keyCode;
                        } else if (e) {
                            keycode = e.which;
                        }
                        if ((keycode == "39") || (keycode == "32") || (keycode == "40")) {
                            if ("<?php echo $nextjs; ?>" != "") {
                                window.location = "<?php echo $nextjs; ?>";
                            }
                        } else if (keycode == "37") {
                            if ("<?php echo $previousjs; ?>" != "") {
                                window.location = "<?php echo $previousjs; ?>";
                            }
                        } else if (keycode == "38") {
                            window.location = "photos.htm";
                        }
                    }
                    document.onkeydown = checkKeycode;
                    
                    
                    // These two functions run at page load.
                    // Together they remember the amount the user has scrolled their screen
                    // and applies the same amount of scrolling to the next screen to load.
                    // This will keep the picture on the screen for users who have smaller screens.
                    // This seems to work in all modern browsers - not tested on old browsers.
                    
                    function detectScroll() {
                        var y = 0, scrolldelay;
                        //get the amount of scrolling, if any
                        if( typeof( window.pageYOffset ) == 'number' ) {
                            // Netscape
                            y = window.pageYOffset;
                        } else if( document.body && document.body.scrollTop ) {
                            // DOM
                            y = document.body.scrollTop;
                        } else if( document.documentElement && document.documentElement.scrollTop ) {
                            // IE6 standards compliant mode
                            y = document.documentElement.scrollTop;
                        }
                        window.name = y.toString(); //save scroll value in window.name as a string
                        //scrolldelay = setTimeout('detectScroll()', 250);  //check every 1/4 second
                    }
                    function jumpScroll() {
                        document.getElementById('bodytag').removeAttribute('style');
                        window.scrollBy(0, parseInt(window.name));
                        //document.getElementById('wrapper').style.display = 'hide';
                   }
                        
                </script>
        <?php
            } else {
                //reset the window.name if we are in the gallery list so we don't scroll it
                //and create some null functions
                echo "<script type='text/javascript'>\n";
                echo "    window.name = ''; \n";
                echo "    function jumpScroll() {\n";
                echo "        document.getElementById('bodytag').removeAttribute('style')\n";
                echo "    }\n";
                echo "    function detectScroll() {\n";
                echo "    }</script>\n";
            }
        ?>

        <?php
            include ('DSC-include-GoogleAnalytics.js');
        ?>

    </head>
    
    <body id="bodytag" onunload="detectScroll()" onload="jumpScroll()" style="display:none">
        <div id="wrapper">
        
            <?php
                include('DSC-include-Header.php');
            ?>
            
            
            <!-- beginning of left column -->
            <div id="column_main">  
                <div class="content">
                    <div id="pagefunctions2">
                    
                        <div style="margin-left: 80px">
                            <!-- AddThis Button BEGIN -->
                            <a class="addthis_button" href="http://www.addthis.com/bookmark.php?v=250&amp;username=dallassierraclub">
                            <img src="http://s7.addthis.com/static/btn/v2/lg-share-en.gif" width="125" height="16" alt="Bookmark and Share" style="border:0"/></a>
                            <script type="text/javascript">var addthis_config = {"data_track_clickback":true};</script>
                            <script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js#username=dallassierraclub"></script>
                            <!-- AddThis Button END -->
                        </div>
                        
                    </div>
                    <h1>
                        Dallas Sierra Club Photo Gallery
                    </h1>
                    
                    
                    <?php
                        //write to use log
                        date_default_timezone_set('America/Chicago');
                        $logFileOutput = date('Y-m-d H:i:s') . "\t" . $_SERVER["REQUEST_URI"] . PHP_EOL;
                        $logFile = "./logfiles/page-access-" . date('Ym') . ".log";
                        file_put_contents($logFile,$logFileOutput,FILE_APPEND);
                        
                        if ($photoGalleryControl == 0) { //display the gallery list
                            
                            echo "<h2>Click on an image to see more photographs.</h2><br />\n";
                        
                            //open the database
                            $db_conn = new mysqli(DSC_DB_SERVER, DSC_DB_USER, DSC_DB_PASSWORD, DSC_DB_DATABASE);
                            if (mysqli_connect_errno()) {
                                echo 'Connection to database failed: ' . mysqli_connect_error();
                                exit();
                            }
                            
                            $queryString = "SELECT * FROM photocategory WHERE approved = '1' ORDER BY categorydate DESC";
                            //get the results from the database
                            $result = $db_conn->query($queryString);
                            $numberOfResults = $result->num_rows;
                            for ($i = 0; $i < $numberOfResults; $i++) {
                                $row = $result->fetch_assoc();
                                $catID                           = $row['categoryid'];
                                $cat[$catID]['categoryid']       = $row['categoryid'];
                                $cat[$catID]['categoryname']     = stripslashes($row['categoryname']);
                                $cat[$catID]['categorydate']     = $row['categorydate'];
                            }
                            
                            $_SESSION['categories'] = $cat;
                            
                            $categoryCount = count($cat);
                            echo "<table style='width:100%' cellpadding='0' cellspacing='0'>\n";    
                            $j = 0;
                            foreach($cat as $i => $value) {
                                //get the number of photos in this category and a random photo id
                                $queryString = "SELECT photoid, photowidth, photoheight FROM photos WHERE approved = '1' AND categoryid = " . $i . " ORDER BY RAND()";
                                $result = $db_conn->query($queryString);
                                $photoCount = $result->num_rows;
                                if ($photoCount > 1) {
                                    $row = $result->fetch_assoc();
                                    $photoID     = $row['photoid'];
                                    $photoWidth  = $row['photowidth'];
                                    $photoHeight = $row['photoheight'];
                                    //do some scaling
                                    if ($photoWidth > $photoHeight) {
                                        $photoScale = 150 / $photoWidth;
                                    } else {
                                        $photoScale = 120 / $photoHeight;
                                    }
                                    //$scaledWidth = intval($photoWidth * $photoScale);
                                   // $scaledHeight = intval($photoHeight * $photoScale);
                                    $scaledWidth = intval($photoWidth * 0.20);
                                    $scaledHeight = intval($photoHeight * 0.20);
                                    $marginLeft = intval((150 - $scaledWidth) / 2);
                                
                                    $j++;
                                    $photoName = "../photos/dsc_img_tmb_" . $photoID . ".jpg";
                                    if ($j & 1) { 
                                        echo "<tr>\n";
                                        echo "<td valign='top' style='text-align:center; width:150px'>\n";
                                        echo "<a href='photos.htm?c=", $i, "&amp;i=1' title='Click to see all of the photos in this gallery section.'><img src='", $photoName, "' height='", $scaledHeight, "' width='", $scaledWidth, "' class='photobordersmall' alt='Click to see all of the photos in this gallery section.' /></a>\n";
                                        echo "</td>\n";
                                        echo "<td valign='top' style='width:310px;'>\n";
                                        echo "<p class='tableparagraph' style='margin-right:20px;'><strong>", $value['categoryname'], "</strong><br /><br />\n";
                                        echo $photoCount, " photographs</p>\n";
                                        echo "</td>\n";
                                    }
                                    if (!($j & 1)) { 
                                        echo "<td valign='top' style='text-align:center; width:150px;'>\n";
                                        echo "<a href='photos.htm?c=", $i, "&amp;i=1' title='Click to see all of the photos in this gallery section.'><img src='", $photoName, "' height='", $scaledHeight, "' width='", $scaledWidth, "' class='photobordersmall' alt='Click to see all of the photos in this gallery section.' /></a>\n";
                                        echo "</td>\n";
                                        echo "<td valign='top' style='width:290px;'>\n";
                                        echo "<p class='tableparagraph'><strong>", $value['categoryname'], "</strong><br /><br />\n";
                                        echo $photoCount, " photographs</p>\n";
                                        echo "</td>\n";
                                        echo "</tr>\n";
                                    }
                                    if (($categoryCount & 1) && ($categoryCount == $j)){
                                        echo "</tr>\n";
                                    }
                                    
                                }
                            }
                            echo "</table>\n";
                            mysqli_close($db_conn);
                            
                        } else {  //display an image
                        
                        
                            //display gallery name header
                            echo "<h2>", $_SESSION['categories'][$photoGalleryControl]['categoryname'],"</h2>\n";
                            echo "<p>&nbsp;</p>\n";
                            
                            //display buttons
                            echo "<div style='text-align:center'>\n";
                            if ($photoImageControl == 1) {
                                echo "<button style='font-size:x-small; width:60px;' name='prevButton' disabled='disabled'>Previous</button>\n";
                             } else { 
                                 echo "<button style='font-size:x-small; width:60px;' name='prevButton' onclick='window.location.href=\"", $previous, "\"' title='Previous Photo (you can also use your left arrow key)' value='Previous Photo (you can also use your left arrow key)'>Previous</button>\n";
                            }    
                            echo "<button style='font-size:x-small; width:200px; margin-left:20px; margin-right:20px;' onclick='window.location.href=\"photos.htm\"' title='Back to the Photo Gallery List' value='Back to the Photo Gallery List'>Back to the Gallery List</button>\n";
                            if ($photoImageControl == $_SESSION['photoCount']) {
                                echo "<button style='font-size:x-small; width:60px;' name='nextButton' disabled='disabled'>Next</button>\n";
                            } else {
                                 echo "<button style='font-size:x-small; width:60px;' name='nextButton' onclick='window.location.href=\"", $next, "\"' title='Next Photo (you can also use your right arrow key)' value='Next Photo (you can also use your right arrow key)'>Next</button>\n";
                            }
                            echo "</div>\n";
                            
                            //build image name
                            $photoName = "dsc_img_" . $_SESSION['photos'][$photoImageControl - 1]['photoid'] . ".jpg";
                            $photoNameFull = $_SERVER['DOCUMENT_ROOT'] . '/photos/' . $photoName;
                            
                            //get the image size and calculate the margin needed to get everything lined up for different sized photos
                            if ($_SESSION['photos'][$photoImageControl - 1]['photowidth'] > 0) {
                                $margin = (890 - $_SESSION['photos'][$photoImageControl - 1]['photowidth']) / 2;
                            } else {
                                $imageSize = getimagesize($photoNameFull);
                                $imageWidth = $imageSize[0];
                                $margin = (890 - $imageWidth) / 2;
                            }
                            
                        
                            //display file number and count        
                            echo "<div style='font-size:xx-small; margin-left:", $margin, "px; margin-right:", $margin, "px'>";                    
                            echo "<span style='float:left'>Image number: ", $_SESSION['photos'][$photoImageControl - 1]['photoid'], "</span><span style='float:right'>Image ", $photoImageControl, " of ", $_SESSION['photoCount'], "</span>\n";
                            echo "</div>\n";
                            
                            //display photo
                            echo "<div style='text-align:center'>\n";
                            //echo "<img src='../photos/", $photoName, "' ", " class='photoborder' alt='Dallas Sierra Club photo gallery' />\n";
                            echo "<img src='../photos/", $photoName, "' ", $imageSize[3], " class='photoborder' alt='Dallas Sierra Club photo gallery' />\n";
                            echo "</div>\n";
                            
                            //display photo credit
                            echo "<div style='font-size:xx-small; text-align:right; margin-right:", $margin, "px;'>\n";
                            echo "Photo credit: ", $_SESSION['photos'][$photoImageControl - 1]['photographer'], "\n";
                            echo "</div>\n";
                            
                            //display photo caption
                            echo "<div style='font-size:small; text-align:center; margin-left:", $margin + 20, "px; margin-right:", $margin + 20, "px; margin-top:5px;'>\n";
                            echo stripslashes($_SESSION['photos'][$photoImageControl - 1]['photocaption']), "\n";
                            echo "</div>\n";
                            
                            //pre-load the next image to speed things up
                            if ($photoImageControl != $_SESSION['photoCount']) { //get the next image name also, so we can preload it
                                $photoNameNext = "../photos/dsc_img_" . $_SESSION['photos'][$photoImageControl]['photoid'] . ".jpg";
                                echo "<div style='display:none'>\n";
                                echo "    <img src='", $photoNameNext, "' alt=' ' />\n";
                                echo "</div>\n";
                            }
                        }

                ?>                
                    
                    
                    
                </div>
            </div>
            <!-- end of left column -->
            
            
            
            <br style="clear:both" />
            <br />
            
            <!-- beginning of footer -->
            <?php
                include('DSC-include-Footer.php');
            ?>
            <!-- end of footer -->

        </div>
    </body>
</html>