';
// print_r($_POST);
// echo '';
// exit();
$datas = array();
$dbfields =
array(
'primary' => array('id'),
'update' => array('name','author','comment','date_creation','keywords')
);
$query = '
SELECT id, date_creation
FROM '.IMAGES_TABLE.'
WHERE id IN ('.implode(',', $collection).')
;';
$result = pwg_query($query);
while ($row = mysql_fetch_array($result))
{
$data = array();
$data['id'] = $row['id'];
foreach (array_diff($dbfields['update'], array('date_creation')) as $field)
{
if (!empty($_POST[$field.'-'.$row['id']]))
{
$data[$field] = $_POST[$field.'-'.$row['id']];
}
}
if ('set' == $_POST['date_creation_action-'.$row['id']])
{
$data['date_creation'] =
$_POST['date_creation_year-'.$row['id']]
.'-'.$_POST['date_creation_month-'.$row['id']]
.'-'.$_POST['date_creation_day-'.$row['id']]
;
}
else if ('leave' == $_POST['date_creation_action-'.$row['id']]
and !empty($row['date_creation']))
{
$data['date_creation'] = $row['date_creation'];
}
array_push($datas, $data);
}
// echo ''; print_r($datas); echo '
';
mass_updates(IMAGES_TABLE, $dbfields, $datas);
}
// +-----------------------------------------------------------------------+
// | page information init |
// +-----------------------------------------------------------------------+
// $page['start'] contains the number of the first element in its
// category. For exampe, $page['start'] = 12 means we must show elements #12
// and $page['nb_images'] next elements
if (!isset($_GET['start'])
or !is_numeric($_GET['start'])
or $_GET['start'] < 0)
{
$page['start'] = 0;
}
else
{
$page['start'] = $_GET['start'];
}
// $page['nb_images'] is the number of elements to show in the page
$page['nb_images'] = !empty($_GET['display']) ? $_GET['display'] : 5;
// $page['cat_nb_images'] is the total number of elements to show in the
// category
$query = '
SELECT COUNT(*)
FROM '.CADDIE_TABLE.'
WHERE user_id = '.$user['id'].'
;';
list($page['cat_nb_images']) = mysql_fetch_row(pwg_query($query));
// +-----------------------------------------------------------------------+
// | template init |
// +-----------------------------------------------------------------------+
$template->set_filenames(
array('element_set_unit' => 'admin/element_set_unit.tpl'));
$base_url = PHPWG_ROOT_PATH.'admin.php';
// $form_action = $base_url.'?page=element_set_global';
$template->assign_vars(
array(
'L_SUBMIT'=>$lang['submit'],
'U_ELEMENTS_PAGE'
=>$base_url.get_query_string_diff(array('display','start')),
'U_GLOBAL_MODE'
// =>$base_url.get_query_string_diff(array('mode','display','start')),
=>add_session_id($base_url.'?page=element_set_global'),
'F_ACTION'=>$base_url.get_query_string_diff(array()),
)
);
// +-----------------------------------------------------------------------+
// | global mode thumbnails |
// +-----------------------------------------------------------------------+
$element_ids = array();
$query = '
SELECT element_id,path,tn_ext,name,date_creation,comment,keywords,author
FROM '.IMAGES_TABLE.' INNER JOIN '.CADDIE_TABLE.' ON id=element_id
WHERE user_id = '.$user['id'].'
'.$conf['order_by'].'
LIMIT '.$page['start'].', '.$page['nb_images'].'
;';
$result = pwg_query($query);
while ($row = mysql_fetch_array($result))
{
// echo ''; print_r($row); echo '
';
array_push($element_ids, $row['element_id']);
$src = get_thumbnail_src($row['path'], @$row['tn_ext']);
// creation date
if (!empty($row['date_creation']))
{
list($year,$month,$day) = explode('-', $row['date_creation']);
}
else
{
list($year,$month,$day) = array('','','');
}
$template->assign_block_vars(
'element',
array(
'ID' => $row['element_id'],
'FILENAME' => $row['path'],
'TN_SRC' => $src,
'NAME' => @$row['name'],
'AUTHOR' => @$row['author'],
'COMMENT' => @$row['comment'],
'DATE_CREATION_YEAR' => $year,
'KEYWORDS' => @$row['keywords']
)
);
get_day_list('element.date_creation_day', $day);
get_month_list('element.date_creation_month', $month);
}
$template->assign_vars(array('IDS_LIST' => implode(',', $element_ids)));
$nav_bar = create_navigation_bar(
$base_url.get_query_string_diff(array('start')),
$page['cat_nb_images'],
$page['start'],
$page['nb_images'],
'');
$template->assign_vars(array('NAV_BAR' => $nav_bar));
// +-----------------------------------------------------------------------+
// | sending html code |
// +-----------------------------------------------------------------------+
$template->assign_var_from_handle('ADMIN_CONTENT', 'element_set_unit');
?>