1
Mods & Plugins (Requests & Discussions) / New Pics in Category
« on: January 23, 2003, 05:44:47 PM »
gti-the-sexy
glad that my pm was some help for you
christian
glad that my pm was some help for you

christian
4images code on GitHub Click here to visit GitHub.
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.
define('PIC_USERS_TABLE', '4images_users');
define('PIC_USERS_TABLE', 'phpbb_users');
<?php
define('ROOT_PATH', './4images/');
define('PIC_CATEGORIES_TABLE', '4images_categories');
define('PIC_IMAGES_TABLE', '4images_images');
define('PIC_USERS_TABLE', 'phpbb_users');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$user_access = get_permission();
$number_of_new_pics = 5;
$days_to_be_new = 30;
$new_cutoff = time() - 60 * 60 * 24 * $days_to_be_new;
$cat_id_sql = get_auth_cat_sql("auth_viewcat", "NOTIN");
$sql = "SELECT MAX(cat_id) as max_id FROM ".PIC_CATEGORIES_TABLE;
$row = $site_db->query_firstrow($sql);
$cat_max_id = (!empty($row['max_id'])) ? $row['max_id'] : 0;
$total_images_found = 0;
for ($i = 0; $i <= $cat_max_id; $i++){
$sql = "SELECT i.image_id, i.cat_id, i.image_active, i.image_name, i.image_date, c.cat_name
FROM ".PIC_IMAGES_TABLE." i, ".PIC_CATEGORIES_TABLE." c
WHERE i.image_active = 1 AND i.image_date >= $new_cutoff AND c.cat_id = i.cat_id AND i.cat_id = $i";
$result = $site_db->query($sql);
$row = $site_db->fetch_array($result);
$images_in_category = $site_db->get_numrows($result);
$total_images_found = $total_images_found + $images_in_category;
$category_name = ($row['cat_name']);
$category_id = ($row['cat_id']);
$category_link = ("<a href=\"" . ROOT_PATH . "categories.php?cat_id=" . $category_id . "\">");
if ($images_in_category) {
echo "Found <b>$images_in_category</b> new images in category <b>$category_name</b> $category_link ...view category </a><br>";}
$sql = "SELECT i.image_id, i.cat_id, i.image_active, i.image_name, i.image_date, c.cat_name, u.username
FROM ".PIC_IMAGES_TABLE." i, ".PIC_CATEGORIES_TABLE." c
LEFT JOIN ".PIC_USERS_TABLE." u ON u.user_id = i.user_id
WHERE i.image_active = 1 AND i.image_date >= $new_cutoff AND c.cat_id = i.cat_id AND i.cat_id = $i
ORDER BY i.image_date DESC
LIMIT $number_of_new_pics";
$result = $site_db->query($sql);
while ($row = $site_db->fetch_array($result)) {
$image_name = ($row['image_name']);
$image_id = ($row['image_id']);
$image_date = format_date($config['date_format']." ".$config['time_format'],$row['image_date']);
$category_name = ($row['cat_name']);
$user_name = ($row['user_name']);
$media_path = ($row['image_media_file']);
$image_link = ("<a href=\"" . ROOT_PATH . "details.php?image_id=" . $image_id . "\">");
echo "<ul><b>$image_name</b> uploaded by <b>$user_name</b> at <b>$image_date</b> $image_link ...view image </a></ul>";
}
}
if (!$total_images_found) {
$gallery_link = ("<a href=\"" . ROOT_PATH . "index.php" . "\">");
echo "No new images found within last $days_to_be_new days. Click $gallery_link here</a> to surf the gallery...<br>";
} else {
$allnew_link = ("<a href=\"" . ROOT_PATH . "search.php?search_new_images=1" . "\">");
echo "$allnew_link Would you like to see all new images? </a>";
}
?>
$allnew_link
<?php
define('ROOT_PATH', './4images/');
define('PIC_CATEGORIES_TABLE', '4images_categories');
define('PIC_IMAGES_TABLE', '4images_images');
define('PIC_USERS_TABLE', '4images_users');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$user_access = get_permission();
$number_of_new_pics = 1;
$days_to_be_new = 100;
$new_cutoff = time() - 60 * 60 * 24 * $days_to_be_new;
$cat_id_sql = get_auth_cat_sql("auth_viewcat", "NOTIN");
$sql = "SELECT MAX(cat_id) as max_id FROM ".PIC_CATEGORIES_TABLE;
$row = $site_db->query_firstrow($sql);
$cat_max_id = (!empty($row['max_id'])) ? $row['max_id'] : 0;
for ($i = 0; $i <= $cat_max_id; $i++){
$sql = "SELECT i.image_id, i.cat_id, i.image_active, i.image_name, i.image_date, c.cat_name
FROM ".PIC_IMAGES_TABLE." i, ".PIC_CATEGORIES_TABLE." c
WHERE i.image_active = 1 AND i.image_date >= $new_cutoff AND c.cat_id = i.cat_id AND i.cat_id = $i";
$result = $site_db->query($sql);
$row = $site_db->fetch_array($result);
$images_in_category = $site_db->get_numrows($result);
$category_name = ($row['cat_name']);
$category_id = ($row['cat_id']);
$category_link = ("<a href=\"" . ROOT_PATH . "categories.php?cat_id=" . $category_id . "\">");
if ($images_in_category) { echo "Found <b>$images_in_category</b> new images in category <b>$category_name</b> $category_link ...view category </a><br>"; }
$sql = "SELECT i.image_id, i.cat_id, i.image_active, i.image_name, i.image_date, c.cat_name, u.user_name
FROM ".PIC_IMAGES_TABLE." i, ".PIC_CATEGORIES_TABLE." c
LEFT JOIN ".PIC_USERS_TABLE." u ON u.user_id = i.user_id
WHERE i.image_active = 1 AND i.image_date >= $new_cutoff AND c.cat_id = i.cat_id AND i.cat_id = $i
ORDER BY i.image_date DESC
LIMIT $number_of_new_pics";
$result = $site_db->query($sql);
while ($row = $site_db->fetch_array($result)) {
$image_name = ($row['image_name']);
$image_id = ($row['image_id']);
$category_name = ($row['cat_name']);
$user_name = ($row['user_name']);
$media_path = ($row['image_media_file']);
$image_link = ("<a href=\"" . ROOT_PATH . "details.php?image_id=" . $image_id . "\">");
$allnew_link = ("<a href=\"" . ROOT_PATH . "search.php?search_new_images=1" . "\">");
echo "<ul><b>$image_name</b> uploaded by <b>$user_name</b> $image_link ...view image </a></ul>";
}
}
echo "$allnew_link Show all new images? </a>";
?>
$sql = "SELECT MAX(cat_id) as max_id FROM ".4images_categories;
<?php
define('ROOT_PATH', './4images/');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$user_access = get_permission();
$number_of_new_pics = 15;
$days_to_be_new = 1;
$new_cutoff = time() - 60 * 60 * 24 * $days_to_be_new;
$cat_id_sql = get_auth_cat_sql("auth_viewcat", "NOTIN");
$sql = "SELECT MAX(cat_id) as max_id FROM ".4images_categories;
$row = $site_db->query_firstrow($sql);
$cat_max_id = (!empty($row['max_id'])) ? $row['max_id'] : 0;
for ($i = 0; $i <= $cat_max_id; $i++){
$sql = "SELECT i.image_id, i.cat_id, i.image_active, i.image_name, i.image_date, c.cat_name
FROM ".4images_images." i, ".4images_categories." c
WHERE i.image_active = 1 AND i.image_date >= $new_cutoff AND c.cat_id = i.cat_id AND i.cat_id = $i";
$result = $site_db->query($sql);
$row = $site_db->fetch_array($result);
$images_in_category = $site_db->get_numrows($result);
$category_name = ($row['cat_name']);
$category_id = ($row['cat_id']);
$category_link = ("<a href=\"" . ROOT_PATH . "categories.php?cat_id=" . $category_id . "\">");
if ($images_in_category) { echo "Found <b>$images_in_category</b> new images in category <b>$category_name</b> $category_link ...view category </a><br>"; }
$sql = "SELECT i.image_id, i.cat_id, i.image_active, i.image_name, i.image_date, c.cat_name, u.user_name
FROM ".4images_images." i, ".4images_categories." c
LEFT JOIN ".4images_users." u ON u.user_id = i.user_id
WHERE i.image_active = 1 AND i.image_date >= $new_cutoff AND c.cat_id = i.cat_id AND i.cat_id = $i
ORDER BY i.image_date DESC
LIMIT $number_of_new_pics";
$result = $site_db->query($sql);
while ($row = $site_db->fetch_array($result)) {
$image_name = ($row['image_name']);
$image_id = ($row['image_id']);
$category_name = ($row['cat_name']);
$user_name = ($row['user_name']);
$media_path = ($row['image_media_file']);
$image_link = ("<a href=\"" . ROOT_PATH . "details.php?image_id=" . $image_id . "\">");
$allnew_link = ("<a href=\"" . ROOT_PATH . "search.php?search_new_images=1" . "\">");
echo "<ul><b>$image_name</b> uploaded by <b>$user_name</b> $image_link ...view image </a></ul>";
}
}
echo "$allnew_link Show all new images? </a>";
?>
"Show me those categories where new images have been added the recent 7 days"
NEWEST PICS in the IMAGE GALLERY!!!
You can find new Pics in Catagory:
- .... (insert name here) (date)
- .... (insert name here) (date)
- ....
Warning: getimagesize: Read error! in /home/httpd/docs/ttomuc/4images/admin/thumbnailer.php on line 115
$image_info = getimagesize(MEDIA_PATH."/".$image_row['cat_id']."/".$image_row['image_media_file']);
Ich komme mit der Formatierung nicht klar.