aboutsummaryrefslogtreecommitdiffstats
path: root/admin/picture_modify.php
diff options
context:
space:
mode:
Diffstat (limited to 'admin/picture_modify.php')
-rw-r--r--admin/picture_modify.php321
1 files changed, 221 insertions, 100 deletions
diff --git a/admin/picture_modify.php b/admin/picture_modify.php
index a07cfbd75..a8fa2b953 100644
--- a/admin/picture_modify.php
+++ b/admin/picture_modify.php
@@ -27,61 +27,93 @@
if(!defined("PHPWG_ROOT_PATH"))
{
- die ("Hacking attempt!");
+ die('Hacking attempt!');
}
include_once(PHPWG_ROOT_PATH.'admin/include/isadmin.inc.php');
+
+// +-----------------------------------------------------------------------+
+// | synchronize metadata |
+// +-----------------------------------------------------------------------+
+
+if (isset($_GET['sync_metadata']))
+{
+ $query = '
+SELECT path
+ FROM '.IMAGES_TABLE.'
+ WHERE id = '.$_GET['image_id'].'
+;';
+ list($path) = mysql_fetch_row(pwg_query($query));
+ update_metadata(array($_GET['image_id'] => $path));
+
+ array_push($page['infos'], l10n('Metadata synchronized from file'));
+}
+
//--------------------------------------------------------- update informations
+
// first, we verify whether there is a mistake on the given creation date
-if (isset($_POST['date_creation']) and !empty($_POST['date_creation']))
+if (isset($_POST['date_creation_action'])
+ and 'set' == $_POST['date_creation_action'])
{
- if (!check_date_format($_POST['date_creation']))
+ if (!checkdate(
+ $_POST['date_creation_month'],
+ $_POST['date_creation_day'],
+ $_POST['date_creation_year'])
+ )
{
array_push($page['errors'], $lang['err_date']);
}
}
+
if (isset($_POST['submit']) and count($page['errors']) == 0)
{
- $query = 'UPDATE '.IMAGES_TABLE.' SET name = ';
- if ($_POST['name'] == '')
- $query.= 'NULL';
- else
- $query.= "'".htmlentities($_POST['name'], ENT_QUOTES)."'";
-
- $query.= ', author = ';
- if ($_POST['author'] == '')
- $query.= 'NULL';
- else
- $query.= "'".htmlentities($_POST['author'],ENT_QUOTES)."'";
+ $data = array();
+ $data{'id'} = $_GET['image_id'];
+ $data{'name'} = $_POST['name'];
+ $data{'author'} = $_POST['author'];
- $query.= ', comment = ';
- if ($_POST['comment'] == '')
- $query.= 'NULL';
- else
- $query.= "'".htmlentities($_POST['comment'],ENT_QUOTES)."'";
-
- $query.= ', date_creation = ';
- if (!empty($_POST['date_creation']))
- $query.= "'".date_convert($_POST['date_creation'])."'";
- else if ($_POST['date_creation'] == '')
- $query.= 'NULL';
-
- $query.= ', keywords = ';
- $keywords_array = get_keywords($_POST['keywords']);
- if (count($keywords_array) == 0)
- $query.= 'NULL';
+ if ($conf['allow_html_descriptions'])
+ {
+ $data{'comment'} = @$_POST['description'];
+ }
else
{
- $query.= "'";
- foreach ($keywords_array as $i => $keyword) {
- if ($i > 0) $query.= ',';
- $query.= $keyword;
+ $data{'comment'} = strip_tags(@$_POST['description']);
+ }
+
+ if (isset($_POST['date_creation_action']))
+ {
+ if ('set' == $_POST['date_creation_action'])
+ {
+ $data{'date_creation'} = $_POST['date_creation_year']
+ .'-'.$_POST['date_creation_month']
+ .'-'.$_POST['date_creation_day'];
+ }
+ else if ('unset' == $_POST['date_creation_action'])
+ {
+ $data{'date_creation'} = '';
}
- $query.= "'";
}
- $query.= ' WHERE id = '.$_GET['image_id'];
- $query.= ';';
- pwg_query($query);
+ $keywords = get_keywords($_POST['keywords']);
+ if (count($keywords) > 0)
+ {
+ $data{'keywords'} = implode(',', $keywords);
+ }
+ else
+ {
+ $data{'keywords'} = '';
+ }
+
+ mass_updates(
+ IMAGES_TABLE,
+ array(
+ 'primary' => array('id'),
+ 'update' => array_diff(array_keys($data), array('id'))
+ ),
+ array($data)
+ );
+
+ array_push($page['infos'], l10n('Picture informations updated'));
}
// associate the element to other categories than its storage category
if (isset($_POST['associate'])
@@ -137,85 +169,175 @@ if (isset($_POST['dismiss'])
// retrieving direct information about picture
$query = '
-SELECT i.*, c.uppercats
- FROM '.IMAGES_TABLE.' AS i
- INNER JOIN '.CATEGORIES_TABLE.' AS c ON i.storage_category_id = c.id
- WHERE i.id = '.$_GET['image_id'].'
+SELECT *
+ FROM '.IMAGES_TABLE.'
+ WHERE id = '.$_GET['image_id'].'
;';
$row = mysql_fetch_array(pwg_query($query));
$storage_category_id = $row['storage_category_id'];
-if (empty($row['name']))
-{
- $title = str_replace('_', ' ',get_filename_wo_extension($row['file']));
-}
-else
-{
- $title = $row['name'];
-}
// Navigation path
-$thumbnail_url = get_thumbnail_src($row['path'], @$row['tn_ext']);
-$url_img = PHPWG_ROOT_PATH.'picture.php?image_id='.$_GET['image_id'];
-$url_img .= '&cat='.$row['storage_category_id'];
$date = isset($_POST['date_creation']) && empty($page['errors'])
?$_POST['date_creation']:date_convert_back(@$row['date_creation']);
-$url = PHPWG_ROOT_PATH.'admin.php?page=cat_modify&cat_id=';
-$storage_category = get_cat_display_name_cache($row['uppercats'],
- $url,
- false);
-//----------------------------------------------------- template initialization
+// +-----------------------------------------------------------------------+
+// | template init |
+// +-----------------------------------------------------------------------+
+
$template->set_filenames(
array(
'picture_modify' => 'admin/picture_modify.tpl'
)
);
-$template->assign_vars(array(
- 'TITLE_IMG'=>$title,
- 'STORAGE_CATEGORY_IMG'=>$storage_category,
- 'PATH_IMG'=>$row['path'],
- 'FILE_IMG'=>$row['file'],
- 'TN_URL_IMG'=>$thumbnail_url,
- 'URL_IMG'=>add_session_id($url_img),
- 'DEFAULT_NAME_IMG'=>str_replace('_',' ',get_filename_wo_extension($row['file'])),
- 'FILE_IMG'=>$row['file'],
- 'NAME_IMG'=>isset($_POST['name'])?$_POST['name']:@$row['name'],
- 'SIZE_IMG'=>@$row['width'].' * '.@$row['height'],
- 'FILESIZE_IMG'=>@$row['filesize'].' KB',
- 'REGISTRATION_DATE_IMG'
- => format_date($row['date_available'], 'mysql_datetime', true),
- 'AUTHOR_IMG'=>isset($_POST['author'])?$_POST['author']:@$row['author'],
- 'CREATION_DATE_IMG'=>$date,
- 'KEYWORDS_IMG'=>isset($_POST['keywords'])?$_POST['keywords']:@$row['keywords'],
- 'COMMENT_IMG'=>isset($_POST['comment'])?$_POST['comment']:@$row['comment'],
+$template->assign_vars(
+ array(
+ 'U_SYNC' =>
+ add_session_id(
+ PHPWG_ROOT_PATH.'admin.php?page=picture_modify'.
+ '&image_id='.$_GET['image_id'].
+ (isset($_GET['cat_id']) ? '&cat_id='.$_GET['cat_id'] : '').
+ '&sync_metadata=1'
+ ),
+
+ 'PATH'=>$row['path'],
+
+ 'TN_SRC' => get_thumbnail_src($row['path'], @$row['tn_ext']),
+
+ 'NAME' =>
+ isset($_POST['name']) ?
+ stripslashes($_POST['name']) : @$row['name'],
+
+ 'DIMENSIONS' => @$row['width'].' * '.@$row['height'],
+
+ 'FILESIZE' => @$row['filesize'].' KB',
+
+ 'REGISTRATION_DATE' =>
+ format_date($row['date_available'], 'mysql_datetime', false),
+
+ 'AUTHOR' => isset($_POST['author']) ? $_POST['author'] : @$row['author'],
+
+ 'CREATION_DATE' => $date,
+
+ 'KEYWORDS' =>
+ isset($_POST['keywords']) ?
+ stripslashes($_POST['keywords']) : @$row['keywords'],
+
+ 'DESCRIPTION' =>
+ isset($_POST['description']) ?
+ stripslashes($_POST['description']) : @$row['comment'],
- 'L_UPLOAD_NAME'=>$lang['upload_name'],
- 'L_DEFAULT'=>$lang['default'],
- 'L_FILE'=>$lang['file'],
- 'L_SIZE'=>$lang['size'],
- 'L_FILESIZE'=>$lang['filesize'],
- 'L_REGISTRATION_DATE'=>$lang['registration_date'],
- 'L_AUTHOR'=>$lang['author'],
- 'L_CREATION_DATE'=>$lang['creation_date'],
- 'L_KEYWORDS'=>$lang['keywords'],
- 'L_COMMENT'=>$lang['description'],
- 'L_CATEGORIES'=>$lang['categories'],
- 'L_DISSOCIATE'=>$lang['dissociate'],
- 'L_INFOIMAGE_ASSOCIATE'=>$lang['infoimage_associate'],
- 'L_SUBMIT'=>$lang['submit'],
- 'L_RESET'=>$lang['reset'],
- 'L_CAT_ASSOCIATED'=>$lang['infoimage_associated'],
- 'L_CAT_DISSOCIATED'=>$lang['infoimage_dissociated'],
- 'L_PATH'=>$lang['path'],
- 'L_STORAGE_CATEGORY'=>$lang['storage_category'],
- 'L_REPRESENTS'=>$lang['represents'],
- 'L_DOESNT_REPRESENT'=>$lang['doesnt_represent'],
+ 'F_ACTION' =>
+ add_session_id(
+ PHPWG_ROOT_PATH.'admin.php'
+ .get_query_string_diff(array('sync_metadata'))
+ )
+ )
+ );
+
+// creation date
+unset($day, $month, $year);
+
+if (isset($_POST['date_creation_action'])
+ and 'set' == $_POST['date_creation_action'])
+{
+ foreach (array('day', 'month', 'year') as $varname)
+ {
+ $$varname = $_POST['date_creation_'.$varname];
+ }
+}
+else if (isset($row['date_creation']) and !empty($row['date_creation']))
+{
+ list($year, $month, $day) = explode('-', $row['date_creation']);
+}
+else
+{
+ list($year, $month, $day) = array('', 0, 0);
+}
+get_day_list('date_creation_day', $day);
+get_month_list('date_creation_month', $month);
+$template->assign_vars(array('DATE_CREATION_YEAR_VALUE' => $year));
- 'F_ACTION'=>add_session_id(PHPWG_ROOT_PATH.'admin.php?'.$_SERVER['QUERY_STRING'])
- ));
+$query = '
+SELECT category_id, uppercats
+ FROM '.IMAGE_CATEGORY_TABLE.' AS ic
+ INNER JOIN '.CATEGORIES_TABLE.' AS c
+ ON c.id = ic.category_id
+ WHERE image_id = '.$_GET['image_id'].'
+;';
+$result = pwg_query($query);
+
+if (mysql_num_rows($result) > 1)
+{
+ $template->assign_block_vars('links', array());
+}
+
+while ($row = mysql_fetch_array($result))
+{
+ $name =
+ get_cat_display_name_cache(
+ $row['uppercats'],
+ PHPWG_ROOT_PATH.'admin.php?page=cat_modify&cat_id=',
+ false
+ );
+
+ if ($row['category_id'] == $storage_category_id)
+ {
+ $template->assign_vars(array('STORAGE_CATEGORY' => $name));
+ }
+ else
+ {
+ $template->assign_block_vars('links.category', array('NAME' => $name));
+ }
+}
+
+// jump to link
+//
+// 1. find all linked categories that are reachable for the current user.
+// 2. if a category is available in the URL, use it if reachable
+// 3. if URL category not available or reachable, use the first reachable
+// linked category
+// 4. if no category reachable, no jumpto link
+$base_url_img = PHPWG_ROOT_PATH.'picture.php';
+$base_url_img.= '?image_id='.$_GET['image_id'];
+$base_url_img.= '&cat=';
+unset($url_img);
+
+$query = '
+SELECT category_id
+ FROM '.IMAGE_CATEGORY_TABLE.'
+ WHERE image_id = '.$_GET['image_id'].'
+;';
+$authorizeds = array_diff(
+ array_from_query($query, 'category_id'),
+ explode(',', calculate_permissions($user['id'], $user['status']))
+ );
+
+if (isset($_GET['cat_id'])
+ and in_array($_GET['cat_id'], $authorizeds))
+{
+ $url_img = $base_url_img.$_GET['cat_id'];
+}
+else
+{
+ foreach ($authorizeds as $category)
+ {
+ $url_img = $base_url_img.$category;
+ break;
+ }
+}
+
+if (isset($url_img))
+{
+ $template->assign_block_vars(
+ 'jumpto',
+ array(
+ 'URL' => $url_img
+ )
+ );
+}
// associate to another category ?
$query = '
@@ -258,6 +380,5 @@ display_select_cat_wrapper($query, array(), 'dismissed_option');
//----------------------------------------------------------- sending html code
-
$template->assign_var_from_handle('ADMIN_CONTENT', 'picture_modify');
?>