/addons/paged_archive.php

<?php

// SVN file version:
// $Id$

/*
Pixelpost version 1.7.1

Pixelpost www: http://www.pixelpost.org/

Version 1.7.1:
Development Team:
Ramin Mehran, Will Duncan, Joseph Spurling,
Piotr "GeoS" Galas, Dennis Mooibroek, Karin Uhlig, Jay Williams, David Kozikowski

Former members of the Development Team:
Connie Mueller-Goedecke
Version 1.1 to Version 1.3: Linus <http://www.shapestyle.se>

Originally written by: Ramin Mehran
============================================================================

NEW TAGS:

<CATEGORY_LINKS_AS_LIST> // Category links as a text list for default PP's archive page
<CATEGORY_LINKS_AS_LIST_PAGED> // Category links as a text list for page-by-page archive
<BROWSE_MONTHLY_ARCHIVE_PAGED> // Monthly drop box for default PP's archive page
<BROWSE_MONTHLY_ARCHIVE_AS_LINK_PAGED> // Monthly links as a text list for page-by-page archive
<BROWSE_CATEGORIES_PAGED> // Category drop box for page-by-page archive
<THUMBNAILS_WHOLE_PAGED> // Thumbnails in this page
<THUMBNAILS_PAGES_LINKS> // Link to the pages of thumbnail in the selected category
<ARCHIVE_PAGES_NUM> // Page number you are viewing
<CATEGORY_OR_DATE_NAME_PAGED_ARCHIVE> // Name of the category or Month you select
<LINK_TO_PAGED_ARCHIVE> // Link to Paged-by-page archive page as <a href="index.php?x=browse&pagenum=1">Archive</a>',$tpl);
<TAG_LINKS_AS_LIST> // Tag links as a text list for default PP's archive page
<TAG_LINKS_AS_LIST_PAGED> // Tag links as a text list for page-by-page archive
<FOCUS_TAG_LINKS_AS_LIST> // Like <TAG_LINKS_AS_LIST> but with reverse font-size (css)
<FOCUS_TAG_LINKS_AS_LIST_PAGED> // Like <TAG_LINKS_AS_LIST_PAGED> but with reverse font-size (css)
<TAG_IMG_LIST> // list of tags for showed image
<TAG_IMG_LIST_PAGED> // list of tags for showed image
<TAG_IMG_LIST_KEYWORDS> // list of tags for showed image for use as Keywords in Meta Tag
<TAG_LINKS_AS_LIST_NO_NUM> // Like <TAG_LINKS_AS_LIST> but without number of photos for this tag
<TAG_LINKS_AS_LIST_PAGED_NO_NUM> // Like <TAG_LINKS_AS_LIST_PAGED> but without number of photos for this tag
<FOCUS_TAG_LINKS_AS_LIST_NO_NUM> // Like <FOCUS_TAG_LINKS_AS_LIST> but without number of photos for this tag
<FOCUS_TAG_LINKS_AS_LIST_PAGED_NO_NUM> // Like <FOCUS_TAG_LINKS_AS_LIST_PAGED> but without number of photos for this tag

*/

$addon_name = "Page-By-Page-Archive for category and month";
$addon_version = "1.7";

global $default_language_abr, $language_abr, $PP_supp_lang, $cdate, $image_id, $tpl;

$maxpthumb = $cfgrow['maxpthumb'];

if ($cfgrow['display_order']=='default')	$display_order = 'DESC';
else	$display_order = 'ASC';

if (isset($_GET['updatedflagp'])&&$_GET['updatedflagp']=="1")	$isupdated = "<font color='#FF0000'>Updated!</font>";
else	$isupdated = "";

if ($language_abr == $default_language_abr)	$headline_selection = 'headline';
else	$headline_selection = 'alt_headline';

// FIELD_EXISTS
// Checks whether specified field exists in current or specified table.
$fieldname = "maxpthumb";

$table = $pixelpost_db_prefix ."config";
$fieldexists = 0;
$t = 0;
$attention_call = "";
if ($table != "")
{
	if(isset($table_name))
	{
		$current_table = $table;
	}
	$result_id = mysql_list_fields( $pixelpost_db_pixelpost, $table);

	for($t = 0; $t < mysql_num_fields($result_id); $t++)
	{
		if (strtolower( $fieldname) == strtolower(mysql_field_name($result_id, $t)))
		{
			$fieldexists = 1;
			break;
		}
	}
}

// if the field does not exit: Create it!
if($fieldexists==0)
{
	$result = mysql_query("ALTER TABLE $table ADD `maxpthumb` VARCHAR( 5) DEFAULT '100' NOT NULL ");
}

// if the maximum number of thumbnails in the admin section is updated
if(isset($_GET['x'])&&$_GET['x'] == "maxpthumb")
{
	$newmaxpthumb = (int) $_POST['newmaxpthumb'];
	$query = "update ".$pixelpost_db_prefix."config set maxpthumb='" .$newmaxpthumb ."'" ;
	$update = mysql_query($query);
};

// description
$addon_description = "$attention_call Page by page category and month archive. Useful when you have
plenty of photos in archive and you want to show them in few pages and not just as a whole.
Many new tags is added to handle the archives. Open the archive_page.php file to see the new tags.<p />
Enter the maximum number of thumbnails in each page of the archive page:
<form method='post' action='index.php?view=addons&amp;x=maxpthumb'>
<input type='text' name='newmaxpthumb' value='".$maxpthumb ."' style='width:40px'>
<input type='submit' value='update'>
</form> $isupdated

<p>TAGS:<br/>
<br/>
&lt;CATEGORY_LINKS_AS_LIST&gt; // Category links as a text list for default PP's
archive page<br/>
&lt;CATEGORY_LINKS_AS_LIST_PAGED&gt; // Category links as a text list for page-by-page
archive<br/>
&lt;BROWSE_MONTHLY_ARCHIVE_PAGED&gt; // Monthly drop box for default PP's archive page<br/>
&lt;BROWSE_MONTHLY_ARCHIVE_AS_LINK_PAGED&gt; // Monthly links as a text list for
page-by-page archive<br/>
&lt;BROWSE_CATEGORIES_PAGED&gt; // Category drop box for page-by-page archive<br/>
&lt;THUMBNAILS_WHOLE_PAGED&gt; // Thumbnails in this page<br/>
&lt;THUMBNAILS_PAGES_LINKS&gt; // Link to the pages of thumbnail in the selected
category<br/>
&lt;ARCHIVE_PAGES_NUM&gt; // Page number you are viewing<br/>
&lt;CATEGORY_OR_DATE_NAME_PAGED_ARCHIVE&gt; // Name of the category or Month you
select<br/>
&lt;LINK_TO_PAGED_ARCHIVE&gt; // Link to Paged-by-page archive page</p>

<p>NEW TAGS:<br/>
<br/>
&lt;TAG_LINKS_AS_LIST&gt; // Tag links as a text list for default PP's archive page (different font-size by css)<br/>
&lt;TAG_LINKS_AS_LIST_PAGED&gt; // Tag links as a text list for page-by-page archive (different font-size by css)<br/>
&lt;FOCUS_TAG_LINKS_AS_LIST&gt; // Like &lt;TAG_LINKS_AS_LIST&gt; but with reverse font-size (css)<br />
&lt;FOCUS_TAG_LINKS_AS_LIST_PAGED&gt; // Like &lt;TAG_LINKS_AS_LIST_PAGED&gt; but with reverse font-size (css)<br />
&lt;TAG_IMG_LIST&gt; // list of tags for showed image<br/>
&lt;TAG_IMG_LIST_PAGED&gt; // list of tags for showed image<br />
&lt;TAG_IMG_LIST_KEYWORDS&gt; // list of tags for showed image for use as Keywords in Meta Tag<br />
&lt;TAG_LINKS_AS_LIST_NO_NUM&gt; // Like &lt;TAG_LINKS_AS_LIST&gt; but without number of photos for this tag<br />
&lt;TAG_LINKS_AS_LIST_PAGED_NO_NUM&gt; // Like &lt;TAG_LINKS_AS_LIST_PAGED&gt; but without number of photos for this tag<br/>
&lt;FOCUS_TAG_LINKS_AS_LIST_NO_NUM&gt; // Like &lt;FOCUS_TAG_LINKS_AS_LIST&gt; but without number of photos for this tag<br />
&lt;FOCUS_TAG_LINKS_AS_LIST_PAGED_NO_NUM&gt; // Like &lt;FOCUS_TAG_LINKS_AS_LIST_PAGED&gt; but without number of photos for this tag<br /></p>

";

// date time of now!
$tz = $cfgrow['timezone'];
$datetime = gmdate("Y-m-d H:i:s",gmdate("U")+(3600 * $tz));

// get maximum number of thumbnails in each browse page from db
$maxnumber_thumbs = $cfgrow['maxpthumb'];


// number of all photos
$photonumb = mysql_query("SELECT count(*) AS count FROM ".$pixelpost_db_prefix."pixelpost WHERE datetime<='$datetime'");
$row = mysql_fetch_array($photonumb,MYSQL_ASSOC);
// number of photos in the database
$pixelpost_all_photonumb = $row['count'] ;

if (isset($_GET['tag'])){
	$_GET['tag'] = ($_GET['tag']) ? urldecode($_GET['tag']) : '';
}
$_GET['category'] = (isset($_GET['category']) && $_GET['category'] > 0) ? (int)$_GET['category'] : "";

if(isset($_GET['tag']) && preg_match("/([a-zA-Z 0-9_-\pL]+)/u",$_GET['tag']))	$paged_arch_tag_flag = 1;
else if(isset($_GET['tag']) && preg_match("/([a-zA-Z 0-9_-]+)/",$_GET['tag']))	$paged_arch_tag_flag = 2;
else	$paged_arch_tag_flag = 0;

if(isset($_GET['archivedate']) && eregi("^[0-9]{4}-[0-9]{2}$", $_GET['archivedate']))	$paged_arch_archdate_flag = 1;
else	$paged_arch_archdate_flag = 0;

// Browse images monthly
$bryear = (isset($_GET['bryear'])) ? (int)$_GET['bryear'] : '';
$brmonth = (isset($_GET['brmonth'])) ? (int)$_GET['brmonth'] : '';
$brbrowse = ($bryear > 0 && $brmonth > 0) ?	1 : 0;

//-------------------------------- Category Browse Menu (paged and original)
/*---------------------------------**********************---------------------------------------*/

$count= $pixelpost_all_photonumb;
$category_Link_List = " <a href='index.php?x=browse'> $lang_browse_all (" .$count .") </a><br />";

$category_Link_List_paged = "<ul id=\"taglist\">";
$category_Link_List_paged .= "<li><a href='index.php?x=browse&amp;pagenum=1'>$lang_browse_all (" .$count .")</a></li>";

if ($language_abr == $default_language_abr)	$query = mysql_query("SELECT * FROM ".$pixelpost_db_prefix."categories ORDER BY name");
else	$query = mysql_query("SELECT * FROM ".$pixelpost_db_prefix."categories ORDER BY alt_name");

while(list($id, $name, $alt_name) = mysql_fetch_row($query))
{
	$queryr = "SELECT count(*) AS count,datetime
	FROM {$pixelpost_db_prefix}catassoc AS t1
	INNER JOIN {$pixelpost_db_prefix}pixelpost t2 on t2.id = t1.image_id
	WHERE (t1.cat_id = '".$id."' AND datetime<='$datetime')
	GROUP BY t1.cat_id ";

	$count = mysql_query($queryr);
	$count = mysql_fetch_array($count,MYSQL_ASSOC);
	$count= $count['count'];
	if ($count > 0){
		if($language_abr == $default_language_abr)	$name = pullout($name);
		else	$name = pullout($alt_name);
		$catname_count = $name ." (" .$count .")";

		$category_Link_List .= "<a href='index.php?x=browse&amp;category=$id'>$catname_count</a><br />";

		// paged version of the browse archive
		$category_Link_List_paged .= "<li><a href='index.php?x=browse&amp;category=$id&amp;pagenum=1'>$catname_count</a></li>";
	}
}

$category_Link_List_paged .= "</ul>";


//----------- Monthly Archive Menu and List
if (isset($_GET['pagenum'])&&$_GET['pagenum'] != "")
{
	$tz = $cfgrow['timezone'];
	$thismonth = gmdate("Y-m",gmdate("U")+(3600 * $tz));
	$select_display_thismonth=date("F, Y",strtotime($thismonth."-01"));

	$archive_select = "<select name='browse' onchange='self.location.href=this.options[this.selectedIndex].value;'><option value=''>Monthly archive</option><option value='index.php?x=browse&amp;pagenum=1'>$lang_browse_all (" .$pixelpost_all_photonumb .")</option>";
	$archive_select_links = "<ul id=\"monthlist\">
                            <li><a href='index.php?x=browse&amp;pagenum=1'>$lang_browse_all (" .$pixelpost_all_photonumb .")</a></li>";
	$query = "SELECT distinct DATE_FORMAT(datetime, '%Y-%m') FROM ".$pixelpost_db_prefix."pixelpost
	WHERE DATE_FORMAT(datetime, '%Y-%m') <= '$thismonth' and datetime<='$datetime'
	ORDER BY datetime desc";

	$query = mysql_query($query);
	while(list($thedate) = mysql_fetch_row($query))
	{
		$query2 = "SELECT count(*) AS count FROM ".$pixelpost_db_prefix."pixelpost WHERE datetime<='$datetime' and DATE_FORMAT(datetime, '%Y-%m')='".$thedate ."'";
		$count = mysql_query($query2);
		$count = mysql_fetch_array($count,MYSQL_ASSOC);
		$count= $count['count'];
		$select_display_date=date("F, Y",strtotime($thedate."-01"));
		$select_display_date2 = ucfirst(${"lang_".strtolower(date("F",strtotime($thedate."-01")))}) . date(", Y",strtotime($thedate."-01"));
		$select_display_date_link=str_replace(" ","%20",$select_display_date);
		$thedate = pullout($thedate);
		preg_match('/(\w+),\s/', $select_display_date, $naturalmonth);
		$natmonth = 'lang_'.strtolower($naturalmonth[1]);
		$mynatmonth = $$natmonth;
		$select_display_date=preg_replace('/\w+,(\s\d+)/', "$mynatmonth$1", $select_display_date);
		$archive_select .= "<option value='index.php?x=browse&amp;archivedate=$thedate&amp;monthname=$select_display_date_link&amp;pagenum=1'>$name (" .$select_display_date2 .") (" .$count .")</option>";
		$archive_select_links .= "<li><a href='index.php?x=browse&amp;archivedate=$thedate&amp;monthname=$select_display_date_link&amp;pagenum=1'>$name " .$select_display_date2 ." (" .$count .")</a></li>";
	};// end while
	$archive_select .= "</select>";
	$archive_select_links .= "</ul>";
} // end $_GET['pagenum'] != "")
else
{
	// does not use page number
	$tz = $cfgrow['timezone'];
	$thismonth = gmdate("Y-m",gmdate("U")+(3600 * $tz));
	$select_display_thismonth=date("F, Y",strtotime($thismonth."-01"));

	if (isset($thedate))
	{
		$archive_select = "<select name='browse' onchange='self.location.href=this.options[this.selectedIndex].value;'><option value=''>Monthly archive</option><option value='index.php?x=browse&amp;archivedate=$thedate&amp;pagenum=1'>$lang_browse_all (" .$pixelpost_all_photonumb .")</option>";
		$archive_select_links = "<ul id='monthlist'><li><a href='index.php?x=browse&amp;archivedate=$thedate&amp;pagenum=1'>$lang_browse_all (" .$pixelpost_all_photonumb .")</a></li>";
	}
	else
	{
		$archive_select = "<select name='browse' onchange='self.location.href=this.options[this.selectedIndex].value;'><option value=''>Monthly archive</option><option value='index.php?x=browse&amp;pagenum=1'>$lang_browse_all (" .$pixelpost_all_photonumb .")</option>";
		$archive_select_links = "<ul id='monthlist'><li><a href='index.php?x=browse&amp;pagenum=1'>$lang_browse_all (" .$pixelpost_all_photonumb .")</a></li>";
	}

	$query = mysql_query("SELECT DISTINCT DATE_FORMAT(datetime, '%Y-%m') FROM ".$pixelpost_db_prefix."pixelpost ORDER BY datetime desc");

	while(list($thedate) = mysql_fetch_row($query))
	{
		$query3 = "SELECT count(*) AS count FROM ".$pixelpost_db_prefix."pixelpost WHERE DATE_FORMAT(datetime, '%Y-%m')='".$thedate ."'";
		$count = mysql_query($query3);
		$count = mysql_fetch_array($count,MYSQL_ASSOC);
		$count= $count['count'];

		$select_display_date=date("F, Y",strtotime($thedate."-01"));
		$select_display_date2 = ucfirst(${"lang_".strtolower(date("F",strtotime($thedate."-01")))}) . date(", Y",strtotime($thedate."-01"));
		$thedate = pullout($thedate);
		$archive_select .= "<option value='index.php?x=browse&amp;archivedate=$thedate'>$name (" .$select_display_date2 .") (" .$count .")</option>";
		$archive_select_links .= "<li><a href='index.php?x=browse&amp;archivedate=$thedate'>$name " .$select_display_date2 ." (" .$count .")</a></li>";
	}; // end while

	$archive_select .= "</select>";
	$archive_select_links .= "</ul>";
} // end else

//--------------- check if it should be the browse page
if(isset($_GET['x'])&&$_GET['x'] == "browse")
{
	// initialize variables
	$thumb_output = "";
	$where = "";
	$limit = "";
	$pagenum = (isset($_GET['pagenum'])) ? (int)$_GET['pagenum'] : 1;
	
	// did user select a category?

	if(isset($_GET['category']) && $_GET['category'] != "")
	{
		$where = "and (t2.cat_id ='".(int)$_GET['category']."')";
	}

	// do you use links with page number?
	if (isset($_GET['pagenum']) && $_GET['pagenum'] != "")
	{
		$start = $maxnumber_thumbs*((int)$_GET['pagenum']-1);// calculate start and end of the thumbs in the selected page
		$limit = " LIMIT $start , $maxnumber_thumbs "; // create the limit command (in MS-SQL this should be TOP)
	}// end if ($_GET['pagenum'] != "")
	// build query
	if (!isset($_GET['archivedate']) && isset($_GET['category']) && $_GET['category'] != "")
	{
	// no archive date
		$query = "SELECT t1.id,t1.{$headline_selection},t1.image
		FROM {$pixelpost_db_prefix}pixelpost AS t1, {$pixelpost_db_prefix}catassoc AS t2
		WHERE (t1.datetime<='$cdate')
		$where
		AND (t1.id = t2.image_id)
		GROUP BY t1.id
		ORDER BY t1.".$cfgrow['display_sort_by']." ".$display_order.$limit;
	} // if ($_GET['archivedate']=="")
	else if($paged_arch_archdate_flag > 0)
	{ // archive date is available
		$archivedate_start = $_GET['archivedate'] ."-01 00:00:00";
		$archivedate_end = $_GET['archivedate'] ."-31 23:59:59";
		$query = "SELECT id,{$headline_selection},image FROM ".$pixelpost_db_prefix."pixelpost
		WHERE (datetime<='$cdate' and datetime >='$archivedate_start' and datetime <= '$archivedate_end')
		$where ORDER BY ".$cfgrow['display_sort_by']." ".$display_order.$limit;
	}
	else if($paged_arch_tag_flag > 0)
	{
  	if ($language_abr == $default_language_abr)	$tag_selection = "AND (t2.tag = '" . $_GET['tag'] . "')";
	  else	$tag_selection = "AND (t2.alt_tag = '" . $_GET['tag'] . "')";

		$query = "SELECT t1.id,t1.{$headline_selection},t1.image
		FROM {$pixelpost_db_prefix}pixelpost AS t1, {$pixelpost_db_prefix}tags AS t2
		WHERE (t1.datetime<='$cdate')
		$where
		AND (t1.id = t2.img_id)
		$tag_selection
		GROUP BY t1.id
		ORDER BY t1.".$cfgrow['display_sort_by']." ".$display_order.$limit;
	}
	// Browse images monthly
	else if($brbrowse)
	{
		$query = "
			SELECT a.id, a.headline, a.alt_headline, a.image, DATE_FORMAT(a.datetime,'%d.%m.%Y'), count(b.id)
			FROM {$pixelpost_db_prefix}pixelpost AS a
			LEFT JOIN {$pixelpost_db_prefix}comments AS b ON (b.parent_id = a.id)
			WHERE	DATE_FORMAT(a.datetime,'%Y%c') = '".$bryear.$brmonth."'
			GROUP BY a.id
			ORDER BY a.datetime DESC";
	}
	else
	{
		$query = "SELECT id, {$headline_selection}, image FROM {$pixelpost_db_prefix}pixelpost
		WHERE (datetime<='$cdate')
		ORDER BY ".$cfgrow['display_sort_by']." ".$display_order.$limit;
	}

	$query = mysql_query($query);

	//---------------------------- Making thumbs row

	// Browse images monthly
	if($brbrowse)
	{
		$thumb_output = "<div id='browse_monthly_imgs'>";

		while(list($id,$title,$alt_title,$name,$date,$coms) = mysql_fetch_row($query))
		{
			// from the thumbnail row. This could be build by tables too.
			$title = ($language_abr == $default_language_abr) ? $title : $alt_title;
			$title = htmlentities ( pullout($title), ENT_QUOTES, 'UTF-8');
			$img = ltrim($cfgrow['imagepath'], "./").$name;
			$thumbnail_extra = getimagesize($img);
			$local_width = $thumbnail_extra['0'];
			$local_height = $thumbnail_extra['1'];
			$thumb_output .= "\n<div class='br_mo_img_link'><a href='".PHP_SELF."?showimage=$id' class='br_mo_link' title='$title ($date)'><img src='$img' alt='$title ($date)' class='br_mo_img' width='".$local_width."' height='".$local_height."' /></a></span><br/><span class='br_mo_title'>$title <span class='br_mo_date'>($date)</span> - <span class='br_mo_coms'>$lang_comment_plural: $coms</span></div>";
		}

		$thumb_output .= "\n</div>";
	}
	else
	{
		while(list($id,$title,$name) = mysql_fetch_row($query))
		{
			// from the thumbnail row. This could be build by tables too.
			$title = pullout($title);
			$title = htmlspecialchars($title,ENT_QUOTES);
			$thumbnail = ltrim($cfgrow['thumbnailpath'], "./")."thumb_".$name;
			$thumbnail_extra = getimagesize($thumbnail);
			$local_width = $thumbnail_extra['0'];
			$local_height = $thumbnail_extra['1'];
			$thumb_output .= "<a href='".PHP_SELF."?showimage=$id'><img src='".$thumbnail."' alt='".$title."' title='".$title."' width='".$local_width."' height='".$local_height."' class='thumbnails' /></a>";
		} //end while
	}
	// initialize page counter
	$pagecounter=0;

	//---------------- Get number of photos in database in the selected category

	// initialize where command
	$where = "";
	$monthname = "";

	// check if user selects a category
	if(isset($_GET['category'])&&$_GET['category'] != "")
	{
		$queryr = "SELECT count(*) AS count,datetime
		FROM {$pixelpost_db_prefix}catassoc AS t1
		INNER JOIN {$pixelpost_db_prefix}pixelpost t2 on t2.id = t1.image_id
		WHERE (t1.cat_id = '".(int)$_GET['category']."' AND datetime<='$datetime')";
		$queryr .= " GROUP BY t1.cat_id ";
	}// end if
	else if($paged_arch_tag_flag > 0)
	{
  	if ($language_abr == $default_language_abr)	$tag_selection = "AND (t2.tag = '" . mysql_real_escape_string($_GET['tag']) . "')";
	  else	$tag_selection = "AND (t2.alt_tag = '" . mysql_real_escape_string($_GET['tag']) . "')";

		$queryr = "SELECT count(*) AS count
		FROM {$pixelpost_db_prefix}pixelpost AS t1, {$pixelpost_db_prefix}tags AS t2
		WHERE (t1.datetime<='$cdate')
		AND (t1.id = t2.img_id)
		$tag_selection";
	}
	else if($paged_arch_archdate_flag > 0)
	{
		$archivedate_start = mysql_real_escape_string($_GET['archivedate']) ."-01 00:00:00";
		$archivedate_end = mysql_real_escape_string($_GET['archivedate']) ."-31 23:59:59";
		$where = " AND datetime >='$archivedate_start' AND datetime <= '$archivedate_end' ";
		$monthname = mysql_real_escape_string($_GET['monthname']);
		$queryr = "SELECT count(*) AS count FROM ".$pixelpost_db_prefix."pixelpost WHERE datetime<='$datetime'" .$where;
	} // end if($_GET['archivedate'] != "")
	else // not cat selected return all images in the DB
	{
		$queryr = "SELECT count(*) AS count
		FROM {$pixelpost_db_prefix}pixelpost
		WHERE ( datetime<='$datetime')";
	} //end else

	$photonumb = mysql_query($queryr);
	$row = mysql_fetch_array($photonumb,MYSQL_ASSOC);
	// number of photos in the database in the same category
	$pixelpost_photonumb = $row['count'];

	// calculate the number of pages
	$num_browse_pages = (isset($_GET['pagenum'])) ? ceil($pixelpost_photonumb/$maxnumber_thumbs) : "";

	// initialize archive links
	$Archive_pages_Links = "";
	// selected category id
	if (isset($_GET['category'])){
		$cat_id = (int)$_GET['category'];
	} else {
		$cat_id = null;
	}

	//-------- Make page number to archive as links (for the selected category)

	// produce Previous page link
	if ($pagenum > 1)
	{
		$temp =$pagenum-1;
		if($cat_id != '')	$Archive_pages_Links .= "<a href='index.php?x=browse&amp;category=$cat_id&amp;pagenum=$temp'>$lang_previous</a> ";
		else if($paged_arch_tag_flag > 0)
		{
			$Archive_pages_Links .= "<a href='index.php?x=browse&amp;tag=".mysql_real_escape_string($_GET['tag'])."&amp;pagenum=$temp'>$lang_previous</a> ";
		}
		else if($paged_arch_archdate_flag > 0)
		{
			$monthname=str_replace(" ","%20",$monthname);
			$archivedate=$_GET['archivedate'];
			$Archive_pages_Links .= "<a  href='index.php?x=browse&amp;archivedate=$archivedate&amp;monthname=$monthname&amp;pagenum=$temp'>$lang_previous</a> ";
		}
		else	$Archive_pages_Links .= "<a href='index.php?x=browse&amp;pagenum=$temp'>$lang_previous</a> ";
	}

	if($cat_id != '')
	{
		$pagecounter = 0;

		while ($pagecounter < $num_browse_pages)
		{
			$pagecounter++;
			if ($pagecounter != $pagenum){
				$Archive_pages_Links .= "<span class=\"archive_page_number\"><a href='index.php?x=browse&amp;category=$cat_id&amp;pagenum=$pagecounter'>$pagecounter</a></span> ";
			} else {
				$Archive_pages_Links .= "<span class=\"archive_active_page_number\"><a href='index.php?x=browse&amp;category=$cat_id&amp;pagenum=$pagecounter'>$pagecounter</a></span> ";
			}
		}// end while
	}// end if
	else if($paged_arch_tag_flag > 0)
	{
		$pagecounter = 0;

		while ($pagecounter < $num_browse_pages)
		{
			$pagecounter++;
			if ($pagecounter != $pagenum){
				$Archive_pages_Links .= "<span class=\"archive_page_number\"><a href='index.php?x=browse&amp;tag=".mysql_real_escape_string($_GET['tag'])."&amp;pagenum=$pagecounter'>$pagecounter</a></span> ";
			} else {
				$Archive_pages_Links .= "<span class=\"archive_active_page_number\"><a href='index.php?x=browse&amp;tag=".mysql_real_escape_string($_GET['tag'])."&amp;pagenum=$pagecounter'>$pagecounter</a></span> ";
				
			}
		}
	}
	else if($paged_arch_archdate_flag > 0)
	{
		$pagecounter = 0;

		while ($pagecounter < $num_browse_pages)
		{
			$monthname=str_replace(" ","%20",$monthname);
			$pagecounter++;
			$archivedate=mysql_real_escape_string($_GET['archivedate']);
			if ($pagecounter != $pagenum){
				$Archive_pages_Links .= "<span class=\"archive_page_number\"><a  href='index.php?x=browse&amp;archivedate=$archivedate&amp;monthname=$monthname&amp;pagenum=$pagecounter'>$pagecounter</a></span> ";
			} else {
				$Archive_pages_Links .= "<span class=\"archive_active_page_number\"><a  href='index.php?x=browse&amp;archivedate=$archivedate&amp;monthname=$monthname&amp;pagenum=$pagecounter'>$pagecounter</a></span> ";
			}
		}// whilte
	}// end if $_GET['archivedate']!=""
	else
	{
		$pagecounter = 0;

		while ($pagecounter < $num_browse_pages)
		{
			$pagecounter++;
			// added support for bold page number
			if ($pagecounter != $pagenum){
				$Archive_pages_Links .= "<span class=\"archive_page_number\"><a href='index.php?x=browse&amp;&amp;pagenum=$pagecounter'>$pagecounter</a></span> ";
			}else{
				$Archive_pages_Links .= "<span class=\"archive_active_page_number\"><a href='index.php?x=browse&amp;&amp;pagenum=$pagecounter'>$pagecounter</a></span> ";
			}
		}// end while
	}// end else

	// produce Next page link
	if ($pagenum < $num_browse_pages)
	{
		$temp = $pagenum+1;
		if($cat_id != '')	$Archive_pages_Links .= "<a href='index.php?x=browse&amp;category=$cat_id&amp;pagenum=$temp'>$lang_next</a>";
		else if($paged_arch_tag_flag > 0)
		{
			$Archive_pages_Links .= "<a href='index.php?x=browse&amp;tag=".mysql_real_escape_string($_GET['tag'])."&amp;pagenum=$temp'>$lang_next</a>";
		}
		else if($paged_arch_archdate_flag > 0)
		{
			$monthname=str_replace(" ","%20",$monthname);
			$archivedate=mysql_real_escape_string($_GET['archivedate']);
			$Archive_pages_Links .= "<a  href='index.php?x=browse&amp;archivedate=$archivedate&amp;monthname=$monthname&amp;pagenum=$temp'>$lang_next</a>";
		}
		else	$Archive_pages_Links .= "<a href='index.php?x=browse&amp;pagenum=$temp'>$lang_next</a>";
	}

	// selected category name
	if($cat_id != "")
	{
		if ($language_abr == $default_language_abr)
		{
			$query = mysql_query("SELECT name FROM ".$pixelpost_db_prefix."categories WHERE id='$cat_id' ORDER BY name");
			$images_category_or_date = mysql_fetch_array($query,MYSQL_ASSOC);
			$images_category_or_date = pullout($images_category_or_date['name']);
		}
		else
		{
			$query = mysql_query("SELECT alt_name FROM ".$pixelpost_db_prefix."categories WHERE id='$cat_id' ORDER BY alt_name");
			$images_category_or_date = mysql_fetch_array($query,MYSQL_ASSOC);
			$images_category_or_date = pullout($images_category_or_date['alt_name']);
		}
	}
	else
	{
		if (isset($_GET['tag']))	$images_category_or_date = mysql_real_escape_string($_GET['tag']);
		else if (isset($_GET['archivedate']))	{
			$images_category_or_date = mysql_real_escape_string($_GET['monthname']);
			preg_match('/(\w+),\s/', $images_category_or_date, $naturalmonth);
			$natmonth = 'lang_'.strtolower($naturalmonth[1]);
			$mynatmonth = $$natmonth;
			$images_category_or_date=preg_replace('/\w+,(\s\d+)/', "$mynatmonth$1", $images_category_or_date);
		}
		else	$images_category_or_date = $lang_browse_all;
	}
} // end if ($_GET['x'] == "browse")

//------------- Make Archive browse menu with link to paged archive
// build browse menu
$browse_select = "";


    $temppagenum =1;
// do you use links with page number?
if ($maxpthumb>0)
{
	$browse_select = "<select name='browse' onchange='self.location.href=this.options[this.selectedIndex].value;'><option value=''>$lang_browse_select_category</option><option value='index.php?x=browse&amp;category=&amp;pagenum=$temppagenum'>$lang_browse_all (" .$pixelpost_all_photonumb .")</option>";
}
else
{
	$browse_select = "<select name='browse' onchange='self.location.href=this.options[this.selectedIndex].value;'><option value=''>$lang_browse_select_category</option><option value='index.php?x=browse&amp;category='>$lang_browse_all (" .$pixelpost_all_photonumb .")</option>";
}

$query = mysql_query("SELECT * FROM ".$pixelpost_db_prefix."categories ORDER BY name");

while(list($id,$name,$alt_name) = mysql_fetch_row($query))
{
	if($language_abr == $default_language_abr)	$name = pullout($name);
	else	$name = pullout($alt_name);

	$queryr = "SELECT count(*) AS count,datetime
	FROM {$pixelpost_db_prefix}catassoc AS t1
	INNER JOIN {$pixelpost_db_prefix}pixelpost t2 on t2.id = t1.image_id
	WHERE (t1.cat_id = '".$id."' AND datetime<='$datetime')
	GROUP BY t1.cat_id ";
	$count = mysql_query($queryr);
	$count = mysql_fetch_array($count,MYSQL_ASSOC);
	$count= $count['count'];
	// check if you are using this addon
	// u r using
	if ($maxpthumb>0)	$browse_select .= "<option value='index.php?x=browse&amp;category=$id&amp;pagenum=1'>$name (" .$count .")</option>";
	// use the original browse category menu
	else	$browse_select .= "<option value='index.php?x=browse&amp;category=$id'>$name (" .$count .")</option>";
} // end while

// finilize the tag
$browse_select .= "</select>";

/* TAGS support */
$tags_output = '<div id="tag_cloud">';
$tags_output_reversed = $tags_output;
$tags_paged_output = $tags_output;
$tags_paged_output_reversed = $tags_output;
$tags_output_no_num = $tags_output;
$tags_output_reversed_no_num = $tags_output;
$tags_paged_output_no_num = $tags_output;
$tags_paged_output_reversed_no_num = $tags_output;

$default_language_abr = strtolower($PP_supp_lang[$cfgrow['langfile']][0]);

if($language_abr == $default_language_abr)	$queryr = "SELECT COUNT(*) AS max
		FROM {$pixelpost_db_prefix}pixelpost AS p, {$pixelpost_db_prefix}tags AS t
		WHERE t.alt_tag LIKE '' AND p.id = t.img_id AND p.datetime<='$cdate'
		GROUP BY t.tag
		ORDER BY max DESC
		LIMIT 1";
else	$queryr = "SELECT COUNT(*) AS max
		FROM {$pixelpost_db_prefix}pixelpost AS p, {$pixelpost_db_prefix}tags AS t
		WHERE t.tag LIKE '' AND p.id = t.img_id AND p.datetime<='$cdate'
		GROUP BY alt_tag
		ORDER BY max DESC
		LIMIT 1";

$tag_max = mysql_query($queryr);
$tag_max = mysql_fetch_row($tag_max);
$tag_max = $tag_max[0];
if($tag_max == ''){ $tag_max = 0; }

if ($language_abr == $default_language_abr)	$queryr = "SELECT ROUND(COUNT(*)/$tag_max,1) AS rank, tag, COUNT(*) as cnt
		FROM {$pixelpost_db_prefix}pixelpost AS p, {$pixelpost_db_prefix}tags AS t
		WHERE t.alt_tag LIKE '' AND p.id = t.img_id AND p.datetime<='$cdate'
		GROUP BY tag
		ORDER BY tag";
else	$queryr = "SELECT ROUND(COUNT(*)/$tag_max,1) AS rank, alt_tag, COUNT(*) as cnt
		FROM {$pixelpost_db_prefix}pixelpost AS p, {$pixelpost_db_prefix}tags AS t
		WHERE t.tag LIKE '' AND p.id = t.img_id AND p.datetime<='$cdate'
		GROUP BY alt_tag
		ORDER BY alt_tag";

$tags = mysql_query($queryr);

while(list($rank, $tag, $cnt)  = mysql_fetch_array($tags,MYSQL_NUM))
{
	$tags_output .= '<a href="index.php?x=browse&amp;tag='.$tag.'" class="tags'.$rank[0].$rank[2].'">'.$tag.'&nbsp;('.$cnt.')</a> ';
	$tags_paged_output .= '<a href="index.php?x=browse&amp;tag='.$tag.'&amp;pagenum=1" class="tags'.$rank[0].$rank[2].'">'.$tag.'&nbsp;('.$cnt.')</a> ';
	$tags_output_no_num .= '<a href="index.php?x=browse&amp;tag='.$tag.'" class="tags'.$rank[0].$rank[2].'">'.$tag.'</a> ';
	$tags_paged_output_no_num .= '<a href="index.php?x=browse&amp;tag='.$tag.'&amp;pagenum=1" class="tags'.$rank[0].$rank[2].'">'.$tag.'</a> ';
	$rank_reversed = $rank;
	if ($rank[0]==1)
	{
		$rank_reversed[0]=0; //give the most important tag the lessest weight
	}
	else
	{
		$rank_reversed[2]=10-$rank[2];
	}
	$tags_output_reversed .= '<a href="index.php?x=browse&amp;tag='.$tag.'" class="tags'.$rank_reversed[0].$rank_reversed[2].'">'.$tag.'&nbsp;('.$cnt.')</a> ';
	$tags_paged_output_reversed .= '<a href="index.php?x=browse&amp;tag='.$tag.'&amp;pagenum=1" class="tags'.$rank_reversed[0].$rank_reversed[2].'">'.$tag.'&nbsp;('.$cnt.')</a> ';
	$tags_output_reversed_no_num .= '<a href="index.php?x=browse&amp;tag='.$tag.'" class="tags'.$rank_reversed[0].$rank_reversed[2].'">'.$tag.'</a> ';
	$tags_paged_output_reversed_no_num .= '<a href="index.php?x=browse&amp;tag='.$tag.'&amp;pagenum=1" class="tags'.$rank_reversed[0].$rank_reversed[2].'">'.$tag.'</a> ';
}

$tags_output .= '</div>';
$tags_paged_output .= '</div>';
$tags_output_reversed .= '</div>';
$tags_paged_output_reversed .= '</div>';
$tags_output_no_num .= '</div>';
$tags_paged_output_no_num .= '</div>';
$tags_output_reversed_no_num .= '</div>';
$tags_paged_output_reversed_no_num .= '</div>';

if ($language_abr == $default_language_abr)	$queryr = "SELECT tag
		FROM {$pixelpost_db_prefix}tags
		WHERE img_id = " . $image_id . " AND tag != ''
		ORDER BY tag";
else	$queryr = "SELECT alt_tag
		FROM {$pixelpost_db_prefix}tags
		WHERE img_id = " . $image_id . " AND alt_tag != ''
		ORDER BY alt_tag";

$tags = mysql_query($queryr);

$tags_img = "";
$tags_paged_img = "";
$tags_keywords ="";

if (@mysql_num_rows($tags)>0)
{
	while(list($tag)  = mysql_fetch_array($tags,MYSQL_BOTH))
	{
		$tags_img .= '<a href="index.php?x=browse&amp;tag='.$tag.'">'.$tag.'</a> ';
		$tags_paged_img .= '<a href="index.php?x=browse&amp;tag='.$tag.'&amp;pagenum=1">'.$tag.'</a> ';
		$tags_keywords .= $tag.', ';
	}
}
else
{
	$tags_img =NULL;
	$tags_paged_img =NULL;
	$tags_keywords = NULL;
}

if($tags_img == '')
{
	$tags_img = $lang_none;
	$tags_paged_img = $lang_none;
}

$tags_img = trim($tags_img);
$tags_paged_img = trim($tags_paged_img);
$tags_keywords = str_replace('_',' ',$tags_keywords);

/***********************************************
*          BROWSE IMAGES MONTHLY
***********************************************/
$query = "SELECT DISTINCT DATE_FORMAT( datetime, '%Y%m' )
	FROM ".$pixelpost_db_prefix."pixelpost
	WHERE datetime <= '$datetime' AND datetime > '0000-00-00 00:00:00'
	ORDER BY datetime ASC";
$result = mysql_query($query);
$start = mysql_fetch_row($result);

$cym = $start[0];
$y = substr($cym, 0, 4);
$m = substr($cym, 4, 2);
$cy = date('Y');
$cm = date('m');

$browse_monthly_menu = "<div id='br_mo_me'>\n";

for($x = $y; $x <= $cy; $x++)
{
	$browse_monthly_menu .= "<div class='br_mo_me_$x'>\n";

	for($m = 1; $m <= 12; $m++)
	{
		if($m == 1)	$browse_monthly_menu .= "<span class='br_mo_me_y_$x'>$x</span>\n";
		$m = ($m < 10) ? "0$m" : $m;
		$m2 = ($x == $cy && $m == $cm) ? $m.' br_mo_me_curr' : $m;

		if($cym < "$x$m")
		{
			$cym = @mysql_fetch_array($result,MYSQL_NUM);
			$cym = $cym[0];
		}

		$browse_monthly_menu .= ($cym == "$x$m") ? " <a href='".PHP_SELF."?x=browse&amp;bryear=" . $x . "&amp;brmonth=" . $m . "' class='br_mo_me_" . $x . "_" . $m2 . "'>" . $m . "</a>\n" : " <span class='br_mo_me_" . $x . "_" . $m2 . "'>" . $m . "</span>\n";
	}
	$browse_monthly_menu .= "</div>\n";
}

$browse_monthly_menu .= "</div>\n";

$tpl = str_replace("<BROWSE_MONTHLY_MENU>", $browse_monthly_menu, $tpl); //menu for browse images monthly

/***********************************************
*          TEMPLATE TAGS REPLACEMNET
***********************************************/

//tags for image tags
$tpl = str_replace("<TAG_LINKS_AS_LIST>",$tags_output,$tpl); //thumbnails in this page
$tpl = str_replace("<TAG_LINKS_AS_LIST_PAGED>",$tags_paged_output,$tpl); //thumbnails in this page
$tpl = str_replace("<FOCUS_TAG_LINKS_AS_LIST>",$tags_output_reversed,$tpl); //thumbnails in this page
$tpl = str_replace("<FOCUS_TAG_LINKS_AS_LIST_PAGED>",$tags_paged_output_reversed,$tpl); //thumbnails in this page
$tpl = str_replace("<TAG_IMG_LIST>",$tags_img,$tpl); // list of tags for showed image
$tpl = str_replace("<TAG_IMG_LIST_PAGED>",$tags_paged_img,$tpl); // list of tags for showed image
$tpl = str_replace("<TAG_IMG_LIST_KEYWORDS>",$tags_keywords,$tpl); // list of tags for meta keywords

//same tags as at the top but without image number
$tpl = str_replace("<TAG_LINKS_AS_LIST_NO_NUM>",$tags_output_no_num,$tpl); //thumbnails in this page
$tpl = str_replace("<TAG_LINKS_AS_LIST_PAGED_NO_NUM>",$tags_paged_output_no_num,$tpl); //thumbnails in this page
$tpl = str_replace("<FOCUS_TAG_LINKS_AS_LIST_NO_NUM>",$tags_output_reversed_no_num,$tpl); //thumbnails in this page
$tpl = str_replace("<FOCUS_TAG_LINKS_AS_LIST_PAGED_NO_NUM>",$tags_paged_output_reversed_no_num,$tpl); //thumbnails in this page


//----------------- Build the additional new tages
//-- If you use paged archive
if (isset($pagenum))
{
	$tpl = str_replace("<THUMBNAILS_WHOLE_PAGED>",$thumb_output,$tpl); //thumbnails in this page
	$tpl = str_replace("<THUMBNAILS_PAGES_LINKS>",$Archive_pages_Links,$tpl); // link to the pages of thumbnail in the selected category
	$tpl = str_replace("<ARCHIVE_PAGES_NUM>",$pagenum,$tpl);// page number you are viewing
	$tpl = str_replace("<CATEGORY_OR_DATE_NAME_PAGED_ARCHIVE>",$images_category_or_date,$tpl); // Name of the category or Month you select
} //end if
//-- If you do not use page archive
else
{
	$tpl = str_replace("<THUMBNAILS_PAGES_LINKS>","",$tpl); // this does not use paged archive so there should be no links
	$tpl = str_replace("<ARCHIVE_PAGES_NUM>","",$tpl); // page number you are viewing (it's empty for this case)

	if(!isset($thumb_output))	$thumb_output = "";

	$tpl = str_replace("<THUMBNAILS_WHOLE_PAGED>",$thumb_output,$tpl); // the original thumb row in the archive

	if(!isset($images_category_or_date))	$images_category_or_date = "";

	$tpl = str_replace("<CATEGORY_OR_DATE_NAME_PAGED_ARCHIVE>",$images_category_or_date,$tpl); // Name of the category or Month you select
}// end else

$tpl = str_replace("<LINK_TO_PAGED_ARCHIVE>",'<a href="index.php?x=browse&amp;pagenum=1">'.$lang_paged_archive.'</a>',$tpl);
$tpl = str_replace("<BROWSE_CATEGORIES_PAGED>",$browse_select,$tpl); //Browse menu for paged archive

// tags of Category List Of Links (default version)
$tpl = str_replace("<CATEGORY_LINKS_AS_LIST>",$category_Link_List,$tpl);

// paged version tages
$tpl = str_replace("<CATEGORY_LINKS_AS_LIST_PAGED>",$category_Link_List_paged,$tpl);

// bulid the new tag
$tpl = str_replace("<BROWSE_MONTHLY_ARCHIVE_PAGED>",$archive_select,$tpl);
$tpl = str_replace("<BROWSE_MONTHLY_ARCHIVE_AS_LINK_PAGED>",$archive_select_links,$tpl);
?>