aboutsummaryrefslogtreecommitdiffstats
path: root/admin
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--admin/infos_images.php162
1 files changed, 81 insertions, 81 deletions
diff --git a/admin/infos_images.php b/admin/infos_images.php
index 0cbfb54eb..ad620286f 100644
--- a/admin/infos_images.php
+++ b/admin/infos_images.php
@@ -51,8 +51,7 @@ if ( isset( $page['cat'] ) )
}
else
{
- $query = 'SELECT id';
- $query.= ' FROM '.PREFIX_TABLE.'categories';
+ $query = 'SELECT id FROM '.CATEGORIES_TABLE;
$query.= ' WHERE id = '.$_POST['associate'];
$query.= ';';
if ( mysql_num_rows( mysql_query( $query ) ) == 0 )
@@ -62,9 +61,8 @@ if ( isset( $page['cat'] ) )
$associate = false;
- $query = 'SELECT id,file';
- $query.= ' FROM '.PREFIX_TABLE.'images';
- $query.= ' INNER JOIN '.PREFIX_TABLE.'image_category ON id = image_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 = mysql_query( $query );
@@ -77,9 +75,7 @@ if ( isset( $page['cat'] ) )
$keywords = 'keywords-'.$row['id'];
if ( isset( $_POST[$name] ) )
{
- $query = 'UPDATE '.PREFIX_TABLE.'images';
-
- $query.= ' SET name = ';
+ $query = 'UPDATE '.IMAGES_TABLE.' SET name = ';
if ( $_POST[$name] == '' )
$query.= 'NULL';
else
@@ -116,7 +112,7 @@ if ( isset( $page['cat'] ) )
// add link to another category
if ( isset( $_POST['check-'.$row['id']] ) and count( $errors ) == 0 )
{
- $query = 'INSERT INTO '.PREFIX_TABLE.'image_category';
+ $query = 'INSERT INTO '.IMAGE_CATEGORY_TABLE;
$query.= ' (image_id,category_id) VALUES';
$query.= ' ('.$row['id'].','.$_POST['associate'].')';
$query.= ';';
@@ -124,18 +120,17 @@ if ( isset( $page['cat'] ) )
$associate = true;
}
}
- update_category( $_POST['associate'] );
+ if ( isset( $_POST['associate'] )) update_category( $_POST['associate'] );
if ( $associate ) synchronize_all_users();
//------------------------------------------------------ update general options
if ( isset( $_POST['use_common_author'] ) )
{
- $query = 'SELECT image_id';
- $query.= ' FROM '.PREFIX_TABLE.'image_category';
+ $query = 'SELECT image_id FROM '.IMAGE_CATEGORY_TABLE;
$query.= ' WHERE category_id = '.$page['cat'];
$result = mysql_query( $query );
while ( $row = mysql_fetch_array( $result ) )
{
- $query = 'UPDATE '.PREFIX_TABLE.'images';
+ $query = 'UPDATE '.IMAGES_TABLE;
if ( $_POST['author_cat'] == '' )
{
$query.= ' SET author = NULL';
@@ -155,13 +150,12 @@ if ( isset( $page['cat'] ) )
if ( check_date_format( $_POST['date_creation_cat'] ) )
{
$date = date_convert( $_POST['date_creation_cat'] );
- $query = 'SELECT image_id';
- $query.= ' FROM '.PREFIX_TABLE.'image_category';
+ $query = 'SELECT image_id FROM '.IMAGE_CATEGORY_TABLE;
$query.= ' WHERE category_id = '.$page['cat'];
$result = mysql_query( $query );
while ( $row = mysql_fetch_array( $result ) )
{
- $query = 'UPDATE '.PREFIX_TABLE.'images';
+ $query = 'UPDATE '.IMAGES_TABLE;
if ( $_POST['date_creation_cat'] == '' )
{
$query.= ' SET date_creation = NULL';
@@ -182,9 +176,8 @@ if ( isset( $page['cat'] ) )
}
if ( isset( $_POST['common_keywords'] ) and $_POST['keywords_cat'] != '' )
{
- $query = 'SELECT id,keywords';
- $query.= ' FROM '.PREFIX_TABLE.'images';
- $query.= ' INNER JOIN '.PREFIX_TABLE.'image_category ON id = image_id';
+ $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 = mysql_query( $query );
@@ -209,8 +202,7 @@ if ( isset( $page['cat'] ) )
// cleaning the keywords array, sometimes, an empty value still remain
$keywords = array_remove( $keywords, '' );
// updating the picture with new keywords array
- $query = 'UPDATE '.PREFIX_TABLE.'images';
- $query.= ' SET keywords = ';
+ $query = 'UPDATE '.IMAGES_TABLE.' SET keywords = ';
if ( count( $keywords ) == 0 )
{
$query.= 'NULL';
@@ -233,8 +225,8 @@ if ( isset( $page['cat'] ) )
}
//--------------------------------------------------------- form initialization
if( !isset( $_GET['start'] )
- or !is_numeric( $_GET['start'] )
- or ( is_numeric( $_GET['start'] ) and $_GET['start'] < 0 ) )
+ || !is_numeric( $_GET['start'] )
+ || ( is_numeric( $_GET['start'] ) and $_GET['start'] < 0 ) )
{
$page['start'] = 0;
}
@@ -248,41 +240,54 @@ if ( isset( $page['cat'] ) )
$page['start'] =
floor( $_GET['num'] / $page['nb_image_page'] ) * $page['nb_image_page'];
}
- // retrieving category information
- $result = get_cat_info( $page['cat'] );
- $cat['name'] = $result['name'];
- $cat['nb_images'] = $result['nb_images'];
+ // Navigation path
+ $current_category = get_cat_info($_GET['cat_id']);
+ $url = PHPWG_ROOT_PATH.'admin.php?page=infos_images&amp;cat_id=';
+ $category_path = get_cat_display_name($current_category['name'], '-&gt;', $url);
+
+ $form_action = PHPWG_ROOT_PATH.'admin.php?page=infos_images&amp;cat_id='.$_GET['cat_id'];
+ if( $page['start'])
+ {
+ $form_action.= '&amp;start='.$_GET['start'];
+ }
+
+ $nav_bar = create_navigation_bar(
+ $form_action, $current_category['nb_images'],$page['start'], $page['nb_image_page'], '' );
+
//----------------------------------------------------- template initialization
- $sub = $vtp->Open('./template/'.$user['template'].'/admin/infos_image.vtp');
- $tpl = array( 'infoimage_general','author','infoimage_useforall','submit',
- 'infoimage_creation_date','infoimage_detailed','thumbnail',
- 'infoimage_title','infoimage_comment',
- 'infoimage_creation_date','keywords',
- 'infoimage_addtoall','infoimage_removefromall',
- 'infoimage_keyword_separation','infoimage_associate',
- 'errors_title' );
- templatize_array( $tpl, 'lang', $sub );
- $vtp->setGlobalVar( $sub, 'user_template', $user['template'] );
+$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['comment'],
+ 'L_INFOS_ASSOCIATE'=>$lang['infoimage_associate'],
+ 'L_SUBMIT'=>$lang['submit'],
+
+ 'F_ACTION'=>add_session_id($form_action)
+ ));
+
//-------------------------------------------------------------- errors display
-if ( count( $errors ) != 0 )
+if ( sizeof( $errors ) != 0 )
{
- $vtp->addSession( $sub, 'errors' );
- foreach ( $errors as $error ) {
- $vtp->addSession( $sub, 'li' );
- $vtp->setVar( $sub, 'li.content', $error );
- $vtp->closeSession( $sub, 'li' );
+ $template->assign_block_vars('errors',array());
+ for ( $i = 0; $i < sizeof( $errors ); $i++ )
+ {
+ $template->assign_block_vars('errors.error',array('ERROR'=>$errors[$i]));
}
- $vtp->closeSession( $sub, 'errors' );
}
//------------------------------------------------------------------------ form
- $url = './admin.php?page=infos_images&amp;cat_id='.$page['cat'];
- $url.= '&amp;start='.$page['start'];
- $vtp->setVar( $sub, 'form_action', add_session_id( $url ) );
- $page['navigation_bar'] = create_navigation_bar(
- $url, $cat['nb_images'],$page['start'], $page['nb_image_page'], '' );
- $vtp->setVar( $sub, 'navigation_bar', $page['navigation_bar'] );
- $cat_name = get_cat_display_name( $cat['name'], ' - ', 'font-style:italic;');
- $vtp->setVar( $sub, 'cat_name', $cat_name );
$array_cat_directories = array();
@@ -290,9 +295,8 @@ if ( count( $errors ) != 0 )
,'date_creation','keywords','storage_category_id'
,'category_id' );
- $query = 'SELECT '.implode( ',', $infos );
- $query.= ' FROM '.PREFIX_TABLE.'images';
- $query.= ' INNER JOIN '.PREFIX_TABLE.'image_category ON id = image_id';
+ $query = 'SELECT * FROM '.IMAGES_TABLE;
+ $query.= ' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id';
$query.= ' WHERE category_id = '.$page['cat'];
$query.= $conf['order_by'];
$query.= ' LIMIT '.$page['start'].','.$page['nb_image_page'];
@@ -301,56 +305,52 @@ if ( count( $errors ) != 0 )
while ( $row = mysql_fetch_array( $result ) )
{
foreach ($infos as $info) { if (!isset($row[$info])) $row[$info] = ''; }
-
- $vtp->addSession( $sub, 'picture' );
- $vtp->setVar( $sub, 'picture.id', $row['id'] );
- $vtp->setVar( $sub, 'picture.filename', $row['file'] );
- $vtp->setVar( $sub, 'picture.name', $row['name'] );
- $vtp->setVar( $sub, 'picture.author', $row['author'] );
- $vtp->setVar( $sub, 'picture.comment', $row['comment'] );
- $vtp->setVar( $sub, 'picture.keywords', $row['keywords'] );
- $vtp->setVar( $sub, 'picture.date_creation',
- date_convert_back( $row['date_creation'] ) );
- $file = get_filename_wo_extension( $row['file'] );
- $vtp->setVar( $sub, 'picture.default_name', $file );
- // creating url to thumbnail
- if ( !isset( $array_cat_directories[$row['storage_category_id']] ) )
+ if ( !isset( $array_cat_directories[$row['storage_category_id']] ) )
{
$array_cat_directories[$row['storage_category_id']] =
get_complete_dir( $row['storage_category_id'] );
}
$thumbnail_url = $array_cat_directories[$row['storage_category_id']];
$thumbnail_url.= 'thumbnail/';
- $thumbnail_url.= $conf['prefix_thumbnail'].$file.".".$row['tn_ext'];
- $vtp->setVar( $sub, 'picture.thumbnail_url', $thumbnail_url );
- $url = './admin.php?page=picture_modify&amp;image_id='.$row['id'];
- $vtp->setVar( $sub, 'picture.url', add_session_id( $url ) );
- $vtp->closeSession( $sub, 'picture' );
+ $thumbnail_url.= $conf['prefix_thumbnail'].get_filename_wo_extension( $row['file'] ).".".$row['tn_ext'];
+
+ $template->assign_block_vars('picture' ,array(
+ 'ID_IMG'=>$row['id'],
+ 'URL_IMG'=>add_session_id( PHPWG_ROOT_PATH.'admin.php?page=picture_modify&amp;image_id='.$row['id'] ),
+ 'TN_URL_IMG'=>$thumbnail_url,
+ 'FILENAME_IMG'=>$row['file'],
+ 'DEFAULTNAME_IMG'=>get_filename_wo_extension( $row['file'] ),
+ 'NAME_IMG'=>$row['name'],
+ 'AUTHOR_IMG'=>$row['author'],
+ 'DATE_IMG'=>date_convert_back( $row['date_creation'] ),
+ 'KEYWORDS_IMG'=>$row['keywords'],
+ 'COMMENT_IMG'=>$row['comment']
+ ));
}
+
// Virtualy associate a picture to a category
//
// We only show a List Of Values if the number of categories is less than
// $conf['max_LOV_categories']
$query = 'SELECT COUNT(id) AS nb_total_categories';
- $query.= ' FROM '.PREFIX_TABLE.'categories';
- $query.= ';';
+ $query.= ' FROM '.CATEGORIES_TABLE.';';
$row = mysql_fetch_array( mysql_query( $query ) );
if ( $row['nb_total_categories'] < $conf['max_LOV_categories'] )
{
- $vtp->addSession( $sub, 'associate_LOV' );
+ /*$vtp->addSession( $sub, 'associate_LOV' );
$page['plain_structure'] = get_plain_structure( true );
$structure = create_structure( '', array() );
display_categories( $structure, '&nbsp;' );
- $vtp->closeSession( $sub, 'associate_LOV' );
+ $vtp->closeSession( $sub, 'associate_LOV' );*/
}
// else, we only display a small text field, we suppose the administrator
// knows the id of its category
else
{
- $vtp->addSession( $sub, 'associate_text' );
- $vtp->closeSession( $sub, 'associate_text' );
+ //$vtp->addSession( $sub, 'associate_text' );
+ //$vtp->closeSession( $sub, 'associate_text' );
}
}
//----------------------------------------------------------- sending html code
-$vtp->Parse( $handle , 'sub', $sub );
+$template->assign_var_from_handle('ADMIN_CONTENT', 'infos_images');
?>