
<?php

require("ini.inc");

require("auth.inc");

require("getTags.inc");



authSession($connection);



$cntThumb = 0;

$cntPhoto = 0;

$photoBodyHTML = "";



//Get the total number of photos

if ($_SESSION['admin']) {

    $query = "SELECT Count(PhotoID) FROM Photos";

}

else {

    $query = "SELECT Count(PhotoID) FROM Photos WHERE Public = 1";

}

if (!$result = @ mysql_query ($query, $connection))

       logError();

while ($tp = mysql_fetch_row($result)) {

    $totalphotos = $tp[0];

}



$pageNum = 1;

$rowsPerPage = 36;

$totalpages = ceil($totalphotos / $rowsPerPage);

if (isset($_GET['page'])) {

    $pageNum = $_GET['page'];

    if (!ctype_digit($pageNum) || $pageNum > $totalpages) {

        $pageNum = 1;

    }

}

$offset = ($pageNum - 1) * $rowsPerPage;







if ($_SESSION['admin']) {

    $query = "SELECT PhotoID, File, Title, Description, DateCreated, Public, Stub FROM Photos ORDER BY DateCreated DESC LIMIT $offset, $rowsPerPage";

}

else {

    $query = "SELECT PhotoID, File, Title, Description, DateCreated, Public, Stub FROM Photos WHERE Public = 1 ORDER BY DateCreated DESC LIMIT $offset, $rowsPerPage";

}

if (!$result = @ mysql_query ($query, $connection))

       printMySQLerror();

if (mysql_num_rows($result) == 0) {

    die("Couldn't find this photo!");

} 

else {

    while ($photo = mysql_fetch_array($result)) {

        $cntPhoto++;

        $photoID = $photo['PhotoID'];

        $photoFile = $photo['File'];

        $photoStub = $photo['Stub'];

        $photoSRC = str_replace(PHOTO_DIR, PHOTO_URL, $photoFile);

        $photoSRC = str_replace("\\", "/", $photoSRC);

        $photoTitle = $photo['Title'];

        $photoDescription = $photo['Description'];

        $photoDate = $photo['DateCreated'];

        $photoDateTitle = date("l, F jS",strtotime($photoDate));

        $photoDateTime = date("g:i A",strtotime($photoDate));

        $photoDateTimeMore = date("M jS, Y",strtotime($photoDate))." at ".$photoDateTime;

        $photoYear = date("Y",strtotime($photoDate));

        $thumbYearDir = THUMB_DIR . $photoYear;

        $thumbBaseFile = $thumbYearDir . "\\" . md5(SALT.$photoID);

        $thumbFile_m = $thumbBaseFile . "_m.jpg";

        $thumbSRC_m = str_replace(THUMB_DIR, THUMB_URL, $thumbFile_m);

        $thumbSRC_m = str_replace("\\", "/", $thumbSRC_m);

        list($width, $height, $type, $attr) = @getimagesize($photoFile);

        $widthCSS = ($width - 10);

        list($width_m, $height_m, $type_m, $attr_m) = @getimagesize($thumbFile_m);

        if ($photoDescription == "") {

            $captionCSS = "display:none;";

        }

        else {

            $captionCSS = "";

        }

        if ($cntThumb == 0) {

            //$photoBodyHTML .= '<h1 class="clsHeader" style="margin-top:30px;margin-bottom:0px;">Older Photos</h1>';

            $photoBodyHTML .= '<table cellspacing="5" cellpadding="5"><tr><td valign="top">';

        }

        if ($cntThumb & 1) {

            $photoBodyHTML .= "</td><td valign=\"top\">";

        }

        else {

            if ($cntThumb > 0) {

                $photoBodyHTML .= "</td></tr><tr><td valign=\"top\">";

            }

        }

        $cntThumb++;

        $photoBodyHTML .= <<<THUMBEND

<div class="clsPost" style="margin-right:50px;">

    <h3 class="clsMiniTitle" style="width:{$width_m}px;">{$photoTitle}</h3>

    <a href="/{$photoStub}"><img src="{$thumbSRC_m}" width="{$width_m}" height="{$height_m}" alt="{$photoTitle}" style="border:solid #333 2px;background:#000;" border="0"/></a><br />

    <div id="datetime"><img src="/images/posted.gif" width="12" height="12" alt="[.]" title="Posted at" style="vertical-align:middle;" border="0"/> {$photoDateTimeMore}</div>

</div>

THUMBEND;

    }

}

$photoBodyHTML .= "</td></tr></table>";



//Assemble page numbers

$pageNumbersHTML = "";

for ($p=1; $p <= $totalpages; $p++) {

    if ($p == $pageNum) {

        $pageNumbersHTML .= ' <span id="thisPage">'.$p.'</span> ';

    } 

    else {

        $pageNumbersHTML .= ' <a class="clsPage" href="/home/'.$p.'/">'.$p.'</a> ';

    }

}

?>

<!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">

<head>

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

    <meta name="DC.title" content="<?php print APP_TITLE ?>" />

    <meta name="geo.country" content="US" />

    <meta name="dc.language" content="en" />

    <meta name="description" content="<?php print APP_DESCRIPTION ?>" />

    <link rel="alternate" type="application/rss+xml" title="RSS" href="<?php print BASE_URL ?>feed/" />

    <link rel="stylesheet" type="text/css" href="/site_pblog.css" />

    <title><?php print APP_TITLE ?></title>

<?php

if ($_SESSION['admin']) {

?>

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

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

<?php } ?>

    </head>

    <body>

    <div id="topBar" style="background:#eee;">

        <div id="phases"><img src="/images/phases_p.gif" width="238" height="28" alt="phases" /></div>

        <div id="sun"><img src="/images/onfocus-photos.gif" height="28" alt="onfocus * photos" style="margin-bottom:2px;margin-right:2px;"/><img src="/images/sun_p.gif" width="33" height="33" alt="sun"/></div>

    </div>

    <div id="menuBar">

        <div style="position:absolute;right:0px;">

            <a href="/"><img src="/images/menu-photos.gif" width="43" height="15" alt="photos" title="View all photos" style="padding-right:16px;padding-left:16px;border-right:solid #bbb 1px;border-left:solid #bbb 1px;" border="0"/></a>

            <a href="/tags/"><img src="/images/menu-tags.gif" width="28" height="15" alt="photos" title="View all tags" style="padding-right:16px;padding-left:14px;border-right:solid #bbb 1px;" border="0"/></a>

            <a href="http://www.onfocus.com/"><img src="/images/menu-blog.gif" width="29" height="15" alt="Blog" title="Go to my blog" style="padding-right:16px;padding-left:16px;" border="0"/></a>

            <a href="http://www.onfocus.com/about/"><img src="/images/menu-about.gif" width="38" height="15" alt="about" title="About onfocus.com" style="padding-right:10px;padding-left:16px;border-left:solid #bbb 1px;" border="0"/></a>

        </div>

    </div>

    <div id="photobody">

    <?php print $photoBodyHTML ?>

    <div class="clsPost" style="color:#444;margin-top:30px;">Page: <?php print $pageNumbersHTML ?></div>

    <div class="clsPost" style="color:#444;margin-top:10px;"><a href="/">all photos</a> | <a href="http://www.onfocus.com/">blog</a> | <a href="/feed/"><img src="/images/icon-feed.gif" width="12" height="12" alt="feed" title="Subscribe to these photos" border="0" style="vertical-align:middle;"></a> feed | photos <a href="http://creativecommons.org/licenses/by-nc-sa/2.0/">cc</a> 1998-2007 pb.</div>

    </div>

    </body>

</html>