summaryrefslogtreecommitdiff
path: root/lib/image/index.php
diff options
context:
space:
mode:
Diffstat (limited to 'lib/image/index.php')
-rw-r--r--lib/image/index.php14
1 files changed, 12 insertions, 2 deletions
diff --git a/lib/image/index.php b/lib/image/index.php
index 59a304d..b9748dc 100644
--- a/lib/image/index.php
+++ b/lib/image/index.php
@@ -6,6 +6,7 @@ $filters = array (
"order" => array (
"name" => "title",
"upl_date" => "date uploaded",
+ "folder_name" => "folder",
),
"way" => $ord_ways,
);
@@ -17,7 +18,10 @@ $fdefaults = array (
$title = "Image upload";
$images = array();
-$files = sql("SELECT * FROM images WHERE owner = " . $user['id'] .
+$files = sql("SELECT images.id AS id, images.name AS name, images.extension AS extension, images.upl_date AS upl_date, ".
+ "images.comment_html AS comment_html, img_folders.id AS folder_id, img_folders.name AS folder_name ".
+ " FROM images LEFT JOIN img_folders ON img_folders.id = images.folder ".
+ "WHERE images.owner = " . $user['id'] .
" ORDER BY " . get_filter('order') . " " . get_filter('way'));
while ($img = mysql_fetch_assoc($files)) $images[] = $img;
@@ -33,7 +37,13 @@ if ($user['priv'] < $apps['image']['upload']) {
$can_upload = true;
}
+$folders = array();
+$r = sql("SELECT id, name FROM img_folders WHERE owner = " . $user['id'] . " ORDER BY name ASC");
+while ($f = mysql_fetch_assoc($r)) {
+ $folders[] = $f;
+}
+
$can_delete = ($user['priv'] >= $apps['image']['delete'] && $user['id'] != 0);
-$can_rename = ($user['priv'] >= $apps['image']['rename'] && $user['id'] != 0);
+$can_rename = ($user['priv'] >= $apps['image']['editinfo'] && $user['id'] != 0);
require("tpl/image/index.php");