future images?

[mat]

http://www.lomat.org/index.php?x=browse&archivedate=2005-05&monthname=May,%202005&pagenum=1

i have an image that will go live tomorrow...

it's interesting because the archives pages says there are three pictures for the month of may, yet you only see two thumbnails...

was this intentional? i dont really care one way or another, just struck me as strange...

mat

[Joe[y]]

oh yeah. this could be a problem for when you post something at the end of the month for the next month. we don't want to be displaying blank archive pages!


i'll watch this thread.

[mat]

oh yeah. this could be a problem for when you post something at the end of the month for the next month. we don't want to be displaying blank archive pages!


i'll watch this thread.

yeah, i would imagine it would happen like that too...

(man you guys reply quickly!!!)

[Joe[y]]

oh yeah. this could be a problem for when you post something at the end of the month for the next month. we don't want to be displaying blank archive pages!


i'll watch this thread.

yeah, i would imagine it would happen like that too...

(man you guys reply quickly!!!)


yes. i have for one will do anything to avoid real work (an english essay) - so right now i'm checking over the paged_archive addon to see if i can figured out how to change this.

[mat]

awesome ;)

i know what you mean... i am the same way...

[raminia]

I'll correct this tonight or tomorrow.

[raminia]

modify the lines 160-162 to
$query = "select distinct DATE_FORMAT(datetime, '%Y-%m') from ".$pixelpost_db_prefix."pixelpost
where datetime<='$datetime'
order by datetime desc";

the line 167 to

where DATE_FORMAT(datetime, '%Y-%m')='".$thedate ."' and datetime<='$datetime'";

line 189 to
$query = mysql_query("select DISTINCT DATE_FORMAT(datetime, '%Y-%m') from ".$pixelpost_db_prefix."pixelpost where datetime<='$datetime' order by datetime desc");

line 191 to
$query3 = "select count(*) as count from ".$pixelpost_db_prefix."pixelpost where DATE_FORMAT(datetime, '%Y-%m')='".$thedate ."' and datetime<='$datetime'";

OR

use these codes and replace the addon with this. (this is the latest version which includes some more bug fixes in the forum.)
<?php
/*

Requires Pixelpost version 1.4 or newer
Page-By-Page-Archive
ADDON-Version 0.6

Written by: Ramin Mehran
Contact: raminia@yahoo.com

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

License: http://www.gnu.org/copyleft/gpl.html

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.

================================================== ==========================

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);
*/

$addon_name = "Page-By-Page-Archive for category and month (for PP v1.4)";
$addon_version = "0.6";

$maxpthumb = $cfgrow['maxpthumb'];

if ($_GET['updatedflagp']=="1")
{$isupdated = "<font color='#FF0000'>Updated!</font>";}
else
{$isupdated = ""; }
// 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 ($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($_GET['x'] == "maxpthumb") {
$newmaxpthumb = $_POST['newmaxpthumb'];
$query = "update ".$pixelpost_db_prefix."config set maxpthumb='" .$newmaxpthumb ."'" ;
$update = mysql_query($query );
$to = './admin/?view=addons&updatedflagp=1';

header('Location: '. $to);
exit;

};

// description
$addon_description = "$attention_call Page by page category and month archive. Usefull when you have
plenty of photos in archive and you want to show them in few pages and not just as a whole. Compatible with Pixelpost version 1.3 with multi category mod and version 1.4.
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?x=maxpthumb'>
<input type='text' name='newmaxpthumb' value='".$maxpthumb ."' style='width:40px'>
<input type='submit' value='update'>
</form> $isupdated
";

// 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);
// number of photos in the database
$pixelpost_all_photonumb = $row['count'] ;

//-------------------------------- 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 = " <a href='index.php?x=browse&pagenum=1'> $lang_browse_all (" .$count .") </a><br />";

$query = mysql_query("select * from ".$pixelpost_db_prefix."categories order by name");
while(list($id,$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);
$count= $count['count'];
$name = pullout($name);
$catname_count = $name ." (" .$count .")";

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

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


// 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);


//----------- Monthly Archive Menu and List
if ($_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.sel ectedIndex].value;'><option value=''>Monthly archive</option><option value='index.php?x=browse&archivedate=$thedate &pagenum=1'>$lang_browse_all (" .$pixelpost_all_photonumb .")</option>";
$archive_select_links = "Monthly archive: <br /><a href='index.php?x=browse&archivedate=$thedate& amp;pagenum=1'>$lang_browse_all (" .$pixelpost_all_photonumb .")</a>";
$query = "select distinct DATE_FORMAT(datetime, '%Y-%m') from ".$pixelpost_db_prefix."pixelpost
where 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 DATE_FORMAT(datetime, '%Y-%m')='".$thedate ."' and datetime<='$datetime'";
$count = mysql_query($query2);
$count = mysql_fetch_array($count);
$count= $count['count'];
$select_display_date=date("F, Y",strtotime($thedate."-01"));
$thedate = pullout($thedate);
$archive_select .= "<option value='index.php?x=browse&archivedate=$thedate &monthname=$select_display_date&pagenum =1'>$name (" .$select_display_date .") (" .$count .")</option>";
$archive_select_links .= "<br /><a href='index.php?x=browse&archivedate=$thedate& amp;monthname=$select_display_date&pagenum=1'>$name (" .$select_display_date .") (" .$count .")</a>";
};// end while
$archive_select .= "</select>";

} // 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"));
$archive_select = "<select name='browse'
onChange='self.location.href=this.options[this.sel ectedIndex].value;'><option value=''>Monthly archive</option><option value='index.php?x=browse&archivedate=$thedate &pagenum=1'>$lang_browse_all (" .$pixelpost_all_photonumb .")</option>";
$archive_select_links = "Monthly archive:<br /><a href='index.php?x=browse&archivedate=$thedate& amp;pagenum=1'>$lang_browse_all (" .$pixelpost_all_photonumb .")</a>";

$query = mysql_query("select DISTINCT DATE_FORMAT(datetime, '%Y-%m') from ".$pixelpost_db_prefix."pixelpost where datetime<='$datetime' 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 ."' and datetime<='$datetime'";
$count = mysql_query($query3);
$count = mysql_fetch_array($count);
$count= $count['count'];

$select_display_date=date("F, Y",strtotime($thedate."-01"));
$thedate = pullout($thedate);
$archive_select .= "<option value='index.php?x=browse&archivedate=$thedate '>$name (" .$select_display_date .") (" .$count .")</option>";
$archive_select_links .= "<br /><a href='index.php?x=browse&archivedate=$thedate'>$name (" .$select_display_date .") (" .$count .")</a>";
}; // end while
$archive_select .= "</select>";
} // end else

// 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);

//--------------- check if it should be the browse page
if($_GET['x'] == "browse") {
// initialize variables
$thumb_output = "";
$where = "";
$limit = "";
$pagenum = $_GET['pagenum'];

// did user select a category?

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

// do you use links with page number?
if ($_GET['pagenum'] != "") {
$start = $maxnumber_thumbs*($_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 ($_GET['archivedate']=="")
{
// no archive date
$query = "select t1.id,t1.headline,t1.image from {$pixelpost_db_prefix}pixelpost as t1
inner join {$pixelpost_db_prefix}catassoc as t2
where (t1.datetime<='$cdate')
$where
and t1.id = t2.image_id
group by t1.id
order by t1.datetime desc" .$limit;

} // if ($_GET['archivedate']=="")
else
{ // archive date is available
$archivedate_start = $_GET['archivedate'] ."-01 00:00:00";
$archivedate_end = $_GET['archivedate'] ."-31 23:59:59";
$query = "select id,headline,image from ".$pixelpost_db_prefix."pixelpost where (datetime<='$cdate' and datetime >='$archivedate_start' and datetime <= '$archivedate_end') $where order by datetime desc" .$limit;
}// end else if ($_GET['archivedate']=="")

$query = mysql_query($query);

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

// for each record ...
while(list($id,$title,$name) = mysql_fetch_row($query)) {

// from the thumbnail row. This could be build by tables too.
$title = htmlspecialchars(pullout($title), ENT_QUOTES);
$thumbnail = "thumbnails/thumb_$name";
$thumb_output .= "<a href='$PHP_SELF?showimage=$id'><img src='$thumbnail' alt='$title' title='$title' class='thumbnails' /></a>";

} //end while
// initialize page counter
$pagecounter=0;

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

// initialize where command
$where = "";

// check if user selects a category
if($_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 = '".$_GET['category']."' AND datetime<='$datetime')";
$queryr .= " group by t1.cat_id ";

}// end if
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

$monthname = "";
if($_GET['archivedate'] != "") {
$archivedate_start = $_GET['archivedate'] ."-01 00:00:00";
$archivedate_end = $_GET['archivedate'] ."-31 23:59:59";
$where = " and datetime >='$archivedate_start' and datetime <= '$archivedate_end' ";
$monthname = $_GET['monthname'];
$queryr = "select count(*) as count from ".$pixelpost_db_prefix."pixelpost where datetime<='$datetime'" .$where;
} // end if($_GET['archivedate'] != "")

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

// calculate the number of pages
$num_browse_pages = ceil($pixelpost_photonumb/$maxnumber_thumbs);

// initialize archive links
$Archive_pages_Links = "";
// selected category id
$cat_id = $_GET['category'];

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

if ($_GET['category']!="")
{
$pagecounter = 0;
while ($pagecounter < $num_browse_pages)
{
$pagecounter++;
$Archive_pages_Links .= "<a href='index.php?x=browse&category=$cat_id& pagenum=$pagecounter'>$pagecounter</a> ";
}// end while
}// end if
else
{
if ($_GET['pagenum']!=""&$_GET['archivedate']=="")
{
$pagecounter = 0;
while ($pagecounter < $num_browse_pages)
{
$pagecounter++;
$Archive_pages_Links .= "<a href='index.php?x=browse&category=&pagenum =$pagecounter'>$pagecounter</a> ";
}// end while
}// end if
if ($_GET['archivedate']!="")
{
$pagecounter = 0;
while ($pagecounter < $num_browse_pages)
{
$monthname=str_replace(" ","%20",$monthname);
$pagecounter++;
$archivedate=$_GET['archivedate'];
$Archive_pages_Links .= "<a href='index.php?x=browse&archivedate=$archived ate&monthname=$monthname&pagenum=$pagecoun ter'>$pagecounter</a> ";
}// whilte
}// end if $_GET['archivedate']!=""
}// end else

// selected category name
if($cat_id != "") {
$query = mysql_query("select name from ".$pixelpost_db_prefix."categories where id='$cat_id'");
$images_category_or_date = mysql_fetch_array($query);
$images_category_or_date = pullout($images_category_or_date['name']);
}
else
{
if ($_GET['archivedate']=="")
{$images_category_or_date = $lang_browse_all;}
else
{$images_category_or_date = $_GET['monthname'];}
}


} // end if ($_GET['x'] == "browse")

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

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


$query = mysql_query("select * from ".$pixelpost_db_prefix."categories order by name");
while(list($id,$name) = mysql_fetch_row($query)) {
$name = pullout($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);
$count= $count['count'];
// check if you are using this addon
if ($maxpthumb>0) {
// u r using
$browse_select .= "<option value='index.php?x=browse&category=$id&pag enum=1'>$name (" .$count .")</option>";
} // end if pagenum!=""
else {
// use the original browse category menu
$browse_select .= "<option value='index.php?x=browse&category=$id'>$name (" .$count .")</option>";};

} // end while

// finilize the tag
$browse_select .= "</select>";
$tpl = str_replace("<BROWSE_CATEGORIES_PAGED>",$browse_select,$tpl); //Browse menu for paged archive


//----------------- Build the additional new tages
//-- If you use paged archive
if ($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)
$tpl = str_replace("<THUMBNAILS_WHOLE_PAGED>",$thumb_output,$tpl); // the original thumb row in the archive
$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&pagenum=1">Archive</a>',$tpl);


?>

*for my furthur notice only: CVS is updated for this.