Paged_Archive v1.0 bug

[posefius]

I discovered 2 bugs in the Page-By-Page-Archive addon. When you call this addon from the image page to display the pictures in a specific category belonging to the picture, for example <a href='index.php?x=browse&amp;category=4'> you get the following bugs:

1: The month totals of pictures posted in the future are displayed

2: All the pictures in the specified category are displayed without page numbers

I hope the addon can be fixed because I like it very much, especially when you have a large database.

[GeoS]

I dont get point 1.

2. No there isnt like that if you use proper tag. Look i.e. on my site.

[posefius]

You dont understand the problem. When you click the archive choice from the bar on my image page you get it the right way. Only the categories and monthly archive of the pictures that are posted now and in the past. But when you click the category choice from the image page, you get the monthly archive of all the pictures, also the ones posted into the future. Just take a look at my site and try it;

http://www.dutchphotoday.nl/index.php?showimage=731

first click on the archive from the menu bar all is ok
second click on the category choice on the image page and you see the problem

[GeoS]

There was a problem with showing fututre images but currently on your site all looks fine.
Someone was making fix in last few days. Look for it on forum.

[posefius]

I mean clicking on a category of the picture on the home page (the image page) to go automaticly to the archives page displaying all the pictures belonging to the category, and than you can see the bug I mentioned.

You dont see page numbers in the heading and the monthly archive totals of future pictures are also showed.

Try this link: http://www.dutchphotoday.nl/index.php?showimage=779 and than click on the category [Typical Dutch] just below the title.

[GeoS]

So you need to modify my addon (v. 1.6).

1) change from (near line 189/197):
// Modified from Mark Lewin's hack for multiple categories
$sql8 = "SELECT 1, t2.id, t2.headline, t2.image, t2.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<='$cdate')
ORDER BY datetime DESC";
$link_cat = "&amp;category=" . $_GET["category"];
$lookingfor = 1;

to:
// Modified from Mark Lewin's hack for multiple categories
$sql8 = "SELECT 1, t2.id, t2.headline, t2.image, t2.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<='$cdate')
ORDER BY datetime DESC";
$link_cat = "&amp;pagenum=1&amp;category=" . $_GET["category"];
$lookingfor = 1;

2) change from (near line 218/227):
$sql8 = "SELECT count(t1.id), t2.id, t2.headline, t2. image,t2. datetime
FROM {$pixelpost_db_prefix}catassoc AS t1
INNER JOIN {$pixelpost_db_prefix}pixelpost t2 ON t2.id = t1.image_id
WHERE (datetime<='$cdate') AND
$sc_thumb_where
GROUP BY t2.id
ORDER BY datetime, t2.id DESC";
$link_cat = "&amp;category=" . $cat;
$lookingfor = $sc_cat_numb+1;

to:
$sql8 = "SELECT count(t1.id), t2.id, t2.headline, t2. image,t2. datetime
FROM {$pixelpost_db_prefix}catassoc AS t1
INNER JOIN {$pixelpost_db_prefix}pixelpost t2 ON t2.id = t1.image_id
WHERE (datetime<='$cdate') AND
$sc_thumb_where
GROUP BY t2.id
ORDER BY datetime, t2.id DESC";
$link_cat = "&amp;pagenum=1&amp;category=" . $cat;
$lookingfor = $sc_cat_numb+1;