The good old "last Images"

[Nicky]

to add my code to your code
was my question

[thunderstrike]

If www.katzen.ag (user) say code is work. Is ok.

[www.katzen.ag]

Hallo Jungs, hey guys,

your made a good Job - I*T*W*O*R*K*S

Danke noch einmal 

[www.katzen.ag]

Hello guys!

I just would like give a feedback. Just have a look... great Job!



http://www.katzen.ag

[thunderstrike]

Is look good.

[www.katzen.ag]

A little question...how can I put the last images in other php files? e.g. in details.php etc?
I Assume I have to include it, but how?

Best regards,
KatzenAG

[Nicky]

hi,

just use ONLY thunderstrike code in details.php.

add it before

Code: [Select]

?>

+ for template into details.html

[www.katzen.ag]

Yes, I but it doesn't work.
I had Insert in detail.php:

//-----------------------------------------------------
//--- Show Last images with thumbnails ----------------
//-----------------------------------------------------
$sql1 = "

SELECT i.image_id, i.image_name, i.image_thumb_file, i.image_media_file, i.cat_id" . get_user_table_field(", u.", "user_name") . "
FROM (" . IMAGES_TABLE . " i, " . CATEGORIES_TABLE . " c)
LEFT JOIN " . USERS_TABLE . " u ON (" . get_user_table_field("u.", "user_id") . " = i.user_id)
WHERE i.image_active = 1 AND i.cat_id = c.cat_id AND (i.cat_id NOT IN (".get_auth_cat_sql("auth_viewimage", "NOTIN").", ".get_auth_cat_sql("auth_viewcat", "NOTIN")."))
ORDER BY i.image_date DESC
LIMIT 3

";

$result = $site_db->query($sql1);
$num_rows = $site_db->get_numrows($result);

if (!$num_rows)  {
  $last_images_with_thumbnails = "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\"><tr class=\"imagerow1\"><td>";
  $last_images_with_thumbnails .= $lang['no_new_images'];
  $last_images_with_thumbnails .= "</td></tr></table>";
}
else  {
  $last_images_with_thumbnails = "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\">";
  $count = 0;
  $bgcounter = 0;
  while ($last_images_with_thumbnails_row = $site_db->fetch_array($result)) {
      $user_name = format_text(trim(ucfirst($last_images_with_thumbnails_row[$user_table_fields['user_name']]), 2));
     
    if ($count == 0) {
      $row_bg_number = ($bgcounter++ % 2 == 0) ? 1 : 2;
      $last_images_with_thumbnails .= "<tr class=\"imagerow".$row_bg_number."\">\n";
    }
    $last_images_with_thumbnails .= "<td width=\"".$imgtable_width."\" valign=\"top\">\n";

    show_image($last_images_with_thumbnails_row);
    $last_images_with_thumbnails .= $site_template->parse_template("thumbnail_bit_last_images");
    $last_images_with_thumbnails .= "\n</td>\n";
    $count++;
    if ($count == $config['image_cells']) {
      $last_images_with_thumbnails .= "</tr>\n";
      $count = 0;
    }
  } // end while

  if ($count > 0)  {
    $leftover = ($config['image_cells'] - $count);
    if ($leftover >= 1) {
      for ($f = 0; $f < $leftover; $f++) {
        $last_images_with_thumbnails .= "<td width=\"".$imgtable_width."\">\n&nbsp;\n</td>\n";
      }
      $last_images_with_thumbnails .= "</tr>\n";
    }
  }
  $last_images_with_thumbnails .= "</table>\n";
} // end else


$site_template->register_vars("lang_last_images_with_thumbnails_from_home", preg_replace("/" . $site_template->start . "user_name" . $site_template->end . "/siU", $user_name, $lang['last_images_with_thumbnails_from_home']));
$site_template->register_vars("last_images_with_thumbnails", $last_images_with_thumbnails);
unset($last_images_with_thumbnails);

and of course in details.html:

{last_images_with_thumbnails}

It seems, that is not enough?
Hmmpf, in my next life I will became a php programmer 

PS: I know you are german, but Ihink this issue could be intresting for english spoken users too.

KatzenAG

[Nicky]

ok.. i didn't test it before.

instead of

Code: [Select]

?>
add it before

Code: [Select]

//-----------------------------------------------------
//--- Show Image --------------------------------------
//-----------------------------------------------------

than it's works

[www.katzen.ag]

YES!!!

So, this issue has been solved.

Thanks