351 lines
13 KiB
PHP
351 lines
13 KiB
PHP
<?php
|
|
// +-----------------------------------------------------------------------+
|
|
// | PhpWebGallery - a PHP based picture gallery |
|
|
// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |
|
|
// | Copyright (C) 2003-2005 PhpWebGallery Team - http://phpwebgallery.net |
|
|
// +-----------------------------------------------------------------------+
|
|
// | branch : BSF (Best So Far)
|
|
// | file : $RCSfile$
|
|
// | last update : $Date$
|
|
// | last modifier : $Author$
|
|
// | revision : $Revision$
|
|
// +-----------------------------------------------------------------------+
|
|
// | This program is free software; you can redistribute it and/or modify |
|
|
// | it under the terms of the GNU General Public License as published by |
|
|
// | the Free Software Foundation |
|
|
// | |
|
|
// | This program is distributed in the hope that it will be useful, but |
|
|
// | WITHOUT ANY WARRANTY; without even the implied warranty of |
|
|
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU |
|
|
// | General Public License for more details. |
|
|
// | |
|
|
// | You should have received a copy of the GNU General Public License |
|
|
// | along with this program; if not, write to the Free Software |
|
|
// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
|
|
// | USA. |
|
|
// +-----------------------------------------------------------------------+
|
|
|
|
if(!defined("PHPWG_ROOT_PATH"))
|
|
{
|
|
die ("Hacking attempt!");
|
|
}
|
|
include_once(PHPWG_ROOT_PATH.'admin/include/isadmin.inc.php');
|
|
// +-----------------------------------------------------------------------+
|
|
// | initialization |
|
|
// +-----------------------------------------------------------------------+
|
|
check_cat_id($_GET['cat_id']);
|
|
$errors = array();
|
|
|
|
if (isset($page['cat']))
|
|
{
|
|
// +-----------------------------------------------------------------------+
|
|
// | update individual options |
|
|
// +-----------------------------------------------------------------------+
|
|
if (isset($_POST['submit']))
|
|
{
|
|
if (isset($_POST['associate']) and $_POST['associate'] != '')
|
|
{
|
|
// does the uppercat id exists in the database ?
|
|
if (!is_numeric($_POST['associate']))
|
|
{
|
|
array_push($errors, $lang['cat_unknown_id']);
|
|
}
|
|
else
|
|
{
|
|
$query = 'SELECT id FROM '.CATEGORIES_TABLE;
|
|
$query.= ' WHERE id = '.$_POST['associate'];
|
|
$query.= ';';
|
|
if (mysql_num_rows(pwg_query($query)) == 0)
|
|
array_push($errors, $lang['cat_unknown_id']);
|
|
}
|
|
}
|
|
|
|
$query = 'SELECT id,file FROM '.IMAGES_TABLE;
|
|
$query.= ' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id';
|
|
$query.= ' WHERE category_id = '.$page['cat'];
|
|
$query.= ';';
|
|
$result = pwg_query($query);
|
|
while ($row = mysql_fetch_array($result))
|
|
{
|
|
$name = 'name-'.$row['id'];
|
|
$author = 'author-'.$row['id'];
|
|
$comment = 'comment-'.$row['id'];
|
|
$date_creation = 'date_creation-'.$row['id'];
|
|
$keywords = 'keywords-'.$row['id'];
|
|
if (isset($_POST[$name]))
|
|
{
|
|
$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)."'";
|
|
|
|
$query.= ', comment = ';
|
|
if ($_POST[$comment] == '')
|
|
$query.= 'NULL';
|
|
else
|
|
$query.= "'".htmlentities($_POST[$comment],ENT_QUOTES)."'";
|
|
|
|
$query.= ', date_creation = ';
|
|
if (check_date_format($_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';
|
|
else $query.= "'".implode(',', $keywords_array)."'";
|
|
|
|
$query.= ' WHERE id = '.$row['id'];
|
|
$query.= ';';
|
|
pwg_query($query);
|
|
}
|
|
// add link to another category
|
|
if (isset($_POST['check-'.$row['id']])
|
|
and isset($_POST['associate'])
|
|
and $_POST['associate'] != '')
|
|
{
|
|
$query = 'INSERT INTO '.IMAGE_CATEGORY_TABLE;
|
|
$query.= ' (image_id,category_id) VALUES';
|
|
$query.= ' ('.$row['id'].','.$_POST['associate'].')';
|
|
$query.= ';';
|
|
pwg_query($query);
|
|
}
|
|
}
|
|
if (isset($_POST['associate']) and $_POST['associate'] != '')
|
|
{
|
|
update_category(array($_POST['associate']));
|
|
}
|
|
// +-----------------------------------------------------------------------+
|
|
// | update general options |
|
|
// +-----------------------------------------------------------------------+
|
|
if (isset($_POST['use_common_author']))
|
|
{
|
|
$query = 'SELECT image_id FROM '.IMAGE_CATEGORY_TABLE;
|
|
$query.= ' WHERE category_id = '.$page['cat'];
|
|
$result = pwg_query($query);
|
|
while ($row = mysql_fetch_array($result))
|
|
{
|
|
$query = 'UPDATE '.IMAGES_TABLE;
|
|
if ($_POST['author_cat'] == '')
|
|
{
|
|
$query.= ' SET author = NULL';
|
|
}
|
|
else
|
|
{
|
|
$query.= ' SET author = ';
|
|
$query.= "'".htmlentities($_POST['author_cat'], ENT_QUOTES)."'";
|
|
}
|
|
$query.= ' WHERE id = '.$row['image_id'];
|
|
$query.= ';';
|
|
pwg_query($query);
|
|
}
|
|
}
|
|
if (isset($_POST['use_common_date_creation']))
|
|
{
|
|
if (check_date_format($_POST['date_creation_cat']))
|
|
{
|
|
$date = date_convert($_POST['date_creation_cat']);
|
|
$query = 'SELECT image_id FROM '.IMAGE_CATEGORY_TABLE;
|
|
$query.= ' WHERE category_id = '.$page['cat'];
|
|
$result = pwg_query($query);
|
|
while ($row = mysql_fetch_array($result))
|
|
{
|
|
$query = 'UPDATE '.IMAGES_TABLE;
|
|
if ($_POST['date_creation_cat'] == '')
|
|
{
|
|
$query.= ' SET date_creation = NULL';
|
|
}
|
|
else
|
|
{
|
|
$query.= " SET date_creation = '".$date."'";
|
|
}
|
|
$query.= ' WHERE id = '.$row['image_id'];
|
|
$query.= ';';
|
|
pwg_query($query);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
array_push($errors, $lang['err_date']);
|
|
}
|
|
}
|
|
if (isset($_POST['common_keywords']) and $_POST['keywords_cat'] != '')
|
|
{
|
|
$query = 'SELECT id,keywords FROM '.IMAGES_TABLE;
|
|
$query.= ' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id';
|
|
$query.= ' WHERE category_id = '.$page['cat'];
|
|
$query.= ';';
|
|
$result = pwg_query($query);
|
|
while ($row = mysql_fetch_array($result))
|
|
{
|
|
if (!isset($row['keywords'])) $specific_keywords = array();
|
|
else $specific_keywords = explode(',', $row['keywords']);
|
|
|
|
$common_keywords = get_keywords($_POST['keywords_cat']);
|
|
// first possiblity : adding the given keywords to all the pictures
|
|
if ($_POST['common_keywords'] == 'add')
|
|
{
|
|
$keywords = array_merge($specific_keywords, $common_keywords);
|
|
$keywords = array_unique($keywords);
|
|
}
|
|
// second possiblity : removing the given keywords from all pictures
|
|
// (without deleting the other specific keywords
|
|
if ($_POST['common_keywords'] == 'remove')
|
|
{
|
|
$keywords = array_diff($specific_keywords, $common_keywords);
|
|
}
|
|
// cleaning the keywords array, sometimes, an empty value still remain
|
|
$keywords = array_remove($keywords, '');
|
|
// updating the picture with new keywords array
|
|
$query = 'UPDATE '.IMAGES_TABLE.' SET keywords = ';
|
|
if (count($keywords) == 0)
|
|
{
|
|
$query.= 'NULL';
|
|
}
|
|
else
|
|
{
|
|
$query.= '"';
|
|
$i = 0;
|
|
foreach ($keywords as $keyword) {
|
|
if ($i++ > 0) $query.= ',';
|
|
$query.= $keyword;
|
|
}
|
|
$query.= '"';
|
|
}
|
|
$query.= ' WHERE id = '.$row['id'];
|
|
$query.= ';';
|
|
pwg_query($query);
|
|
}
|
|
}
|
|
}
|
|
// +-----------------------------------------------------------------------+
|
|
// | form initialization |
|
|
// +-----------------------------------------------------------------------+
|
|
if (!isset($_GET['start'])
|
|
or !is_numeric($_GET['start'])
|
|
or (is_numeric($_GET['start']) and $_GET['start'] < 0))
|
|
{
|
|
$page['start'] = 0;
|
|
}
|
|
else
|
|
{
|
|
$page['start'] = $_GET['start'];
|
|
}
|
|
|
|
if (isset($_GET['num']) and is_numeric($_GET['num']) and $_GET['num'] >= 0)
|
|
{
|
|
$max = $conf['info_nb_elements_page'];
|
|
$page['start'] = floor($_GET['num'] / $max) * $max;
|
|
}
|
|
// Navigation path
|
|
$current_category = get_cat_info($_GET['cat_id']);
|
|
$url = PHPWG_ROOT_PATH.'admin.php?page=infos_images&cat_id=';
|
|
$category_path = get_cat_display_name($current_category['name'], $url);
|
|
|
|
$form_action = PHPWG_ROOT_PATH.'admin.php';
|
|
$form_action.= '?page=infos_images&cat_id='.$_GET['cat_id'];
|
|
if($page['start'])
|
|
{
|
|
$form_action.= '&start='.$_GET['start'];
|
|
}
|
|
|
|
$nav_bar = create_navigation_bar($form_action,
|
|
$current_category['nb_images'],
|
|
$page['start'],
|
|
$conf['info_nb_elements_page'],
|
|
'');
|
|
// +-----------------------------------------------------------------------+
|
|
// | template initialization |
|
|
// +-----------------------------------------------------------------------+
|
|
$template->set_filenames(array('infos_images'=>'admin/infos_images.tpl'));
|
|
$template->assign_vars(
|
|
array(
|
|
'CATEGORY'=>$category_path,
|
|
'NAV_BAR'=>$nav_bar,
|
|
|
|
'L_INFOS_TITLE'=>$lang['infoimage_general'],
|
|
'L_AUTHOR'=>$lang['author'],
|
|
'L_INFOS_OVERALL_USE'=>$lang['infoimage_useforall'],
|
|
'L_INFOS_CREATION_DATE'=>$lang['infoimage_creation_date'],
|
|
'L_KEYWORD'=>$lang['keywords'],
|
|
'L_KEYWORD_SEPARATION'=>$lang['infoimage_keyword_separation'],
|
|
'L_INFOS_ADDTOALL'=>$lang['infoimage_addtoall'],
|
|
'L_INFOS_REMOVEFROMALL'=>$lang['infoimage_removefromall'],
|
|
'L_INFOS_DETAIL'=>$lang['infoimage_detailed'],
|
|
'L_THUMBNAIL'=>$lang['thumbnail'],
|
|
'L_INFOS_IMG'=>$lang['infoimage_title'],
|
|
'L_INFOS_COMMENT'=>$lang['description'],
|
|
'L_INFOS_ASSOCIATE'=>$lang['infoimage_associate'],
|
|
'L_SUBMIT'=>$lang['submit'],
|
|
|
|
'F_ACTION'=>add_session_id($form_action)
|
|
));
|
|
// +-----------------------------------------------------------------------+
|
|
// | errors display |
|
|
// +-----------------------------------------------------------------------+
|
|
if (count($errors) != 0)
|
|
{
|
|
$template->assign_block_vars('errors',array());
|
|
foreach ($errors as $error)
|
|
{
|
|
$template->assign_block_vars('errors.error',array('ERROR'=>$error));
|
|
}
|
|
}
|
|
// +-----------------------------------------------------------------------+
|
|
// | form |
|
|
// +-----------------------------------------------------------------------+
|
|
$array_cat_directories = array();
|
|
|
|
$pic_mod_base_url = PHPWG_ROOT_PATH.'admin.php';
|
|
$pic_mod_base_url = '?page=picture_modify&image_id=';
|
|
|
|
$query = '
|
|
SELECT *
|
|
FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id
|
|
WHERE category_id = '.$page['cat'].'
|
|
'.$conf['order_by'].'
|
|
LIMIT '.$page['start'].','.$conf['info_nb_elements_page'].'
|
|
;';
|
|
$result = pwg_query($query);
|
|
while ($row = mysql_fetch_array($result))
|
|
{
|
|
$thumbnail_url = get_thumbnail_src($row['path'], @$row['tn_ext']);
|
|
|
|
$template->assign_block_vars(
|
|
'picture',
|
|
array(
|
|
'ID_IMG'=>$row['id'],
|
|
'URL_IMG'=>add_session_id($pic_mod_base_url.$row['id']),
|
|
'TN_URL_IMG'=>$thumbnail_url,
|
|
'FILENAME_IMG'=>$row['file'],
|
|
'DEFAULTNAME_IMG'=>get_filename_wo_extension($row['file']),
|
|
'NAME_IMG'=>@$row['name'],
|
|
'DATE_IMG'=>date_convert_back(@$row['date_creation']),
|
|
'AUTHOR_IMG'=>@$row['author'],
|
|
'KEYWORDS_IMG'=>@$row['keywords'],
|
|
'COMMENT_IMG'=>@$row['comment']
|
|
));
|
|
}
|
|
|
|
// Virtualy associate a picture to a category
|
|
$query = '
|
|
SELECT id,name,uppercats,global_rank
|
|
FROM '.CATEGORIES_TABLE.'
|
|
;';
|
|
display_select_cat_wrapper($query,
|
|
array(),
|
|
'associate_option',
|
|
true);
|
|
}
|
|
//----------------------------------------------------------- sending html code
|
|
$template->assign_var_from_handle('ADMIN_CONTENT', 'infos_images');
|
|
?>
|