';
// 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);
}
// +-----------------------------------------------------------------------+
// | 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(
'CATEGORIES_NAV'=>$page['title'],
'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'))
.'&mode=global',
'F_ACTION'=>$base_url.get_query_string_diff(array()),
)
);
// +-----------------------------------------------------------------------+
// | global mode thumbnails |
// +-----------------------------------------------------------------------+
$page['nb_images'] = !empty($_GET['display']) ? intval($_GET['display']) : 5;
if (count($page['cat_elements_id']) > 0)
{
$nav_bar = create_navigation_bar(
$base_url.get_query_string_diff(array('start')),
count($page['cat_elements_id']),
$page['start'],
$page['nb_images'],
'');
$template->assign_vars(array('NAV_BAR' => $nav_bar));
$element_ids = array();
$query = '
SELECT id,path,tn_ext,name,date_creation,comment,keywords,author
FROM '.IMAGES_TABLE.'
WHERE id IN ('.implode(',', $page['cat_elements_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['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['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)));
}
// +-----------------------------------------------------------------------+
// | sending html code |
// +-----------------------------------------------------------------------+
$template->assign_var_from_handle('ADMIN_CONTENT', 'element_set_unit');
?>