Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
//-----------------------------------------------------
//--- 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 \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);
{last_images_with_thumbnails}
