function phphoto_text($db, $category, $name)
{
$language = GALLERY_LANGUAGE;
$argv = func_get_args();
array_shift($argv);
// $db
array_shift($argv);
// $category
array_shift($argv);
// $name
$sql = sprintf("SELECT text, parameters FROM texts WHERE language_id = '%s' AND category = '%s' AND name = '%s';", mysql_real_escape_string($language), mysql_real_escape_string($category), mysql_real_escape_string($name));
$result = phphoto_db_query($db, $sql);
if (count($result) != 1) {
return "@{$category}:{$name}@";
}
$text = $result[0];
if ($text['parameters'] != count($argv)) {
return "@{$category}:{$name}:{$text['parameters']}@";
}
return call_user_func_array('sprintf', array_merge((array) $result[0]['text'], $argv));
}
function phphoto_echo_galleries($db)
{
$gallery_sql = "\n SELECT\n id,\n title,\n description,\n (SELECT COUNT(*) FROM image_to_gallery WHERE gallery_id = g.id) AS images,\n \n (SELECT MAX(changed) FROM\n (\n (SELECT temp1.changed, temp1.id AS gallery_id FROM galleries temp1)\n UNION\n (SELECT temp2.changed, temp2.gallery_id FROM image_to_gallery temp2)\n UNION\n (SELECT (SELECT changed FROM images WHERE id = temp3.image_id) AS changed, temp3.gallery_id FROM image_to_gallery temp3)\n ) temp\n WHERE\n gallery_id = g.id\n ) AS changed\n FROM\n galleries g\n WHERE\n active = TRUE\n AND\n (\n SELECT COUNT(*) FROM image_to_gallery itg WHERE itg.gallery_id = g.id\n AND\n (\n SELECT COUNT(*) FROM images i WHERE i.id = itg.image_id AND active = TRUE\n ) > 0\n ) > 0\n ORDER BY\n " . GALLERY_SORT_COLUMN . "\n ";
$tag_sql = "\n SELECT\n id,\n name,\n description\n FROM\n tags t\n WHERE\n active = TRUE\n AND\n (\n SELECT COUNT(*) FROM image_to_tag itt WHERE itt.tag_id = t.id\n AND\n (\n SELECT COUNT(*) FROM images i WHERE i.id = itt.image_id AND active = TRUE\n ) > 0\n ) > 0\n ORDER BY\n name\n ";
echo "\n<div class='header'>";
echo "\n <p><a href='" . GALLERY_INDEX_PAGE . "'>" . GALLERY_TITLE . "</a></p>";
echo "\n</div>";
echo "\n<div class='container'>";
echo "\n <h1>" . GALLERY_WELCOME . "</h1>";
echo "\n <div class='wrapper'>";
foreach (phphoto_db_query($db, $gallery_sql) as $gallery) {
echo "\n <div class='gallery'>";
echo "\n <a href='" . CURRENT_PAGE . "?" . GET_KEY_GALLERY_ID . "={$gallery['id']}'>";
echo "\n <img class='thumbnail' src='image.php?" . GET_KEY_GALLERY_ID . "={$gallery['id']}' title='{$gallery['description']}' alt='{$gallery['title']}' />";
echo "\n <h1>" . format_string($gallery['title'], 30) . "</h1>";
echo "\n <h2>updated " . format_date_time($gallery['changed']) . "</h2>";
echo "\n <p>" . format_string($gallery['description']) . "</p>";
echo "\n </a>";
echo "\n </div>";
}
echo "\n </div>";
// echo links for the different tags
$tags = array();
foreach (phphoto_db_query($db, $tag_sql) as $tag) {
array_push($tags, "<a href='" . CURRENT_PAGE . "?" . GET_KEY_TAG_ID . "={$tag['id']}' title='{$tag['description']}'>{$tag['name']}</a>");
}
if (count($tags) > 0) {
echo "\n <p>" . phphoto_text($db, 'section', 'tags') . ": " . implode(', ', $tags) . '</p>';
}
echo "\n</div>";
phphoto_echo_gallery_footer("<a href='http://github.com/RiJo/phphoto'>" . GALLERY_NAME . ' v.' . GALLERY_VERSION . "</a>");
}
$image = $result[0]['image'];
$type = $result[0]['type'];
if ($thumbnail) {
header('Content-type: image/png');
} else {
header('Content-type: ' . image_type_to_mime_type($type));
}
echo $image;
exit;
} elseif (isset($_GET[GET_KEY_GALLERY_ID])) {
$id = $_GET[GET_KEY_GALLERY_ID];
if (!is_numeric($id)) {
not_valid_id($id, 'the id is not numeric');
}
$db = phphoto_db_connect();
$result = phphoto_db_query($db, "SELECT thumbnail AS image FROM galleries WHERE id = {$id};");
phphoto_db_connect($db);
if (empty($result)) {
not_valid_id($id, 'there is no gallery in the database with that id');
}
if ($result[0]['image'] == null) {
$image = phphoto_generate_null_image();
} else {
$image = $result[0]['image'];
}
header('Content-type: image/png');
echo $image;
exit;
} else {
not_valid_id('', 'no image requested');
}
function phphoto_echo_admin_images($db)
{
phphoto_upload_image($db);
phphoto_image_thumbnails($db);
$order_by = isset($_GET[GET_KEY_SORT_COLUMN]) ? $_GET[GET_KEY_SORT_COLUMN] : 2;
$items_per_page = isset($_GET[GET_KEY_ITEMS_PER_PAGE]) ? $_GET[GET_KEY_ITEMS_PER_PAGE] : DEFAULT_ITEMS_PER_PAGE;
assert(is_numeric($items_per_page));
// prevent SQL injections
$page_number = isset($_GET[GET_KEY_PAGE_NUMBER]) ? $_GET[GET_KEY_PAGE_NUMBER] : 0;
assert(is_numeric($page_number));
// prevent SQL injections
$sql = "SELECT CEIL(COUNT(*) / {$items_per_page}) AS pages FROM images";
$pages = phphoto_db_query($db, $sql);
$pages = $pages[0]['pages'] > 0 ? $pages[0]['pages'] : 1;
$sql = sprintf("\n SELECT\n id,\n IF (LENGTH(title) > 0, title, filename) AS name,\n active,\n width,\n height,\n (SELECT COUNT(*) FROM image_to_gallery WHERE image_id = id) AS galleries,\n (SELECT COUNT(*) FROM image_to_tag WHERE image_id = id) AS tags,\n views,\n views / (SELECT SUM(views) FROM images) AS popularity\n FROM\n images\n ORDER BY\n %s\n LIMIT\n " . $page_number * $items_per_page . ", {$items_per_page}", mysql_real_escape_string($order_by, $db));
$header = array(phphoto_text($db, 'header', 'thumbnail'), "<a href='" . CURRENT_PAGE . '?' . GET_KEY_ADMIN_QUERY . '=' . GET_VALUE_ADMIN_IMAGE . '&' . GET_KEY_SORT_COLUMN . "=2'>" . phphoto_text($db, 'header', 'name') . "</a>", "<a href='" . CURRENT_PAGE . '?' . GET_KEY_ADMIN_QUERY . '=' . GET_VALUE_ADMIN_IMAGE . '&' . GET_KEY_SORT_COLUMN . "=3'>" . phphoto_text($db, 'header', 'active') . "</a>", "<a href='" . CURRENT_PAGE . '?' . GET_KEY_ADMIN_QUERY . '=' . GET_VALUE_ADMIN_IMAGE . '&' . GET_KEY_SORT_COLUMN . "=4'>" . phphoto_text($db, 'header', 'resolution') . "</a>", "<a href='" . CURRENT_PAGE . '?' . GET_KEY_ADMIN_QUERY . '=' . GET_VALUE_ADMIN_IMAGE . '&' . GET_KEY_SORT_COLUMN . "=6'>" . phphoto_text($db, 'header', 'galleries') . "</a>", "<a href='" . CURRENT_PAGE . '?' . GET_KEY_ADMIN_QUERY . '=' . GET_VALUE_ADMIN_IMAGE . '&' . GET_KEY_SORT_COLUMN . "=7'>" . phphoto_text($db, 'header', 'tags') . "</a>", "<a href='" . CURRENT_PAGE . '?' . GET_KEY_ADMIN_QUERY . '=' . GET_VALUE_ADMIN_IMAGE . '&' . GET_KEY_SORT_COLUMN . "=8'>" . phphoto_text($db, 'header', 'views') . "</a>", ' ');
$max_text_length = 12;
$data = array();
foreach (phphoto_db_query($db, $sql) as $row) {
array_push($data, array("<a href='" . CURRENT_PAGE . '?' . GET_KEY_ADMIN_QUERY . '=' . GET_VALUE_ADMIN_IMAGE . '&' . GET_KEY_IMAGE_ID . "={$row['id']}'>\n <img src='image.php?" . GET_KEY_IMAGE_ID . "={$row['id']}t' class='thumbnail' /></a>", wordwrap(format_string($row['name']), 20, '<br>', true), format_bool($row['active']), $row['width'] . 'x' . $row['height'] . '<br>' . phphoto_image_aspect_ratio($row['width'], $row['height']), $row['galleries'], $row['tags'], $row['views'] . " (" . round($row['popularity'] * 100) . "%)", !$row['galleries'] && !$row['tags'] ? "<a href='" . CURRENT_PAGE . '?' . GET_KEY_ADMIN_QUERY . '=' . GET_VALUE_ADMIN_IMAGE . '&' . GET_KEY_OPERATION . '=' . GET_VALUE_DELETE . '&' . GET_KEY_IMAGE_ID . "={$row['id']}'><img src='./icons/process-stop.png' /></a>" : "<img src='./icons/process-stop-inactive.png' />"));
}
echo "\n<div class='admin'>";
echo "\n <h1>" . phphoto_text($db, 'section', 'images') . "</h1>";
$url_previous = CURRENT_PAGE . '?' . GET_KEY_ADMIN_QUERY . '=' . GET_VALUE_ADMIN_IMAGE . '&' . GET_KEY_PAGE_NUMBER . '=' . ($page_number - 1);
$url_next = CURRENT_PAGE . '?' . GET_KEY_ADMIN_QUERY . '=' . GET_VALUE_ADMIN_IMAGE . '&' . GET_KEY_PAGE_NUMBER . '=' . ($page_number + 1);
$footer = array(phphoto_page_numbering($db, $page_number, $pages, $url_previous, $url_next));
phphoto_to_html_table($data, $header, $footer);
echo "\n</div>";
}
function phphoto_regenerate_image_thumbnails($db)
{
$regenerated_thumbnails = 0;
$sql = "SELECT id, data FROM images";
foreach (phphoto_db_query($db, $sql) as $image) {
$temp_resource = imagecreatefromstring($image['data']);
if (!imagejpeg($temp_resource, IMAGE_TEMP_FILE, IMAGE_THUMBNAIL_QUALITY)) {
die('Could not create new jpeg image');
}
$thumbnail = phphoto_generate_image_data(IMAGE_TEMP_FILE, IMAGE_THUMBNAIL_WIDTH, IMAGE_THUMBNAIL_HEIGHT, IMAGE_THUMBNAIL_PANEL_COLOR);
$sql = "UPDATE images SET thumbnail = '{$thumbnail}' WHERE id = {$image['id']}";
$regenerated_thumbnails += phphoto_db_query($db, $sql);
}
return $regenerated_thumbnails;
}