Changeset 506 for trunk/admin

Timestamp:

Aug 29, 2004, 11:22:24 PM (20 years ago)

Author:

gweltas

Message:

Migration of the template of images_infos.php

File:

• trunk/admin/infos_images.php (modified) (15 diffs)

trunk/admin/infos_images.php

@@ -52 +52 @@
       else
       {
-        $query = 'SELECT id';
-        $query.= ' FROM '.PREFIX_TABLE.'categories';
+        $query = 'SELECT id FROM '.CATEGORIES_TABLE;
         $query.= ' WHERE id = '.$_POST['associate'];
         $query.= ';';
@@ -63 +62 @@
     $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.= ';';
@@ -78 +76 @@
       if ( isset( $_POST[$name] ) )
       {
-        $query = 'UPDATE '.PREFIX_TABLE.'images';
-
-        $query.= ' SET name = ';
+        $query = 'UPDATE '.IMAGES_TABLE.' SET name = ';
         if ( $_POST[$name] == '' )
           $query.= 'NULL';
@@ -117 +113 @@
       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'].')';
@@ -125 +121 @@
       }
     }
-    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'] == '' )
         {
@@ -156 +151 @@
       {
         $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'] == '' )
           {
@@ -183 +177 @@
     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.= ';';
@@ -210 +203 @@
         $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 )
         {
@@ -234 +226 @@
 //--------------------------------------------------------- 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;
@@ -249 +241 @@
       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' );
-  }
-  $vtp->closeSession( $sub, 'errors' );
+  $template->assign_block_vars('errors',array());
+  for ( $i = 0; $i < sizeof( $errors ); $i++ )
+  {
+    $template->assign_block_vars('errors.error',array('ERROR'=>$errors[$i]));
+  }
 }
 //------------------------------------------------------------------------ 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();
@@ -291 +296 @@
                   ,'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'];
@@ -302 +306 @@
   {
     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']] =
@@ -322 +313 @@
     $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
   //
@@ -333 +334 @@
   // $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
@@ -348 +348 @@
   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');
 ?>